TABLE DETAIL REFERENCE: InvoiceLine
(USA VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CustomerRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
| CustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | True | %s | Yes |
| ClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| ARAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ARAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| TemplateRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TemplateRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | 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 | |
| RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | |
| BillAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| BillAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| BillAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| BillAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| BillAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| BillAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| BillAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| BillAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| BillAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| BillAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| BillAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| BillAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| BillAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressAddr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| ShipAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| ShipAddressProvince | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| ShipAddressCounty | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| ShipAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| ShipAddressCountry | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| ShipAddressNote | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| ShipAddressBlockAddr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| ShipAddressBlockAddr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| IsPending | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| IsFinanceCharge | -7 | BIT | 1 | True | False | True | False | 1 0 true false | |
| PONumber | 12 | VARCHAR | 25 | True | True | True | False | %s | |
| TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| SalesRepRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| SalesRepRefFullName | 12 | VARCHAR | 5 | True | True | True | False | %s | Yes |
| FOB | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| ShipDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| ShipMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ShipMethodRefFullName | 12 | VARCHAR | 15 | True | True | True | False | %s | Yes |
| Subtotal | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| ItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| ItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| SalesTaxPercentage | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
| SalesTaxTotal | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| AppliedAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| BalanceRemaining | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 64 | True | False | False | False | %s | Yes |
| ExchangeRate | 3 | DECIMAL | 17 | True | True | True | False | %6.8f | |
| BalanceRemainingInHomeCurrency | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| IsPaid | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| CustomerMsgRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CustomerMsgRefFullName | 12 | VARCHAR | 101 | True | True | True | False | %s | Yes |
| IsToBePrinted | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| IsToBeEmailed | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
| IsTaxIncluded | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| CustomerSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CustomerSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
| CustomerTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| SuggestedDiscountAmount | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| SuggestedDiscountDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| CustomFieldOther | 12 | VARCHAR | 29 | True | True | True | False | %s | |
| LinkToTxnID1 | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| InvoiceLineType | 12 | VARCHAR | 11 | True | False | True | False | ItemType | |
| InvoiceLineSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
| InvoiceLineGroupTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
| InvoiceLineGroupItemGroupRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InvoiceLineGroupItemGroupRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| InvoiceLineGroupDesc | 12 | VARCHAR | 4095 | True | False | True | False | %s | |
| InvoiceLineGroupQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
| InvoiceLineGroupUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| InvoiceLineGroupInventorySiteRefListID | 12 | VARCHAR | 36 | False | False | True | False | %s | Yes |
| InvoiceLineGroupInventorySiteRefFullName | 12 | VARCHAR | 31 | False | False | True | False | %s | Yes |
| InvoiceLineGroupInventorySiteLocationRefListID | 12 | VARCHAR | 36 | False | False | True | False | %s | Yes |
| InvoiceLineGroupInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | False | False | True | False | %s | Yes |
| InvoiceLineGroupOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
| InvoiceLineGroupOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
| InvoiceLineGroupIsPrintItemsInGroup | -7 | BIT | 1 | True | False | True | False | 1 0 true false | |
| InvoiceLineGroupTotalAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| InvoiceLineGroupServiceDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| InvoiceLineGroupSeqNo | 4 | INTEGER | 4 | True | False | False | False | SubSeqNo | |
| InvoiceLineTxnLineID | 12 | VARCHAR | 36 | True | True | False | False | %s | |
| InvoiceLineItemRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InvoiceLineItemRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| InvoiceLineDesc | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| InvoiceLineQuantity | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
| InvoiceLineUnitOfMeasure | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| InvoiceLineOverrideUOMSetRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
| InvoiceLineOverrideUOMSetRefFullName | 12 | VARCHAR | 31 | True | True | False | False | %s | Yes |
| InvoiceLineRate | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
| InvoiceLineRatePercent | 3 | DECIMAL | 18 | True | True | True | False | %10.5f | |
| InvoiceLinePriceLevelRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InvoiceLinePriceLevelRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| InvoiceLineClassRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InvoiceLineClassRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| InvoiceLineAmount | 3 | DECIMAL | 18 | True | True | True | False | %10.2f | |
| InvoiceLineOptionForPriceRuleConflict | 12 | VARCHAR | 23 | False | True | True | False | Zero BasePrice | |
| InvoiceLineInventorySiteRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InvoiceLineInventorySiteRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| InvoiceLineInventorySiteLocationRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InvoiceLineInventorySiteLocationRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| InvoiceLineSerialNumber | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| InvoiceLineLotNumber | 12 | VARCHAR | 40 | True | True | True | False | %s | |
| InvoiceLineTaxAmount | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| InvoiceLineServiceDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| InvoiceLineSalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InvoiceLineSalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
| InvoiceLineTaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InvoiceLineTaxCodeRefFullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Yes |
| InvoiceLineOverrideItemAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| InvoiceLineOverrideItemAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| CustomFieldInvoiceLineOther1 | 12 | VARCHAR | 29 | True | True | True | False | %s | |
| CustomFieldInvoiceLineOther2 | 12 | VARCHAR | 29 | True | True | True | False | %s | |
| InvoiceLineLinkToTxnTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| InvoiceLineLinkToTxnTxnLineID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| Tax1Total | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| Tax2Total | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| FQSaveToCache | -7 | BIT | 1 | True | True | True | False | FQSaveToCache | |
| FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
| FQTxnLinkKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
| CustomFieldInvoiceLineALU | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineALU2 | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineApproved | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineColor | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineCompletedby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineCustomer | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineInspectedBy | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineOrdered | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLinePulled | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLinePulledby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineQtyPriceBreak | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineRequiredDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineStartDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineStyle | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupALU | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupALU2 | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupApproved | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupColor | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupCompletedby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupCustomer | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupInspectedBy | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupOrdered | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupPulled | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupPulledby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupQtyPriceBreak | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupRequiredDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupStartDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupStyle | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineALU | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineALU2 | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineApproved | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineColor | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineCompletedby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineCustomer | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineInspectedBy | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineOrdered | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLinePulled | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLinePulledby | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineQtyPriceBreak | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineRequiredDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineStartDate | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldInvoiceLineGroupLineStyle | 12 | VARCHAR | 30 | True | True | False | False | %s | |
| CustomFieldShipAccount | 12 | VARCHAR | 30 | True | True | True | False | %s | |
| CustomFieldShipMethod | 12 | VARCHAR | 30 | True | True | True | False | %s | |
| CustomFieldShipVendor | 12 | VARCHAR | 30 | True | True | True | False | %s |