TABLE DETAIL REFERENCE: Company
(POS VERSION)
TABLE DETAIL REFERENCE: Customer
(POS VERSION)
TABLE DETAIL REFERENCE: CustomerReward
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
AccountBalance | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
AccountLimit | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
AmountPastDue | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
CompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
CustomerDiscPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
CustomerDiscType | 12 | VARCHAR | 10 | True | False | False | False | None PriceLevel Percentage | |
CustomerType | 12 | VARCHAR | 15 | True | False | False | False | %s | |
CustomerID | 12 | VARCHAR | 41 | True | False | False | False | %s | |
DefaultShipAddress | 12 | VARCHAR | 20 | True | False | False | False | %s | |
12 | VARCHAR | 99 | True | False | False | False | %s | ||
FirstName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
FullName | 12 | VARCHAR | 200 | True | False | False | False | %s | |
IsAcceptingChecks | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
IsNoShipToBilling | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
IsOkToEMail | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
IsRewardsMember | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
IsUsingChargeAccount | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
IsUsingWithQB | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
LastName | 12 | VARCHAR | 30 | True | False | False | True | %s | |
LastSale | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
Notes | 12 | VARCHAR | 245 | True | False | False | False | %s | |
Phone | 12 | VARCHAR | 40 | True | False | False | False | %s | |
Phone2 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
Phone3 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
Phone4 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
PriceLevelNumber | 12 | VARCHAR | 1 | True | False | False | False | 1 2 3 4 | |
Salutation | 12 | VARCHAR | 15 | True | False | False | False | %s | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
TaxCategory | 12 | VARCHAR | 20 | True | False | False | False | %s | |
WebNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
BillAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
BillAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillAddressStreet | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressStreet2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
RewardSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
RewardAmount | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
RewardPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
RewardEarnedDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
RewardMatureDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
RewardExpirationDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
RewardStatus | 12 | VARCHAR | 10 | True | False | False | False | Available Removed | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
CustomFieldOther | 12 | VARCHAR | 30 | True | False | False | False | %s | |
CustomFieldSalesLocation | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldSerial | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldSerial1 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldSerial2 | 12 | VARCHAR | 30 | True | True | True | False | %s |
TABLE DETAIL REFERENCE: CustomerShipAddress
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
AccountBalance | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
AccountLimit | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
AmountPastDue | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
CompanyName | 12 | VARCHAR | 48 | True | True | True | False | %s | |
CustomerDiscPercent | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
CustomerDiscType | 12 | VARCHAR | 10 | True | True | True | False | None PriceLevel Percentage | |
CustomerType | 12 | VARCHAR | 15 | True | True | True | False | %s | |
CustomerID | 12 | VARCHAR | 41 | True | True | True | False | %s | |
DefaultShipAddress | 12 | VARCHAR | 20 | True | True | True | False | %s | |
12 | VARCHAR | 99 | True | True | True | False | %s | ||
FirstName | 12 | VARCHAR | 30 | True | True | True | False | %s | |
FullName | 12 | VARCHAR | 200 | True | False | False | False | %s | |
IsAcceptingChecks | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsNoShipToBilling | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsOkToEMail | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsRewardsMember | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsUsingChargeAccount | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsUsingWithQB | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
LastName | 12 | VARCHAR | 30 | True | True | True | True | %s | |
LastSale | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
Notes | 12 | VARCHAR | 245 | True | True | True | False | %s | |
Phone | 12 | VARCHAR | 40 | True | True | True | False | %s | |
Phone2 | 12 | VARCHAR | 40 | True | True | True | False | %s | |
Phone3 | 12 | VARCHAR | 40 | True | True | True | False | %s | |
Phone4 | 12 | VARCHAR | 40 | True | True | True | False | %s | |
PriceLevelNumber | 12 | VARCHAR | 1 | True | True | True | False | 1 2 3 4 | |
Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
TaxCategory | 12 | VARCHAR | 20 | True | True | True | False | %s | |
WebNumber | 12 | VARCHAR | 20 | True | True | True | False | %s | |
BillAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
BillAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressStreet | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressStreet2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ShipAddressAddressName | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressCompanyName | 12 | VARCHAR | 48 | True | True | True | False | %s | |
ShipAddressFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
ShipAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressStreet | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressStreet2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
CustomFieldOther | 12 | VARCHAR | 30 | True | False | False | False | %s | |
CustomFieldSalesLocation | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldSerial | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldSerial1 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldSerial2 | 12 | VARCHAR | 30 | True | True | True | False | %s |
TABLE DETAIL REFERENCE: CustomField
(POS VERSION)
TABLE DETAIL REFERENCE: Department
(POS VERSION)
TABLE DETAIL REFERENCE: Employee
(POS VERSION)
TABLE DETAIL REFERENCE: InventoryCostAdjustment
(POS VERSION)
TABLE DETAIL REFERENCE: InventoryCostAdjustmentItem
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Comments | 12 | VARCHAR | 300 | True | False | True | False | %s | |
CostDifference | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
HistoryDocStatus | 12 | VARCHAR | 9 | True | False | False | False | Regular Reversed Reversing | |
InventoryAdjustmentNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
InventoryAdjustmentSource | 12 | VARCHAR | 17 | True | False | True | False | Manual PhysicalInventory Assembly | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
NewCost | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
OldCost | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
QuickBooksFlag | 12 | VARCHAR | 17 | True | False | True | False | NotPosted Completed Error UnbilledPurchases | |
Reason | 12 | VARCHAR | 8 | True | False | True | False | %s | |
StoreExchangeStatus | 12 | VARCHAR | 17 | True | False | False | False | Modified Sent Acknowledged | |
StoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnState | 12 | VARCHAR | 6 | True | False | True | False | Normal Held | |
Workstation | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
InventoryCostAdjustmentItemSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
InventoryCostAdjustmentItemListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
InventoryCostAdjustmentItemCostDifference | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
InventoryCostAdjustmentItemNewCost | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
InventoryCostAdjustmentItemOldCost | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: InventoryQtyAdjustment
(POS VERSION)
TABLE DETAIL REFERENCE: InventoryQtyAdjustmentItem
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Comments | 12 | VARCHAR | 300 | True | False | True | False | %s | |
CostDifference | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
HistoryDocStatus | 12 | VARCHAR | 9 | True | False | False | False | Regular Reversed Reversing | |
InventoryAdjustmentNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
InventoryAdjustmentSource | 12 | VARCHAR | 17 | True | False | True | False | Manual PhysicalInventory Assembly | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
NewQuantity | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
OldQuantity | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
QuickBooksFlag | 12 | VARCHAR | 17 | True | False | True | False | NotPosted Completed Error UnbilledPurchases | |
Reason | 12 | VARCHAR | 8 | True | False | True | False | %s | |
StoreExchangeStatus | 12 | VARCHAR | 17 | True | False | False | False | Modified Sent Acknowledged | |
StoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnState | 12 | VARCHAR | 6 | True | False | True | False | Normal Held | |
Workstation | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
InventoryQtyAdjustmentItemSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
InventoryQtyAdjustmentItemListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
InventoryQtyAdjustmentItemNewQuantity | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
InventoryQtyAdjustmentItemOldQuantity | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
InventoryQtyAdjustmentItemQtyDifference | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
InventoryQtyAdjustmentItemSerialNumber | 12 | VARCHAR | 25 | True | False | True | False | %s | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: ItemInventory
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
Attribute | 12 | VARCHAR | 8 | True | True | True | False | %s | |
COGSAccount | 12 | VARCHAR | 159 | True | True | True | False | %s | |
Cost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
DepartmentCode | 12 | VARCHAR | 3 | True | True | True | False | %s | |
DepartmentListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
Desc1 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
Desc2 | 12 | VARCHAR | 8000 | True | True | True | False | %s | |
IncomeAccount | 12 | VARCHAR | 159 | True | True | True | False | %s | |
IsBelowReorder | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsEligibleForCommission | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsPrintingTags | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsUnorderable | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
ItemNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
ItemType | 12 | VARCHAR | 13 | True | True | True | False | Inventory Non-Inventory Service Assembly Group SpecialOrder | |
Keywords | 12 | VARCHAR | 18 | True | True | True | False | %s | |
LastReceived | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
MarginPercent | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
MarkupPercent | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
MSRP | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
OnHandStore01 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore02 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore03 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore04 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore05 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore06 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore07 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore08 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore09 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore10 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore11 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore12 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore13 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore14 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore15 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore16 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore17 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore18 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore19 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore20 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OrderByUnit | 12 | VARCHAR | 20 | True | True | True | False | %s | |
OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price1 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price2 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price3 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price4 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price5 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
QuantityOnCustomerOrder | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
QuantityOnHand | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
QuantityOnOrder | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
QuantityOnPendingOrder | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPoint | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore01 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore02 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore03 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore04 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore05 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore06 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore07 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore08 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore09 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore10 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore11 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore12 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore13 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore14 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore15 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore16 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore17 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore18 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore19 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore20 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
SellByUnit | 12 | VARCHAR | 20 | True | True | True | False | %s | |
SerialFlag | 12 | VARCHAR | 8 | True | True | True | False | Optional Prompt | |
Size | 12 | VARCHAR | 12 | True | True | True | False | %s | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | True | True | False | Modified Sent Acknowledged | |
TaxCode | 12 | VARCHAR | 36 | True | True | True | False | %s | |
UnitOfMeasure | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorCode | 12 | VARCHAR | 3 | True | True | True | False | %s | |
VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
WebDesc | 12 | VARCHAR | 18 | True | True | True | False | %s | |
WebPrice | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Manufacturer | 12 | VARCHAR | 50 | True | True | True | False | %s | |
Weight | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
WebSKU | 12 | VARCHAR | 18 | True | True | True | False | %s | |
WebCategories | 12 | VARCHAR | 18 | True | True | True | False | %s | |
UnitOfMeasure1ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure1MSRP | 3 | DECIMAL | 13 | True | True | True | False | %7.5f | |
UnitOfMeasure1NumberOfBaseUnits | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
UnitOfMeasure1Price1 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1Price2 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1Price3 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1Price4 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1Price5 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1UnitOfMeasure | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure1UPC | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure2ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure2MSRP | 3 | DECIMAL | 13 | True | True | True | False | %7.5f | |
UnitOfMeasure2NumberOfBaseUnits | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
UnitOfMeasure2Price1 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2Price2 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2Price3 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2Price4 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2Price5 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2UnitOfMeasure | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure2UPC | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure3ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure3MSRP | 3 | DECIMAL | 13 | True | True | True | False | %7.5f | |
UnitOfMeasure3NumberOfBaseUnits | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
UnitOfMeasure3Price1 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3Price2 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3Price3 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3Price4 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3Price5 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3UnitOfMeasure | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure3UPC | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo2ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo2OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
VendorInfo2UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorInfo2VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
VendorInfo3ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo3OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
VendorInfo3UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorInfo3VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
VendorInfo4ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo4OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
VendorInfo4UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorInfo4VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
VendorInfo5ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo5OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
VendorInfo5UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorInfo5VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
CustomFieldAlternateLoc1 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldAlternateLoc2 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldAlternateLoc3 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldCatagory | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldPrimaryLocation | 12 | VARCHAR | 30 | True | True | True | False | %s |
TABLE DETAIL REFERENCE: ListDeleted
(POS VERSION)
TABLE DETAIL REFERENCE: PurchaseOrder
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | True | True | False | %s | |
CancelDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
CompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
Discount | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
DiscountPercent | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
Fee | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Instructions | 12 | VARCHAR | 2000 | True | True | True | False | %s | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PurchaseOrderNumber | 12 | VARCHAR | 20 | True | True | True | False | %s | |
PurchaseOrderStatusDesc | 12 | VARCHAR | 200 | True | True | True | False | %s | |
QtyDue | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
QtyOrdered | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
QtyReceived | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
SalesOrderNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
StartShipDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
StoreNumber | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
Subtotal | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
Terms | 12 | VARCHAR | 200 | True | False | False | False | %s | |
TermsDiscount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
TermsDiscountDays | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
TermsNetDays | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
Total | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
UnfilledPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
VendorCode | 12 | VARCHAR | 3 | True | False | False | False | %s | |
VendorListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
FQSaveToCache | -7 | BIT | 1 | True | True | True | False | FQSaveToCache | |
CustomFieldOther1 | 12 | VARCHAR | 30 | True | False | False | False | %s | |
CustomFieldOther2 | 12 | VARCHAR | 30 | True | False | False | False | %s |
TABLE DETAIL REFERENCE: PurchaseOrderItem
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | True | True | False | %s | |
CancelDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
CompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
Discount | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
DiscountPercent | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
Fee | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Instructions | 12 | VARCHAR | 2000 | True | True | True | False | %s | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PurchaseOrderNumber | 12 | VARCHAR | 20 | True | True | True | False | %s | |
PurchaseOrderStatusDesc | 12 | VARCHAR | 200 | True | True | True | False | %s | |
QtyDue | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
QtyOrdered | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
QtyReceived | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
SalesOrderNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
StartShipDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
StoreNumber | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
Subtotal | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
Terms | 12 | VARCHAR | 200 | True | False | False | False | %s | |
TermsDiscount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
TermsDiscountDays | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
TermsNetDays | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
Total | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
UnfilledPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
VendorCode | 12 | VARCHAR | 3 | True | False | False | False | %s | |
VendorListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
PurchaseOrderItemSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
PurchaseOrderItemListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
PurchaseOrderItemTxnLineID | 4 | INTEGER | 4 | True | True | False | False | %11.0f | |
PurchaseOrderItemALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
PurchaseOrderItemAttribute | 12 | VARCHAR | 8 | True | True | True | False | %s | |
PurchaseOrderItemCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
PurchaseOrderItemDesc1 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
PurchaseOrderItemDesc2 | 12 | VARCHAR | 8000 | True | True | True | False | %s | |
PurchaseOrderItemExtendedCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
PurchaseOrderItemItemNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PurchaseOrderItemNumberOfBaseUnits | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
PurchaseOrderItemQty | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
PurchaseOrderItemQtyReceived | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
PurchaseOrderItemSize | 12 | VARCHAR | 8 | True | True | True | False | %s | |
PurchaseOrderItemUnitOfMeasure | 12 | VARCHAR | 20 | True | False | True | False | %s | |
PurchaseOrderItemUPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
FQSaveToCache | -7 | BIT | 1 | True | True | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: SalesOrder
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | True | True | False | %s | |
BalanceDue | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
Cashier | 12 | VARCHAR | 40 | True | True | True | False | %s | |
CustomerListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
DepositBalance | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
Discount | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
DiscountPercent | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
Instructions | 12 | VARCHAR | 2000 | True | True | True | False | %s | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PriceLevelNumber | 12 | VARCHAR | 1 | True | True | True | False | 1 2 3 4 | |
PromoCode | 12 | VARCHAR | 10 | True | True | True | False | %s | |
Qty | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
SalesOrderNumber | 12 | VARCHAR | 32 | True | False | False | False | %11.0f | |
SalesOrderStatusDesc | 12 | VARCHAR | 50 | True | True | True | False | %s | |
SalesOrderType | 12 | VARCHAR | 10 | True | True | True | False | SalesOrder Layaway WorkOrder | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
Subtotal | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TaxAmount | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TaxCategory | 12 | VARCHAR | 20 | True | True | True | False | %s | |
TaxPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
Total | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
UnfilledPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
BillingInformationCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillingInformationCompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
BillingInformationCountry | 12 | VARCHAR | 32 | True | False | False | False | %s | |
BillingInformationFirstName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
BillingInformationLastName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
BillingInformationPhone | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationPhone2 | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationPhone3 | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationPhone4 | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationPostalCode | 12 | VARCHAR | 10 | True | False | False | False | %s | |
BillingInformationSalutation | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillingInformationStreet | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShippingInformationCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShippingInformationCompanyName | 12 | VARCHAR | 48 | True | True | True | False | %s | |
ShippingInformationCountry | 12 | VARCHAR | 32 | True | True | True | False | %s | |
ShippingInformationFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | |
ShippingInformationPhone | 12 | VARCHAR | 15 | True | True | True | False | %s | |
ShippingInformationPhone2 | 12 | VARCHAR | 15 | True | True | True | False | %s | |
ShippingInformationPhone3 | 12 | VARCHAR | 15 | True | True | True | False | %s | |
ShippingInformationPhone4 | 12 | VARCHAR | 15 | True | True | True | False | %s | |
ShippingInformationPostalCode | 12 | VARCHAR | 10 | True | True | True | False | %s | |
ShippingInformationShipBy | 12 | VARCHAR | 50 | True | True | True | False | %s | |
ShippingInformationShipping | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
ShippingInformationState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShippingInformationStreet | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShippingInformationStreet2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
FQSaveToCache | -7 | BIT | 1 | True | True | True | False | FQSaveToCache |
TABLE DETAIL REFERENCE: SalesOrderItem
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | True | True | False | %s | |
BalanceDue | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
Cashier | 12 | VARCHAR | 40 | True | True | True | False | %s | |
CustomerListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
DepositBalance | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
Discount | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
DiscountPercent | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
Instructions | 12 | VARCHAR | 2000 | True | True | True | False | %s | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PriceLevelNumber | 12 | VARCHAR | 1 | True | True | True | False | 1 2 3 4 | |
PromoCode | 12 | VARCHAR | 10 | True | True | True | False | %s | |
Qty | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
SalesOrderNumber | 12 | VARCHAR | 32 | True | False | False | False | %11.0f | |
SalesOrderStatusDesc | 12 | VARCHAR | 50 | True | True | True | False | %s | |
SalesOrderType | 12 | VARCHAR | 10 | True | True | True | False | SalesOrder Layaway WorkOrder | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
Subtotal | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TaxAmount | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TaxCategory | 12 | VARCHAR | 20 | True | True | True | False | %s | |
TaxPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
Total | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
UnfilledPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
BillingInformationCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillingInformationCompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
BillingInformationCountry | 12 | VARCHAR | 32 | True | False | False | False | %s | |
BillingInformationFirstName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
BillingInformationLastName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
BillingInformationPhone | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationPhone2 | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationPhone3 | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationPhone4 | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationPostalCode | 12 | VARCHAR | 10 | True | False | False | False | %s | |
BillingInformationSalutation | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillingInformationStreet | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShippingInformationCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShippingInformationCompanyName | 12 | VARCHAR | 48 | True | True | True | False | %s | |
ShippingInformationCountry | 12 | VARCHAR | 32 | True | True | True | False | %s | |
ShippingInformationFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | |
ShippingInformationPhone | 12 | VARCHAR | 15 | True | True | True | False | %s | |
ShippingInformationPhone2 | 12 | VARCHAR | 15 | True | True | True | False | %s | |
ShippingInformationPhone3 | 12 | VARCHAR | 15 | True | True | True | False | %s | |
ShippingInformationPhone4 | 12 | VARCHAR | 15 | True | True | True | False | %s | |
ShippingInformationPostalCode | 12 | VARCHAR | 10 | True | True | True | False | %s | |
ShippingInformationShipBy | 12 | VARCHAR | 50 | True | True | True | False | %s | |
ShippingInformationShipping | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
ShippingInformationState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShippingInformationStreet | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShippingInformationStreet2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
SalesOrderItemSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
SalesOrderItemListID | 12 | VARCHAR | 36 | True | True | True | True | %s | |
SalesOrderItemTxnLineID | 4 | INTEGER | 4 | True | True | False | False | %11.0f | |
SalesOrderItemALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
SalesOrderItemAssociate | 12 | VARCHAR | 40 | True | True | True | False | %s | |
SalesOrderItemAttribute | 12 | VARCHAR | 12 | True | True | True | False | %s | |
SalesOrderItemCommission | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
SalesOrderItemDesc1 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
SalesOrderItemDesc2 | 12 | VARCHAR | 8000 | True | True | True | False | %s | |
SalesOrderItemDiscount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
SalesOrderItemDiscountPercent | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
SalesOrderItemDiscountType | 12 | VARCHAR | 16 | True | True | True | False | %s | |
SalesOrderItemExtendedPrice | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
SalesOrderItemExtendedTax | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
SalesOrderItemItemNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
SalesOrderItemPrice | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
SalesOrderItemPriceLevelNumber | 12 | VARCHAR | 1 | True | False | False | False | 1 2 3 4 | |
SalesOrderItemQty | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
SalesOrderItemSerialNumber | 12 | VARCHAR | 25 | True | True | True | False | %s | |
SalesOrderItemSize | 12 | VARCHAR | 8 | True | True | True | False | %s | |
SalesOrderItemTaxAmount | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
SalesOrderItemTaxCode | 12 | VARCHAR | 36 | True | True | True | False | %s | |
SalesOrderItemTaxPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
SalesOrderItemUnitOfMeasure | 12 | VARCHAR | 20 | True | True | True | False | %s | |
SalesOrderItemUPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
SalesOrderItemWebDesc | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
SalesOrderItemManufacturer | 12 | VARCHAR | 50 | True | False | False | False | %s | |
SalesOrderItemWeight | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
SalesOrderItemWebSKU | 12 | VARCHAR | 20 | True | False | False | False | %s | |
FQSaveToCache | -7 | BIT | 1 | True | True | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: SalesReceipt
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Cashier | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Comments | 12 | VARCHAR | 300 | True | False | True | False | %s | |
CustomerListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
Discount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
DiscountPercent | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
HistoryDocStatus | 12 | VARCHAR | 9 | True | False | False | False | Regular Reversed Reversing | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PriceLevelNumber | 12 | VARCHAR | 1 | True | False | True | False | 1 2 3 4 | |
PromoCode | 12 | VARCHAR | 10 | True | False | True | False | %s | |
QuickBooksFlag | 12 | VARCHAR | 17 | True | False | True | False | NotPosted Completed Error UnbilledPurchases | |
SalesOrderTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
SalesReceiptNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
SalesReceiptType | 12 | VARCHAR | 7 | True | False | True | False | Sales Return Deposit Refund Payout Payin | |
ShipDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
StoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
Subtotal | 3 | DECIMAL | 20 | True | False | False | False | %8.5f | |
TaxAmount | 3 | DECIMAL | 20 | True | False | False | False | %8.5f | |
TaxCategory | 12 | VARCHAR | 20 | True | False | True | False | %s | |
TaxPercentage | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
TenderType | 12 | VARCHAR | 12 | True | False | False | False | None Cash Check CreditCard DebitCard GiftCard Account Gift Deposit Split | |
Total | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TrackingNumber | 12 | VARCHAR | 50 | True | False | True | False | %s | |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnState | 12 | VARCHAR | 6 | True | False | True | False | Normal Held | |
Workstation | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
BillingInformationCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillingInformationCompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
BillingInformationCountry | 12 | VARCHAR | 32 | True | False | False | False | %s | |
BillingInformationFirstName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
BillingInformationLastName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
BillingInformationPhone | 12 | VARCHAR | 40 | True | False | False | False | %s | |
BillingInformationPhone2 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
BillingInformationPhone3 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
BillingInformationPhone4 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
BillingInformationPostalCode | 12 | VARCHAR | 10 | True | False | False | False | %s | |
BillingInformationSalutation | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillingInformationStreet | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShippingInformationCity | 12 | VARCHAR | 31 | True | False | True | False | %s | |
ShippingInformationCompanyName | 12 | VARCHAR | 48 | True | False | True | False | %s | |
ShippingInformationCountry | 12 | VARCHAR | 32 | True | False | True | False | %s | |
ShippingInformationFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | |
ShippingInformationPhone | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ShippingInformationPhone2 | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ShippingInformationPhone3 | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ShippingInformationPhone4 | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ShippingInformationPostalCode | 12 | VARCHAR | 10 | True | False | True | False | %s | |
ShippingInformationShipBy | 12 | VARCHAR | 50 | True | False | True | False | %s | |
ShippingInformationShipping | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
ShippingInformationState | 12 | VARCHAR | 21 | True | False | True | False | %s | |
ShippingInformationStreet | 12 | VARCHAR | 41 | True | False | True | False | %s | |
TenderAccount01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount01TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount02TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount03TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount04TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount05TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount06TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount06TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount07TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount07TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount08TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount08TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount09TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount09TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount10TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount10TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck01CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck02CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck03CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck04CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck05CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck06CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck06TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck07CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck07TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck08CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck08TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck09CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck09TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck10CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck10TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash06TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash07TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash08TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash09TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash10TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard01CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard01TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard02CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard02TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard03CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard03TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard04CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard04TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard05CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard05TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard01Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard02Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard03Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard04Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard05Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift01GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift02GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift03GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift04GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift05GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift06TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift06GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift07TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift07GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift08TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift08GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift09TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift09GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift10TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift10GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGiftCard01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard01TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard02TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard03TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard04TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard05TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache |
TABLE DETAIL REFERENCE: SalesReceiptItem
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Cashier | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Comments | 12 | VARCHAR | 300 | True | False | True | False | %s | |
CustomerListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
Discount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
DiscountPercent | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
HistoryDocStatus | 12 | VARCHAR | 9 | True | False | False | False | Regular Reversed Reversing | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PriceLevelNumber | 12 | VARCHAR | 1 | True | False | True | False | 1 2 3 4 | |
PromoCode | 12 | VARCHAR | 10 | True | False | True | False | %s | |
QuickBooksFlag | 12 | VARCHAR | 17 | True | False | True | False | NotPosted Completed Error UnbilledPurchases | |
SalesOrderTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
SalesReceiptNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
SalesReceiptType | 12 | VARCHAR | 7 | True | False | True | False | Sales Return Deposit Refund Payout Payin | |
ShipDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
StoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
Subtotal | 3 | DECIMAL | 20 | True | False | False | False | %8.5f | |
TaxAmount | 3 | DECIMAL | 20 | True | False | False | False | %8.5f | |
TaxCategory | 12 | VARCHAR | 20 | True | False | True | False | %s | |
TaxPercentage | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
TenderType | 12 | VARCHAR | 12 | True | False | False | False | None Cash Check CreditCard DebitCard GiftCard Account Gift Deposit Split | |
Total | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TrackingNumber | 12 | VARCHAR | 50 | True | False | True | False | %s | |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnState | 12 | VARCHAR | 6 | True | False | True | False | Normal Held | |
Workstation | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
BillingInformationCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillingInformationCompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
BillingInformationCountry | 12 | VARCHAR | 32 | True | False | False | False | %s | |
BillingInformationFirstName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
BillingInformationLastName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
BillingInformationPhone | 12 | VARCHAR | 40 | True | False | False | False | %s | |
BillingInformationPhone2 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
BillingInformationPhone3 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
BillingInformationPhone4 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
BillingInformationPostalCode | 12 | VARCHAR | 10 | True | False | False | False | %s | |
BillingInformationSalutation | 12 | VARCHAR | 15 | True | False | False | False | %s | |
BillingInformationState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillingInformationStreet | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShippingInformationCity | 12 | VARCHAR | 31 | True | False | True | False | %s | |
ShippingInformationCompanyName | 12 | VARCHAR | 48 | True | False | True | False | %s | |
ShippingInformationCountry | 12 | VARCHAR | 32 | True | False | True | False | %s | |
ShippingInformationFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | |
ShippingInformationPhone | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ShippingInformationPhone2 | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ShippingInformationPhone3 | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ShippingInformationPhone4 | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ShippingInformationPostalCode | 12 | VARCHAR | 10 | True | False | True | False | %s | |
ShippingInformationShipBy | 12 | VARCHAR | 50 | True | False | True | False | %s | |
ShippingInformationShipping | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
ShippingInformationState | 12 | VARCHAR | 21 | True | False | True | False | %s | |
ShippingInformationStreet | 12 | VARCHAR | 41 | True | False | True | False | %s | |
SalesReceiptItemSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
SalesReceiptItemListID | 12 | VARCHAR | 36 | False | False | True | False | %s | |
SalesReceiptItemALU | 12 | VARCHAR | 20 | False | False | True | False | %s | |
SalesReceiptItemAssociate | 12 | VARCHAR | 40 | False | False | True | False | %s | |
SalesReceiptItemAttribute | 12 | VARCHAR | 8 | False | False | True | False | %s | |
SalesReceiptItemCommission | 3 | DECIMAL | 16 | False | False | True | False | %8.5f | |
SalesReceiptItemCost | 3 | DECIMAL | 18 | True | False | False | False | %8.5f | |
SalesReceiptItemDesc1 | 12 | VARCHAR | 30 | False | False | True | False | %s | |
SalesReceiptItemDesc2 | 12 | VARCHAR | 8000 | False | False | True | False | %s | |
SalesReceiptItemDiscount | 3 | DECIMAL | 20 | False | False | True | False | %8.5f | |
SalesReceiptItemDiscountPercent | 3 | DECIMAL | 13 | False | False | True | False | %8.2f | |
SalesReceiptItemDiscountType | 12 | VARCHAR | 16 | False | False | True | False | %s | |
SalesReceiptItemExtendedPrice | 3 | DECIMAL | 20 | False | False | True | False | %8.5f | |
SalesReceiptItemExtendedTax | 3 | DECIMAL | 20 | False | False | True | False | %8.5f | |
SalesReceiptItemPrice | 3 | DECIMAL | 16 | False | False | True | False | %8.5f | |
SalesReceiptItemQty | 3 | DECIMAL | 15 | False | False | True | False | %7.5f | |
SalesReceiptItemSerialNumber | 12 | VARCHAR | 25 | False | False | True | False | %s | |
SalesReceiptItemSize | 12 | VARCHAR | 8 | False | False | True | False | %s | |
SalesReceiptItemTaxAmount | 3 | DECIMAL | 20 | False | False | True | False | %8.5f | |
SalesReceiptItemTaxCode | 12 | VARCHAR | 100 | False | False | True | False | %s | |
SalesReceiptItemUnitOfMeasure | 12 | VARCHAR | 20 | True | False | True | False | %s | |
SalesReceiptItemUPC | 12 | VARCHAR | 18 | False | False | True | False | %s | |
SalesReceiptItemWebDesc | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
SalesReceiptItemManufacturer | 12 | VARCHAR | 50 | True | False | True | False | %s | |
SalesReceiptItemWeight | 3 | DECIMAL | 15 | True | False | True | False | %7.5f | |
SalesReceiptItemWebSKU | 12 | VARCHAR | 20 | True | False | True | False | %s | |
TenderAccount01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount01TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount02TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount03TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount04TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount05TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount06TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount06TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount07TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount07TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount08TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount08TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount09TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount09TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount10TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderAccount10TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck01CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck02CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck03CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck04CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck05CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck06CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck06TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck07CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck07TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck08CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck08TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck09CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck09TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCheck10CheckNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderCheck10TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash06TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash07TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash08TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash09TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCash10TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard01CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard01TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard02CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard02TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard03CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard03TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard04CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard04TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard05CardName | 12 | VARCHAR | 16 | True | False | True | False | %s | |
TenderCreditCard05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderCreditCard05TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard01Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard02Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard03Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard04Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard05Cashback | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDebitCard05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderDeposit05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift01GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift02GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift03GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift04GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift05GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift06TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift06GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift07TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift07GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift08TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift08GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift09TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift09GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGift10TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGift10GiftCertificateNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
TenderGiftCard01TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard01TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard02TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard02TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard03TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard03TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard04TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard04TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard05TenderAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
TenderGiftCard05TipAmount | 3 | DECIMAL | 20 | True | False | True | False | %8.5f | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: TimeEntry
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
ClockInTime | 11 | TIMESTAMP | 16 | True | True | True | False | CCCC-MM-DDThh:mm:ssZ | |
ClockOutTime | 11 | TIMESTAMP | 16 | True | True | True | False | CCCC-MM-DDThh:mm:ssZ | |
CreatedBy | 12 | VARCHAR | 40 | True | True | True | False | %s | |
EmployeeListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
EmployeeLoginName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
FirstName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
LastName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
QuickBooksFlag | 12 | VARCHAR | 30 | True | False | True | True | %s | |
StoreNumber | 4 | INTEGER | 4 | True | True | True | True | %11.0f |
TABLE DETAIL REFERENCE: TransferSlip
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Carrier | 12 | VARCHAR | 15 | True | False | True | False | %s | |
Comments | 12 | VARCHAR | 300 | True | False | True | False | %s | |
Freight | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
FromStoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
HistoryDocStatus | 12 | VARCHAR | 9 | True | False | False | False | Regular Reversed Reversing | |
QuickBooksFlag | 12 | VARCHAR | 17 | True | False | True | False | NotPosted Completed Error UnbilledPurchases | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
SlipETA | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
SlipNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
ToStoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
TotalCost | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
TotalQty | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnState | 12 | VARCHAR | 6 | True | False | True | False | Normal Held | |
Workstation | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache |
TABLE DETAIL REFERENCE: TransferSlipItem
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Carrier | 12 | VARCHAR | 15 | True | False | True | False | %s | |
Comments | 12 | VARCHAR | 300 | True | False | True | False | %s | |
Freight | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
FromStoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
HistoryDocStatus | 12 | VARCHAR | 9 | True | False | False | False | Regular Reversed Reversing | |
QuickBooksFlag | 12 | VARCHAR | 17 | True | False | True | False | NotPosted Completed Error UnbilledPurchases | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
SlipETA | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
SlipNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
ToStoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
TotalCost | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
TotalQty | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnState | 12 | VARCHAR | 6 | True | False | True | False | Normal Held | |
Workstation | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
TransferSlipItemSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
TransferSlipItemListID | 12 | VARCHAR | 36 | True | False | True | True | %s | |
TransferSlipItemQty | 3 | DECIMAL | 15 | True | False | True | False | %7.5f | |
TransferSlipItemSerialNumber | 12 | VARCHAR | 25 | True | False | True | False | %s | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Vendor
(POS VERSION)
TABLE DETAIL REFERENCE: Voucher
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Comments | 12 | VARCHAR | 300 | True | False | True | False | %s | |
CompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
Discount | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
DiscountPercent | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
Fee | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
Freight | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
HistoryDocStatus | 12 | VARCHAR | 9 | True | False | True | False | Regular Reversed Reversing | |
InvoiceDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
InvoiceDueDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
InvoiceNumber | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PayeeCode | 12 | VARCHAR | 15 | True | False | True | False | %s | |
PayeeListID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
PayeeName | 12 | VARCHAR | 26 | True | False | False | False | %s | |
PurchaseOrderNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
PurchaseOrderTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
QuickBooksFlag | 12 | VARCHAR | 17 | True | False | True | False | NotPosted Completed Error UnbilledPurchases | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
StoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
Subtotal | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TermsDiscount | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
TermsDiscountDays | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
TermsNetDays | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
Total | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TotalQty | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnState | 12 | VARCHAR | 6 | True | False | True | False | Normal Held | |
VendorCode | 12 | VARCHAR | 3 | True | False | True | False | %s | |
VendorListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
VoucherNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
VoucherType | 12 | VARCHAR | 9 | True | False | True | False | Receiving Return | |
Workstation | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache |
TABLE DETAIL REFERENCE: VoucherItem
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
Associate | 12 | VARCHAR | 40 | True | False | True | False | %s | |
Comments | 12 | VARCHAR | 300 | True | False | True | False | %s | |
CompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
Discount | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
DiscountPercent | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
Fee | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
Freight | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
HistoryDocStatus | 12 | VARCHAR | 9 | True | False | True | False | Regular Reversed Reversing | |
InvoiceDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
InvoiceDueDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
InvoiceNumber | 12 | VARCHAR | 15 | True | False | True | False | %s | |
ItemsCount | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PayeeCode | 12 | VARCHAR | 15 | True | False | True | False | %s | |
PayeeListID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
PayeeName | 12 | VARCHAR | 26 | True | False | False | False | %s | |
PurchaseOrderNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
PurchaseOrderTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
QuickBooksFlag | 12 | VARCHAR | 17 | True | False | True | False | NotPosted Completed Error UnbilledPurchases | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
StoreNumber | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
Subtotal | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TermsDiscount | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
TermsDiscountDays | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
TermsNetDays | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
Total | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
TotalQty | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnState | 12 | VARCHAR | 6 | True | False | True | False | Normal Held | |
VendorCode | 12 | VARCHAR | 3 | True | False | True | False | %s | |
VendorListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
VoucherNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
VoucherType | 12 | VARCHAR | 9 | True | False | True | False | Receiving Return | |
Workstation | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
VoucherItemSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
VoucherItemListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
VoucherItemALU | 12 | VARCHAR | 20 | True | False | True | False | %s | |
VoucherItemAttribute | 12 | VARCHAR | 8 | True | False | True | False | %s | |
VoucherItemCost | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
VoucherItemDesc1 | 12 | VARCHAR | 30 | True | False | True | False | %s | |
VoucherItemDesc2 | 12 | VARCHAR | 8000 | True | False | True | False | %s | |
VoucherItemExtendedCost | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
VoucherItemItemNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
VoucherItemNumberOfBaseUnits | 3 | DECIMAL | 15 | True | False | True | False | %7.5f | |
VoucherItemQtyReceived | 3 | DECIMAL | 15 | True | False | True | False | %7.5f | |
VoucherItemSerialNumber | 12 | VARCHAR | 25 | True | False | True | False | %s | |
VoucherItemSize | 12 | VARCHAR | 8 | True | False | True | False | %s | |
VoucherItemUnitOfMeasure | 12 | VARCHAR | 20 | True | False | True | False | %s | |
VoucherItemUPC | 12 | VARCHAR | 18 | True | False | True | False | %s | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |