TABLE DETAIL REFERENCE: InvoiceLine
(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 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-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 21TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
BillEmailBccAddress12 VARCHAR 1000TrueTrueTrueFalse%s
BillEmailCcAddress12 VARCHAR 1000TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Subtotal3 DECIMAL 15TrueTrueFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
AppliedAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
EmailStatus12 VARCHAR 13TrueTrueTrueFalse
NotSet
NeedToPrint
EmailSent
BillEmailAddress12 VARCHAR 1000TrueTrueTrueFalse%s
HomeBalance3 DECIMAL 15TrueFalseFalseFalse%11.2f
TaxRateRefName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TaxRateRefType12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TaxRateRefValue12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
TaxLineDetailPercentBase-7 BIT 1FalseTrueTrueFalse
1
0
true
false
TaxLineDetailTaxPercent3 DECIMAL 15FalseTrueTrueFalse%10.7f
TaxLineDetailNetAmountTaxable3 DECIMAL 15FalseTrueTrueFalse%7.5f
InvoiceLineType12 VARCHAR 11TrueFalseTrueFalseItemType
InvoiceLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
InvoiceLineGroupTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
InvoiceLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineGroupItemGroupRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
InvoiceLineGroupDesc12 VARCHAR 4000TrueFalseTrueFalse%s
InvoiceLineGroupQuantity3 DECIMAL 16TrueTrueTrueFalse%8.5f
InvoiceLineGroupAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
InvoiceLineGroupTotalAmount3 DECIMAL 13TrueFalseFalseFalse%8.2f
InvoiceLineGroupServiceDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
InvoiceLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
InvoiceLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
InvoiceLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineItemRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
InvoiceLineDesc12 VARCHAR 4000TrueTrueTrueFalse%s
InvoiceLineQuantity3 DECIMAL 16TrueTrueTrueFalse%10.7f
InvoiceLineRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
InvoiceLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%10.7f
InvoiceLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
InvoiceLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
InvoiceLineTaxAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
InvoiceLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
InvoiceLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
InvoiceLineTaxCodeRefType12 VARCHAR 1000TrueTrueTrueFalse%s Yes
InvoiceLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DiscountLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%11.7f
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ShippingLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
ShippingLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
ShippingLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
CustomFieldCrew12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew112 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCrew212 VARCHAR 30TrueTrueTrueFalse%s