Export File Layout

The export file name is user-determined as indicated on the File Name field on the Export File Details tab. The export file type is delimited ASCII file.

The file layout includes one header row per file, then one row for each disposal record.

Field Col # Length Source
HDR ROW-Input Row 1 (10)9999999999 Export Preprocessor
HDR ROW-Record Type 2 (1)VARCHAR Value = 'H', entered by Export Preprocessor
HDR ROW-Current Fiscal Year 3 (6)VARCHAR FA_SETTINGS.CUR_FY_CD
HDR ROW-Current Period Number 4 (2)99 FA_SETTINGS.CUR_PD_NO
HDR_ROW-Company ID 5 (10)VARCHAR FA_SETTINGS.COMPANY_ID
All of the following rows are related to the asset master rows, which will include one “Row” for each asset record.
Input Row 1 (10)9999999999 Export Preprocessor
Record Type 2 (1)VARCHAR Value =A, entered by Export Preprocessor
Asset ID 3 (10)VARCHAR ASSET.ASSET_ID
Item No 4 (5)99999 ASSET.ITEM_NO
FA Template ID 5 (30)VARCHAR ASSET.FA_TMPLT_ID
FA Template Rev No 6 (3)VARCHAR ASSET.FA_TMPLT_RVSN_ID
Short Desc 7 (30)VARCHAR ASSET.SHORT_DESC
Long Desc 8 (60)VARCHAR ASSET.LONG_DESC
Addt'l Desc 9 (254)VARCHAR ASSET.ADDTL_DESC_NOTES
Class Code 10 (6)VARCHAR ASSET.FA_CLASSIF_CD
Property Type 11 (6)VARCHAR ASSET.PRPTY_TYPE
Depr Status 12 (1)VARCHAR ASSET.S_DEPR_STATUS_CD
Record Status 13 (1)VARCHAR ASSET.S_STATUS_CD
Depr Based On 14 (1)VARCHAR ASSET.S_DEPR_BASED_ON_CD
Vendor 15 (12)VARCHAR ASSET.VEND_ID
Vendor Name 16 (25)VARCHAR ASSET.VEND_NAME
Manufacturer 17 (10)VARCHAR ASSET.MANUF_ID
Manufacturer Name 18 (30)VARCHAR ASSET.MANUF_NAME
Model No 19 (30)VARCHAR ASSET.MODEL_ID
Condition 20 (1)VARCHAR ASSET.S_CONDITION_CD
City 21 (25)VARCHAR ASSET.CITY_NAME
State/Province 22 (15)VARCHAR ASSET.MAIL_STATE_DC
Postal Code 23 (10)VARCHAR ASSET.POSTAL_CD
County 24 (25)VARCHAR ASSET.COUNTY_NAME
Country 25 (8)VARCHAR ASSET.COUNTRY_CD
Location Group 26 (8)VARCHAR ASSET.FA_LOC_GRP_CD
Location 1 Code 27 (8)VARCHAR ASSET.FA_LOC1_CD
Location 2 Code 28 (8)VARCHAR ASSET.FA_LOC2_CD
Location 3 Code 29 (8)VARCHAR ASSET.FA_LOC3_CD
Accumulated Depreciation Account Code 30 (6)VARCHAR ASSET.ACCUM_DEPR_ACCT_CD
Depr Expense Acct Alloc Code 31 (6)VARCHAR ASSET.DEPR_EXP_ALC_CD
Tag Number 32 (30)VARCHAR ASSET.TAG_NO_S
Acquisition Date 33 (8)DATE ASSET.ACQ_DT
Purchase Order Date 34 (8)DATE ASSET.PO_DT
Purchase Order No 35 (10)VARCHAR ASSET.PO_ID
Purchase Order Rel No 36 (3)999 ASSET.PO_RLSE_NO
Purchase Order Line No 37 (4)9999 ASSET.PO_LN_NO
Receipt Date 38 (8)DATE ASSET.RECPT_DT
Packing Slip 39 (15)VARCHAR ASSET.PS_ID
Invoice Date 40 (8)DATE ASSET.INVC_DT
Invoice No 41 (15)VARCHAR ASSET.INVC_ID
Voucher Date 42 (8)DATE ASSET.VCHR_DT
Voucher No 43 (9)999999999 ASSET.VCHR_NO
Serial No 44 (20)VARCHAR ASSET.SERIAL_ID
Acquisition Fiscal Year 45 (6)VARCHAR ASSET.ACQ_FY_CD
Acquisition Period 46 (2)99 ASSET.ACQ_PD_NO
Acquisition Subperiod 47 (2)99 ASSET.ACQ.SUB_PD_NO
Units Quantity No 48 (4)9999 ASSET.UNITS_QTY_NO
Unit of Measure 49 (10)VARCHAR ASSET.UM_S
Unit Amount 50 (14.2)999999999999.99 ASSET.PRICE_AMT
Sales Tax 51 (14.2)999999999999.99 ASSET.SALES_TAX_AMT
Shipping/Handling 52 (14.2)999999999999.99 ASSET.SHIP_AMT
Transportation 53 (14.2)999999999999.99 ASSET.TRANSP_AMT
Other Cost 54 (14.2)999999999999.99 ASSET.OTHER_CST_AMT
Amount Posted Curr Pd 55 (14.2)999999999999.99 ASSET.CUR_POSTED_AMT
Estimated Units Useful Life 56 (9)999999999 ASSET.UNITS_LIFE_NO
Unit of Measure Description 57 (10)VARCHAR ASSET.USAGE_UM_S
Std Depr Rt Per Unit of Usage 58 (14.4)999.9999 ASSET.UNIT_DEPR_RT_AMT
Prior Units Used 59 (14.4)999999999999.99 ASSET.PRIR_UNITS_USED_NO
Current Units Used 60 (14.4)999999999999.99 ASSET.CUR_UNITS_USED_NO
Capitalized Lease 61 (1)VARCHAR ASSET.CAPTLZD_LEASE_FL
Lease Start Date 62 (8)DATE ASSET.LEASE_START_DT
Lease End Date 63 (8)DATE ASSET.LEASE_END_DT
Total No Periods 64 (3)999 ASSET.TOT_LEASE_PMTS_NO
Monthly Lease Payment 65 (14.2)999999999999.99 ASSET.MTH_LEASE_PMT_AMT
Lease Pds Remaining 66 (3)999 ASSET.LEASE_PDS_REMN_NO
Disposal Date 67 (8)DATE ASSET.DISP_DT
Disposal Fiscal Year 68 (6)VARCHAR ASSET.DISP_FY_CD
Disposal Period 69 (2)99 ASSET.DISP_PD_NO
Disposal Subperiod 70 (2)99 ASSET.DISP_SUB_PD_NO
Disposal Price 71 (14.2)999999999999.99 ASSET.DISP_PRICE_AMT
Disposal Description 72 (30)VARCHAR ASSET.DISP_DESC
73 (3)VARCHAR ASSET.DISP_S_JNL_CD
Disposal Post Seq No 74 Numeric ASSET.DISP_POST_SEQ_NO
Disposal Entry Type (System or Manual) 75 (6)VARCHAR ASSET.S_DISPOSAL_CD
Depr Method Code 76 (6)VARCHAR ASSET.B1_DEPR_MTHD_CD
Useful Life 77 (4)9999 ASSET.B1_USEFUL_LIFE_NO
Auto Calculate Depreciation 78 (1)VARCHAR ASSET.B1_AUTO_CALC_FL
Salvage Percent 79 (7.6)999.9999 ASSET.B1_SLVGE_RT
Salvage Value 80 (14.2)999999999999.99 ASSET.B1_SLVGE_VAL_AMT
FYTD Depreciation 81 (14.2)999999999999.99 ASSET.B1_FYTD_DEPR_AMT
Prior FY Depreciation 82 (14.2)999999999999.99 ASSET.B1_PFY_DEPR_AMT
Current Pd Depreciation 83 (14.2)999999999999.99 ASSET.B1_CUR_DEPR_AMT
Annual Depreciation 84 (14.2)999999999999.99 ASSET.B1_ANNL_DEPR_AMT
Depr Start Date 85 (8)DATE ASSET.B1_DEPR_START_DT
In Service Date 86 (8)DATE ASSET.B1_IN_SERVICE_DT
Cur Depr Year 87 (2)99 ASSET.B1_CUR_DEPR_YR_NO
Days/Pds Remaining 88 (3)999 ASSET.B1_PDS_REMAIN_NO
Amt Taken Purchase YTD 89 (14.2)999999999999.99 ASSET.B1_DP_DEPR_YTD_AMT
Asset Account 90 (15)VARCHAR ASSET.ASSET_ACCT_ID
Asset Organization 91 (20)VARCHAR ASSET.ASSET_ORG_ID
Asset Project 92 (30)VARCHAR ASSET.ASSET_PROJ_ID
Asset Ref1 93 (20)VARCHAR ASSET.ASSET_REF1_ID
Asset Ref2 94 (20)VARCHAR ASSET.ASSET_REF2_ID
95 (14.2) 999999999999.99 ASSET.B1_DP_DEPR_NY_AMT
Post Sequence No 96 Numeric ASSET.POST_SEQ_NO
Disposal Posting Date 97 (8)DATE ASSET.DISP_POST_DT
Disposal Posting User 98 (20)VARCHAR ASSET.DISP_POST_USER_ID
Receipt 99 (10)VARCHAR ASSET.RECPT_ID
Voucher Line No 100 (5)99999 ASSET.VCHR_LN_NO
Non Depr Post Disposal to G/L 101 (1)VARCHAR ASSET.ND_POST_DISP_FL
Disposal Doc No 102 (20)VARCHAR ASSET.DISP_DOC_ID
Subclass Code 103 (6)VARCHAR ASSET.FA_SUBCLASS_CD
Employee 104 (12)VARCHAR ASSET.EMPL_ID
Disposal Type 105 (6)VARCHAR ASSET.FA_DISP_TYPE
UID 106 (78)VARCHAR ASSET.UID_CD
UID Type 107 (5)VARCHAR S_UID_TYPE
Issuing Agency Code 108 (3)VARCHAR UID_IAC_CD
Enterprise Identifier 109 (13)VARCHAR UID_EID_CD
Cage ID 110 (5)VARCHAR CAGE_ID_FLD
End of row (end of asset table data). Start new row in export file where data will come from asset_oth_bk_depr.
Input Row 1 (10)9999999999 Export Preprocessor
Record Type 2 (1)VARCHAR Value = B, entered by Export Preprocessor
Asset ID 3 (10)VARCHAR ASSET_OTH_BK_DEPR.ASSET_ID
Item Number 4 (5)99999 ASSET_OTH_BK_DEPR.ITEM_NO
Book 2_Depr Method Code 5 (6)VARCHAR ASSET_OTH_BK_DEPR.B2_DEPR_MTHD_CD
Book 2 Useful Life 6 (4)9999 ASSET_OTH_BK_DEPR.B2_USEFUL_LIFE_NO
Book 2 Auto Calc Depr 7 (1)VARCHAR ASSET_OTH_BK_DEPR.B2_AUTO_CALC_FL
Book 2 Salvage Percent 8 (7.6)999.9999 ASSET_OTH_BK_DEPR.B2_SLVGE_RT
Book 2 Salvage Value 9 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B2_SLVGE_VAL_AMT
Book 2 FYTD Depreciation 10 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B2_FYTD_DEPR_AMT
Book 2 Prior FY Depreciation 11 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B2_PFY_DEPR_AMT
Book 2 Amt To Depreciate 12 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B2_CUR_DEPR_AMT
Book 2 Annual Depreciation 13 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B2_ANNL_DEPR_AMT
Book 2 Total Cost 14 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B2_TOT_CST_AMT
Book 2 Depr Start Date 15 (8)DATE ASSET_OTH_BK_DEPR.B2_DEPR_START_DT
Book 2 In-Service Date 16 (8)DATE ASSET_OTH_BK_DEPR.B2_IN_SERVICE_DT
Book 2 Curr Depr Yr 17 (2)99 ASSET_OTH_BK_DEPR.B2_CUR_DEPR_YR_NO
Book 2 Days/Pds Remaining Number 18 (3)999 ASSET_OTH_BK_DEPR.B2_PDS_REMAIN_NO
Book 2 Amt Taken Purchase YTD 19 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B2_DP_DEPR_YTD_AMT
20 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B2_DP_DEPR_NY_AMT
Book 3_Depr Method Code 21 (6)VARCHAR ASSET_OTH_BK_DEPR.B3_DEPR_MTHD_CD
Book 3 Useful Life 22 (4)9999 ASSET_OTH_BK_DEPR.B3_USEFUL_LIFE_NO
Book 3 Auto Calc Depr 23 (1)VARCHAR ASSET_OTH_BK_DEPR.B3_AUTO_CALC_FL
Book 3 Salvage Percent 24 (7.6)999.9999 ASSET_OTH_BK_DEPR.B3_SLVGE_RT
Book 3 Salvage Value 25 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B3_SLVGE_VAL_AMT
Book 3 FYTD Depreciation 26 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B3_FYTD_DEPR_AMT
Book 3 Prior FY Depreciation 27 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B3_PFY_DEPR_AMT
Book 3 Current Pd Depreciation 28 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B3_CUR_DEPR_AMT
Book 3 Annual Depreciation 29 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B3_ANNL_DEPR_AMT
Book 3 Total Cost 30 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B3_TOT_CST_AMT
Book 3 Depr Start Date 31 (8)DATE ASSET_OTH_BK_DEPR.B3_DEPR_START_DT
Book 3 In-Service Date 32 (8)DATE ASSET_OTH_BK_DEPR.B3_IN_SERVICE_DT
Book 3 Curr Depr Yr 33 (2)99 ASSET_OTH_BK_DEPR.B3_CUR_DEPR_YR_NO
Book 3 Days/Pds Remaining 34 (3)999 ASSET_OTH_BK_DEPR.B3_PDS_REMAIN_NO
Book 3 Amt Taken Purchase YTD 35 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B3_DP_DEPR_YTD_AMT
36 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B3_DP_DEPR_NY_AMT
Book 4_Depr Method Code 37 (6)VARCHAR ASSET_OTH_BK_DEPR.B4_DEPR_MTHD_CD
Book 4 Useful Life 38 (4)9999 ASSET_OTH_BK_DEPR.B4_USEFUL_LIFE_NO
Book 4 Auto Calc Depr 39 (1)VARCHAR ASSET_OTH_BK_DEPR.B4_AUTO_CALC_FL
Book 4 Salvage Percent 40 (7.6)999.9999 ASSET_OTH_BK_DEPR.B4_SLVGE_RT
Book 4 Salvage Value 41 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B4_SLVGE_VAL_AMT
Book 4 FYTD Depreciation 42 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B4_FYTD_DEPR_AMT
Book 4 Prior FY Depreciation 43 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B4_PFY_DEPR_AMT
Book 4 Curr Pd Depreciation 44 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B4_CUR_DEPR_AMT
Book 4 Annual Depreciation 45 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B4_ANNL_DEPR_AMT
Book 4 Total Cost 46 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B4_TOT_CST_AMT
Book 4 Depr Start Date 47 (8)DATE ASSET_OTH_BK_DEPR.B4_DEPR_START_DT
Book 4 In-Service Date 48 (8)DATE ASSET_OTH_BK_DEPR.B4_IN_SERVICE_DT
Book 4 Curr Depr Yr 49 (2)99 ASSET_OTH_BK_DEPR.B4_CUR_DEPR_YR_NO
Book 4 Days/Pds Remaining 50 (3)999 ASSET_OTH_BK_DEPR.B4_PDS_REMAIN_NO
Book 4 Amt Taken Purchase YTD 51 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B4_DP_DEPR_YTD_AMT
52 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B4_DP_DEPR_NY_AMT
Book 5_Depr Method Code 53 (6)VARCHAR ASSET_OTH_BK_DEPR.B5_DEPR_MTHD_CD
Book 5 Useful Life 54 (4)9999 ASSET_OTH_BK_DEPR.B5_USEFUL_LIFE_NO
Book 5 Auto Calc Depr 55 (1)VARCHAR ASSET_OTH_BK_DEPR.B5_AUTO_CALC_FL
Book 5 Salvage Percent 56 (7.6)999.9999 ASSET_OTH_BK_DEPR.B5_SLVGE_RT
Book 5 Salvage Value 57 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B5_SLVGE_VAL_AMT
Book 5 FYTD Depreciation 58 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B5_FYTD_DEPR_AMT
Book 5 Prior FY Depreciation 59 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B5_PFY_DEPR_AMT
Book 5 Current Pd Depreciation 60 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B5_CUR_DEPR_AMT
Book 5 Annual Depreciation 61 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B5_ANNL_DEPR_AMT
Book 5 Total Cost 62 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B5_TOT_CST_AMT
Book 5 Depr Start Date 63 (8)DATE ASSET_OTH_BK_DEPR.B5_DEPR_START_DT
Book 5 In-Service Date 64 (8)DATE ASSET_OTH_BK_DEPR.B5_IN_SERVICE_DT
Book 5 Curr Depr Yr 65 (2)99 ASSET_OTH_BK_DEPR.B5_CUR_DEPR_YR_NO
Book 5 Days/Pds Remaining 66 (3)999 ASSET_OTH_BK_DEPR.B5_PDS_REMAIN_NO
Book 5 Amt Taken Purchase YTD 67 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B5_DP_DEPR_YTD_AMT
68 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B5_DP_DEPR_NY_AMT
Book 6_Depr Method Code 69 (6)VARCHAR ASSET_OTH_BK_DEPR.B6_DEPR_MTHD_CD
Book 6 Useful Life 70 (4)9999 ASSET_OTH_BK_DEPR.B6_USEFUL_LIFE_NO
Book 6 Auto Calc Rate 71 (1)VARCHAR ASSET_OTH_BK_DEPR.B6_AUTO_CALC_FL
Book 6 Salvage Percent 72 (7.6)999.9999 ASSET_OTH_BK_DEPR.B6_SLVGE_RT
Book 6 Salvage Value 73 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B6_SLVGE_VAL_AMT
Book 6 FYTD Depreciation 74 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B6_FYTD_DEPR_AMT
Book 6 Prior FY Depreciation 75 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B6_PFY_DEPR_AMT
Book 6 Current Pd Depreciation 76 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B6_CUR_DEPR_AMT
Book 6 Annual Depreciation 77 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B6_ANNL_DEPR_AMT
Book 6 Total Cost 78 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B6_TOT_CST_AMT
Book 6 Depr Start Date 79 (8)DATE ASSET_OTH_BK_DEPR.B6_DEPR_START_DT
Book 6 In-Service Date 80 (8)DATE ASSET_OTH_BK_DEPR.B6_IN_SERVICE_DT
Book 6 Curr Depr Yr 81 (2)99 ASSET_OTH_BK_DEPR.B6_CUR_DEPR_YR_NO
Book 6 Days/Pds Remaining 82 (3)999 ASSET_OTH_BK_DEPR.B6_PDS_REMAIN_NO
Book 6 Amt Taken Purchase YTD 83 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B6_DP_DEPR_YTD_AMT
84 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B6_DP_DEPR_NY_AMT
Book 7_Depr Method Code 85 (6)VARCHAR ASSET_OTH_BK_DEPR.B7_DEPR_MTHD_CD
Book 7 Useful Life 86 (4)9999 ASSET_OTH_BK_DEPR.B7_USEFUL_LIFE_NO
Book 7 Auto Calc Depr 87 (1)VARCHAR ASSET_OTH_BK_DEPR.B7_AUTO_CALC_FL
Book 7 Salvage Percent 88 (7.6)999.9999 ASSET_OTH_BK_DEPR.B7_SLVGE_RT
Book 7 Salvage Value 89 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B7_SLVGE_VAL_AMT
Book 7 FYTD Depreciation 90 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B7_FYTD_DEPR_AMT
Book 7 Prior FY Depreciation 91 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B7_PFY_DEPR_AMT
Book 7 Current Pd Depreciation 92 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B7_CUR_DEPR_AMT
Book 7 Annual Depreciation 93 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B7_ANNL_DEPR_AMT
Book 7 Total Cost 94 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B7_TOT_CST_AMT
Book 7 Depr Start Date 95 (8)DATE ASSET_OTH_BK_DEPR.B7_DEPR_START_DT
Book 7 In-Service Date 96 (8)DATE ASSET_OTH_BK_DEPR.B7_IN_SERVICE_DT
Book7 Curr Depr Yr 97 (2)99 ASSET_OTH_BK_DEPR.B7_CUR_DEPR_YR_NO
Book 7 Days/Pds Remaining 98 (3)999 ASSET_OTH_BK_DEPR.B7_PDS_REMAIN_NO
Book 7 Amt Taken Purchase YTD 99 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B7_DP_DEPR_YTD_AMT
100 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B7_DP_DEPR_NY_AMT
Book 8_Depr Method Code 101 (6)VARCHAR ASSET_OTH_BK_DEPR.B8_DEPR_MTHD_CD
Book 8 Useful Life 102 (4)9999 ASSET_OTH_BK_DEPR.B8_USEFUL_LIFE_NO
Book 8 Auto Calc Depr 103 (1)VARCHAR ASSET_OTH_BK_DEPR.B8_AUTO_CALC_FL
Book 8 Salvage Percent 104 (7.6)999.9999 ASSET_OTH_BK_DEPR.B8_SLVGE_RT
Book 8 Salvage Value 105 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B8_SLVGE_VAL_AMT
Book 8 FYTD Depreciation 106 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B8_FYTD_DEPR_AMT
Book 8 Prior FY Depreciation 107 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B8_PFY_DEPR_AMT
Book 8 Current Pd Depreciation 108 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B8_CUR_DEPR_AMT
Book 8 Annual Depreciation 109 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B8_ANNL_DEPR_AMT
Book 8 Total Cost 110 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B8_TOT_CST_AMT
Book 8 Depr Start Date 111 (8)DATE ASSET_OTH_BK_DEPR.B8_DEPR_START_DT
Book 8 In-Service Date 112 (8)DATE ASSET_OTH_BK_DEPR.B8_IN_SERVICE_DT
Book 8 Curr Depr Yr 113 (2)99 ASSET_OTH_BK_DEPR.B8_CUR_DEPR_YR_NO
Book 8 Days/Pds Remaining 114 (3)999 ASSET_OTH_BK_DEPR.B8_PDS_REMAIN_NO
Book 8 Amt Taken Purchase YTD 115 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B8_DP_DEPR_YTD_AMT
116 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B8_DP_DEPR_NY_AMT
Book 9_Depr Method Code 117 (6)VARCHAR ASSET_OTH_BK_DEPR.B9_DEPR_MTHD_CD
Book 9 Useful Life 118 (4)9999 ASSET_OTH_BK_DEPR.B9_USEFUL_LIFE_NO
Book 9 Auto Calc Depr 119 (1)VARCHAR ASSET_OTH_BK_DEPR.B9_AUTO_CALC_FL
Book 9 Salvage Percent 120 (7.6)999.9999 ASSET_OTH_BK_DEPR.B9_SLVGE_RT
Book 9 Salvage Value 121 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B9_SLVGE_VAL_AMT
Book 9 FYTD Depreciation 122 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B9_FYTD_DEPR_AMT
Book 9 Prior FY Depreciation 123 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B9_PFY_DEPR_AMT
Book 9 Current Pd Depreciation 124 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B9_CUR_DEPR_AMT
Book 9 Annual Depreciation 125 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B9_ANNL_DEPR_AMT
Book 9 Total Cost 126 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B9_TOT_CST_AMT
Book 9 Depr Start Date 127 (8)DATE ASSET_OTH_BK_DEPR.B9_DEPR_START_DT
Book 9 In-Service Date 128 (8)DATE ASSET_OTH_BK_DEPR.B9_IN_SERVICE_DT
Book 9 Curr Depr Yr 129 (2)99 ASSET_OTH_BK_DEPR.B9_CUR_DEPR_YR_NO
Book 9 Days/Pds Remaining 130 (3)999 ASSET_OTH_BK_DEPR.B9_PDS_REMAIN_NO
Book 9 Amt Taken Purchase YTD 131 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B9_DP_DEPR_YTD_AMT
132 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B9_DP_DEPR_NY_AMT
Book 10_Depr Method Code 133 (6)VARCHAR ASSET_OTH_BK_DEPR.B10_DEPR_MTHD_CD
Book 10 Useful Life 134 (4)9999 ASSET_OTH_BK_DEPR.B10_USEFUL_LIFE_NO
Book 10 Auto Calc Depr 135 (1)VARCHAR ASSET_OTH_BK_DEPR.B10_AUTO_CALC_FL
Book 10 Salvage Percent 136 (7.6)999.9999 ASSET_OTH_BK_DEPR.B10_SLVGE_RT
Book 10 Salvage Value 137 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B10_SLVGE_VAL_AMT
Book 10 FYTD Depreciation 138 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B10_FYTD_DEPR_AMT
Book 10 Prior FY Depreciation 139 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B10_PFY_DEPR_AMT
Book 10 Current Pd Depreciation 140 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B10_CUR_DEPR_AMT
Book 10 Annual Depreciation 141 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B10_ANNL_DEPR_AMT
Book 10 Total Cost 142 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B10_TOT_CST_AMT
Book 10 Depr Start Date 143 (8)DATE ASSET_OTH_BK_DEPR.B10_DEPR_START_DT
Book 10 In-Service Date 144 (8)DATE ASSET_OTH_BK_DEPR.B10_IN_SERVICE_DT
Book 10 Curr Depr Yr 145 (2)99 ASSET_OTH_BK_DEPR.B10_CUR_DEPR_YR_NO
Book 10 Days/Pds Remaining 146 (3)999 ASSET_OTH_BK_DEPR.B10_PDS_REMAIN_NO
Book 10 Amt Taken Purchase YTD 147 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B10_DP_DEPR_YTD_AMT
148 (14.2)999999999999.99 ASSET_OTH_BK_DEPR.B10_DP_DEPR_NY_AMT
End of row (end of ASSET_OTH_BK_DEPR table data). Start new row in export file where data will come from ASSET_OTHER_INFO and ASSET_BOOKS_DISP
Input Row 1 (10)9999999999 Export Preprocessor
Record Type 2 (1)VARCHAR Value =O, entered by Export Preprocessor
Asset ID 3 (10)VARCHAR ASSET_OTHER_INFO.ASSET_ID
Item Number 4 (5)99999 ASSET_OTHER_INFO.ITEM_NO
Notes 5 (254)VARCHAR ASSET_OTHER_INFO.NOTES
Year Built 6 (4)9999 ASSET_OTHER_INFO.YR_BUILT_NO
Nat Stock No 7 (20)VARCHAR ASSET_OTHER_INFO.MSN_ID
Govt Field 1 8 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD1_DESC
Govt Field 2 9 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD2_DESC
Govt Field 3 10 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD3_DESC
Govt Field 4 11 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD4_DESC
Govt Field 5 12 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD5_DESC
Govt Field 6 13 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD6_DESC
Govt Field 7 14 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD7_DESC
Govt Field 8 15 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD8_DESC
Govt Field 9 16 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD9_DESC
Govt Field 10 17 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD10_DESC
Govt Field 11 18 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD11_DESC
Govt Field 12 19 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD12_DESC
Govt Field 13 20 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD13_DESC
Govt Field 14 21 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD14_DESC
Govt Field 15 22 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD15_DESC
G/L Book Depr Adj 23 (14.2)999999999999.99 ASSET_BOOKS_DISP.B1_DEPR_ADJ_AMT
Book 2 Depr Adj 24 (14.2)999999999999.99 ASSET_BOOKS_DISP.B2_DEPR_ADJ_AMT
Book 3 Depr Adj 25 (14.2)999999999999.99 ASSET_BOOKS_DISP.B3_DEPR_ADJ_AMT
Book 4 Depr Adj 26 (14.2)999999999999.99 ASSET_BOOKS_DISP.B4_DEPR_ADJ_AMT
Book 5 Depr Adj 27 (14.2)999999999999.99 ASSET_BOOKS_DISP.B5_DEPR_ADJ_AMT
Book 6 Depr Adj 28 (14.2)999999999999.99 ASSET_BOOKS_DISP.B6_DEPR_ADJ_AMT
Book 7 Depr Adj 29 (14.2)999999999999.99 ASSET_BOOKS_DISP.B7_DEPR_ADJ_AMT
Book 8 Depr Adj 30 (14.2)999999999999.99 ASSET_BOOKS_DISP.B8_DEPR_ADJ_AM
Book 9 Depr Adj 31 (14.2)999999999999.99 ASSET_BOOKS_DISP.B9_DEPR_ADJ_AMT
Book 10 Depr Adj 32 (14.2)999999999999.99 ASSET_BOOKS_DISP.B10_DEPR_ADJ_AMT
End of row (end of ASSET_OTHER_INFO table data). Start new row in export file where data will come from User Defined tables.
Input Row 1 (10)9999999999 Export Preprocessor
Record Type 2 (1)VARCHAR Value = U, entered by Export Preprocessor
Asset ID 3 (10)VARCHAR GENL_UDEF.GENL_ID
Item Number 4 (5)99999 GENL_UDEF.GENL1_ID
Text Value 5 (30)VARCHAR GENL_UDEF.UDEF_TXT
Validated Text Value 6 (20)VARCHAR GENL_UDEF.UDEF_ID
Date Value 7 (8)DATE GENL_UDEF.IDEF_DT
Numeric Value 8 (14.2)999999999999.99  GENL_UDEF.UDEF_AMT
Label 9 (20)VARCHAR UDEF_LBL.UDEF_LBL