TABLE DETAIL REFERENCE: DepositAppliedToTxn
(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 | False | False | False | CCCC-MM-DD | |
| DocNumber | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| DepartmentRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| DepartmentRefFullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | Yes |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | Yes |
| ExchangeRate | 3 | DECIMAL | 13 | True | False | False | False | %11.7f | |
| GlobalTaxCalculation | 12 | VARCHAR | 15 | True | False | False | False | TaxExcluded TaxInclusive NotApplicable | |
| TransactionLocationType | 12 | VARCHAR | 32 | True | False | False | False | WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU | |
| PrivateNote | 12 | VARCHAR | 4000 | True | False | False | False | %s | |
| TxnStatus | 12 | VARCHAR | 13 | True | False | False | False | Draft Overdue Pending Payable Paid Trash Unpaid | |
| DepositToAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| DepositToAccountRefFullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | Yes |
| TxnSource | 12 | VARCHAR | 100 | True | False | False | False | %s | |
| CashBackAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CashBackAccountRefFullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | Yes |
| CashBackAmount | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| CashBackMemo | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| TotalAmt | 3 | DECIMAL | 13 | True | False | False | False | %11.2f | |
| HomeTotalAmt | 3 | DECIMAL | 13 | True | False | False | False | %11.2f | |
| DepositAppliedToTxnTxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| DepositAppliedToTxnTxnType | 12 | VARCHAR | 32 | True | False | False | 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 | |
| DepositAppliedToTxnTxnLineID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TaxDetailDefaultTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TaxDetailDefaultTaxCodeRefFullName | 12 | VARCHAR | 100 | True | False | False | False | %s | Yes |
| TaxDetailTxnTaxCodeRef | 12 | VARCHAR | 11 | True | False | False | False | %8.2f | |
| TaxDetailTotalTax | 3 | DECIMAL | 13 | True | False | False | False | %10.7f | |
| TaxDetailReviewStatus | 12 | VARCHAR | 11 | True | False | False | False | Billable NotBillable HasBeenBill | |
| FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey |