TABLE DETAIL REFERENCE: Account
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueTrueTrueTrue%s
FullName12 VARCHAR 159TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 159TrueTrueTrueFalse%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
SpecialAccountType12 VARCHAR 30TrueFalseFalseFalse
AccountsPayable
AccountsReceivable
CondenseItemAdjustmentExpenses
CostOfGoodsSold
DirectDepositLiabilities
Estimates
InventoryAssets
OpeningBalanceEquity
PayrollExpenses
PayrollLiabilities
PettyCash
PurchaseOrders
ReconciliationDifferences
RetainedEarnings
SalesOrders
SalesTaxPayable
UncategorizedExpenses
UncategorizedIncome
UndepositedFunds
IsTaxAccount-7 BIT 1TrueTrueTrueFalse
1
0
true
false
AccountNumber12 VARCHAR 7TrueTrueTrueFalse%s
BankNumber12 VARCHAR 25TrueTrueTrueFalse%s
Desc12 VARCHAR 200TrueTrueTrueFalse%s
Balance3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenBalance3 DECIMAL 15TrueTrueTrueFalse%10.2f
OpenBalanceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxLineInfoRetTaxLineID4 INTEGER 4TrueFalseFalseFalse%11.0f Yes
TaxLineInfoRetTaxLineName12 VARCHAR 256TrueFalseFalseFalse%s Yes
CashFlowClassification12 VARCHAR 13TrueFalseFalseFalse
None
Operating
Investing
Financing
NotApplicable
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
TABLE DETAIL REFERENCE: AccountTaxLineInfo
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TaxLineID4 INTEGER 4TrueFalseFalseFalse%11.0f
TaxLineName12 VARCHAR 256TrueFalseFalseFalse%s
TABLE DETAIL REFERENCE: ARRefundCreditCard
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseTrueTrue%s Yes
RefundFromAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
RefundFromAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-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 11TrueFalseTrueFalse%s
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AddressAddr112 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr212 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr312 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr412 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr512 VARCHAR 41TrueFalseTrueFalse%s
AddressCity12 VARCHAR 31TrueFalseTrueFalse%s
AddressState12 VARCHAR 21TrueFalseTrueFalse%s
AddressProvince12 VARCHAR 21TrueFalseTrueFalse%s
AddressCounty12 VARCHAR 21TrueFalseTrueFalse%s
AddressPostalCode12 VARCHAR 13TrueFalseTrueFalse%s
AddressCountry12 VARCHAR 31TrueFalseTrueFalse%s
AddressNote12 VARCHAR 41TrueFalseTrueFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
PaymentMethodRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 31TrueFalseTrueFalse%s Yes
Memo12 VARCHAR 4095TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardNumber12 VARCHAR 25TrueFalseTrueFalse%s
CreditCardTxnInfoInputExpirationMonth4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoInputExpirationYear4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoInputNameOnCard12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardAddress12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardPostalCode12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCommercialCardCode12 VARCHAR 50TrueFalseTrueFalse%s
CreditCardTxnInfoInputTransactionMode12 VARCHAR 14TrueFalseTrueFalse
CardNotPresent
CardPresent
CreditCardTxnInfoInputCreditCardTxnType12 VARCHAR 18TrueFalseTrueFalse
Authorization
Capture
Charge
Refund
VoiceAuthorization
CreditCardTxnInfoResultResultCode4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultResultMessage12 VARCHAR 500TrueFalseTrueFalse%s
CreditCardTxnInfoResultCreditCardTransID12 VARCHAR 24TrueFalseTrueFalse%s
CreditCardTxnInfoResultMerchantAccountNumber12 VARCHAR 32TrueFalseTrueFalse%s
CreditCardTxnInfoResultAuthorizationCode12 VARCHAR 12TrueFalseTrueFalse%s
CreditCardTxnInfoResultAVSStreet12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultAVSZip12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultCardSecurityCodeMatch12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultReconBatchID12 VARCHAR 84TrueFalseTrueFalse%s
CreditCardTxnInfoResultPaymentGroupingCode4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultPaymentStatus12 VARCHAR 9TrueFalseTrueFalse
Unknown
Completed
CreditCardTxnInfoResultTxnAuthorizationTime11 TIMESTAMP 16TrueFalseTrueFalseCCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultClientTransID12 VARCHAR 16TrueFalseTrueFalse%s
TABLE DETAIL REFERENCE: ARRefundCreditCardRefundAppliedTo
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseTrueTrue%s Yes
RefundFromAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
RefundFromAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-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 11TrueFalseTrueFalse%s
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AddressAddr112 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr212 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr312 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr412 VARCHAR 41TrueFalseTrueFalse%s
AddressAddr512 VARCHAR 41TrueFalseTrueFalse%s
AddressCity12 VARCHAR 31TrueFalseTrueFalse%s
AddressState12 VARCHAR 21TrueFalseTrueFalse%s
AddressProvince12 VARCHAR 21TrueFalseTrueFalse%s
AddressCounty12 VARCHAR 21TrueFalseTrueFalse%s
AddressPostalCode12 VARCHAR 13TrueFalseTrueFalse%s
AddressCountry12 VARCHAR 31TrueFalseTrueFalse%s
AddressNote12 VARCHAR 41TrueFalseTrueFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
PaymentMethodRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 31TrueFalseTrueFalse%s Yes
Memo12 VARCHAR 4095TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardNumber12 VARCHAR 25TrueFalseTrueFalse%s
CreditCardTxnInfoInputExpirationMonth4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoInputExpirationYear4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoInputNameOnCard12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardAddress12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCreditCardPostalCode12 VARCHAR 41TrueFalseTrueFalse%s
CreditCardTxnInfoInputCommercialCardCode12 VARCHAR 50TrueFalseTrueFalse%s
CreditCardTxnInfoInputTransactionMode12 VARCHAR 14TrueFalseTrueFalse
CardNotPresent
CardPresent
CreditCardTxnInfoInputCreditCardTxnType12 VARCHAR 18TrueFalseTrueFalse
Authorization
Capture
Charge
Refund
VoiceAuthorization
CreditCardTxnInfoResultResultCode4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultResultMessage12 VARCHAR 500TrueFalseTrueFalse%s
CreditCardTxnInfoResultCreditCardTransID12 VARCHAR 24TrueFalseTrueFalse%s
CreditCardTxnInfoResultMerchantAccountNumber12 VARCHAR 32TrueFalseTrueFalse%s
CreditCardTxnInfoResultAuthorizationCode12 VARCHAR 12TrueFalseTrueFalse%s
CreditCardTxnInfoResultAVSStreet12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultAVSZip12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultCardSecurityCodeMatch12 VARCHAR 12TrueFalseTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultReconBatchID12 VARCHAR 84TrueFalseTrueFalse%s
CreditCardTxnInfoResultPaymentGroupingCode4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultPaymentStatus12 VARCHAR 9TrueFalseTrueFalse
Unknown
Completed
CreditCardTxnInfoResultTxnAuthorizationTime11 TIMESTAMP 16TrueFalseTrueFalseCCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp4 INTEGER 4TrueFalseTrueFalse%11.0f
CreditCardTxnInfoResultClientTransID12 VARCHAR 16TrueFalseTrueFalse%s
RefundAppliedToTxnTxnID12 VARCHAR 36TrueFalseTrueTrue%s
RefundAppliedToTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
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
RefundAppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
RefundAppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
RefundAppliedToTxnRefCreditRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefundAppliedToTxnRefRefundAmount3 DECIMAL 15TrueFalseTrueFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BarCode
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
FullName12 VARCHAR 50TrueFalseFalseFalse%s
TABLE DETAIL REFERENCE: Bill
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VendorRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
VendorRefFullName12 VARCHAR 41TrueTrueTrueTrue%s Yes
VendorAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
VendorAddressState12 VARCHAR 21TrueTrueTrueFalse%s
VendorAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%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
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
AmountDue3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountDueInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 20TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
LinkToTxnID112 VARCHAR 36TrueFalseTrueFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: BillExpenseLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VendorRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
VendorRefFullName12 VARCHAR 41TrueTrueTrueTrue%s Yes
VendorAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
VendorAddressState12 VARCHAR 21TrueTrueTrueFalse%s
VendorAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%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
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
AmountDue3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountDueInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 20TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
LinkToTxnID112 VARCHAR 36TrueFalseTrueFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ExpenseLineClearExpenseLines-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ExpenseLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ExpenseLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ExpenseLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ExpenseLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ExpenseLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExpenseLineTax1Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExpenseLineMemo12 VARCHAR 4095TrueTrueTrueFalse%s
ExpenseLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ExpenseLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ExpenseLineSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillingRate
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueFalseTrueTrue%s
BillingRateType12 VARCHAR 9TrueFalseTrueFalse
FixedRate
PerItem
FixedBillingRate3 DECIMAL 18TrueFalseTrueFalse%10.5f
TABLE DETAIL REFERENCE: BillingRateLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueFalseTrueTrue%s
BillingRateType12 VARCHAR 9TrueFalseTrueFalse
FixedRate
PerItem
FixedBillingRate3 DECIMAL 18TrueFalseTrueFalse%10.5f
BillingRateLineItemRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
BillingRateLineItemRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
BillingRateLineCustomRate3 DECIMAL 18TrueFalseTrueFalse%10.5f
BillingRateLineCustomRatePercent3 DECIMAL 18TrueFalseTrueFalse%10.5f
BillingRateLineAdjustPercentage3 DECIMAL 18TrueFalseTrueFalse%10.5f
BillingRateLineAdjustBillingRateRelativeTo12 VARCHAR 9TrueFalseTrueFalse
StandardRate
CurrentCustomRate
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillItemLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VendorRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
VendorRefFullName12 VARCHAR 41TrueTrueTrueTrue%s Yes
VendorAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
VendorAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
VendorAddressState12 VARCHAR 21TrueTrueTrueFalse%s
VendorAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%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
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
AmountDue3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountDueInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 20TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
LinkToTxnID112 VARCHAR 36TrueFalseTrueFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemLineType12 VARCHAR 11TrueFalseFalseFalseItemType
ItemLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ItemGroupLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ItemGroupLineItemGroupRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ItemGroupLineItemGroupRefFullName12 VARCHAR 31TrueTrueTrueTrue%s Yes
ItemGroupLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemGroupUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemGroupOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ItemGroupOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ItemGroupLineTotalAmount3 DECIMAL 18TrueFalseFalseFalse%10.5f
ItemGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
ItemLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ItemLineItemRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ItemLineItemRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
ItemLineInventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineInventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
ItemLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ItemLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ItemLineCost3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ItemLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemLineTax1Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ItemLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ItemLineSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemLineSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemLineTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ItemLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ItemLineLinkToTxnTxnID12 VARCHAR 36TrueFalseTrueFalse%s
ItemLineLinkToTxnTxnLineID12 VARCHAR 36TrueFalseTrueFalse%s
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueTrueFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillLinkedTxn
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VendorRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
VendorRefFullName12 VARCHAR 41TrueFalseFalseTrue%s Yes
VendorAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
VendorAddressState12 VARCHAR 21TrueFalseFalseFalse%s
VendorAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
APAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%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
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AmountDue3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.6f
AmountDueInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 20TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
Memo12 VARCHAR 4095TrueFalseFalseFalse%s
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
LinkToTxnID112 VARCHAR 36TrueFalseFalseFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
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 20TrueFalseFalseFalse%s
LinkedTxnLinkType12 VARCHAR 8TrueFalseFalseFalse
AMTTYPE
QUANTYPE
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillPaymentCheck
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
PayeeEntityRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueFalseTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%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
BankAccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
BankAccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
Amount3 DECIMAL 15TrueTrueFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
ExchangeRate3 DECIMAL 15TrueTrueFalseFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueTrueFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueTrueTrueTrue%s
IsToBePrinted-7 BIT 1TrueTrueTrueTrue
1
0
true
false
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
AddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
AddressCity12 VARCHAR 31TrueFalseFalseFalse%s
AddressState12 VARCHAR 21TrueFalseFalseFalse%s
AddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
AddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
AddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
AddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
AddressNote12 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
TABLE DETAIL REFERENCE: BillPaymentCheckLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
PayeeEntityRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueFalseTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%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
BankAccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
BankAccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
Amount3 DECIMAL 15TrueTrueFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
ExchangeRate3 DECIMAL 15TrueTrueFalseFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueTrueFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueTrueTrueTrue%s
IsToBePrinted-7 BIT 1TrueTrueTrueTrue
1
0
true
false
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
AddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
AddressCity12 VARCHAR 31TrueFalseFalseFalse%s
AddressState12 VARCHAR 21TrueFalseFalseFalse%s
AddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
AddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
AddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
AddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
AddressNote12 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
AppliedToTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
AppliedToTxnTxnID12 VARCHAR 36TrueTrueTrueTrue%s
AppliedToTxnPaymentAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
AppliedToTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
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
AppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnBalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnSetCreditCreditTxnID12 VARCHAR 36TrueTrueTrueFalse%s
AppliedToTxnSetCreditAppliedAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
AppliedToTxnDiscountAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
AppliedToTxnDiscountAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
AppliedToTxnDiscountAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
AppliedToTxnDiscountClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
AppliedToTxnDiscountClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillPaymentCheckLineLinkedTxn
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
PayeeEntityRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueFalseFalseTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%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
BankAccountRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
BankAccountRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueFalseFalseTrue%s
IsToBePrinted-7 BIT 1TrueFalseFalseTrue
1
0
true
false
Memo12 VARCHAR 4095TrueFalseFalseFalse%s
AddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
AddressCity12 VARCHAR 31TrueFalseFalseFalse%s
AddressState12 VARCHAR 21TrueFalseFalseFalse%s
AddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
AddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
AddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
AddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
AddressNote12 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
AppliedToTxnLinkedTxnTxnID12 VARCHAR 36TrueFalseFalseTrue%s
AppliedToTxnLinkedTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
ARRefundCreditCard
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
AppliedToTxnLinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnLinkedTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnLinkedTxnLinkType12 VARCHAR 14TrueFalseFalseFalse
AMTTYPE
QUANTYPE
AppliedToTxnLinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillPaymentCreditCard
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
PayeeEntityRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueFalseTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-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
CreditCardAccountRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
CreditCardAccountRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueFalseTrueTrue%s
Memo12 VARCHAR 4095TrueFalseTrueFalse%s
TABLE DETAIL REFERENCE: BillPaymentCreditCardLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
PayeeEntityRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueFalseTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-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
CreditCardAccountRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
CreditCardAccountRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueFalseTrueTrue%s
Memo12 VARCHAR 4095TrueFalseTrueFalse%s
AppliedToTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
AppliedToTxnTxnID12 VARCHAR 36TrueFalseTrueTrue%s
AppliedToTxnPaymentAmount3 DECIMAL 15TrueFalseTrueFalse%10.2f
AppliedToTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
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
AppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnBalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnSetCreditCreditTxnID12 VARCHAR 36TrueFalseTrueFalse%s
AppliedToTxnSetCreditAppliedAmount3 DECIMAL 15TrueFalseTrueFalse%10.2f
AppliedToTxnDiscountAmount3 DECIMAL 15TrueFalseTrueFalse%10.2f
AppliedToTxnDiscountAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
AppliedToTxnDiscountAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
AppliedToTxnDiscountClassRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
AppliedToTxnDiscountClassRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillPaymentCreditCardLineLinkedTxn
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
PayeeEntityRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueFalseTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-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
CreditCardAccountRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
CreditCardAccountRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueFalseTrueTrue%s
Memo12 VARCHAR 4095TrueFalseTrueFalse%s
AppliedToTxnLinkedTxnTxnID12 VARCHAR 36TrueFalseFalseTrue%s
AppliedToTxnLinkedTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
ARRefundCreditCard
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
AppliedToTxnLinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnLinkedTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnLinkedTxnLinkType12 VARCHAR 14TrueFalseFalseFalse
AMTTYPE
QUANTYPE
AppliedToTxnLinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BillToPay
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
PayeeEntityRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
DueDateCutoff9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
BillToPayTxnID12 VARCHAR 36TrueFalseFalseFalse%s
BillToPayTxnType12 VARCHAR 14TrueFalseFalseFalse
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
BillToPayTxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
BillToPayAPAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
BillToPayAPAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
BillToPayTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
BillToPayRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
BillToPayDueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
BillToPayAmountDue3 DECIMAL 15TrueFalseFalseFalse%10.2f
BillToPayCurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
BillToPayCurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
BillToPayExchangeRate3 DECIMAL 18TrueFalseFalseFalse%6.6f
BillToPayAmountDueInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
CreditToApplyTxnID12 VARCHAR 36TrueFalseFalseFalse%s
CreditToApplyTxnType12 VARCHAR 14TrueFalseFalseFalse
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
CreditToApplyTxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditToApplyAPAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CreditToApplyAPAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
CreditToApplyTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
CreditToApplyRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
CreditToApplyCreditRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: BuildAssembly
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
ItemInventoryAssemblyRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
ItemInventoryAssemblyRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
InventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
InventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
LotNumber12 VARCHAR 40TrueTrueTrueFalse%s
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 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsPending-7 BIT 1TrueFalseFalseFalse
1
0
true
false
QuantityToBuild3 DECIMAL 18TrueTrueTrueTrue%10.5f
QuantityCanBuild3 DECIMAL 18TrueFalseFalseFalse%10.5f
QuantityOnHand3 DECIMAL 18TrueFalseFalseFalse%10.5f
QuantityOnSalesOrder3 DECIMAL 18TrueFalseFalseFalse%10.5f
MarkPendingIfRequired-7 BIT 1TrueTrueTrueFalse
1
0
true
false
RemovePending-7 BIT 1TrueTrueFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: BuildAssemblyComponentItemLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
ItemInventoryAssemblyRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
ItemInventoryAssemblyRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
InventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
InventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
LotNumber12 VARCHAR 40TrueTrueTrueFalse%s
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 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsPending-7 BIT 1TrueFalseFalseFalse
1
0
true
false
QuantityToBuild3 DECIMAL 18TrueTrueTrueTrue%10.5f
QuantityCanBuild3 DECIMAL 18TrueFalseFalseFalse%10.5f
QuantityOnHand3 DECIMAL 18TrueFalseFalseFalse%10.5f
QuantityOnSalesOrder3 DECIMAL 18TrueFalseFalseFalse%10.5f
MarkPendingIfRequired-7 BIT 1TrueTrueTrueFalse
1
0
true
false
RemovePending-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ComponentItemLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ComponentItemLineItemRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ComponentItemLineItemRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ComponentItemLineInventorySiteRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ComponentItemLineInventorySiteRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
ComponentItemLineInventorySiteLocationRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ComponentItemLineInventorySiteLocationRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
ComponentItemLineDesc12 VARCHAR 4095TrueFalseFalseFalse%s
ComponentItemLineQuantityOnHand3 DECIMAL 18TrueFalseFalseFalse%10.5f
ComponentItemLineQuantityNeeded3 DECIMAL 18TrueFalseFalseFalse%10.5f
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Charge
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueTrueTrueTrue%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 11TrueTrueTrueFalse%s
ItemRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ItemRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
InventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
InventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
Quantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
UnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
OverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
OverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
Rate3 DECIMAL 18TrueTrueTrueFalse%10.5f
OptionForPriceRuleConflict12 VARCHAR 23FalseTrueTrueFalse
Zero
BasePrice
Amount3 DECIMAL 15TrueTrueTrueFalse%10.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
Desc12 VARCHAR 4095TrueTrueTrueFalse%s
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
BilledDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
OverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
OverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: ChargeLinkedTxn
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseFalseTrue%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 11TrueFalseFalseFalse%s
ItemRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
ItemRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
InventorySiteRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
InventorySiteRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
InventorySiteLocationRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
InventorySiteLocationRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
Quantity3 DECIMAL 18TrueFalseFalseFalse%10.5f
UnitOfMeasure12 VARCHAR 31TrueFalseFalseFalse%s Yes
OverrideUOMSetRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
OverrideUOMSetRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
Rate3 DECIMAL 18TrueFalseFalseFalse%10.5f
OptionForPriceRuleConflict12 VARCHAR 23FalseFalseFalseFalse
Zero
BasePrice
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
Desc12 VARCHAR 4095TrueFalseFalseFalse%s
ARAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
BilledDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
OverrideItemAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
OverrideItemAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
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 20TrueFalseFalseFalse%s
LinkedTxnLinkType12 VARCHAR 8TrueFalseFalseFalse
AMTTYPE
QUANTYPE
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Check
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
AddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
AddressCity12 VARCHAR 31TrueTrueTrueFalse%s
AddressState12 VARCHAR 21TrueTrueTrueFalse%s
AddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
AddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
AddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
AddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
AddressNote12 VARCHAR 41TrueTrueTrueFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: CheckApplyCheckToTxn
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
AddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
AddressCity12 VARCHAR 31TrueTrueTrueFalse%s
AddressState12 VARCHAR 21TrueTrueTrueFalse%s
AddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
AddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
AddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
AddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
AddressNote12 VARCHAR 41TrueTrueTrueFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ApplyCheckToTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ApplyCheckToTxnTxnID12 VARCHAR 36TrueTrueTrueFalse%sf
ApplyCheckToTxnAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: CheckExpenseLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
AddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
AddressCity12 VARCHAR 31TrueTrueTrueFalse%s
AddressState12 VARCHAR 21TrueTrueTrueFalse%s
AddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
AddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
AddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
AddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
AddressNote12 VARCHAR 41TrueTrueTrueFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineClearExpenseLines-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ExpenseLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ExpenseLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ExpenseLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ExpenseLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ExpenseLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExpenseLineTax1Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExpenseLineMemo12 VARCHAR 4095TrueTrueTrueFalse%s
ExpenseLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ExpenseLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ExpenseLineSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: CheckItemLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
AddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
AddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
AddressCity12 VARCHAR 31TrueTrueTrueFalse%s
AddressState12 VARCHAR 21TrueTrueTrueFalse%s
AddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
AddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
AddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
AddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
AddressNote12 VARCHAR 41TrueTrueTrueFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemLineClearItemLines-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ItemLineType12 VARCHAR 11TrueFalseFalseFalseItemType
ItemLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ItemGroupLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ItemGroupLineItemRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ItemGroupLineItemRefFullName12 VARCHAR 31TrueTrueTrueTrue%s Yes
ItemGroupLineDesc12 VARCHAR 4095TrueFalseFalseFalse%s
ItemGroupLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemGroupLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemGroupLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ItemGroupLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ItemGroupLineTotalAmount3 DECIMAL 18TrueFalseFalseFalse%10.5f
ItemGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
ItemLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ItemLineItemRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ItemLineItemRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
ItemLineInventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineInventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemlineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
ItemLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ItemLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ItemLineCost3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ItemLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemLineTax1Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ItemLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ItemLineSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemLineSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemLineTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ItemLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Class
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueTrueTrueTrue%s
FullName12 VARCHAR 159TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
TABLE DETAIL REFERENCE: ClearedStatus
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseTrueTrue%s
TxnLineID12 VARCHAR 36TrueFalseTrueFalse%s
ClearedStatus12 VARCHAR 10TrueFalseTrueTrue
Cleared
NotCleared
Pending
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: Company
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 59TrueFalseFalseFalse%s
LegalCompanyName12 VARCHAR 59TrueFalseFalseFalse%s
AddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
AddressCity12 VARCHAR 31TrueFalseFalseFalse%s
AddressState12 VARCHAR 21TrueFalseFalseFalse%s
AddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
AddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
AddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
AddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
AddressNote12 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
LegalAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
LegalAddressState12 VARCHAR 21TrueFalseFalseFalse%s
LegalAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
LegalAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
LegalAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
LegalAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
LegalAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr112 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr212 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr312 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr412 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerAddr512 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressForCustomerCity12 VARCHAR 31TrueFalseFalseFalse%s
CompanyAddressForCustomerState12 VARCHAR 21TrueFalseFalseFalse%s
CompanyAddressForCustomerProvince12 VARCHAR 21TrueFalseFalseFalse%s
CompanyAddressForCustomerCounty12 VARCHAR 21TrueFalseFalseFalse%s
CompanyAddressForCustomerPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
CompanyAddressForCustomerCountry12 VARCHAR 31TrueFalseFalseFalse%s
CompanyAddressForCustomerNote12 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr112 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr212 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr312 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr412 VARCHAR 41TrueFalseFalseFalse%s
CompanyAddressBlockForCustomerAddr512 VARCHAR 41TrueFalseFalseFalse%s
Phone12 VARCHAR 51TrueFalseFalseFalse%s
Fax12 VARCHAR 51TrueFalseFalseFalse%s
Email12 VARCHAR 99TrueFalseFalseFalse%s
CompanyWebSite12 VARCHAR 128TrueFalseFalseFalse%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
EIN12 VARCHAR 20TrueFalseFalseFalse%s
SSN12 VARCHAR 11TrueFalseFalseFalse%s
TaxForm12 VARCHAR 11TrueFalseFalseFalse
Form1120
Form1120S
Form1065
Form990
Form990PF
Form990T
Form1040
OtherOrNone
BusinessNumber12 VARCHAR 16TrueFalseFalseFalse%s
SubscribedServicesServiceName12 VARCHAR 50TrueFalseFalseFalse%s
SubscribedServicesServiceDomain12 VARCHAR 50TrueFalseFalseFalse%s
SubscribedServicesServiceServiceStatus12 VARCHAR 10TrueFalseFalseFalse
Active
Expired
Never
Pending
Suspended
Terminated
Trial
AccountantCopyAccountantCopyExists-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountantCopyDividingDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
TABLE DETAIL REFERENCE: CompanyActivity
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
Id4 INTEGER 4TrueFalseFalseFalseFQID
LastRestoreTime11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
LastCondenseTime11 TIMESTAMP 16TrueFalseFalseFalse
TABLE DETAIL REFERENCE: CreditCardCharge
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: CreditCardChargeExpenseLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineClearExpenseLines-7 BIT 1FalseTrueFalseFalse
1
0
true
false
ExpenseLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ExpenseLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ExpenseLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ExpenseLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ExpenseLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExpenseLineTax1Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExpenseLineMemo12 VARCHAR 4095TrueTrueTrueFalse%s
ExpenseLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ExpenseLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ExpenseLineSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: CreditCardChargeItemLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemLineClearItemLines-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ItemLineType12 VARCHAR 11TrueFalseFalseFalseItemType
ItemLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ItemGroupLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ItemGroupLineItemRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ItemGroupLineItemRefFullName12 VARCHAR 31TrueTrueTrueTrue%s Yes
ItemGroupLineDesc12 VARCHAR 4095TrueFalseFalseFalse%s
ItemGroupLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemLineGroupUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineGroupOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ItemLineGroupOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ItemGroupLineTotalAmount3 DECIMAL 18TrueFalseTrueFalse%10.5f
ItemGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
ItemLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ItemLineItemRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ItemLineItemRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
ItemLineInventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineInventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
ItemLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ItemLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ItemLineCost3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ItemLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemLineTax1Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ItemLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ItemLineSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemLineSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemLineTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ItemLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: CreditCardCredit
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TABLE DETAIL REFERENCE: CreditCardCreditExpenseLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
ExpenseLineClearExpenseLines-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ExpenseLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ExpenseLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ExpenseLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ExpenseLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ExpenseLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExpenseLineTax1Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExpenseLineMemo12 VARCHAR 4095TrueTrueTrueFalse%s
ExpenseLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ExpenseLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ExpenseLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ExpenseLineSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ExpenseLineSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ExpenseLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: CreditCardCreditItemLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%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
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineClearItemLines-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ItemLineType12 VARCHAR 11TrueFalseFalseFalseItemType
ItemLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ItemGroupLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ItemGroupLineItemRefListID12 VARCHAR 36TrueTrueFalseTrue%s Yes
ItemGroupLineItemRefFullName12 VARCHAR 31TrueTrueFalseTrue%s Yes
ItemGroupLineDesc12 VARCHAR 4095TrueFalseFalseFalse%s
ItemGroupLineQuantity3 DECIMAL 18TrueTrueFalseFalse%10.5f
ItemLineGroupUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineGroupOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ItemLineGroupOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ItemGroupLineTotalAmount3 DECIMAL 18TrueFalseFalseFalse%10.5f
ItemGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
ItemLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ItemLineItemRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ItemLineItemRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
ItemLineInventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineInventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
ItemLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
ItemLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ItemLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ItemLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ItemLineCost3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ItemLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemLineTax1Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ItemLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ItemLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ItemLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
TABLE DETAIL REFERENCE: CreditMemo
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueTrueTrueTrue%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TemplateRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TemplateRefFullName12 VARCHAR 159TrueTrueTrueFalse%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 11TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
IsPending-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PONumber12 VARCHAR 25TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesRepRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueTrueTrueFalse%s Yes
FOB12 VARCHAR 13TrueTrueTrueFalse%s
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ShipMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShipMethodRefFullName12 VARCHAR 15TrueTrueTrueFalse%s Yes
Subtotal3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemSalesTaxRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesTaxPercentage3 DECIMAL 18TrueFalseFalseFalse%10.5f
SalesTaxTotal3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CreditRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 101TrueFalseFalseFalse%s Yes
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
CustomerMsgRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerMsgRefFullName12 VARCHAR 101TrueTrueTrueFalse%s Yes
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsToBeEmailed-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CustomerSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerSalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
CustomerTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomFieldOther12 VARCHAR 29TrueTrueTrueFalse%s
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CustomFieldBDay12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldContract12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSpousesName12 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CreditMemoLine
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueTrueTrueTrue%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TemplateRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TemplateRefFullName12 VARCHAR 159TrueTrueTrueFalse%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 11TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
IsPending-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PONumber12 VARCHAR 25TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesRepRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueTrueTrueFalse%s Yes
FOB12 VARCHAR 13TrueTrueTrueFalse%s
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ShipMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShipMethodRefFullName12 VARCHAR 15TrueTrueTrueFalse%s Yes
Subtotal3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemSalesTaxRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesTaxPercentage3 DECIMAL 18TrueFalseFalseFalse%10.5f
SalesTaxTotal3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CreditRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 101TrueFalseFalseFalse%s Yes
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
CustomerMsgRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerMsgRefFullName12 VARCHAR 101TrueTrueTrueFalse%s Yes
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsToBeEmailed-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CustomerSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerSalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
CustomerTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomFieldOther12 VARCHAR 29TrueTrueTrueFalse%s
CreditMemoLineType12 VARCHAR 11TrueFalseFalseFalseItemType
CreditMemoLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
CreditMemoLineGroupLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
CreditMemoLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineGroupItemGroupRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CreditMemoLineGroupDesc12 VARCHAR 4095TrueFalseFalseFalse%s
CreditMemoLineGroupQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
CreditMemoLineGroupUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
CreditMemoLineGroupOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
CreditMemoLineGroupOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
CreditMemoLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CreditMemoLineGroupTotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CreditMemoLineGroupServiceDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
CreditMemoLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
CreditMemoLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
CreditMemoLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CreditMemoLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
CreditMemoLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
CreditMemoLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
CreditMemoLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
CreditMemoLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
CreditMemoLineRate3 DECIMAL 18TrueTrueTrueFalse%10.5f
CreditMemoLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%7.5f
CreditMemoLinePriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLinePriceLevelRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CreditMemoLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CreditMemoLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
CreditMemoLineInventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineInventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
CreditMemoLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
CreditMemoLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
CreditMemoLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
CreditMemoLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CreditMemoLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
CreditMemoLineSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineSalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
CreditMemoLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
CreditMemoLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CustomFieldCreditMemoLineOther112 VARCHAR 29TrueTrueTrueFalse%s
CustomFieldCreditMemoLineOther212 VARCHAR 29TrueTrueTrueFalse%s
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldCreditMemoLineColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldCreditMemoLineMaterial12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldCreditMemoLineGroupColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldCreditMemoLineGroupMaterial12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldCreditMemoLineGroupLineColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldCreditMemoLineGroupLineMaterial12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldBDay12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldContract12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSpousesName12 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CreditMemoLinkedTxn
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseFalseTrue%s Yes
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
TemplateRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TemplateRefFullName12 VARCHAR 159TrueFalseFalseFalse%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 11TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
IsPending-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PONumber12 VARCHAR 25TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
SalesRepRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueFalseFalseFalse%s Yes
FOB12 VARCHAR 13TrueFalseFalseFalse%s
ShipDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
ShipMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ShipMethodRefFullName12 VARCHAR 15TrueFalseFalseFalse%s Yes
Subtotal3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemSalesTaxRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
SalesTaxPercentage3 DECIMAL 18TrueFalseFalseFalse%10.5f
SalesTaxTotal3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CreditRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 101TrueFalseFalseFalse%s Yes
Memo12 VARCHAR 4095TrueFalseFalseFalse%s
CustomerMsgRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerMsgRefFullName12 VARCHAR 101TrueFalseFalseFalse%s Yes
IsToBePrinted-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsToBeEmailed-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CustomerSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
CustomerTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomFieldOther12 VARCHAR 29TrueFalseFalseFalse%s
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 20TrueFalseFalseFalse%s
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.6f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldBDay12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldContract12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSpousesName12 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: Currency
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 64TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CurrencyCode12 VARCHAR 3TrueTrueTrueTrue%s
CurrencyFormatThousandSeparator12 VARCHAR 10TrueTrueTrueFalse
Comma
Period
Space
Apostrophe
CurrencyFormatThousandSeparatorGrouping12 VARCHAR 11TrueTrueTrueFalse
XX_XXX_XXX
X_XX_XX_XXX
CurrencyFormatDecimalPlaces12 VARCHAR 1TrueTrueTrueFalse
0
2
CurrencyFormatDecimalSeparator12 VARCHAR 6TrueTrueTrueFalse
Period
Comma
IsUserDefinedCurrency-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.6f
AsOfDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
TABLE DETAIL REFERENCE: Customer
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 41TrueTrueTrueTrue%s
FullName12 VARCHAR 209TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 209TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 41TrueTrueTrueFalse%s
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 5TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
JobTitle12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 1023TrueTrueTrueFalse%s
Cc12 VARCHAR 1023TrueTrueTrueFalse%s
Contact12 VARCHAR 41TrueTrueTrueFalse%s
AltContact12 VARCHAR 41TrueTrueTrueFalse%s
CustomerTypeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerTypeRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesRepRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueTrueTrueFalse%s Yes
Balance3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenBalance3 DECIMAL 15TrueFalseTrueFalse%10.2f
OpenBalanceDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
ItemSalesTaxRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesTaxCountry12 VARCHAR 31TrueTrueTrueFalse
Australia
Canada
UK
ResaleNumber12 VARCHAR 15TrueTrueTrueFalse%s
AccountNumber12 VARCHAR 99TrueTrueTrueFalse%s
BusinessNumber12 VARCHAR 99TrueFalseFalseFalse%s
CreditLimit3 DECIMAL 15TrueTrueTrueFalse%10.2f
PreferredPaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PreferredPaymentMethodRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
CreditCardInfoCreditCardNumber12 VARCHAR 25TrueTrueTrueFalse%s
CreditCardInfoExpirationMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardInfoExpirationYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardInfoNameOnCard12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardInfoCreditCardAddress12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardInfoCreditCardPostalCode12 VARCHAR 41TrueTrueTrueFalse%s
JobStatus12 VARCHAR 10TrueTrueTrueFalse
None
Pending
Awarded
InProgress
Closed
NotAwarded
JobStartDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobProjectedEndDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobEndDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobDesc12 VARCHAR 99TrueTrueTrueFalse%s
JobTypeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JobTypeRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
Notes12 VARCHAR 4095TrueTrueTrueFalse%s
PreferredDeliveryMethod12 VARCHAR 10TrueTrueTrueTrue
None
Email
Fax
IsUsingCustomerTaxCode-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PriceLevelRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TaxRegistrationNumber12 VARCHAR 30TrueFalseFalseFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
CustomFieldBDay12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldContract12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSpousesName12 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CustomerAddtionalNote
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 41TrueTrueTrueTrue%s
FullName12 VARCHAR 209TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 209TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 41TrueTrueTrueFalse%s
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 5TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
JobTitle12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 1023TrueTrueTrueFalse%s
Cc12 VARCHAR 1023TrueTrueTrueFalse%s
Contact12 VARCHAR 41TrueTrueTrueFalse%s
AltContact12 VARCHAR 41TrueTrueTrueFalse%s
CustomerTypeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerTypeRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesRepRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueTrueTrueFalse%s Yes
Balance3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenBalance3 DECIMAL 15TrueFalseTrueFalse%10.2f
OpenBalanceDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
ItemSalesTaxRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesTaxCountry12 VARCHAR 31TrueTrueTrueFalse
Australia
Canada
UK
ResaleNumber12 VARCHAR 15TrueTrueTrueFalse%s
AccountNumber12 VARCHAR 99TrueTrueTrueFalse%s
BusinessNumber12 VARCHAR 99TrueFalseFalseFalse%s
CreditLimit3 DECIMAL 15TrueTrueTrueFalse%10.2f
PreferredPaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PreferredPaymentMethodRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
CreditCardInfoCreditCardNumber12 VARCHAR 25TrueTrueTrueFalse%s
CreditCardInfoExpirationMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardInfoExpirationYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardInfoNameOnCard12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardInfoCreditCardAddress12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardInfoCreditCardPostalCode12 VARCHAR 41TrueTrueTrueFalse%s
JobStatus12 VARCHAR 10TrueTrueTrueFalse
None
Pending
Awarded
InProgress
Closed
NotAwarded
JobStartDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobProjectedEndDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobEndDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobDesc12 VARCHAR 99TrueTrueTrueFalse%s
JobTypeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JobTypeRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
Notes12 VARCHAR 4095TrueTrueTrueFalse%s
AdditionalNotesRetNoteID4 INTEGER 4TrueTrueFalseFalse%11.0f
AdditionalNotesRetDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AdditionalNotesRetNote12 VARCHAR 4095TrueTrueTrueFalse%s
PreferredDeliveryMethod12 VARCHAR 10TrueTrueTrueTrue
None
Email
Fax
IsUsingCustomerTaxCode-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PriceLevelRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TaxRegistrationNumber12 VARCHAR 30TrueFalseFalseFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldBDay12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldContract12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSpousesName12 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CustomerContacts
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 41TrueTrueTrueTrue%s
FullName12 VARCHAR 209TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 209TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 41TrueTrueTrueFalse%s
Salutation12 VARCHAR 15TrueTrueTrueFalse%s
FirstName12 VARCHAR 25TrueTrueTrueFalse%s
MiddleName12 VARCHAR 5TrueTrueTrueFalse%s
LastName12 VARCHAR 25TrueTrueTrueFalse%s
JobTitle12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
Phone12 VARCHAR 21TrueTrueTrueFalse%s
AltPhone12 VARCHAR 21TrueTrueTrueFalse%s
Fax12 VARCHAR 21TrueTrueTrueFalse%s
Email12 VARCHAR 1023TrueTrueTrueFalse%s
Cc12 VARCHAR 1023TrueTrueTrueFalse%s
Contact12 VARCHAR 41TrueTrueTrueFalse%s
AltContact12 VARCHAR 41TrueTrueTrueFalse%s
ContactsRetListID12 VARCHAR 36TrueTrueFalseFalse%s
ContactsRetTimeCreated11 TIMESTAMP 16TrueFalseFalseFalse%s
ContactsRetTimeModified11 TIMESTAMP 16TrueFalseFalseFalse%s
ContactsRetEditSequence12 VARCHAR 16TrueTrueFalseFalse%s
ContactsRetSalutation12 VARCHAR 15TrueTrueTrueFalse%s
ContactsRetFirstName12 VARCHAR 25TrueTrueTrueTrue%s
ContactsRetMiddleName12 VARCHAR 5TrueTrueTrueFalse%s
ContactsRetLastName12 VARCHAR 25TrueTrueTrueFalse%s
ContactsRetJobTitle12 VARCHAR 41TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef1ContactName12 VARCHAR 40TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef1ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef2ContactName12 VARCHAR 40TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef2ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef3ContactName12 VARCHAR 40TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef3ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef4ContactName12 VARCHAR 40TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef4ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef5ContactName12 VARCHAR 40TrueTrueTrueFalse%s
ContactsRetAdditionalContactRef5ContactValue12 VARCHAR 255TrueTrueTrueFalse%s
CustomerTypeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerTypeRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesRepRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueTrueTrueFalse%s Yes
Balance3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenBalance3 DECIMAL 15TrueFalseTrueFalse%10.2f
OpenBalanceDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
ItemSalesTaxRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesTaxCountry12 VARCHAR 31TrueTrueTrueFalse
Australia
Canada
UK
ResaleNumber12 VARCHAR 15TrueTrueTrueFalse%s
AccountNumber12 VARCHAR 99TrueTrueTrueFalse%s
BusinessNumber12 VARCHAR 99TrueFalseFalseFalse%s
CreditLimit3 DECIMAL 15TrueTrueTrueFalse%10.2f
PreferredPaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PreferredPaymentMethodRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
CreditCardInfoCreditCardNumber12 VARCHAR 25TrueTrueTrueFalse%s
CreditCardInfoExpirationMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardInfoExpirationYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardInfoNameOnCard12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardInfoCreditCardAddress12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardInfoCreditCardPostalCode12 VARCHAR 41TrueTrueTrueFalse%s
JobStatus12 VARCHAR 10TrueTrueTrueFalse
None
Pending
Awarded
InProgress
Closed
NotAwarded
JobStartDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobProjectedEndDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobEndDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
JobDesc12 VARCHAR 99TrueTrueTrueFalse%s
JobTypeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
JobTypeRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
Notes12 VARCHAR 4095TrueTrueTrueFalse%s
PreferredDeliveryMethod12 VARCHAR 10TrueTrueTrueTrue
None
Email
Fax
IsUsingCustomerTaxCode-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PriceLevelRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TaxRegistrationNumber12 VARCHAR 30TrueFalseFalseFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldBDay12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldContract12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSpousesName12 VARCHAR 30TrueTrueTrueFalse%s
TABLE DETAIL REFERENCE: CustomerMsg
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 101TrueFalseTrueTrue%s
IsActive-7 BIT 1TrueFalseTrueFalse
1
0
true
false
TABLE DETAIL REFERENCE: CustomerShipToAddress
(USA VERSION)
v18.0.0.325, Last Updated: 2017-12-27
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 16TrueFalseFalseFalse%s
Name12 VARCHAR 41TrueFalseFalseTrue%s
FullName12 VARCHAR 209TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
ParentRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ParentRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
CompanyName12 VARCHAR 41TrueFalseFalseFalse%s
Salutation12 VARCHAR 15TrueFalseFalseFalse%s
FirstName12 VARCHAR 25TrueFalseFalseFalse%s
MiddleName12 VARCHAR 5TrueFalseFalseFalse%s
LastName12 VARCHAR 25TrueFalseFalseFalse%s
JobTitle12 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressName12 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
ShipToAddressState12 VARCHAR 21TrueFalseFalseFalse%s
ShipToAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
ShipToAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
ShipToAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
ShipToAddressDefaultShipTo-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Phone12 VARCHAR 21TrueFalseFalseFalse%s
AltPhone12 VARCHAR 21TrueFalseFalseFalse%s
Fax12 VARCHAR 21TrueFalseFalseFalse%s
Email12 VARCHAR 1023TrueFalseFalseFalse%s
Cc12 VARCHAR 1023TrueFalseFalseFalse%s
Contact12 VARCHAR 41TrueFalseFalseFalse%s
AltContact12 VARCHAR 41TrueFalseFalseFalse%s
CustomerTypeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerTypeRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
SalesRepRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueFalseFalseFalse%s Yes
Balance3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenBalance3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenBalanceDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
ItemSalesTaxRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
SalesTaxCountry12 VARCHAR 31TrueFalseFalseFalse
Australia
Canada
UK
ResaleNumber12 VARCHAR 15TrueFalseFalseFalse%s
AccountNumber12 VARCHAR 99TrueFalseFalseFalse%s
BusinessNumber12 VARCHAR 99TrueFalseFalseFalse%s
CreditLimit3 DECIMAL 15TrueFalseFalseFalse%10.2f
PreferredPaymentMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PreferredPaymentMethodRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
CreditCardInfoCreditCardNumber12 VARCHAR 25TrueFalseFalseFalse%s
CreditCardInfoExpirationMonth4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardInfoExpirationYear4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardInfoNameOnCard12 VARCHAR 41TrueFalseFalseFalse%s
CreditCardInfoCreditCardAddress12 VARCHAR 41TrueFalseFalseFalse%s
CreditCardInfoCreditCardPostalCode12 VARCHAR 41TrueFalseFalseFalse%s
JobStatus12 VARCHAR 10TrueFalseFalseFalse
None
Pending
Awarded
InProgress
Closed
NotAwarded
JobStartDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
JobProjectedEndDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
JobEndDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
JobDesc12 VARCHAR 99TrueFalseFalseFalse%s
JobTypeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
JobTypeRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
Notes12 VARCHAR 4095TrueFalseFalseFalse%s
PreferredDeliveryMethod12 VARCHAR 10TrueFalseFalseTrue
None
Email
Fax
IsUsingCustomerTaxCode-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PriceLevelRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PriceLevelRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
ExternalGUID12 VARCHAR 40TrueFalseFalseFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TaxRegistrationNumber12 VARCHAR 30TrueFalseFalseFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldBDay12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldContract12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldSpousesName12 VARCHAR