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.