TABLE DETAIL REFERENCE: SalesOrderLinkedTxn
(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
CustomerRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseFalseTrue%s Yes
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
TemplateRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TemplateRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYeCC
RefNumber12 VARCHAR 11TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressProvince12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressCounty12 VARCHAR 21TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
PONumber12 VARCHAR 25TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
SalesRepRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueFalseFalseFalse%s Yes
FOB12 VARCHAR 13TrueFalseFalseFalse%s
ShipDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
ShipMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ShipMethodRefFullName12 VARCHAR 15TrueFalseFalseFalse%s Yes
Subtotal3 DECIMAL 15TrueFalseFalseFalse%10.2f
ItemSalesTaxRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
SalesTaxPercentage3 DECIMAL 18TrueFalseFalseFalse%10.5f
SalesTaxTotal3 DECIMAL 15TrueFalseFalseFalse%10.2f
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.6f
TotalAmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
IsManuallyClosed-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsFullyInvoiced-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Memo12 VARCHAR 4095TrueFalseFalseFalse%s
CustomerMsgRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerMsgRefFullName12 VARCHAR 101TrueFalseFalseFalse%s Yes
IsToBePrinted-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsToBeEmailed-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CustomerSalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerSalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
CustomerTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
CustomFieldOther12 VARCHAR 29TrueFalseFalseFalse%s
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
LiabilityAdjusoNKv  ۅ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
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey