TABLE DETAIL REFERENCE: Account
(Australia ,New Zealand,Singapore Southeast Asia 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~õn,~ | |
| SpecialAccountType | 12 | VARCHAR | 30 | True | False | False | False | AccountsPayable AccountsReceivable CondenseItemAdjustmentExpenses CostOfGoodsSold DirectDepositLiabilities Estimates InventoryAssets OpeningBalanceEquity PayrollExpenses PayrollLiabilities PettyCash P~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn | |
| 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 | 13 | True | False | False | False | %8.2f | |
| TotalBalance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| OpenBalance | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 6 | True | False | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | True | False | True | False | %s | Yes |
| TaxLineInfoRetTaxLineID | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| TaxLineInfoRetTaxLineName | 12 | VARCHAR | 256 | True | False | False | False | %s | |
| CashFlowClassification | 12 | VARCHAR | 13 | True | False | False | False | None Operating Investing Financing NotApplicable | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s |
TABLE DETAIL REFERENCE: ARRefundCreditCard
(Australia ,New Zealand,Singapore Southeast Asia 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 e t u r n R o w s N o n Z e r o A l l T a x Y e a r t e r T o t a l O n l y T w o W e e k | |
| RefNumber | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| TotalAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | |
| 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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| RefNumber | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| TotalAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | |
| 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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| RefundAppliedToTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| RefundAppliedToTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| RefundAppliedToTxnRefCreditRemaining | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| RefundAppliedToTxnRefRefundAmount | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BarCode
(Australia ,New Zealand,Singapore Southeast Asia 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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| AmountDue | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| 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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| OpenAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | False | 1 0 true false |
TABLE DETAIL REFERENCE: BillExpenseLine
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| AmountDue | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| 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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | True | True | False | %8.2f | |
| ExpenseLineTaxAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ExpenseLineTax1Amount | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| ExpenseLineTaxCodeRefFullName | 12 | VARCHAR | 6 | True | True | True | False | %s | Yes |
| ExpenseLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| OpenAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | 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
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
TABLE DETAIL REFERENCE: BillingRateLine
(Australia ,New Zealand,Singapore Southeast Asia 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 | 16 | True | False | True | False | %8.5f | |
| BillingRateLineItemRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
| BillingRateLineItemRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
| BillingRateLineCustomRate | 3 | DECIMAL | 16 | True | False | True | False | %8.5f | |
| BillingRateLineCustomRatePercent | 3 | DECIMAL | 15 | True | False | True | False | %7.5f | |
| BillingRateLineAdjustPercentage | 3 | DECIMAL | 15 | True | False | True | False | %7.5f | |
| BillingRateLineAdjustBillingRateRelativeTo | 12 | VARCHAR | 9 | True | False | True | False | StandardRate CurrentCustomRate | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillItemLine
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| AmountDue | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| 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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 16 | True | True | True | False | %8.5f | |
| ItemGroupLineTotalAmount | 3 | DECIMAL | 16 | True | False | False | False | %8.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 |
| ItemLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| ItemLineQuantity | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| ItemLineCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| ItemLineAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ItemLineTaxAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ItemLineTax1Amount | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| ItemLineTaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| OpenAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | 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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| DueDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| AmountDue | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| 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 | 6 | True | False | False | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| 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 | 13 | True | False | False | False | %8.2f | |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| OpenAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| BankAccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
| BankAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
| Amount | 3 | DECIMAL | 13 | True | True | False | False | %8.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.8f | |
| AmountInHomeCurrency | 3 | DECIMAL | 13 | True | True | False | False | %8.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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| BankAccountRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
| BankAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | True | %s | Yes |
| Amount | 3 | DECIMAL | 13 | True | True | False | False | %8.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.8f | |
| AmountInHomeCurrency | 3 | DECIMAL | 13 | True | True | False | False | %8.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 | 13 | True | True | True | False | %8.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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| AppliedToTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| AppliedToTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| AppliedToTxnBalanceRemaining | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| AppliedToTxnAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| AppliedToTxnSetCreditCreditTxnID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| AppliedToTxnSetCreditAppliedAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| AppliedToTxnDiscountAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| BankAccountRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
| BankAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.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.8f | |
| AmountInHomeCurrency | 3 | DECIMAL | 13 | True | False | False | False | %8.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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| 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 | 13 | True | False | False | False | %8.2f | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillPaymentCreditCard
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| CreditCardAccountRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
| CreditCardAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| RefNumber | 12 | VARCHAR | 11 | True | False | True | True | %s | |
| Memo | 12 | VARCHAR | 4095 | True | False | True | False | %s |
TABLE DETAIL REFERENCE: BillPaymentCreditCardLine
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| CreditCardAccountRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
| CreditCardAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 13 | True | False | True | False | %8.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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| AppliedToTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| AppliedToTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| AppliedToTxnBalanceRemaining | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| AppliedToTxnAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| AppliedToTxnSetCreditCreditTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| AppliedToTxnSetCreditAppliedAmount | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
| AppliedToTxnDiscountAmount | 3 | DECIMAL | 13 | True | False | True | False | %8.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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| CreditCardAccountRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
| CreditCardAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| 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 | 13 | True | False | False | False | %8.2f | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BillToPay
(Australia ,New Zealand,Singapore Southeast Asia 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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| 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 | 13 | True | False | False | False | %8.2f | |
| BillToPayCurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| BillToPayCurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| 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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| 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 | 13 | True | False | False | False | %8.2f | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: BuildAssembly
(Australia ,New Zealand,Singapore Southeast Asia 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 |
| 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| 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 | 16 | True | True | True | True | %8.5f | |
| QuantityCanBuild | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| QuantityOnHand | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| QuantityOnSalesOrder | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| RemovePending | -7 | BIT | 1 | True | True | False | False | 1 0 true false |
TABLE DETAIL REFERENCE: BuildAssemblyComponentItemLine
(Australia ,New Zealand,Singapore Southeast Asia 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 |
| 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| 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 | 16 | True | True | True | True | %8.5f | |
| QuantityCanBuild | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| QuantityOnHand | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| QuantityOnSalesOrder | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| 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 |
| ComponentItemLineDesc | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
| ComponentItemLineQuantityOnHand | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| ComponentItemLineQuantityNeeded | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Charge
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| 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 |
| Quantity | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| Rate | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| Amount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| BalanceRemaining | 3 | DECIMAL | 13 | True | False | False | False | %8.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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| 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 |
| Quantity | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| Rate | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| BalanceRemaining | 3 | DECIMAL | 13 | True | False | False | False | %8.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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| 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 | 13 | True | False | False | False | %8.2f | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Check
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | True | True | True | False | %s | Yes |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | False | 1 0 true false |
TABLE DETAIL REFERENCE: CheckExpenseLine
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | True | True | False | %8.2f | |
| ExpenseLineTaxAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ExpenseLineTax1Amount | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| ExpenseLineTaxCodeRefFullName | 12 | VARCHAR | 6 | True | True | True | False | %s | Yes |
| ExpenseLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | 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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 16 | True | True | True | False | %8.5f | |
| ItemGroupLineTotalAmount | 3 | DECIMAL | 16 | True | False | False | False | %8.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 |
| ItemLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| ItemLineQuantity | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| ItemLineCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| ItemLineAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ItemLineTaxAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ItemLineTax1Amount | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| ItemLineTaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | 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
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
TABLE DETAIL REFERENCE: ClearedStatus
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
TABLE DETAIL REFERENCE: Company
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
TABLE DETAIL REFERENCE: CompanyActivity
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
TABLE DETAIL REFERENCE: CreditCardCharge
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
| 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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | True | True | True | False | %s | Yes |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | False | 1 0 true false |
TABLE DETAIL REFERENCE: CreditCardChargeExpenseLine
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
| 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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | True | True | False | %8.2f | |
| ExpenseLineTaxAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ExpenseLineTax1Amount | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| ExpenseLineTaxCodeRefFullName | 12 | VARCHAR | 6 | True | True | True | False | %s | Yes |
| ExpenseLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | 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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | True | %s | Yes |
| 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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 16 | True | True | True | False | %8.5f | |
| ItemGroupLineTotalAmount | 3 | DECIMAL | 16 | True | False | True | False | %8.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 |
| ItemLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| ItemLineQuantity | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| ItemLineCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| ItemLineAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ItemLineTaxAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ItemLineTax1Amount | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| ItemLineTaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | 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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
| Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | False | 1 0 true false |
TABLE DETAIL REFERENCE: CreditCardCreditExpenseLine
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 13 | True | True | True | False | %8.2f | |
| ExpenseLineTaxAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ExpenseLineTax1Amount | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| ExpenseLineTaxCodeRefFullName | 12 | VARCHAR | 6 | True | True | True | False | %s | Yes |
| ExpenseLineBillableStatus | 12 | VARCHAR | 13 | True | True | True | False | Billable NotBillable HasBeenBilled | |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | 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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| Amount | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 16 | True | True | False | False | %8.5f | |
| ItemGroupLineTotalAmount | 3 | DECIMAL | 16 | True | False | False | False | %8.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 |
| ItemLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| ItemLineQuantity | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| ItemLineCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| ItemLineAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ItemLineTaxAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.2f | |
| ItemLineTax1Amount | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | 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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| 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 | 13 | True | False | False | False | %8.2f | |
| ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| SalesTaxPercentage | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
| SalesTaxTotal | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| TotalAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CreditRemaining | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| CustomerTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CustomerTaxCodeRefFullName | 12 | VARCHAR | 6 | True | True | True | False | %s | Yes |
| CustomFieldOther | 12 | VARCHAR | 29 | True | True | True | False | %s | |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | False | 1 0 true false |
TABLE DETAIL REFERENCE: CreditMemoLine
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| 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 | 13 | True | False | False | False | %8.2f | |
| ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| SalesTaxPercentage | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
| SalesTaxTotal | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| TotalAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CreditRemaining | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| CustomerTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CustomerTaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 16 | True | True | True | False | %8.5f | |
| CreditMemoLineGroupIsPrintItemsInGroup | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| CreditMemoLineGroupTotalAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CreditMemoLineGroupServiceDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| CreditMemoLineGroupSeqNo | 4 | INTEGER | 4 | True | False | False | False | 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 | 16 | True | True | True | False | %8.5f | |
| CreditMemoLineRate | 3 | DECIMAL | 16 | True | True | True | False | %8.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 | 13 | True | True | True | False | %8.2f | |
| CreditMemoLineTaxAmount | 3 | DECIMAL | 13 | True | True | True | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| CreditMemoLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CreditMemoLineTaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | True | True | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | True | True | 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
(Australia ,New Zealand,Singapore Southeast Asia 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| 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 | 13 | True | False | False | False | %8.2f | |
| ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
| SalesTaxPercentage | 3 | DECIMAL | 15 | True | False | False | False | %7.5f | |
| SalesTaxTotal | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| TotalAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CreditRemaining | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 6 | True | False | False | False | %s | Yes |
| CustomerTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CustomerTaxCodeRefFullName | 12 | VARCHAR | 6 | 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~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn _ €±” ¸P” | |
| LinkedTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| LinkedTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| LinkedTxnAmount | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax1Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| Tax2Total | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| ExchangeRate | 3 | DECIMAL | 15 | True | False | False | False | %6.8f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Customer
(Australia ,New Zealand,Singapore Southeast Asia 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 | |
| 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 | ||
| 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 | 13 | True | False | False | False | %8.2f | |
| TotalBalance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| OpenBalance | 3 | DECIMAL | 13 | True | False | True | False | %8.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 | 6 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | True | True | False | %8.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 | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | |
| 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 |
TABLE DETAIL REFERENCE: CustomerMsg
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
TABLE DETAIL REFERENCE: CustomerShipToAddress
(Australia ,New Zealand,Singapore Southeast Asia 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 | |
| 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 | ||
| 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 | 13 | True | False | False | False | %8.2f | |
| TotalBalance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| OpenBalance | 3 | DECIMAL | 13 | True | False | False | False | %8.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 | 6 | True | False | False | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 6 | 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 | 13 | True | False | False | False | %8.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 | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | |
| 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 |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: CustomerType
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
TABLE DETAIL REFERENCE: CustomField
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| OwnerID | 12 | VARCHAR | 50 | True | False | True | True | %s | |
| Name | 12 | VARCHAR | 31 | True | False | True | True | %s | |
| EntityType | 12 | VARCHAR | 23 | True | False | True | False | Customer Vendor Employee OtherName Item Account | |
| EntityRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
| EntityRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
| TxnType | 12 | VARCHAR | 23 | True | False | True | False | Bill BillPaymentCheck BillPaymentCreditCard Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry PurchaseOrder ReceivePayment~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn | |
| TxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| TxnLineID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| OtherType | 12 | VARCHAR | 7 | True | False | True | False | Company | |
| Value | 12 | VARCHAR | 4095 | True | False | True | True |
TABLE DETAIL REFERENCE: DateDrivenTerms
(Australia ,New Zealand,Singapore Southeast Asia 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 | 31 | True | False | True | True | %s | |
| IsActive | -7 | BIT | 1 | True | False | True | False | 1 0 true false | |
| DayOfMonthDue | 4 | INTEGER | 4 | True | False | True | True | %11.0f | |
| DueNextMonthDays | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
| DiscountDayOfMonth | 4 | INTEGER | 4 | True | False | True | False | %11.0f | |
| DiscountPct | 3 | DECIMAL | 15 | True | False | True | False | %7.5f |
TABLE DETAIL REFERENCE: Deposit
(Australia ,New Zealand,Singapore Southeast Asia 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 | |
| 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| DepositToAccountRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
| DepositToAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
| Memo | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
| DepositTotal | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
| CashBackInfoTxnLineID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CashBackInfoAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
| CashBackInfoAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
| CashBackInfoMemo | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
| CashBackInfoAmount | 3 | DECIMAL | 13 | True | False | True | False | %8.2f |
TABLE DETAIL REFERENCE: DepositLine
(Australia ,New Zealand,Singapore Southeast Asia 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 | |
| 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 l i t i e s E s t i m a t e s I n v e n t o r y A s s e t s O p e n i n g B a l a n c e E q u i t y P a y r o l l E x p e n s e s P a y r o l l L i a b i l i t i e s P e t t y C a s h P ~ õ n , ~ õ n ) ) ? _ ¸ " x ¬ ± d L k w õ n Ì õ n Ü õ n | |
| DepositToAccountRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
| DepositToAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
| Memo | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
| DepositTotal | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
| CashBackInfoTxnLineID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CashBackInfoAccountRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
| CashBackInfoAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
| CashBackInfoMemo | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
| CashBackInfoAmount | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
| DepositLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
| DepositLineTxnType | 12 | VARCHAR | 22 | True | False | False | False | Bill BillPaymentCheck BillPaymentCreditCard Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate Invoice InventoryAdjustment JournalEntry LiabilityAdjustment PurchaseOrder Receiv~õn,~õn) )?_ ¸"Ÿ €±” dLkw õnÌõn Üõn | |
| DepositLineTxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| DepositLineTxnLineID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| DepositLinePaymentTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| DepositLinePaymentTxnLineID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| DepositLineEntityRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
| DepositLineEntityRefFullName | 12 | VARCHAR | 209 | True | False | True | False | %s | Yes |
| DepositLineAccountRefListID | 12 | VARCHAR | 36 | True | False | True | True | %s | Yes |
| DepositLineAccountRefFullName | 12 | VARCHAR | 159 | True | False | True | True | %s | Yes |
| DepositLineMemo | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
| DepositLineCheckNumber | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| DepositLinePaymentMethodRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
| DepositLinePaymentMethodRefFullName | 12 | VARCHAR | 31 | True | False | True | False | %s | Yes |
| DepositLineClassRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
| DepositLineClassRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
| DepositLineAmount | 3 | DECIMAL | 13 | True | False | True | False | %8.2f | |
| FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Employee
(Australia ,New Zealand,Singapore Southeast Asia 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 | False | %s | |
| IsActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
| FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| MiddleName | 12 | VARCHAR | 5 | True | True | True | False | %s | |
| LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| JobTitle | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| EmployeeAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| PrintAs | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Mobile | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Pager | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| PagerPIN | 12 | VARCHAR | 10 | True | True | True | False | %s | |
| AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| SSN | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| SIN | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| NiNumber | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| MaritalStatus | 12 | VARCHAR | 6 | True | False | False | False | Single Married | |
| 12 | VARCHAR | 1023 | True | True | True | False | %s | ||
| EmployeeType | 12 | VARCHAR | 9 | True | False | True | False | Regular Officer Statutory Owner | |
| Gender | 12 | VARCHAR | 6 | True | False | True | False | Female Male | |
| Sex | 12 | VARCHAR | 6 | True | False | True | False | Female Male | |
| HiredDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| ReleasedDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| BirthDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| AccountNumber | 12 | VARCHAR | 99 | True | True | True | False | %s | |
| Notes | 12 | VARCHAR | 4096 | True | True | True | False | %s | |
| BillingRateRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| BillingRateRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| PayrollInfoPayPeriod | 12 | VARCHAR | 11 | True | True | True | False | Daily Weekly Biweekly Semimonthly Monthly Quarterly Yearly | |
| PayrollInfoClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PayrollInfoClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| PayrollInfoUseTimeDataToCreatePaychecks | 12 | VARCHAR | 16 | True | True | True | False | NotSet UseTimeData DoNotUseTimeData | |
| PayrollInfoSickHoursHoursAvailable | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursAccrualPeriod | 12 | VARCHAR | 19 | True | True | True | False | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoSickHoursHoursAccrued | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursMaximumHours | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursIsResettingHoursEachNewYear | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PayrollInfoSickHoursHoursUsed | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursAccrualStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| PayrollInfoVacationHoursHoursAvailable | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualPeriod | 12 | VARCHAR | 19 | True | True | True | False | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoVacationHoursHoursAccrued | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursMaximumHours | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursIsResetHoursEachNewYear | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PayrollInfoVacationHoursHoursUsed | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD |
TABLE DETAIL REFERENCE: EmployeeAddtionalNote
(Australia ,New Zealand,Singapore Southeast Asia 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 | False | %s | |
| IsActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
| FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| MiddleName | 12 | VARCHAR | 5 | True | True | True | False | %s | |
| LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| JobTitle | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| EmployeeAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| PrintAs | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Mobile | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Pager | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| PagerPIN | 12 | VARCHAR | 10 | True | True | True | False | %s | |
| AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| SSN | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| SIN | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| NiNumber | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| MaritalStatus | 12 | VARCHAR | 6 | True | False | False | False | Single Married | |
| 12 | VARCHAR | 1023 | True | True | True | False | %s | ||
| EmployeeType | 12 | VARCHAR | 9 | True | False | True | False | Regular Officer Statutory Owner | |
| Gender | 12 | VARCHAR | 6 | True | False | True | False | Female Male | |
| Sex | 12 | VARCHAR | 6 | True | False | True | False | Female Male | |
| HiredDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| ReleasedDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| BirthDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| AccountNumber | 12 | VARCHAR | 99 | True | True | True | False | %s | |
| Notes | 12 | VARCHAR | 4096 | 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 | |
| BillingRateRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| BillingRateRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| PayrollInfoPayPeriod | 12 | VARCHAR | 11 | True | True | True | False | Daily Weekly Biweekly Semimonthly Monthly Quarterly Yearly | |
| PayrollInfoClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PayrollInfoClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| PayrollInfoUseTimeDataToCreatePaychecks | 12 | VARCHAR | 16 | True | True | True | False | NotSet UseTimeData DoNotUseTimeData | |
| PayrollInfoSickHoursHoursAvailable | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursAccrualPeriod | 12 | VARCHAR | 19 | True | True | True | False | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoSickHoursHoursAccrued | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursMaximumHours | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursIsResettingHoursEachNewYear | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PayrollInfoSickHoursHoursUsed | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursAccrualStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| PayrollInfoVacationHoursHoursAvailable | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualPeriod | 12 | VARCHAR | 19 | True | True | True | False | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoVacationHoursHoursAccrued | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursMaximumHours | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursIsResetHoursEachNewYear | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PayrollInfoVacationHoursHoursUsed | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: EmployeeEarning
(Australia ,New Zealand,Singapore Southeast Asia 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 | False | %s | |
| IsActive | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| Salutation | 12 | VARCHAR | 15 | True | True | True | False | %s | |
| FirstName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| MiddleName | 12 | VARCHAR | 5 | True | True | True | False | %s | |
| LastName | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| JobTitle | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| EmployeeAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| EmployeeAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| EmployeeAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| PrintAs | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| Phone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Mobile | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Pager | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| PagerPIN | 12 | VARCHAR | 10 | True | True | True | False | %s | |
| AltPhone | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Fax | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| SSN | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| SIN | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| NiNumber | 12 | VARCHAR | 11 | True | False | True | False | %s | |
| MaritalStatus | 12 | VARCHAR | 6 | True | False | False | False | Single Married | |
| 12 | VARCHAR | 1023 | True | True | True | False | %s | ||
| EmployeeType | 12 | VARCHAR | 9 | True | False | True | False | Regular Officer Statutory Owner | |
| Gender | 12 | VARCHAR | 6 | True | False | True | False | Female Male | |
| Sex | 12 | VARCHAR | 6 | True | False | True | False | Female Male | |
| HiredDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| ReleasedDate | 9 | DATE | 6 | True | False | True | False | CCCC-MM-DD | |
| BirthDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| AccountNumber | 12 | VARCHAR | 99 | True | True | True | False | %s | |
| Notes | 12 | VARCHAR | 4096 | True | True | True | False | %s | |
| BillingRateRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| BillingRateRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| PayrollInfoPayPeriod | 12 | VARCHAR | 11 | True | True | True | False | Daily Weekly Biweekly Semimonthly Monthly Quarterly Yearly | |
| PayrollInfoClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PayrollInfoClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| PayrollInfoEarningsClearEarnings | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PayrollInfoEarningsSeqNo | 4 | INTEGER | 4 | True | False | False | False | SubSeqNo | |
| PayrollInfoEarningsPayrollItemWageRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| PayrollInfoEarningsPayrollItemWageRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| PayrollInfoEarningsRate | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
| PayrollInfoEarningsRatePercent | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
| PayrollInfoUseTimeDataToCreatePaychecks | 12 | VARCHAR | 16 | True | True | True | False | NotSet UseTimeData DoNotUseTimeData | |
| PayrollInfoSickHoursHoursAvailable | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursAccrualPeriod | 12 | VARCHAR | 19 | True | True | True | False | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoSickHoursHoursAccrued | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursMaximumHours | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursIsResettingHoursEachNewYear | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PayrollInfoSickHoursHoursUsed | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoSickHoursAccrualStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| PayrollInfoVacationHoursHoursAvailable | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualPeriod | 12 | VARCHAR | 19 | True | True | True | False | BeginningOfYear EveryPaycheck EveryHourOnPaycheck | |
| PayrollInfoVacationHoursHoursAccrued | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursMaximumHours | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursIsResetHoursEachNewYear | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| PayrollInfoVacationHoursHoursUsed | 8 | DOUBLE | 8 | True | True | True | False | PTnHnMnS | |
| PayrollInfoVacationHoursAccrualStartDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| FQSaveToCache | -7 | BIT | 1 | True | True | True | False | FQSaveToCache | |
| FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |
TABLE DETAIL REFERENCE: Entity
(Australia ,New Zealand,Singapore Southeast Asia 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 | 209 | True | False | False | False | %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 | |
| ClassRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| 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 | 209 | True | False | False | False | %s | |
| Salutation | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| FirstName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| MiddleName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| LastName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| JobTitle | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr1 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr2 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr3 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr4 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr5 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressCity | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressState | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressPostalCode | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressCountry | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressNote | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr1 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr2 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr3 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr4 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr5 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr1 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr2 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr3 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr4 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr5 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressCity | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressState | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressPostalCode | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressCountry | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressNote | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr1 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr2 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr3 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr4 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr5 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Phone | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| AltPhone | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Fax | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| 12 | VARCHAR | 209 | True | False | False | False | %s | ||
| Cc | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Contact | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| AltContac | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| AdditionalContactRefContactName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| AdditionalContactRefContactValue | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| CustomerTypeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CustomerTypeRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| TermsRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TermsRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| SalesRepRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| SalesRepRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Balance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| TotalBalance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| SalesTaxCodeRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| ItemSalesTaxRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ResaleNumber | 12 | VARCHAR | 15 | True | False | False | False | %s | |
| AccountNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
| CreditLimit | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| PreferredPaymentMethodRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| PreferredPaymentMethodRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| 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 | False | None Fax | |
| PriceLevelRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| PriceLevelRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CurrencyRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Type | 12 | VARCHAR | 20 | True | False | False | False | %s |
TABLE DETAIL REFERENCE: EntityAdditionalNote
(Australia ,New Zealand,Singapore Southeast Asia 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 | 209 | True | False | False | False | %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 | |
| ClassRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| 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 | 209 | True | False | False | False | %s | |
| Salutation | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| FirstName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| MiddleName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| LastName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| JobTitle | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr1 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr2 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr3 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr4 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressAddr5 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressCity | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressState | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressPostalCode | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressCountry | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressNote | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr1 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr2 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr3 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr4 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| BillAddressBlockAddr5 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr1 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr2 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr3 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr4 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressAddr5 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressCity | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressState | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressPostalCode | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressCountry | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressNote | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr1 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr2 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr3 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr4 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ShipAddressBlockAddr5 | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Phone | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| AltPhone | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Fax | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| 12 | VARCHAR | 209 | True | False | False | False | %s | ||
| Cc | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Contact | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| AltContac | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| AdditionalContactRefContactName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| AdditionalContactRefContactValue | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| CustomerTypeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| CustomerTypeRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| TermsRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TermsRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| SalesRepRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| SalesRepRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| Balance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| TotalBalance | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| SalesTaxCodeRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| ItemSalesTaxRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| ResaleNumber | 12 | VARCHAR | 15 | True | False | False | False | %s | |
| AccountNumber | 12 | VARCHAR | 99 | True | False | False | False | %s | |
| CreditLimit | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| PreferredPaymentMethodRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| PreferredPaymentMethodRefFullName | 12 | VARCHAR | 209 | True | False | False | False | %s | |
| 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 |