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 |