TABLE DETAIL REFERENCE: InvoiceLine
(Australia ,New Zealand,Singapore Southeast Asia 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 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueTrueTrueTrue%s Yes
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TemplateRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TemplateRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYelities
Estimates
InventoryAssets
OpeningBalanceEquity
PayrollExpenses
PayrollLiabilities
PettyCash
P~õn,~õn))?_¸"x ¬ ± dLkwõnÌõnÜõn
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
BillAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
BillAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
BillAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressAddr112 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressProvince12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressCounty12 VARCHAR 21TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 13TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 31TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 41TrueTrueTrueFalse%s
ShipAddressBlockAddr112 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr212 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr312 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr412 VARCHAR 41TrueFalseFalseFalse%s
ShipAddressBlockAddr512 VARCHAR 41TrueFalseFalseFalse%s
IsPending-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsFinanceCharge-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PONumber12 VARCHAR 25TrueTrueTrueFalse%s
TermsRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TermsRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
DueDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesRepRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesRepRefFullName12 VARCHAR 5TrueTrueTrueFalse%s Yes
FOB12 VARCHAR 13TrueTrueTrueFalse%s
ShipDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ShipMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShipMethodRefFullName12 VARCHAR 15TrueTrueTrueFalse%s Yes
Subtotal3 DECIMAL 13TrueFalseFalseFalse%8.2f
ItemSalesTaxRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemSalesTaxRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%7.5f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%8.2f
AppliedAmount3 DECIMAL 13TrueFalseFalseFalse%8.2f
BalanceRemaining3 DECIMAL 13TrueFalseFalseFalse%8.2f
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CustomerMsgRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerMsgRefFullName12 VARCHAR 101TrueTrueTrueFalse%s Yes
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsToBeEmailed-7 BIT 1TrueTrueTrueFalse
1
0
true
false
IsTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CustomerSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerSalesTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
CustomerTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
SuggestedDiscountAmount3 DECIMAL 13TrueFalseFalseFalse%8.2f
SuggestedDiscountDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
CustomFieldOther12 VARCHAR 29TrueTrueTrueFalse%s
LinkToTxnID112 VARCHAR 36TrueTrueTrueFalse%s
InvoiceLineType12 VARCHAR 11TrueFalseTrueFalseItemType
InvoiceLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
InvoiceLineGroupTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
InvoiceLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineGroupItemGroupRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
InvoiceLineGroupDesc12 VARCHAR 4095TrueFalseTrueFalse%s
InvoiceLineGroupQuantity3 DECIMAL 16TrueTrueTrueFalse%8.5f
InvoiceLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseTrueFalse
1
0
true
false
InvoiceLineGroupTotalAmount3 DECIMAL 13TrueFalseFalseFalse%8.2f
InvoiceLineGroupServiceDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
InvoiceLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
InvoiceLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
InvoiceLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
InvoiceLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
InvoiceLineQuantity3 DECIMAL 16TrueTrueTrueFalse%8.5f
InvoiceLineRate3 DECIMAL 16TrueTrueTrueFalse%8.5f
InvoiceLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%7.5f
InvoiceLinePriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLinePriceLevelRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
InvoiceLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
InvoiceLineAmount3 DECIMAL 13TrueTrueTrueFalse%8.2f
InvoiceLineTaxAmount3 DECIMAL 13TrueTrueTrueFalse%8.2f
InvoiceLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
InvoiceLineSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineSalesTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
InvoiceLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
InvoiceLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InvoiceLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CustomFieldInvoiceLineOther112 VARCHAR 29TrueTrueTrueFalse%s
CustomFieldInvoiceLineOther212 VARCHAR 29TrueTrueTrueFalse%s
InvoiceLineLinkToTxnTxnID12 VARCHAR 36TrueFalseTrueFalse%s
InvoiceLineLinkToTxnTxnLineID12 VARCHAR 36TrueFalseTrueFalse%s
Tax1Total3 DECIMAL 13TrueFalseFalseFalse%8.2f
Tax2Total3 DECIMAL 13TrueFalseFalseFalse%8.2f
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.8f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey