TABLE DETAIL REFERENCE: BillPaymentCheckLineLinkedTxn
(UK 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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
PayeeEntityRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueFalseFalseTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYeRX<eTT
BankAccountRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
BankAccountRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.6f
AmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueFalseFalseTrue%s
IsToBePrinted-7 BIT 1TrueFalseFalseTrue
1
0
true
false
Memo12 VARCHAR 4095TrueFalseFalseFalse%s
AddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
AddressCity12 VARCHAR 31TrueFalseFalseFalse%s
AddressState12 VARCHAR 21TrueFalseFalseFalse%s
AddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
AddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
AddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
AddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
AddressNote12 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
AddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
AppliedToTxnLinkedTxnTxnID12 VARCHAR 36TrueFalseFalseTrue%s
AppliedToTxnLinkedTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
ARRefundCreditCard
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEoNKv  ۅT ۅT HۅTHۅT 
AppliedToTxnLinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnLinkedTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnLinkedTxnLinkType12 VARCHAR 14TrueFalseFalseFalse
AMTTYPE
QUANTYPE
AppliedToTxnLinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey