TABLE DETAIL REFERENCE: DepositAttachable
(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
AttachableRefListID12 VARCHAR 36TrueFalseFalseFalse%s
AttachableRefEntityRefListID12 VARCHAR 36TrueFalseFalseFalse%s
AttachableRefEntityRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s
AttachableRefLineInfo12 VARCHAR 4000TrueFalseFalseFalse%s
AttachableRefIncludeOnSend-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AttachableRefInactive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AttachableRefNoRefOnly-7 BIT 1TrueFalseFalseFalse
1
0
true
false
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