TABLE DETAIL REFERENCE: DepositAppliedToTxn
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DocNumber12 VARCHAR 21TrueFalseFalseFalse%s
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxInclusive
NotApplicable
TransactionLocationType12 VARCHAR 32TrueFalseFalseFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU
PrivateNote12 VARCHAR 4000TrueFalseFalseFalse%s
TxnStatus12 VARCHAR 13TrueFalseFalseFalse
Draft
Overdue
Pending
Payable
Paid
Trash
Unpaid
DepositToAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
CashBackAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CashBackAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CashBackAmount12 VARCHAR 21TrueFalseFalseFalse%s
CashBackMemo12 VARCHAR 21TrueFalseFalseFalse%s
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
HomeTotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
DepositAppliedToTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
DepositAppliedToTxnTxnType12 VARCHAR 32TrueFalseFalseFalse
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
DepositAppliedToTxnTxnLineID12 VARCHAR 36TrueFalseFalseFalse%s
TaxDetailDefaultTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxDetailDefaultTaxCodeRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
TaxDetailTxnTaxCodeRef12 VARCHAR 11TrueFalseFalseFalse%8.2f
TaxDetailTotalTax3 DECIMAL 13TrueFalseFalseFalse%10.7f
TaxDetailReviewStatus12 VARCHAR 11TrueFalseFalseFalse
Billable
NotBillable
HasBeenBill
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey