TABLE DETAIL REFERENCE: EstimateLinkedTxn
(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
DocNumber12 VARCHAR 21TrueFalseFalseFalse%s
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
PrivateNote12 VARCHAR 4000TrueFalseFalseFalse%s
TxnStatus12 VARCHAR 1000TrueFalseFalseFalse%s
CustomerRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
CustomerMemo12 VARCHAR 1000TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressProvince12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressCounty12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 100TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 31TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
ShipMethodRef12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ShipDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxIncluded
NotApplicable
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
ApplyTaxAfterDiscount-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PrintStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
PrintComplete
EmailStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueFalseFalseFalse%s
ExpirationDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AcceptedBy12 VARCHAR 1000TrueFalseFalseFalse%s Yes
AcceptedDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
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
ARRefundCreditCard
LinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnRefNumber12 VARCHAR 21TrueFalseFalseFalse%s
LinkedTxnLinkType12 VARCHAR 11TrueFalseFalseFalse
AMTTYPE
QUANTYPE
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s