TABLE DETAIL REFERENCE: TransferSlipItem
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Carrier12 VARCHAR 15TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
Freight3 DECIMAL 13TrueFalseTrueFalse%8.2f
FromStoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
SlipETA9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
SlipNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
ToStoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
TotalCost3 DECIMAL 13TrueFalseFalseFalse%8.2f
TotalQty3 DECIMAL 15TrueFalseFalseFalse%7.5f
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
TransferSlipItemSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
TransferSlipItemListID12 VARCHAR 36TrueFalseTrueTrue%s
TransferSlipItemQty3 DECIMAL 15TrueFalseTrueFalse%7.5f
TransferSlipItemSerialNumber12 VARCHAR 25TrueFalseTrueFalse%s
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey