TABLE DETAIL REFERENCE:
 
(US VERSION)
FIELD NAME TYPE LENGTH QRY MOD INS REQ INS VALIDATE REL
ListID Varchar 36 True False False N/A String
TimeCreated Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
TimeModified Timestamp 27 True False False N/A CCCC-MM-DDThh:mm:ssZ
EditSequence Varchar 16 True False False N/A String
Name Varchar 31 True True True Yes String
IsActive Bit 5 True True True No 1 0 true false
AcquiredAs Varchar 3 True True True Yes New Old
PurchaseDesc Varchar 50 True True True Yes String
PurchaseDate Date 10 True True True Yes CCCC-MM-DD
PurchaseCost Decimal 14 True True True No 8.5
VendorOrPayeeName Varchar 50 True True True No String
AssetAccountRefListID Varchar 36 True False True Yes String
AssetAccountRefFullName Varchar 159 True True True Yes String
FixedAssetSalesInfoSalesDesc Varchar 50 True True True No String
FixedAssetSalesInfoSalesDate Date 10 True True True No CCCC-MM-DD
FixedAssetSalesInfoSalesPrice Decimal 14 True True True No 8.5
FixedAssetSalesInfoSalesExpense Decimal 14 True True True No 8.5
AssetDesc Varchar 50 True True True No String
Location Varchar 50 True True True No String
PONumber Varchar 30 True True True No String
SerialNumber Varchar 30 True True True No String
WarrantyExpDate Date 10 True True True No CCCC-MM-DD
Notes Varchar 4096 True True True No String
AssetNumber Varchar 10 True True True No String
CostBasis Decimal 11 True True True No 8.2
YearEndAccumulatedDepreciation Decimal 11 True True True No 8.2
YearEndBookValue Decimal 11 True True True No 8.2