TABLE DETAIL REFERENCE: Voucher
(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
CompanyName12 VARCHAR 48TrueFalseFalseFalse%s
Discount3 DECIMAL 16TrueFalseTrueFalse%8.5f
DiscountPercent3 DECIMAL 13TrueFalseTrueFalse%8.2f
Fee3 DECIMAL 16TrueFalseTrueFalse%8.5f
Freight3 DECIMAL 16TrueFalseTrueFalse%8.5f
HistoryDocStatus12 VARCHAR 9TrueFalseTrueFalse
Regular
Reversed
Reversing
InvoiceDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
InvoiceDueDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
InvoiceNumber12 VARCHAR 15TrueFalseTrueFalse%s
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
PayeeCode12 VARCHAR 15TrueFalseTrueFalse%s
PayeeListID12 VARCHAR 36TrueFalseTrueFalse%s
PayeeName12 VARCHAR 26TrueFalseFalseFalse%s
PurchaseOrderNumber12 VARCHAR 20TrueFalseFalseFalse%s
PurchaseOrderTxnID12 VARCHAR 36TrueFalseTrueFalse%s Yes
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
Subtotal3 DECIMAL 16TrueFalseFalseFalse%8.5f
TermsDiscount3 DECIMAL 13TrueFalseTrueFalse%8.2f
TermsDiscountDays4 INTEGER 4TrueFalseTrueFalse%11.0f
TermsNetDays4 INTEGER 4TrueFalseTrueFalse%11.0f
Total3 DECIMAL 16TrueFalseFalseFalse%8.5f
TotalQty3 DECIMAL 15TrueFalseFalseFalse%7.5f
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
VendorCode12 VARCHAR 3TrueFalseTrueFalse%s
VendorListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
VoucherNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VoucherType12 VARCHAR 9TrueFalseTrueFalse
Receiving
Return
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache