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) |
Parent Topic: Processing Details