TABLE DETAIL REFERENCE: InvoiceLinkedTxn
(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
CustomerRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueFalseFalseTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
ARAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ARAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYear
ThisFiscalYearToDate
Yesterday
LastWeek
LastWeekToDate
LastMonth
LastMonthToDate
LastCalendarQuarter
LastCalendarQuarterToDate
LastFiscalQuarter
LastFiscalQuarterToDate
LastCalendarYear
LastCalendarYearToDate
LastFiscalYear
LastFiscalYearToDate
NextWeek
NextFourWeeks
NextMonth
NextCalendarQuarter
NextCalendarYear
NextFiscalQuarter
NextFiscalYear
RefNumber12 VARCHAR 21TrueFalseFalseFalse%s
BillAddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
BillAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
BillAddressCity12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressState12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
BillAddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
BillAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
BillEmailBccAddress12 VARCHAR 1000TrueFalseFalseFalse%s
BillEmailCcAddress12 VARCHAR 1000TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr212 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr312 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr412 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressAddr512 VARCHAR 500TrueFalseFalseFalse%s
ShipAddressCity12 VARCHAR 255TrueFalseFalseFalse%s
ShipAddressState12 VARCHAR 255TrueFalseFalseFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueFalseFalseFalse%s
ShipAddressCountry12 VARCHAR 255TrueFalseFalseFalse%s
ShipAddressNote12 VARCHAR 500TrueFalseFalseFalse%s
TermsRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
DueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
ShipDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
Subtotal3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
AppliedAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueFalseFalseFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsToBePrinted-7 BIT 1TrueFalseFalseFalse
1
0
true
false
EmailStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueFalseFalseFalse%s
HomeBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
TaxRateRefName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TaxRateRefType12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TaxRateRefValue12 VARCHAR 1000TrueFalseFalseFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueFalseFalseFalse
TaxExcluded
TaxIncluded
NotApplicable
TaxLineDetailPercentBase-7 BIT 1FalseFalseFalseFalse
1
0
true
false
TaxLineDetailTaxPercent3 DECIMAL 15FalseFalseFalseFalse%10.7f
TaxLineDetailNetAmountTaxable3 DECIMAL 15FalseFalseFalseFalse%7.5f
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
LinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
DiscountLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueFalseFalseFalse%11.7f
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ShippingLineAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
ShippingLineAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ShippingLineAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s