Export File Layout

The export file name is user-determined as indicated in the File Name field on the Export Asset Disposals screen. 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 rows after the first row are related to the disposal edit records, and there will be one “Row” for each disposal edit record.
Input Row 1 (10)9999999999 Export Preprocessor
Record Type 2 (1)VARCHAR Value = D, entered by Export Preprocessor
Asset ID 3 (10)VARCHAR ASSET.ASSET_ID
Item No 4 (5)99999 ASSET.ITEM_NO
Disposal Price Amount 5 (12.2)999999999999.99 DISP_PRICE_AMT from application table/zero default
Disposal Description 6 (30)VARCHAR FA_DISP_EDIT.DISP_DESC
Disposal Date 7 SMALLDAT FA_DISP_EDIT.DISP_DATE
Gain/Loss Account ID 8 (15)VARCHAR Application table.GNLS_ACCT_ID
Gain/Loss Org ID 9 (20)VARCHAR Application table.GNLS_ORG_ID
Gain/Loss Proj ID 10 (30)VARCHAR Application table.GNLS_PROJ_ID
Gain/Loss Ref 1 ID 11 (20)VARCHAR Application table.GNLS_REF1_ID
Gain/Loss Ref 2 ID 12 (20)VARCHAR Application table.GNLS_REF2_ID
Disposal Status Code 13 (1)VARCHAR FA_DISP_EDIT.S_DISP_STATUS_CD
Book 1 Depreciation Adjustment 14 (12.2)999999999999.99 Application table.B1_DEPR_ADJ_AMT
Book 2 Depreciation Adjustment 15 (12.2)999999999999.99 Application table.B2_DEPR_ADJ_AMT
Book 3 Depreciation Adjustment 16 (12.2)999999999999.99 Application table.B3_DEPR_ADJ_AMT
Book 4 Depreciation Adjustment 17 (12.2)999999999999.99 Application table.B4_DEPR_ADJ_AMT
Book 5 Depreciation Adjustment 18 (12.2)999999999999.99 Application table.B5_DEPR_ADJ_AMT
Book 6 Depreciation Adjustment 19 (12.2)999999999999.99 Application table.B6_DEPR_ADJ_AMT
Book 7 Depreciation Adjustment 20 (12.2)999999999999.99 Application table.B7_DEPR_ADJ_AMT
Book 8 Depreciation Adjustment 21 (12.2)999999999999.99 Application table.B8_DEPR_ADJ_AMT
Book 9 Depreciation Adjustment 22 (12.2)999999999999.99 Application table.B9_DEPR_ADJ_AMT
Book 10 Depreciation Adjustment 23 (12.2)999999999999.99 Application table.B10_DEPR_ADJ_AMT
Disposal Document ID 24 (20)VARCHAR FA_DISP_EDIT.DISP_DOC_ID
Disposal Type 25 (6)VARCHAR FA_DISP_EDIT.DISP_TYPE
Modified By 26 (20)VARCHAR FA_DISP_EDIT.MODIFIED_BY
Time Stamp 27 FA_DISP_EDIT.TIME_STAMP
Row Version 28 (10)Integer Assigned = 500