Importing Assets
The following table defines the field references to be used in the Assets section of the MasterFA.DEF file:
| Table: tblFACode | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,ASSETS,HEADER,HASSET | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
ASSET_ID |
Y |
User Defined |
Asset ID |
|
|
ASSET_STATUS |
Y |
1 |
A |
A (Active), I (Inactive), or D (Discontinued/Disposed) |
|
ASSET_DESCRIPTION |
Y |
User Defined |
Asset Description |
|
|
ASSET_CATEGORY |
Y |
User Defined |
Category |
|
|
ASSET_TAG |
N |
30 |
Asset Tag |
|
|
ASSET_ORGASSETID |
N |
User Defined |
Original Asset ID |
|
|
ASSET_TAXABLE |
N |
1 |
0 |
0 = No; 1 = Yes |
|
ASSET_ACQCODE |
N |
User Defined |
Acquisition Code |
|
|
ASSET_RESCODE |
N |
User Defined |
Responsibility Code |
|
|
ASSET_VALCODE |
N |
User Defined |
Valuation Code |
|
|
ASSET_LOCCODE |
N |
User Defined |
Location Code |
|
|
ASSET_TYPE_ID |
Y |
User Defined |
Asset Type ID |
|
|
ASSET_COST |
Y |
Currency |
0.00 |
Cost or Basis Amount |
|
ASSET_SALVAGE |
Y |
Currency |
0.00 |
Salvage Value |
|
ASSET_BEGDEPRDATE |
Y |
Date |
Current Date |
Begin Depreciation Date. Can be 6, 8, or 10 digit date. |
|
ASSET_LASTDEPRDATE |
N |
Date |
Last Depreciation Date. Can be 6, 8, or 10 digit date. |
|
|
ASSET_ACCMDEPRAMT |
Y |
Currency |
0.00 |
Accumulation Depreciation Amount. Required if Last Depreciation Date is completed. |
|
ASSET_MONTHSDEPR |
Y |
Integer |
0 |
Months Depreciated. Required if Last Depreciation Date is completed. |
|
ASSET_MAINTDATE |
N |
Date |
Can be 6, 8, or 10 digit date. |
|
|
ASSET_WARRANTY |
N |
60 |
Warranty |
|
|
ASSET_MODEL |
N |
40 |
Manufacturer/Model Number |
|
|
ASSET_SERIAL |
N |
40 |
Serial Number |
|
|
ASSET_PAYEE |
N |
50 |
Payee or Vendor ID |
|
|
ASSET_DOCNUM |
N |
User Defined |
Check or Invoice Number |
|
|
ASSET_ACQDATE |
N |
Date |
Can be 6, 8, or 10 digit date. |
|
|
ASSET_PONUM |
N |
User Defined |
Purchase Order Number |
|
|
ASSET_CODE |
N |
User Defined |
Asset Code |
|
|
ASSET_LIFE |
Y |
Integer |
Life in Months |
|
|
ASSET_REPLACECOST |
N |
Currency |
0.00 |
Replacement Cost |
|
ASSET_ZEROBV |
N |
1 |
0 |
0 = No; 1 = Yes |
|
ASSET_NOTES |
N |
Notes |
||