Details:ALL

TABLE DETAIL REFERENCE: Company

(POS VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
Id	4	INTEGER	4	True	False	False	False	FQID
IsSampleCompany	-7	BIT	1	True	False	False	False	1 0 true false
CompanyName	12	VARCHAR	100	True	False	False	False	%s
AddressStreet	12	VARCHAR	100	True	False	False	False	%s
CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Misc1	12	VARCHAR	100	True	False	False	False	%s
Misc2	12	VARCHAR	100	True	False	False	False	%s
Misc3	12	VARCHAR	100	True	False	False	False	%s
QuickBooksCompanyFile	12	VARCHAR	500	True	False	False	False	%s
StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store01StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store01StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store01StoreName	12	VARCHAR	100	True	False	False	False	%s
Store01AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store01CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store01Misc1	12	VARCHAR	100	True	False	False	False	%s
Store01Misc2	12	VARCHAR	100	True	False	False	False	%s
Store01Misc3	12	VARCHAR	100	True	False	False	False	%s
Store02StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store02StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store02StoreName	12	VARCHAR	100	True	False	False	False	%s
Store02AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store02CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store02Misc1	12	VARCHAR	100	True	False	False	False	%s
Store02Misc2	12	VARCHAR	100	True	False	False	False	%s
Store02Misc3	12	VARCHAR	100	True	False	False	False	%s
Store03StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store03StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store03StoreName	12	VARCHAR	100	True	False	False	False	%s
Store03AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store03CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store03Misc1	12	VARCHAR	100	True	False	False	False	%s
Store03Misc2	12	VARCHAR	100	True	False	False	False	%s
Store03Misc3	12	VARCHAR	100	True	False	False	False	%s
Store04StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store04StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store04StoreName	12	VARCHAR	100	True	False	False	False	%s
Store04AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store04CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store04Misc1	12	VARCHAR	100	True	False	False	False	%s
Store04Misc2	12	VARCHAR	100	True	False	False	False	%s
Store04Misc3	12	VARCHAR	100	True	False	False	False	%s
Store05StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store05StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store05StoreName	12	VARCHAR	100	True	False	False	False	%s
Store05AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store05CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store05Misc1	12	VARCHAR	100	True	False	False	False	%s
Store05Misc2	12	VARCHAR	100	True	False	False	False	%s
Store05Misc3	12	VARCHAR	100	True	False	False	False	%s
Store06StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store06StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store06StoreName	12	VARCHAR	100	True	False	False	False	%s
Store06AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store06CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store06Misc1	12	VARCHAR	100	True	False	False	False	%s
Store06Misc2	12	VARCHAR	100	True	False	False	False	%s
Store06Misc3	12	VARCHAR	100	True	False	False	False	%s
Store07StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store07StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store07StoreName	12	VARCHAR	100	True	False	False	False	%s
Store07AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store07CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store07Misc1	12	VARCHAR	100	True	False	False	False	%s
Store07Misc2	12	VARCHAR	100	True	False	False	False	%s
Store07Misc3	12	VARCHAR	100	True	False	False	False	%s
Store08StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store08StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store08StoreName	12	VARCHAR	100	True	False	False	False	%s
Store08AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store08CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store08Misc1	12	VARCHAR	100	True	False	False	False	%s
Store08Misc2	12	VARCHAR	100	True	False	False	False	%s
Store08Misc3	12	VARCHAR	100	True	False	False	False	%s
Store09StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store09StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store09StoreName	12	VARCHAR	100	True	False	False	False	%s
Store09AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store09CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store09Misc1	12	VARCHAR	100	True	False	False	False	%s
Store09Misc2	12	VARCHAR	100	True	False	False	False	%s
Store09Misc3	12	VARCHAR	100	True	False	False	False	%s
Store10StoreNumber	4	INTEGER	4	True	False	False	False	%11.0f
Store10StoreCode	12	VARCHAR	13	True	False	False	False	%s
Store10StoreName	12	VARCHAR	100	True	False	False	False	%s
Store10AddressStreet	12	VARCHAR	100	True	False	False	False	%s
Store10CityStateZIP	12	VARCHAR	100	True	False	False	False	%s
Store10Misc1	12	VARCHAR	100	True	False	False	False	%s
Store10Misc2	12	VARCHAR	100	True	False	False	False	%s
Store10Misc3	12	VARCHAR	100	True	False	False	False	%s
PriceLevel1Name	12	VARCHAR	100	True	False	False	False	%s
PriceLevel1Markdown	3	DECIMAL	15	True	False	False	False	%7.5f
PriceLevel2Name	12	VARCHAR	100	True	False	False	False	%s
PriceLevel2Markdown	3	DECIMAL	15	True	False	False	False	%7.5f
PriceLevel3Name	12	VARCHAR	100	True	False	False	False	%s
PriceLevel3Markdown	3	DECIMAL	15	True	False	False	False	%7.5f
PriceLevel4Name4	12	VARCHAR	100	True	False	False	False	%s
PriceLevel4Markdown	3	DECIMAL	15	True	False	False	False	%7.5f
PurchaseOrderStatusInfoStatusType	12	VARCHAR	6	True	False	False	False	Open Closed Custom
PurchaseOrderStatusInfoStatusDescription	12	VARCHAR	100	True	False	False	False	%s
LayawayStatusInfoStatusType	12	VARCHAR	6	True	False	False	False	Open Closed Custom
LayawayStatusInfoStatusDescription	12	VARCHAR	100	True	False	False	False	%s
SalesOrderStatusInfoStatusType	12	VARCHAR	6	True	False	False	False	Open Closed Custom
SalesOrderStatusInfoStatusDescription	12	VARCHAR	100	True	False	False	False	%s
WorkOrderStatusInfoStatusType	12	VARCHAR	6	True	False	False	False	Open Closed Custom
WorkOrderStatusInfoStatusDescription	12	VARCHAR	100	True	False	False	False	%s

TABLE DETAIL REFERENCE: Customer

(POS VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
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
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
EMail	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
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: 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
EMail	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
EMail	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)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
OwnerID	12	VARCHAR	50	True	False	True	False	%s
Name	12	VARCHAR	31	True	False	True	False	%s
EntityType	12	VARCHAR	23	True	False	True	False	Customer Vendor Employee OtherName Item Account
EntityRefListID	12	VARCHAR	36	True	False	True	False	%s
OtherType	12	VARCHAR	7	True	False	True	False	Company
Value	12	VARCHAR	4095	True	False	True	False

TABLE DETAIL REFERENCE: Department

(POS VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
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
DefaultMarginPercent	4	INTEGER	4	True	True	True	False	%11.0f
DefaultMarkupPercent	4	INTEGER	4	True	True	True	False	%11.0f
DepartmentCode	12	VARCHAR	3	True	True	True	True	%s
DepartmentName	12	VARCHAR	30	True	True	True	True	%s
StoreExchangeStatus	12	VARCHAR	12	True	False	False	False	Modified Sent Acknowledged
TaxCode	12	VARCHAR	100	True	True	True	True	%s

TABLE DETAIL REFERENCE: Employee

(POS VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
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
City	12	VARCHAR	31	True	True	True	False	%s
CommissionPercent	3	DECIMAL	15	True	True	True	False	%7.5f
Country	12	VARCHAR	31	True	True	True	False	%s
Email	12	VARCHAR	99	True	True	True	False	%s
FirstName	12	VARCHAR	30	True	True	True	False	%s
LastName	12	VARCHAR	30	True	True	True	False	%s
LoginName	12	VARCHAR	20	True	True	True	True	%s
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
PostalCode	12	VARCHAR	13	True	True	True	False	%s
State	12	VARCHAR	21	True	True	True	False	%s
Street	12	VARCHAR	41	True	True	True	False	%s
CustomFieldOther	12	VARCHAR	30	True	False	False	False	%s

TABLE DETAIL REFERENCE: InventoryCostAdjustment

(POS VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
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
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
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache

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)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
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
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
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache

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)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
ListDelType	12	VARCHAR	20	True	False	False	False	Customer Department Employee ItemInventory PurchaseOrder SalesOrder TimeEntry Vendor
ListID	12	VARCHAR	36	True	False	False	False	%s
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeDeleted	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ

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)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
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
AccountNumber	12	VARCHAR	99	True	True	True	False	%s
City	12	VARCHAR	31	True	True	True	False	%s
CompanyName	12	VARCHAR	48	True	True	True	False	%s
Country	12	VARCHAR	31	True	True	True	False	%s
EMail	12	VARCHAR	99	True	True	True	False	%s
FirstName	12	VARCHAR	30	True	True	True	False	%s
IsInactive	-7	BIT	1	True	True	True	False	1 0 true false
LastName	12	VARCHAR	30	True	True	True	False	%s
Notes	12	VARCHAR	245	True	True	True	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
Phone2	12	VARCHAR	21	True	True	True	False	%s
Phone3	12	VARCHAR	21	True	True	True	False	%s
Phone4	12	VARCHAR	21	True	True	True	False	%s
PostalCode	12	VARCHAR	13	True	True	True	False	%s
Salutation	12	VARCHAR	15	True	True	True	False	%s
State	12	VARCHAR	21	True	True	True	False	%s
StoreExchangeStatus	12	VARCHAR	12	True	True	False	False	Modified Sent Acknowledged
Street	12	VARCHAR	41	True	True	True	False	%s
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
VendorCode	12	VARCHAR	3	True	True	True	False	%s
CustomFieldOther	12	VARCHAR	30	True	False	False	False	%s
CustomFieldAccountingContact	12	VARCHAR	30	True	True	True	False	%s
CustomFieldAccountingEmail	12	VARCHAR	30	True	True	True	False	%s
CustomFieldAccountingPhone	12	VARCHAR	30	True	True	True	False	%s
CustomFieldBrand	12	VARCHAR	30	True	True	True	False	%s

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

QODBC.com Tools for QuickBooks