TABLE DETAIL REFERENCE: BillLinkedTxn
(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
VendorRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
VendorRefFullName12 VARCHAR 41TrueFalseFalseTrue%s Yes
VendorAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
VendorAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
VendorAddressState12 VARCHAR 21TrueFalseFalseFalse%s
VendorAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
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<°ÖeüTà™ ‘T
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AmountDue3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.6f
AmountDueInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 20TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
Memo12 VARCHAR 4095TrueFalseFalseFalse%s
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
LinkToTxnID112 VARCHAR 36TrueFalseFalseFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
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
LiabilityAdjusÃÝoNþKvÉÐþ ø ÄÛ…T ÄÛ…TÐþ øHÄÛ…THÄÛ…TžŸžŸÐþ ø
LinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
LinkedTxnLinkType12 VARCHAR 8TrueFalseFalseFalse
AMTTYPE
QUANTYPE
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey