ItemFixedAsset Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ListID 12 VARCHAR 36 True False False False %s 3.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 3.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 3.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 3.0 US, CA, UK
Name 12 VARCHAR 31 True True True True %s 3.0 US, CA, UK
FullName 12 VARCHAR 159 True False False False %s 3.0 US, CA, UK
BarCode_Value 12 VARCHAR 50 True True True False %s 12.0 US, CA, UK
BarCode_AssignEvenIfUsed -7 BIT 2 False True True False
1
0
true
false
 3.0 US, CA, UK
BarCode_AllowOverride -7 BIT 2 False True True False
1
0
true
false
 3.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 3.0 US, CA, UK
ClassRef_ListID 12 VARCHAR 36 True True True False %s 12.0 US, CA, UK
ClassRef_FullName 12 VARCHAR 159 True True True False %s 12.0 US, CA, UK
AcquiredAs 12 VARCHAR 3 True False False True
New
Old
 3.0 US, CA, UK
PurchaseDesc 12 VARCHAR 50 True True True True %s 3.0 US, CA, UK
PurchaseDate 91 DATE 10 True True True True CCCC-MM-DD 3.0 US, CA, UK
PurchaseCost 2 NUMERIC 15 True True True False %10.5f 3.0 US, CA, UK
VendorOrPayeeName 12 VARCHAR 50 True True True False %s 3.0 US, CA, UK
AssetAccountRef_ListID 12 VARCHAR 36 True True True True %s ListID 3.0 US, CA, UK
AssetAccountRef_FullName 12 VARCHAR 159 True True True True %s FullName 3.0 US, CA, UK
FixedAssetSalesInfo_SalesDesc 12 VARCHAR 50 True True True False %s 3.0 US, CA, UK
FixedAssetSalesInfo_SalesDate 91 DATE 10 True True True False CCCC-MM-DD 3.0 US, CA, UK
FixedAssetSalesInfo_SalesPrice 2 NUMERIC 15 True True True False %10.5f 3.0 US, CA, UK
FixedAssetSalesInfo_SalesExpense 2 NUMERIC 15 True True True False %10.5f 3.0 US, CA, UK
AssetDesc 12 VARCHAR 50 True True True False %s 3.0 US, CA, UK
Location 12 VARCHAR 50 True True True False %s 3.0 US, CA, UK
PONumber 12 VARCHAR 30 True True True False %s 3.0 US, CA, UK
SerialNumber 12 VARCHAR 30 True True True False %s 3.0 US, CA, UK
WarrantyExpDate 91 DATE 10 True True True False CCCC-MM-DD 3.0 US, CA, UK
Notes 12 VARCHAR 4095 True True True False %s 3.0 US, CA, UK
AssetNumber 12 VARCHAR 10 True True True False %s 3.0 US, CA, UK
CostBasis 2 NUMERIC 15 True True True False %10.2f 3.0 US, CA, UK
YearEndAccumulatedDepreciation 2 NUMERIC 15 True True True False %10.2f 3.0 US, CA, UK
YearEndBookValue 2 NUMERIC 15 True True True False %10.2f 3.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 True False True False {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} 8.0 US, CA, UK
CFColor 12 VARCHAR 255 True True True False %s 3.0 US, CA, UK
CFMaterial 12 VARCHAR 255 True True True False %s 3.0 US, CA, UK

Back to list of tables.