TABLE DETAIL REFERENCE: SalesOrder
(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 40TrueTrueTrueFalse%s
BalanceDue3 DECIMAL 16TrueFalseFalseFalse%8.5f
Cashier12 VARCHAR 40TrueTrueTrueFalse%s
CustomerListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
DepositBalance3 DECIMAL 16TrueFalseFalseFalse%8.5f
Discount3 DECIMAL 16TrueTrueTrueFalse%8.5f
DiscountPercent3 DECIMAL 13TrueTrueTrueFalse%8.2f
Instructions12 VARCHAR 2000TrueTrueTrueFalse%s
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
PriceLevelNumber12 VARCHAR 1TrueTrueTrueFalse
1
2
3
4
PromoCode12 VARCHAR 10TrueTrueTrueFalse%s
Qty3 DECIMAL 15TrueFalseFalseFalse%7.5f
SalesOrderNumber12 VARCHAR 32TrueFalseFalseFalse%11.0f
SalesOrderStatusDesc12 VARCHAR 50TrueTrueTrueFalse%s
SalesOrderType12 VARCHAR 10TrueTrueTrueFalse
SalesOrder
Layaway
WorkOrder
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
Subtotal3 DECIMAL 16TrueFalseFalseFalse%8.5f
TaxAmount3 DECIMAL 16TrueFalseFalseFalse%8.5f
TaxCategory12 VARCHAR 20TrueTrueTrueFalse%s
TaxPercent3 DECIMAL 13TrueFalseFalseFalse%8.2f
Total3 DECIMAL 16TrueFalseFalseFalse%8.5f
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
UnfilledPercent3 DECIMAL 13TrueFalseFalseFalse%8.2f
BillingInformationCity12 VARCHAR 31TrueFalseFalseFalse%s
BillingInformationCompanyName12 VARCHAR 48TrueFalseFalseFalse%s
BillingInformationCountry12 VARCHAR 32TrueFalseFalseFalse%s
BillingInformationFirstName12 VARCHAR 30TrueFalseFalseFalse%s
BillingInformationLastName12 VARCHAR 30TrueFalseFalseFalse%s
BillingInformationPhone12 VARCHAR 15TrueFalseFalseFalse%s
BillingInformationPhone212 VARCHAR 15TrueFalseFalseFalse%s
BillingInformationPhone312 VARCHAR 15TrueFalseFalseFalse%s
BillingInformationPhone412 VARCHAR 15TrueFalseFalseFalse%s
BillingInformationPostalCode12 VARCHAR 10TrueFalseFalseFalse%s
BillingInformationSalutation12 VARCHAR 15TrueFalseFalseFalse%s
BillingInformationState12 VARCHAR 21TrueFalseFalseFalse%s
BillingInformationStreet12 VARCHAR 41TrueFalseFalseFalse%s
ShippingInformationCity12 VARCHAR 31TrueTrueTrueFalse%s
ShippingInformationCompanyName12 VARCHAR 48TrueTrueTrueFalse%s
ShippingInformationCountry12 VARCHAR 32TrueTrueTrueFalse%s
ShippingInformationFullName12 VARCHAR 159TrueTrueTrueFalse%s
ShippingInformationPhone12 VARCHAR 15TrueTrueTrueFalse%s
ShippingInformationPhone212 VARCHAR 15TrueTrueTrueFalse%s
ShippingInformationPhone312 VARCHAR 15TrueTrueTrueFalse%s
ShippingInformationPhone412 VARCHAR 15TrueTrueTrueFalse%s
ShippingInformationPostalCode12 VARCHAR 10TrueTrueTrueFalse%s
ShippingInformationShipBy12 VARCHAR 50TrueTrueTrueFalse%s
ShippingInformationShipping3 DECIMAL 16TrueTrueTrueFalse%8.5f
ShippingInformationState12 VARCHAR 21TrueTrueTrueFalse%s
ShippingInformationStreet12 VARCHAR 41TrueTrueTrueFalse%s
ShippingInformationStreet212 VARCHAR 41TrueTrueTrueFalse%s
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache