TABLE DETAIL REFERENCE: InventoryCostAdjustment
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
CostDifference3 DECIMAL 16TrueFalseFalseFalse%8.5f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
InventoryAdjustmentNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
InventoryAdjustmentSource12 VARCHAR 17TrueFalseTrueFalse
Manual
PhysicalInventory
Assembly
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
NewCost3 DECIMAL 16TrueFalseFalseFalse%8.5f
OldCost3 DECIMAL 16TrueFalseFalseFalse%8.5f
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
Reason12 VARCHAR 8TrueFalseTrueFalse%s
StoreExchangeStatus12 VARCHAR 17TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache