Details:ALL

TABLE DETAIL REFERENCE: Account

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	31	True	True	True	True	%s
FullName	12	VARCHAR	159	True	False	False	False	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
ParentRefListID	12	VARCHAR	36	True	True	True	False	%s
ParentRefFullName	12	VARCHAR	159	True	True	True	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
AccountType	12	VARCHAR	21	True	True	True	True	AccountsPayable AccountsReceivable Bank CostOfGoodsSold CreditCard Equity Expense FixedAsset Income LongTermLiability Nonposting OtherAsset OtherCurrentAsset OtherCurrentLiability OtherExpense OtherIncome
SpecialAccountType	12	VARCHAR	30	True	False	False	False	AccountsPayable AccountsReceivable CondenseItemAdjustmentExpenses CostOfGoodsSold DirectDepositLiabilities Estimates InventoryAssets OpeningBalanceEquity PayrollExpenses PayrollLiabilities PettyCash PurchaseOrders ReconciliationDifferences RetainedEarnings SalesOrders SalesTaxPayable UncategorizedExpenses UncategorizedIncome UndepositedFunds
IsTaxAccount	-7	BIT	1	True	True	True	False	1 0 true false
AccountNumber	12	VARCHAR	7	True	True	True	False	%s
BankNumber	12	VARCHAR	25	True	True	True	False	%s
Desc	12	VARCHAR	200	True	True	True	False	%s
Description	12	VARCHAR	4095	True	True	True	False	%s
Balance	3	DECIMAL	18	True	False	False	False	%10.2f
TotalBalance	3	DECIMAL	18	True	False	False	False	%10.2f
OpenBalance	3	DECIMAL	18	True	True	True	False	%10.2f
OpenBalanceDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxLineInfoRetTaxLineID	4	INTEGER	4	True	False	False	False	%11.0f	Yes
TaxLineInfoRetTaxLineName	12	VARCHAR	256	True	False	False	False	%s	Yes
CashFlowClassification	12	VARCHAR	13	True	False	False	False	None Operating Investing Financing NotApplicable
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes

TABLE DETAIL REFERENCE: AccountTaxLineInfo

(USA VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
TaxLineID	4	INTEGER	4	True	False	False	False	%11.0f
TaxLineName	12	VARCHAR	256	True	False	False	False	%s

TABLE DETAIL REFERENCE: ARRefundCreditCard

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
CustomerRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
CustomerRefFullName	12	VARCHAR	209	True	False	True	True	%s	Yes
RefundFromAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
RefundFromAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
TxnDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	11	True	False	True	False	%s
TotalAmount	3	DECIMAL	18	True	False	False	False	%10.2f
AddressAddr1	12	VARCHAR	41	True	False	True	False	%s
AddressAddr2	12	VARCHAR	41	True	False	True	False	%s
AddressAddr3	12	VARCHAR	41	True	False	True	False	%s
AddressAddr4	12	VARCHAR	41	True	False	True	False	%s
AddressAddr5	12	VARCHAR	41	True	False	True	False	%s
AddressCity	12	VARCHAR	31	True	False	True	False	%s
AddressState	12	VARCHAR	21	True	False	True	False	%s
AddressProvince	12	VARCHAR	21	True	False	True	False	%s
AddressCounty	12	VARCHAR	21	True	False	True	False	%s
AddressPostalCode	12	VARCHAR	13	True	False	True	False	%s
AddressCountry	12	VARCHAR	31	True	False	True	False	%s
AddressNote	12	VARCHAR	41	True	False	True	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
PaymentMethodRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	31	True	False	True	False	%s	Yes
Memo	12	VARCHAR	4095	True	False	True	False	%s
CreditCardTxnInfoInputCreditCardNumber	12	VARCHAR	25	True	False	True	False	%s
CreditCardTxnInfoInputExpirationMonth	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoInputExpirationYear	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoInputNameOnCard	12	VARCHAR	41	True	False	True	False	%s
CreditCardTxnInfoInputCreditCardAddress	12	VARCHAR	41	True	False	True	False	%s
CreditCardTxnInfoInputCreditCardPostalCode	12	VARCHAR	41	True	False	True	False	%s
CreditCardTxnInfoInputCommercialCardCode	12	VARCHAR	50	True	False	True	False	%s
CreditCardTxnInfoInputTransactionMode	12	VARCHAR	14	True	False	True	False	CardNotPresent CardPresent
CreditCardTxnInfoInputCreditCardTxnType	12	VARCHAR	18	True	False	True	False	Authorization Capture Charge Refund VoiceAuthorization
CreditCardTxnInfoResultResultCode	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoResultResultMessage	12	VARCHAR	500	True	False	True	False	%s
CreditCardTxnInfoResultCreditCardTransID	12	VARCHAR	24	True	False	True	False	%s
CreditCardTxnInfoResultMerchantAccountNumber	12	VARCHAR	32	True	False	True	False	%s
CreditCardTxnInfoResultAuthorizationCode	12	VARCHAR	12	True	False	True	False	%s
CreditCardTxnInfoResultAVSStreet	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable
CreditCardTxnInfoResultAVSZip	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable
CreditCardTxnInfoResultCardSecurityCodeMatch	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable
CreditCardTxnInfoResultReconBatchID	12	VARCHAR	84	True	False	True	False	%s
CreditCardTxnInfoResultPaymentGroupingCode	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoResultPaymentStatus	12	VARCHAR	9	True	False	True	False	Unknown Completed
CreditCardTxnInfoResultTxnAuthorizationTime	11	TIMESTAMP	16	True	False	True	False	CCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoResultClientTransID	12	VARCHAR	16	True	False	True	False	%s

TABLE DETAIL REFERENCE: ARRefundCreditCardRefundAppliedTo

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
CustomerRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
CustomerRefFullName	12	VARCHAR	209	True	False	True	True	%s	Yes
RefundFromAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
RefundFromAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
TxnDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	11	True	False	True	False	%s
TotalAmount	3	DECIMAL	18	True	False	False	False	%10.2f
AddressAddr1	12	VARCHAR	41	True	False	True	False	%s
AddressAddr2	12	VARCHAR	41	True	False	True	False	%s
AddressAddr3	12	VARCHAR	41	True	False	True	False	%s
AddressAddr4	12	VARCHAR	41	True	False	True	False	%s
AddressAddr5	12	VARCHAR	41	True	False	True	False	%s
AddressCity	12	VARCHAR	31	True	False	True	False	%s
AddressState	12	VARCHAR	21	True	False	True	False	%s
AddressProvince	12	VARCHAR	21	True	False	True	False	%s
AddressCounty	12	VARCHAR	21	True	False	True	False	%s
AddressPostalCode	12	VARCHAR	13	True	False	True	False	%s
AddressCountry	12	VARCHAR	31	True	False	True	False	%s
AddressNote	12	VARCHAR	41	True	False	True	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
PaymentMethodRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	31	True	False	True	False	%s	Yes
Memo	12	VARCHAR	4095	True	False	True	False	%s
CreditCardTxnInfoInputCreditCardNumber	12	VARCHAR	25	True	False	True	False	%s
CreditCardTxnInfoInputExpirationMonth	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoInputExpirationYear	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoInputNameOnCard	12	VARCHAR	41	True	False	True	False	%s
CreditCardTxnInfoInputCreditCardAddress	12	VARCHAR	41	True	False	True	False	%s
CreditCardTxnInfoInputCreditCardPostalCode	12	VARCHAR	41	True	False	True	False	%s
CreditCardTxnInfoInputCommercialCardCode	12	VARCHAR	50	True	False	True	False	%s
CreditCardTxnInfoInputTransactionMode	12	VARCHAR	14	True	False	True	False	CardNotPresent CardPresent
CreditCardTxnInfoInputCreditCardTxnType	12	VARCHAR	18	True	False	True	False	Authorization Capture Charge Refund VoiceAuthorization
CreditCardTxnInfoResultResultCode	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoResultResultMessage	12	VARCHAR	500	True	False	True	False	%s
CreditCardTxnInfoResultCreditCardTransID	12	VARCHAR	24	True	False	True	False	%s
CreditCardTxnInfoResultMerchantAccountNumber	12	VARCHAR	32	True	False	True	False	%s
CreditCardTxnInfoResultAuthorizationCode	12	VARCHAR	12	True	False	True	False	%s
CreditCardTxnInfoResultAVSStreet	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable
CreditCardTxnInfoResultAVSZip	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable
CreditCardTxnInfoResultCardSecurityCodeMatch	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable
CreditCardTxnInfoResultReconBatchID	12	VARCHAR	84	True	False	True	False	%s
CreditCardTxnInfoResultPaymentGroupingCode	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoResultPaymentStatus	12	VARCHAR	9	True	False	True	False	Unknown Completed
CreditCardTxnInfoResultTxnAuthorizationTime	11	TIMESTAMP	16	True	False	True	False	CCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp	4	INTEGER	4	True	False	True	False	%11.0f
CreditCardTxnInfoResultClientTransID	12	VARCHAR	16	True	False	True	False	%s
RefundAppliedToTxnTxnID	12	VARCHAR	36	True	False	True	True	%s
RefundAppliedToTxnTxnType	12	VARCHAR	14	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
RefundAppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
RefundAppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
RefundAppliedToTxnRefCreditRemaining	3	DECIMAL	17	True	False	False	False	%10.2f
RefundAppliedToTxnRefRefundAmount	3	DECIMAL	17	True	False	True	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BarCode

(USA 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
FullName	12	VARCHAR	50	True	False	False	False	%s

TABLE DETAIL REFERENCE: Bill

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
VendorRefFullName	12	VARCHAR	41	True	True	True	True	%s	Yes
VendorAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
VendorAddressCity	12	VARCHAR	31	True	True	True	False	%s
VendorAddressState	12	VARCHAR	21	True	True	True	False	%s
VendorAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
AmountDueInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	20	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
LinkToTxnID1	12	VARCHAR	36	True	False	True	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
OpenAmount	3	DECIMAL	18	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
CustomFieldBillALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillPulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillPulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillStyle	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupPulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupPulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupStyle	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLinePulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLinePulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldBillGroupLineStyle	12	VARCHAR	30	True	False	True	False	%s

TABLE DETAIL REFERENCE: BillExpenseLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
VendorRefFullName	12	VARCHAR	41	True	True	True	True	%s	Yes
VendorAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
VendorAddressCity	12	VARCHAR	31	True	True	True	False	%s
VendorAddressState	12	VARCHAR	21	True	True	True	False	%s
VendorAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
AmountDueInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	20	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
LinkToTxnID1	12	VARCHAR	36	True	False	True	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
ExpenseLineClearExpenseLines	-7	BIT	1	True	True	False	False	1 0 true false
ExpenseLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ExpenseLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ExpenseLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ExpenseLineAmount	3	DECIMAL	18	True	True	True	False	%10.2f
ExpenseLineTaxAmount	3	DECIMAL	17	True	False	False	False	%10.2f
ExpenseLineTax1Amount	3	DECIMAL	17	True	False	False	False	%10.2f
ExpenseLineMemo	12	VARCHAR	4095	True	True	True	False	%s
ExpenseLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ExpenseLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ExpenseLineSalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
OpenAmount	3	DECIMAL	18	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey
CustomFieldExpenseLineALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLinePulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLinePulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineStyle	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupPulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupPulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupStyle	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLinePulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLinePulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldExpenseLineGroupLineStyle	12	VARCHAR	30	True	False	True	False	%s

TABLE DETAIL REFERENCE: BillingRate

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	31	True	False	True	True	%s
BillingRateType	12	VARCHAR	9	True	False	True	False	FixedRate PerItem
FixedBillingRate	3	DECIMAL	18	True	False	True	False	%10.5f

TABLE DETAIL REFERENCE: BillingRateLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	31	True	False	True	True	%s
BillingRateType	12	VARCHAR	9	True	False	True	False	FixedRate PerItem
FixedBillingRate	3	DECIMAL	18	True	False	True	False	%10.5f
BillingRateLineItemRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
BillingRateLineItemRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
BillingRateLineCustomRate	3	DECIMAL	18	True	False	True	False	%10.5f
BillingRateLineCustomRatePercent	3	DECIMAL	18	True	False	True	False	%10.5f
BillingRateLineAdjustPercentage	3	DECIMAL	18	True	False	True	False	%10.5f
BillingRateLineAdjustBillingRateRelativeTo	12	VARCHAR	9	True	False	True	False	StandardRate CurrentCustomRate
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillItemLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
VendorRefFullName	12	VARCHAR	41	True	True	True	True	%s	Yes
VendorAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
VendorAddressCity	12	VARCHAR	31	True	True	True	False	%s
VendorAddressState	12	VARCHAR	21	True	True	True	False	%s
VendorAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
AmountDueInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	20	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
LinkToTxnID1	12	VARCHAR	36	True	False	True	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
ItemLineType	12	VARCHAR	11	True	False	False	False	ItemType
ItemLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ItemGroupLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemGroupLineItemGroupRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemGroupLineItemGroupRefFullName	12	VARCHAR	31	True	True	True	True	%s	Yes
ItemGroupLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
ItemGroupUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemGroupLineInventorySiteRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteLocationRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteLocationRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
ItemGroupOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemGroupOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemGroupLineTotalAmount	3	DECIMAL	18	True	False	False	False	%10.5f
ItemGroupSeqNo	4	INTEGER	4	True	False	False	False	SubSeqNo
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
ItemLineInventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineInventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineInventorySiteLocationRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineInventorySiteLocationRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineSerialNumber	12	VARCHAR	4095	True	True	True	False	%s
ItemLineLotNumber	12	VARCHAR	40	True	True	True	False	%s
ItemLineDesc	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemLineOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemLineCost	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineAmount	3	DECIMAL	18	True	True	True	False	%10.2f
ItemLineTaxAmount	3	DECIMAL	17	True	False	False	False	%10.2f
ItemLineTax1Amount	3	DECIMAL	17	True	False	False	False	%10.2f
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ItemLineSalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
ItemLineOverrideItemAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineOverrideItemAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ItemLineLinkToTxnTxnID	12	VARCHAR	36	True	False	True	False	%s
ItemLineLinkToTxnTxnLineID	12	VARCHAR	36	True	False	True	False	%s
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
OpenAmount	3	DECIMAL	18	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	True	False	False	FQPrimaryKey
FQTxnLinkKey	12	VARCHAR	110	True	True	False	False	FQPrimaryKey
CustomFieldItemLineALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLinePulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLinePulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineStyle	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupPulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupPulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupStyle	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLinePulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLinePulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldItemLineGroupLineStyle	12	VARCHAR	30	True	False	True	False	%s

TABLE DETAIL REFERENCE: BillLinkedTxn

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
VendorRefFullName	12	VARCHAR	41	True	False	False	True	%s	Yes
VendorAddressAddr1	12	VARCHAR	41	True	False	False	False	%s
VendorAddressAddr2	12	VARCHAR	41	True	False	False	False	%s
VendorAddressAddr3	12	VARCHAR	41	True	False	False	False	%s
VendorAddressAddr4	12	VARCHAR	41	True	False	False	False	%s
VendorAddressCity	12	VARCHAR	31	True	False	False	False	%s
VendorAddressState	12	VARCHAR	21	True	False	False	False	%s
VendorAddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
APAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
DueDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AmountDue	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	17	True	False	False	False	%6.8f
AmountDueInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	20	True	False	False	False	%s
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
Memo	12	VARCHAR	4095	True	False	False	False	%s
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
LinkToTxnID1	12	VARCHAR	36	True	False	False	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
LinkedTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
LinkedTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
LinkedTxnTxnType	12	VARCHAR	21	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
LinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
LinkedTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
LinkedTxnLinkType	12	VARCHAR	8	True	False	False	False	AMTTYPE QUANTYPE
LinkedTxnAmount	3	DECIMAL	18	True	False	False	False	%10.2f
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
OpenAmount	3	DECIMAL	18	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey
CustomFieldLinkedTxnALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnPulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnPulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnStyle	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupPulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupPulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupStyle	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineALU	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineALU2	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineApproved	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineColor	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineCompletedby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineCustomer	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineInspectedBy	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineOrdered	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLinePulled	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLinePulledby	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineQtyPriceBreak	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineRequiredDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineStartDate	12	VARCHAR	30	True	False	True	False	%s
CustomFieldLinkedTxnGroupLineStyle	12	VARCHAR	30	True	False	True	False	%s

TABLE DETAIL REFERENCE: BillPaymentCheck

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
PayeeEntityRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	False	True	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
BankAccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
BankAccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
Amount	3	DECIMAL	18	True	True	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
ExchangeRate	3	DECIMAL	18	True	True	False	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	True	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	True	True	True	%s
IsToBePrinted	-7	BIT	1	True	True	True	True	1 0 true false
Memo	12	VARCHAR	4095	True	True	True	False	%s
AddressAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressAddr5	12	VARCHAR	41	True	False	False	False	%s
AddressCity	12	VARCHAR	31	True	False	False	False	%s
AddressState	12	VARCHAR	21	True	False	False	False	%s
AddressProvince	12	VARCHAR	21	True	False	False	False	%s
AddressCounty	12	VARCHAR	21	True	False	False	False	%s
AddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
AddressCountry	12	VARCHAR	31	True	False	False	False	%s
AddressNote	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s

TABLE DETAIL REFERENCE: BillPaymentCheckLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
PayeeEntityRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	False	True	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
BankAccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
BankAccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
Amount	3	DECIMAL	18	True	True	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
ExchangeRate	3	DECIMAL	18	True	True	False	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	True	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	True	True	True	%s
IsToBePrinted	-7	BIT	1	True	True	True	True	1 0 true false
Memo	12	VARCHAR	4095	True	True	True	False	%s
AddressAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressAddr5	12	VARCHAR	41	True	False	False	False	%s
AddressCity	12	VARCHAR	31	True	False	False	False	%s
AddressState	12	VARCHAR	21	True	False	False	False	%s
AddressProvince	12	VARCHAR	21	True	False	False	False	%s
AddressCounty	12	VARCHAR	21	True	False	False	False	%s
AddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
AddressCountry	12	VARCHAR	31	True	False	False	False	%s
AddressNote	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
AppliedToTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
AppliedToTxnTxnID	12	VARCHAR	36	True	True	True	True	%s
AppliedToTxnPaymentAmount	3	DECIMAL	18	True	True	True	False	%10.2f
AppliedToTxnTxnType	12	VARCHAR	14	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
AppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
AppliedToTxnBalanceRemaining	3	DECIMAL	18	True	False	False	False	%10.2f
AppliedToTxnAmount	3	DECIMAL	18	True	False	False	False	%10.2f
AppliedToTxnSetCreditCreditTxnID	12	VARCHAR	36	True	True	True	False	%s
AppliedToTxnSetCreditAppliedAmount	3	DECIMAL	18	True	True	True	False	%10.2f
AppliedToTxnDiscountAmount	3	DECIMAL	15	True	True	True	False	%10.2f
AppliedToTxnDiscountAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
AppliedToTxnDiscountAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
AppliedToTxnDiscountClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
AppliedToTxnDiscountClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillPaymentCheckLineLinkedTxn

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
PayeeEntityRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	False	False	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
BankAccountRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
BankAccountRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
ExchangeRate	3	DECIMAL	18	True	False	False	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	False	False	True	%s
IsToBePrinted	-7	BIT	1	True	False	False	True	1 0 true false
Memo	12	VARCHAR	4095	True	False	False	False	%s
AddressAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressAddr5	12	VARCHAR	41	True	False	False	False	%s
AddressCity	12	VARCHAR	31	True	False	False	False	%s
AddressState	12	VARCHAR	21	True	False	False	False	%s
AddressProvince	12	VARCHAR	21	True	False	False	False	%s
AddressCounty	12	VARCHAR	21	True	False	False	False	%s
AddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
AddressCountry	12	VARCHAR	31	True	False	False	False	%s
AddressNote	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
AppliedToTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
AppliedToTxnTxnID	12	VARCHAR	36	True	False	False	True	%s
AppliedToTxnPaymentAmount	3	DECIMAL	17	True	False	False	False	%10.2f
AppliedToTxnTxnType	12	VARCHAR	14	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
AppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
AppliedToTxnBalanceRemaining	3	DECIMAL	17	True	False	False	False	%10.2f
AppliedToTxnAmount	3	DECIMAL	17	True	False	False	False	%10.2f
AppliedToTxnSetCreditCreditTxnID	12	VARCHAR	36	True	False	False	False	%s
AppliedToTxnSetCreditAppliedAmount	3	DECIMAL	17	True	False	False	False	%10.2f
AppliedToTxnDiscountAmount	3	DECIMAL	17	True	False	False	False	%10.2f
AppliedToTxnDiscountAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
AppliedToTxnDiscountAccountRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
AppliedToTxnDiscountClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
AppliedToTxnDiscountClassRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
AppliedToTxnLinkedTxnTxnID	12	VARCHAR	36	True	False	False	True	%s
AppliedToTxnLinkedTxnTxnType	12	VARCHAR	14	True	False	False	False	ARRefundCreditCard Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment
AppliedToTxnLinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AppliedToTxnLinkedTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
AppliedToTxnLinkedTxnLinkType	12	VARCHAR	14	True	False	False	False	AMTTYPE QUANTYPE
AppliedToTxnLinkedTxnAmount	3	DECIMAL	18	True	False	False	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillPaymentCreditCard

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
PayeeEntityRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	False	True	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
TxnDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
CreditCardAccountRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
CreditCardAccountRefFullName	12	VARCHAR	159	True	False	True	True	%s	Yes
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	False	True	True	%s
Memo	12	VARCHAR	4095	True	False	True	False	%s

TABLE DETAIL REFERENCE: BillPaymentCreditCardLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
PayeeEntityRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	False	True	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
TxnDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
CreditCardAccountRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
CreditCardAccountRefFullName	12	VARCHAR	159	True	False	True	True	%s	Yes
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	False	True	True	%s
Memo	12	VARCHAR	4095	True	False	True	False	%s
AppliedToTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
AppliedToTxnTxnID	12	VARCHAR	36	True	False	True	True	%s
AppliedToTxnPaymentAmount	3	DECIMAL	18	True	False	True	False	%10.2f
AppliedToTxnTxnType	12	VARCHAR	14	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
AppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
AppliedToTxnBalanceRemaining	3	DECIMAL	18	True	False	False	False	%10.2f
AppliedToTxnAmount	3	DECIMAL	18	True	False	False	False	%10.2f
AppliedToTxnSetCreditCreditTxnID	12	VARCHAR	36	True	False	True	False	%s
AppliedToTxnSetCreditAppliedAmount	3	DECIMAL	18	True	False	True	False	%10.2f
AppliedToTxnDiscountAmount	3	DECIMAL	15	True	False	True	False	%10.2f
AppliedToTxnDiscountAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
AppliedToTxnDiscountAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
AppliedToTxnDiscountClassRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
AppliedToTxnDiscountClassRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillPaymentCreditCardLineLinkedTxn

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
PayeeEntityRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	False	True	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
TxnDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
CreditCardAccountRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
CreditCardAccountRefFullName	12	VARCHAR	159	True	False	True	True	%s	Yes
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	False	True	True	%s
Memo	12	VARCHAR	4095	True	False	True	False	%s
AppliedToTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
AppliedToTxnTxnID	12	VARCHAR	36	True	False	True	True	%s
AppliedToTxnPaymentAmount	3	DECIMAL	17	True	False	True	False	%10.2f
AppliedToTxnTxnType	12	VARCHAR	14	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
AppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
AppliedToTxnBalanceRemaining	3	DECIMAL	17	True	False	False	False	%10.2f
AppliedToTxnAmount	3	DECIMAL	17	True	False	False	False	%10.2f
AppliedToTxnSetCreditCreditTxnID	12	VARCHAR	36	True	False	True	False	%s
AppliedToTxnSetCreditAppliedAmount	3	DECIMAL	17	True	False	True	False	%10.2f
AppliedToTxnDiscountAmount	3	DECIMAL	17	True	False	True	False	%10.2f
AppliedToTxnDiscountAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
AppliedToTxnDiscountAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
AppliedToTxnDiscountClassRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
AppliedToTxnDiscountClassRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
AppliedToTxnLinkedTxnTxnID	12	VARCHAR	36	True	False	False	True	%s
AppliedToTxnLinkedTxnTxnType	12	VARCHAR	14	True	False	False	False	ARRefundCreditCard Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment
AppliedToTxnLinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AppliedToTxnLinkedTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
AppliedToTxnLinkedTxnLinkType	12	VARCHAR	14	True	False	False	False	AMTTYPE QUANTYPE
AppliedToTxnLinkedTxnAmount	3	DECIMAL	18	True	False	False	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillToPay

(USA VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
PayeeEntityRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
DueDateCutoff	9	DATE	6	True	False	False	False	CCCC-MM-DD
BillToPayTxnID	12	VARCHAR	36	True	False	False	False	%s
BillToPayTxnType	12	VARCHAR	14	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
BillToPayTxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
BillToPayAPAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BillToPayAPAccountRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
BillToPayTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
BillToPayRefNumber	12	VARCHAR	20	True	False	False	False	%s
BillToPayDueDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
BillToPayAmountDue	3	DECIMAL	18	True	False	False	False	%10.2f
BillToPayCurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BillToPayCurrencyRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
BillToPayExchangeRate	3	DECIMAL	18	True	False	False	False	%6.6f
BillToPayAmountDueInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
CreditToApplyTxnID	12	VARCHAR	36	True	False	False	False	%s
CreditToApplyTxnType	12	VARCHAR	14	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
CreditToApplyTxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
CreditToApplyAPAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CreditToApplyAPAccountRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
CreditToApplyTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
CreditToApplyRefNumber	12	VARCHAR	20	True	False	False	False	%s
CreditToApplyCreditRemaining	3	DECIMAL	17	True	False	False	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BuildAssembly

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
ItemInventoryAssemblyRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
ItemInventoryAssemblyRefFullName	12	VARCHAR	159	True	False	True	True	%s	Yes
InventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
InventorySiteLocationRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InventorySiteLocationRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
SerialNumber	12	VARCHAR	4095	True	True	True	False	%s
LotNumber	12	VARCHAR	40	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	11	True	True	True	False	%s
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsPending	-7	BIT	1	True	False	False	False	1 0 true false
QuantityToBuild	3	DECIMAL	18	True	True	True	True	%10.5f
QuantityCanBuild	3	DECIMAL	18	True	False	False	False	%10.5f
QuantityOnHand	3	DECIMAL	18	True	False	False	False	%10.5f
QuantityOnSalesOrder	3	DECIMAL	18	True	False	False	False	%10.5f
MarkPendingIfRequired	-7	BIT	1	True	True	True	False	1 0 true false
RemovePending	-7	BIT	1	True	True	False	False	1 0 true false

TABLE DETAIL REFERENCE: BuildAssemblyComponentItemLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
ItemInventoryAssemblyRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
ItemInventoryAssemblyRefFullName	12	VARCHAR	159	True	False	True	True	%s	Yes
InventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
InventorySiteLocationRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InventorySiteLocationRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
SerialNumber	12	VARCHAR	4095	True	True	True	False	%s
LotNumber	12	VARCHAR	40	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	11	True	True	True	False	%s
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsPending	-7	BIT	1	True	False	False	False	1 0 true false
QuantityToBuild	3	DECIMAL	18	True	True	True	True	%10.5f
QuantityCanBuild	3	DECIMAL	18	True	False	False	False	%10.5f
QuantityOnHand	3	DECIMAL	18	True	False	False	False	%10.5f
QuantityOnSalesOrder	3	DECIMAL	18	True	False	False	False	%10.5f
MarkPendingIfRequired	-7	BIT	1	True	True	True	False	1 0 true false
RemovePending	-7	BIT	1	True	True	False	False	1 0 true false
ComponentItemLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ComponentItemLineItemRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ComponentItemLineItemRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
ComponentItemLineInventorySiteRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ComponentItemLineInventorySiteRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
ComponentItemLineInventorySiteLocationRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ComponentItemLineInventorySiteLocationRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
ComponentItemLineSerialNumber	12	VARCHAR	4095	True	True	True	False	%s
ComponentItemLineLotNumber	12	VARCHAR	40	True	True	True	False	%s
ComponentItemLineDesc	12	VARCHAR	4095	True	False	False	False	%s
ComponentItemLineQuantityOnHand	3	DECIMAL	18	True	False	False	False	%10.5f
ComponentItemLineQuantityNeeded	3	DECIMAL	18	True	False	False	False	%10.5f
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Charge

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
CustomerRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
CustomerRefFullName	12	VARCHAR	209	True	True	True	True	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	11	True	True	True	False	%s
ItemRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
InventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
InventorySiteLocationRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InventorySiteLocationRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
Quantity	3	DECIMAL	18	True	True	True	False	%10.5f
UnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
OverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
OverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
Rate	3	DECIMAL	18	True	True	True	False	%10.5f
OptionForPriceRuleConflict	12	VARCHAR	23	False	True	True	False	Zero BasePrice
Amount	3	DECIMAL	18	True	True	True	False	%10.2f
BalanceRemaining	3	DECIMAL	18	True	False	False	False	%10.2f
Desc	12	VARCHAR	4095	True	True	True	False	%s
Description	12	VARCHAR	4095	True	True	True	False	%s
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
BilledDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
OverrideItemAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
OverrideItemAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: ChargeLinkedTxn

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
CustomerRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
CustomerRefFullName	12	VARCHAR	209	True	False	False	True	%s	Yes
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	11	True	False	False	False	%s
ItemRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
ItemRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
InventorySiteRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
InventorySiteRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
InventorySiteLocationRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
InventorySiteLocationRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
Quantity	3	DECIMAL	18	True	False	False	False	%10.5f
UnitOfMeasure	12	VARCHAR	31	True	False	False	False	%s	Yes
OverrideUOMSetRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
OverrideUOMSetRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
Rate	3	DECIMAL	18	True	False	False	False	%10.5f
OptionForPriceRuleConflict	12	VARCHAR	23	False	False	False	False	Zero BasePrice
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
BalanceRemaining	3	DECIMAL	18	True	False	False	False	%10.2f
Desc	12	VARCHAR	4095	True	False	False	False	%s
Description	12	VARCHAR	4095	True	False	False	False	%s
ARAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
ClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ClassRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
BilledDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
DueDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
OverrideItemAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
OverrideItemAccountRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
LinkedTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
LinkedTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
LinkedTxnTxnType	12	VARCHAR	21	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
LinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
LinkedTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
LinkedTxnLinkType	12	VARCHAR	8	True	False	False	False	AMTTYPE QUANTYPE
LinkedTxnAmount	3	DECIMAL	18	True	False	False	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Check

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
RefNumber	12	VARCHAR	11	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
Memo	12	VARCHAR	4095	True	True	True	False	%s
AddressAddr1	12	VARCHAR	41	True	True	True	False	%s
AddressAddr2	12	VARCHAR	41	True	True	True	False	%s
AddressAddr3	12	VARCHAR	41	True	True	True	False	%s
AddressAddr4	12	VARCHAR	41	True	True	True	False	%s
AddressAddr5	12	VARCHAR	41	True	True	True	False	%s
AddressCity	12	VARCHAR	31	True	True	True	False	%s
AddressState	12	VARCHAR	21	True	True	True	False	%s
AddressProvince	12	VARCHAR	21	True	True	True	False	%s
AddressCounty	12	VARCHAR	21	True	True	True	False	%s
AddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
AddressCountry	12	VARCHAR	31	True	True	True	False	%s
AddressNote	12	VARCHAR	41	True	True	True	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: CheckApplyCheckToTxn

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
RefNumber	12	VARCHAR	11	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
Memo	12	VARCHAR	4095	True	True	True	False	%s
AddressAddr1	12	VARCHAR	41	True	True	True	False	%s
AddressAddr2	12	VARCHAR	41	True	True	True	False	%s
AddressAddr3	12	VARCHAR	41	True	True	True	False	%s
AddressAddr4	12	VARCHAR	41	True	True	True	False	%s
AddressAddr5	12	VARCHAR	41	True	True	True	False	%s
AddressCity	12	VARCHAR	31	True	True	True	False	%s
AddressState	12	VARCHAR	21	True	True	True	False	%s
AddressProvince	12	VARCHAR	21	True	True	True	False	%s
AddressCounty	12	VARCHAR	21	True	True	True	False	%s
AddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
AddressCountry	12	VARCHAR	31	True	True	True	False	%s
AddressNote	12	VARCHAR	41	True	True	True	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ApplyCheckToTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ApplyCheckToTxnTxnID	12	VARCHAR	36	True	True	True	False	%sf
ApplyCheckToTxnAmount	3	DECIMAL	18	True	True	True	False	%10.2f
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CheckExpenseLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
RefNumber	12	VARCHAR	11	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
Memo	12	VARCHAR	4095	True	True	True	False	%s
AddressAddr1	12	VARCHAR	41	True	True	True	False	%s
AddressAddr2	12	VARCHAR	41	True	True	True	False	%s
AddressAddr3	12	VARCHAR	41	True	True	True	False	%s
AddressAddr4	12	VARCHAR	41	True	True	True	False	%s
AddressAddr5	12	VARCHAR	41	True	True	True	False	%s
AddressCity	12	VARCHAR	31	True	True	True	False	%s
AddressState	12	VARCHAR	21	True	True	True	False	%s
AddressProvince	12	VARCHAR	21	True	True	True	False	%s
AddressCounty	12	VARCHAR	21	True	True	True	False	%s
AddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
AddressCountry	12	VARCHAR	31	True	True	True	False	%s
AddressNote	12	VARCHAR	41	True	True	True	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineClearExpenseLines	-7	BIT	1	True	True	False	False	1 0 true false
ExpenseLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ExpenseLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ExpenseLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ExpenseLineAmount	3	DECIMAL	18	True	True	True	False	%10.2f
ExpenseLineTaxAmount	3	DECIMAL	17	True	False	False	False	%10.2f
ExpenseLineTax1Amount	3	DECIMAL	17	True	False	False	False	%10.2f
ExpenseLineMemo	12	VARCHAR	4095	True	True	True	False	%s
ExpenseLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ExpenseLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ExpenseLineSalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
ExpenseLineSalesRepRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineSalesRepRefFullName	12	VARCHAR	5	True	True	True	False	%s	Yes
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CheckItemLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
RefNumber	12	VARCHAR	11	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
Memo	12	VARCHAR	4095	True	True	True	False	%s
AddressAddr1	12	VARCHAR	41	True	True	True	False	%s
AddressAddr2	12	VARCHAR	41	True	True	True	False	%s
AddressAddr3	12	VARCHAR	41	True	True	True	False	%s
AddressAddr4	12	VARCHAR	41	True	True	True	False	%s
AddressAddr5	12	VARCHAR	41	True	True	True	False	%s
AddressCity	12	VARCHAR	31	True	True	True	False	%s
AddressState	12	VARCHAR	21	True	True	True	False	%s
AddressProvince	12	VARCHAR	21	True	True	True	False	%s
AddressCounty	12	VARCHAR	21	True	True	True	False	%s
AddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
AddressCountry	12	VARCHAR	31	True	True	True	False	%s
AddressNote	12	VARCHAR	41	True	True	True	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ItemLineClearItemLines	-7	BIT	1	True	True	False	False	1 0 true false
ItemLineType	12	VARCHAR	11	True	False	False	False	ItemType
ItemLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ItemGroupLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemGroupLineItemRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemGroupLineItemRefFullName	12	VARCHAR	31	True	True	True	True	%s	Yes
ItemGroupLineDesc	12	VARCHAR	4095	True	False	False	False	%s
ItemGroupLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
ItemGroupLineUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemGroupLineInventorySiteRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteLocationRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteLocationRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
ItemGroupLineOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemGroupLineOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemGroupLineTotalAmount	3	DECIMAL	18	True	False	False	False	%10.5f
ItemGroupSeqNo	4	INTEGER	4	True	False	False	False	SubSeqNo
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
ItemLineInventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineInventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineInventorySiteLocationRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemlineInventorySiteLocationRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineSerialNumber	12	VARCHAR	4095	True	True	True	False	%s
ItemLineLotNumber	12	VARCHAR	40	True	True	True	False	%s
ItemLineDesc	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemLineOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemLineCost	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineAmount	3	DECIMAL	18	True	True	True	False	%10.2f
ItemLineTaxAmount	3	DECIMAL	17	True	False	False	False	%10.2f
ItemLineTax1Amount	3	DECIMAL	17	True	False	False	False	%10.2f
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ItemLineSalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
ItemLineOverrideItemAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineOverrideItemAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ItemLineSalesRepRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineSalesRepRefFullName	12	VARCHAR	5	True	True	True	False	%s	Yes
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey
FQTxnLinkKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Class

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	31	True	True	True	True	%s
FullName	12	VARCHAR	159	True	False	False	False	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
ParentRefListID	12	VARCHAR	36	True	True	True	False	%s
ParentRefFullName	12	VARCHAR	159	True	True	True	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f

TABLE DETAIL REFERENCE: ClearedStatus

(USA VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
TxnID	12	VARCHAR	36	True	False	True	True	%s
TxnLineID	12	VARCHAR	36	True	False	True	False	%s
ClearedStatus	12	VARCHAR	10	True	False	True	True	Cleared NotCleared Pending
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Company

(USA 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	59	True	False	False	False	%s
LegalCompanyName	12	VARCHAR	59	True	False	False	False	%s
AddressAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressAddr5	12	VARCHAR	41	True	False	False	False	%s
AddressCity	12	VARCHAR	31	True	False	False	False	%s
AddressState	12	VARCHAR	21	True	False	False	False	%s
AddressProvince	12	VARCHAR	21	True	False	False	False	%s
AddressCounty	12	VARCHAR	21	True	False	False	False	%s
AddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
AddressCountry	12	VARCHAR	31	True	False	False	False	%s
AddressNote	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
AddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
LegalAddressAddr1	12	VARCHAR	41	True	False	False	False	%s
LegalAddressAddr2	12	VARCHAR	41	True	False	False	False	%s
LegalAddressAddr3	12	VARCHAR	41	True	False	False	False	%s
LegalAddressAddr4	12	VARCHAR	41	True	False	False	False	%s
LegalAddressAddr5	12	VARCHAR	41	True	False	False	False	%s
LegalAddressCity	12	VARCHAR	31	True	False	False	False	%s
LegalAddressState	12	VARCHAR	21	True	False	False	False	%s
LegalAddressProvince	12	VARCHAR	21	True	False	False	False	%s
LegalAddressCounty	12	VARCHAR	21	True	False	False	False	%s
LegalAddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
LegalAddressCountry	12	VARCHAR	31	True	False	False	False	%s
LegalAddressNote	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressForCustomerAddr1	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressForCustomerAddr2	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressForCustomerAddr3	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressForCustomerAddr4	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressForCustomerAddr5	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressForCustomerCity	12	VARCHAR	31	True	False	False	False	%s
CompanyAddressForCustomerState	12	VARCHAR	21	True	False	False	False	%s
CompanyAddressForCustomerProvince	12	VARCHAR	21	True	False	False	False	%s
CompanyAddressForCustomerCounty	12	VARCHAR	21	True	False	False	False	%s
CompanyAddressForCustomerPostalCode	12	VARCHAR	13	True	False	False	False	%s
CompanyAddressForCustomerCountry	12	VARCHAR	31	True	False	False	False	%s
CompanyAddressForCustomerNote	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressBlockForCustomerAddr1	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressBlockForCustomerAddr2	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressBlockForCustomerAddr3	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressBlockForCustomerAddr4	12	VARCHAR	41	True	False	False	False	%s
CompanyAddressBlockForCustomerAddr5	12	VARCHAR	41	True	False	False	False	%s
Phone	12	VARCHAR	51	True	False	False	False	%s
Fax	12	VARCHAR	51	True	False	False	False	%s
Email	12	VARCHAR	99	True	False	False	False	%s
CompanyWebSite	12	VARCHAR	128	True	False	False	False	%s
FirstMonthFiscalYear	12	VARCHAR	9	True	False	False	False	January February March April May June July August September October November December
FirstMonthIncomeTaxYear	12	VARCHAR	9	True	False	False	False	January February March April May June July August September October November December
CompanyType	12	VARCHAR	255	True	False	False	False	%s
EIN	12	VARCHAR	20	True	False	False	False	%s
SSN	12	VARCHAR	11	True	False	False	False	%s
TaxForm	12	VARCHAR	11	True	False	False	False	Form1120 Form1120S Form1065 Form990 Form990PF Form990T Form1040 OtherOrNone
BusinessNumber	12	VARCHAR	16	True	False	False	False	%s
SubscribedServicesServiceName	12	VARCHAR	50	True	False	False	False	%s
SubscribedServicesServiceDomain	12	VARCHAR	50	True	False	False	False	%s
SubscribedServicesServiceServiceStatus	12	VARCHAR	10	True	False	False	False	Active Expired Never Pending Suspended Terminated Trial
AccountantCopyAccountantCopyExists	-7	BIT	1	True	False	False	False	1 0 true false
AccountantCopyDividingDate	9	DATE	6	True	False	False	False	CCCC-MM-DD

TABLE DETAIL REFERENCE: CompanyActivity

(USA VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
Id	4	INTEGER	4	True	False	False	False	FQID
LastRestoreTime	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
LastCondenseTime	11	TIMESTAMP	16	True	False	False	False

TABLE DETAIL REFERENCE: CreditCardCharge

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	True	True	False	%s
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsTaxIncluded	-7	BIT	1	True	True	True	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: CreditCardChargeExpenseLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	True	True	False	%s
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsTaxIncluded	-7	BIT	1	True	True	True	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineClearExpenseLines	-7	BIT	1	False	True	False	False	1 0 true false
ExpenseLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ExpenseLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ExpenseLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ExpenseLineAmount	3	DECIMAL	18	True	True	True	False	%10.2f
ExpenseLineTaxAmount	3	DECIMAL	17	True	False	False	False	%10.2f
ExpenseLineTax1Amount	3	DECIMAL	17	True	False	False	False	%10.2f
ExpenseLineMemo	12	VARCHAR	4095	True	True	True	False	%s
ExpenseLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ExpenseLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ExpenseLineSalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CreditCardChargeItemLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	True	True	False	%s
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsTaxIncluded	-7	BIT	1	True	True	True	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ItemLineClearItemLines	-7	BIT	1	True	True	False	False	1 0 true false
ItemLineType	12	VARCHAR	11	True	False	False	False	ItemType
ItemLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ItemGroupLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemGroupLineItemRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemGroupLineItemRefFullName	12	VARCHAR	31	True	True	True	True	%s	Yes
ItemGroupLineDesc	12	VARCHAR	4095	True	False	False	False	%s
ItemGroupLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineGroupUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemGroupLineInventorySiteRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteLocationRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteLocationRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
ItemLineGroupOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemLineGroupOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemGroupLineTotalAmount	3	DECIMAL	18	True	False	True	False	%10.5f
ItemGroupSeqNo	4	INTEGER	4	True	False	False	False	SubSeqNo
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
ItemLineInventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineInventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineInventorySiteLocationRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineInventorySiteLocationRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineSerialNumber	12	VARCHAR	4095	True	True	True	False	%s
ItemLineLotNumber	12	VARCHAR	40	True	True	True	False	%s
ItemLineDesc	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemLineOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemLineCost	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineAmount	3	DECIMAL	18	True	True	True	False	%10.2f
ItemLineTaxAmount	3	DECIMAL	15	True	False	False	False	%10.2f
ItemLineTax1Amount	3	DECIMAL	15	True	False	False	False	%10.2f
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ItemLineSalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
ItemLineOverrideItemAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineOverrideItemAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey
FQTxnLinkKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CreditCardCredit

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	True	True	False	%s
Memo	12	VARCHAR	4095	True	True	True	False	%s
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: CreditCardCreditExpenseLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	True	True	False	%s
Memo	12	VARCHAR	4095	True	True	True	False	%s
ExpenseLineClearExpenseLines	-7	BIT	1	True	True	False	False	1 0 true false
ExpenseLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ExpenseLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ExpenseLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ExpenseLineAmount	3	DECIMAL	18	True	True	True	False	%10.2f
ExpenseLineTaxAmount	3	DECIMAL	17	True	False	False	False	%10.2f
ExpenseLineTax1Amount	3	DECIMAL	17	True	False	False	False	%10.2f
ExpenseLineMemo	12	VARCHAR	4095	True	True	True	False	%s
ExpenseLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ExpenseLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ExpenseLineSalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CreditCardCreditItemLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
Amount	3	DECIMAL	18	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	True	True	False	%s
Memo	12	VARCHAR	4095	True	True	True	False	%s
ItemLineClearItemLines	-7	BIT	1	True	True	False	False	1 0 true false
ItemLineType	12	VARCHAR	11	True	False	False	False	ItemType
ItemLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ItemGroupLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemGroupLineItemRefListID	12	VARCHAR	36	True	True	False	True	%s	Yes
ItemGroupLineItemRefFullName	12	VARCHAR	31	True	True	False	True	%s	Yes
ItemGroupLineDesc	12	VARCHAR	4095	True	False	False	False	%s
ItemGroupLineQuantity	3	DECIMAL	18	True	True	False	False	%10.5f
ItemLineGroupUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemGroupLineInventorySiteRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteLocationRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
ItemGroupLineInventorySiteLocationRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
ItemLineGroupOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemLineGroupOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemGroupLineTotalAmount	3	DECIMAL	18	True	False	False	False	%10.5f
ItemGroupSeqNo	4	INTEGER	4	True	False	False	False	SubSeqNo
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
ItemLineInventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineInventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineInventorySiteLocationRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineInventorySiteLocationRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineSerialNumber	12	VARCHAR	4095	True	True	True	False	%s
ItemLineLotNumber	12	VARCHAR	40	True	True	True	False	%s
ItemLineDesc	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
ItemLineOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
ItemLineOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
ItemLineCost	3	DECIMAL	18	True	True	True	False	%10.5f
ItemLineAmount	3	DECIMAL	18	True	True	True	False	%10.2f
ItemLineTaxAmount	3	DECIMAL	17	True	False	False	False	%10.2f
ItemLineTax1Amount	3	DECIMAL	17	True	False	False	False	%10.2f
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
ItemLineOverrideItemAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineOverrideItemAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey
FQTxnLinkKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CreditMemo

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
CustomerRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
CustomerRefFullName	12	VARCHAR	209	True	True	True	True	%s	Yes
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TemplateRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TemplateRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	11	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	41	True	True	True	False	%s
BillAddressCity	12	VARCHAR	31	True	True	True	False	%s
BillAddressState	12	VARCHAR	21	True	True	True	False	%s
BillAddressProvince	12	VARCHAR	21	True	True	True	False	%s
BillAddressCounty	12	VARCHAR	21	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	31	True	True	True	False	%s
BillAddressNote	12	VARCHAR	41	True	True	True	False	%s
BillAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	41	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	31	True	True	True	False	%s
ShipAddressState	12	VARCHAR	21	True	True	True	False	%s
ShipAddressProvince	12	VARCHAR	21	True	True	True	False	%s
ShipAddressCounty	12	VARCHAR	21	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	31	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	41	True	True	True	False	%s
ShipAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
IsPending	-7	BIT	1	True	True	True	False	1 0 true false
PONumber	12	VARCHAR	25	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
SalesRepRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesRepRefFullName	12	VARCHAR	5	True	True	True	False	%s	Yes
FOB	12	VARCHAR	13	True	True	True	False	%s
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
ShipMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	15	True	True	True	False	%s	Yes
Subtotal	3	DECIMAL	18	True	False	False	False	%10.2f
ItemSalesTaxRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemSalesTaxRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
SalesTaxPercentage	3	DECIMAL	18	True	False	False	False	%10.5f
SalesTaxTotal	3	DECIMAL	18	True	False	False	False	%10.2f
TotalAmount	3	DECIMAL	18	True	False	False	False	%10.2f
CreditRemaining	3	DECIMAL	15	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	101	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
Memo	12	VARCHAR	4095	True	True	True	False	%s
CustomerMsgRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerMsgRefFullName	12	VARCHAR	101	True	True	True	False	%s	Yes
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
IsToBeEmailed	-7	BIT	1	True	True	True	False	1 0 true false
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	True	False	%s	Yes
CustomerSalesTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
CustomerTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomFieldOther	12	VARCHAR	29	True	True	True	False	%s
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
CustomFieldShipAccount	12	VARCHAR	30	True	True	True	False	%s
CustomFieldShipMethod	12	VARCHAR	30	True	True	True	False	%s
CustomFieldShipVendor	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: CreditMemoLine

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
CustomerRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
CustomerRefFullName	12	VARCHAR	209	True	True	True	True	%s	Yes
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TemplateRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TemplateRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	11	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	41	True	True	True	False	%s
BillAddressCity	12	VARCHAR	31	True	True	True	False	%s
BillAddressState	12	VARCHAR	21	True	True	True	False	%s
BillAddressProvince	12	VARCHAR	21	True	True	True	False	%s
BillAddressCounty	12	VARCHAR	21	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	31	True	True	True	False	%s
BillAddressNote	12	VARCHAR	41	True	True	True	False	%s
BillAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	41	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	31	True	True	True	False	%s
ShipAddressState	12	VARCHAR	21	True	True	True	False	%s
ShipAddressProvince	12	VARCHAR	21	True	True	True	False	%s
ShipAddressCounty	12	VARCHAR	21	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	31	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	41	True	True	True	False	%s
ShipAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
IsPending	-7	BIT	1	True	True	True	False	1 0 true false
PONumber	12	VARCHAR	25	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
SalesRepRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesRepRefFullName	12	VARCHAR	5	True	True	True	False	%s	Yes
FOB	12	VARCHAR	13	True	True	True	False	%s
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
ShipMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	15	True	True	True	False	%s	Yes
Subtotal	3	DECIMAL	18	True	False	False	False	%10.2f
ItemSalesTaxRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemSalesTaxRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
SalesTaxPercentage	3	DECIMAL	18	True	False	False	False	%10.5f
SalesTaxTotal	3	DECIMAL	18	True	False	False	False	%10.2f
TotalAmount	3	DECIMAL	18	True	False	False	False	%10.2f
CreditRemaining	3	DECIMAL	15	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	101	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	17	True	True	True	False	%6.8f
Memo	12	VARCHAR	4095	True	True	True	False	%s
CustomerMsgRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerMsgRefFullName	12	VARCHAR	101	True	True	True	False	%s	Yes
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
IsToBeEmailed	-7	BIT	1	True	True	True	False	1 0 true false
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	True	False	%s	Yes
CustomerSalesTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
CustomerTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomFieldOther	12	VARCHAR	29	True	True	True	False	%s
CreditMemoLineType	12	VARCHAR	11	True	False	False	False	ItemType
CreditMemoLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
CreditMemoLineGroupLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
CreditMemoLineGroupItemGroupRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineGroupItemGroupRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
CreditMemoLineGroupDesc	12	VARCHAR	4095	True	False	False	False	%s
CreditMemoLineGroupQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
CreditMemoLineGroupUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
CreditMemoLineGroupInventorySiteRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
CreditMemoLineGroupInventorySiteRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
CreditMemoLineGroupInventorySiteLocationRefListID	12	VARCHAR	36	False	False	True	False	%s	Yes
CreditMemoLineGroupInventorySiteLocationRefFullName	12	VARCHAR	31	False	False	True	False	%s	Yes
CreditMemoLineGroupOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
CreditMemoLineGroupOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
CreditMemoLineGroupIsPrintItemsInGroup	-7	BIT	1	True	False	False	False	1 0 true false
CreditMemoLineGroupTotalAmount	3	DECIMAL	18	True	False	False	False	%10.2f
CreditMemoLineGroupServiceDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
CreditMemoLineGroupSeqNo	4	INTEGER	4	True	False	False	False	SubSeqNo
CreditMemoLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
CreditMemoLineItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineItemRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
CreditMemoLineDesc	12	VARCHAR	4095	True	True	True	False	%s
CreditMemoLineQuantity	3	DECIMAL	18	True	True	True	False	%10.5f
CreditMemoLineUnitOfMeasure	12	VARCHAR	31	True	True	True	False	%s	Yes
CreditMemoLineOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
CreditMemoLineOverrideUOMSetRefFullName	12	VARCHAR	31	True	True	False	False	%s	Yes
CreditMemoLineRate	3	DECIMAL	18	True	True	True	False	%10.5f
CreditMemoLineRatePercent	3	DECIMAL	15	True	True	True	False	%7.5f
CreditMemoLinePriceLevelRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLinePriceLevelRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
CreditMemoLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
CreditMemoLineAmount	3	DECIMAL	18	True	True	True	False	%10.2f
CreditMemoLineInventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineInventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
CreditMemoLineInventorySiteLocationRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineInventorySiteLocationRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
CreditMemoLineSerialNumber	12	VARCHAR	4095	True	True	True	False	%s
CreditMemoLineLotNumber	12	VARCHAR	40	True	True	True	False	%s
CreditMemoLineTaxAmount	3	DECIMAL	17	True	False	False	False	%10.2f
CreditMemoLineServiceDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
CreditMemoLineSalesTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
CreditMemoLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
CreditMemoLineOverrideItemAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineOverrideItemAccountRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
CustomFieldCreditMemoLineOther1	12	VARCHAR	29	True	True	True	False	%s
CustomFieldCreditMemoLineOther2	12	VARCHAR	29	True	True	True	False	%s
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey
FQTxnLinkKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey
CustomFieldCreditMemoLineALU	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineALU2	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineApproved	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineColor	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineCompletedby	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineCustomer	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineInspectedBy	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineOrdered	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLinePulled	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLinePulledby	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineQtyPriceBreak	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineRequiredDate	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineStartDate	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineStyle	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupALU	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupALU2	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupApproved	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupColor	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupCompletedby	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupCustomer	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupInspectedBy	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupOrdered	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupPulled	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupPulledby	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupQtyPriceBreak	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupRequiredDate	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupStartDate	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupStyle	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineALU	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineALU2	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineApproved	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineColor	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineCompletedby	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineCustomer	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineInspectedBy	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineOrdered	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLinePulled	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLinePulledby	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineQtyPriceBreak	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineRequiredDate	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineStartDate	12	VARCHAR	30	True	True	False	False	%s
CustomFieldCreditMemoLineGroupLineStyle	12	VARCHAR	30	True	True	False	False	%s
CustomFieldShipAccount	12	VARCHAR	30	True	True	True	False	%s
CustomFieldShipMethod	12	VARCHAR	30	True	True	True	False	%s
CustomFieldShipVendor	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: CreditMemoLinkedTxn

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
CustomerRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
CustomerRefFullName	12	VARCHAR	209	True	False	False	True	%s	Yes
ClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ClassRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
TemplateRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TemplateRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	11	True	False	False	False	%s
BillAddressAddr1	12	VARCHAR	41	True	False	False	False	%s
BillAddressAddr2	12	VARCHAR	41	True	False	False	False	%s
BillAddressAddr3	12	VARCHAR	41	True	False	False	False	%s
BillAddressAddr4	12	VARCHAR	41	True	False	False	False	%s
BillAddressAddr5	12	VARCHAR	41	True	False	False	False	%s
BillAddressCity	12	VARCHAR	31	True	False	False	False	%s
BillAddressState	12	VARCHAR	21	True	False	False	False	%s
BillAddressProvince	12	VARCHAR	21	True	False	False	False	%s
BillAddressCounty	12	VARCHAR	21	True	False	False	False	%s
BillAddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
BillAddressCountry	12	VARCHAR	31	True	False	False	False	%s
BillAddressNote	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressCity	12	VARCHAR	31	True	False	False	False	%s
ShipAddressState	12	VARCHAR	21	True	False	False	False	%s
ShipAddressProvince	12	VARCHAR	21	True	False	False	False	%s
ShipAddressCounty	12	VARCHAR	21	True	False	False	False	%s
ShipAddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
ShipAddressCountry	12	VARCHAR	31	True	False	False	False	%s
ShipAddressNote	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
IsPending	-7	BIT	1	True	False	False	False	1 0 true false
PONumber	12	VARCHAR	25	True	False	False	False	%s
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
DueDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
SalesRepRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesRepRefFullName	12	VARCHAR	5	True	False	False	False	%s	Yes
FOB	12	VARCHAR	13	True	False	False	False	%s
ShipDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
ShipMethodRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	15	True	False	False	False	%s	Yes
Subtotal	3	DECIMAL	18	True	False	False	False	%10.2f
ItemSalesTaxRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemSalesTaxRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
SalesTaxPercentage	3	DECIMAL	18	True	False	False	False	%10.5f
SalesTaxTotal	3	DECIMAL	18	True	False	False	False	%10.2f
TotalAmount	3	DECIMAL	18	True	False	False	False	%10.2f
CreditRemaining	3	DECIMAL	15	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	101	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	17	True	False	False	False	%6.8f
Memo	12	VARCHAR	4095	True	False	False	False	%s
CustomerMsgRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CustomerMsgRefFullName	12	VARCHAR	101	True	False	False	False	%s	Yes
IsToBePrinted	-7	BIT	1	True	False	False	False	1 0 true false
IsToBeEmailed	-7	BIT	1	True	False	False	False	1 0 true false
IsTaxIncluded	-7	BIT	1	True	False	False	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
CustomerSalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CustomerSalesTaxCodeRefFullName	12	VARCHAR	3	True	False	False	False	%s	Yes
CustomerTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CustomFieldOther	12	VARCHAR	29	True	False	False	False	%s
LinkedTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
LinkedTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
LinkedTxnTxnType	12	VARCHAR	21	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
LinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
LinkedTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
LinkedTxnAmount	3	DECIMAL	18	True	False	False	False	%10.2f
Tax1Total	3	DECIMAL	17	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	17	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey
CustomFieldShipAccount	12	VARCHAR	30	True	True	True	False	%s
CustomFieldShipMethod	12	VARCHAR	30	True	True	True	False	%s
CustomFieldShipVendor	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: Currency

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	64	True	True	True	True	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
CurrencyCode	12	VARCHAR	3	True	True	True	True	%s
CurrencyFormatThousandSeparator	12	VARCHAR	10	True	True	True	False	Comma Period Space Apostrophe
CurrencyFormatThousandSeparatorGrouping	12	VARCHAR	11	True	True	True	False	XX_XXX_XXX X_XX_XX_XXX
CurrencyFormatDecimalPlaces	12	VARCHAR	1	True	True	True	False	0 2
CurrencyFormatDecimalSeparator	12	VARCHAR	6	True	True	True	False	Period Comma
IsUserDefinedCurrency	-7	BIT	1	True	False	False	False	1 0 true false
ExchangeRate	3	DECIMAL	34	True	False	False	False	%6.8f
AsOfDate	9	DATE	6	True	False	False	False	CCCC-MM-DD

TABLE DETAIL REFERENCE: Customer

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	41	True	True	True	True	%s
FullName	12	VARCHAR	209	True	False	False	False	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ParentRefListID	12	VARCHAR	36	True	True	True	False	%s
ParentRefFullName	12	VARCHAR	209	True	True	True	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
CompanyName	12	VARCHAR	41	True	True	True	False	%s
Salutation	12	VARCHAR	15	True	True	True	False	%s
FirstName	12	VARCHAR	25	True	True	True	False	%s
MiddleName	12	VARCHAR	5	True	True	True	False	%s
LastName	12	VARCHAR	25	True	True	True	False	%s
JobTitle	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	41	True	True	True	False	%s
BillAddressCity	12	VARCHAR	31	True	True	True	False	%s
BillAddressState	12	VARCHAR	21	True	True	True	False	%s
BillAddressProvince	12	VARCHAR	21	True	True	True	False	%s
BillAddressCounty	12	VARCHAR	21	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	31	True	True	True	False	%s
BillAddressNote	12	VARCHAR	41	True	True	True	False	%s
BillAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	41	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	31	True	True	True	False	%s
ShipAddressState	12	VARCHAR	21	True	True	True	False	%s
ShipAddressProvince	12	VARCHAR	21	True	True	True	False	%s
ShipAddressCounty	12	VARCHAR	21	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	31	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	41	True	True	True	False	%s
ShipAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
AltPhone	12	VARCHAR	21	True	True	True	False	%s
Fax	12	VARCHAR	21	True	True	True	False	%s
Email	12	VARCHAR	1023	True	True	True	False	%s
Cc	12	VARCHAR	1023	True	True	True	False	%s
Contact	12	VARCHAR	41	True	True	True	False	%s
AltContact	12	VARCHAR	41	True	True	True	False	%s
AdditionalContactRef1ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef1ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef2ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef2ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef3ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef3ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef4ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef4ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef5ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef5ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef6ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef6ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef7ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef7ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef8ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef8ContactValue	12	VARCHAR	255	True	True	True	False	%s
CustomerTypeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerTypeRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
SalesRepRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesRepRefFullName	12	VARCHAR	5	True	True	True	False	%s	Yes
Balance	3	DECIMAL	18	True	False	False	False	%10.2f
TotalBalance	3	DECIMAL	18	True	False	False	False	%10.2f
OpenBalance	3	DECIMAL	18	True	False	True	False	%10.2f
OpenBalanceDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
SalesTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ItemSalesTaxRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemSalesTaxRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
SalesTaxCountry	12	VARCHAR	31	True	True	True	False	Australia Canada UK
ResaleNumber	12	VARCHAR	15	True	True	True	False	%s
AccountNumber	12	VARCHAR	99	True	True	True	False	%s
BusinessNumber	12	VARCHAR	99	True	False	False	False	%s
CreditLimit	3	DECIMAL	17	True	True	True	False	%10.2f
PreferredPaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PreferredPaymentMethodRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
CreditCardInfoCreditCardNumber	12	VARCHAR	25	True	True	True	False	%s
CreditCardInfoExpirationMonth	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardInfoExpirationYear	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardInfoNameOnCard	12	VARCHAR	41	True	True	True	False	%s
CreditCardInfoCreditCardAddress	12	VARCHAR	41	True	True	True	False	%s
CreditCardInfoCreditCardPostalCode	12	VARCHAR	41	True	True	True	False	%s
JobStatus	12	VARCHAR	10	True	True	True	False	None Pending Awarded InProgress Closed NotAwarded
JobStartDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
JobProjectedEndDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
JobEndDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
JobDesc	12	VARCHAR	99	True	True	True	False	%s
JobTypeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JobTypeRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
Notes	12	VARCHAR	4095	True	True	True	False	%s
PreferredDeliveryMethod	12	VARCHAR	10	True	True	True	True	None Email Fax
IsUsingCustomerTaxCode	-7	BIT	1	True	False	False	False	1 0 true false
PriceLevelRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PriceLevelRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ExternalGUID	12	VARCHAR	40	True	False	True	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TaxRegistrationNumber	12	VARCHAR	30	True	False	False	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
CustomFieldShipAccount	12	VARCHAR	30	True	True	True	False	%s
CustomFieldShipMethod	12	VARCHAR	30	True	True	True	False	%s
CustomFieldShipVendor	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: CustomerAddtionalNote

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	41	True	True	True	True	%s
FullName	12	VARCHAR	209	True	False	False	False	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ParentRefListID	12	VARCHAR	36	True	True	True	False	%s
ParentRefFullName	12	VARCHAR	209	True	True	True	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
CompanyName	12	VARCHAR	41	True	True	True	False	%s
Salutation	12	VARCHAR	15	True	True	True	False	%s
FirstName	12	VARCHAR	25	True	True	True	False	%s
MiddleName	12	VARCHAR	5	True	True	True	False	%s
LastName	12	VARCHAR	25	True	True	True	False	%s
JobTitle	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	41	True	True	True	False	%s
BillAddressCity	12	VARCHAR	31	True	True	True	False	%s
BillAddressState	12	VARCHAR	21	True	True	True	False	%s
BillAddressProvince	12	VARCHAR	21	True	True	True	False	%s
BillAddressCounty	12	VARCHAR	21	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	31	True	True	True	False	%s
BillAddressNote	12	VARCHAR	41	True	True	True	False	%s
BillAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
BillAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	41	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	31	True	True	True	False	%s
ShipAddressState	12	VARCHAR	21	True	True	True	False	%s
ShipAddressProvince	12	VARCHAR	21	True	True	True	False	%s
ShipAddressCounty	12	VARCHAR	21	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	31	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	41	True	True	True	False	%s
ShipAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
AltPhone	12	VARCHAR	21	True	True	True	False	%s
Fax	12	VARCHAR	21	True	True	True	False	%s
Email	12	VARCHAR	1023	True	True	True	False	%s
Cc	12	VARCHAR	1023	True	True	True	False	%s
Contact	12	VARCHAR	41	True	True	True	False	%s
AltContact	12	VARCHAR </

QODBC.com Tools for QuickBooks