TABLE DETAIL REFERENCE: DepositLine
(Online VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 10 | True | False | False | False | %s | |
| TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| DocNumber | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| DepartmentRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| DepartmentRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| ExchangeRate | 3 | DECIMAL | 13 | True | True | True | False | %11.7f | |
| GlobalTaxCalculation | 12 | VARCHAR | 15 | True | True | True | False | TaxExcluded TaxInclusive NotApplicable | |
| TransactionLocationType | 12 | VARCHAR | 32 | True | True | True | False | WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU | |
| PrivateNote | 12 | VARCHAR | 4000 | True | True | True | False | %s | |
| TxnStatus | 12 | VARCHAR | 13 | True | True | True | False | Draft Overdue Pending Payable Paid Trash Unpaid | |
| DepositToAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| DepositToAccountRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| TxnSource | 12 | VARCHAR | 100 | True | False | False | False | %s | |
| CashBackAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CashBackAccountRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| CashBackAmount | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| CashBackMemo | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| TotalAmt | 3 | DECIMAL | 13 | True | True | True | False | %11.2f | |
| HomeTotalAmt | 3 | DECIMAL | 13 | True | True | True | False | %11.2f | |
| DepositLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
| DepositLineLineNum | 4 | INTEGER | 4 | True | True | True | False | %s | |
| DepositLineDescription | 12 | VARCHAR | 4000 | True | True | True | False | %s | |
| DepositLineAmount | 3 | DECIMAL | 15 | True | True | True | False | %11.2f | |
| DepositLineDetailType | 12 | VARCHAR | 64 | True | True | True | False | DepositLineDetail | |
| DepositLineIsTaxable | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| DepositLineDetailEntityRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| DepositLineDetailEntityRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| DepositLineDetailClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| DepositLineDetailClassRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| DepositLineDetailAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| DepositLineDetailAccountRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| DepositLineDetailPaymentMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| DepositLineDetailPaymentMethodRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| DepositLineDetailCheckNum | 12 | VARCHAR | 4000 | True | True | True | False | %s | |
| DepositLineDetailTxnType | 12 | VARCHAR | 32 | True | True | True | False | APCreditCard ARRefundCreditCard Bill BillPaymentCheck BuildAssembly CarryOver CashPurchase Charge Check CreditMemo Deposit EFPLiabilityCheck EFTBillPayment EFTRefund Estimate InventoryAdjustment InventoryTransfer Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck Purchase PurchaseOrder PriorPayment ReceivePayment RefundCheck RefundReceipt SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer TimeActivity VendorCredit YTDAdjustment | |
| DepositLineDetailTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| DepositLineDetailTaxCodeRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | Yes |
| AppliedToTxnTxnID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| AppliedToTxnTxnType | 12 | VARCHAR | 32 | True | True | True | False | ARRefundCreditCard Transfer Cash CreditCardCharge CreditCardCredit SalesReceipt RefundReceipt JournalEntry BillPaymentCheck Check ReceivePayment Payment | |
| AppliedToTxnTxnLineID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| TaxDetailDefaultTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxDetailDefaultTaxCodeRefFullName | 12 | VARCHAR | 100 | True | True | True | False | %s | Yes |
| TaxDetailTxnTaxCodeRef | 12 | VARCHAR | 11 | True | True | True | False | %8.2f | |
| TaxDetailTotalTax | 3 | DECIMAL | 13 | True | True | True | False | %10.7f | |
| TaxDetailReviewStatus | 12 | VARCHAR | 11 | True | True | True | False | Billable NotBillable HasBeenBill | |
| FQSaveToCache | -7 | BIT | 1 | True | False | True | False | FQSaveToCache | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | True | False | False | FQPrimaryKey |