Details:ALL

TABLE DETAIL REFERENCE: Account

(UK 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 OtherIn
SpecialAccountType	12	VARCHAR	30	True	False	False	False	AccountsPayable AccountsReceivable CondenseItemAdjustmentExpenses CostOfGoodsSold DirectDepositLiabilities Estimates InventoryAssets OpeningBalanceEquity PayrollExpenses PayrollLiabilities PettyCash PÃÝoNþK±…=wvÉ€?n‚øÌ±‘TÍ$ÃÝoNþK±…=wvÉ0'^‚ø
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
Balance	3	DECIMAL	15	True	False	False	False	%10.2f
TotalBalance	3	DECIMAL	15	True	False	False	False	%10.2f
OpenBalance	3	DECIMAL	15	True	True	True	False	%10.2f
OpenBalanceDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	True	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	False	True	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

(UK 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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
RefNumber	12	VARCHAR	11	True	False	True	False	%s
TotalAmount	3	DECIMAL	15	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
RefNumber	12	VARCHAR	11	True	False	True	False	%s
TotalAmount	3	DECIMAL	15	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 LiabilityAdjusÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
RefundAppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
RefundAppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
RefundAppliedToTxnRefCreditRemaining	3	DECIMAL	15	True	False	False	False	%10.2f
RefundAppliedToTxnRefRefundAmount	3	DECIMAL	15	True	False	True	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BarCode

(UK 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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	15	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	15	True	True	True	False	%6.6f
AmountDueInHomeCurrency	3	DECIMAL	15	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	True	True	False	1 0 true false
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
LinkToTxnID1	12	VARCHAR	36	True	False	True	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
OpenAmount	3	DECIMAL	15	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: BillExpenseLine

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	15	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	15	True	True	True	False	%6.6f
AmountDueInHomeCurrency	3	DECIMAL	15	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	True	True	False	1 0 true false
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
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	15	True	True	True	False	%10.2f
ExpenseLineTaxAmount	3	DECIMAL	15	True	False	False	False	%10.2f
ExpenseLineTax1Amount	3	DECIMAL	15	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	True	True	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
OpenAmount	3	DECIMAL	15	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

TABLE DETAIL REFERENCE: BillingRate

(UK 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

(UK 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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	15	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	15	True	True	True	False	%6.6f
AmountDueInHomeCurrency	3	DECIMAL	15	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	True	True	False	1 0 true false
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
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
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	15	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	True	True	False	%s	Yes
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	3	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
ItemLineLinkToTxnTxnID	12	VARCHAR	36	True	False	True	False	%s
ItemLineLinkToTxnTxnLineID	12	VARCHAR	36	True	False	True	False	%s
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
OpenAmount	3	DECIMAL	15	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

TABLE DETAIL REFERENCE: BillLinkedTxn

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
DueDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AmountDue	3	DECIMAL	15	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	15	True	False	False	False	%6.6f
AmountDueInHomeCurrency	3	DECIMAL	15	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 LiabilityAdjusÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
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	15	True	False	False	False	%10.2f
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
OpenAmount	3	DECIMAL	15	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

TABLE DETAIL REFERENCE: BillPaymentCheck

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
BankAccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
BankAccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
Amount	3	DECIMAL	15	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	15	True	True	False	False	%6.6f
AmountInHomeCurrency	3	DECIMAL	15	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
BankAccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
BankAccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
Amount	3	DECIMAL	15	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	15	True	True	False	False	%6.6f
AmountInHomeCurrency	3	DECIMAL	15	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	15	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 LiabilityAdjusÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
AppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
AppliedToTxnBalanceRemaining	3	DECIMAL	15	True	False	False	False	%10.2f
AppliedToTxnAmount	3	DECIMAL	15	True	False	False	False	%10.2f
AppliedToTxnSetCreditCreditTxnID	12	VARCHAR	36	True	True	True	False	%s
AppliedToTxnSetCreditAppliedAmount	3	DECIMAL	15	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
BankAccountRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
BankAccountRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
Amount	3	DECIMAL	15	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	15	True	False	False	False	%6.6f
AmountInHomeCurrency	3	DECIMAL	15	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
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 JournalEÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
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	15	True	False	False	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillPaymentCreditCard

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
CreditCardAccountRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
CreditCardAccountRefFullName	12	VARCHAR	159	True	False	True	True	%s	Yes
Amount	3	DECIMAL	15	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
CreditCardAccountRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
CreditCardAccountRefFullName	12	VARCHAR	159	True	False	True	True	%s	Yes
Amount	3	DECIMAL	15	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	15	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 LiabilityAdjusÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
AppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
AppliedToTxnBalanceRemaining	3	DECIMAL	15	True	False	False	False	%10.2f
AppliedToTxnAmount	3	DECIMAL	15	True	False	False	False	%10.2f
AppliedToTxnSetCreditCreditTxnID	12	VARCHAR	36	True	False	True	False	%s
AppliedToTxnSetCreditAppliedAmount	3	DECIMAL	15	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
CreditCardAccountRefListID	12	VARCHAR	36	True	False	True	True	%s	Yes
CreditCardAccountRefFullName	12	VARCHAR	159	True	False	True	True	%s	Yes
Amount	3	DECIMAL	15	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	False	True	True	%s
Memo	12	VARCHAR	4095	True	False	True	False	%s
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 JournalEÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
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	15	True	False	False	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillToPay

(UK 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 LiabilityAdjusÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
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	15	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	15	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 LiabilityAdjusÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
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	15	True	False	False	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BuildAssembly

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
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
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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
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	15	True	True	True	False	%10.2f
BalanceRemaining	3	DECIMAL	15	True	False	False	False	%10.2f
Desc	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
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	15	True	False	False	False	%10.2f
BalanceRemaining	3	DECIMAL	15	True	False	False	False	%10.2f
Desc	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 LiabilityAdjusÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
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	15	True	False	False	False	%10.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Check

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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.6f
AmountInHomeCurrency	3	DECIMAL	15	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	True	True	False	1 0 true false
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
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: CheckApplyCheckToTxn

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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.6f
AmountInHomeCurrency	3	DECIMAL	15	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	True	True	False	1 0 true false
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
ApplyCheckToTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ApplyCheckToTxnTxnID	12	VARCHAR	36	True	True	True	False	%sf
ApplyCheckToTxnAmount	3	DECIMAL	15	True	True	True	False	%10.2f
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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.6f
AmountInHomeCurrency	3	DECIMAL	15	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	True	True	False	1 0 true false
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
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	15	True	True	True	False	%10.2f
ExpenseLineTaxAmount	3	DECIMAL	15	True	False	False	False	%10.2f
ExpenseLineTax1Amount	3	DECIMAL	15	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	True	True	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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.6f
AmountInHomeCurrency	3	DECIMAL	15	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	True	True	False	1 0 true false
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
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
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	15	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	True	True	False	%s	Yes
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	3	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	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	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

(UK 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

(UK 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

(UK 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

(UK 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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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	15	True	True	True	False	%6.6f
AmountInHomeCurrency	3	DECIMAL	15	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	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
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: CreditCardChargeExpenseLine

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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	15	True	True	True	False	%6.6f
AmountInHomeCurrency	3	DECIMAL	15	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	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
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	15	True	True	True	False	%10.2f
ExpenseLineTaxAmount	3	DECIMAL	15	True	False	False	False	%10.2f
ExpenseLineTax1Amount	3	DECIMAL	15	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	True	True	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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	15	True	True	True	False	%6.6f
AmountInHomeCurrency	3	DECIMAL	15	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	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
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
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	15	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	True	True	False	%s	Yes
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	3	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	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.6f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: CreditCardCreditExpenseLine

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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	15	True	True	True	False	%10.2f
ExpenseLineTaxAmount	3	DECIMAL	15	True	False	False	False	%10.2f
ExpenseLineTax1Amount	3	DECIMAL	15	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	True	True	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.6f
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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
Amount	3	DECIMAL	15	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
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	15	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
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	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.6f
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

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
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	15	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	15	True	False	False	False	%10.2f
TotalAmount	3	DECIMAL	15	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
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	True	True	False	1 0 true false
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
CustomerTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
CustomFieldOther	12	VARCHAR	29	True	True	True	False	%s
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.6f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: CreditMemoLine

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
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	15	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	15	True	False	False	False	%10.2f
TotalAmount	3	DECIMAL	15	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
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	True	True	False	1 0 true false
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
CustomerTaxCodeRefFullName	12	VARCHAR	3	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
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	15	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	15	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	15	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	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.6f
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: CreditMemoLinkedTxn

(UK 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 ThisFiscalYeRX<°ÖeüTà™ ‘T
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	15	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	15	True	False	False	False	%10.2f
TotalAmount	3	DECIMAL	15	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
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
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
CustomerTaxCodeRefFullName	12	VARCHAR	3	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 LiabilityAdjusÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸÐþø
LinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
LinkedTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
LinkedTxnAmount	3	DECIMAL	15	True	False	False	False	%10.2f
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
ExchangeRate	3	DECIMAL	15	True	False	False	False	%6.6f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Currency

(UK 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	15	True	False	False	False	%6.6f
AsOfDate	9	DATE	6	True	False	False	False	CCCC-MM-DD

TABLE DETAIL REFERENCE: Customer

(UK 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
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	15	True	False	False	False	%10.2f
TotalBalance	3	DECIMAL	15	True	False	False	False	%10.2f
OpenBalance	3	DECIMAL	15	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	15	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	True	True	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

TABLE DETAIL REFERENCE: CustomerAddtionalNote

(UK 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
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	15	True	False	False	False	%10.2f
TotalBalance	3	DECIMAL	15	True	False	False	False	%10.2f
OpenBalance	3	DECIMAL	15	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	15	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
AdditionalNotesRetNoteID	4	INTEGER	4	True	True	False	False	%11.0f
AdditionalNotesRetDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AdditionalNotesRetNote	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	True	True	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
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CustomerContacts

(UK 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
ContactsRetListID	12	VARCHAR	36	True	True	False	False	%s
ContactsRetTimeCreated	11	TIMESTAMP	16	True	False	False	False	%s
ContactsRetTimeModified	11	TIMESTAMP	16	True	False	False	False	%s
ContactsRetEditSequence	12	VARCHAR	16	True	True	False	False	%s
ContactsRetSalutation	12	VARCHAR	15	True	True	True	False	%s
ContactsRetFirstName	12	VARCHAR	25	True	True	True	True	%s
ContactsRetMiddleName	12	VARCHAR	5	True	True	True	False	%s
ContactsRetLastName	12	VARCHAR	25	True	True	True	False	%s
ContactsRetJobTitle	12	VARCHAR	41	True	True	True	False	%s
ContactsRetAdditionalContactRef1ContactName	12	VARCHAR	40	True	True	True	False	%s
ContactsRetAdditionalContactRef1ContactValue	12	VARCHAR	255	True	True	True	False	%s
ContactsRetAdditionalContactRef2ContactName	12	VARCHAR	40	True	True	True	False	%s
ContactsRetAdditionalContactRef2ContactValue	12	VARCHAR	255	True	True	True	False	%s
ContactsRetAdditionalContactRef3ContactName	12	VARCHAR	40	True	True	True	False	%s
ContactsRetAdditionalContactRef3ContactValue	12	VARCHAR	255	True	True	True	False	%s
ContactsRetAdditionalContactRef4ContactName	12	VARCHAR	40	True	True	True	False	%s
ContactsRetAdditionalContactRef4ContactValue	12	VARCHAR	255	True	True	True	False	%s
ContactsRetAdditionalContactRef5ContactName	12	VARCHAR	40	True	True	True	False	%s
ContactsRetAdditionalContactRef5ContactValue	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	15	True	False	False	False	%10.2f
TotalBalance	3	DECIMAL	15	True	False	False	False	%10.2f
OpenBalance	3	DECIMAL	15	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	15	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	True	True	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
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CustomerMsg

(UK 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	101	True	False	True	True	%s
IsActive	-7	BIT	1	True	False	True	False	1 0 true false

TABLE DETAIL REFERENCE: CustomerShipToAddress

(UK 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	False	False	True	%s
FullName	12	VARCHAR	209	True	False	False	False	%s
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
ClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ClassRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ParentRefListID	12	VARCHAR	36	True	False	False	False	%s
ParentRefFullName	12	VARCHAR	209	True	False	False	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
CompanyName	12	VARCHAR	41	True	False	False	False	%s
Salutation	12	VARCHAR	15	True	False	False	False	%s
FirstName	12	VARCHAR	25	True	False	False	False	%s
MiddleName	12	VARCHAR	5	True	False	False	False	%s
LastName	12	VARCHAR	25	True	False	False	False	%s
JobTitle	12	VARCHAR	41	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
ShipToAddressName	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressCity	12	VARCHAR	31	True	False	False	False	%s
ShipToAddressState	12	VARCHAR	21	True	False	False	False	%s
ShipToAddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
ShipToAddressCountry	12	VARCHAR	31	True	False	False	False	%s
ShipToAddressNote	12	VARCHAR	41	True	False	False	False	%s
ShipToAddressDefaultShipTo	-7	BIT	1	True	False	False	False	1 0 true false
Phone	12	VARCHAR	21	True	False	False	False	%s
AltPhone	12	VARCHAR	21	True	False	False	False	%s
Fax	12	VARCHAR	21	True	False	False	False	%s
Email	12	VARCHAR	1023	True	False	False	False	%s
Cc	12	VARCHAR	1023	True	False	False	False	%s
Contact	12	VARCHAR	41	True	False	False	False	%s
AltContact	12	VARCHAR	41	True	False	False	False	%s
CustomerTypeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CustomerTypeRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
SalesRepRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesRepRefFullName	12	VARCHAR	5	True	False	False	False	%s	Yes
Balance	3	DECIMAL	15	True	False	False	False	%10.2f
TotalBalance	3	DECIMAL	15	True	False	False	False	%10.2f
OpenBalance	3	DECIMAL	15	True	False	False	False	%10.2f
OpenBalanceDate	9	DATE	6	True	False	False	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
ItemSalesTaxRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemSalesTaxRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
SalesTaxCountry	12	VARCHAR	31	True	False	False	False	Australia Canada UK
ResaleNumber	12	VARCHAR	15	True	False	False	False	%s
AccountNumber	12	VARCHAR	99	True	False	False	False	%s
BusinessNumber	12	VARCHAR	99	True	False	False	False	%s
CreditLimit	3	DECIMAL	15	True	False	False	False	%10.2f
PreferredPaymentMethodRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
PreferredPaymentMethodRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
CreditCardInfoCreditCardNumber	12	VARCHAR	25	True	False	False	False	%s
CreditCardInfoExpirationMonth	4	INTEGER	4	True	False	False	False	%11.0f
CreditCardInfoExpirationYear	4	INTEGER	4	True	False	False	False	%11.0f
CreditCardInfoNameOnCard	12	VARCHAR	41	True	False	False	False	%s
CreditCardInfoCreditCardAddress	12	VARCHAR	41	True	False	False	False	%s
CreditCardInfoCreditCardPostalCode	12	VARCHAR	41	True	False	False	False	%s
JobStatus	12	VARCHAR	10	True	False	False	False	None Pending Awarded InProgress Closed NotAwarded
JobStartDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
JobProjectedEndDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
JobEndDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
JobDesc	12	VARCHAR	99	True	False	False	False	%s
JobTypeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
JobTypeRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
Notes	12	VARCHAR	4095	True	False	False	False	%s
PreferredDeliveryMethod	12	VARCHAR	10	True	False	False	True	None Email Fax
IsUsingCustomerTaxCode	-7	BIT	1	True	False	False	False	1 0 true false
PriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
PriceLevelRefFullName	12	VARCHAR	31	True	False	False	False	%s	Yes
ExternalGUID	12	VARCHAR	40	True	False	False	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TaxRegistrationNumber	12	VARCHAR	30	True	False	False	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	False	%s	Yes
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CustomerType

(UK 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
FullName	12	VARCHAR	159	True	False	False	False	%s
IsActive	-7	BIT	1	True	False	True	False	1 0 true false
ParentRefListID	12	VARCHAR	36	True	False	True	False	%s
ParentRefFullName	12	VARCHAR	159	True	False	True	False	%s

QODBC.com Tools for QuickBooks