TABLE DETAIL REFERENCE: VendorCreditLinkedTxn
(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
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VendorRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
VendorRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 16TrueFalseFalseFalse%11.7f
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
CreditAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
CreditAmountInHomeCurrency3 DECIMAL 13TrueFalseFalseFalse%11.2f
RefNumber12 VARCHAR 21TrueFalseFalseFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxIncluded
NotApplicable
LinkedTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
LinkedTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
LinkedTxnTxnType12 VARCHAR 21TrueFalseFalseFalse
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
LinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnRefNumber12 VARCHAR 21TrueFalseFalseFalse%s
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey