Data Processing
The process consists of converting the disposal edit records with asset/item numbers listed in the Asset/Item Number Non-Contiguous subtask into record rows within a delimited ASCII file.
If the starting point for the list of records currently listed on the screen was the retrieval of record data from a batch, then the processing of the records on the screen will include the deletion of the batch and its associated records in the applications holding table. Further, the disposal edit records thus exported will be deleted from the application's batch table at that point.
Care should be used that the records associated with the export that were originally entered and can be viewed on the Manage Disposal Transactions screen are properly handled.
Prior to processing the export, all valid disposal edit records listed on the screen can be edited using the Modify/View Data for Export button found in the Asset Master and Disposal Data Records subtask. Certain fields, such as the Asset ID, Item No, and certain depreciation adjustment amount fields will be disabled.
Refer to the Asset Master and Disposal Data Records topic on details about this button and subtask. You can also refer to the Field Conditions topic to see which fields are enabled or disabled.
Field | Col # | Length | Source |
---|---|---|---|
Asset ID | 1 | (10)VARCHAR | ASSET.ASSET_ID |
Item No | 2 | (5)99999 | ASSET.ITEM_NO |
Disposal Price | 3 | (12.2)999999999999.99 | FA_DISP_EDIT.DISP_PRICE_AMT |
Gain/Loss Account ID | 5 | (15)VARCHAR | FA_DISP_EDIT.GNLS_ACCT_ID |
Gain/Loss Org ID | 6 | (20)VARCHAR | FA_DISP_EDIT.GNLS_ORG_ID |
Gain/Loss Project ID | 7 | (30)VARCHAR | FA_DISP_EDIT.GNLS_PROJ_ID |
Gain/Loss Ref 1 ID | 7 | (20)VARCHAR | FA_DISP_EDIT.GNLS_REF1_ID |
Gain/Loss Ref 2 ID | 7 | (20)VARCHAR | FA_DISP_EDIT.GNLS_REF2_ID |
Book 1 Depr Adj Amt | 8 | (12.2)999999999999.99 | FA_DISP_EDIT.B1_DEPR_ADJ_AMT |
Book 2 Depr Adj Amt | 9 | (12.2)999999999999.99 | FA_DISP_EDIT.B2_DEPR_ADJ_AMT |
Book 3 Depr Adj Amt | 10 | (12.2)999999999999.99 | FA_DISP_EDIT.B3_DEPR_ADJ_AMT |
Book 4 Depr Adj Amt | 11 | (12.2)999999999999.99 | FA_DISP_EDIT.B4_DEPR_ADJ_AMT |
Book 5 Depr Adj Amt | 12 | (12.2)999999999999.99 | FA_DISP_EDIT.B5_DEPR_ADJ_AMT |
Book 6 Depr Adj Amt | 13 | (12.2)999999999999.99 | FA_DISP_EDIT.B6_DEPR_ADJ_AMT |
Book 7 Depr Adj Amt | 14 | (12.2)999999999999.99 | FA_DISP_EDIT.B7_DEPR_ADJ_AMT |
Book 8 Depr Adj Amt | 15 | (12.2)999999999999.99 | FA_DISP_EDIT.B8_DEPR_ADJ_AMT |
Book 9 Depr Adj Amt | 16 | (12.2)999999999999.99 | FA_DISP_EDIT.B9_DEPR_ADJ_AMT |
Book 10 Depr Adj Amt | 17 | (12.2)999999999999.99 | FA_DISP_EDIT.B10_DEPR_ADJ_AMT |
Batch ID | 18 | (10)VARCHAR | SCREEN ENTRY/SAVE - BATCH_ID |
Books 1 through 10 will only show to the extent that they exist in FA_SETTINGS.TOT_BOOK_NO. Thus, if the Total Books showing in the Configure Fixed Assets Settings is 3, then books 1, 2 and 3 will be visible in the table.
Book 1 will always be enabled on the screen. Only the books that have been assigned to the asset record will have the Depr Adj Amt field enabled. When a book other than Book 1 has been assigned to an asset, the Depr Status on the Desc Info tab of the Manage Asset Master Information screen will be set to Depreciable and the book’s Depr Method Code will contain a value other than NULL in the Other Books Info subtask of the Manage Asset Master Information screen.