Data Processing

The process consists of Fixed Assets asset master data records being accessed from the application’s tables and loaded into a delimited ASCII file.

The records thus exported will be deleted from the application’s tables at that point.

The asset master table displayed via the Modify/View Data for Export button in the Asset Master and Disposal Data Records subtask will be laid out as follows:

  • All field data retrieved via the Modify/View Data for Export button can be edited except Asset No and Item No.

Asset Master Table

Field Col # Length Source
Asset No 1 (10)VARCHAR ASSET.ASSET_ID
Item No 2 (5)99999 ASSET.ITEM_NO
Template No 3 (30)VARCHAR ASSET.FA_TMPLT_ID
Tmplt Rev No 4 (3)VARCHAR ASSET.FA_TMPLT_RVSN_ID
Asset Account 5 (15)VARCHAR ASSET.ASSET_ACCT_ID
Asset Organization 6 (20)VARCHAR ASSET.ASSET_ORG_ID
Asset Project 7 (30)VARCHAR ASSET.ASSET_PROJ_ID
Asset Ref1 ID 8 (20)VARCHAR ASSET.ASSET_REF1_ID
Asset Ref2 ID 9 (20)VARCHAR ASSET.ASSET_REF2_ID
Location Group 10 (8)VARCHAR ASSET.FA_LOC_GRP_CD
Location 1 Code 11 (8)VARCHAR ASSET.FA_LOC1_CD
Location 2 Code 12 (8)VARCHAR ASSET.FA_LOC2_CD
Location 3 Code 13 (8)VARCHAR ASSET.FA_LOC3_CD
Accum Depr Acct Code 14 (6)VARCHAR ASSET.ACCUM_DEPR_ACCT_CD
Depr Exp Alloc Code 15 (6)VARCHAR ASSET.DEPR_EXP_ALC_CD
G/L Book Depr Method Code 16 (6)VARCHAR ASSET.B1_DEPR_MTHD_CD
B2_Depr Method Code 17 (6)VARCHAR ASSET_OTH_BK_DEPR.B2_DEPR_MTHD_CD
B3_Depr Method Code 18 (6)VARCHAR ASSET_OTH_BK_DEPR.B3_DEPR_MTHD_CD
B4_Depr Method Code 19 (6)VARCHAR ASSET_OTH_BK_DEPR.B4_DEPR_MTHD_CD
B5_Depr Method Code 20 (6)VARCHAR ASSET_OTH_BK_DEPR.B5_DEPR_MTHD_CD
B6_Depr Method Code 21 (6)VARCHAR ASSET_OTH_BK_DEPR.B6_DEPR_MTHD_CD
B7_Depr Method Code 22 (6)VARCHAR ASSET_OTH_BK_DEPR.B7_DEPR_MTHD_CD
B8_Depr Method Code 23 (6)VARCHAR ASSET_OTH_BK_DEPR.B8_DEPR_MTHD_CD
B9_Depr Method Code 24 (6)VARCHAR ASSET_OTH_BK_DEPR.B9_DEPR_MTHD_CD
B10_Depr Method Code 25 (6)VARCHAR ASSET_OTH_BK_DEPR.B10_DEPR_MTHD_CD
G/L Book In Srvc Date 26 (8)DATE ASSET.B1_IN_SERVICE_DT
B2 In Srvc Date 27 (8)DATE ASSET_OTH_BK_DEPR.B2_IN_SERVICE_DT
B3 In Srvc Date 28 (8)DATE ASSET_OTH_BK_DEPR.B3_IN_SERVICE_DT
B4 In Srvc Date 29 (8)DATE ASSET_OTH_BK_DEPR.B4_IN_SERVICE_DT
B5 In Srvc Date 30 (8)DATE ASSET_OTH_BK_DEPR.B5_IN_SERVICE_DT
B6 In Srvc Date 31 (8)DATE ASSET_OTH_BK_DEPR.B6_IN_SERVICE_DT
B7 In Srvc Date 32 (8)DATE ASSET_OTH_BK_DEPR.B7_IN_SERVICE_DT
B8 In Srvc Date 33 (8)DATE ASSET_OTH_BK_DEPR.B8_IN_SERVICE_DT
B9 In Srvc Date 34 (8)DATE ASSET_OTH_BK_DEPR.B9_IN_SERVICE_DT
B10 In Srvc Date 35 (8)DATE ASSET_OTH_BK_DEPR.B10_IN_SERVICE_DT
Govt Field 1 36 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD1_DESC
Govt Field 2 37 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD2_DESC
Govt Field 3 38 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD3_DESC
Govt Field 4 39 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD4_DESC
Govt Field 5 40 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD5_DESC
Govt Field 6 41 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD6_DESC
Govt Field 7 42 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD7_DESC
Govt Field 8 43 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD8_DESC
Govt Field 9 44 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD9_DESC
Govt Field 10 45 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD10_DESC
Govt Field 11 46 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD11_DESC
Govt Field 12 47 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD12_DESC
Govt Field 13 48 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD13_DESC
Govt Field 14 49 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD14_DESC
Govt Field 15 50 (30)VARCHAR ASSET_OTHER_INFO.GOVT_FLD15_DESC
Notes 51 (254)VARCHAR ASSET_OTHER_INFO.NOTES

The disposal table display via the Modify/View Data for Export button in the Asset Master and Disposal Data Records subtask will be laid out as follows:

  • All records retrieved via the Modify/View Data for Export button can be edited except Asset ID and Item No.
Field Col # Length Source
Asset No 1 (10)VARCHAR ASSET.ASSET_ID
Item No 2 (5)99999 ASSET.ITEM_NO
Gain/Loss Account 3 (15)VARCHAR FA_SETTINGS.DFLT_GNLS_ACCT_ID
Gain/Loss Organization 4 (20)VARCHAR FA_SETTINGS.DFLT_GNLS_ORG_ID
Gain/Loss Project 5 (30)VARCHAR FA_SETTINGS.DFLT_GNLS_PROJ_ID
Disposal Price Amt 6 (14.2)999999999999.99 Default in '0'(zero)
G/L Book Depr Adj Amt 7 (14.2)999999999999.99 Default in '0'(zero)
Book 2 Depr Adj Amt 8 (14.2)999999999999.99 Default in '0'(zero)
Book 3 Depr Adj Amt 9 (14.2)999999999999.99 Default in '0'(zero)
Book 4 Depr Adj Amt 10 (14.2)999999999999.99 Default in '0'(zero)
Book 5 Depr Adj Amt 11 (14.2)999999999999.99 Default in '0'(zero)
Book 6 Depr Adj Amt 12 (14.2)999999999999.99 Default in '0'(zero)
Book 7 Depr Adj Amt 13 (14.2)999999999999.99 Default in '0'(zero)
Book 8 Depr Adj Amt 14 (14.2)999999999999.99 Default in '0'(zero)
Book 9 Depr Adj Amt 15 (14.2)999999999999.99 Default in '0'(zero)
Book 10 Depr Adj Amt 16 (14.2)999999999999.99 Default in '0'(zero)