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
ShipMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ShipMethodRefFullName12 VARCHAR 100TrueFalseFalseFalse%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
BillAddressID12 VARCHAR 500TrueFalseFalseFalse%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
ShipAddressID12 VARCHAR 500TrueFalseFalseFalse%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
TrackingNumber12 VARCHAR 1000TrueFalseFalseFalse%s
Subtotal3 DECIMAL 15TrueFalseFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
TotalAmount3 DECIMAL 13TrueFalseFalseFalse%11.2f
HomeTotalAmount3 DECIMAL 13TrueFalseFalseFalse%8.2f
ApplyTaxAfterDiscount-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AppliedAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueFalseFalseFalse%s
CustomerMemo12 VARCHAR 1000TrueFalseFalseFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsToBePrinted-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PrintStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToPrint
PrintComplete
EmailStatus12 VARCHAR 13TrueFalseFalseFalse
NotSet
NeedToSend
EmailSent
BillEmailAddress12 VARCHAR 1000TrueFalseFalseFalse%s
HomeBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
DepositAmount3 DECIMAL 13TrueFalseFalseFalse%11.2f
DepositToAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
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
AllowIPNPayment-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AllowOnlineACHPayment-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AllowOnlineCreditCardPayment-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AllowOnlinePayment-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Deposit3 DECIMAL 13TrueFalseFalseFalse%11.2f
ECloudStatusTimeStamp9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LessCIS3 DECIMAL 13TrueFalseFalseFalse%11.2f
EInvoiceStatus12 VARCHAR 13TrueFalseFalseFalse
Sent
Viewed
Paid
TransactionLocationType12 VARCHAR 32TrueFalseFalseFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU
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
TaxDetailDefaultTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxDetailDefaultTaxCodeRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
TaxDetailTxnTaxCodeRef12 VARCHAR 11TrueFalseFalseFalse%8.2f
TaxDetailTotalTax3 DECIMAL 13TrueFalseFalseFalse%10.7f
TaxDetailReviewStatus12 VARCHAR 11TrueFalseFalseFalse
Billable
NotBillable
HasBeenBill
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
CustomFieldPONumber12 VARCHAR 30TrueTrueTrueFalse%s