Details:ALL

TABLE DETAIL REFERENCE: Account

(Online 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	10	True	False	False	False	%s
Name	12	VARCHAR	100	True	True	True	True	%s
FullName	12	VARCHAR	1000	True	True	True	False	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false
ParentRefListID	12	VARCHAR	36	True	True	True	False	%s
ParentRefFullName	12	VARCHAR	1000	True	True	True	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
AccountType	12	VARCHAR	21	True	True	True	True	AccountsPayable AccountsReceivable Bank CostOfGoodsSold CreditCard Equity Expense FixedAsset Income LongTermLiability Nonposting OtherAsset OtherCurrentAsset OtherCurrentLiability OtherExpense OtherIncome
DetailAccountType	12	VARCHAR	255	True	True	True	False	AP AR AccumulatedAdjustment AccumulatedAmortization AccumulatedAmortizationOfOtherAssets AccumulatedDepletion AccumulatedDepreciation AdvertisingOrPromotional AllowanceForBadDebts Amortization Auto BadDebts BankCharges Buildings CashOnHand CharitableContributions Checking CommonStock CostOfLabor CostOfLaborCOS CreditCard DepletableAssets Depreciation DevelopmentCosts DiscountsOrRefundsGiven DividendIncome DuesAndSubscriptions EmployeeCashAdvances Entertainment EntertainmentMeals EquipmentRental EquipmentRentalCOS FederalIncomeTaxPayable FurnitureAndFixtures Goodwill Insurance InsurancePayable IntangibleAssets InterestEarned InterestPaid Inventory InvestmentMortgageOrRealEstateLoans InvestmentOther InvestmentTaxExemptSecurities InvestmentUSGovObligations Land LeaseBuyout LeaseholdImprovements LegalAndProfessionalFees Licenses LineOfCredit LoanPayable LoansToOfficers LoansToOthers LoansToStockholders MachineryAndEquipment MoneyMarket NonProfitIncome NotesPayable OfficeOrGeneralAdministrativeExpenses OpeningBalanceEquity OrganizationalCosts OtherCostsOfServiceCOS OtherCurrentAssets OtherCurrentLiab OtherFixedAssets OtherInvestmentIncome OtherLongTermAssets OtherLongTermLiab OtherMiscExpense OtherMiscIncome OtherMiscServiceCost OtherPrimaryIncome OwnersEquity PaidInCapitalOrSurplus PartnerContributions PartnerDistributions PartnersEquity PayrollClearing PayrollExpenses PayrollTaxPayable PenaltiesAndSettlements PreferredStock PrepaidExpenses PrepaidExpensesPayable PromotionalMeals RentOrLeaseOfBuildings RentsHeldInTrust RentsInTrustLiab RepairAndMaintenance Retainage RetainedEarnings SalesOfProductIncome SalesTaxPayable Savings SecurityDeposits ServiceOrFeeIncome ShareholderNotesPayable ShippingFreightAndDelivery ShippingFreightAndDeliveryCOS StateOrLocalIncomeTaxPayable SuppliesAndMaterials SuppliesAndMaterialsCOGS TaxExemptInterest TaxesPaid Travel TravelMeals TreasuryStock TrustAccounts TrustAccountsLiab UndepositedFunds Utilities Vehicles
AccountNumber	12	VARCHAR	64	True	True	True	False	%s
LastCheckNumber	12	VARCHAR	21	True	True	True	False	%s
Desc	12	VARCHAR	100	True	True	True	False	%s
Description	12	VARCHAR	4095	True	True	True	False	%s
Balance	3	DECIMAL	15	True	False	True	False	%11.2f
TotalBalance	3	DECIMAL	15	True	True	True	False	%11.2f
OpenBalance	3	DECIMAL	13	True	False	True	False	%11.2f
OpenBalanceDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
AccountAlias	12	VARCHAR	1000	True	True	True	True	%s
TxnLocationType	12	VARCHAR	255	True	True	True	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU

TABLE DETAIL REFERENCE: Attachable

(Online 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	10	True	False	False	False	%s
FileName	12	VARCHAR	1000	True	True	True	False	%s
FileAccessUri	12	VARCHAR	1000	True	False	True	False	%s
TempDownloadUri	12	VARCHAR	1000	True	False	True	False	%s
Size	12	VARCHAR	1000	True	False	True	False	%s
ContentType	12	VARCHAR	100	True	False	True	False	%s
Category	12	VARCHAR	100	True	False	True	False	%s
Lat	12	VARCHAR	100	True	True	True	False	%s
Long	12	VARCHAR	100	True	True	True	False	%s
PlaceName	12	VARCHAR	2000	True	True	True	False	%s
Note	12	VARCHAR	2000	True	True	True	False	%s
Tag	12	VARCHAR	2000	True	True	True	False	%s
ThumbnailFileAccessUri	12	VARCHAR	1000	True	False	True	False	%s
ThumbnailTempDownloadUri	12	VARCHAR	1000	True	False	True	False	%s

TABLE DETAIL REFERENCE: AttachableReference

(Online 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	10	True	False	False	False	%s
FileName	12	VARCHAR	1000	True	True	True	False	%s
FileAccessUri	12	VARCHAR	1000	True	False	True	False	%s
TempDownloadUri	12	VARCHAR	1000	True	False	True	False	%s
Size	12	VARCHAR	1000	True	False	True	False	%s
ContentType	12	VARCHAR	100	True	False	True	False	%s
Category	12	VARCHAR	100	True	False	True	False	%s
Lat	12	VARCHAR	100	True	True	True	False	%s
Long	12	VARCHAR	100	True	True	True	False	%s
PlaceName	12	VARCHAR	2000	True	True	True	False	%s
Note	12	VARCHAR	2000	True	True	True	False	%s
Tag	12	VARCHAR	2000	True	True	True	False	%s
ThumbnailFileAccessUri	12	VARCHAR	1000	True	False	True	False	%s
ThumbnailTempDownloadUri	12	VARCHAR	1000	True	False	True	False	%s
AttachableReferenceEntityRefListID	12	VARCHAR	36	True	True	True	False	%s
AttachableReferenceEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s
AttachableReferenceLineInfo	12	VARCHAR	4000	True	True	True	False	%s
AttachableReferenceIncludeOnSend	-7	BIT	1	True	True	True	False	1 0 true false
AttachableReferenceIsactive	-7	BIT	1	True	True	True	False	1 0 true false
AttachableReferenceNoRefOnly	-7	BIT	1	True	True	True	False	1 0 true false
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Bill

(Online 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	10	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	True	True	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	13	True	True	True	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
OpenAmount	3	DECIMAL	15	True	False	False	False	%11.2f
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f

TABLE DETAIL REFERENCE: BillExpenseLine

(Online 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	10	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	True	True	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	13	True	True	True	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ExpenseLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
ExpenseLineTxnLineID	12	VARCHAR	36	True	True	True	False	%s
ExpenseLineMemo	12	VARCHAR	4000	True	True	True	False	%s
ExpenseLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineTaxAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ExpenseLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineCustomerRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
ExpenseLineMarkupInfoPercent	3	DECIMAL	13	True	False	False	False	%7.5f
ExpenseLineMarkupInfoPercentBased	-7	BIT	1	True	False	False	False	1 0 true false
ExpenseLineMarkupInfoPriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoPriceLevelRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoValue	3	DECIMAL	13	True	False	False	False	%8.2f
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
OpenAmount	3	DECIMAL	15	True	False	False	False	%11.2f
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillItemLine

(Online 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	10	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	True	True	False	%11.0f
VendorRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AmountDue	3	DECIMAL	13	True	True	True	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineNumber	12	VARCHAR	16	True	False	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineMemo	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	16	True	True	True	False	%10.7f
ItemLineRate	3	DECIMAL	18	True	True	True	False	%10.7f
ItemLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineClassRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ItemLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ItemLineDetailType	12	VARCHAR	32	True	False	False	False	ItemBasedExpenseLineDetail
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
ItemLineMarkupInfoPercent	3	DECIMAL	13	True	False	False	False	%10.7f
ItemLineMarkupInfoPercentBased	-7	BIT	1	True	False	False	False	1 0 true false
ItemLineMarkupInfoPriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ItemLineMarkupInfoPriceLevelRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ItemLineMarkupInfoValue	3	DECIMAL	13	True	False	False	False	%10.7f
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineTaxCodeRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
OpenAmount	3	DECIMAL	15	True	False	False	False	%11.2f
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
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

(Online 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	10	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	1000	True	False	False	True	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	False	False	%11.7f
DepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
DueDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AmountDue	3	DECIMAL	13	True	False	False	False	%11.2f
RefNumber	12	VARCHAR	21	True	False	False	False	%s
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
Memo	12	VARCHAR	4000	True	False	False	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	False	False	False	TaxExcluded TaxIncluded NotApplicable
LinkedTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
LinkedTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
LinkedTxnTxnType	12	VARCHAR	21	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
LinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
LinkedTxnRefNumber	12	VARCHAR	21	True	False	False	False	%s
LinkedTxnAmount	3	DECIMAL	15	True	False	False	False	%11.2f
ExpenseLineBillableStatus	12	VARCHAR	23	True	False	False	False	Billable NotBillable HasBeenBilled
OpenAmount	3	DECIMAL	15	True	False	False	False	%11.2f
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillPayment

(Online 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	10	True	False	False	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DocNumber	12	VARCHAR	1000	True	False	False	False	%s
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
VendorRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
PayType	12	VARCHAR	13	True	False	True	False	Check CreditCard
CheckPaymentBankAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CheckPaymentBankAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CheckPaymentPrintStatus	12	VARCHAR	13	True	True	True	False	NeedToPrint NotSet PrintComplete
CheckPaymentCheckDetailCheckNum	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailStatus	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailNameOnAcct	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailAcctNum	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailBankName	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditCardPaymentCCAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditCardPaymentCCDetailNumber	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailNameOnAcct	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCcExpiryMonth	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailBillAddrStreet	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPostalCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCommercialCardCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnMode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPrevCCTransId	12	VARCHAR	1000	True	True	True	False	%s
TotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill

TABLE DETAIL REFERENCE: BillPaymentAppliedToTxn

(Online 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	10	True	False	False	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DocNumber	12	VARCHAR	1000	True	False	False	False	%s
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
VendorRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
PayType	12	VARCHAR	13	True	False	True	False	Check CreditCard
CheckPaymentBankAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CheckPaymentBankAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CheckPaymentPrintStatus	12	VARCHAR	13	True	True	True	False	NeedToPrint NotSet PrintComplete
CheckPaymentCheckDetailCheckNum	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailStatus	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailNameOnAcct	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailAcctNum	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailBankName	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditCardPaymentCCAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditCardPaymentCCDetailNumber	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailNameOnAcct	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCcExpiryMonth	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailBillAddrStreet	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPostalCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCommercialCardCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnMode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPrevCCTransId	12	VARCHAR	1000	True	True	True	False	%s
TotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
BillPaymentAppliedToTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
BillPaymentAppliedToTxnTxnType	12	VARCHAR	1000	True	False	False	False	%s
BillPaymentAppliedToTxnTxnLineID	12	VARCHAR	36	True	False	False	False	%s
BillPaymentAppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
BillPaymentAppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillPaymentLine

(Online 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	10	True	False	False	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DocNumber	12	VARCHAR	1000	True	False	False	False	%s
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
VendorRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
PayType	12	VARCHAR	13	True	False	True	False	Check CreditCard
CheckPaymentBankAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CheckPaymentBankAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CheckPaymentPrintStatus	12	VARCHAR	13	True	True	True	False	NeedToPrint NotSet PrintComplete
CheckPaymentCheckDetailCheckNum	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailStatus	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailNameOnAcct	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailAcctNum	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailBankName	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditCardPaymentCCAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditCardPaymentCCDetailNumber	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailNameOnAcct	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCcExpiryMonth	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailBillAddrStreet	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPostalCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCommercialCardCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnMode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPrevCCTransId	12	VARCHAR	1000	True	True	True	False	%s
TotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
BillPaymentLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
BillPaymentLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
BillPaymentAppliedToTxnTxnID	12	VARCHAR	36	True	False	True	False	%s
BillPaymentAppliedToTxnTxnType	12	VARCHAR	1000	True	False	True	False	%s
BillPaymentAppliedToTxnTxnLineID	12	VARCHAR	36	True	False	True	False	%s
BillPaymentAppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
BillPaymentAppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	True	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: BillPaymentTaxLineDetail

(Online 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	10	True	False	False	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DocNumber	12	VARCHAR	1000	True	False	False	False	%s
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
VendorRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
VendorRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
APAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
APAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
PayType	12	VARCHAR	13	True	False	True	False	Check CreditCard
CheckPaymentBankAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CheckPaymentBankAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CheckPaymentPrintStatus	12	VARCHAR	13	True	True	True	False	NeedToPrint NotSet PrintComplete
CheckPaymentCheckDetailCheckNum	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailStatus	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailNameOnAcct	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailAcctNum	12	VARCHAR	1000	True	True	True	False	%s
CheckPaymentCheckDetailBankName	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditCardPaymentCCAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditCardPaymentCCDetailNumber	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailNameOnAcct	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCcExpiryMonth	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear	4	INTEGER	4	True	True	True	False	%11.0f
CreditCardPaymentCCDetailBillAddrStreet	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPostalCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCommercialCardCode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnMode	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailCCTxnType	12	VARCHAR	1000	True	True	True	False	%s
CreditCardPaymentCCDetailPrevCCTransId	12	VARCHAR	1000	True	True	True	False	%s
TotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
TaxDetailLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
TaxDetailLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
TaxDetailLineDetailType	12	VARCHAR	15	True	True	True	False	TaxLineDetail
TaxDetailLineTaxRateRefListID	12	VARCHAR	36	True	True	True	False	%s
TaxDetailLineTaxRateRefFullName	12	VARCHAR	1000	True	True	True	False	%s
TaxDetailLinePercentBased	-7	BIT	1	True	True	True	False	1 0 true false
TaxDetailLineTaxPercent	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineNetAmountTaxable	3	DECIMAL	13	True	True	True	False	%11.2f
TaxDetailLineOverrideDeltaAmount	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Budget

(Online 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	10	True	False	False	False	%s
Name	12	VARCHAR	1000	True	False	False	False	%s
StartDate	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EndDate	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
BudgetType	12	VARCHAR	13	True	False	False	False	ProfitAndLoss BalanceSheet
BudgetEntryType	12	VARCHAR	13	True	False	False	False	Monthly Quarterly Annually
IsActive	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: BudgetDetailLine

(Online 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	10	True	False	False	False	%s
Name	12	VARCHAR	1000	True	False	False	False	%s
StartDate	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EndDate	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
BudgetType	12	VARCHAR	13	True	False	False	False	ProfitAndLoss BalanceSheet
BudgetEntryType	12	VARCHAR	13	True	False	False	False	Monthly Quarterly Annually
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
BudgetDetailListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailBudgetDate	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
BudgetDetailAmount	3	DECIMAL	15	True	False	False	False	%11.2f
BudgetDetailAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailAccountRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
BudgetDetailCustomerRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailCustomerRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
BudgetDetailClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailClassRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
BudgetDetailDepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
BudgetDetailDepartmentRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Check

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
RefNumber	12	VARCHAR	21	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Amount	3	DECIMAL	15	True	True	True	False	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
AddressAddr1	12	VARCHAR	500	True	True	True	False	%s
AddressAddr2	12	VARCHAR	500	True	True	True	False	%s
AddressAddr3	12	VARCHAR	500	True	True	True	False	%s
AddressAddr4	12	VARCHAR	500	True	True	True	False	%s
AddressAddr5	12	VARCHAR	500	True	True	True	False	%s
AddressCity	12	VARCHAR	255	True	True	True	False	%s
AddressState	12	VARCHAR	255	True	True	True	False	%s
AddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
AddressCountry	12	VARCHAR	255	True	True	True	False	%s
AddressNote	12	VARCHAR	500	True	True	True	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled

TABLE DETAIL REFERENCE: CheckExpenseLine

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
RefNumber	12	VARCHAR	21	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Amount	3	DECIMAL	15	True	True	True	False	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
AddressAddr1	12	VARCHAR	500	True	True	True	False	%s
AddressAddr2	12	VARCHAR	500	True	True	True	False	%s
AddressAddr3	12	VARCHAR	500	True	True	True	False	%s
AddressAddr4	12	VARCHAR	500	True	True	True	False	%s
AddressAddr5	12	VARCHAR	500	True	True	True	False	%s
AddressCity	12	VARCHAR	255	True	True	True	False	%s
AddressState	12	VARCHAR	255	True	True	True	False	%s
AddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
AddressCountry	12	VARCHAR	255	True	True	True	False	%s
AddressNote	12	VARCHAR	500	True	True	True	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
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
ExpenseLineMemo	12	VARCHAR	4000	True	True	True	False	%s
ExpenseLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineTaxAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ExpenseLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineCustomerRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
ExpenseLineMarkupInfoPercent	3	DECIMAL	13	True	False	False	False	%7.5f
ExpenseLineMarkupInfoPercentBased	-7	BIT	1	True	False	False	False	1 0 true false
ExpenseLineMarkupInfoPriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoPriceLevelRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoValue	3	DECIMAL	13	True	False	False	False	%8.2f
ExpenseLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CheckItemLine

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
RefNumber	12	VARCHAR	21	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Amount	3	DECIMAL	15	True	True	True	False	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
AddressAddr1	12	VARCHAR	500	True	True	True	False	%s
AddressAddr2	12	VARCHAR	500	True	True	True	False	%s
AddressAddr3	12	VARCHAR	500	True	True	True	False	%s
AddressAddr4	12	VARCHAR	500	True	True	True	False	%s
AddressAddr5	12	VARCHAR	500	True	True	True	False	%s
AddressCity	12	VARCHAR	255	True	True	True	False	%s
AddressState	12	VARCHAR	255	True	True	True	False	%s
AddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
AddressCountry	12	VARCHAR	255	True	True	True	False	%s
AddressNote	12	VARCHAR	500	True	True	True	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ItemLineTxnLineID	12	VARCHAR	36	True	True	True	False	%s
ItemLineNumber	12	VARCHAR	16	True	True	True	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
ItemLineMemo	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	16	True	True	True	False	%10.7f
ItemLineRate	3	DECIMAL	18	True	True	True	False	%10.7f
ItemLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ItemLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ItemLineDetailType	12	VARCHAR	32	True	True	True	False	ItemBasedExpenseLineDetail
ItemLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
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

(Online 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	10	True	False	False	False	%s
Name	12	VARCHAR	100	True	True	True	True	%s
FullName	12	VARCHAR	1000	True	False	False	False	%s
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
ParentRefListID	12	VARCHAR	36	True	True	True	False	%s
ParentRefFullName	12	VARCHAR	1000	True	True	True	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f

TABLE DETAIL REFERENCE: Company

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
Id	4	INTEGER	4	True	False	False	False	FQID
IsSampleCompany	-7	BIT	1	True	False	False	False	1 0 true false
CompanyName	12	VARCHAR	100	True	False	False	False	%s
LegalCompanyName	12	VARCHAR	100	True	False	False	False	%s
AddressAddr1	12	VARCHAR	500	True	False	False	False	%s
AddressAddr2	12	VARCHAR	500	True	False	False	False	%s
AddressAddr3	12	VARCHAR	500	True	False	False	False	%s
AddressAddr4	12	VARCHAR	500	True	False	False	False	%s
AddressCity	12	VARCHAR	255	True	False	False	False	%s
AddressState	12	VARCHAR	255	True	False	False	False	%s
AddressPostalCode	12	VARCHAR	30	True	False	False	False	%s
AddressCountry	12	VARCHAR	255	True	False	False	False	%s
LegalAddressAddr1	12	VARCHAR	500	True	False	False	False	%s
LegalAddressAddr2	12	VARCHAR	500	True	False	False	False	%s
LegalAddressAddr3	12	VARCHAR	500	True	False	False	False	%s
LegalAddressAddr4	12	VARCHAR	500	True	False	False	False	%s
LegalAddressCity	12	VARCHAR	255	True	False	False	False	%s
LegalAddressState	12	VARCHAR	255	True	False	False	False	%s
LegalAddressPostalCode	12	VARCHAR	30	True	False	False	False	%s
LegalAddressCountry	12	VARCHAR	255	True	False	False	False	%s
CompanyAddressForCustomerAddr1	12	VARCHAR	500	True	False	False	False	%s
CompanyAddressForCustomerAddr2	12	VARCHAR	500	True	False	False	False	%s
CompanyAddressForCustomerAddr3	12	VARCHAR	500	True	False	False	False	%s
CompanyAddressForCustomerAddr4	12	VARCHAR	500	True	False	False	False	%s
CompanyAddressForCustomerCity	12	VARCHAR	255	True	False	False	False	%s
CompanyAddressForCustomerState	12	VARCHAR	255	True	False	False	False	%s
CompanyAddressForCustomerPostalCode	12	VARCHAR	30	True	False	False	False	%s
CompanyAddressForCustomerCountry	12	VARCHAR	255	True	False	False	False	%s
Phone	12	VARCHAR	20	True	False	False	False	%s
Email	12	VARCHAR	100	True	False	False	False	%s
CompanyEmailForCustomer	12	VARCHAR	100	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
AccountantCopyExists	-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: CompanyCurrency

(Online 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	10	True	False	False	False	%s
Code	12	VARCHAR	100	True	True	True	False	%s
Name	12	VARCHAR	1000	True	True	True	False	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false

TABLE DETAIL REFERENCE: CompanyCurrencyAttachable

(Online 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	10	True	False	False	False	%s
AttachableRefListID	12	VARCHAR	36	True	False	False	False	%s
AttachableRefEntityRefListID	12	VARCHAR	36	True	False	False	False	%s
AttachableRefEntityRefFullName	12	VARCHAR	1000	True	False	False	False	%s
AttachableRefLineInfo	12	VARCHAR	4000	True	False	False	False	%s
AttachableRefIncludeOnSend	-7	BIT	1	True	False	False	False	1 0 true false
AttachableRefInactive	-7	BIT	1	True	False	False	False	1 0 true false
AttachableRefNoRefOnly	-7	BIT	1	True	False	False	False	1 0 true false
Code	12	VARCHAR	100	True	False	False	False	%s
Name	12	VARCHAR	1000	True	False	False	False	%s
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CreditCardCharge

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Amount	3	DECIMAL	15	True	True	True	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled

TABLE DETAIL REFERENCE: CreditCardChargeExpenseLine

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Amount	3	DECIMAL	15	True	True	True	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ExpenseLineClearExpenseLines	-7	BIT	1	False	True	True	False	1 0 true false
ExpenseLineSeqNo	4	INTEGER	4	True	True	True	False	SeqNo
ExpenseLineTxnLineID	12	VARCHAR	36	True	True	True	False	%s
ExpenseLineMemo	12	VARCHAR	4000	True	True	True	False	%s
ExpenseLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineTaxAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ExpenseLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineCustomerRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
ExpenseLineMarkupInfoPercent	3	DECIMAL	13	True	False	False	False	%7.5f
ExpenseLineMarkupInfoPercentBased	-7	BIT	1	True	False	False	False	1 0 true false
ExpenseLineMarkupInfoPriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoPriceLevelRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoValue	3	DECIMAL	13	True	False	False	False	%8.2f
ExpenseLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CreditCardChargeItemLine

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Amount	3	DECIMAL	15	True	True	True	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineNumber	12	VARCHAR	16	True	True	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineMemo	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	16	True	True	True	False	%10.7f
ItemLineRate	3	DECIMAL	18	True	True	True	False	%10.7f
ItemLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ItemLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ItemLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ItemLineDetailType	12	VARCHAR	32	True	True	True	False	ItemBasedExpenseLineDetail
ItemLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
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

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Amount	3	DECIMAL	15	True	False	False	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled

TABLE DETAIL REFERENCE: CreditCardCreditExpenseLine

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Amount	3	DECIMAL	15	True	False	False	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
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
ExpenseLineMemo	12	VARCHAR	4000	True	True	True	False	%s
ExpenseLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineTaxAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ExpenseLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ExpenseLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineCustomerRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
ExpenseLineMarkupInfoPercent	3	DECIMAL	13	True	False	False	False	%7.5f
ExpenseLineMarkupInfoPercentBased	-7	BIT	1	True	False	False	False	1 0 true false
ExpenseLineMarkupInfoPriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoPriceLevelRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
ExpenseLineMarkupInfoValue	3	DECIMAL	13	True	False	False	False	%8.2f
ExpenseLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	False	True	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CreditCardCreditItemLine

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Amount	3	DECIMAL	15	True	False	False	False	%11.2f
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
ItemLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ItemLineNumber	12	VARCHAR	16	True	True	False	False	%s
ItemLineItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineItemRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineMemo	12	VARCHAR	4095	True	True	True	False	%s
ItemLineQuantity	3	DECIMAL	16	True	True	True	False	%10.7f
ItemLineRate	3	DECIMAL	18	True	True	True	False	%10.7f
ItemLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ItemLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
ItemLineDetailType	12	VARCHAR	32	True	True	True	False	ItemBasedExpenseLineDetail
ItemLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ItemLineCustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineCustomerRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
ItemLineBillableStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
ItemLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
ExpenseLineBillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	False	True	False	FQPrimaryKey
FQTxnLinkKey	12	VARCHAR	110	True	False	True	False	FQPrimaryKey

TABLE DETAIL REFERENCE: CreditCardPayment

(Online 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	10	True	False	False	False	%s
CreditCardAccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
CreditCardAccountRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
BankAccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
BankAccountRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
VendorRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
VendorRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	True	CCCC-MM-DD
Amount	3	DECIMAL	15	True	True	True	True	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
PrintStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToPrint PrintComplete
CheckNum	12	VARCHAR	1000	True	True	True	False	%s

TABLE DETAIL REFERENCE: CreditMemo

(Online 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	10	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	1000	True	True	True	True	%s	Yes
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
RefNumber	12	VARCHAR	21	True	True	True	False	%s
BillAddressID	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	255	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	255	True	True	True	False	%s
BillAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipAddressID	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	255	True	True	True	False	%s
ShipAddressState	12	VARCHAR	255	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	255	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Subtotal	3	DECIMAL	13	True	False	False	False	%11.2f
SalesTaxPercentage	3	DECIMAL	15	True	False	False	False	%10.7f
SalesTaxTotal	3	DECIMAL	13	True	False	False	False	%11.2f
TotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
CreditRemaining	3	DECIMAL	13	True	False	False	False	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
CustomerMemo	12	VARCHAR	1000	True	True	True	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
CustomFieldOther	12	VARCHAR	29	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
DiscountLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
DiscountLineRatePercent	3	DECIMAL	15	True	True	True	False	%11.7f
DiscountLineAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
DiscountLineAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes
SalesTaxLineAmount	3	DECIMAL	15	True	False	True	False	%11.2f
SalesTaxLineRatePercent	3	DECIMAL	15	True	False	True	False	%10.7f
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ShippingLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ShippingLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShippingLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldPONumber	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: CreditMemoLine

(Online 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	10	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	1000	True	True	True	True	%s	Yes
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
RefNumber	12	VARCHAR	21	True	True	True	False	%s
BillAddressID	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	255	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	255	True	True	True	False	%s
BillAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipAddressID	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	255	True	True	True	False	%s
ShipAddressState	12	VARCHAR	255	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	255	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Subtotal	3	DECIMAL	13	True	False	False	False	%11.2f
SalesTaxPercentage	3	DECIMAL	15	True	False	False	False	%10.7f
SalesTaxTotal	3	DECIMAL	13	True	False	False	False	%11.2f
TotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
CreditRemaining	3	DECIMAL	13	True	False	False	False	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
CustomerMemo	12	VARCHAR	1000	True	True	True	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
CustomFieldOther	12	VARCHAR	29	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
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	100	True	True	True	False	%s	Yes
CreditMemoLineGroupDesc	12	VARCHAR	4000	True	True	True	False	%s
CreditMemoLineGroupQuantity	3	DECIMAL	16	True	True	True	False	%8.5f
CreditMemoLineGroupAmount	3	DECIMAL	15	True	True	True	False	%11.2f
CreditMemoLineGroupTotalAmount	3	DECIMAL	13	True	False	False	False	%8.2f
CreditMemoLineGroupServiceDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
CreditMemoLineGroupSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
CreditMemoLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
CreditMemoLineItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineItemRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditMemoLineDesc	12	VARCHAR	4000	True	True	True	False	%s
CreditMemoLineQuantity	3	DECIMAL	16	True	True	True	False	%10.7f
CreditMemoLineRate	3	DECIMAL	18	True	True	True	False	%10.7f
CreditMemoLineRatePercent	3	DECIMAL	15	True	True	True	False	%10.7f
CreditMemoLineUnitOfMeasure	12	VARCHAR	100	True	True	True	False	%s	Yes
CreditMemoLineOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
CreditMemoLineOverrideUOMSetRefFullName	12	VARCHAR	1000	True	True	False	False	%s	Yes
CreditMemoLinePriceLevelRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
CreditMemoLinePriceLevelRefFullName	12	VARCHAR	1000	True	True	False	False	%s	Yes
CreditMemoLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineClassRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CreditMemoLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
CreditMemoLineTaxCodeRefName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditMemoLineTaxCodeRefType	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditMemoLineTaxCodeRefValue	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditMemoLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditMemoLineItemAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineItemAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditMemoLineTaxAmount	3	DECIMAL	15	True	False	False	False	%11.2f
CreditMemoLineServiceDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
CreditMemoLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
CreditMemoLineOverrideItemAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
CreditMemoLineOverrideItemAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
DiscountLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
DiscountLineRatePercent	3	DECIMAL	15	True	True	True	False	%11.7f
DiscountLineAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
DiscountLineAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes
SalesTaxLineAmount	3	DECIMAL	15	True	False	True	False	%11.2f
SalesTaxLineRatePercent	3	DECIMAL	15	True	False	True	False	%10.7f
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ShippingLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ShippingLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShippingLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
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
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldPONumber	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: CreditMemoLinkedTxn

(Online 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	10	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	1000	True	False	False	True	%s	Yes
ClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ClassRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	False	False	%11.7f
ARAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
RefNumber	12	VARCHAR	21	True	False	False	False	%s
BillAddressID	12	VARCHAR	500	True	False	False	False	%s
BillAddressAddr1	12	VARCHAR	500	True	False	False	False	%s
BillAddressAddr2	12	VARCHAR	500	True	False	False	False	%s
BillAddressAddr3	12	VARCHAR	500	True	False	False	False	%s
BillAddressAddr4	12	VARCHAR	500	True	False	False	False	%s
BillAddressAddr5	12	VARCHAR	500	True	False	False	False	%s
BillAddressCity	12	VARCHAR	255	True	False	False	False	%s
BillAddressState	12	VARCHAR	255	True	False	False	False	%s
BillAddressPostalCode	12	VARCHAR	30	True	False	False	False	%s
BillAddressCountry	12	VARCHAR	255	True	False	False	False	%s
BillAddressNote	12	VARCHAR	500	True	False	False	False	%s
ShipAddressID	12	VARCHAR	500	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	500	True	False	False	False	%s
ShipAddressAddr2	12	VARCHAR	500	True	False	False	False	%s
ShipAddressAddr3	12	VARCHAR	500	True	False	False	False	%s
ShipAddressAddr4	12	VARCHAR	500	True	False	False	False	%s
ShipAddressAddr5	12	VARCHAR	500	True	False	False	False	%s
ShipAddressCity	12	VARCHAR	255	True	False	False	False	%s
ShipAddressState	12	VARCHAR	255	True	False	False	False	%s
ShipAddressPostalCode	12	VARCHAR	30	True	False	False	False	%s
ShipAddressCountry	12	VARCHAR	255	True	False	False	False	%s
ShipAddressNote	12	VARCHAR	500	True	False	False	False	%s
ShipDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
Subtotal	3	DECIMAL	13	True	False	False	False	%11.2f
SalesTaxPercentage	3	DECIMAL	15	True	False	False	False	%10.7f
SalesTaxTotal	3	DECIMAL	13	True	False	False	False	%11.2f
TotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
CreditRemaining	3	DECIMAL	13	True	False	False	False	%11.2f
Memo	12	VARCHAR	4000	True	False	False	False	%s
CustomerMemo	12	VARCHAR	1000	True	False	False	False	%s
IsToBePrinted	-7	BIT	1	True	False	False	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	False	False	False	%s
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
CustomFieldOther	12	VARCHAR	29	True	False	False	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	False	False	False	TaxExcluded TaxIncluded NotApplicable
LinkedTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
LinkedTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
LinkedTxnTxnType	12	VARCHAR	21	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
LinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
LinkedTxnRefNumber	12	VARCHAR	21	True	False	False	False	%s
LinkedTxnAmount	3	DECIMAL	15	True	False	False	False	%11.2f
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	False	False	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	False	False	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	False	False	False	Billable NotBillable HasBeenBill
DiscountLineAmount	3	DECIMAL	15	True	False	False	False	%11.2f
DiscountLineRatePercent	3	DECIMAL	15	True	False	False	False	%11.7f
DiscountLineAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DiscountLineAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
SalesTaxLineAmount	3	DECIMAL	15	True	False	False	False	%11.2f
SalesTaxLineRatePercent	3	DECIMAL	15	True	False	False	False	%10.7f
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
ShippingLineAmount	3	DECIMAL	15	True	False	False	False	%11.2f
ShippingLineAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ShippingLineAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldPONumber	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: CreditMemoTaxLineDetail

(Online 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	10	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	1000	True	True	True	True	%s	Yes
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
RefNumber	12	VARCHAR	21	True	True	True	False	%s
BillAddressID	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	255	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	255	True	True	True	False	%s
BillAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipAddressID	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	255	True	True	True	False	%s
ShipAddressState	12	VARCHAR	255	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	255	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Subtotal	3	DECIMAL	13	True	False	False	False	%11.2f
SalesTaxPercentage	3	DECIMAL	15	True	False	False	False	%10.7f
SalesTaxTotal	3	DECIMAL	13	True	False	False	False	%11.2f
TotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
CreditRemaining	3	DECIMAL	13	True	False	False	False	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
CustomerMemo	12	VARCHAR	1000	True	True	True	False	%s
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
CustomFieldOther	12	VARCHAR	29	True	True	True	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
TaxDetailLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
TaxDetailLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
TaxDetailLineDetailType	12	VARCHAR	15	True	True	True	False	TaxLineDetail
TaxDetailLineTaxRateRefListID	12	VARCHAR	36	True	True	True	False	%s
TaxDetailLineTaxRateRefFullName	12	VARCHAR	1000	True	True	True	False	%s
TaxDetailLinePercentBased	-7	BIT	1	True	True	True	False	1 0 true false
TaxDetailLineTaxPercent	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineNetAmountTaxable	3	DECIMAL	13	True	True	True	False	%11.2f
TaxDetailLineOverrideDeltaAmount	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
DiscountLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
DiscountLineRatePercent	3	DECIMAL	15	True	True	True	False	%11.7f
DiscountLineAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
DiscountLineAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes
SalesTaxLineAmount	3	DECIMAL	15	True	False	True	False	%11.2f
SalesTaxLineRatePercent	3	DECIMAL	15	True	False	True	False	%10.7f
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ShippingLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
ShippingLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShippingLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldPONumber	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: Customer

(Online 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	10	True	False	False	False	%s
Name	12	VARCHAR	100	True	True	True	True	%s
FullName	12	VARCHAR	1000	True	False	False	False	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false
ParentRefListID	12	VARCHAR	36	True	True	True	False	%s
ParentRefFullName	12	VARCHAR	1000	True	True	True	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
CompanyName	12	VARCHAR	50	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	25	True	True	True	False	%s
LastName	12	VARCHAR	25	True	True	True	False	%s
Suffix	12	VARCHAR	10	True	True	True	False	%s
BillAddressID	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	255	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	255	True	True	True	False	%s
BillAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipAddressID	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	255	True	True	True	False	%s
ShipAddressState	12	VARCHAR	255	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	255	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	500	True	True	True	False	%s
PrintAs	12	VARCHAR	110	True	True	True	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
Mobile	12	VARCHAR	21	True	True	True	False	%s
Pager	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	100	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
Balance	3	DECIMAL	15	True	False	False	False	%11.2f
TotalBalance	3	DECIMAL	15	True	False	False	False	%11.2f
OpenBalance	3	DECIMAL	13	True	False	True	False	%11.2f
OpenBalanceDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
ResaleNumber	12	VARCHAR	16	True	True	True	False	%s
Notes	12	VARCHAR	2000	True	True	True	False	%s
IsStatementWithParent	-7	BIT	1	True	True	True	False	1 0 true false
DeliveryMethod	12	VARCHAR	5	True	True	True	False	Print Fax Email
DefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
Taxable	-7	BIT	1	True	True	True	False	1 0 true false
WebAddressURI	12	VARCHAR	1000	True	True	True	False	%s
Job	-7	BIT	1	True	True	True	False	1 0 true false
PaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxExemptionReasonId	12	VARCHAR	5	True	False	False	False	%s
IsProject	-7	BIT	1	True	False	False	False	1 0 true false
BusinessNumber	12	VARCHAR	99	True	False	True	False	%s
GSTIN	12	VARCHAR	99	True	False	True	False	%s
GSTRegistrationType	12	VARCHAR	99	True	False	True	False	%s
IsCISContractor	-7	BIT	1	True	True	True	False	1 0 true false
ClientCompanyId	12	VARCHAR	36	True	True	True	False	%s
ClientEntityId	12	VARCHAR	36	True	True	True	False	%s
OverDueBalance	3	DECIMAL	15	True	False	False	False	%11.2f
Organization	-7	BIT	1	True	True	True	False	1 0 true false
OtherContactInfoType	12	VARCHAR	1000	True	True	True	False	%s
OtherContactInfoTelephone	12	VARCHAR	1000	True	True	True	False	%s
PriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s
PriceLevelRefFullName	12	VARCHAR	1000	True	False	False	False	%s
RootCustomerRefListID	12	VARCHAR	36	True	False	False	False	%s
RootCustomerRefFullName	12	VARCHAR	1000	True	False	False	False	%s
SalesRepRefListID	12	VARCHAR	36	True	False	False	False	%s
SalesRepRefFullName	12	VARCHAR	1000	True	False	False	False	%s
TotalExpense	3	DECIMAL	15	True	False	False	False	%11.2f
TotalRevenue	3	DECIMAL	15	True	False	False	False	%11.2f
UserId	12	VARCHAR	1000	True	True	True	False	%s
Status	12	VARCHAR	1000	True	True	True	False	%s
CCDetailAmount	4	INTEGER	4	True	False	False	False	%11.0f
CCDetailBillAddrStreet	12	VARCHAR	1000	True	False	False	False	%s
CCDetailExpiryMonth	4	INTEGER	4	True	False	False	False	%11.0f
CCDetailExpiryYear	4	INTEGER	4	True	False	False	False	%11.0f
CCDetailTxnMode	12	VARCHAR	1000	True	False	False	False	%s
CCDetailTxnType	12	VARCHAR	1000	True	False	False	False	%s
CCDetailCommercialCardCode	12	VARCHAR	1000	True	False	False	False	%s
ContactName	12	VARCHAR	1000	True	False	False	False	%s
AltContactName	12	VARCHAR	1000	True	False	False	False	%s
CreditLimit	3	DECIMAL	13	True	True	True	False	%8.2f
CustomerTypeRefListID	12	VARCHAR	36	True	False	False	False	%s
CustomerTypeRefFullName	12	VARCHAR	1000	True	False	False	False	%s
OtherAddrId	12	VARCHAR	36	True	True	True	False	%s
OtherAddr1	12	VARCHAR	100	True	True	True	False	%s
OtherAddr2	12	VARCHAR	100	True	True	True	False	%s
OtherAddr3	12	VARCHAR	100	True	True	True	False	%s
OtherAddr4	12	VARCHAR	100	True	True	True	False	%s
OtherAddr5	12	VARCHAR	100	True	True	True	False	%s
OtherAddrCity	12	VARCHAR	100	True	True	True	False	%s
OtherAddrState	12	VARCHAR	100	True	True	True	False	%s
OtherAddrProvince	12	VARCHAR	100	True	True	True	False	%s
OtherAddrCounty	12	VARCHAR	100	True	True	True	False	%s
OtherAddrPostalCode	12	VARCHAR	100	True	True	True	False	%s
OtherAddrLat	12	VARCHAR	100	True	True	True	False	%s
OtherAddrLong	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoEmailAddress	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoEmailAddressDefault	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoEmailAddressId	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoEmailAddressTag	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberAreaCode	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberCountryCode	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberDeviceType	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberDefault	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberExchangeCode	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberExtension	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberTelephone	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberId	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoTelephoneNumberTag	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoWebSiteAddressURI	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoWebSiteAddressDefault	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoWebSiteAddressId	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoWebSiteAddressTag	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeName	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeType	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeValue	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeDefault	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeId	12	VARCHAR	100	True	True	True	False	%s
OtherContactInfoGenericContactTypeTag	12	VARCHAR	100	True	True	True	False	%s
UpdateAccountOnTxns	-7	BIT	1	False	True	False	False	1 0 true false

TABLE DETAIL REFERENCE: CustomerType

(Online 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	10	True	False	False	False	%s
Name	12	VARCHAR	100	True	False	False	True	%s
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
CustomerTypeSparse	-7	BIT	1	True	False	False	False	1 0 true false
CustomerTypeDomain	12	VARCHAR	100	True	False	False	False	%s

TABLE DETAIL REFERENCE: DateDrivenTerms

(Online 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	10	True	False	False	False	%s
Name	12	VARCHAR	100	True	False	True	True	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false
DayOfMonthDue	4	INTEGER	4	True	False	True	True	%11.0f
DueNextMonthDays	4	INTEGER	4	True	False	True	False	%11.0f
DiscountDayOfMonth	4	INTEGER	4	True	False	True	False	%11.0f
DiscountPct	3	DECIMAL	15	True	False	True	False	%11.7f

TABLE DETAIL REFERENCE: Department

(Online 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	10	True	False	False	False	%s
Name	12	VARCHAR	100	True	True	True	False	%s
FullName	12	VARCHAR	1000	True	True	True	False	%s
SubDepartment	-7	BIT	1	True	True	True	False	1 0 true false
ParentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ParentRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
FullyQualifiedName	12	VARCHAR	1000	True	True	True	False	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false

TABLE DETAIL REFERENCE: Deposit

(Online 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	10	True	False	False	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DocNumber	12	VARCHAR	21	True	True	True	False	%s
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	True	True	False	%11.7f
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxInclusive NotApplicable
TransactionLocationType	12	VARCHAR	32	True	True	True	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnStatus	12	VARCHAR	13	True	True	True	False	Draft Overdue Pending Payable Paid Trash Unpaid
DepositToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnSource	12	VARCHAR	100	True	False	False	False	%s
CashBackAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CashBackAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CashBackAmount	12	VARCHAR	21	True	True	True	False	%s
CashBackMemo	12	VARCHAR	21	True	True	True	False	%s
TotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
HomeTotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill

TABLE DETAIL REFERENCE: DepositAppliedToTxn

(Online 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	10	True	False	False	False	%s
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
DocNumber	12	VARCHAR	21	True	False	False	False	%s
DepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	False	False	%11.7f
GlobalTaxCalculation	12	VARCHAR	15	True	False	False	False	TaxExcluded TaxInclusive NotApplicable
TransactionLocationType	12	VARCHAR	32	True	False	False	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU
PrivateNote	12	VARCHAR	4000	True	False	False	False	%s
TxnStatus	12	VARCHAR	13	True	False	False	False	Draft Overdue Pending Payable Paid Trash Unpaid
DepositToAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
TxnSource	12	VARCHAR	100	True	False	False	False	%s
CashBackAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CashBackAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
CashBackAmount	12	VARCHAR	21	True	False	False	False	%s
CashBackMemo	12	VARCHAR	21	True	False	False	False	%s
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
HomeTotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
DepositAppliedToTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
DepositAppliedToTxnTxnType	12	VARCHAR	32	True	False	False	False	APCreditCard ARRefundCreditCard Bill BillPaymentCheck BuildAssembly CarryOver CashPurchase Charge Check CreditMemo Deposit EFPLiabilityCheck EFTBillPayment EFTRefund Estimate InventoryAdjustment InventoryTransfer Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck Purchase PurchaseOrder PriorPayment ReceivePayment RefundCheck RefundReceipt SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer TimeActivity VendorCredit YTDAdjustment
DepositAppliedToTxnTxnLineID	12	VARCHAR	36	True	False	False	False	%s
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	False	False	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	False	False	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	False	False	False	Billable NotBillable HasBeenBill
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: DepositAttachable

(Online 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	10	True	False	False	False	%s
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
DocNumber	12	VARCHAR	21	True	False	False	False	%s
DepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	False	False	%11.7f
GlobalTaxCalculation	12	VARCHAR	15	True	False	False	False	TaxExcluded TaxInclusive NotApplicable
TransactionLocationType	12	VARCHAR	32	True	False	False	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU
PrivateNote	12	VARCHAR	4000	True	False	False	False	%s
TxnStatus	12	VARCHAR	13	True	False	False	False	Draft Overdue Pending Payable Paid Trash Unpaid
DepositToAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
TxnSource	12	VARCHAR	100	True	False	False	False	%s
CashBackAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CashBackAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
CashBackAmount	12	VARCHAR	21	True	False	False	False	%s
CashBackMemo	12	VARCHAR	21	True	False	False	False	%s
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
HomeTotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
AttachableRefListID	12	VARCHAR	36	True	False	False	False	%s
AttachableRefEntityRefListID	12	VARCHAR	36	True	False	False	False	%s
AttachableRefEntityRefFullName	12	VARCHAR	1000	True	False	False	False	%s
AttachableRefLineInfo	12	VARCHAR	4000	True	False	False	False	%s
AttachableRefIncludeOnSend	-7	BIT	1	True	False	False	False	1 0 true false
AttachableRefInactive	-7	BIT	1	True	False	False	False	1 0 true false
AttachableRefNoRefOnly	-7	BIT	1	True	False	False	False	1 0 true false
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	False	False	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	False	False	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	False	False	False	Billable NotBillable HasBeenBill
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: DepositLine

(Online 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	10	True	False	False	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DocNumber	12	VARCHAR	21	True	True	True	False	%s
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	True	True	False	%11.7f
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxInclusive NotApplicable
TransactionLocationType	12	VARCHAR	32	True	True	True	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnStatus	12	VARCHAR	13	True	True	True	False	Draft Overdue Pending Payable Paid Trash Unpaid
DepositToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnSource	12	VARCHAR	100	True	False	False	False	%s
CashBackAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CashBackAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CashBackAmount	12	VARCHAR	21	True	True	True	False	%s
CashBackMemo	12	VARCHAR	21	True	True	True	False	%s
TotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
HomeTotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
DepositLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
DepositLineLineNum	4	INTEGER	4	True	True	True	False	%s
DepositLineDescription	12	VARCHAR	4000	True	True	True	False	%s
DepositLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
DepositLineDetailType	12	VARCHAR	64	True	True	True	False	DepositLineDetail
DepositLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
DepositLineDetailEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositLineDetailEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepositLineDetailClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositLineDetailClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepositLineDetailAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositLineDetailAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepositLineDetailPaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositLineDetailPaymentMethodRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepositLineDetailCheckNum	12	VARCHAR	4000	True	True	True	False	%s
DepositLineDetailTxnType	12	VARCHAR	32	True	True	True	False	APCreditCard ARRefundCreditCard Bill BillPaymentCheck BuildAssembly CarryOver CashPurchase Charge Check CreditMemo Deposit EFPLiabilityCheck EFTBillPayment EFTRefund Estimate InventoryAdjustment InventoryTransfer Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck Purchase PurchaseOrder PriorPayment ReceivePayment RefundCheck RefundReceipt SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer TimeActivity VendorCredit YTDAdjustment
DepositLineDetailTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositLineDetailTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
AppliedToTxnTxnID	12	VARCHAR	36	True	True	True	False	%s
AppliedToTxnTxnType	12	VARCHAR	32	True	True	True	False	ARRefundCreditCard Transfer Cash CreditCardCharge CreditCardCredit SalesReceipt RefundReceipt JournalEntry BillPaymentCheck Check ReceivePayment Payment
AppliedToTxnTxnLineID	12	VARCHAR	36	True	True	True	False	%s
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: DepositTaxLineDetail

(Online 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	10	True	False	False	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DocNumber	12	VARCHAR	21	True	True	True	False	%s
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	True	True	False	%11.7f
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxInclusive NotApplicable
TransactionLocationType	12	VARCHAR	32	True	True	True	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnStatus	12	VARCHAR	13	True	True	True	False	Draft Overdue Pending Payable Paid Trash Unpaid
DepositToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnSource	12	VARCHAR	100	True	False	False	False	%s
CashBackAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CashBackAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CashBackAmount	12	VARCHAR	21	True	True	True	False	%s
CashBackMemo	12	VARCHAR	21	True	True	True	False	%s
TotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
HomeTotalAmt	3	DECIMAL	13	True	True	True	False	%11.2f
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
TaxDetailLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
TaxDetailLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
TaxDetailLineDetailType	12	VARCHAR	15	True	True	True	False	TaxLineDetail
TaxDetailLineTaxRateRefListID	12	VARCHAR	36	True	True	True	False	%s
TaxDetailLineTaxRateRefFullName	12	VARCHAR	1000	True	True	True	False	%s
TaxDetailLinePercentBased	-7	BIT	1	True	True	True	False	1 0 true false
TaxDetailLineTaxPercent	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineNetAmountTaxable	3	DECIMAL	13	True	True	True	False	%11.2f
TaxDetailLineOverrideDeltaAmount	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Employee

(Online 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	10	True	False	False	False	%s
Organization	-7	BIT	1	True	True	True	False	1 0 true false
Name	12	VARCHAR	100	True	True	True	False	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false
Salutation	12	VARCHAR	15	True	True	True	False	%s
FirstName	12	VARCHAR	25	True	True	True	False	%s
MiddleName	12	VARCHAR	25	True	True	True	False	%s
LastName	12	VARCHAR	25	True	True	True	False	%s
Suffix	12	VARCHAR	10	True	True	True	False	%s
PrintAs	12	VARCHAR	110	True	True	True	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
Mobile	12	VARCHAR	21	True	True	True	False	%s
AltPhone	12	VARCHAR	21	True	True	True	False	%s
Email	12	VARCHAR	100	True	True	True	False	%s
EmployeeNumber	12	VARCHAR	100	True	True	True	False	%s
SSN	12	VARCHAR	100	True	True	True	False	%s
EmployeeAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
EmployeeAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
EmployeeAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
EmployeeAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
EmployeeAddressCity	12	VARCHAR	255	True	True	True	False	%s
EmployeeAddressState	12	VARCHAR	255	True	True	True	False	%s
EmployeeAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
EmployeeAddressCountry	12	VARCHAR	255	True	True	True	False	%s
BillableTime	-7	BIT	1	True	True	True	False	1 0 true false
BillRate	3	DECIMAL	18	True	True	True	False	%10.7f
BirthDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Gender	12	VARCHAR	100	True	True	True	False	%s
HiredDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
ReleasedDate	9	DATE	6	True	False	True	False	CCCC-MM-DD

TABLE DETAIL REFERENCE: Entitlements

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
ID	12	VARCHAR	36	True	False	False	False	%s
QboCompany	12	VARCHAR	1000	True	False	False	False	%s
PlanName	12	VARCHAR	1000	True	False	False	False	%s
MaxUsers	3	DECIMAL	15	True	False	False	False	%11.2f
CurrentUsers	3	DECIMAL	15	True	False	False	False	%11.2f
DaysRemainingTrial	3	DECIMAL	15	True	False	False	False	%11.2f
FQPrimaryKey	12	VARCHAR	256	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: EntitlementsLine

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
ID	12	VARCHAR	36	True	False	False	False	%s
QboCompany	12	VARCHAR	1000	True	False	False	False	%s
PlanName	12	VARCHAR	1000	True	False	False	False	%s
MaxUsers	3	DECIMAL	15	True	False	False	False	%11.2f
CurrentUsers	3	DECIMAL	15	True	False	False	False	%11.2f
DaysRemainingTrial	3	DECIMAL	15	True	False	False	False	%11.2f
EntitlementLineListID	12	VARCHAR	36	True	False	False	False	%s
EntitlementLineName	12	VARCHAR	1000	True	False	False	False	%s
EntitlementLineTerm	-7	BIT	1	True	False	False	False	1 0 true false
FQPrimaryKey	12	VARCHAR	256	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: EntitlementsThreshold

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
ID	12	VARCHAR	36	True	False	False	False	%s
QboCompany	12	VARCHAR	1000	True	False	False	False	%s
PlanName	12	VARCHAR	1000	True	False	False	False	%s
MaxUsers	3	DECIMAL	15	True	False	False	False	%11.2f
CurrentUsers	3	DECIMAL	15	True	False	False	False	%11.2f
DaysRemainingTrial	3	DECIMAL	15	True	False	False	False	%11.2f
EntitlementThresholdsName	12	VARCHAR	1000	True	False	False	False	%s
EntitlementThresholdsLimit	3	DECIMAL	13	True	False	False	False	%8.2f
EntitlementThresholdsEnforced	-7	BIT	1	True	False	False	False	1 0 true false
EntitlementThresholdsCurrentCount	3	DECIMAL	13	True	False	False	False	%8.2f
EntitlementThresholdsAboveThreshold	-7	BIT	1	True	False	False	False	1 0 true false
FQPrimaryKey	12	VARCHAR	256	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Entity

(Online 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	10	True	False	False	False	%s
Name	12	VARCHAR	1000	True	False	False	False	%s
FullName	12	VARCHAR	1000	True	False	False	False	%s
ClassRefListID	12	VARCHAR	36	True	False	False	False	%s
ClassRefFullName	12	VARCHAR	1000	True	False	False	False	%s
ParentRefListID	12	VARCHAR	36	True	False	False	False	%s
ParentRefFullName	12	VARCHAR	1000	True	False	False	False	%s
Sublevel	4	INTEGER	4	True	False	False	False	%11.0f
CompanyName	12	VARCHAR	1000	True	False	False	False	%s
Salutation	12	VARCHAR	1000	True	False	False	False	%s
FirstName	12	VARCHAR	1000	True	False	False	False	%s
MiddleName	12	VARCHAR	1000	True	False	False	False	%s
LastName	12	VARCHAR	1000	True	False	False	False	%s
JobTitle	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr1	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr2	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr3	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr4	12	VARCHAR	1000	True	False	False	False	%s
BillAddressAddr5	12	VARCHAR	1000	True	False	False	False	%s
BillAddressCity	12	VARCHAR	1000	True	False	False	False	%s
BillAddressState	12	VARCHAR	1000	True	False	False	False	%s
BillAddressPostalCode	12	VARCHAR	1000	True	False	False	False	%s
BillAddressCountry	12	VARCHAR	1000	True	False	False	False	%s
BillAddressNote	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr1	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr2	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr3	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr4	12	VARCHAR	1000	True	False	False	False	%s
BillAddressBlockAddr5	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr2	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr3	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr4	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressAddr5	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressCity	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressState	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressPostalCode	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressCountry	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressNote	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr1	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr2	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr3	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr4	12	VARCHAR	1000	True	False	False	False	%s
ShipAddressBlockAddr5	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressName	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr1	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr2	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr3	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr4	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressAddr5	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressCity	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressState	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressPostalCode	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressCountry	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressNote	12	VARCHAR	1000	True	False	False	False	%s
ShipToAddressDefaultShipTo	-7	BIT	1	True	False	False	False	1 0 true false
Phone	12	VARCHAR	1000	True	False	False	False	%s
AltPhone	12	VARCHAR	1000	True	False	False	False	%s
Fax	12	VARCHAR	1000	True	False	False	False	%s
Email	12	VARCHAR	1000	True	False	False	False	%s
Cc	12	VARCHAR	1000	True	False	False	False	%s
Contact	12	VARCHAR	1000	True	False	False	False	%s
AltContac	12	VARCHAR	1000	True	False	False	False	%s
AdditionalContactRefContactName	12	VARCHAR	1000	True	False	False	False	%s
AdditionalContactRefContactValue	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetListID	12	VARCHAR	36	True	False	False	False	%s
ContactsRetTimeCreated	11	TIMESTAMP	16	True	False	False	False	%s
ContactsRetTimeModified	11	TIMESTAMP	16	True	False	False	False	%s
ContactsRetEditSequence	12	VARCHAR	10	True	False	False	False	%s
ContactsRetContact	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetSalutation	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetFirstName	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetMiddleName	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetLastName	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetJobTitle	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetAdditionalContactRefContactName	12	VARCHAR	1000	True	False	False	False	%s
ContactsRetAdditionalContactRefContactValue	12	VARCHAR	1000	True	False	False	False	%s
CustomerTypeRefListID	12	VARCHAR	36	True	False	False	False	%s
CustomerTypeRefFullName	12	VARCHAR	1000	True	False	False	False	%s
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s
TermsRefFullName	12	VARCHAR	1000	True	False	False	False	%s
SalesRepRefListID	12	VARCHAR	36	True	False	False	False	%s
SalesRepRefFullName	12	VARCHAR	1000	True	False	False	False	%s
Balance	3	DECIMAL	15	True	False	False	False	%11.2f
TotalBalance	3	DECIMAL	15	True	False	False	False	%11.2f
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s
SalesTaxCodeRefFullName	12	VARCHAR	1000	True	False	False	False	%s
ItemSalesTaxRefListID	12	VARCHAR	36	True	False	False	False	%s
ItemSalesTaxRefFullName	12	VARCHAR	1000	True	False	False	False	%s
ResaleNumber	12	VARCHAR	16	True	False	False	False	%s
PreferredPaymentMethodRefListID	12	VARCHAR	36	True	False	False	False	%s
PreferredPaymentMethodRefFullName	12	VARCHAR	1000	True	False	False	False	%s
PriceLevelRefListID	12	VARCHAR	36	True	False	False	False	%s
PriceLevelRefFullName	12	VARCHAR	1000	True	False	False	False	%s
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	False	%s
Type	12	VARCHAR	1000	True	False	False	True	%s

TABLE DETAIL REFERENCE: Estimate

(Online 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	10	True	False	False	False	%s
DocNumber	12	VARCHAR	21	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnStatus	12	VARCHAR	1000	True	False	False	False	%s
CustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CustomerMemo	12	VARCHAR	1000	True	True	True	False	%s
BillAddressID	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	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	31	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressProvince	12	VARCHAR	255	True	True	True	False	%s
BillAddressCounty	12	VARCHAR	255	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	500	True	True	True	False	%s
ShipAddressID	12	VARCHAR	41	True	True	True	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	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	31	True	True	True	False	%s
ShipAddressState	12	VARCHAR	100	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	500	True	True	True	False	%s
ShipMethodRef	12	VARCHAR	1000	True	False	False	False	%s	Yes
ShipMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
ApplyTaxAfterDiscount	-7	BIT	1	True	False	False	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
ExpirationDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AcceptedBy	12	VARCHAR	1000	True	False	False	False	%s	Yes
AcceptedDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldPONumber	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: EstimateLine

(Online 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	10	True	False	False	False	%s
DocNumber	12	VARCHAR	21	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnStatus	12	VARCHAR	1000	True	False	False	False	%s
CustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CustomerMemo	12	VARCHAR	1000	True	True	True	False	%s
BillAddressID	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	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	31	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressProvince	12	VARCHAR	255	True	True	True	False	%s
BillAddressCounty	12	VARCHAR	255	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	500	True	True	True	False	%s
ShipAddressID	12	VARCHAR	41	True	True	True	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	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	31	True	True	True	False	%s
ShipAddressState	12	VARCHAR	100	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	500	True	True	True	False	%s
ShipMethodRef	12	VARCHAR	1000	True	False	False	False	%s	Yes
ShipMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
ApplyTaxAfterDiscount	-7	BIT	1	True	False	False	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
ExpirationDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AcceptedBy	12	VARCHAR	1000	True	False	False	False	%s	Yes
AcceptedDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
EstimateLineType	12	VARCHAR	11	True	False	False	False	ItemType
EstimateLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
EstimateLineGroupTxnLineID	12	VARCHAR	36	True	True	False	False	%s
EstimateLineGroupItemGroupRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
EstimateLineGroupItemGroupRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
EstimateLineGroupDesc	12	VARCHAR	4095	True	False	False	False	%s
EstimateLineGroupQuantity	3	DECIMAL	16	True	True	True	False	%10.7f
EstimateLineGroupAmount	3	DECIMAL	13	True	True	False	False	%11.2f
EstimateLineGroupIsPrintItemsInGroup	-7	BIT	1	True	False	False	False	1 0 true false
EstimateLineGroupTotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
EstimateLineGroupSeqNo	4	INTEGER	4	True	False	False	False	SubSeqNo
EstimateLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
EstimateLineItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
EstimateLineItemRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
EstimateLineDesc	12	VARCHAR	4095	True	True	True	False	%s
EstimateLineUnitPrice	12	VARCHAR	4095	True	True	True	False	%s
EstimateLineQuantity	3	DECIMAL	16	True	True	True	False	%10.7f
EstimateLineUnitOfMeasure	12	VARCHAR	100	True	True	True	False	%s	Yes
EstimateLineOverrideUOMSetRefListID	12	VARCHAR	36	True	True	False	False	%s	Yes
EstimateLineOverrideUOMSetRefFullName	12	VARCHAR	1000	True	True	False	False	%s	Yes
EstimateLineRate	3	DECIMAL	18	True	True	True	False	%10.7f
EstimateLineRatePercent	3	DECIMAL	15	True	True	True	False	%10.7f
EstimateLinePriceLevelRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
EstimateLinePriceLevelRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
EstimateLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
EstimateLineClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
EstimateLineInventorySiteRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
EstimateLineInventorySiteRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
EstimateLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
EstimateLineTaxAmount	3	DECIMAL	15	True	False	False	False	%11.2f
EstimateLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
EstimateLineSalesTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
EstimateLineSalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
EstimateLineMarkupRate	3	DECIMAL	18	True	True	True	False	%10.7f
EstimateLineMarkupRatePercent	3	DECIMAL	15	True	True	True	False	%10.7f
EstimateLineOverrideItemAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
EstimateLineOverrideItemAccountRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
EstimateLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
EstimateLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CustomFieldEstimateLineOther1	12	VARCHAR	29	True	True	True	False	%s
CustomFieldEstimateLineOther2	12	VARCHAR	29	True	True	True	False	%s
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldPONumber	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: EstimateLinkedTxn

(Online 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	10	True	False	False	False	%s
DocNumber	12	VARCHAR	21	True	False	False	False	%s
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
DepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	False	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	False	False	False	%s
TxnStatus	12	VARCHAR	1000	True	False	False	False	%s
CustomerRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CustomerRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
CustomerMemo	12	VARCHAR	1000	True	False	False	False	%s
BillAddressID	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	500	True	False	False	False	%s
BillAddressCity	12	VARCHAR	31	True	False	False	False	%s
BillAddressState	12	VARCHAR	255	True	False	False	False	%s
BillAddressProvince	12	VARCHAR	255	True	False	False	False	%s
BillAddressCounty	12	VARCHAR	255	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	500	True	False	False	False	%s
ShipAddressID	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	500	True	False	False	False	%s
ShipAddressCity	12	VARCHAR	31	True	False	False	False	%s
ShipAddressState	12	VARCHAR	100	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	500	True	False	False	False	%s
ShipMethodRef	12	VARCHAR	1000	True	False	False	False	%s	Yes
ShipMethodRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
ShipDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
GlobalTaxCalculation	12	VARCHAR	15	True	False	False	False	TaxExcluded TaxIncluded NotApplicable
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
ApplyTaxAfterDiscount	-7	BIT	1	True	False	False	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	False	False	False	%s
ExpirationDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AcceptedBy	12	VARCHAR	1000	True	False	False	False	%s	Yes
AcceptedDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
LinkedTxnSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
LinkedTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
LinkedTxnTxnType	12	VARCHAR	21	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
LinkedTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
LinkedTxnRefNumber	12	VARCHAR	21	True	False	False	False	%s
LinkedTxnLinkType	12	VARCHAR	11	True	False	False	False	AMTTYPE QUANTYPE
LinkedTxnAmount	3	DECIMAL	15	True	False	False	False	%11.2f
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	False	False	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	False	False	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	False	False	False	Billable NotBillable HasBeenBill
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldPONumber	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: EstimateTaxLineDetail

(Online 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	10	True	False	False	False	%s
DocNumber	12	VARCHAR	21	True	True	True	False	%s
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnStatus	12	VARCHAR	1000	True	False	False	False	%s
CustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CustomerMemo	12	VARCHAR	1000	True	True	True	False	%s
BillAddressID	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	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	31	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressProvince	12	VARCHAR	255	True	True	True	False	%s
BillAddressCounty	12	VARCHAR	255	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	500	True	True	True	False	%s
ShipAddressID	12	VARCHAR	41	True	True	True	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	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	31	True	True	True	False	%s
ShipAddressState	12	VARCHAR	100	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	500	True	True	True	False	%s
ShipMethodRef	12	VARCHAR	1000	True	False	False	False	%s	Yes
ShipMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
ApplyTaxAfterDiscount	-7	BIT	1	True	False	False	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
ExpirationDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
AcceptedBy	12	VARCHAR	1000	True	False	False	False	%s	Yes
AcceptedDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
TaxDetailDefaultTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxDetailDefaultTaxCodeRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailReviewStatus	12	VARCHAR	11	True	True	True	False	Billable NotBillable HasBeenBill
TaxDetailLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
TaxDetailLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
TaxDetailLineDetailType	12	VARCHAR	15	True	True	True	False	TaxLineDetail
TaxDetailLineTaxRateRefListID	12	VARCHAR	36	True	True	True	False	%s
TaxDetailLineTaxRateRefFullName	12	VARCHAR	1000	True	True	True	False	%s
TaxDetailLinePercentBased	-7	BIT	1	True	True	True	False	1 0 true false
TaxDetailLineTaxPercent	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineNetAmountTaxable	3	DECIMAL	13	True	True	True	False	%11.2f
TaxDetailLineOverrideDeltaAmount	3	DECIMAL	13	True	True	True	False	%10.7f
TaxDetailLineTaxInclusiveAmount	4	INTEGER	4	True	True	True	False	%11.0f
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldPONumber	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: ExchangeRate

(Online 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	10	True	False	False	False	%s
SourceCurrencyCode	12	VARCHAR	100	True	False	True	False	%s
TargetCurrencyCode	12	VARCHAR	1000	True	False	True	False	%s
Rate	3	DECIMAL	18	True	False	False	False	%11.7f
AsOfDate	9	DATE	6	True	False	True	False	CCCC-MM-DD

TABLE DETAIL REFERENCE: ExchangeRateAttachable

(Online 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	10	True	False	False	False	%s
SourceCurrencyCode	12	VARCHAR	100	True	False	True	False	%s
TargetCurrencyCode	12	VARCHAR	1000	True	False	True	False	%s
Rate	3	DECIMAL	18	True	False	False	False	%11.7f
AsOfDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
AttachableRefListID	12	VARCHAR	36	True	False	False	False	%s
AttachableRefEntityRefListID	12	VARCHAR	36	True	False	True	False	%s
AttachableRefEntityRefFullName	12	VARCHAR	1000	True	False	True	False	%s
AttachableRefLineInfo	12	VARCHAR	4000	True	False	True	False	%s
AttachableRefIncludeOnSend	-7	BIT	1	True	False	True	False	1 0 true false
AttachableRefInactive	-7	BIT	1	True	False	True	False	1 0 true false
AttachableRefNoRefOnly	-7	BIT	1	True	False	True	False	1 0 true false
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Host

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
ID	4	INTEGER	4	True	False	False	False	FQID
ProductName	12	VARCHAR	255	True	False	False	False	%s
MajorVersion	12	VARCHAR	5	True	False	False	False	%s
MinorVersion	12	VARCHAR	5	True	False	False	False	%s
QODBCMajorVersion	12	VARCHAR	5	True	False	False	False	QODBCMajorVersion
QODBCMinorVersion	12	VARCHAR	5	True	False	False	False	QODBCMinorVersion
QODBCBuildNumber	12	VARCHAR	5	True	False	False	False	QODBCBuildNumber
QODBCRegion	12	VARCHAR	5	True	False	False	False	QODBCRegion
QODBCSerialNo	12	VARCHAR	12	True	False	False	False	QODBCSerialNo
QODBCEdition	12	VARCHAR	50	True	False	False	False	QODBCEdition
QODBCEditionQBES	12	VARCHAR	50	True	False	False	False	QODBCEditionQBES
QODBCEditionRunning	12	VARCHAR	50	True	False	False	False	QODBCEditionRunning

TABLE DETAIL REFERENCE: HostSupportedVersions

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
ID	4	INTEGER	4	True	False	False	False	FQID	Yes
ProductName	12	VARCHAR	255	True	False	False	False	%s
MajorVersion	12	VARCHAR	5	True	False	False	False	%s
MinorVersion	12	VARCHAR	5	True	False	False	False	%s
SupportedQBXMLVersion	12	VARCHAR	10	True	False	False	False	%s
QODBCMajorVersion	12	VARCHAR	5	True	False	False	False	QODBCMajorVersion
QODBCMinorVersion	12	VARCHAR	5	True	False	False	False	QODBCMinorVersion
QODBCBuildNumber	12	VARCHAR	5	True	False	False	False	QODBCBuildNumber
QODBCRegion	12	VARCHAR	5	True	False	False	False	QODBCRegion
QODBCSerialNo	12	VARCHAR	12	True	False	False	False	QODBCSerialNo
QODBCEdition	12	VARCHAR	50	True	False	False	False	QODBCEdition
QODBCEditionQBES	12	VARCHAR	50	True	False	False	False	QODBCEditionQBES
QODBCEditionRunning	12	VARCHAR	50	True	False	False	False	QODBCEditionRunning
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: Invoice

(Online 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	10	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	1000	True	True	True	True	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ShipMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	21	True	True	True	False	%s
BillAddressID	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	255	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	255	True	True	True	False	%s
BillAddressNote	12	VARCHAR	500	True	True	True	False	%s
BillEmailBccAddress	12	VARCHAR	1000	True	True	True	False	%s
BillEmailCcAddress	12	VARCHAR	1000	True	True	True	False	%s
ShipAddressID	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	255	True	True	True	False	%s
ShipAddressState	12	VARCHAR	255	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	255	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	500	True	True	True	False	%s
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
DueDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
ShipDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TrackingNumber	12	VARCHAR	1000	True	True	True	False	%s
Subtotal	3	DECIMAL	15	True	True	False	False	%11.2f
SalesTaxPercentage	3	DECIMAL	15	True	False	False	False	%10.7f
SalesTaxTotal	3	DECIMAL	13	True	False	False	False	%11.2f

QODBC.com Tools for QuickBooks