TABLE DETAIL REFERENCE: Account
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
Name | 12 | VARCHAR | 31 | True | True | True | True | %s | |
FullName | 12 | VARCHAR | 159 | True | False | False | False | %s | |
IsActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
ParentRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
ParentRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | |
Sublevel | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountType | 12 | VARCHAR | 21 | True | True | True | True | AccountsPayable AccountsReceivable Bank CostOfGoodsSold CreditCard Equity Expense FixedAsset Income LongTermLiability Nonposting OtherAsset OtherCurrentAsset OtherCurrentLiability OtherExpense OtherIn | |
SpecialAccountType | 12 | VARCHAR | 30 | True | False | False | False | AccountsPayable AccountsReceivable CondenseItemAdjustmentExpenses CostOfGoodsSold DirectDepositLiabilities Estimates InventoryAssets OpeningBalanceEquity PayrollExpenses PayrollLiabilities PettyCash PÃÝoNþK±…=wvÉ €? n‚ø ̱‘T Í $ÃÝoNþK±…=wvÉ 0'^‚ø | |
IsTaxAccount | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
AccountNumber | 12 | VARCHAR | 7 | True | True | True | False | %s | |
BankNumber | 12 | VARCHAR | 25 | True | True | True | False | %s | |
Desc | 12 | VARCHAR | 200 | True | True | True | False | %s | |
Balance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
TotalBalance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenBalance | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
OpenBalanceDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | True | False | %s | Yes |
TaxLineInfoRetTaxLineID | 4 | INTEGER | 4 | True | False | False | False | %11.0f | Yes |
TaxLineInfoRetTaxLineName | 12 | VARCHAR | 256 | True | False | False | False | %s | Yes |
CashFlowClassification | 12 | VARCHAR | 13 | True | False | False | False | None Operating Investing Financing NotApplicable | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 64 | True | True | True | False | %s | Yes |
TABLE DETAIL REFERENCE: AccountTaxLineInfo
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TaxLineID | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
TaxLineName | 12 | VARCHAR | 256 | True | False | False | False | %s |
TABLE DETAIL REFERENCE: ARRefundCreditCard
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CustomerRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
CustomerRefFullName | 12 | VARCHAR | 209 | True | False | True | True | %s | Yes |
RefundFromAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
RefundFromAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
ARAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
ARAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
RefNumber | 12 | VARCHAR | 11 | True | False | True | False | %s | |
TotalAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AddressAddr1 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressAddr2 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressAddr3 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressAddr4 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressAddr5 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressCity | 12 | VARCHAR | 31 | True | False | True | False | %s | |
AddressState | 12 | VARCHAR | 21 | True | False | True | False | %s | |
AddressProvince | 12 | VARCHAR | 21 | True | False | True | False | %s | |
AddressCounty | 12 | VARCHAR | 21 | True | False | True | False | %s | |
AddressPostalCode | 12 | VARCHAR | 13 | True | False | True | False | %s | |
AddressCountry | 12 | VARCHAR | 31 | True | False | True | False | %s | |
AddressNote | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
PaymentMethodRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
PaymentMethodRefFullName | 12 | VARCHAR | 31 | True | False | True | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
CreditCardTxnInfoInputCreditCardNumber | 12 | VARCHAR | 25 | True | False | True | False | %s | |
CreditCardTxnInfoInputExpirationMonth | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoInputExpirationYear | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoInputNameOnCard | 12 | VARCHAR | 41 | True | False | True | False | %s | |
CreditCardTxnInfoInputCreditCardAddress | 12 | VARCHAR | 41 | True | False | True | False | %s | |
CreditCardTxnInfoInputCreditCardPostalCode | 12 | VARCHAR | 41 | True | False | True | False | %s | |
CreditCardTxnInfoInputCommercialCardCode | 12 | VARCHAR | 50 | True | False | True | False | %s | |
CreditCardTxnInfoInputTransactionMode | 12 | VARCHAR | 14 | True | False | True | False | CardNotPresent CardPresent | |
CreditCardTxnInfoInputCreditCardTxnType | 12 | VARCHAR | 18 | True | False | True | False | Authorization Capture Charge Refund VoiceAuthorization | |
CreditCardTxnInfoResultResultCode | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoResultResultMessage | 12 | VARCHAR | 500 | True | False | True | False | %s | |
CreditCardTxnInfoResultCreditCardTransID | 12 | VARCHAR | 24 | True | False | True | False | %s | |
CreditCardTxnInfoResultMerchantAccountNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
CreditCardTxnInfoResultAuthorizationCode | 12 | VARCHAR | 12 | True | False | True | False | %s | |
CreditCardTxnInfoResultAVSStreet | 12 | VARCHAR | 12 | True | False | True | False | Pass Fail NotAvailable | |
CreditCardTxnInfoResultAVSZip | 12 | VARCHAR | 12 | True | False | True | False | Pass Fail NotAvailable | |
CreditCardTxnInfoResultCardSecurityCodeMatch | 12 | VARCHAR | 12 | True | False | True | False | Pass Fail NotAvailable | |
CreditCardTxnInfoResultReconBatchID | 12 | VARCHAR | 84 | True | False | True | False | %s | |
CreditCardTxnInfoResultPaymentGroupingCode | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoResultPaymentStatus | 12 | VARCHAR | 9 | True | False | True | False | Unknown Completed | |
CreditCardTxnInfoResultTxnAuthorizationTime | 11 | TIMESTAMP | 16 | True | False | True | False | CCCC-MM-DDThh:mm:ssZ | |
CreditCardTxnInfoResultTxnAuthorizationStamp | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoResultClientTransID | 12 | VARCHAR | 16 | True | False | True | False | %s |
TABLE DETAIL REFERENCE: ARRefundCreditCardRefundAppliedTo
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CustomerRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
CustomerRefFullName | 12 | VARCHAR | 209 | True | False | True | True | %s | Yes |
RefundFromAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
RefundFromAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
ARAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
ARAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
RefNumber | 12 | VARCHAR | 11 | True | False | True | False | %s | |
TotalAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AddressAddr1 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressAddr2 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressAddr3 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressAddr4 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressAddr5 | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressCity | 12 | VARCHAR | 31 | True | False | True | False | %s | |
AddressState | 12 | VARCHAR | 21 | True | False | True | False | %s | |
AddressProvince | 12 | VARCHAR | 21 | True | False | True | False | %s | |
AddressCounty | 12 | VARCHAR | 21 | True | False | True | False | %s | |
AddressPostalCode | 12 | VARCHAR | 13 | True | False | True | False | %s | |
AddressCountry | 12 | VARCHAR | 31 | True | False | True | False | %s | |
AddressNote | 12 | VARCHAR | 41 | True | False | True | False | %s | |
AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
PaymentMethodRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
PaymentMethodRefFullName | 12 | VARCHAR | 31 | True | False | True | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
CreditCardTxnInfoInputCreditCardNumber | 12 | VARCHAR | 25 | True | False | True | False | %s | |
CreditCardTxnInfoInputExpirationMonth | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoInputExpirationYear | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoInputNameOnCard | 12 | VARCHAR | 41 | True | False | True | False | %s | |
CreditCardTxnInfoInputCreditCardAddress | 12 | VARCHAR | 41 | True | False | True | False | %s | |
CreditCardTxnInfoInputCreditCardPostalCode | 12 | VARCHAR | 41 | True | False | True | False | %s | |
CreditCardTxnInfoInputCommercialCardCode | 12 | VARCHAR | 50 | True | False | True | False | %s | |
CreditCardTxnInfoInputTransactionMode | 12 | VARCHAR | 14 | True | False | True | False | CardNotPresent CardPresent | |
CreditCardTxnInfoInputCreditCardTxnType | 12 | VARCHAR | 18 | True | False | True | False | Authorization Capture Charge Refund VoiceAuthorization | |
CreditCardTxnInfoResultResultCode | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoResultResultMessage | 12 | VARCHAR | 500 | True | False | True | False | %s | |
CreditCardTxnInfoResultCreditCardTransID | 12 | VARCHAR | 24 | True | False | True | False | %s | |
CreditCardTxnInfoResultMerchantAccountNumber | 12 | VARCHAR | 32 | True | False | True | False | %s | |
CreditCardTxnInfoResultAuthorizationCode | 12 | VARCHAR | 12 | True | False | True | False | %s | |
CreditCardTxnInfoResultAVSStreet | 12 | VARCHAR | 12 | True | False | True | False | Pass Fail NotAvailable | |
CreditCardTxnInfoResultAVSZip | 12 | VARCHAR | 12 | True | False | True | False | Pass Fail NotAvailable | |
CreditCardTxnInfoResultCardSecurityCodeMatch | 12 | VARCHAR | 12 | True | False | True | False | Pass Fail NotAvailable | |
CreditCardTxnInfoResultReconBatchID | 12 | VARCHAR | 84 | True | False | True | False | %s | |
CreditCardTxnInfoResultPaymentGroupingCode | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoResultPaymentStatus | 12 | VARCHAR | 9 | True | False | True | False | Unknown Completed | |
CreditCardTxnInfoResultTxnAuthorizationTime | 11 | TIMESTAMP | 16 | True | False | True | False | CCCC-MM-DDThh:mm:ssZ | |
CreditCardTxnInfoResultTxnAuthorizationStamp | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
CreditCardTxnInfoResultClientTransID | 12 | VARCHAR | 16 | True | False | True | False | %s | |
RefundAppliedToTxnTxnID | 12 | VARCHAR | 36 | True | False | True | True | %s | |
RefundAppliedToTxnTxnType | 12 | VARCHAR | 14 | True | False | False | False | Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjusÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
RefundAppliedToTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
RefundAppliedToTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
RefundAppliedToTxnRefCreditRemaining | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefundAppliedToTxnRefRefundAmount | 3 | DECIMAL | 15 | True | False | True | False | %10.2f | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BarCode
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
FullName | 12 | VARCHAR | 50 | True | False | False | False | %s |
TABLE DETAIL REFERENCE: Bill
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
VendorRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
VendorRefFullName | 12 | VARCHAR | 41 | True | True | True | True | %s | Yes |
VendorAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
VendorAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
VendorAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
APAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
AmountDue | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountDueInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 20 | True | True | True | False | %s | |
TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
LinkToTxnID1 | 12 | VARCHAR | 36 | True | False | True | False | %s | |
IsPaid | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false |
TABLE DETAIL REFERENCE: BillExpenseLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
VendorRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
VendorRefFullName | 12 | VARCHAR | 41 | True | True | True | True | %s | Yes |
VendorAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
VendorAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
VendorAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
APAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
AmountDue | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountDueInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 20 | True | True | True | False | %s | |
TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
LinkToTxnID1 | 12 | VARCHAR | 36 | True | False | True | False | %s | |
IsPaid | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
ExpenseLineClearExpenseLines | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
ExpenseLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ExpenseLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ExpenseLineAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ExpenseLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
ExpenseLineTaxAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExpenseLineTax1Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExpenseLineMemo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ExpenseLineCustomerRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineCustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ExpenseLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ExpenseLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | True | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillingRate
(UK VERSION)
TABLE DETAIL REFERENCE: BillingRateLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
Name | 12 | VARCHAR | 31 | True | False | True | True | %s | |
BillingRateType | 12 | VARCHAR | 9 | True | False | True | False | FixedRate PerItem | |
FixedBillingRate | 3 | DECIMAL | 18 | True | False | True | False | %10.5f | |
BillingRateLineItemRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
BillingRateLineItemRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
BillingRateLineCustomRate | 3 | DECIMAL | 18 | True | False | True | False | %10.5f | |
BillingRateLineCustomRatePercent | 3 | DECIMAL | 18 | True | False | True | False | %10.5f | |
BillingRateLineAdjustPercentage | 3 | DECIMAL | 18 | True | False | True | False | %10.5f | |
BillingRateLineAdjustBillingRateRelativeTo | 12 | VARCHAR | 9 | True | False | True | False | StandardRate CurrentCustomRate | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillItemLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
VendorRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
VendorRefFullName | 12 | VARCHAR | 41 | True | True | True | True | %s | Yes |
VendorAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
VendorAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
VendorAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
VendorAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
APAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
AmountDue | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountDueInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 20 | True | True | True | False | %s | |
TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
LinkToTxnID1 | 12 | VARCHAR | 36 | True | False | True | False | %s | |
IsPaid | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
ItemLineType | 12 | VARCHAR | 11 | True | False | False | False | ItemType | |
ItemLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ItemGroupLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ItemGroupLineItemGroupRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
ItemGroupLineItemGroupRefFullName | 12 | VARCHAR | 31 | True | True | True | True | %s | Yes |
ItemGroupLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemGroupUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemGroupOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
ItemGroupOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
ItemGroupLineTotalAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
ItemGroupSeqNo | 4 | INTEGER | 4 | True | False | False | False | SubSeqNo | |
ItemLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ItemLineItemRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
ItemLineItemRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
ItemLineInventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineInventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineInventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineSerialNumber | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ItemLineLotNumber | 12 | VARCHAR | 40 | True | True | True | False | %s | |
ItemLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ItemLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemLineUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
ItemLineOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
ItemLineCost | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
ItemLineTaxAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemLineTax1Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemLineCustomerRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineCustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ItemLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ItemLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
ItemLineOverrideItemAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineOverrideItemAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ItemLineLinkToTxnTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
ItemLineLinkToTxnTxnLineID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | True | False | False | FQPrimaryKey | |
FQTxnLinkKey | 12 | VARCHAR | 110 | True | True | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillLinkedTxn
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
VendorRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
VendorRefFullName | 12 | VARCHAR | 41 | True | False | False | True | %s | Yes |
VendorAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
VendorAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
VendorAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
VendorAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
VendorAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
VendorAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
VendorAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
APAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
DueDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
AmountDue | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.6f | |
AmountDueInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
TermsRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
IsTaxIncluded | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
LinkToTxnID1 | 12 | VARCHAR | 36 | True | False | False | False | %s | |
IsPaid | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
LinkedTxnSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
LinkedTxnTxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
LinkedTxnTxnType | 12 | VARCHAR | 21 | True | False | False | False | Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjusÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
LinkedTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
LinkedTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
LinkedTxnLinkType | 12 | VARCHAR | 8 | True | False | False | False | AMTTYPE QUANTYPE | |
LinkedTxnAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillPaymentCheck
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | False | True | True | %s | Yes |
APAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
BankAccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
BankAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
Amount | 3 | DECIMAL | 15 | True | True | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | False | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | True | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | True | %s | |
IsToBePrinted | -7 | BIT | 1 | True | True | True | True | 1 0 true false | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
AddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
AddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
AddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
AddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s |
TABLE DETAIL REFERENCE: BillPaymentCheckLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | False | True | True | %s | Yes |
APAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
BankAccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
BankAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
Amount | 3 | DECIMAL | 15 | True | True | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | False | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | True | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | True | %s | |
IsToBePrinted | -7 | BIT | 1 | True | True | True | True | 1 0 true false | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
AddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
AddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
AddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
AddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AppliedToTxnSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
AppliedToTxnTxnID | 12 | VARCHAR | 36 | True | True | True | True | %s | |
AppliedToTxnPaymentAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
AppliedToTxnTxnType | 12 | VARCHAR | 14 | True | False | False | False | Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjusÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
AppliedToTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
AppliedToTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
AppliedToTxnBalanceRemaining | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AppliedToTxnAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AppliedToTxnSetCreditCreditTxnID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
AppliedToTxnSetCreditAppliedAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
AppliedToTxnDiscountAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
AppliedToTxnDiscountAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
AppliedToTxnDiscountAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
AppliedToTxnDiscountClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
AppliedToTxnDiscountClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | True | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillPaymentCheckLineLinkedTxn
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | False | False | True | %s | Yes |
APAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
BankAccountRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
BankAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | False | False | True | %s | |
IsToBePrinted | -7 | BIT | 1 | True | False | False | True | 1 0 true false | |
Memo | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
AddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
AddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
AddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
AddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AppliedToTxnLinkedTxnTxnID | 12 | VARCHAR | 36 | True | False | False | True | %s | |
AppliedToTxnLinkedTxnTxnType | 12 | VARCHAR | 14 | True | False | False | False | ARRefundCreditCard Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
AppliedToTxnLinkedTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
AppliedToTxnLinkedTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
AppliedToTxnLinkedTxnLinkType | 12 | VARCHAR | 14 | True | False | False | False | AMTTYPE QUANTYPE | |
AppliedToTxnLinkedTxnAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillPaymentCreditCard
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | False | True | True | %s | Yes |
APAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
CreditCardAccountRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
CreditCardAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | False | True | True | %s | |
Memo | 12 | VARCHAR | 4095 | True | False | True | False | %s |
TABLE DETAIL REFERENCE: BillPaymentCreditCardLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | False | True | True | %s | Yes |
APAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
CreditCardAccountRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
CreditCardAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | False | True | True | %s | |
Memo | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
AppliedToTxnSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
AppliedToTxnTxnID | 12 | VARCHAR | 36 | True | False | True | True | %s | |
AppliedToTxnPaymentAmount | 3 | DECIMAL | 15 | True | False | True | False | %10.2f | |
AppliedToTxnTxnType | 12 | VARCHAR | 14 | True | False | False | False | Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjusÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
AppliedToTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
AppliedToTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
AppliedToTxnBalanceRemaining | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AppliedToTxnAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AppliedToTxnSetCreditCreditTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
AppliedToTxnSetCreditAppliedAmount | 3 | DECIMAL | 15 | True | False | True | False | %10.2f | |
AppliedToTxnDiscountAmount | 3 | DECIMAL | 15 | True | False | True | False | %10.2f | |
AppliedToTxnDiscountAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
AppliedToTxnDiscountAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
AppliedToTxnDiscountClassRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
AppliedToTxnDiscountClassRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillPaymentCreditCardLineLinkedTxn
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | False | True | True | %s | Yes |
APAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
APAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
CreditCardAccountRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
CreditCardAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | False | True | True | %s | |
Memo | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
AppliedToTxnLinkedTxnTxnID | 12 | VARCHAR | 36 | True | False | False | True | %s | |
AppliedToTxnLinkedTxnTxnType | 12 | VARCHAR | 14 | True | False | False | False | ARRefundCreditCard Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
AppliedToTxnLinkedTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
AppliedToTxnLinkedTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
AppliedToTxnLinkedTxnLinkType | 12 | VARCHAR | 14 | True | False | False | False | AMTTYPE QUANTYPE | |
AppliedToTxnLinkedTxnAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillToPay
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
DueDateCutoff | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
BillToPayTxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
BillToPayTxnType | 12 | VARCHAR | 14 | True | False | False | False | Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjusÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
BillToPayTxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
BillToPayAPAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
BillToPayAPAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
BillToPayTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
BillToPayRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
BillToPayDueDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
BillToPayAmountDue | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
BillToPayCurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
BillToPayCurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
BillToPayExchangeRate | 3 | DECIMAL | 18 | True | False | False | False | %6.6f | |
BillToPayAmountDueInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CreditToApplyTxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
CreditToApplyTxnType | 12 | VARCHAR | 14 | True | False | False | False | Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjusÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
CreditToApplyTxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CreditToApplyAPAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CreditToApplyAPAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
CreditToApplyTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
CreditToApplyRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
CreditToApplyCreditRemaining | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BuildAssembly
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
ItemInventoryAssemblyRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
ItemInventoryAssemblyRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
InventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
InventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
InventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
InventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SerialNumber | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
LotNumber | 12 | VARCHAR | 40 | True | True | True | False | %s | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
IsPending | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
QuantityToBuild | 3 | DECIMAL | 18 | True | True | True | True | %10.5f | |
QuantityCanBuild | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
QuantityOnHand | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
QuantityOnSalesOrder | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
MarkPendingIfRequired | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
RemovePending | -7 | BIT | 1 | True | True | False | False | 1 0 true false |
TABLE DETAIL REFERENCE: BuildAssemblyComponentItemLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
ItemInventoryAssemblyRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
ItemInventoryAssemblyRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
InventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
InventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
InventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
InventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SerialNumber | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
LotNumber | 12 | VARCHAR | 40 | True | True | True | False | %s | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
IsPending | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
QuantityToBuild | 3 | DECIMAL | 18 | True | True | True | True | %10.5f | |
QuantityCanBuild | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
QuantityOnHand | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
QuantityOnSalesOrder | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
MarkPendingIfRequired | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
RemovePending | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
ComponentItemLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ComponentItemLineItemRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ComponentItemLineItemRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
ComponentItemLineInventorySiteRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ComponentItemLineInventorySiteRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
ComponentItemLineInventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ComponentItemLineInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
ComponentItemLineDesc | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
ComponentItemLineQuantityOnHand | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
ComponentItemLineQuantityNeeded | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Charge
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CustomerRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
CustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | True | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
ItemRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
ItemRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
InventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
InventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
InventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
InventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
Quantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
UnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
OverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
OverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
Rate | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
OptionForPriceRuleConflict | 12 | VARCHAR | 23 | False | True | True | False | Zero BasePrice | |
Amount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
BalanceRemaining | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Desc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ARAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ARAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
BilledDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
OverrideItemAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
OverrideItemAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
IsPaid | -7 | BIT | 1 | True | False | False | False | 1 0 true false |
TABLE DETAIL REFERENCE: ChargeLinkedTxn
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CustomerRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
CustomerRefFullName | 12 | VARCHAR | 209 | True | False | False | True | %s | Yes |
TxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
RefNumber | 12 | VARCHAR | 11 | True | False | False | False | %s | |
ItemRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
ItemRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
InventorySiteRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
InventorySiteRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
InventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
InventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
Quantity | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
UnitOfMeasure | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
OverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
OverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
Rate | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
OptionForPriceRuleConflict | 12 | VARCHAR | 23 | False | False | False | False | Zero BasePrice | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
BalanceRemaining | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Desc | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
ARAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ARAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
ClassRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ClassRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
BilledDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
DueDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
OverrideItemAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
OverrideItemAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
IsPaid | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
LinkedTxnSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
LinkedTxnTxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
LinkedTxnTxnType | 12 | VARCHAR | 21 | True | False | False | False | Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjusÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
LinkedTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
LinkedTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
LinkedTxnLinkType | 12 | VARCHAR | 8 | True | False | False | False | AMTTYPE QUANTYPE | |
LinkedTxnAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Check
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
AddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
AddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
AddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
AddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
IsToBePrinted | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false |
TABLE DETAIL REFERENCE: CheckApplyCheckToTxn
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
AddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
AddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
AddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
AddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
IsToBePrinted | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ApplyCheckToTxnSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ApplyCheckToTxnTxnID | 12 | VARCHAR | 36 | True | True | True | False | %sf | |
ApplyCheckToTxnAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CheckExpenseLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
AddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
AddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
AddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
AddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
IsToBePrinted | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineClearExpenseLines | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
ExpenseLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ExpenseLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ExpenseLineAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ExpenseLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
ExpenseLineTaxAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExpenseLineTax1Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExpenseLineMemo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ExpenseLineCustomerRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineCustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ExpenseLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ExpenseLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CheckItemLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
AddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
AddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
AddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
AddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
IsToBePrinted | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemLineClearItemLines | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
ItemLineType | 12 | VARCHAR | 11 | True | False | False | False | ItemType | |
ItemLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ItemGroupLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ItemGroupLineItemRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
ItemGroupLineItemRefFullName | 12 | VARCHAR | 31 | True | True | True | True | %s | Yes |
ItemGroupLineDesc | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
ItemGroupLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemGroupLineUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemGroupLineOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
ItemGroupLineOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
ItemGroupLineTotalAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
ItemGroupSeqNo | 4 | INTEGER | 4 | True | False | False | False | SubSeqNo | |
ItemLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ItemLineItemRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
ItemLineItemRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
ItemLineInventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineInventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineInventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemlineInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineSerialNumber | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ItemLineLotNumber | 12 | VARCHAR | 40 | True | True | True | False | %s | |
ItemLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ItemLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemLineUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
ItemLineOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
ItemLineCost | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
ItemLineTaxAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemLineTax1Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemLineCustomerRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineCustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ItemLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ItemLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
ItemLineOverrideItemAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineOverrideItemAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
FQTxnLinkKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Class
(UK VERSION)
TABLE DETAIL REFERENCE: ClearedStatus
(UK VERSION)
TABLE DETAIL REFERENCE: Company
(UK VERSION)
TABLE DETAIL REFERENCE: CompanyActivity
(UK VERSION)
TABLE DETAIL REFERENCE: CreditCardCharge
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false |
TABLE DETAIL REFERENCE: CreditCardChargeExpenseLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineClearExpenseLines | -7 | BIT | 1 | False | True | False | False | 1 0 true false | |
ExpenseLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ExpenseLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ExpenseLineAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ExpenseLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
ExpenseLineTaxAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExpenseLineTax1Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExpenseLineMemo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ExpenseLineCustomerRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineCustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ExpenseLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ExpenseLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CreditCardChargeItemLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemLineClearItemLines | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
ItemLineType | 12 | VARCHAR | 11 | True | False | False | False | ItemType | |
ItemLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ItemGroupLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ItemGroupLineItemRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
ItemGroupLineItemRefFullName | 12 | VARCHAR | 31 | True | True | True | True | %s | Yes |
ItemGroupLineDesc | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
ItemGroupLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemLineGroupUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineGroupOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
ItemLineGroupOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
ItemGroupLineTotalAmount | 3 | DECIMAL | 18 | True | False | True | False | %10.5f | |
ItemGroupSeqNo | 4 | INTEGER | 4 | True | False | False | False | SubSeqNo | |
ItemLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ItemLineItemRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
ItemLineItemRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
ItemLineInventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineInventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineInventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineSerialNumber | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ItemLineLotNumber | 12 | VARCHAR | 40 | True | True | True | False | %s | |
ItemLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ItemLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemLineUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
ItemLineOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
ItemLineCost | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
ItemLineTaxAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemLineTax1Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemLineCustomerRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineCustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ItemLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ItemLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
ItemLineOverrideItemAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineOverrideItemAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
FQTxnLinkKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CreditCardCredit
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false |
TABLE DETAIL REFERENCE: CreditCardCreditExpenseLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ExpenseLineClearExpenseLines | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
ExpenseLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ExpenseLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ExpenseLineAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ExpenseLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
ExpenseLineTaxAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExpenseLineTax1Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExpenseLineMemo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ExpenseLineCustomerRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineCustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ExpenseLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ExpenseLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ExpenseLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ExpenseLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CreditCardCreditItemLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
AccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
AccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
PayeeEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PayeeEntityRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ItemLineClearItemLines | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
ItemLineType | 12 | VARCHAR | 11 | True | False | False | False | ItemType | |
ItemLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
ItemGroupLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ItemGroupLineItemRefListID | 12 | VARCHAR | 36 | True | True | False | True | %s | Yes |
ItemGroupLineItemRefFullName | 12 | VARCHAR | 31 | True | True | False | True | %s | Yes |
ItemGroupLineDesc | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
ItemGroupLineQuantity | 3 | DECIMAL | 18 | True | True | False | False | %10.5f | |
ItemLineGroupUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineGroupOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
ItemLineGroupOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
ItemGroupLineTotalAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
ItemGroupSeqNo | 4 | INTEGER | 4 | True | False | False | False | SubSeqNo | |
ItemLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ItemLineItemRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
ItemLineItemRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
ItemLineInventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineInventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineInventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineSerialNumber | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ItemLineLotNumber | 12 | VARCHAR | 40 | True | True | True | False | %s | |
ItemLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
ItemLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemLineUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ItemLineOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
ItemLineOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
ItemLineCost | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
ItemLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
ItemLineTaxAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemLineTax1Amount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemLineCustomerRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineCustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ItemLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ItemLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
ItemLineOverrideItemAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemLineOverrideItemAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
FQTxnLinkKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CreditMemo
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CustomerRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
CustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | True | %s | Yes |
ClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ARAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ARAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TemplateRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TemplateRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
BillAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
BillAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
ShipAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
IsPending | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
PONumber | 12 | VARCHAR | 25 | True | True | True | False | %s | |
TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
SalesRepRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesRepRefFullName | 12 | VARCHAR | 5 | True | True | True | False | %s | Yes |
FOB | 12 | VARCHAR | 13 | True | True | True | False | %s | |
ShipDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
ShipMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ShipMethodRefFullName | 12 | VARCHAR | 15 | True | True | True | False | %s | Yes |
Subtotal | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SalesTaxPercentage | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
SalesTaxTotal | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
TotalAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CreditRemaining | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 101 | True | False | False | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
CustomerMsgRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CustomerMsgRefFullName | 12 | VARCHAR | 101 | True | True | True | False | %s | Yes |
IsToBePrinted | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsToBeEmailed | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
CustomerSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CustomerSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
CustomerTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CustomerTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
CustomFieldOther | 12 | VARCHAR | 29 | True | True | True | False | %s | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false |
TABLE DETAIL REFERENCE: CreditMemoLine
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CustomerRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
CustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | True | %s | Yes |
ClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
ARAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ARAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TemplateRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TemplateRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
BillAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
BillAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
ShipAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
IsPending | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
PONumber | 12 | VARCHAR | 25 | True | True | True | False | %s | |
TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
SalesRepRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesRepRefFullName | 12 | VARCHAR | 5 | True | True | True | False | %s | Yes |
FOB | 12 | VARCHAR | 13 | True | True | True | False | %s | |
ShipDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
ShipMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ShipMethodRefFullName | 12 | VARCHAR | 15 | True | True | True | False | %s | Yes |
Subtotal | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SalesTaxPercentage | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
SalesTaxTotal | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
TotalAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CreditRemaining | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 101 | True | False | False | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
CustomerMsgRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CustomerMsgRefFullName | 12 | VARCHAR | 101 | True | True | True | False | %s | Yes |
IsToBePrinted | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsToBeEmailed | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsTaxIncluded | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
CustomerSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CustomerSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
CustomerTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CustomerTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
CustomFieldOther | 12 | VARCHAR | 29 | True | True | True | False | %s | |
CreditMemoLineType | 12 | VARCHAR | 11 | True | False | False | False | ItemType | |
CreditMemoLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
CreditMemoLineGroupLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
CreditMemoLineGroupItemGroupRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CreditMemoLineGroupItemGroupRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
CreditMemoLineGroupDesc | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
CreditMemoLineGroupQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
CreditMemoLineGroupUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
CreditMemoLineGroupOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
CreditMemoLineGroupOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
CreditMemoLineGroupIsPrintItemsInGroup | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
CreditMemoLineGroupTotalAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CreditMemoLineGroupServiceDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
CreditMemoLineGroupSeqNo | 4 | INTEGER | 4 | True | False | False | False | SubSeqNo | |
CreditMemoLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
CreditMemoLineItemRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CreditMemoLineItemRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
CreditMemoLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
CreditMemoLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
CreditMemoLineUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
CreditMemoLineOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
CreditMemoLineOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
CreditMemoLineRate | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
CreditMemoLineRatePercent | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
CreditMemoLinePriceLevelRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CreditMemoLinePriceLevelRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
CreditMemoLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CreditMemoLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
CreditMemoLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
CreditMemoLineInventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CreditMemoLineInventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
CreditMemoLineInventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CreditMemoLineInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
CreditMemoLineSerialNumber | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
CreditMemoLineLotNumber | 12 | VARCHAR | 40 | True | True | True | False | %s | |
CreditMemoLineTaxAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CreditMemoLineServiceDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
CreditMemoLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CreditMemoLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
CreditMemoLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CreditMemoLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
CreditMemoLineOverrideItemAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CreditMemoLineOverrideItemAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
CustomFieldCreditMemoLineOther1 | 12 | VARCHAR | 29 | True | True | True | False | %s | |
CustomFieldCreditMemoLineOther2 | 12 | VARCHAR | 29 | True | True | True | False | %s | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.6f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
FQTxnLinkKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CreditMemoLinkedTxn
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CustomerRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
CustomerRefFullName | 12 | VARCHAR | 209 | True | False | False | True | %s | Yes |
ClassRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ClassRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
ARAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ARAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
TemplateRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TemplateRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe R X< °ÖeüT à™ ‘T | |
RefNumber | 12 | VARCHAR | 11 | True | False | False | False | %s | |
BillAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillAddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillAddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
BillAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillAddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
ShipAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
ShipAddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
ShipAddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
ShipAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
ShipAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
ShipAddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
IsPending | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
PONumber | 12 | VARCHAR | 25 | True | False | False | False | %s | |
TermsRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
DueDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
SalesRepRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
SalesRepRefFullName | 12 | VARCHAR | 5 | True | False | False | False | %s | Yes |
FOB | 12 | VARCHAR | 13 | True | False | False | False | %s | |
ShipDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
ShipMethodRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ShipMethodRefFullName | 12 | VARCHAR | 15 | True | False | False | False | %s | Yes |
Subtotal | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
SalesTaxPercentage | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
SalesTaxTotal | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
TotalAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CreditRemaining | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 101 | True | False | False | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
CustomerMsgRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CustomerMsgRefFullName | 12 | VARCHAR | 101 | True | False | False | False | %s | Yes |
IsToBePrinted | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
IsToBeEmailed | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
IsTaxIncluded | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
CustomerSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CustomerSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
CustomerTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CustomerTaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
CustomFieldOther | 12 | VARCHAR | 29 | True | False | False | False | %s | |
LinkedTxnSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
LinkedTxnTxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
LinkedTxnTxnType | 12 | VARCHAR | 21 | True | False | False | False | Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjusÃÝoNþK vÉ Ðþø ÄÛ…T ÄÛ…T Ðþø HÄÛ…T HÄÛ…T ž Ÿ ž Ÿ Ðþø | |
LinkedTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
LinkedTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
LinkedTxnAmount | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax1Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
Tax2Total | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.6f | |
AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Currency
(UK VERSION)
TABLE DETAIL REFERENCE: Customer
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
Name | 12 | VARCHAR | 41 | True | True | True | True | %s | |
FullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
IsActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
ClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ClassRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ParentRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
ParentRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | |
Sublevel | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CompanyName | 12 | VARCHAR | 41 | True | True | True | False | %s | |
Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
MiddleName | 12 | VARCHAR | 5 | True | True | True | False | %s | |
LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
JobTitle | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
BillAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
ShipAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
12 | VARCHAR | 1023 | True | True | True | False | %s | ||
Cc | 12 | VARCHAR | 1023 | True | True | True | False | %s | |
Contact | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AltContact | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CustomerTypeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CustomerTypeRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SalesRepRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesRepRefFullName | 12 | VARCHAR | 5 | True | True | True | False | %s | Yes |
Balance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
TotalBalance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenBalance | 3 | DECIMAL | 15 | True | False | True | False | %10.2f | |
OpenBalanceDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SalesTaxCountry | 12 | VARCHAR | 31 | True | True | True | False | Australia Canada UK | |
ResaleNumber | 12 | VARCHAR | 15 | True | True | True | False | %s | |
AccountNumber | 12 | VARCHAR | 99 | True | True | True | False | %s | |
BusinessNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
CreditLimit | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
PreferredPaymentMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PreferredPaymentMethodRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
CreditCardInfoCreditCardNumber | 12 | VARCHAR | 25 | True | True | True | False | %s | |
CreditCardInfoExpirationMonth | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardInfoExpirationYear | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardInfoNameOnCard | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CreditCardInfoCreditCardAddress | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CreditCardInfoCreditCardPostalCode | 12 | VARCHAR | 41 | True | True | True | False | %s | |
JobStatus | 12 | VARCHAR | 10 | True | True | True | False | None Pending Awarded InProgress Closed NotAwarded | |
JobStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
JobProjectedEndDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
JobEndDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
JobDesc | 12 | VARCHAR | 99 | True | True | True | False | %s | |
JobTypeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
JobTypeRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
Notes | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
PreferredDeliveryMethod | 12 | VARCHAR | 10 | True | True | True | True | None Fax | |
IsUsingCustomerTaxCode | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
PriceLevelRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PriceLevelRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ExternalGUID | 12 | VARCHAR | 40 | True | False | True | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} | |
TaxRegistrationNumber | 12 | VARCHAR | 30 | True | True | True | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 64 | True | True | True | False | %s | Yes |
TABLE DETAIL REFERENCE: CustomerAddtionalNote
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
Name | 12 | VARCHAR | 41 | True | True | True | True | %s | |
FullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
IsActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
ClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ClassRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ParentRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
ParentRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | |
Sublevel | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CompanyName | 12 | VARCHAR | 41 | True | True | True | False | %s | |
Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
MiddleName | 12 | VARCHAR | 5 | True | True | True | False | %s | |
LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
JobTitle | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
BillAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
ShipAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
12 | VARCHAR | 1023 | True | True | True | False | %s | ||
Cc | 12 | VARCHAR | 1023 | True | True | True | False | %s | |
Contact | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AltContact | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CustomerTypeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CustomerTypeRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SalesRepRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesRepRefFullName | 12 | VARCHAR | 5 | True | True | True | False | %s | Yes |
Balance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
TotalBalance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenBalance | 3 | DECIMAL | 15 | True | False | True | False | %10.2f | |
OpenBalanceDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SalesTaxCountry | 12 | VARCHAR | 31 | True | True | True | False | Australia Canada UK | |
ResaleNumber | 12 | VARCHAR | 15 | True | True | True | False | %s | |
AccountNumber | 12 | VARCHAR | 99 | True | True | True | False | %s | |
BusinessNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
CreditLimit | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
PreferredPaymentMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PreferredPaymentMethodRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
CreditCardInfoCreditCardNumber | 12 | VARCHAR | 25 | True | True | True | False | %s | |
CreditCardInfoExpirationMonth | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardInfoExpirationYear | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardInfoNameOnCard | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CreditCardInfoCreditCardAddress | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CreditCardInfoCreditCardPostalCode | 12 | VARCHAR | 41 | True | True | True | False | %s | |
JobStatus | 12 | VARCHAR | 10 | True | True | True | False | None Pending Awarded InProgress Closed NotAwarded | |
JobStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
JobProjectedEndDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
JobEndDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
JobDesc | 12 | VARCHAR | 99 | True | True | True | False | %s | |
JobTypeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
JobTypeRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
Notes | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
AdditionalNotesRetNoteID | 4 | INTEGER | 4 | True | True | False | False | %11.0f | |
AdditionalNotesRetDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
AdditionalNotesRetNote | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
PreferredDeliveryMethod | 12 | VARCHAR | 10 | True | True | True | True | None Fax | |
IsUsingCustomerTaxCode | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
PriceLevelRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PriceLevelRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ExternalGUID | 12 | VARCHAR | 40 | True | False | True | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} | |
TaxRegistrationNumber | 12 | VARCHAR | 30 | True | True | True | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 64 | True | True | True | False | %s | Yes |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CustomerContacts
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
Name | 12 | VARCHAR | 41 | True | True | True | True | %s | |
FullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
IsActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
ClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ClassRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | Yes |
ParentRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
ParentRefFullName | 12 | VARCHAR | 209 | True | True | True | False | %s | |
Sublevel | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CompanyName | 12 | VARCHAR | 41 | True | True | True | False | %s | |
Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
MiddleName | 12 | VARCHAR | 5 | True | True | True | False | %s | |
LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
JobTitle | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
BillAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
BillAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
BillAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
BillAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
ShipAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
ShipAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
ShipAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
12 | VARCHAR | 1023 | True | True | True | False | %s | ||
Cc | 12 | VARCHAR | 1023 | True | True | True | False | %s | |
Contact | 12 | VARCHAR | 41 | True | True | True | False | %s | |
AltContact | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ContactsRetListID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
ContactsRetTimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | %s | |
ContactsRetTimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | %s | |
ContactsRetEditSequence | 12 | VARCHAR | 16 | True | True | False | False | %s | |
ContactsRetSalutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
ContactsRetFirstName | 12 | VARCHAR | 25 | True | True | True | True | %s | |
ContactsRetMiddleName | 12 | VARCHAR | 5 | True | True | True | False | %s | |
ContactsRetLastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
ContactsRetJobTitle | 12 | VARCHAR | 41 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef1ContactName | 12 | VARCHAR | 40 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef1ContactValue | 12 | VARCHAR | 255 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef2ContactName | 12 | VARCHAR | 40 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef2ContactValue | 12 | VARCHAR | 255 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef3ContactName | 12 | VARCHAR | 40 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef3ContactValue | 12 | VARCHAR | 255 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef4ContactName | 12 | VARCHAR | 40 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef4ContactValue | 12 | VARCHAR | 255 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef5ContactName | 12 | VARCHAR | 40 | True | True | True | False | %s | |
ContactsRetAdditionalContactRef5ContactValue | 12 | VARCHAR | 255 | True | True | True | False | %s | |
CustomerTypeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CustomerTypeRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SalesRepRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesRepRefFullName | 12 | VARCHAR | 5 | True | True | True | False | %s | Yes |
Balance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
TotalBalance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenBalance | 3 | DECIMAL | 15 | True | False | True | False | %10.2f | |
OpenBalanceDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
SalesTaxCountry | 12 | VARCHAR | 31 | True | True | True | False | Australia Canada UK | |
ResaleNumber | 12 | VARCHAR | 15 | True | True | True | False | %s | |
AccountNumber | 12 | VARCHAR | 99 | True | True | True | False | %s | |
BusinessNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
CreditLimit | 3 | DECIMAL | 15 | True | True | True | False | %10.2f | |
PreferredPaymentMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PreferredPaymentMethodRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
CreditCardInfoCreditCardNumber | 12 | VARCHAR | 25 | True | True | True | False | %s | |
CreditCardInfoExpirationMonth | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardInfoExpirationYear | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardInfoNameOnCard | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CreditCardInfoCreditCardAddress | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CreditCardInfoCreditCardPostalCode | 12 | VARCHAR | 41 | True | True | True | False | %s | |
JobStatus | 12 | VARCHAR | 10 | True | True | True | False | None Pending Awarded InProgress Closed NotAwarded | |
JobStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
JobProjectedEndDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
JobEndDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
JobDesc | 12 | VARCHAR | 99 | True | True | True | False | %s | |
JobTypeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
JobTypeRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
Notes | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
PreferredDeliveryMethod | 12 | VARCHAR | 10 | True | True | True | True | None Fax | |
IsUsingCustomerTaxCode | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
PriceLevelRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PriceLevelRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
ExternalGUID | 12 | VARCHAR | 40 | True | False | True | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} | |
TaxRegistrationNumber | 12 | VARCHAR | 30 | True | True | True | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 64 | True | True | True | False | %s | Yes |
FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CustomerMsg
(UK VERSION)
TABLE DETAIL REFERENCE: CustomerShipToAddress
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
Name | 12 | VARCHAR | 41 | True | False | False | True | %s | |
FullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
IsActive | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
ClassRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ClassRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | Yes |
ParentRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
ParentRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
Sublevel | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CompanyName | 12 | VARCHAR | 41 | True | False | False | False | %s | |
Salutation | 12 | VARCHAR | 15 | True | False | False | False | %s | |
FirstName | 12 | VARCHAR | 25 | True | False | False | False | %s | |
MiddleName | 12 | VARCHAR | 5 | True | False | False | False | %s | |
LastName | 12 | VARCHAR | 25 | True | False | False | False | %s | |
JobTitle | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillAddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillAddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
BillAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
BillAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
BillAddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
BillAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
ShipAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
ShipAddressProvince | 12 | VARCHAR | 21 | True | False | False | False | %s | |
ShipAddressCounty | 12 | VARCHAR | 21 | True | False | False | False | %s | |
ShipAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
ShipAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
ShipAddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipToAddressName | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipToAddressAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipToAddressAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipToAddressAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipToAddressAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipToAddressAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipToAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
ShipToAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
ShipToAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
ShipToAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
ShipToAddressNote | 12 | VARCHAR | 41 | True | False | False | False | %s | |
ShipToAddressDefaultShipTo | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
Phone | 12 | VARCHAR | 21 | True | False | False | False | %s | |
AltPhone | 12 | VARCHAR | 21 | True | False | False | False | %s | |
Fax | 12 | VARCHAR | 21 | True | False | False | False | %s | |
12 | VARCHAR | 1023 | True | False | False | False | %s | ||
Cc | 12 | VARCHAR | 1023 | True | False | False | False | %s | |
Contact | 12 | VARCHAR | 41 | True | False | False | False | %s | |
AltContact | 12 | VARCHAR | 41 | True | False | False | False | %s | |
CustomerTypeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CustomerTypeRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
TermsRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TermsRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
SalesRepRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
SalesRepRefFullName | 12 | VARCHAR | 5 | True | False | False | False | %s | Yes |
Balance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
TotalBalance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenBalance | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
OpenBalanceDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
TaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
TaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
SalesTaxCountry | 12 | VARCHAR | 31 | True | False | False | False | Australia Canada UK | |
ResaleNumber | 12 | VARCHAR | 15 | True | False | False | False | %s | |
AccountNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
BusinessNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
CreditLimit | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
PreferredPaymentMethodRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
PreferredPaymentMethodRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
CreditCardInfoCreditCardNumber | 12 | VARCHAR | 25 | True | False | False | False | %s | |
CreditCardInfoExpirationMonth | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CreditCardInfoExpirationYear | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
CreditCardInfoNameOnCard | 12 | VARCHAR | 41 | True | False | False | False | %s | |
CreditCardInfoCreditCardAddress | 12 | VARCHAR | 41 | True | False | False | False | %s | |
CreditCardInfoCreditCardPostalCode | 12 | VARCHAR | 41 | True | False | False | False | %s | |
JobStatus | 12 | VARCHAR | 10 | True | False | False | False | None Pending Awarded InProgress Closed NotAwarded | |
JobStartDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
JobProjectedEndDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
JobEndDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
JobDesc | 12 | VARCHAR | 99 | True | False | False | False | %s | |
JobTypeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
JobTypeRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
Notes | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
PreferredDeliveryMethod | 12 | VARCHAR | 10 | True | False | False | True | None Fax | |
IsUsingCustomerTaxCode | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
PriceLevelRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
PriceLevelRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
ExternalGUID | 12 | VARCHAR | 40 | True | False | False | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} | |
TaxRegistrationNumber | 12 | VARCHAR | 30 | True | False | False | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} | |
CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | Yes |
FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CustomerType
(UK VERSION)