You are here: File Descriptions > Fixed Assets > FAMA

FAMAxxx - Fixed Assets Master File

The Fixed Assets Master file stores information about fixed assets: costs, dates, locations, credits, valuation, and four depreciation columns.

There is one record for each fixed asset.

  Template: DIM FAMA:"ASSET:C(9), ASTNO:C(4), SEQ:C(1*), DESCR:C(30*), MFG:C(30), MOD:C(30), SERN:C(30), TAG:C(20*), TAXD1:C(15), TAXD2:C(15), TAXD3:C(15*), LOC1:C(15), LOC2:C(15), LOC3:C(15*), STAT:C(1), OLFG:C(1), NLFG:C(1), PRFG:C(1), LSTP:C(1), INP:C(1*), PCC:C(6), TCLS:C(4), BUPCT:C(3*), GLACTA:C(12*), GLACTD:C(12*), GLACTX:C(12*), CRDES:C(30*), ACQCST:N(14*), ACQDAT:N(7*), RETDAT:N(7*), QTY:N(7*), IVAL:N(14*), IVDAT:N(7*), ASVAL:N(14*), ASDAT:N(7*), RCVAL:N(14*), RCDAT:N(7*), PSDAT:N(7*), UTAX:N(12*), NONDP:N(14*), ADJCT:N(14*), DLADJ:N(7*), TTLCR:N(12*), RSV1:N(1*), DMBK:C(6*), DMTAX:C(6*), DMOT:C(6*), DMAMT:C(6*), BUBK:C(1*), BUTAX:C(1*), BUOT:C(1*), BUAMT:C(1*), STBK:C(6*), STTAX:C(6*), STOT:C(6*), STAMT:C(6*), BKBY:C(4*), BKEY:C(4*), BKSV:N(14*), BKOBD:N(14*), BK179:N(14*), BKCST:N(14*), BKADT:N(14*), BKYTD:N(14*), BKCD:N(14*), BKADP:N(14*), BKEL:N(5*), BKDBP:N(2*), BKDEP:N(2*), BKRPD:N(4*), BKAPC:N(12*), BKAD:N(14*), BKRSV:N(1*), TXDBY:N(4*), TXDEY:N(4*), TXSLV:N(14*), TXBON:N(14*), TX179:N(14*), TXBC:N(14*), TXDEP:N(14*), TXYTD:N(14*), TXCUR:N(14*), TXADP:N(14*), TXEL:N(5*), TXDPB:N(2*), TXDPE:N(2*), TXRCP:N(4*), TXACR:N(12*), TXADE:N(14*), TXRSV:N(1*), OTBYR:N(4*), OTEYR:N(4*), OTSLV:N(14*), OTBDP:N(14*), OT179:N(14*), OTBASE:N(14*), OTDTK:N(14*), OTYTD:N(14*), OTCDP:N(14*), OTADP:N(14*), OTEL:N(14*), OTDBP:N(2*), OTDEP:N(2*), OTREC:N(4*), OTAPC:N(12*), OTADE:N(14*), OTRSV:N(1*), AMTBY:N(4*), AMTEY:N(4*), AMTSLV:N(14*), AMTBNS:N(14*), AMT179:N(14*), AMTBS:N(14*), AMTTKN:N(14*), AMTYTD:N(14*), AMTCD:N(14*), AMTAD:N(14*), AMTLIF:N(5*), AMTBP:N(2*), AMTEP:N(2*), AMTRP:N(4*), AMTCR:N(12*), AMTEL:N(14*), AMTRSV:N(1*), MEMO:C(20*), SPCAL:C(1*), ISVA:C(1*), ISVN[2]:N(1*)"
  IOLIST: 0999 FAMAXXX: IOLIST A0$, A1$, A2$, A3$, A4$, A5$, A6$, A7$[ALL], A8$, A0[ALL], A12$[ALL], A13$[ALL], A14$[ALL], A1[ALL], A[ALL], A1[ALL], A15$, A16$, A99$[ALL], A99[ALL]
  Array Sizes: DIM A7$[3], A0[16], A12$[3], A13$[3], A14$[3], A1[3,10], A1[3,16], A99$[0], A99[1]
  String Sizes: DIM A0$(14), A1$(30), A2$(110), A3$(45), A4$(45), A5$(6), A6$(13), A8$(30), A15$(20), A16$(1)

Key Definitions

  Key Number Field Description
  0 [1:1:9] + Asset ID +
  [1:10:4] + Asset Number +
  [1:14:1] Sequence Number
       
  1 [3:91:20] Asset Tag Number
       
  2 [8:1:12] + GL Asset Account +
  [1:1:9] + Asset ID +
  [1:10:4] + Asset Number +
  [1:14:1] Sequence Number
       
  3 [5:1:15] + Location 1 +
  [5:16:15] + Location 2 +
  [5:31:15] + Location 3 +
  [1:1:9] + Asset ID +
  [1:10:4] + Asset Number +
  [1:14:1] Sequence Number
       
  4 [8:1:12] + GL Asset Account +
  [22:1:7] + Date Placed in Service +
  [1:1:9] + Asset ID +
  [1:10:4] + Asset Number +
  [1:14:1] Sequence Number
       
  5 [7:7:4] + Tax Class (1250,1245,etc.) +
  [22:1:7] + Date Placed in Service +
  [1:1:9] + Asset ID +
  [1:10:4] + Asset Number +
  [1:14:1] Sequence Number
       
  6 [9:1:12] + GL Accumulated Depr Account +
  [10:1:12] + GL Depr Expense Account +
  [1:1:9] + Asset ID +
  [1:10:4] + Asset Number +
  [1:14:1] Sequence Number
       
  7 [6:5:1] + Listed Property +
  [7:11:3:"D"] + Business Use Percentage +
  [22:1:7] + Date Placed in Service +
  [1:1:9] + Asset ID +
  [1:10:4] + Asset Number +
  [1:14:1] Sequence Number
       
  8 [22:1:7:"D"] + Date Placed in Service +
  [1:1:9] + Asset ID +
  [1:10:4] + Asset Number +
  [1:14:1] Sequence Number
    __________  
    39 segments  

Fixed Assets Master File

  File Name: FAMAxxx Record Size: 1332(1408)
  File Type: Mkeyed - Dynamic Number of Keys: 9
         
  Field Field Name Variable Description A/N Length Note
  1(1,9) ASSET A0$(1,9) Asset ID A 9
  1(10,4) ASTNO A0$(10,4) Asset Number A 4 ####
  1(14,1) SEQ A0$(14,1) Sequence Number A 1
  2 DESCR A1$ Description A 30
  3(1,30) MFG A2$(1,30) Manufacturer A 30
  3(31,30) MOD A2$(31,30) Model Number A 30
  3(61,30) SERN A2$(61,30) Serial Number A 30
  3(91,20) TAG A2$(91,20) Asset Tag Number A 20
  4(1,15) TAXD1 A3$(1,15) Tax District 1 A 15
  4(16,15) TAXD2 A3$(16,15) Tax District 2 A 15
  4(31,15) TAXD3 A3$(31,15) Tax District 3 A 15
  5(1,15) LOC1 A4$(1,15) Location 1 A 15
  5(16,15) LOC2 A4$(16,15) Location 2 A 15
  5(31,15) LOC3 A4$(31,15) Location 3 A 15
  6(1,1) STAT A5$(1,1) Status A 1 1 = active
              2 = retired
              3 = new
              4 = suspended
  6(2,1) OLFG A5$(2,1) Owned/Leased Flag A 1
  6(3,1) NLFG A5$(3,1) New/Used Flag A 1 1 = new
              2 = used
  6(4,1) PRFG A5$(4,1) Personal/Real Flag A 1 1 = personal
              2 = real
  6(5,1) LSTP A5$(5,1) Listed Property A 1 Y or N
  6(6,1) INP A5$(6,1) Insurable Property A 1 1 = yes
              2 = no
  7(1,6) PCC A6$(1,6) Property Class Code A 6 user-defined
  7(7,4) TCLS A6$(11,3) Tax Class (1250,1245,etc.) A 4
  7(11,3) BUPCT A6$(11,3) Business Use Percentage A 3
  8 GLACTA A7$[1] GL Asset Account A 12
  9 GLACTD A7$[2] GL Accumulated Depr Account A 12
  10 GLACTX A7$[3] GL Depr Expense Account A 12
  11 CRDES A8$ Credits Description A 30
  12 ACQCST A0[0] Acquisition Cost N 14 DOLL
  13 ACQDAT A0[1] Acquisition Date N 7 Julian
  14 RETDAT A0[2] Retirement Date N 7 Julian
  15 QTY A0[3] Quantity N 7 6.0-
  16 IVAL A0[4] Insured Value N 14 DOLL
  17 IVDAT A0[5] Insured Value Date N 7 Julian
  18 ASVAL A0[6] Assessed Value N 14 DOLL
  19 ASDAT A0[7] Assessment Date N 7 Julian
  20 RCVAL A0[8] Replacement Cost Value N 14 DOLL
  21 RCDAT A0[9] Replacement Cost Date N 7 Julian
  22 PSDAT A0[10] Date Placed in Service N 7 Julian
  23 UTAX A0[11] Sales/Use Tax Paid N 12 8.2-
  24 NONDP A0[12] Accumulated Nondepreciable Cost N 14 DOLL
  25 ADJCT A0[13] Adjusted Cost N 14 DOLL
  26 DLADJ A0[14] Date of Last Adjustment N 7 Julian
  27 TTLCR A0[15] Total Credits N 12 9.2
  28 RSV1 A0[16] Reserved for OSD N 1
  29 DMBK A12$[0] Depreciation Method/Table--Book A 6
  30 DMTAX A12$[1] Depreciation Method/Table--Tax A 6
  31 DMOT A12$[2] Depreciation Method/Table--Other A 6
  32 DMAMT A12$[3] Depreciation Method/Table---A.M.T A 6
  33 BUBK A13$[0] Apply % Business Use--Book A 1 Y or N
  34 BUTAX A13$[1] Apply % Business Use--Tax A 1 Y or N
  35 BUOT A13$[2] Apply % Business Use--Other A 1 Y or N
  36 BUAMT A13$[3] Apply Pct Business Use--A.M.T. A 1 Y or N
  37 STBK A14$[0] Switch-to-Method--Book A 6
  38 STTAX A14$[1] Switch-to-Method--Tax A 6
  39 STOT A14$[2] Switch-to-Method--Other A 6
  40 STAMT A14$[3] Switch-to-Method--A.M.T A 6
  41 BKBY A1[0,0] Book--Depr Begin Year A 4
  42 BKEY A1[0,1] Book--Depr End Year A 4
  43 BKSV A1[0,2] Book--Salvage Value N 14 DOLL
  44 BKOBD A1[0,3] Book--Other Bonus Depr N 14 DOLL
  45 BK179 A1[0,4] Book--179 Expense N 14 DOLL
  46 BKCST A1[0,5] Book--Base Cost N 14 DOLL
  47 BKADT A1[0,6] Book--Accum Depr Taken N 14 DOLL
  48 BKYTD A1[0,7] Book--YTD Depreciation N 14 DOLL
  49 BKCD A1[0,8] Book--Current Depreciation N 14 DOLL
  50 BKADP A1[0,9] Book--Annual Depreciation N 14 DOLL
  51 BKEL A1[0,10] Book--Estimated Life N 5
  52 BKDBP A1[0,11] Book--Depr Begin Period N 2
  53 BKDEP A1[0,12] Book--Depr End Period N 2
  54 BKRPD A1[0,13] Book--Recovery Period N 4 2.1
  55 BKAPC A1[0,14] Book--Applied Credits N 12 9.2
  56 BKAD A1[0,15] Book--Accum Depr Elig N 14 DOLL
  57 BKRSV A1[0,16] Book--Reserved for OSD N 1
  58 TXDBY A1[1,0] Tax--Depr Begin Year N 4
  59 TXDEY A1[1,1] Tax--Depr End Year N 4
  60 TXSLV A1[1,2] Tax--Salvage Value N 14 DOLL
  61 TXBON A1[1,3] Tax--Other Bonus Depr N 14 DOLL
  62 TX179 A1[1,4] Tax--179 Expense N 14 DOLL
  63 TXBC A1[1,5] Tax--Base Cost N 14 DOLL
  64 TXDEP A1[1,6] Tax--Accum Depr Taken N 14 DOLL
  65 TXYTD A1[1,7] Tax--YTD Depreciation N 14 DOLL
  66 TXCUR A1[1,8] Tax--Current Depreciation N 14 DOLL
  67 TXADP A1[1,9] Tax--Annual Depreciation N 14 DOLL
  68 TXEL A1[1,10] Tax--Estimated Life N 5
  69 TXDPB A1[1,11] Tax--Depr Begin Period N 2
  70 TXDPE A1[1,12] Tax--Depreciation End Period N 2
  71 TXRCP A1[1,13] Tax--Recovery Period N 4 2.1
  72 TXACR A1[1,14] Tax--Applied Credits N 12 9.2
  73 TXADE A1[1,15] Tax--Accum Depr Elig N 14 DOLL
  74 TXRSV A1[1,16] Tax--Reserved for OSD N 1
  75 OTBYR A1[2,0] Other--Depr Begin Year N 4
  76 OTEYR A1[2,1] Other--Depr End Year N 4
  77 OTSLV A1[2,2] Other--Salvage Value N 14 DOLL
  78 OTBDP A1[2,2] Other--Other Bonus Depr N 14 DOLL
  79 OT179 A1[2,4] Other--179 Expense N 14 DOLL
  80 OTBASE A1[2,5] Other--Base Cost N 14 DOLL
  81 OTDTK A1[2,6] Other--Accum Depr Taken N 14 DOLL
  82 OTYTD A1[2,7] Other--YTD Depreciation N 14 DOLL
  83 OTCDP A1[2,8] Other--Current Depreciation N 14 DOLL
  84 OTADP A1[2,9] Other--Annual Depreciation N 14 DOLL
  85 OTEL A1[2,10] Other--Estimated Life N 14 DOLL
  86 OTDBP A1[2,11] Other--Depr Begin Period N 2
  87 OTDEP A1[2,12] Other--Depr End Period N 2
  88 OTREC A1[2,13] Other--Recovery Period N 4
  89 OTAPC A1[2,14] Other--Applied Credits N 12 9.2
  90 OTADE A1[2,15] Other--Accum Depr Elig N 14 DOLL
  91 OTRSV A1[2,15] Other--Reserved for OSD N 1
  92 AMTBY A1[3,0] AMT--Begin Year N 4
  93 AMTEY A1[3,1] AMT--Depr End Year N 4
  94 AMTSLV A1[3,2] AMT--Salvage Value N 14 DOLL
  95 AMTBNS A1[3,3] AMT--Other Bonus Depr N 14 DOLL
  96 AMT179 A1[3,4] AMT--179 Expense N 14 DOLL
  97 AMTBS A1[3,5] AMT--Base Cost N 14 DOLL
  98 AMTTKN A1[3,6] AMT--Accum Depr Tkn N 14 DOLL
  99 AMTYTD A1[3,7] AMT--YTD Depreciation N 14 DOLL
  100 AMTCD A1[3,8] AMT--Current Depreciation N 14 DOLL
  101 AMTAD A1[3,9] AMT--Annual Depr N 14 DOLL
  102 AMTLIF A1[3,10] AMT--Estimated Life N 5
  103 AMTBP A[3,11] AMT--Depr Begin Period N 2
  104 AMTEP A1[3,12] AMT--Depr End Period N 2
  105 AMTRP A1[3,13] AMT--Recovery Period N 4
  106 AMTCR A1[3,14] AMT--Applied Credits N 12 9.2
  107 AMTEL A1[3,15] AMT--Accum Depr Elig N 14 DOLL
  108 AMTRSV A1[3,16] AMT--Reserved for OSD N 1
  109 MEMO A15$ Memo Field A 20
  110 SPCAL A16$ JCWAA Asset Toggle A 1 Y or N
  111 ISVA A99$[0] Reserved for ISV A 1
  112 ISVN[1] A99[0] Reserved for ISV N 1
  113 ISVN[2] A99[1] Reserved for ISV N 1