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	7	True	True	True	False	%s
LastCheckNumber	12	VARCHAR	21	True	True	True	False	%s
Desc	12	VARCHAR	100	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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	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
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
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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	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

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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	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
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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	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
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
FQPrimaryKey	12	VARCHAR	110	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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	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: 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	False	False	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	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	False	False	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	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: 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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	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	False	False	FQPrimaryKey

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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	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
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
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
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToPrint 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
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
CustomFieldCrew1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew2	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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	False	False	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
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
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
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToPrint 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
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
CreditMemoLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CreditMemoLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
CreditMemoLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
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	True	True	False	%s	Yes
CreditMemoLineOverrideItemAccountRefFullName	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
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
CustomFieldCrew1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew2	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
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
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
IsToBePrinted	-7	BIT	1	True	False	False	False	1 0 true false
EmailStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint 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
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
CustomFieldCrew1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew2	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
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
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
UpdateAccountOnTxns	-7	BIT	1	False	True	False	False	1 0 true false

TABLE DETAIL REFERENCE: CustomField

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
OwnerID	12	VARCHAR	50	True	False	True	True	%s
Name	12	VARCHAR	31	True	False	True	True	%s
EntityType	12	VARCHAR	23	True	False	True	False	Customer Vendor Employee OtherName Item Account
EntityRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
EntityRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
TxnType	12	VARCHAR	23	True	False	True	False	Bill BillPaymentCheck BillPaymentCreditCard Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck VendorCredit BuildAssembly ARRefundCreditCard
TxnID	12	VARCHAR	36	True	False	True	False	%s
TxnLineID	12	VARCHAR	36	True	False	True	False	%s
OtherType	12	VARCHAR	7	True	False	True	False	Company
Value	12	VARCHAR	4095	True	False	True	True

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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	True	True	False	%11.7f
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxInclusive NotApplicable
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

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
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
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
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
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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	True	True	False	%11.7f
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxInclusive NotApplicable
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
FQSaveToCache	-7	BIT	1	True	False	True	False	FQSaveToCache
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
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
Term	-7	BIT	1	True	False	False	False	1 0 true false

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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	False	False	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
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
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
ShipDate	9	DATE	6	True	False	False	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 NeedToPrint 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
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
CustomFieldCrew1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew2	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	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	False	False	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
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
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
ShipDate	9	DATE	6	True	False	False	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 NeedToPrint 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
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
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
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
CustomFieldCrew1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew2	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
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
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
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 NeedToPrint 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
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
CustomFieldCrew1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew2	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
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	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
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
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
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
AppliedAmount	3	DECIMAL	15	True	False	False	False	%11.2f
BalanceRemaining	3	DECIMAL	15	True	False	False	False	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToPrint EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
HomeBalance	3	DECIMAL	15	True	False	False	False	%11.2f
TaxRateRefName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TaxRateRefType	12	VARCHAR	1000	True	True	True	False	%s	Yes
TaxRateRefValue	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnSource	12	VARCHAR	100	True	False	False	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
TaxLineDetailPercentBase	-7	BIT	1	False	True	True	False	1 0 true false
TaxLineDetailTaxPercent	3	DECIMAL	15	False	True	True	False	%10.7f
TaxLineDetailNetAmountTaxable	3	DECIMAL	15	False	True	True	False	%7.5f
DiscountLineAmount	3	DECIMAL	15	True	False	True	False	%11.2f
DiscountLineRatePercent	3	DECIMAL	15	True	False	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	False	True	False	%11.2f
ShippingLineAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
ShippingLineAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes
CustomFieldCrew	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew2	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: InvoiceLine

(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
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
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	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
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
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
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
AppliedAmount	3	DECIMAL	15	True	False	False	False	%11.2f
BalanceRemaining	3	DECIMAL	15	True	False	False	False	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToPrint EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
HomeBalance	3	DECIMAL	15	True	False	False	False	%11.2f
TaxRateRefName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TaxRateRefType	12	VARCHAR	1000	True	True	True	False	%s	Yes
TaxRateRefValue	12	VARCHAR	1000	True	True	True	False	%s	Yes
TxnSource	12	VARCHAR	100	True	False	False	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
TaxLineDetailPercentBase	-7	BIT	1	False	True	True	False	1 0 true false
TaxLineDetailTaxPercent	3	DECIMAL	15	False	True	True	False	%10.7f
TaxLineDetailNetAmountTaxable	3	DECIMAL	15	False	True	True	False	%7.5f
InvoiceLineType	12	VARCHAR	11	True	False	True	False	ItemType
InvoiceLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
InvoiceLineGroupTxnLineID	12	VARCHAR	36	True	True	False	False	%s
InvoiceLineGroupItemGroupRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InvoiceLineGroupItemGroupRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
InvoiceLineGroupDesc	12	VARCHAR	4000	True	False	True	False	%s
InvoiceLineGroupQuantity	3	DECIMAL	16	True	True	True	False	%8.5f
InvoiceLineGroupAmount	3	DECIMAL	15	True	True	True	False	%11.2f
InvoiceLineGroupTotalAmount	3	DECIMAL	13	True	False	False	False	%8.2f
InvoiceLineGroupServiceDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
InvoiceLineGroupSeqNo	4	INTEGER	4	True	False	False	False	SubSeqNo
InvoiceLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
InvoiceLineItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InvoiceLineItemRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
InvoiceLineDesc	12	VARCHAR	4000	True	True	True	False	%s
InvoiceLineQuantity	3	DECIMAL	16	True	True	True	False	%10.7f
InvoiceLineRate	3	DECIMAL	18	True	True	True	False	%10.7f
InvoiceLineRatePercent	3	DECIMAL	15	True	True	True	False	%10.7f
InvoiceLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InvoiceLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
InvoiceLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
InvoiceLineTaxAmount	3	DECIMAL	15	True	False	False	False	%11.2f
InvoiceLineServiceDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
InvoiceLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
InvoiceLineTaxCodeRefType	12	VARCHAR	1000	True	True	True	False	%s	Yes
InvoiceLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
InvoiceLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DiscountLineAmount	3	DECIMAL	15	True	False	True	False	%11.2f
DiscountLineRatePercent	3	DECIMAL	15	True	False	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	False	True	False	%11.2f
ShippingLineAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
ShippingLineAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes
FQSaveToCache	-7	BIT	1	True	True	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
CustomFieldCrew1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew2	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: InvoiceLinkedTxn

(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
DepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
ClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ClassRefFullName	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
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	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
BillEmailBccAddress	12	VARCHAR	1000	True	False	False	False	%s
BillEmailCcAddress	12	VARCHAR	1000	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
TermsRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TermsRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
DueDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
ShipDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
Subtotal	3	DECIMAL	15	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
AppliedAmount	3	DECIMAL	15	True	False	False	False	%11.2f
BalanceRemaining	3	DECIMAL	15	True	False	False	False	%11.2f
Memo	12	VARCHAR	4000	True	False	False	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
IsToBePrinted	-7	BIT	1	True	False	False	False	1 0 true false
EmailStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint EmailSent
BillEmailAddress	12	VARCHAR	1000	True	False	False	False	%s
HomeBalance	3	DECIMAL	15	True	False	False	False	%11.2f
TaxRateRefName	12	VARCHAR	1000	True	False	False	False	%s	Yes
TaxRateRefType	12	VARCHAR	1000	True	False	False	False	%s	Yes
TaxRateRefValue	12	VARCHAR	1000	True	False	False	False	%s	Yes
TxnSource	12	VARCHAR	100	True	False	False	False	%s
GlobalTaxCalculation	12	VARCHAR	15	True	False	False	False	TaxExcluded TaxIncluded NotApplicable
TaxLineDetailPercentBase	-7	BIT	1	False	False	False	False	1 0 true false
TaxLineDetailTaxPercent	3	DECIMAL	15	False	False	False	False	%10.7f
TaxLineDetailNetAmountTaxable	3	DECIMAL	15	False	False	False	False	%7.5f
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
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
CustomFieldCrew1	12	VARCHAR	30	True	True	True	False	%s
CustomFieldCrew2	12	VARCHAR	30	True	True	True	False	%s

TABLE DETAIL REFERENCE: ItemGroup

(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	False	False	False	%s
FullName	12	VARCHAR	1000	True	False	False	False	%s
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
Sku	12	VARCHAR	100	True	False	False	False	%s
Type	12	VARCHAR	1000	True	False	False	False	%s
ItemDesc	12	VARCHAR	4000	True	False	False	False	%s
IsTaxable	-7	BIT	1	True	False	False	False	1 0 true false
UnitPrice	3	DECIMAL	18	True	False	False	False	%10.7f
PurchaseCost	3	DECIMAL	15	True	False	False	False	%10.6f
IsPrintGroupedItems	-7	BIT	1	True	False	False	False	1 0 true false

TABLE DETAIL REFERENCE: ItemGroupLine

(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	False	False	False	%s
FullName	12	VARCHAR	1000	True	False	False	False	%s
IsActive	-7	BIT	1	True	False	False	False	1 0 true false
Sku	12	VARCHAR	100	True	False	False	False	%s
Type	12	VARCHAR	1000	True	False	False	False	%s
ItemDesc	12	VARCHAR	4000	True	False	False	False	%s
IsTaxable	-7	BIT	1	True	False	False	False	1 0 true false
UnitPrice	3	DECIMAL	18	True	False	False	False	%10.7f
PurchaseCost	3	DECIMAL	15	True	False	False	False	%10.6f
IsPrintGroupedItems	-7	BIT	1	True	False	False	False	1 0 true false
ItemGroupLineSeqNo	12	VARCHAR	36	True	False	False	False	%s
ItemGroupLineItemRefListID	12	VARCHAR	36	True	False	False	False	%s
ItemGroupLineItemRefFullName	12	VARCHAR	36	True	False	False	False	%s
ItemGroupLineQuantity	3	DECIMAL	15	True	False	False	False	%10.7f
ItemGroupLineItemType	12	VARCHAR	36	True	False	False	False	%s
FQPrimaryKey	12	VARCHAR	110	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: ItemService

(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	False	False	False	%s
Sku	12	VARCHAR	100	True	True	True	True	%s
Description	12	VARCHAR	4000	True	True	True	True	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false
SubItem	-7	BIT	1	True	True	True	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
Taxable	-7	BIT	1	True	True	True	False	1 0 true false
IsTaxIncluded	-7	BIT	1	True	True	True	False	1 0 true false
UnitPrice	3	DECIMAL	18	True	True	True	False	%10.7f
RatePercent	3	DECIMAL	15	True	False	True	False	%7.6f
Type	12	VARCHAR	1000	True	True	True	True	%s
ItemCategoryType	12	VARCHAR	14	True	False	False	True	Product Service
IncomeAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
IncomeAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
PurchaseDesc	12	VARCHAR	1000	True	True	True	True	%s
PurchaseTaxIncluded	-7	BIT	1	True	True	True	False	1 0 true false
PurchaseCost	3	DECIMAL	15	True	True	True	False	%10.6f
ExpenseAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ExpenseAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
AssetAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
AssetAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
TrackQtyOnHand	-7	BIT	1	True	True	True	False	1 0 true false
QtyOnHand	3	DECIMAL	16	True	True	True	False	%10.7f
SalesTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
PurchaseTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PurchaseTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
InvStartDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
SalesOrPurchaseDesc	12	VARCHAR	4000	True	True	True	False	%s
SalesOrPurchasePrice	3	DECIMAL	16	True	True	True	True	%10.7f
SalesOrPurchasePricePercent	3	DECIMAL	15	True	True	True	True	%10.7f
AbatementRate	3	DECIMAL	18	True	True	True	False	%11.7f
ReverseChargeRate	3	DECIMAL	18	True	True	True	False	%11.7f
ServiceType	12	VARCHAR	32	True	True	True	True	ADVT AIRPORTSERVICES AIRTRANSPORT AIRTRVLAGNT ARCHITECT ASSTMGMT ATMMAINTENANCE AUCTIONSERV AUTHSERST BANKANDFIN BEAUTYPARLOR BROADCAST BUSINESSAUX BUSINESSEXHIBITION BUSINESSSUPPORTSERV CA CABLEOPTR CARGOHAND CLEANINGSERV CLEARANDFORW CLUBSANDASSSERVICE COMMCOACHORTRAINING CONSENG CONSTRCOMMERCIALCOMPLEX CONTAINERRAILTRANS CONVSERV COSTACC COURIER CREDITCARD CREDITRATAGNCY CRUISESHIPTOUR CS CUSHOUSEAG DESIGNSERV DEVELOPSUPPLYCONTENT DREDGING DRYCLEANING ERECTIONCOMMORINSTALL EVENTMGMT FASHIONDES FOREXBROKING FORWARDCONTRACT FRANCHISESERV GENERALINSURANCE GOODSTRANSPORT HEALTHCLUBANDFITNESS INFORMATIONSERV INSURAUX INTDEC INTELLECTUALPROPERTY INTERNATIONALAIRTRAVEL INTERNETCAFE INTERNETTELEPHONY LIFEINS MAILLISTCOMPILE MANDAPKEEPER MANPWRRECRUIT MGMTCONSUL MGMTMAINTREPAIR MININGOIL MKTRESAGNCY ONLINEINFORMRETRIEVAL OPINIONPOLL OUTDOORCATERING PACKAGINGSERV PANDALSHAMIANA PHOTOGRAPHY PORT PORTSER PROCESSCLEARHOUSE PUBLICRELATIONMGMT RAILTRAVELAGNT REALESTAGT RECOVERYAGENTS REGISTRARSERV RENTACAB RENTINGIMMOVABLEPROP RESIDENTIALCOMPLEXCONST SALEOFSPACEFORADVT SCANDTECHCONSUL SECAG SERVICESPROVIDEDFORTRANSACTION SHARETRANSFERSERV SHIPMGMT SITEPREP SOUNDRECORD SPONSORSHIP STAG STOCKBROKING STOCKEXCHGSERV STORANDWAREHOUSING SUPPLYTANGIBLEGOODS SURVEYANDMAPMAKING SURVEYMINERALS TECHINSPECTION TECHTESTING TELECOMMUNICATIONSERV TELEVISIONANDRADIO TOUROP TRANSPORTPIPELINE TRAVELAGENT ULIPMANAGEMENT UNDERWRITER VIDEOTAPEPROD WORKSCONTRACT
DoNotUpdateAccountOnTxns	-7	BIT	1	False	True	False	False	1 0 true false

TABLE DETAIL REFERENCE: JournalCode

(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	False	%s
Type	12	VARCHAR	1000	True	True	True	False	%s
Description	12	VARCHAR	100	True	True	True	False	%s
IsActive	-7	BIT	1	True	True	False	False	1 0 true false

TABLE DETAIL REFERENCE: JournalCodeAttachable

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

TABLE DETAIL REFERENCE: JournalEntry

(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
IsAdjustment	-7	BIT	1	True	True	True	False	1 0 true false
IsHomeCurrencyAdjustment	-7	BIT	1	True	True	True	False	1 0 true false
IsAmountsEnteredInHomeCurrency	-7	BIT	1	True	True	True	False	1 0 true false
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	True	False	%11.7f
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
TotalAmount	3	DECIMAL	15	True	True	True	False	%11.2f
HomeTotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
TxnSource	12	VARCHAR	100	True	False	False	False	%s
TransactionLocationType	12	VARCHAR	32	True	True	True	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU

TABLE DETAIL REFERENCE: JournalEntryCreditLine

(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
IsAdjustment	-7	BIT	1	True	True	True	False	1 0 true false
IsHomeCurrencyAdjustment	-7	BIT	1	True	True	True	False	1 0 true false
IsAmountsEnteredInHomeCurrency	-7	BIT	1	True	True	True	False	1 0 true false
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	True	False	%11.7f
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
TotalAmount	3	DECIMAL	15	True	True	True	False	%11.2f
HomeTotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
TxnSource	12	VARCHAR	100	True	False	False	False	%s
TransactionLocationType	12	VARCHAR	32	True	True	True	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU
JournalCreditLineTxnLineID	12	VARCHAR	36	True	True	True	False	%s
JournalCreditLineType	12	VARCHAR	14	True	True	False	False	Debit Credit
JournalCreditLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalCreditLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalCreditLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
JournalCreditLineMemo	12	VARCHAR	4000	True	True	True	False	%s
JournalCreditLineEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalCreditLineEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalCreditLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalCreditLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalCreditLineDepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalCreditLineDepartmentRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
JournalCreditLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalCreditLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalCreditLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
FQSaveToCache	-7	BIT	1	True	True	True	False	FQSaveToCache
FQTransactionLinkKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: JournalEntryDebitLine

(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
IsAdjustment	-7	BIT	1	True	True	True	False	1 0 true false
IsHomeCurrencyAdjustment	-7	BIT	1	True	True	True	False	1 0 true false
IsAmountsEnteredInHomeCurrency	-7	BIT	1	True	True	True	False	1 0 true false
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	True	False	%11.7f
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
RefNumber	12	VARCHAR	21	True	True	True	False	%s
Memo	12	VARCHAR	4000	True	True	True	False	%s
TotalAmount	3	DECIMAL	15	True	True	True	False	%11.2f
HomeTotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
TxnSource	12	VARCHAR	100	True	False	False	False	%s
TransactionLocationType	12	VARCHAR	32	True	True	True	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU
JournalDebitLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
JournalDebitLineType	12	VARCHAR	14	True	True	False	False	Debit Credit
JournalDebitLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalDebitLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalDebitLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
JournalDebitLineMemo	12	VARCHAR	4000	True	True	True	False	%s
JournalDebitLineEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalDebitLineEntityRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalDebitLineClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalDebitLineClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalDebitLineDepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalDebitLineDepartmentRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
JournalDebitLineTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
JournalDebitLineTaxCodeRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
JournalDebitLineBillableStatus	12	VARCHAR	13	True	True	True	False	Billable NotBillable HasBeenBilled
FQSaveToCache	-7	BIT	1	True	True	True	False	FQSaveToCache
FQTransactionLinkKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: JournalEntryLine

(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
IsAdjustment	-7	BIT	1	True	False	False	False	1 0 true false
IsHomeCurrencyAdjustment	-7	BIT	1	True	False	False	False	1 0 true false
IsAmountsEnteredInHomeCurrency	-7	BIT	1	True	False	False	False	1 0 true false
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
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
RefNumber	12	VARCHAR	21	True	False	False	False	%s
Memo	12	VARCHAR	4000	True	False	False	False	%s
TotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
HomeTotalAmount	3	DECIMAL	15	True	False	False	False	%11.2f
TxnSource	12	VARCHAR	100	True	False	False	False	%s
TransactionLocationType	12	VARCHAR	32	True	False	False	False	WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU
JournalLineSeqNo	4	INTEGER	4	True	False	False	False	SeqNo
JournalLineType	12	VARCHAR	25	True	False	False	False	%s
JournalLineTxnLineID	12	VARCHAR	36	True	False	False	False	%s
JournalLineAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
JournalLineAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
JournalLineAmount	3	DECIMAL	15	True	False	False	False	%11.2f
JournalLineCreditAmount	3	DECIMAL	15	True	False	False	False	%11.2f
JournalLineDebitAmount	3	DECIMAL	15	True	False	False	False	%11.2f
JournalLineMemo	12	VARCHAR	4000	True	False	False	False	%s
JournalLineEntityRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
JournalLineEntityRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
JournalLineClassRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
JournalLineClassRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
JournalLineDepartmentRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
JournalLineDepartmentRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
JournalLineTaxCodeRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
JournalLineTaxCodeRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
JournalLineBillableStatus	12	VARCHAR	13	True	False	False	False	Billable NotBillable HasBeenBilled
FQTransactionLinkKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: ListDeleted

(Online VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
ListDelType	12	VARCHAR	20	True	False	False	False	Account Customer Employee OtherName Vendor StandardTerms DateDrivenTerms Class SalesRep CustomerType VendorType JobType CustomerMsg PaymentMethod ShipMethod SalesTaxCode ToDo ItemService ItemNonInventory ItemOtherCharge ItemInventory ItemInventoryAssembly ItemFixedAsset ItemSubtotal ItemDiscount ItemPayment ItemSalesTax ItemSalesTaxGroup ItemGroup PriceLevel PayrollItemNonWage PayrollItemWage VehicleMileage
ListID	12	VARCHAR	36	True	False	False	False	%s
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeDeleted	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
FullName	12	VARCHAR	41	True	False	False	False	%s

TABLE DETAIL REFERENCE: Payment

(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
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnStatus	12	VARCHAR	1000	True	True	True	False	%s
CustomerRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	100	True	False	True	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
DepositToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
PaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
PaymentRefNum	12	VARCHAR	1000	True	False	False	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
TxnSource	12	VARCHAR	100	True	False	False	False	%s
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
UnappliedAmt	3	DECIMAL	13	True	False	False	False	%11.2f
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	True	False	%11.7f

TABLE DETAIL REFERENCE: PaymentAppliedToTxn

(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
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
ARAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
DepositToAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
PaymentMethodRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	False	False	False	%s	Yes
PaymentRefNum	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCAccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CreditCardPaymentCCAccountRefFullName	12	VARCHAR	1000	True	False	False	False	%s	Yes
CreditCardPaymentCCDetailNumber	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCDetailType	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCDetailNameOnAcct	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCDetailCcExpiryMonth	4	INTEGER	4	True	False	False	False	%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear	4	INTEGER	4	True	False	False	False	%11.0f
CreditCardPaymentCCDetailBillAddrStreet	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCDetailPostalCode	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCDetailCommercialCardCode	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCDetailCCTxnMode	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCDetailCCTxnType	12	VARCHAR	1000	True	False	False	False	%s
CreditCardPaymentCCDetailPrevCCTransId	12	VARCHAR	1000	True	False	False	False	%s
TxnSource	12	VARCHAR	100	True	False	False	False	%s
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
UnappliedAmt	3	DECIMAL	13	True	False	False	False	%11.2f
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
PaymentAppliedToTxnTxnID	12	VARCHAR	36	True	False	False	False	%s
PaymentAppliedToTxnTxnType	12	VARCHAR	1000	True	False	False	False	%s
PaymentAppliedToTxnTxnLineID	12	VARCHAR	36	True	False	False	False	%s
PaymentAppliedToTxnTxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
PaymentAppliedToTxnRefNumber	12	VARCHAR	20	True	False	False	False	%s
PaymentAppliedToTxnBalanceRemaining	3	DECIMAL	13	True	False	False	False	%11.2f
PaymentAppliedToTxnAmount	3	DECIMAL	15	True	False	False	False	%11.2f
PaymentAppliedToTxnDiscountAmount	3	DECIMAL	15	True	False	False	False	%11.2f
FQPrimaryKey	12	VARCHAR	73	True	False	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: PaymentLine

(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
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnStatus	12	VARCHAR	1000	True	True	True	False	%s
CustomerRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	100	True	False	True	False	%s	Yes
ARAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ARAccountRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
DepositToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
PaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
PaymentRefNum	12	VARCHAR	1000	True	False	False	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
TxnSource	12	VARCHAR	100	True	False	False	False	%s
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
UnappliedAmt	3	DECIMAL	13	True	False	False	False	%11.2f
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	True	False	%11.7f
PaymentLineTxnLineID	12	VARCHAR	36	True	True	False	False	%s
PaymentLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
FQPrimaryKey	12	VARCHAR	73	True	True	False	False	FQPrimaryKey

TABLE DETAIL REFERENCE: PaymentMethod

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

TABLE DETAIL REFERENCE: Preferences

(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
AccountingInfoPrefsTrackDepartments	-7	BIT	1	True	False	False	False	1 0 true false

QXL - One-Click Export all your QuickBooks data.