Records can also be imported into Costpoint Fixed Assets via the Import Asset Records application by scripting the records into the application's tables that were established for the Import Asset Records functionality within Costpoint:
FA_IMP_ASSET
FA_IMP_ASSETB
FA_IMP_ASSETO
FA_IMP_ASSETU
The layout of the fields in the FA_IMP_ASSETx are as follows:
|
Field Name |
Costpoint Column Name |
Field Type |
Costpoint Table Name |
|
INPUT_ROW_NO |
INT |
FA_IMP_ASSET |
|
|
PROC_STATUS |
VARCHAR (1) |
FA_IMP_ASSET |
|
|
AUTO_NO_GRP |
INT |
FA_IMP_ASSET |
|
|
Asset ID |
ASSET_ID |
VARCHAR (10) |
FA_IMP_ASSET |
|
Item No |
ITEM_NO |
INT |
FA_IMP_ASSET |
|
Current Fiscal Year |
IMP_FY_CD |
VARCHAR (6) |
FA_IMP_ASSET |
|
Current Period |
IMP_PD_NO |
INT |
FA_IMP_ASSET |
|
Company ID |
IMP_COMPANY_ID |
VARCHAR (10) |
FA_IMP_ASSET |
|
Template No |
FA_TMPLT_ID |
VARCHAR (30) |
FA_IMP_ASSET |
|
Template Rev No |
FA_TMPLT_RVSN_ID |
VARCHAR (3) |
FA_IMP_ASSET |
|
Short Desc |
SHORT_DESC |
VARCHAR (30) |
FA_IMP_ASSET |
|
Long Desc |
LONG_DESC |
VARCHAR (60) |
FA_IMP_ASSET |
|
Add'l Desc |
ADDTL_DESC_NOTES |
VARCHAR (254) |
FA_IMP_ASSET |
|
Classification Code |
FA_CLASSIF_CD |
VARCHAR (6) |
FA_IMP_ASSET |
|
Property Type |
PRPTY_TYPE |
VARCHAR (6) |
FA_IMP_ASSET |
|
Depr Status |
S_DEPR_STATUS_CD |
VARCHAR (1) |
FA_IMP_ASSET |
|
Record Status |
S_STATUS_CD |
VARCHAR (1) |
FA_IMP_ASSET |
|
Depr Based on |
S_DEPR_BASED_ON_CD |
VARCHAR (1) |
FA_IMP_ASSET |
|
Vendor |
VEND_ID |
VARCHAR (12) |
FA_IMP_ASSET |
|
Vendor Name |
VEND_NAME |
VARCHAR (25) |
FA_IMP_ASSET |
|
Manufacturer ID |
MANUF_ID |
VARCHAR (10) |
FA_IMP_ASSET |
|
Manufacturer Name |
MANUF_NAME |
VARCHAR (30) |
FA_IMP_ASSET |
|
Model No |
MODEL_ID |
VARCHAR (30) |
FA_IMP_ASSET |
|
Condition |
S_CONDITION_CD |
VARCHAR (1) |
FA_IMP_ASSET |
|
City |
CITY_NAME |
VARCHAR (25) |
FA_IMP_ASSET |
|
State/Province |
MAIL_STATE_DC |
VARCHAR (15) |
FA_IMP_ASSET |
|
Postal Code |
POSTAL_CD |
VARCHAR (10) |
FA_IMP_ASSET |
|
County |
COUNTY_NAME |
VARCHAR (25) |
FA_IMP_ASSET |
|
Country |
COUNTRY_CD |
VARCHAR (8) |
FA_IMP_ASSET |
|
Location Group |
FA_LOC_GRP_CD |
VARCHAR (10) |
FA_IMP_ASSET |
|
Location 1 Code |
FA_LOC1_CD |
VARCHAR (8) |
FA_IMP_ASSET |
|
Location 2 Code |
FA_LOC2_CD |
VARCHAR (8) |
FA_IMP_ASSET |
|
Location 3 Code |
FA_LOC3_CD |
VARCHAR (8) |
FA_IMP_ASSET |
|
Accumulated Depreciation Account Code |
ACCUM_DEPR_ACCT_CD |
VARCHAR (6) |
FA_IMP_ASSET |
|
Depr Expense Acct Alloc Code |
DEPR_EXP_ALC_CD |
VARCHAR (6) |
FA_IMP_ASSET |
|
Tag Number |
TAG_NO_S |
VARCHAR (30) |
FA_IMP_ASSET |
|
Acquisition Date |
ACQ_DT |
DATETIME |
FA_IMP_ASSET |
|
Purchase Order Date |
PO_DT |
DATETIME |
FA_IMP_ASSET |
|
Purchase Order No |
PO_ID |
VARCHAR (10) |
FA_IMP_ASSET |
|
Purchase Order Rel No |
PO_RLSE_NO |
SMALLINT |
FA_IMP_ASSET |
|
Purchase Order Line No |
PO_LN_NO |
INT |
FA_IMP_ASSET |
|
Receipt Date |
RECPT_DT |
DATETIME |
FA_IMP_ASSET |
|
Packing Slip |
PS_ID |
VARCHAR (15) |
FA_IMP_ASSET |
|
Invoice Date |
INVC_DT |
DATETIME |
FA_IMP_ASSET |
|
Invoice No |
INVC_ID |
VARCHAR (15) |
FA_IMP_ASSET |
|
Voucher Date |
VCHR_DT |
DATETIME |
FA_IMP_ASSET |
|
Voucher No |
VCHR_NO |
INT |
FA_IMP_ASSET |
|
Serial No |
SERIAL_ID |
VARCHAR (20) |
FA_IMP_ASSET |
|
Acquisition Fiscal Year |
ACQ_FY_CD |
VARCHAR (6) |
FA_IMP_ASSET |
|
Acquisition Period |
ACQ_PD_NO |
SMALLINT |
FA_IMP_ASSET |
|
Acquisition Subperiod |
ACQ_SUB_PD_NO |
SMALLINT |
FA_IMP_ASSET |
|
Units Quantity No |
UNITS_QTY_NO |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Unit of Measure |
UM_S |
VARCHAR (10) |
FA_IMP_ASSET |
|
Unit Price |
PRICE_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Sales Tax |
SALES_TAX_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Shipping/Handling |
SHIP_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Transportation |
TRANSP_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Other Cost |
OTHER_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Amount Posted Curr Pd |
CUR_POSTED_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Estimated Units Useful Life |
UNITS_LIFE_NO |
INT |
FA_IMP_ASSET |
|
Unit of Measure Description |
USAGE_UM_S |
VARCHAR (10) |
FA_IMP_ASSET |
|
Std Depr Rt Per Unit of Usage |
UNIT_DEPR_RT_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Prior Units Used |
PRIR_UNITS_USED_NO |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Current Units Used |
CUR_UNITS_USED_NO |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Capitalized Lease |
CAPTLZD_LEASE_FL |
VARCHAR (1) |
FA_IMP_ASSET |
|
Lease Start Date |
LEASE_START_DT |
DATETIME |
FA_IMP_ASSET |
|
Lease End Date |
LEASE_END_DT |
DATETIME |
FA_IMP_ASSET |
|
Total No Periods |
TOT_LEASE_PMTS_NO |
SMALLINT |
FA_IMP_ASSET |
|
Monthly Lease Payment |
MTH_LEASE_PMT_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Lease Pds Remaining |
LEASE_PDS_REMN_NO |
SMALLINT |
FA_IMP_ASSET |
|
Disposal Date |
DISP_DT |
DATETIME |
FA_IMP_ASSET |
|
Disposal Fiscal Year |
DISP_FY_CD |
VARCHAR (6) |
FA_IMP_ASSET |
|
Disposal Period |
DISP_PD_NO |
SMALLINT |
FA_IMP_ASSET |
|
Disposal Subperiod |
DISP_SUB_PD_NO |
SMALLINT |
FA_IMP_ASSET |
|
Disposal Price |
DISP_PRICE_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Disposal Description |
DISP_DESC |
VARCHAR (30) |
FA_IMP_ASSET |
|
|
DISP_S_JNL_CD |
VARCHAR (3) |
FA_IMP_ASSET |
|
Disposal Post Seq No |
DISP_POST_SEQ_NO |
INT |
FA_IMP_ASSET |
|
Disposal Entry Type (System or Manual) |
S_DISPOSAL_CD |
VARCHAR (6) |
FA_IMP_ASSET |
|
Modified By |
MODIFIED_BY |
VARCHAR (20) |
FA_IMP_ASSET |
|
Timestamp Date/Time |
TIME_STAMP |
DATETIME |
FA_IMP_ASSET |
|
Depr Method Code |
B1_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSET |
|
Useful Life |
B1_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSET |
|
Auto Calculate Depreciation |
B1_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSET |
|
Salvage Percent |
B1_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSET |
|
Salvage Value |
B1_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
FYTD Depreciation |
B1_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Prior FY Depreciation |
B1_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Current Pd Depreciation |
B1_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Annual Depreciation |
B1_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Depr Start Date |
B1_DEPR_START_DT |
DATETIME |
FA_IMP_ASSET |
|
In-Service Date |
B1_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSET |
|
Curr Depr Yr |
B1_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSET |
|
Days/Pds Remaining |
B1_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSET |
|
Amt Taken Purch YTD |
B1_DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Asset Account |
ASSET_ACCT_ID |
VARCHAR (15) |
FA_IMP_ASSET |
|
Asset Organization |
ASSET_ORG_ID |
VARCHAR (20) |
FA_IMP_ASSET |
|
Asset Project |
ASSET_PROJ_ID |
VARCHAR (30) |
FA_IMP_ASSET |
|
Asset Ref 1 |
ASSET_REF1_ID |
VARCHAR (20) |
FA_IMP_ASSET |
|
Asset Ref 2 |
ASSET_REF2_ID |
VARCHAR (20) |
FA_IMP_ASSET |
|
|
B1_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSET |
|
Post Seq No |
POST_SEQ_NO |
INT |
FA_IMP_ASSET |
|
Disposal Posting Date |
DISP_POST_DT |
DATETIME |
FA_IMP_ASSET |
|
Disposal Posting User |
DISP_POST_USER_ID |
VARCHAR (20) |
FA_IMP_ASSET |
|
Receipt |
RECPT_ID |
VARCHAR (10) |
FA_IMP_ASSET |
|
Voucher Line No |
VCHR_LN_NO |
SMALLINT |
FA_IMP_ASSET |
|
Non-Depr Post Disposal to GL |
ND_POST_DISP_FL |
VARCHAR (1) |
FA_IMP_ASSET |
|
Disposal Doc No |
DISP_DOC_ID |
VARCHAR (20) |
FA_IMP_ASSET |
|
Subclass Code |
FA_SUBCLASS_CD |
VARCHAR (6) |
FA_IMP_ASSET |
|
Employee |
EMPL_ID |
VARCHAR (12) |
FA_IMP_ASSET |
|
Disposal Type |
FA_DISP_TYPE |
VARCHAR (6) |
FA_IMP_ASSET |
|
Row Version |
ROW_VERSION |
SMALLINT |
FA_IMP_ASSET |
|
UID |
UID_CD |
VARCHAR(78) |
FA_IMP_ASSET |
|
UID Type |
S_UID_TYPE |
VARCHAR(5) |
FA_IMP_ASSET |
|
Issuing Agency Code |
UID_IAC_CD |
VARCHAR(3) |
FA_IMP_ASSET |
|
Enterprise Identifier |
UID_EID_CD |
VARCHAR(13) |
FA_IMP_ASSET |
|
Cage ID |
CAGE_ID_FLD |
VARCHAR(5) |
FA_IMP_ASSET |
|
Field Name |
Costpoint Column Name |
Field Type |
Costpoint Table Name |
|
INPUT_ROW_NO |
INT |
FA_IMP_ASSETB |
|
|
PROC_STATUS |
VARCHAR (1) |
FA_IMP_ASSETB |
|
|
AUTO_NO_GRP |
INT |
FA_IMP_ASSETB |
|
|
Asset ID |
ASSET_ID |
VARCHAR (10) |
FA_IMP_ASSETB |
|
Item No |
ITEM_NO |
INT |
FA_IMP_ASSETB |
|
Current Fiscal Year |
IMP_FY_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Current Period |
IMP_PD_NO |
INT |
FA_IMP_ASSETB |
|
Company ID |
IMP_COMPANY_ID |
VARCHAR (10) |
FA_IMP_ASSETB |
|
Book 2 Depr Method Code |
B2_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Book 2 Useful Life |
B2_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSETB |
|
Book 2 Auto Calc Depr |
B2_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSETB |
|
Book 2 Salvage Percent |
B2_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSETB |
|
Book 2 Salvage Value |
B2_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 2 FYTD Depreciation |
B2_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 2 Prior FY Depreciation |
B2_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 2 Amt To Depreciate |
B2_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 2 Annual Depreciation |
B2_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 2 Total Cost |
B2_TOT_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 2 Depr Start Date |
B2_DEPR_START_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 2 In-Service Date |
B2_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 2 Curr Depr Yr |
B2_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 2 Days/Pds Remaining |
B2_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 2 Amt Taken Purchase YTD |
B2_DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 3 Depr Method Code |
B3_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Book 3 Useful Life |
B3_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSETB |
|
Book 3 Auto Calc Depr |
B3_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSETB |
|
Book 3 Salvage Percent |
B3_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSETB |
|
Book 3 Salvage Value |
B3_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 3 FYTD Depreciation |
B3_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 3 Prior FY Depreciation |
B3_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 3 Current Pd Depreciation |
B3_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 3 Annual Depreciation |
B3_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 3 Total Cost |
B3_TOT_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 3 Depr Start Date |
B3_DEPR_START_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 3 In-Service Date |
B3_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 3 Curr Depr Yr |
B3_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Bok 3 Days/Pds Remaining |
B3_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 3 Amt Taken Purchase YTD |
B3_DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 4 Depr Method Code |
B4_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Book 4 Useful Life |
B4_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSETB |
|
Book 4 Auto Calc Depr |
B4_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSETB |
|
Book 4 Salvage Percent |
B4_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSETB |
|
Book 4 Salvage Value |
B4_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 4 FYTD Depreciation |
B4_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 4 Prior FY Depreciation |
B4_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 4 Current Pd Depreciation |
B4_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 4 Annual Depreciation |
B4_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 4 Total Cost |
B4_TOT_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 4 Depr Start Date |
B4_DEPR_START_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 4 In-Service Date |
B4_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 4 Curr Depr Yr |
B4_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 4 Days/Pds Remaining |
B4_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 4 Amt Taken Purch YTD |
B4_DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 5 Depr Method Code |
B5_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Book 5 Useful Life |
B5_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSETB |
|
Book 5 Auto Calc Depr |
B5_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSETB |
|
Book 5 Salvage Percent |
B5_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSETB |
|
Book 5 Salvage Value |
B5_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 5 FYTD Depreciation |
B5_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 5 Prior FY Depreciation |
B5_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 5 Current Pd Depreciation |
B5_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 5 Annual Depreciation |
B5_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 5 Total Cost |
B5_TOT_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 5 Depr Start Date |
B5_DEPR_START_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 5 In-Service Date |
B5_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 5 Curr Depr Yr |
B5_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 5 Days/Pds Remaining |
B5_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 5 Amt Taken Purchase YTD |
B5_DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 6 Depr Method Code |
B6_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Book 6 Useful Life |
B6_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSETB |
|
Book 6 Auto Calc Depr |
B6_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSETB |
|
Book 6 Salvage Percent |
B6_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSETB |
|
Book 6 Salvage Value |
B6_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 6 FYTD Depreciation |
B6_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 6 Prior FY Depreciation |
B6_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 6 Current Pd Depreciation |
B6_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 6 Annual Depreciation |
B6_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 6 Total Cost |
B6_TOT_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 6 Depr Start Date |
B6_DEPR_START_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 6 In-Service Date |
B6_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 6 Curr Depr Yr |
B6_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 6 Days/Pds Remaining |
B6_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 6 Amt Taken Purchase YTD |
B6_DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 7 Depr Method Code |
B7_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Book 7 Useful Life |
B7_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSETB |
|
Book 7 Auto Calc Depr |
B7_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSETB |
|
Book 7 Salvage Percent |
B7_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSETB |
|
Book 7 Salvage Value |
B7_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 7 FYTD Depreciation |
B7_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 7 Prior FY Depreciation |
B7_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 7 Current Pd Depreciation |
B7_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 7 Annual Depreciation |
B7_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 7 Total Cost |
B7_TOT_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 7 Depr Start Date |
B7_DEPR_START_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 7 In-Service Date |
B7_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 7 Curr Depr Yr |
B7_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 7 Days/Pds Remaining |
B7_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Bok 7 Amt Taken Purchase YTD |
B7_DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 8 Depr Method Code |
B8_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Book 8 Useful Life |
B8_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSETB |
|
Book 8 Auto Calc Depr |
B8_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSETB |
|
Book 8 Salvage Percent |
B8_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSETB |
|
Book 8 Salvage Value |
B8_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 8 FYTD Depreciation |
B8_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 8 Prior FY Depreciation |
B8_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 8 Current Pd Depreciation |
B8_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 8 Annual Depreciation |
B8_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 8 Total Cost |
B8_TOT_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 8 Depr Start Date |
B8_DEPR_START_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 8 In-Service Date |
B8_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 8 Curr Depr Yr |
B8_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 8 Days/Pds Remaining |
B8_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 8 Amt Taken Purchase YTD |
B8_DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 9 Depr Method Code |
B9_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Book 9 Useful Life |
B9_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSETB |
|
Book 9 Auto Calc Depr |
B9_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSETB |
|
Book 9 Salvage Percent |
B9_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSETB |
|
Book 9 Salvage Value |
B9_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 9 FYTD Deprecation |
B9_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 9 Prior FY Depreciation |
B9_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 9 Current Pd Depreciation |
B9_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 9 Annual Depreciation |
B9_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 9 Total Cost |
B9_TOT_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 9 Depr Start Date |
B9_DEPR_START_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 9 In-Service Date |
B9_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 9 Curr Depr Yr |
B9_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 9 Days/Pds Remaining |
B9_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 9 Amt Taken Purchase YTD |
B9_DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 10 Depr Method Code |
B10_DEPR_MTHD_CD |
VARCHAR (6) |
FA_IMP_ASSETB |
|
Book 10 Useful Life |
B10_USEFUL_LIFE_NO |
INT |
FA_IMP_ASSETB |
|
Book 10 Auto Calc Depr |
B10_AUTO_CALC_FL |
VARCHAR (1) |
FA_IMP_ASSETB |
|
Book 10 Salvage Percent |
B10_SLVGE_RT |
DECIMAL (7, 6) |
FA_IMP_ASSETB |
|
Book 10 Salvage Value |
B10_SLVGE_VAL_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 10 FYTD Depreciation |
B10_FYTD_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 10 Prior FY Depreciation |
B10_PFY_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 10 Current Pd Depreciation |
B10_CUR_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 10 Annual Depreciation |
B10_ANNL_DEPR_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 10 Total Cost |
B10_TOT_CST_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 10 Depr Start Date |
B10_DEPR_START_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 10 In-Service Date |
B10_IN_SERVICE_DT |
DATETIME |
FA_IMP_ASSETB |
|
Book 10 Curr Depr Yr |
B10_CUR_DEPR_YR_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 10 Days/Pds Remaining |
B10_PDS_REMAIN_NO |
SMALLINT |
FA_IMP_ASSETB |
|
Book 10 Amt Taken Purchase YTD |
B10DP_DEPR_YTD_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 2 DP Depr Next Yr Amt |
B2_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 3 DP Depr Next Yr Amt |
B3_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 4 DP Depr Next Yr Amt |
B4_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 5 DP Depr Next Yr Amt |
B5_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 6 DP Depr Next Yr Amt |
B6_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 7 DP Depr Next Yr Amt |
B7_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 8 DP Depr Next Yr Amt |
B8_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 9 DP Depr Next Yr Amt |
B9_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Book 10 DP Depr Next Yr Amt |
B10_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Modified By |
MODIFIED_BY |
VARCHAR (18) |
FA_IMP_ASSETB |
|
Timestamp |
TIME_STAMP |
TIMESTMP (10) |
FA_IMP_ASSETB |
|
Row Version |
ROW_VERSION |
SMALLINT |
FA_IMP_ASSET |
|
Field Name |
Costpoint Column Name |
Field Type |
Costpoint Table Name |
|
INPUT_ROW_NO |
INT |
FA_IMP_ASSETO |
|
|
PROC_STATUS |
VARCHAR (1) |
FA_IMP_ASSETO |
|
|
AUTO_NO_GRP |
INT |
FA_IMP_ASSETO |
|
|
Asset ID |
ASSET_ID |
VARCHAR (10) |
FA_IMP_ASSETO |
|
Item No |
ITEM_NO |
INT |
FA_IMP_ASSETO |
|
Notes |
NOTES |
VARCHAR (254) |
FA_IMP_ASSETO |
|
Year Built |
YR_BUILT_NO |
SMALLINT |
FA_IMP_ASSETO |
|
Nat Stock No |
NSN_ID |
VARCHAR (20) |
FA_IMP_ASSETO |
|
Govt Field 1 |
GOVT_FLD1_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 2 |
GOVT_FLD2_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 3 |
GOVT_FLD3_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 4 |
GOVT_FLD4_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 5 |
GOVT_FLD5_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 6 |
GOVT_FLD6_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 7 |
GOVT_FLD7_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 8 |
GOVT_FLD8_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 9 |
GOVT_FLD9_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 10 |
GOVT_FLD10_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 11 |
GOVT_FLD11_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 12 |
GOVT_FLD12_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 13 |
GOVT_FLD13_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 14 |
GOVT_FLD14_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
Govt Field 15 |
GOVT_FLD15_DESC |
VARCHAR (30) |
FA_IMP_ASSETO |
|
G/L Book Depr Adj |
B1_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 2 Depr Adj |
B2_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 3 Depr Adj |
B3_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 4 Depr Adj |
B4_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 5 Depr Adj |
B5_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 6 Depr Adj |
B6_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 7 Depr Adj |
B7_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 8 Depr Adj |
B8_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 9 Depr Adj |
B9_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 10 Depr Adj |
B10_DEPR_ADJ_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETO |
|
Book 10 DP Depr Next Yr Amt |
B10_DP_DEPR_NY_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETB |
|
Modified By |
MODIFIED_BY |
VARCHAR (18) |
FA_IMP_ASSETB |
|
Timestamp |
TIME_STAMP |
TIMESTMP (10) |
FA_IMP_ASSETB |
|
Row Version |
ROW_VERSION |
SMALLINT |
FA_IMP_ASSET |
|
Field Name |
Costpoint Column Name |
Field Type |
Costpoint Table Name |
|
INPUT_ROW_NO |
INT |
FA_IMP_ASSETU |
|
|
PROC_STATUS |
VARCHAR (1) |
FA_IMP_ASSETU |
|
|
AUTO_NO_GRP |
INT |
FA_IMP_ASSETU |
|
|
Asset ID |
ASSET_ID |
VARCHAR (10) |
FA_IMP_ASSETU |
|
Item No |
ITEM_NO |
INT |
FA_IMP_ASSETU |
|
Text Value |
UDEF_TXT |
VARCHAR (30) |
FA_IMP_ASSETU |
|
Validated Text Value |
UDEF_ID |
VARCHAR (20) |
FA_IMP_ASSETU |
|
User-Defined Date |
UDEF_DT |
DATETIME |
FA_IMP_ASSETU |
|
Numeric Value |
UDEF_AMT |
DECIMAL (14, 2) |
FA_IMP_ASSETU |
|
Label |
UDEF_LBL |
VARCHAR (20) |
FA_IMP_ASSETU |
|
Modified By |
MODIFIED_BY |
VARCHAR (18) |
FA_IMP_ASSETB |
|
Timestamp |
TIME_STAMP |
TIMESTMP (10) |
FA_IMP_ASSETB |
|
Row Version |
ROWVERSION |
SMALLINT |
FA_IMP_ASSET |
|
|
|
|
|