TABLE DETAIL REFERENCE: Company
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
Id4 INTEGER 4TrueFalseFalseFalseFQID
IsSampleCompany-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CompanyName12 VARCHAR 100TrueFalseFalseFalse%s
AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Misc112 VARCHAR 100TrueFalseFalseFalse%s
Misc212 VARCHAR 100TrueFalseFalseFalse%s
Misc312 VARCHAR 100TrueFalseFalseFalse%s
QuickBooksCompanyFile12 VARCHAR 500TrueFalseFalseFalse%s
StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store01StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store01StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store01StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store01AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store01CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store01Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store01Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store01Misc312 VARCHAR 100TrueFalseFalseFalse%s
Store02StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store02StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store02StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store02AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store02CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store02Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store02Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store02Misc312 VARCHAR 100TrueFalseFalseFalse%s
Store03StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store03StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store03StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store03AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store03CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store03Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store03Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store03Misc312 VARCHAR 100TrueFalseFalseFalse%s
Store04StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store04StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store04StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store04AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store04CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store04Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store04Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store04Misc312 VARCHAR 100TrueFalseFalseFalse%s
Store05StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store05StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store05StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store05AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store05CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store05Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store05Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store05Misc312 VARCHAR 100TrueFalseFalseFalse%s
Store06StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store06StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store06StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store06AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store06CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store06Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store06Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store06Misc312 VARCHAR 100TrueFalseFalseFalse%s
Store07StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store07StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store07StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store07AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store07CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store07Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store07Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store07Misc312 VARCHAR 100TrueFalseFalseFalse%s
Store08StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store08StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store08StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store08AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store08CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store08Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store08Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store08Misc312 VARCHAR 100TrueFalseFalseFalse%s
Store09StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store09StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store09StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store09AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store09CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store09Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store09Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store09Misc312 VARCHAR 100TrueFalseFalseFalse%s
Store10StoreNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
Store10StoreCode12 VARCHAR 13TrueFalseFalseFalse%s
Store10StoreName12 VARCHAR 100TrueFalseFalseFalse%s
Store10AddressStreet12 VARCHAR 100TrueFalseFalseFalse%s
Store10CityStateZIP12 VARCHAR 100TrueFalseFalseFalse%s
Store10Misc112 VARCHAR 100TrueFalseFalseFalse%s
Store10Misc212 VARCHAR 100TrueFalseFalseFalse%s
Store10Misc312 VARCHAR 100TrueFalseFalseFalse%s
PriceLevel1Name12 VARCHAR 100TrueFalseFalseFalse%s
PriceLevel1Markdown3 DECIMAL 15TrueFalseFalseFalse%7.5f
PriceLevel2Name12 VARCHAR 100TrueFalseFalseFalse%s
PriceLevel2Markdown3 DECIMAL 15TrueFalseFalseFalse%7.5f
PriceLevel3Name12 VARCHAR 100TrueFalseFalseFalse%s
PriceLevel3Markdown3 DECIMAL 15TrueFalseFalseFalse%7.5f
PriceLevel4Name412 VARCHAR 100TrueFalseFalseFalse%s
PriceLevel4Markdown3 DECIMAL 15TrueFalseFalseFalse%7.5f
PurchaseOrderStatusInfoStatusType12 VARCHAR 6TrueFalseFalseFalse
Open
Closed
Custom
PurchaseOrderStatusInfoStatusDescription12 VARCHAR 100TrueFalseFalseFalse%s
LayawayStatusInfoStatusType12 VARCHAR 6TrueFalseFalseFalse
Open
Closed
Custom
LayawayStatusInfoStatusDescription12 VARCHAR 100TrueFalseFalseFalse%s
SalesOrderStatusInfoStatusType12 VARCHAR 6TrueFalseFalseFalse
Open
Closed
Custom
SalesOrderStatusInfoStatusDescription12 VARCHAR 100TrueFalseFalseFalse%s
WorkOrderStatusInfoStatusType12 VARCHAR 6TrueFalseFalseFalse
Open
Closed
Custom
WorkOrderStatusInfoStatusDescription12 VARCHAR 100TrueFalseFalseFalse%s
TABLE DETAIL REFERENCE: Customer
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
AccountBalance3 DECIMAL 16TrueFalseFalseFalse%8.5f
AccountLimit3 DECIMAL 16TrueFalseFalseFalse%8.5f
AmountPastDue3 DECIMAL 16TrueFalseFalseFalse%8.5f
CompanyName12 VARCHAR 48TrueTrueTrueFalse%s
CustomerDiscPercent3 DECIMAL 13TrueTrueTrueFalse%8.2f
CustomerDiscType12 VARCHAR 10TrueTrueTrueFalse
None
PriceLevel
Percentage
CustomerType12 VARCHAR 15TrueTrueTrueFalse%s
CustomerID12 VARCHAR 41TrueTrueTrueFalse%s
DefaultShipAddress12 VARCHAR 20TrueTrueTrueFalse%s
EMail12 VARCHAR 99TrueTrueTrueFalse%s
FirstName12 VARCHAR 30TrueTrueTrueFalse%s
FullName12 VARCHAR 200TrueFalseFalseFalse%s
IsAcceptingChecks-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsNoShipToBilling-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsOkToEMail-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsRewardsMember-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsUsingChargeAccount-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsUsingWithQB-7 BIT 1TrueTrueTrueFalse
1
0
true
false
LastName12 VARCHAR 30TrueTrueTrueTrue%s
LastSale9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
Notes12 VARCHAR 245TrueTrueTrueFalse%s
Phone12 VARCHAR 40TrueTrueTrueFalse%s
Phone212 VARCHAR 40TrueTrueTrueFalse%s
Phone312 VARCHAR 40TrueTrueTrueFalse%s
Phone412 VARCHAR 40TrueTrueTrueFalse%s
PriceLevelNumber12 VARCHAR 1TrueTrueTrueFalse
1
2
3
4
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
TaxCategory12 VARCHAR 20TrueTrueTrueFalse%s
WebNumber12 VARCHAR 20TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressStreet12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressStreet212 VARCHAR 41TrueTrueTrueFalse%s
CustomFieldOther12 VARCHAR 30TrueFalseFalseFalse%s
CustomFieldSalesLocation12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSerial12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSerial112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSerial212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CustomerReward
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
AccountBalance3 DECIMAL 16TrueFalseFalseFalse%8.5f
AccountLimit3 DECIMAL 16TrueFalseFalseFalse%8.5f
AmountPastDue3 DECIMAL 16TrueFalseFalseFalse%8.5f
CompanyName12 VARCHAR 48TrueFalseFalseFalse%s
CustomerDiscPercent3 DECIMAL 13TrueFalseFalseFalse%8.2f
CustomerDiscType12 VARCHAR 10TrueFalseFalseFalse
None
PriceLevel
Percentage
CustomerType12 VARCHAR 15TrueFalseFalseFalse%s
CustomerID12 VARCHAR 41TrueFalseFalseFalse%s
DefaultShipAddress12 VARCHAR 20TrueFalseFalseFalse%s
EMail12 VARCHAR 99TrueFalseFalseFalse%s
FirstName12 VARCHAR 30TrueFalseFalseFalse%s
FullName12 VARCHAR 200TrueFalseFalseFalse%s
IsAcceptingChecks-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsNoShipToBilling-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsOkToEMail-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsRewardsMember-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsUsingChargeAccount-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsUsingWithQB-7 BIT 1TrueFalseFalseFalse
1
0
true
false
LastName12 VARCHAR 30TrueFalseFalseTrue%s
LastSale9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
Notes12 VARCHAR 245TrueFalseFalseFalse%s
Phone12 VARCHAR 40TrueFalseFalseFalse%s
Phone212 VARCHAR 40TrueFalseFalseFalse%s
Phone312 VARCHAR 40TrueFalseFalseFalse%s
Phone412 VARCHAR 40TrueFalseFalseFalse%s
PriceLevelNumber12 VARCHAR 1TrueFalseFalseFalse
1
2
3
4
Salutation12 VARCHAR 15TrueFalseFalseFalse%s
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
TaxCategory12 VARCHAR 20TrueFalseFalseFalse%s
WebNumber12 VARCHAR 20TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressStreet12 VARCHAR 41TrueFalseFalseFalse%s
BillAddressStreet212 VARCHAR 41TrueFalseFalseFalse%s
RewardSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
RewardAmount3 DECIMAL 16TrueFalseFalseFalse%8.5f
RewardPercent3 DECIMAL 13TrueFalseFalseFalse%8.2f
RewardEarnedDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
RewardMatureDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
RewardExpirationDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
RewardStatus12 VARCHAR 10TrueFalseFalseFalse
Available
Removed
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldOther12 VARCHAR 30TrueFalseFalseFalse%s
CustomFieldSalesLocation12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSerial12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSerial112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSerial212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CustomerShipAddress
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
AccountBalance3 DECIMAL 16TrueFalseFalseFalse%8.5f
AccountLimit3 DECIMAL 16TrueFalseFalseFalse%8.5f
AmountPastDue3 DECIMAL 16TrueFalseFalseFalse%8.5f
CompanyName12 VARCHAR 48TrueTrueTrueFalse%s
CustomerDiscPercent3 DECIMAL 13TrueTrueTrueFalse%8.2f
CustomerDiscType12 VARCHAR 10TrueTrueTrueFalse
None
PriceLevel
Percentage
CustomerType12 VARCHAR 15TrueTrueTrueFalse%s
CustomerID12 VARCHAR 41TrueTrueTrueFalse%s
DefaultShipAddress12 VARCHAR 20TrueTrueTrueFalse%s
EMail12 VARCHAR 99TrueTrueTrueFalse%s
FirstName12 VARCHAR 30TrueTrueTrueFalse%s
FullName12 VARCHAR 200TrueFalseFalseFalse%s
IsAcceptingChecks-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsNoShipToBilling-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsOkToEMail-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsRewardsMember-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsUsingChargeAccount-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsUsingWithQB-7 BIT 1TrueTrueTrueFalse
1
0
true
false
LastName12 VARCHAR 30TrueTrueTrueTrue%s
LastSale9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
Notes12 VARCHAR 245TrueTrueTrueFalse%s
Phone12 VARCHAR 40TrueTrueTrueFalse%s
Phone212 VARCHAR 40TrueTrueTrueFalse%s
Phone312 VARCHAR 40TrueTrueTrueFalse%s
Phone412 VARCHAR 40TrueTrueTrueFalse%s
PriceLevelNumber12 VARCHAR 1TrueTrueTrueFalse
1
2
3
4
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
TaxCategory12 VARCHAR 20TrueTrueTrueFalse%s
WebNumber12 VARCHAR 20TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressStreet12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressStreet212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ShipAddressAddressName12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressCompanyName12 VARCHAR 48TrueTrueTrueFalse%s
ShipAddressFullName12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressStreet12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressStreet212 VARCHAR 41TrueTrueTrueFalse%s
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldOther12 VARCHAR 30TrueFalseFalseFalse%s
CustomFieldSalesLocation12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSerial12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSerial112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSerial212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CustomField
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
OwnerID12 VARCHAR 50TrueFalseTrueFalse%s
Name12 VARCHAR 31TrueFalseTrueFalse%s
EntityType12 VARCHAR 23TrueFalseTrueFalse
Customer
Vendor
Employee
OtherName
Item
Account
EntityRefListID12 VARCHAR 36TrueFalseTrueFalse%s
OtherType12 VARCHAR 7TrueFalseTrueFalse
Company
Value12 VARCHAR 4095TrueFalseTrueFalse
TABLE DETAIL REFERENCE: Department
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
DefaultMarginPercent4 INTEGER 4TrueTrueTrueFalse%11.0f
DefaultMarkupPercent4 INTEGER 4TrueTrueTrueFalse%11.0f
DepartmentCode12 VARCHAR 3TrueTrueTrueTrue%s
DepartmentName12 VARCHAR 30TrueTrueTrueTrue%s
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
TaxCode12 VARCHAR 100TrueTrueTrueTrue%s
TABLE DETAIL REFERENCE: Employee
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
City12 VARCHAR 31TrueTrueTrueFalse%s
CommissionPercent3 DECIMAL 15TrueTrueTrueFalse%7.5f
Country12 VARCHAR 31TrueTrueTrueFalse%s
Email12 VARCHAR 99TrueTrueTrueFalse%s
FirstName12 VARCHAR 30TrueTrueTrueFalse%s
LastName12 VARCHAR 30TrueTrueTrueFalse%s
LoginName12 VARCHAR 20TrueTrueTrueTrue%s
Notes12 VARCHAR 245TrueTrueTrueFalse%s
Phone12 VARCHAR 40TrueTrueTrueFalse%s
Phone212 VARCHAR 40TrueTrueTrueFalse%s
Phone312 VARCHAR 40TrueTrueTrueFalse%s
Phone412 VARCHAR 40TrueTrueTrueFalse%s
PostalCode12 VARCHAR 13TrueTrueTrueFalse%s
State12 VARCHAR 21TrueTrueTrueFalse%s
Street12 VARCHAR 41TrueTrueTrueFalse%s
CustomFieldOther12 VARCHAR 30TrueFalseFalseFalse%s
TABLE DETAIL REFERENCE: InventoryCostAdjustment
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
CostDifference3 DECIMAL 16TrueFalseFalseFalse%8.5f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
InventoryAdjustmentNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
InventoryAdjustmentSource12 VARCHAR 17TrueFalseTrueFalse
Manual
PhysicalInventory
Assembly
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
NewCost3 DECIMAL 16TrueFalseFalseFalse%8.5f
OldCost3 DECIMAL 16TrueFalseFalseFalse%8.5f
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
Reason12 VARCHAR 8TrueFalseTrueFalse%s
StoreExchangeStatus12 VARCHAR 17TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
TABLE DETAIL REFERENCE: InventoryCostAdjustmentItem
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
CostDifference3 DECIMAL 16TrueFalseFalseFalse%8.5f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
InventoryAdjustmentNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
InventoryAdjustmentSource12 VARCHAR 17TrueFalseTrueFalse
Manual
PhysicalInventory
Assembly
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
NewCost3 DECIMAL 16TrueFalseFalseFalse%8.5f
OldCost3 DECIMAL 16TrueFalseFalseFalse%8.5f
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
Reason12 VARCHAR 8TrueFalseTrueFalse%s
StoreExchangeStatus12 VARCHAR 17TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
InventoryCostAdjustmentItemSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
InventoryCostAdjustmentItemListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
InventoryCostAdjustmentItemCostDifference3 DECIMAL 16TrueFalseFalseFalse%8.5f
InventoryCostAdjustmentItemNewCost3 DECIMAL 16TrueFalseTrueFalse%8.5f
InventoryCostAdjustmentItemOldCost3 DECIMAL 16TrueFalseFalseFalse%8.5f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: InventoryQtyAdjustment
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
CostDifference3 DECIMAL 16TrueFalseFalseFalse%8.5f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
InventoryAdjustmentNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
InventoryAdjustmentSource12 VARCHAR 17TrueFalseTrueFalse
Manual
PhysicalInventory
Assembly
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
NewQuantity3 DECIMAL 15TrueFalseFalseFalse%7.5f
OldQuantity3 DECIMAL 15TrueFalseFalseFalse%7.5f
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
Reason12 VARCHAR 8TrueFalseTrueFalse%s
StoreExchangeStatus12 VARCHAR 17TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
TABLE DETAIL REFERENCE: InventoryQtyAdjustmentItem
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
CostDifference3 DECIMAL 16TrueFalseFalseFalse%8.5f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
InventoryAdjustmentNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
InventoryAdjustmentSource12 VARCHAR 17TrueFalseTrueFalse
Manual
PhysicalInventory
Assembly
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
NewQuantity3 DECIMAL 15TrueFalseFalseFalse%7.5f
OldQuantity3 DECIMAL 15TrueFalseFalseFalse%7.5f
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
Reason12 VARCHAR 8TrueFalseTrueFalse%s
StoreExchangeStatus12 VARCHAR 17TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
InventoryQtyAdjustmentItemSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
InventoryQtyAdjustmentItemListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
InventoryQtyAdjustmentItemNewQuantity3 DECIMAL 16TrueFalseTrueFalse%8.5f
InventoryQtyAdjustmentItemOldQuantity3 DECIMAL 16TrueFalseFalseFalse%8.5f
InventoryQtyAdjustmentItemQtyDifference3 DECIMAL 16TrueFalseFalseFalse%8.5f
InventoryQtyAdjustmentItemSerialNumber12 VARCHAR 25TrueFalseTrueFalse%s
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: ItemInventory
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
ALU12 VARCHAR 20TrueTrueTrueFalse%s
Attribute12 VARCHAR 8TrueTrueTrueFalse%s
COGSAccount12 VARCHAR 159TrueTrueTrueFalse%s
Cost3 DECIMAL 16TrueTrueTrueFalse%8.5f
DepartmentCode12 VARCHAR 3TrueTrueTrueFalse%s
DepartmentListID12 VARCHAR 36TrueTrueTrueFalse%s
Desc112 VARCHAR 30TrueTrueTrueFalse%s
Desc212 VARCHAR 8000TrueTrueTrueFalse%s
IncomeAccount12 VARCHAR 159TrueTrueTrueFalse%s
IsBelowReorder-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsEligibleForCommission-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsPrintingTags-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsUnorderable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ItemNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
ItemType12 VARCHAR 13TrueTrueTrueFalse
Inventory
Non-Inventory
Service
Assembly
Group
SpecialOrder
Keywords12 VARCHAR 18TrueTrueTrueFalse%s
LastReceived9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
MarginPercent4 INTEGER 4TrueTrueTrueFalse%11.0f
MarkupPercent4 INTEGER 4TrueTrueTrueFalse%11.0f
MSRP3 DECIMAL 16TrueTrueTrueFalse%8.5f
OnHandStore013 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore023 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore033 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore043 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore053 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore063 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore073 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore083 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore093 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore103 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore113 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore123 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore133 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore143 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore153 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore163 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore173 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore183 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore193 DECIMAL 15TrueTrueTrueFalse%7.5f
OnHandStore203 DECIMAL 15TrueTrueTrueFalse%7.5f
OrderByUnit12 VARCHAR 20TrueTrueTrueFalse%s
OrderCost3 DECIMAL 16TrueTrueTrueFalse%8.5f
Price13 DECIMAL 16TrueTrueTrueFalse%8.5f
Price23 DECIMAL 16TrueTrueTrueFalse%8.5f
Price33 DECIMAL 16TrueTrueTrueFalse%8.5f
Price43 DECIMAL 16TrueTrueTrueFalse%8.5f
Price53 DECIMAL 16TrueTrueTrueFalse%8.5f
QuantityOnCustomerOrder3 DECIMAL 15TrueTrueTrueFalse%7.5f
QuantityOnHand3 DECIMAL 15TrueTrueTrueFalse%7.5f
QuantityOnOrder3 DECIMAL 15TrueTrueTrueFalse%7.5f
QuantityOnPendingOrder3 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPoint3 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore013 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore023 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore033 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore043 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore053 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore063 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore073 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore083 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore093 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore103 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore113 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore123 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore133 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore143 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore153 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore163 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore173 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore183 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore193 DECIMAL 15TrueTrueTrueFalse%7.5f
ReorderPointStore203 DECIMAL 15TrueTrueTrueFalse%7.5f
SellByUnit12 VARCHAR 20TrueTrueTrueFalse%s
SerialFlag12 VARCHAR 8TrueTrueTrueFalse
Optional
Prompt
Size12 VARCHAR 12TrueTrueTrueFalse%s
StoreExchangeStatus12 VARCHAR 12TrueTrueTrueFalse
Modified
Sent
Acknowledged
TaxCode12 VARCHAR 36TrueTrueTrueFalse%s
UnitOfMeasure12 VARCHAR 20TrueTrueTrueFalse%s
UPC12 VARCHAR 18TrueTrueTrueFalse%s
VendorCode12 VARCHAR 3TrueTrueTrueFalse%s
VendorListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
WebDesc12 VARCHAR 18TrueTrueTrueFalse%s
WebPrice3 DECIMAL 16TrueTrueTrueFalse%8.5f
Manufacturer12 VARCHAR 50TrueTrueTrueFalse%s
Weight3 DECIMAL 15TrueTrueTrueFalse%7.5f
WebSKU12 VARCHAR 18TrueTrueTrueFalse%s
WebCategories12 VARCHAR 18TrueTrueTrueFalse%s
UnitOfMeasure1ALU12 VARCHAR 20TrueTrueTrueFalse%s
UnitOfMeasure1MSRP3 DECIMAL 13TrueTrueTrueFalse%7.5f
UnitOfMeasure1NumberOfBaseUnits3 DECIMAL 15TrueTrueTrueFalse%7.5f
UnitOfMeasure1Price13 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure1Price23 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure1Price33 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure1Price43 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure1Price53 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure1UnitOfMeasure12 VARCHAR 20TrueTrueTrueFalse%s
UnitOfMeasure1UPC12 VARCHAR 20TrueTrueTrueFalse%s
UnitOfMeasure2ALU12 VARCHAR 20TrueTrueTrueFalse%s
UnitOfMeasure2MSRP3 DECIMAL 13TrueTrueTrueFalse%7.5f
UnitOfMeasure2NumberOfBaseUnits3 DECIMAL 15TrueTrueTrueFalse%7.5f
UnitOfMeasure2Price13 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure2Price23 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure2Price33 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure2Price43 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure2Price53 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure2UnitOfMeasure12 VARCHAR 20TrueTrueTrueFalse%s
UnitOfMeasure2UPC12 VARCHAR 20TrueTrueTrueFalse%s
UnitOfMeasure3ALU12 VARCHAR 20TrueTrueTrueFalse%s
UnitOfMeasure3MSRP3 DECIMAL 13TrueTrueTrueFalse%7.5f
UnitOfMeasure3NumberOfBaseUnits3 DECIMAL 15TrueTrueTrueFalse%7.5f
UnitOfMeasure3Price13 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure3Price23 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure3Price33 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure3Price43 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure3Price53 DECIMAL 16TrueTrueTrueFalse%8.5f
UnitOfMeasure3UnitOfMeasure12 VARCHAR 20TrueTrueTrueFalse%s
UnitOfMeasure3UPC12 VARCHAR 20TrueTrueTrueFalse%s
VendorInfo2ALU12 VARCHAR 20TrueTrueTrueFalse%s
VendorInfo2OrderCost3 DECIMAL 16TrueTrueTrueFalse%8.5f
VendorInfo2UPC12 VARCHAR 18TrueTrueTrueFalse%s
VendorInfo2VendorListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorInfo3ALU12 VARCHAR 20TrueTrueTrueFalse%s
VendorInfo3OrderCost3 DECIMAL 16TrueTrueTrueFalse%8.5f
VendorInfo3UPC12 VARCHAR 18TrueTrueTrueFalse%s
VendorInfo3VendorListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorInfo4ALU12 VARCHAR 20TrueTrueTrueFalse%s
VendorInfo4OrderCost3 DECIMAL 16TrueTrueTrueFalse%8.5f
VendorInfo4UPC12 VARCHAR 18TrueTrueTrueFalse%s
VendorInfo4VendorListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorInfo5ALU12 VARCHAR 20TrueTrueTrueFalse%s
VendorInfo5OrderCost3 DECIMAL 16TrueTrueTrueFalse%8.5f
VendorInfo5UPC12 VARCHAR 18TrueTrueTrueFalse%s
VendorInfo5VendorListID12 VARCHAR 36TrueTrueTrueFalse%s
CustomFieldAlternateLoc112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldAlternateLoc212 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldAlternateLoc312 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCatagory12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldPrimaryLocation12 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: ListDeleted
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListDelType12 VARCHAR 20TrueFalseFalseFalse
Customer
Department
Employee
ItemInventory
PurchaseOrder
SalesOrder
TimeEntry
Vendor
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeDeleted11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TABLE DETAIL REFERENCE: PurchaseOrder
(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
CancelDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
CompanyName12 VARCHAR 48TrueFalseFalseFalse%s
Discount3 DECIMAL 16TrueTrueTrueFalse%8.5f
DiscountPercent3 DECIMAL 13TrueTrueTrueFalse%8.2f
Fee3 DECIMAL 16TrueTrueTrueFalse%8.5f
Instructions12 VARCHAR 2000TrueTrueTrueFalse%s
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
PurchaseOrderNumber12 VARCHAR 20TrueTrueTrueFalse%s
PurchaseOrderStatusDesc12 VARCHAR 200TrueTrueTrueFalse%s
QtyDue3 DECIMAL 15TrueFalseFalseFalse%7.5f
QtyOrdered3 DECIMAL 15TrueFalseFalseFalse%7.5f
QtyReceived3 DECIMAL 15TrueFalseFalseFalse%7.5f
SalesOrderNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
StartShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueTrueTrueFalse%11.0f
Subtotal3 DECIMAL 16TrueFalseFalseFalse%8.5f
Terms12 VARCHAR 200TrueFalseFalseFalse%s
TermsDiscount3 DECIMAL 13TrueTrueTrueFalse%8.2f
TermsDiscountDays4 INTEGER 4TrueTrueTrueFalse%11.0f
TermsNetDays4 INTEGER 4TrueTrueTrueFalse%11.0f
Total3 DECIMAL 16TrueFalseFalseFalse%8.5f
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
UnfilledPercent3 DECIMAL 13TrueFalseFalseFalse%8.2f
VendorCode12 VARCHAR 3TrueFalseFalseFalse%s
VendorListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
CustomFieldOther112 VARCHAR 30TrueFalseFalseFalse%s
CustomFieldOther212 VARCHAR 30TrueFalseFalseFalse%s
TABLE DETAIL REFERENCE: PurchaseOrderItem
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueTrueTrueFalse%s
CancelDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
CompanyName12 VARCHAR 48TrueFalseFalseFalse%s
Discount3 DECIMAL 16TrueTrueTrueFalse%8.5f
DiscountPercent3 DECIMAL 13TrueTrueTrueFalse%8.2f
Fee3 DECIMAL 16TrueTrueTrueFalse%8.5f
Instructions12 VARCHAR 2000TrueTrueTrueFalse%s
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
PurchaseOrderNumber12 VARCHAR 20TrueTrueTrueFalse%s
PurchaseOrderStatusDesc12 VARCHAR 200TrueTrueTrueFalse%s
QtyDue3 DECIMAL 15TrueFalseFalseFalse%7.5f
QtyOrdered3 DECIMAL 15TrueFalseFalseFalse%7.5f
QtyReceived3 DECIMAL 15TrueFalseFalseFalse%7.5f
SalesOrderNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
StartShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueTrueTrueFalse%11.0f
Subtotal3 DECIMAL 16TrueFalseFalseFalse%8.5f
Terms12 VARCHAR 200TrueFalseFalseFalse%s
TermsDiscount3 DECIMAL 13TrueTrueTrueFalse%8.2f
TermsDiscountDays4 INTEGER 4TrueTrueTrueFalse%11.0f
TermsNetDays4 INTEGER 4TrueTrueTrueFalse%11.0f
Total3 DECIMAL 16TrueFalseFalseFalse%8.5f
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
UnfilledPercent3 DECIMAL 13TrueFalseFalseFalse%8.2f
VendorCode12 VARCHAR 3TrueFalseFalseFalse%s
VendorListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
PurchaseOrderItemSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
PurchaseOrderItemListID12 VARCHAR 36TrueTrueTrueFalse%s
PurchaseOrderItemTxnLineID4 INTEGER 4TrueTrueFalseFalse%11.0f
PurchaseOrderItemALU12 VARCHAR 20TrueTrueTrueFalse%s
PurchaseOrderItemAttribute12 VARCHAR 8TrueTrueTrueFalse%s
PurchaseOrderItemCost3 DECIMAL 16TrueTrueTrueFalse%8.5f
PurchaseOrderItemDesc112 VARCHAR 30TrueTrueTrueFalse%s
PurchaseOrderItemDesc212 VARCHAR 8000TrueTrueTrueFalse%s
PurchaseOrderItemExtendedCost3 DECIMAL 16TrueTrueTrueFalse%8.5f
PurchaseOrderItemItemNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
PurchaseOrderItemNumberOfBaseUnits3 DECIMAL 15TrueTrueTrueFalse%7.5f
PurchaseOrderItemQty3 DECIMAL 15TrueTrueTrueFalse%7.5f
PurchaseOrderItemQtyReceived3 DECIMAL 15TrueFalseFalseFalse%7.5f
PurchaseOrderItemSize12 VARCHAR 8TrueTrueTrueFalse%s
PurchaseOrderItemUnitOfMeasure12 VARCHAR 20TrueFalseTrueFalse%s
PurchaseOrderItemUPC12 VARCHAR 18TrueTrueTrueFalse%s
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
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
TABLE DETAIL REFERENCE: SalesOrderItem
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 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
SalesOrderItemSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
SalesOrderItemListID12 VARCHAR 36TrueTrueTrueTrue%s
SalesOrderItemTxnLineID4 INTEGER 4TrueTrueFalseFalse%11.0f
SalesOrderItemALU12 VARCHAR 20TrueTrueTrueFalse%s
SalesOrderItemAssociate12 VARCHAR 40TrueTrueTrueFalse%s
SalesOrderItemAttribute12 VARCHAR 12TrueTrueTrueFalse%s
SalesOrderItemCommission3 DECIMAL 16TrueTrueTrueFalse%8.5f
SalesOrderItemDesc112 VARCHAR 30TrueTrueTrueFalse%s
SalesOrderItemDesc212 VARCHAR 8000TrueTrueTrueFalse%s
SalesOrderItemDiscount3 DECIMAL 13TrueTrueTrueFalse%8.2f
SalesOrderItemDiscountPercent3 DECIMAL 13TrueTrueTrueFalse%8.2f
SalesOrderItemDiscountType12 VARCHAR 16TrueTrueTrueFalse%s
SalesOrderItemExtendedPrice3 DECIMAL 16TrueTrueTrueFalse%8.5f
SalesOrderItemExtendedTax3 DECIMAL 16TrueFalseFalseFalse%8.5f
SalesOrderItemItemNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
SalesOrderItemPrice3 DECIMAL 16TrueTrueTrueFalse%8.5f
SalesOrderItemPriceLevelNumber12 VARCHAR 1TrueFalseFalseFalse
1
2
3
4
SalesOrderItemQty3 DECIMAL 15TrueTrueTrueFalse%7.5f
SalesOrderItemSerialNumber12 VARCHAR 25TrueTrueTrueFalse%s
SalesOrderItemSize12 VARCHAR 8TrueTrueTrueFalse%s
SalesOrderItemTaxAmount3 DECIMAL 16TrueFalseFalseFalse%8.5f
SalesOrderItemTaxCode12 VARCHAR 36TrueTrueTrueFalse%s
SalesOrderItemTaxPercent3 DECIMAL 13TrueFalseFalseFalse%8.2f
SalesOrderItemUnitOfMeasure12 VARCHAR 20TrueTrueTrueFalse%s
SalesOrderItemUPC12 VARCHAR 18TrueTrueTrueFalse%s
SalesOrderItemWebDesc12 VARCHAR 4095TrueFalseFalseFalse%s
SalesOrderItemManufacturer12 VARCHAR 50TrueFalseFalseFalse%s
SalesOrderItemWeight3 DECIMAL 15TrueFalseFalseFalse%7.5f
SalesOrderItemWebSKU12 VARCHAR 20TrueFalseFalseFalse%s
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: SalesReceipt
(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
Cashier12 VARCHAR 40TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
CustomerListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
Discount3 DECIMAL 20TrueFalseTrueFalse%8.5f
DiscountPercent3 DECIMAL 13TrueFalseTrueFalse%8.2f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
PriceLevelNumber12 VARCHAR 1TrueFalseTrueFalse
1
2
3
4
PromoCode12 VARCHAR 10TrueFalseTrueFalse%s
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
SalesOrderTxnID12 VARCHAR 36TrueFalseTrueFalse%s Yes
SalesReceiptNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
SalesReceiptType12 VARCHAR 7TrueFalseTrueFalse
Sales
Return
Deposit
Refund
Payout
Payin
ShipDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
Subtotal3 DECIMAL 20TrueFalseFalseFalse%8.5f
TaxAmount3 DECIMAL 20TrueFalseFalseFalse%8.5f
TaxCategory12 VARCHAR 20TrueFalseTrueFalse%s
TaxPercentage3 DECIMAL 13TrueFalseFalseFalse%8.2f
TenderType12 VARCHAR 12TrueFalseFalseFalse
None
Cash
Check
CreditCard
DebitCard
GiftCard
Account
Gift
Deposit
Split
Total3 DECIMAL 16TrueFalseFalseFalse%8.5f
TrackingNumber12 VARCHAR 50TrueFalseTrueFalse%s
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
BillingInformationCity12 VARCHAR 31TrueFalseFalseFalse%s
BillingInformationCompanyName12 VARCHAR 48TrueFalseFalseFalse%s
BillingInformationCountry12 VARCHAR 32TrueFalseFalseFalse%s
BillingInformationFirstName12 VARCHAR 30TrueFalseFalseFalse%s
BillingInformationLastName12 VARCHAR 30TrueFalseFalseFalse%s
BillingInformationPhone12 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPhone212 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPhone312 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPhone412 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPostalCode12 VARCHAR 10TrueFalseFalseFalse%s
BillingInformationSalutation12 VARCHAR 15TrueFalseFalseFalse%s
BillingInformationState12 VARCHAR 21TrueFalseFalseFalse%s
BillingInformationStreet12 VARCHAR 41TrueFalseFalseFalse%s
ShippingInformationCity12 VARCHAR 31TrueFalseTrueFalse%s
ShippingInformationCompanyName12 VARCHAR 48TrueFalseTrueFalse%s
ShippingInformationCountry12 VARCHAR 32TrueFalseTrueFalse%s
ShippingInformationFullName12 VARCHAR 159TrueFalseTrueFalse%s
ShippingInformationPhone12 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPhone212 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPhone312 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPhone412 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPostalCode12 VARCHAR 10TrueFalseTrueFalse%s
ShippingInformationShipBy12 VARCHAR 50TrueFalseTrueFalse%s
ShippingInformationShipping3 DECIMAL 16TrueFalseTrueFalse%8.5f
ShippingInformationState12 VARCHAR 21TrueFalseTrueFalse%s
ShippingInformationStreet12 VARCHAR 41TrueFalseTrueFalse%s
TenderAccount01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount01TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount02TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount03TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount04TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount05TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount06TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount07TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount08TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount09TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount10TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck01CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck02CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck03CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck04CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck05CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck06CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck07CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck08CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck09CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck10CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard01CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard01TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard02CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard02TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard03CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard03TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard04CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard04TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard05CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard05TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard01Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard02Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard03Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard04Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard05Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift01GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift02GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift03GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift04GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift05GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift06GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift07GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift08GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift09GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift10GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGiftCard01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard01TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard02TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard03TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard04TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard05TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
TABLE DETAIL REFERENCE: SalesReceiptItem
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Cashier12 VARCHAR 40TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
CustomerListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
Discount3 DECIMAL 20TrueFalseTrueFalse%8.5f
DiscountPercent3 DECIMAL 13TrueFalseTrueFalse%8.2f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
PriceLevelNumber12 VARCHAR 1TrueFalseTrueFalse
1
2
3
4
PromoCode12 VARCHAR 10TrueFalseTrueFalse%s
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
SalesOrderTxnID12 VARCHAR 36TrueFalseTrueFalse%s Yes
SalesReceiptNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
SalesReceiptType12 VARCHAR 7TrueFalseTrueFalse
Sales
Return
Deposit
Refund
Payout
Payin
ShipDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
StoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
Subtotal3 DECIMAL 20TrueFalseFalseFalse%8.5f
TaxAmount3 DECIMAL 20TrueFalseFalseFalse%8.5f
TaxCategory12 VARCHAR 20TrueFalseTrueFalse%s
TaxPercentage3 DECIMAL 13TrueFalseFalseFalse%8.2f
TenderType12 VARCHAR 12TrueFalseFalseFalse
None
Cash
Check
CreditCard
DebitCard
GiftCard
Account
Gift
Deposit
Split
Total3 DECIMAL 16TrueFalseFalseFalse%8.5f
TrackingNumber12 VARCHAR 50TrueFalseTrueFalse%s
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
BillingInformationCity12 VARCHAR 31TrueFalseFalseFalse%s
BillingInformationCompanyName12 VARCHAR 48TrueFalseFalseFalse%s
BillingInformationCountry12 VARCHAR 32TrueFalseFalseFalse%s
BillingInformationFirstName12 VARCHAR 30TrueFalseFalseFalse%s
BillingInformationLastName12 VARCHAR 30TrueFalseFalseFalse%s
BillingInformationPhone12 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPhone212 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPhone312 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPhone412 VARCHAR 40TrueFalseFalseFalse%s
BillingInformationPostalCode12 VARCHAR 10TrueFalseFalseFalse%s
BillingInformationSalutation12 VARCHAR 15TrueFalseFalseFalse%s
BillingInformationState12 VARCHAR 21TrueFalseFalseFalse%s
BillingInformationStreet12 VARCHAR 41TrueFalseFalseFalse%s
ShippingInformationCity12 VARCHAR 31TrueFalseTrueFalse%s
ShippingInformationCompanyName12 VARCHAR 48TrueFalseTrueFalse%s
ShippingInformationCountry12 VARCHAR 32TrueFalseTrueFalse%s
ShippingInformationFullName12 VARCHAR 159TrueFalseTrueFalse%s
ShippingInformationPhone12 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPhone212 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPhone312 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPhone412 VARCHAR 15TrueFalseTrueFalse%s
ShippingInformationPostalCode12 VARCHAR 10TrueFalseTrueFalse%s
ShippingInformationShipBy12 VARCHAR 50TrueFalseTrueFalse%s
ShippingInformationShipping3 DECIMAL 16TrueFalseTrueFalse%8.5f
ShippingInformationState12 VARCHAR 21TrueFalseTrueFalse%s
ShippingInformationStreet12 VARCHAR 41TrueFalseTrueFalse%s
SalesReceiptItemSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
SalesReceiptItemListID12 VARCHAR 36FalseFalseTrueFalse%s
SalesReceiptItemALU12 VARCHAR 20FalseFalseTrueFalse%s
SalesReceiptItemAssociate12 VARCHAR 40FalseFalseTrueFalse%s
SalesReceiptItemAttribute12 VARCHAR 8FalseFalseTrueFalse%s
SalesReceiptItemCommission3 DECIMAL 16FalseFalseTrueFalse%8.5f
SalesReceiptItemCost3 DECIMAL 18TrueFalseFalseFalse%8.5f
SalesReceiptItemDesc112 VARCHAR 30FalseFalseTrueFalse%s
SalesReceiptItemDesc212 VARCHAR 8000FalseFalseTrueFalse%s
SalesReceiptItemDiscount3 DECIMAL 20FalseFalseTrueFalse%8.5f
SalesReceiptItemDiscountPercent3 DECIMAL 13FalseFalseTrueFalse%8.2f
SalesReceiptItemDiscountType12 VARCHAR 16FalseFalseTrueFalse%s
SalesReceiptItemExtendedPrice3 DECIMAL 20FalseFalseTrueFalse%8.5f
SalesReceiptItemExtendedTax3 DECIMAL 20FalseFalseTrueFalse%8.5f
SalesReceiptItemPrice3 DECIMAL 16FalseFalseTrueFalse%8.5f
SalesReceiptItemQty3 DECIMAL 15FalseFalseTrueFalse%7.5f
SalesReceiptItemSerialNumber12 VARCHAR 25FalseFalseTrueFalse%s
SalesReceiptItemSize12 VARCHAR 8FalseFalseTrueFalse%s
SalesReceiptItemTaxAmount3 DECIMAL 20FalseFalseTrueFalse%8.5f
SalesReceiptItemTaxCode12 VARCHAR 100FalseFalseTrueFalse%s
SalesReceiptItemUnitOfMeasure12 VARCHAR 20TrueFalseTrueFalse%s
SalesReceiptItemUPC12 VARCHAR 18FalseFalseTrueFalse%s
SalesReceiptItemWebDesc12 VARCHAR 4095TrueFalseTrueFalse%s
SalesReceiptItemManufacturer12 VARCHAR 50TrueFalseTrueFalse%s
SalesReceiptItemWeight3 DECIMAL 15TrueFalseTrueFalse%7.5f
SalesReceiptItemWebSKU12 VARCHAR 20TrueFalseTrueFalse%s
TenderAccount01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount01TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount02TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount03TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount04TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount05TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount06TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount07TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount08TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount09TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderAccount10TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck01CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck02CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck03CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck04CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck05CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck06CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck07CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck08CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck09CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCheck10CheckNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderCheck10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCash10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard01CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard01TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard02CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard02TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard03CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard03TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard04CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard04TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard05CardName12 VARCHAR 16TrueFalseTrueFalse%s
TenderCreditCard05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderCreditCard05TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard01Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard02Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard03Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard04Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard05Cashback3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDebitCard05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderDeposit05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift01GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift02GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift03GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift04GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift05GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift06TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift06GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift07TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift07GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift08TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift08GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift09TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift09GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGift10TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGift10GiftCertificateNumber12 VARCHAR 32TrueFalseTrueFalse%s
TenderGiftCard01TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard01TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard02TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard02TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard03TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard03TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard04TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard04TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard05TenderAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
TenderGiftCard05TipAmount3 DECIMAL 20TrueFalseTrueFalse%8.5f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: TimeEntry
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
ClockInTime11 TIMESTAMP 16TrueTrueTrueFalseCCCC-MM-DDThh:mm:ssZ
ClockOutTime11 TIMESTAMP 16TrueTrueTrueFalseCCCC-MM-DDThh:mm:ssZ
CreatedBy12 VARCHAR 40TrueTrueTrueFalse%s
EmployeeListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
EmployeeLoginName12 VARCHAR 30TrueFalseFalseFalse%s
FirstName12 VARCHAR 30TrueFalseFalseFalse%s
LastName12 VARCHAR 30TrueFalseFalseFalse%s
QuickBooksFlag12 VARCHAR 30TrueFalseTrueTrue%s
StoreNumber4 INTEGER 4TrueTrueTrueTrue%11.0f
TABLE DETAIL REFERENCE: TransferSlip
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Carrier12 VARCHAR 15TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
Freight3 DECIMAL 13TrueFalseTrueFalse%8.2f
FromStoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
SlipETA9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
SlipNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
ToStoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
TotalCost3 DECIMAL 13TrueFalseFalseFalse%8.2f
TotalQty3 DECIMAL 15TrueFalseFalseFalse%7.5f
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
TABLE DETAIL REFERENCE: TransferSlipItem
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
Carrier12 VARCHAR 15TrueFalseTrueFalse%s
Comments12 VARCHAR 300TrueFalseTrueFalse%s
Freight3 DECIMAL 13TrueFalseTrueFalse%8.2f
FromStoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
HistoryDocStatus12 VARCHAR 9TrueFalseFalseFalse
Regular
Reversed
Reversing
QuickBooksFlag12 VARCHAR 17TrueFalseTrueFalse
NotPosted
Completed
Error
UnbilledPurchases
ItemsCount4 INTEGER 4TrueFalseFalseFalse%11.0f
SlipETA9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
SlipNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
ToStoreNumber4 INTEGER 4TrueFalseTrueFalse%11.0f
TotalCost3 DECIMAL 13TrueFalseFalseFalse%8.2f
TotalQty3 DECIMAL 15TrueFalseFalseFalse%7.5f
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnState12 VARCHAR 6TrueFalseTrueFalse
Normal
Held
Workstation4 INTEGER 4TrueFalseTrueFalse%11.0f
TransferSlipItemSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
TransferSlipItemListID12 VARCHAR 36TrueFalseTrueTrue%s
TransferSlipItemQty3 DECIMAL 15TrueFalseTrueFalse%7.5f
TransferSlipItemSerialNumber12 VARCHAR 25TrueFalseTrueFalse%s
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Vendor
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
AccountNumber12 VARCHAR 99TrueTrueTrueFalse%s
City12 VARCHAR 31TrueTrueTrueFalse%s
CompanyName12 VARCHAR 48TrueTrueTrueFalse%s
Country12 VARCHAR 31TrueTrueTrueFalse%s
EMail12 VARCHAR 99TrueTrueTrueFalse%s
FirstName12 VARCHAR 30TrueTrueTrueFalse%s
IsInactive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
LastName12 VARCHAR 30TrueTrueTrueFalse%s
Notes12 VARCHAR 245TrueTrueTrueFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
Phone212 VARCHAR 21TrueTrueTrueFalse%s
Phone312 VARCHAR 21TrueTrueTrueFalse%s
Phone412 VARCHAR 21TrueTrueTrueFalse%s
PostalCode12 VARCHAR 13TrueTrueTrueFalse%s
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
State12 VARCHAR 21TrueTrueTrueFalse%s
StoreExchangeStatus12 VARCHAR 12TrueTrueFalseFalse
Modified
Sent
Acknowledged
Street12 VARCHAR 41TrueTrueTrueFalse%s
Terms12 VARCHAR 200TrueFalseFalseFalse%s
TermsDiscount3 DECIMAL 13TrueTrueTrueFalse%8.2f
TermsDiscountDays4 INTEGER 4TrueTrueTrueFalse%11.0f
TermsNetDays4 INTEGER 4TrueTrueTrueFalse%11.0f
VendorCode12 VARCHAR 3TrueTrueTrueFalse%s
CustomFieldOther12 VARCHAR 30TrueFalseFalseFalse%s
CustomFieldAccountingContact12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldAccountingEmail12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldAccountingPhone12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldBrand12 VARCHAR 30TrueTrueTrueFalse%s
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
TABLE DETAIL REFERENCE: VoucherItem
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
Associate12 VARCHAR 40TrueFalseTrueFalse%s
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
VoucherItemSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
VoucherItemListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
VoucherItemALU12 VARCHAR 20TrueFalseTrueFalse%s
VoucherItemAttribute12 VARCHAR 8TrueFalseTrueFalse%s
VoucherItemCost3 DECIMAL 16TrueFalseTrueFalse%8.5f
VoucherItemDesc112 VARCHAR 30TrueFalseTrueFalse%s
VoucherItemDesc212 VARCHAR 8000TrueFalseTrueFalse%s
VoucherItemExtendedCost3 DECIMAL 16TrueFalseTrueFalse%8.5f
VoucherItemItemNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VoucherItemNumberOfBaseUnits3 DECIMAL 15TrueFalseTrueFalse%7.5f
VoucherItemQtyReceived3 DECIMAL 15TrueFalseTrueFalse%7.5f
VoucherItemSerialNumber12 VARCHAR 25TrueFalseTrueFalse%s
VoucherItemSize12 VARCHAR 8TrueFalseTrueFalse%s
VoucherItemUnitOfMeasure12 VARCHAR 20TrueFalseTrueFalse%s
VoucherItemUPC12 VARCHAR 18TrueFalseTrueFalse%s
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey