TABLE DETAIL REFERENCE: Account
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueTrue%s
FullName12 VARCHAR 1000TrueTrueTrueFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountType12 VARCHAR 21TrueTrueTrueTrue
AccountsPayable
AccountsReceivable
Bank
CostOfGoodsSold
CreditCard
Equity
Expense
FixedAsset
Income
LongTermLiability
Nonposting
OtherAsset
OtherCurrentAsset
OtherCurrentLiability
OtherExpense
OtherIncome
DetailAccountType12 VARCHAR 255TrueTrueTrueFalse
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
AccountNumber12 VARCHAR 7TrueTrueTrueFalse%s
LastCheckNumber12 VARCHAR 21TrueTrueTrueFalse%s
Desc12 VARCHAR 100TrueTrueTrueFalse%s
Balance3 DECIMAL 15TrueFalseTrueFalse%11.2f
TotalBalance3 DECIMAL 15TrueTrueTrueFalse%11.2f
OpenBalance3 DECIMAL 13TrueFalseTrueFalse%11.2f
OpenBalanceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
AccountAlias12 VARCHAR 1000TrueTrueTrueTrue%s
TxnLocationType12 VARCHAR 255TrueTrueTrueFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU
TABLE DETAIL REFERENCE: Attachable
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
FileName12 VARCHAR 1000TrueTrueTrueFalse%s
FileAccessUri12 VARCHAR 1000TrueFalseTrueFalse%s
TempDownloadUri12 VARCHAR 1000TrueFalseTrueFalse%s
Size12 VARCHAR 1000TrueFalseTrueFalse%s
ContentType12 VARCHAR 100TrueFalseTrueFalse%s
Category12 VARCHAR 100TrueFalseTrueFalse%s
Lat12 VARCHAR 100TrueTrueTrueFalse%s
Long12 VARCHAR 100TrueTrueTrueFalse%s
PlaceName12 VARCHAR 2000TrueTrueTrueFalse%s
Note12 VARCHAR 2000TrueTrueTrueFalse%s
Tag12 VARCHAR 2000TrueTrueTrueFalse%s
ThumbnailFileAccessUri12 VARCHAR 1000TrueFalseTrueFalse%s
ThumbnailTempDownloadUri12 VARCHAR 1000TrueFalseTrueFalse%s
TABLE DETAIL REFERENCE: AttachableReference
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
FileName12 VARCHAR 1000TrueTrueTrueFalse%s
FileAccessUri12 VARCHAR 1000TrueFalseTrueFalse%s
TempDownloadUri12 VARCHAR 1000TrueFalseTrueFalse%s
Size12 VARCHAR 1000TrueFalseTrueFalse%s
ContentType12 VARCHAR 100TrueFalseTrueFalse%s
Category12 VARCHAR 100TrueFalseTrueFalse%s
Lat12 VARCHAR 100TrueTrueTrueFalse%s
Long12 VARCHAR 100TrueTrueTrueFalse%s
PlaceName12 VARCHAR 2000TrueTrueTrueFalse%s
Note12 VARCHAR 2000TrueTrueTrueFalse%s
Tag12 VARCHAR 2000TrueTrueTrueFalse%s
ThumbnailFileAccessUri12 VARCHAR 1000TrueFalseTrueFalse%s
ThumbnailTempDownloadUri12 VARCHAR 1000TrueFalseTrueFalse%s
AttachableReferenceEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s
AttachableReferenceEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
AttachableReferenceLineInfo12 VARCHAR 4000TrueTrueTrueFalse%s
AttachableReferenceIncludeOnSend-7 BIT 1TrueTrueTrueFalse
1
0
true
false
AttachableReferenceIsactive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
AttachableReferenceNoRefOnly-7 BIT 1TrueTrueTrueFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Bill
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueTrueTrueFalse%11.0f
VendorRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
VendorRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
AmountDue3 DECIMAL 13TrueTrueTrueFalse%11.2f
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
TABLE DETAIL REFERENCE: BillExpenseLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueTrueTrueFalse%11.0f
VendorRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
VendorRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
AmountDue3 DECIMAL 13TrueTrueTrueFalse%11.2f
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ExpenseLineTxnLineID12 VARCHAR 36TrueTrueTrueFalse%s
ExpenseLineMemo12 VARCHAR 4000TrueTrueTrueFalse%s
ExpenseLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineTaxAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ExpenseLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ExpenseLineMarkupInfoPercent3 DECIMAL 13TrueFalseFalseFalse%7.5f
ExpenseLineMarkupInfoPercentBased-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ExpenseLineMarkupInfoPriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoPriceLevelRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoValue3 DECIMAL 13TrueFalseFalseFalse%8.2f
ExpenseLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineTaxInclusiveAmount4 INTEGER 4TrueTrueTrueFalse%11.0f
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillItemLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueTrueTrueFalse%11.0f
VendorRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
VendorRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
AmountDue3 DECIMAL 13TrueTrueTrueFalse%11.2f
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ItemLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ItemLineNumber12 VARCHAR 16TrueFalseFalseFalse%s
ItemLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineItemRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ItemLineMemo12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineQuantity3 DECIMAL 16TrueTrueTrueFalse%10.7f
ItemLineRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
ItemLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineClassRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ItemLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ItemLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ItemLineDetailType12 VARCHAR 32TrueFalseFalseFalse
ItemBasedExpenseLineDetail
ItemLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ItemLineBillableStatus12 VARCHAR 11TrueTrueTrueFalse
Billable
NotBillable
HasBeenBill
ItemLineMarkupInfoPercent3 DECIMAL 13TrueFalseFalseFalse%10.7f
ItemLineMarkupInfoPercentBased-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemLineMarkupInfoPriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemLineMarkupInfoPriceLevelRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
ItemLineMarkupInfoValue3 DECIMAL 13TrueFalseFalseFalse%10.7f
ItemLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineTaxCodeRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ItemLineTaxInclusiveAmount4 INTEGER 4TrueTrueTrueFalse%11.0f
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueTrueFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillLinkedTxn
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VendorRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
VendorRefFullName12 VARCHAR 1000TrueFalseFalseTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AmountDue3 DECIMAL 13TrueFalseFalseFalse%11.2f
RefNumber12 VARCHAR 21TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
Memo12 VARCHAR 4000TrueFalseFalseFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxIncluded
NotApplicable
LinkedTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
LinkedTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
LinkedTxnTxnType12 VARCHAR 21TrueFalseFalseFalse
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
LinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnRefNumber12 VARCHAR 21TrueFalseFalseFalse%s
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
ExpenseLineBillableStatus12 VARCHAR 23TrueFalseFalseFalse
Billable
NotBillable
HasBeenBilled
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillPayment
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DocNumber12 VARCHAR 1000TrueFalseFalseFalse%s
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
VendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
PayType12 VARCHAR 13TrueFalseTrueFalse
Check
CreditCard
CheckPaymentBankAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CheckPaymentBankAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CheckPaymentPrintStatus12 VARCHAR 13TrueTrueTrueFalse
NeedToPrint
NotSet
PrintComplete
CheckPaymentCheckDetailCheckNum12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailStatus12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailAcctNum12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailBankName12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditCardPaymentCCAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditCardPaymentCCDetailNumber12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCcExpiryMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailBillAddrStreet12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPostalCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCommercialCardCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnMode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPrevCCTransId12 VARCHAR 1000TrueTrueTrueFalse%s
TotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
TABLE DETAIL REFERENCE: BillPaymentAppliedToTxn
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DocNumber12 VARCHAR 1000TrueFalseFalseFalse%s
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
VendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
PayType12 VARCHAR 13TrueFalseTrueFalse
Check
CreditCard
CheckPaymentBankAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CheckPaymentBankAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CheckPaymentPrintStatus12 VARCHAR 13TrueTrueTrueFalse
NeedToPrint
NotSet
PrintComplete
CheckPaymentCheckDetailCheckNum12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailStatus12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailAcctNum12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailBankName12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditCardPaymentCCAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditCardPaymentCCDetailNumber12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCcExpiryMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailBillAddrStreet12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPostalCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCommercialCardCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnMode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPrevCCTransId12 VARCHAR 1000TrueTrueTrueFalse%s
TotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
BillPaymentAppliedToTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
BillPaymentAppliedToTxnTxnType12 VARCHAR 1000TrueFalseFalseFalse%s
BillPaymentAppliedToTxnTxnLineID12 VARCHAR 36TrueFalseFalseFalse%s
BillPaymentAppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
BillPaymentAppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillPaymentLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DocNumber12 VARCHAR 1000TrueFalseFalseFalse%s
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
VendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
PayType12 VARCHAR 13TrueFalseTrueFalse
Check
CreditCard
CheckPaymentBankAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CheckPaymentBankAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CheckPaymentPrintStatus12 VARCHAR 13TrueTrueTrueFalse
NeedToPrint
NotSet
PrintComplete
CheckPaymentCheckDetailCheckNum12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailStatus12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailAcctNum12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailBankName12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditCardPaymentCCAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditCardPaymentCCDetailNumber12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCcExpiryMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailBillAddrStreet12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPostalCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCommercialCardCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnMode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPrevCCTransId12 VARCHAR 1000TrueTrueTrueFalse%s
TotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
BillPaymentLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
BillPaymentLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
BillPaymentAppliedToTxnTxnID12 VARCHAR 36TrueFalseTrueFalse%s
BillPaymentAppliedToTxnTxnType12 VARCHAR 1000TrueFalseTrueFalse%s
BillPaymentAppliedToTxnTxnLineID12 VARCHAR 36TrueFalseTrueFalse%s
BillPaymentAppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
BillPaymentAppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Budget
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 1000TrueFalseFalseFalse%s
StartDate11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EndDate11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
BudgetType12 VARCHAR 13TrueFalseFalseFalse
ProfitAndLoss
BalanceSheet
BudgetEntryType12 VARCHAR 13TrueFalseFalseFalse
Monthly
Quarterly
Annually
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: BudgetDetailLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 1000TrueFalseFalseFalse%s
StartDate11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EndDate11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
BudgetType12 VARCHAR 13TrueFalseFalseFalse
ProfitAndLoss
BalanceSheet
BudgetEntryType12 VARCHAR 13TrueFalseFalseFalse
Monthly
Quarterly
Annually
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
BudgetDetailListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
BudgetDetailBudgetDate11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
BudgetDetailAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
BudgetDetailAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
BudgetDetailAccountRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
BudgetDetailCustomerRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
BudgetDetailCustomerRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
BudgetDetailClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
BudgetDetailClassRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
BudgetDetailDepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
BudgetDetailDepartmentRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Check
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Amount3 DECIMAL 15TrueTrueTrueFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
AddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
AddressCity12 VARCHAR 255TrueTrueTrueFalse%s
AddressState12 VARCHAR 255TrueTrueTrueFalse%s
AddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
AddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
AddressNote12 VARCHAR 500TrueTrueTrueFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
TABLE DETAIL REFERENCE: CheckExpenseLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Amount3 DECIMAL 15TrueTrueTrueFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
AddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
AddressCity12 VARCHAR 255TrueTrueTrueFalse%s
AddressState12 VARCHAR 255TrueTrueTrueFalse%s
AddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
AddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
AddressNote12 VARCHAR 500TrueTrueTrueFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineClearExpenseLines-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ExpenseLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ExpenseLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ExpenseLineMemo12 VARCHAR 4000TrueTrueTrueFalse%s
ExpenseLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineTaxAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ExpenseLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ExpenseLineMarkupInfoPercent3 DECIMAL 13TrueFalseFalseFalse%7.5f
ExpenseLineMarkupInfoPercentBased-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ExpenseLineMarkupInfoPriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoPriceLevelRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoValue3 DECIMAL 13TrueFalseFalseFalse%8.2f
ExpenseLineTaxInclusiveAmount4 INTEGER 4TrueTrueTrueFalse%11.0f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Class
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueTrue%s
FullName12 VARCHAR 1000TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
TABLE DETAIL REFERENCE: Company
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
Id4 INTEGER 4TrueFalseFalseFalseFQID
IsSampleCompany-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CompanyName12 VARCHAR 100TrueFalseFalseFalse%s
LegalCompanyName12 VARCHAR 100TrueFalseFalseFalse%s
AddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
AddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
AddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
AddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
AddressCity12 VARCHAR 255TrueFalseFalseFalse%s
AddressState12 VARCHAR 255TrueFalseFalseFalse%s
AddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
AddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
LegalAddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
LegalAddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
LegalAddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
LegalAddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
LegalAddressCity12 VARCHAR 255TrueFalseFalseFalse%s
LegalAddressState12 VARCHAR 255TrueFalseFalseFalse%s
LegalAddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
LegalAddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr112 VARCHAR 500TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr212 VARCHAR 500TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr312 VARCHAR 500TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr412 VARCHAR 500TrueFalseFalseFalse%s
CompanyAddressForCustomerCity12 VARCHAR 255TrueFalseFalseFalse%s
CompanyAddressForCustomerState12 VARCHAR 255TrueFalseFalseFalse%s
CompanyAddressForCustomerPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
CompanyAddressForCustomerCountry12 VARCHAR 255TrueFalseFalseFalse%s
Phone12 VARCHAR 20TrueFalseFalseFalse%s
Email12 VARCHAR 100TrueFalseFalseFalse%s
CompanyEmailForCustomer12 VARCHAR 100TrueFalseFalseFalse%s
FirstMonthFiscalYear12 VARCHAR 9TrueFalseFalseFalse
January
February
March
April
May
June
July
August
September
October
November
December
FirstMonthIncomeTaxYear12 VARCHAR 9TrueFalseFalseFalse
January
February
March
April
May
June
July
August
September
October
November
December
CompanyType12 VARCHAR 255TrueFalseFalseFalse%s
AccountantCopyExists-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountantCopyDividingDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
TABLE DETAIL REFERENCE: CompanyCurrency
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Code12 VARCHAR 100TrueTrueTrueFalse%s
Name12 VARCHAR 1000TrueTrueTrueFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: CompanyCurrencyAttachable
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
AttachableRefListID12 VARCHAR 36TrueFalseFalseFalse%s
AttachableRefEntityRefListID12 VARCHAR 36TrueFalseFalseFalse%s
AttachableRefEntityRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
AttachableRefLineInfo12 VARCHAR 4000TrueFalseFalseFalse%s
AttachableRefIncludeOnSend-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AttachableRefInactive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AttachableRefNoRefOnly-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Code12 VARCHAR 100TrueFalseFalseFalse%s
Name12 VARCHAR 1000TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: CreditCardCharge
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseTrue%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Amount3 DECIMAL 15TrueTrueTrueFalse%11.2f
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
TABLE DETAIL REFERENCE: CreditCardChargeExpenseLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseTrue%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Amount3 DECIMAL 15TrueTrueTrueFalse%11.2f
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineClearExpenseLines-7 BIT 1FalseTrueTrueFalse
1
0
true
false
ExpenseLineSeqNo4 INTEGER 4TrueTrueTrueFalseSeqNo
ExpenseLineTxnLineID12 VARCHAR 36TrueTrueTrueFalse%s
ExpenseLineMemo12 VARCHAR 4000TrueTrueTrueFalse%s
ExpenseLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineTaxAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ExpenseLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ExpenseLineMarkupInfoPercent3 DECIMAL 13TrueFalseFalseFalse%7.5f
ExpenseLineMarkupInfoPercentBased-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ExpenseLineMarkupInfoPriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoPriceLevelRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoValue3 DECIMAL 13TrueFalseFalseFalse%8.2f
ExpenseLineTaxInclusiveAmount4 INTEGER 4TrueTrueTrueFalse%11.0f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: CreditCardCredit
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Amount3 DECIMAL 15TrueFalseFalseFalse%11.2f
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
TABLE DETAIL REFERENCE: CreditCardCreditExpenseLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Amount3 DECIMAL 15TrueFalseFalseFalse%11.2f
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineClearExpenseLines-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ExpenseLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ExpenseLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ExpenseLineMemo12 VARCHAR 4000TrueTrueTrueFalse%s
ExpenseLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineTaxAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ExpenseLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ExpenseLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ExpenseLineMarkupInfoPercent3 DECIMAL 13TrueFalseFalseFalse%7.5f
ExpenseLineMarkupInfoPercentBased-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ExpenseLineMarkupInfoPriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoPriceLevelRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
ExpenseLineMarkupInfoValue3 DECIMAL 13TrueFalseFalseFalse%8.2f
ExpenseLineTaxInclusiveAmount4 INTEGER 4TrueTrueTrueFalse%11.0f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: CreditMemo
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Subtotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
CreditRemaining3 DECIMAL 13TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
EmailStatus12 VARCHAR 13TrueTrueTrueFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueTrueTrueFalse%s
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
CustomFieldOther12 VARCHAR 29TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
DiscountLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%11.7f
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ShippingLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ShippingLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShippingLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CreditMemoLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Subtotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
CreditRemaining3 DECIMAL 13TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
EmailStatus12 VARCHAR 13TrueTrueTrueFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueTrueTrueFalse%s
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
CustomFieldOther12 VARCHAR 29TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
CreditMemoLineType12 VARCHAR 11TrueFalseFalseFalseItemType
CreditMemoLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
CreditMemoLineGroupLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
CreditMemoLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
CreditMemoLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineItemRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditMemoLineDesc12 VARCHAR 4000TrueTrueTrueFalse%s
CreditMemoLineQuantity3 DECIMAL 16TrueTrueTrueFalse%10.7f
CreditMemoLineRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
CreditMemoLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%10.7f
CreditMemoLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditMemoLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
CreditMemoLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
CreditMemoLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
CreditMemoLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CreditMemoLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineOverrideItemAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditMemoLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DiscountLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%11.7f
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ShippingLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
ShippingLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShippingLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CreditMemoLinkedTxn
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueFalseFalseTrue%s Yes
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
ARAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ARAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 255TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 255TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
ShipDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
Subtotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
CreditRemaining3 DECIMAL 13TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueFalseFalseFalse%s
IsToBePrinted-7 BIT 1TrueFalseFalseFalse
1
0
true
false
EmailStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueFalseFalseFalse%s
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
CustomFieldOther12 VARCHAR 29TrueFalseFalseFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxIncluded
NotApplicable
LinkedTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
LinkedTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
LinkedTxnTxnType12 VARCHAR 21TrueFalseFalseFalse
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
LinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnRefNumber12 VARCHAR 21TrueFalseFalseFalse%s
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
DiscountLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueFalseFalseFalse%11.7f
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ShippingLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
ShippingLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ShippingLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: Customer
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueTrue%s
FullName12 VARCHAR 1000TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 50TrueTrueTrueFalse%s
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 25TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
Suffix12 VARCHAR 10TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
PrintAs12 VARCHAR 110TrueTrueTrueFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
Mobile12 VARCHAR 21TrueTrueTrueFalse%s
Pager12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 100TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Balance3 DECIMAL 15TrueFalseFalseFalse%11.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
OpenBalance3 DECIMAL 13TrueFalseTrueFalse%11.2f
OpenBalanceDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
ResaleNumber12 VARCHAR 16TrueTrueTrueFalse%s
Notes12 VARCHAR 2000TrueTrueTrueFalse%s
IsStatementWithParent-7 BIT 1TrueTrueTrueFalse
1
0
true
false
DeliveryMethod12 VARCHAR 5TrueTrueTrueFalse
Print
Fax
Email
DefaultTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DefaultTaxCodeRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Taxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
WebAddressURI12 VARCHAR 1000TrueTrueTrueFalse%s
Job-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
UpdateAccountOnTxns-7 BIT 1FalseTrueFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: CustomField
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
OwnerID12 VARCHAR 50TrueFalseTrueTrue%s
Name12 VARCHAR 31TrueFalseTrueTrue%s
EntityType12 VARCHAR 23TrueFalseTrueFalse
Customer
Vendor
Employee
OtherName
Item
Account
EntityRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
EntityRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TxnType12 VARCHAR 23TrueFalseTrueFalse
Bill
BillPaymentCheck
BillPaymentCreditCard
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
VendorCredit
BuildAssembly
ARRefundCreditCard
TxnID12 VARCHAR 36TrueFalseTrueFalse%s
TxnLineID12 VARCHAR 36TrueFalseTrueFalse%s
OtherType12 VARCHAR 7TrueFalseTrueFalse
Company
Value12 VARCHAR 4095TrueFalseTrueTrue
TABLE DETAIL REFERENCE: DateDrivenTerms
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueFalseTrueTrue%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
DayOfMonthDue4 INTEGER 4TrueFalseTrueTrue%11.0f
DueNextMonthDays4 INTEGER 4TrueFalseTrueFalse%11.0f
DiscountDayOfMonth4 INTEGER 4TrueFalseTrueFalse%11.0f
DiscountPct3 DECIMAL 15TrueFalseTrueFalse%11.7f
TABLE DETAIL REFERENCE: Department
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueFalse%s
FullName12 VARCHAR 1000TrueTrueTrueFalse%s
SubDepartment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ParentRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
FullyQualifiedName12 VARCHAR 1000TrueTrueTrueFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: Deposit
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DocNumber12 VARCHAR 21TrueTrueTrueFalse%s
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueTrueTrueFalse%11.7f
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxInclusive
NotApplicable
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
TxnStatus12 VARCHAR 13TrueTrueTrueFalse
Draft
Overdue
Pending
Payable
Paid
Trash
Unpaid
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
CashBackAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CashBackAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CashBackAmount12 VARCHAR 21TrueTrueTrueFalse%s
CashBackMemo12 VARCHAR 21TrueTrueTrueFalse%s
TotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
HomeTotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
TABLE DETAIL REFERENCE: DepositAppliedToTxn
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DocNumber12 VARCHAR 21TrueFalseFalseFalse%s
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxInclusive
NotApplicable
PrivateNote12 VARCHAR 4000TrueFalseFalseFalse%s
TxnStatus12 VARCHAR 13TrueFalseFalseFalse
Draft
Overdue
Pending
Payable
Paid
Trash
Unpaid
DepositToAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
CashBackAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CashBackAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CashBackAmount12 VARCHAR 21TrueFalseFalseFalse%s
CashBackMemo12 VARCHAR 21TrueFalseFalseFalse%s
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
HomeTotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
DepositAppliedToTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
DepositAppliedToTxnTxnType12 VARCHAR 32TrueFalseFalseFalse
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
DepositAppliedToTxnTxnLineID12 VARCHAR 36TrueFalseFalseFalse%s
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: DepositAttachable
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DocNumber12 VARCHAR 21TrueFalseFalseFalse%s
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxInclusive
NotApplicable
PrivateNote12 VARCHAR 4000TrueFalseFalseFalse%s
TxnStatus12 VARCHAR 13TrueFalseFalseFalse
Draft
Overdue
Pending
Payable
Paid
Trash
Unpaid
DepositToAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
CashBackAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CashBackAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CashBackAmount12 VARCHAR 21TrueFalseFalseFalse%s
CashBackMemo12 VARCHAR 21TrueFalseFalseFalse%s
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
HomeTotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
AttachableRefListID12 VARCHAR 36TrueFalseFalseFalse%s
AttachableRefEntityRefListID12 VARCHAR 36TrueFalseFalseFalse%s
AttachableRefEntityRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
AttachableRefLineInfo12 VARCHAR 4000TrueFalseFalseFalse%s
AttachableRefIncludeOnSend-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AttachableRefInactive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AttachableRefNoRefOnly-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: DepositLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DocNumber12 VARCHAR 21TrueTrueTrueFalse%s
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueTrueTrueFalse%11.7f
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxInclusive
NotApplicable
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
TxnStatus12 VARCHAR 13TrueTrueTrueFalse
Draft
Overdue
Pending
Payable
Paid
Trash
Unpaid
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
CashBackAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CashBackAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CashBackAmount12 VARCHAR 21TrueTrueTrueFalse%s
CashBackMemo12 VARCHAR 21TrueTrueTrueFalse%s
TotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
HomeTotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
DepositLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
DepositLineLineNum4 INTEGER 4TrueTrueTrueFalse%s
DepositLineDescription12 VARCHAR 4000TrueTrueTrueFalse%s
DepositLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
DepositLineDetailType12 VARCHAR 64TrueTrueTrueFalse
DepositLineDetail
DepositLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
DepositLineDetailEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepositLineDetailClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepositLineDetailAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepositLineDetailPaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailPaymentMethodRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepositLineDetailCheckNum12 VARCHAR 4000TrueTrueTrueFalse%s
DepositLineDetailTxnType12 VARCHAR 32TrueTrueTrueFalse
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
DepositLineDetailTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositLineDetailTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
AppliedToTxnTxnID12 VARCHAR 36TrueTrueTrueFalse%s
AppliedToTxnTxnType12 VARCHAR 32TrueTrueTrueFalse
ARRefundCreditCard
Transfer
Cash
CreditCardCharge
CreditCardCredit
SalesReceipt
RefundReceipt
JournalEntry
BillPaymentCheck
Check
ReceivePayment
Payment
AppliedToTxnTxnLineID12 VARCHAR 36TrueTrueTrueFalse%s
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Employee
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Organization-7 BIT 1TrueTrueTrueFalse
1
0
true
false
Name12 VARCHAR 100TrueTrueTrueFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 25TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
Suffix12 VARCHAR 10TrueTrueTrueFalse%s
PrintAs12 VARCHAR 110TrueTrueTrueFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
Mobile12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 100TrueTrueTrueFalse%s
EmployeeNumber12 VARCHAR 100TrueTrueTrueFalse%s
SSN12 VARCHAR 100TrueTrueTrueFalse%s
EmployeeAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
EmployeeAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
EmployeeAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
EmployeeAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
EmployeeAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
EmployeeAddressState12 VARCHAR 255TrueTrueTrueFalse%s
EmployeeAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
EmployeeAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
BillableTime-7 BIT 1TrueTrueTrueFalse
1
0
true
false
BillRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
BirthDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Gender12 VARCHAR 100TrueTrueTrueFalse%s
HiredDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
ReleasedDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TABLE DETAIL REFERENCE: Entitlements
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 1000TrueFalseFalseFalse%s
Term-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: Entity
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 1000TrueFalseFalseFalse%s
FullName12 VARCHAR 1000TrueFalseFalseFalse%s
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ClassRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
ParentRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ParentRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 1000TrueFalseFalseFalse%s
Salutation12 VARCHAR 1000TrueFalseFalseFalse%s
FirstName12 VARCHAR 1000TrueFalseFalseFalse%s
MiddleName12 VARCHAR 1000TrueFalseFalseFalse%s
LastName12 VARCHAR 1000TrueFalseFalseFalse%s
JobTitle12 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressBlockAddr112 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressBlockAddr112 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressName12 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressAddr112 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressAddr212 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressAddr312 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressAddr412 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressAddr512 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressCity12 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressState12 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressPostalCode12 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressCountry12 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressNote12 VARCHAR 1000TrueFalseFalseFalse%s
ShipToAddressDefaultShipTo-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Phone12 VARCHAR 1000TrueFalseFalseFalse%s
AltPhone12 VARCHAR 1000TrueFalseFalseFalse%s
Fax12 VARCHAR 1000TrueFalseFalseFalse%s
Email12 VARCHAR 1000TrueFalseFalseFalse%s
Cc12 VARCHAR 1000TrueFalseFalseFalse%s
Contact12 VARCHAR 1000TrueFalseFalseFalse%s
AltContac12 VARCHAR 1000TrueFalseFalseFalse%s
AdditionalContactRefContactName12 VARCHAR 1000TrueFalseFalseFalse%s
AdditionalContactRefContactValue12 VARCHAR 1000TrueFalseFalseFalse%s
ContactsRetListID12 VARCHAR 36TrueFalseFalseFalse%s
ContactsRetTimeCreated11 TIMESTAMP 16TrueFalseFalseFalse%s
ContactsRetTimeModified11 TIMESTAMP 16TrueFalseFalseFalse%s
ContactsRetEditSequence12 VARCHAR 10TrueFalseFalseFalse%s
ContactsRetContact12 VARCHAR 1000TrueFalseFalseFalse%s
ContactsRetSalutation12 VARCHAR 1000TrueFalseFalseFalse%s
ContactsRetFirstName12 VARCHAR 1000TrueFalseFalseFalse%s
ContactsRetMiddleName12 VARCHAR 1000TrueFalseFalseFalse%s
ContactsRetLastName12 VARCHAR 1000TrueFalseFalseFalse%s
ContactsRetJobTitle12 VARCHAR 1000TrueFalseFalseFalse%s
ContactsRetAdditionalContactRefContactName12 VARCHAR 1000TrueFalseFalseFalse%s
ContactsRetAdditionalContactRefContactValue12 VARCHAR 1000TrueFalseFalseFalse%s
CustomerTypeRefListID12 VARCHAR 36TrueFalseFalseFalse%s
CustomerTypeRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s
TermsRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
SalesRepRefListID12 VARCHAR 36TrueFalseFalseFalse%s
SalesRepRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
Balance3 DECIMAL 15TrueFalseFalseFalse%11.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s
SalesTaxCodeRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
ItemSalesTaxRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ItemSalesTaxRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
ResaleNumber12 VARCHAR 16TrueFalseFalseFalse%s
PreferredPaymentMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s
PreferredPaymentMethodRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
PriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s
PriceLevelRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
Type12 VARCHAR 1000TrueFalseFalseTrue%s
TABLE DETAIL REFERENCE: Estimate
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
DocNumber12 VARCHAR 21TrueTrueTrueFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
TxnStatus12 VARCHAR 1000TrueFalseFalseFalse%s
CustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
CustomerMemo12 VARCHAR 1000TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 100TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipMethodRef12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ShipDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
ApplyTaxAfterDiscount-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PrintStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
PrintComplete
EmailStatus12 VARCHAR 13TrueTrueTrueFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueTrueTrueFalse%s
ExpirationDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AcceptedBy12 VARCHAR 1000TrueFalseFalseFalse%s Yes
AcceptedDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
SalesTaxLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: EstimateLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
DocNumber12 VARCHAR 21TrueTrueTrueFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
TxnStatus12 VARCHAR 1000TrueFalseFalseFalse%s
CustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
CustomerMemo12 VARCHAR 1000TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 100TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipMethodRef12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ShipDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
ApplyTaxAfterDiscount-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PrintStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
PrintComplete
EmailStatus12 VARCHAR 13TrueTrueTrueFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueTrueTrueFalse%s
ExpirationDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AcceptedBy12 VARCHAR 1000TrueFalseFalseFalse%s Yes
AcceptedDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
EstimateLineType12 VARCHAR 11TrueFalseFalseFalseItemType
EstimateLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
EstimateLineGroupTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
EstimateLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
EstimateLineGroupItemGroupRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
EstimateLineGroupDesc12 VARCHAR 4095TrueFalseFalseFalse%s
EstimateLineGroupQuantity3 DECIMAL 16TrueTrueTrueFalse%10.7f
EstimateLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
EstimateLineGroupTotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
EstimateLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
EstimateLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
EstimateLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
EstimateLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
EstimateLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
EstimateLineQuantity3 DECIMAL 16TrueTrueTrueFalse%10.7f
EstimateLineUnitOfMeasure12 VARCHAR 100TrueTrueTrueFalse%s Yes
EstimateLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
EstimateLineOverrideUOMSetRefFullName12 VARCHAR 1000TrueTrueFalseFalse%s Yes
EstimateLineRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
EstimateLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%10.7f
EstimateLinePriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
EstimateLinePriceLevelRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
EstimateLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
EstimateLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
EstimateLineInventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
EstimateLineInventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
EstimateLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
EstimateLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
EstimateLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
EstimateLineSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
EstimateLineSalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
EstimateLineMarkupRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
EstimateLineMarkupRatePercent3 DECIMAL 15TrueTrueTrueFalse%10.7f
EstimateLineOverrideItemAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
EstimateLineOverrideItemAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
EstimateLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
EstimateLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CustomFieldEstimateLineOther112 VARCHAR 29TrueTrueTrueFalse%s
CustomFieldEstimateLineOther212 VARCHAR 29TrueTrueTrueFalse%s
SalesTaxLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: EstimateLinkedTxn
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
DocNumber12 VARCHAR 21TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
PrivateNote12 VARCHAR 4000TrueFalseFalseFalse%s
TxnStatus12 VARCHAR 1000TrueFalseFalseFalse%s
CustomerRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
CustomerMemo12 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressProvince12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressCounty12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 100TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
ShipMethodRef12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ShipDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxIncluded
NotApplicable
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
ApplyTaxAfterDiscount-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PrintStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
PrintComplete
EmailStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueFalseFalseFalse%s
ExpirationDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AcceptedBy12 VARCHAR 1000TrueFalseFalseFalse%s Yes
AcceptedDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
LinkedTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
LinkedTxnTxnType12 VARCHAR 21TrueFalseFalseFalse
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
LinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnRefNumber12 VARCHAR 21TrueFalseFalseFalse%s
LinkedTxnLinkType12 VARCHAR 11TrueFalseFalseFalse
AMTTYPE
QUANTYPE
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: ExchangeRate
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
SourceCurrencyCode12 VARCHAR 100TrueFalseTrueFalse%s
TargetCurrencyCode12 VARCHAR 1000TrueFalseTrueFalse%s
Rate3 DECIMAL 18TrueFalseFalseFalse%11.7f
AsOfDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TABLE DETAIL REFERENCE: ExchangeRateAttachable
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
SourceCurrencyCode12 VARCHAR 100TrueFalseTrueFalse%s
TargetCurrencyCode12 VARCHAR 1000TrueFalseTrueFalse%s
Rate3 DECIMAL 18TrueFalseFalseFalse%11.7f
AsOfDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
AttachableRefListID12 VARCHAR 36TrueFalseFalseFalse%s
AttachableRefEntityRefListID12 VARCHAR 36TrueFalseTrueFalse%s
AttachableRefEntityRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s
AttachableRefLineInfo12 VARCHAR 4000TrueFalseTrueFalse%s
AttachableRefIncludeOnSend-7 BIT 1TrueFalseTrueFalse
1
0
true
false
AttachableRefInactive-7 BIT 1TrueFalseTrueFalse
1
0
true
false
AttachableRefNoRefOnly-7 BIT 1TrueFalseTrueFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Host
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ID4 INTEGER 4TrueFalseFalseFalseFQID
ProductName12 VARCHAR 255TrueFalseFalseFalse%s
MajorVersion12 VARCHAR 5TrueFalseFalseFalse%s
MinorVersion12 VARCHAR 5TrueFalseFalseFalse%s
QODBCMajorVersion12 VARCHAR 5TrueFalseFalseFalseQODBCMajorVersion
QODBCMinorVersion12 VARCHAR 5TrueFalseFalseFalseQODBCMinorVersion
QODBCBuildNumber12 VARCHAR 5TrueFalseFalseFalseQODBCBuildNumber
QODBCRegion12 VARCHAR 5TrueFalseFalseFalseQODBCRegion
QODBCSerialNo12 VARCHAR 12TrueFalseFalseFalseQODBCSerialNo
QODBCEdition12 VARCHAR 50TrueFalseFalseFalseQODBCEdition
QODBCEditionQBES12 VARCHAR 50TrueFalseFalseFalseQODBCEditionQBES
QODBCEditionRunning12 VARCHAR 50TrueFalseFalseFalseQODBCEditionRunning
TABLE DETAIL REFERENCE: HostSupportedVersions
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ID4 INTEGER 4TrueFalseFalseFalseFQID Yes
ProductName12 VARCHAR 255TrueFalseFalseFalse%s
MajorVersion12 VARCHAR 5TrueFalseFalseFalse%s
MinorVersion12 VARCHAR 5TrueFalseFalseFalse%s
SupportedQBXMLVersion12 VARCHAR 10TrueFalseFalseFalse%s
QODBCMajorVersion12 VARCHAR 5TrueFalseFalseFalseQODBCMajorVersion
QODBCMinorVersion12 VARCHAR 5TrueFalseFalseFalseQODBCMinorVersion
QODBCBuildNumber12 VARCHAR 5TrueFalseFalseFalseQODBCBuildNumber
QODBCRegion12 VARCHAR 5TrueFalseFalseFalseQODBCRegion
QODBCSerialNo12 VARCHAR 12TrueFalseFalseFalseQODBCSerialNo
QODBCEdition12 VARCHAR 50TrueFalseFalseFalseQODBCEdition
QODBCEditionQBES12 VARCHAR 50TrueFalseFalseFalseQODBCEditionQBES
QODBCEditionRunning12 VARCHAR 50TrueFalseFalseFalseQODBCEditionRunning
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Invoice
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
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
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
BillEmailBccAddress12 VARCHAR 1000TrueTrueTrueFalse%s
BillEmailCcAddress12 VARCHAR 1000TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Subtotal3 DECIMAL 15TrueTrueFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
AppliedAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
EmailStatus12 VARCHAR 13TrueTrueTrueFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueTrueTrueFalse%s
HomeBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
TaxRateRefName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TaxRateRefType12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TaxRateRefValue12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
TaxLineDetailPercentBase-7 BIT 1FalseTrueTrueFalse
1
0
true
false
TaxLineDetailTaxPercent3 DECIMAL 15FalseTrueTrueFalse%10.7f
TaxLineDetailNetAmountTaxable3 DECIMAL 15FalseTrueTrueFalse%7.5f
DiscountLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%11.7f
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ShippingLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
ShippingLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
ShippingLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: InvoiceLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
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
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
BillEmailBccAddress12 VARCHAR 1000TrueTrueTrueFalse%s
BillEmailCcAddress12 VARCHAR 1000TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Subtotal3 DECIMAL 15TrueTrueFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
AppliedAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
EmailStatus12 VARCHAR 13TrueTrueTrueFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueTrueTrueFalse%s
HomeBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
TaxRateRefName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TaxRateRefType12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TaxRateRefValue12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
TaxLineDetailPercentBase-7 BIT 1FalseTrueTrueFalse
1
0
true
false
TaxLineDetailTaxPercent3 DECIMAL 15FalseTrueTrueFalse%10.7f
TaxLineDetailNetAmountTaxable3 DECIMAL 15FalseTrueTrueFalse%7.5f
InvoiceLineType12 VARCHAR 11TrueFalseTrueFalseItemType
InvoiceLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
InvoiceLineGroupTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
InvoiceLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineGroupItemGroupRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
InvoiceLineGroupDesc12 VARCHAR 4000TrueFalseTrueFalse%s
InvoiceLineGroupQuantity3 DECIMAL 16TrueTrueTrueFalse%8.5f
InvoiceLineGroupAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
InvoiceLineGroupTotalAmount3 DECIMAL 13TrueFalseFalseFalse%8.2f
InvoiceLineGroupServiceDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
InvoiceLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
InvoiceLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
InvoiceLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineItemRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
InvoiceLineDesc12 VARCHAR 4000TrueTrueTrueFalse%s
InvoiceLineQuantity3 DECIMAL 16TrueTrueTrueFalse%10.7f
InvoiceLineRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
InvoiceLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%10.7f
InvoiceLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
InvoiceLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
InvoiceLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
InvoiceLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
InvoiceLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
InvoiceLineTaxCodeRefType12 VARCHAR 1000TrueTrueTrueFalse%s Yes
InvoiceLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DiscountLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%11.7f
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ShippingLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
ShippingLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
ShippingLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: InvoiceLinkedTxn
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueFalseFalseTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
ARAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ARAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
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
RefNumber12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
BillEmailBccAddress12 VARCHAR 1000TrueFalseFalseFalse%s
BillEmailCcAddress12 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 255TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 255TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
ShipDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
Subtotal3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
AppliedAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueFalseFalseFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsToBePrinted-7 BIT 1TrueFalseFalseFalse
1
0
true
false
EmailStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueFalseFalseFalse%s
HomeBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
TaxRateRefName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TaxRateRefType12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TaxRateRefValue12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxIncluded
NotApplicable
TaxLineDetailPercentBase-7 BIT 1FalseFalseFalseFalse
1
0
true
false
TaxLineDetailTaxPercent3 DECIMAL 15FalseFalseFalseFalse%10.7f
TaxLineDetailNetAmountTaxable3 DECIMAL 15FalseFalseFalseFalse%7.5f
LinkedTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
LinkedTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
LinkedTxnTxnType12 VARCHAR 21TrueFalseFalseFalse
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
LinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnRefNumber12 VARCHAR 21TrueFalseFalseFalse%s
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
DiscountLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueFalseFalseFalse%11.7f
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ShippingLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
ShippingLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ShippingLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: ItemGroup
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueFalseFalseFalse%s
FullName12 VARCHAR 1000TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Sku12 VARCHAR 100TrueFalseFalseFalse%s
Type12 VARCHAR 1000TrueFalseFalseFalse%s
ItemDesc12 VARCHAR 4000TrueFalseFalseFalse%s
IsTaxable-7 BIT 1TrueFalseFalseFalse
1
0
true
false
UnitPrice3 DECIMAL 18TrueFalseFalseFalse%10.7f
PurchaseCost3 DECIMAL 15TrueFalseFalseFalse%10.6f
IsPrintGroupedItems-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: ItemGroupLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueFalseFalseFalse%s
FullName12 VARCHAR 1000TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Sku12 VARCHAR 100TrueFalseFalseFalse%s
Type12 VARCHAR 1000TrueFalseFalseFalse%s
ItemDesc12 VARCHAR 4000TrueFalseFalseFalse%s
IsTaxable-7 BIT 1TrueFalseFalseFalse
1
0
true
false
UnitPrice3 DECIMAL 18TrueFalseFalseFalse%10.7f
PurchaseCost3 DECIMAL 15TrueFalseFalseFalse%10.6f
IsPrintGroupedItems-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemGroupLineSeqNo12 VARCHAR 36TrueFalseFalseFalse%s
ItemGroupLineItemRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ItemGroupLineItemRefFullName12 VARCHAR 36TrueFalseFalseFalse%s
ItemGroupLineQuantity3 DECIMAL 15TrueFalseFalseFalse%10.7f
ItemGroupLineItemType12 VARCHAR 36TrueFalseFalseFalse%s
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: ItemService
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueTrue%s
FullName12 VARCHAR 1000TrueFalseFalseFalse%s
Sku12 VARCHAR 100TrueTrueTrueTrue%s
Description12 VARCHAR 4000TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
SubItem-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
Taxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
UnitPrice3 DECIMAL 18TrueTrueTrueFalse%10.7f
RatePercent3 DECIMAL 15TrueFalseTrueFalse%7.6f
Type12 VARCHAR 1000TrueTrueTrueTrue%s
ItemCategoryType12 VARCHAR 14TrueFalseFalseTrue
Product
Service
IncomeAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
IncomeAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
PurchaseDesc12 VARCHAR 1000TrueTrueTrueTrue%s
PurchaseTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PurchaseCost3 DECIMAL 15TrueTrueTrueFalse%10.6f
ExpenseAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
AssetAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
AssetAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TrackQtyOnHand-7 BIT 1TrueTrueTrueFalse
1
0
true
false
QtyOnHand3 DECIMAL 16TrueTrueTrueFalse%10.7f
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
PurchaseTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
InvStartDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesOrPurchaseDesc12 VARCHAR 4000TrueTrueTrueFalse%s
SalesOrPurchasePrice3 DECIMAL 16TrueTrueTrueTrue%10.7f
SalesOrPurchasePricePercent3 DECIMAL 15TrueTrueTrueTrue%10.7f
AbatementRate3 DECIMAL 18TrueTrueTrueFalse%11.7f
ReverseChargeRate3 DECIMAL 18TrueTrueTrueFalse%11.7f
ServiceType12 VARCHAR 32TrueTrueTrueTrueADVT
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 1FalseTrueFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: JournalCode
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueFalse%s
Type12 VARCHAR 1000TrueTrueTrueFalse%s
Description12 VARCHAR 100TrueTrueTrueFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: JournalCodeAttachable
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueFalse%s
Type12 VARCHAR 1000TrueTrueTrueFalse%s
Description12 VARCHAR 100TrueTrueTrueFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
AttachableRefListID12 VARCHAR 36TrueTrueFalseFalse%s
AttachableRefEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s
AttachableRefEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
AttachableRefLineInfo12 VARCHAR 4000TrueTrueTrueFalse%s
AttachableRefIncludeOnSend-7 BIT 1TrueTrueTrueFalse
1
0
true
false
AttachableRefInactive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
AttachableRefNoRefOnly-7 BIT 1TrueTrueTrueFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: JournalEntry
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
IsAdjustment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsHomeCurrencyAdjustment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsAmountsEnteredInHomeCurrency-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
TotalAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
HomeTotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TransactionLocationType12 VARCHAR 32TrueTrueTrueFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU
TABLE DETAIL REFERENCE: JournalEntryCreditLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
IsAdjustment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsHomeCurrencyAdjustment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsAmountsEnteredInHomeCurrency-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
TotalAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
HomeTotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TransactionLocationType12 VARCHAR 32TrueTrueTrueFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU
JournalCreditLineTxnLineID12 VARCHAR 36TrueTrueTrueFalse%s
JournalCreditLineType12 VARCHAR 14TrueTrueFalseFalse
Debit
Credit
JournalCreditLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalCreditLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
JournalCreditLineMemo12 VARCHAR 4000TrueTrueTrueFalse%s
JournalCreditLineEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalCreditLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalCreditLineDepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineDepartmentRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
JournalCreditLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalCreditLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalCreditLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
FQTransactionLinkKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: JournalEntryDebitLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
IsAdjustment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsHomeCurrencyAdjustment-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsAmountsEnteredInHomeCurrency-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
TotalAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
HomeTotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TransactionLocationType12 VARCHAR 32TrueTrueTrueFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU
JournalDebitLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
JournalDebitLineType12 VARCHAR 14TrueTrueFalseFalse
Debit
Credit
JournalDebitLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalDebitLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalDebitLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
JournalDebitLineMemo12 VARCHAR 4000TrueTrueTrueFalse%s
JournalDebitLineEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalDebitLineEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalDebitLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalDebitLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalDebitLineDepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalDebitLineDepartmentRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
JournalDebitLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JournalDebitLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
JournalDebitLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
FQTransactionLinkKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: JournalEntryLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
IsAdjustment-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsHomeCurrencyAdjustment-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsAmountsEnteredInHomeCurrency-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueFalseFalseFalse%s
Memo12 VARCHAR 4000TrueFalseFalseFalse%s
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
HomeTotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TransactionLocationType12 VARCHAR 32TrueFalseFalseFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU
JournalLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
JournalLineType12 VARCHAR 25TrueFalseFalseFalse%s
JournalLineTxnLineID12 VARCHAR 36TrueFalseFalseFalse%s
JournalLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
JournalLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
JournalLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
JournalLineCreditAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
JournalLineDebitAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
JournalLineMemo12 VARCHAR 4000TrueFalseFalseFalse%s
JournalLineEntityRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
JournalLineEntityRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
JournalLineClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
JournalLineClassRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
JournalLineDepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
JournalLineDepartmentRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
JournalLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
JournalLineTaxCodeRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
JournalLineBillableStatus12 VARCHAR 13TrueFalseFalseFalse
Billable
NotBillable
HasBeenBilled
FQTransactionLinkKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: ListDeleted
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListDelType12 VARCHAR 20TrueFalseFalseFalse
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
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeDeleted11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
FullName12 VARCHAR 41TrueFalseFalseFalse%s
TABLE DETAIL REFERENCE: Payment
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
TxnStatus12 VARCHAR 1000TrueTrueTrueFalse%s
CustomerRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
CustomerRefFullName12 VARCHAR 100TrueFalseTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
PaymentRefNum12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditCardPaymentCCAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditCardPaymentCCDetailNumber12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCcExpiryMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailBillAddrStreet12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPostalCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCommercialCardCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnMode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPrevCCTransId12 VARCHAR 1000TrueTrueTrueFalse%s
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
UnappliedAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyReffullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
TABLE DETAIL REFERENCE: PaymentAppliedToTxn
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
PrivateNote12 VARCHAR 4000TrueFalseFalseFalse%s
TxnStatus12 VARCHAR 1000TrueFalseFalseFalse%s
CustomerRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ARAccountRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
DepositToAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
PaymentMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
PaymentRefNum12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CreditCardPaymentCCAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CreditCardPaymentCCDetailNumber12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailType12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailNameOnAcct12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailCcExpiryMonth4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardPaymentCCDetailBillAddrStreet12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailPostalCode12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailCommercialCardCode12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailCCTxnMode12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailCCTxnType12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailPrevCCTransId12 VARCHAR 1000TrueFalseFalseFalse%s
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
UnappliedAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyReffullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
PaymentAppliedToTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
PaymentAppliedToTxnTxnType12 VARCHAR 1000TrueFalseFalseFalse%s
PaymentAppliedToTxnTxnLineID12 VARCHAR 36TrueFalseFalseFalse%s
PaymentAppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
PaymentAppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
PaymentAppliedToTxnBalanceRemaining3 DECIMAL 13TrueFalseFalseFalse%11.2f
PaymentAppliedToTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
PaymentAppliedToTxnDiscountAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: PaymentLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
TxnStatus12 VARCHAR 1000TrueTrueTrueFalse%s
CustomerRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
CustomerRefFullName12 VARCHAR 100TrueFalseTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
PaymentRefNum12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditCardPaymentCCAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditCardPaymentCCDetailNumber12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCcExpiryMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailBillAddrStreet12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPostalCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCommercialCardCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnMode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPrevCCTransId12 VARCHAR 1000TrueTrueTrueFalse%s
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
UnappliedAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyReffullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PaymentLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
PaymentLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: PaymentMethod
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: Preferences
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
AccountingInfoPrefsTrackDepartments-7 BIT 1TrueFalseFalseFalse
1
0
true
false