TABLE DETAIL REFERENCE: ItemFixedAsset
(Canada VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT		 VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueTrueTrueTrue%s
BarCodeValue12 VARCHAR 50TrueTrueTrueFalse%s
BarCodeAssignEvenIfUsed-7 BIT 1FalseTrueTrueFalse
1
0
true
false
BarCodeAllowOverride-7 BIT 1FalseTrueTrueFalse
1
0
true
false
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
AcquiredAs12 VARCHAR 3TrueTrueTrueTrue
New
Old
PurchaseDesc12 VARCHAR 50TrueTrueTrueTrue%s
PurchaseDate9 DATE 6TrueTrueTrueTrueCCCC-MM-DD
PurchaseCost3 DECIMAL 18TrueTrueTrueFalse%10.5f
VendorOrPayeeName12 VARCHAR 50TrueTrueTrueFalse%s
AssetAccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AssetAccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
FixedAssetSalesInfoSalesDesc12 VARCHAR 50TrueTrueTrueFalse%s
FixedAssetSalesInfoSalesDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
FixedAssetSalesInfoSalesPrice3 DECIMAL 18TrueTrueTrueFalse%10.5f
FixedAssetSalesInfoSalesExpense3 DECIMAL 18TrueTrueTrueFalse%10.5f
AssetDesc12 VARCHAR 50TrueTrueTrueFalse%s
Location12 VARCHAR 50TrueTrueTrueFalse%s
PONumber12 VARCHAR 30TrueTrueTrueFalse%s
SerialNumber12 VARCHAR 30TrueTrueTrueFalse%s
WarrantyExpDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Notes12 VARCHAR 4096TrueTrueTrueFalse%s
AssetNumber12 VARCHAR 10TrueTrueTrueFalse%s
CostBasis3 DECIMAL 17TrueTrueTrueFalse%10.2f
YearEndAccumulatedDepreciation3 DECIMAL 17TrueTrueTrueFalse%10.2f
YearEndBookValue3 DECIMAL 17TrueTrueTrueFalse%10.2f
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}