Field Listing for Table SALESINVOICELINES
| Field: | INVOICENUMBER | Type: | VARCHAR Length: 15 |
| Field: | GROUPNO | Type: | INTEGER |
| Field: | DELIVERYORSCHEDULENO | Type: | INTEGER |
| Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
| Field: | LINENUMBER | Type: | INTEGER |
| Field: | CODETYPE | Type: | VARCHAR Length: 20 |
| Field: | LINECODE | Type: | VARCHAR Length: 50 |
| Field: | LINEDESCRIPTION | Type: | VARCHAR Length: 255 |
| Field: | LINEUNIT | Type: | VARCHAR Length: 15 |
| Field: | INVOICEQTY | Type: | DOUBLE |
| Field: | INVOICEUNITPRICE | Type: | DOUBLE |
| Field: | REMAININGQTY | Type: | DOUBLE |
| Field: | CUSTOMERUNITPRICE | Type: | DOUBLE |
| Field: | INVOICEUNITTAX | Type: | DOUBLE |
| Field: | INVOICEUNITCOST | Type: | DOUBLE |
| Field: | DISCOUNTPERCENT | Type: | DOUBLE |
| Field: | DISCOUNTAMOUNT | Type: | DOUBLE |
| Field: | EXTENDEDNETTPRICE | Type: | DOUBLE |
| Field: | EXTENDEDTAX | Type: | DOUBLE |
| Field: | EXTENDEDTOTALPRICE | Type: | DOUBLE |
| Field: | PRICEOVERRIDE | Type: | BOOLEAN |
| Field: | TAXCODE | Type: | VARCHAR Length: 10 |
| Field: | ANALYSISCODE | Type: | VARCHAR Length: 20 |
| Field: | CUSTOMERCODE | Type: | VARCHAR Length: 50 |
| Field: | LINENOTES | Type: | BLOB |
| Field: | RETENTIONNETTPRICE | Type: | DOUBLE |
| Field: | RETENTIONTAX | Type: | DOUBLE |
| Field: | RETENTIONTOTALPRICE | Type: | DOUBLE |
| Field: | CATALOGUECATEGORY | Type: | VARCHAR Length: 20 |
| Field: | STANDARDUNITPRICE | Type: | DOUBLE |
| Field: | LINKEDCATALOGUENAME | Type: | VARCHAR Length: 20 |
| Field: | SPECIALINSTRUCTIONS | Type: | VARCHAR Length: 250 |
| Field: | SPECIALINSTRUCTIONS2 | Type: | VARCHAR Length: 250 |
| Field: | CALCULATEDUNITPRICE | Type: | DOUBLE |
| Field: | CREATEDFROMPROCEDURE | Type: | BOOLEAN |
| Field: | ADDITIONALFIELD_1 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_2 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_3 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALFIELD_4 | Type: | VARCHAR Length: 100 |
| Field: | ADDITIONALDATEFIELD_1 | Type: | DATE |
| Field: | ADDITIONALDATEFIELD_2 | Type: | DATE |
| Field: | LOCALINVOICEUNITPRICE | Type: | DOUBLE |
| Field: | LOCALCUSTOMERUNITPRICE | Type: | DOUBLE |
| Field: | LOCALINVOICEUNITTAX | Type: | DOUBLE |
| Field: | LOCALDISCOUNTAMOUNT | Type: | DOUBLE |
| Field: | LOCALEXTENDEDNETTPRICE | Type: | DOUBLE |
| Field: | LOCALEXTENDEDTAX | Type: | DOUBLE |
| Field: | LOCALEXTENDEDTOTALPRICE | Type: | DOUBLE |
| Field: | LOCALRETENTIONNETTPRICE | Type: | DOUBLE |
| Field: | LOCALRETENTIONTAX | Type: | DOUBLE |
| Field: | LOCALRETENTIONTOTALPRICE | Type: | DOUBLE |
| Field: | SIZEUNITPRICE | Type: | DOUBLE |
| Field: | SIZECUSTOMERUNITPRICE | Type: | DOUBLE |
| Field: | WRITEOFFSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ORIGINALDISCOUNTPERCENT | Type: | DOUBLE |
| Field: | ORIGINALDISCOUNTAMOUNT | Type: | DOUBLE |
| Field: | ORIGINALORDERUNITPRICE | Type: | DOUBLE |
| Field: | ORDERDISCOUNTAPPLIES | Type: | BOOLEAN |
| Field: | ORIGINALTAXAMOUNT | Type: | DOUBLE |
| Field: | INVOICEUNITINCLPRICE | Type: | DOUBLE |
| Field: | PRICINGMATRIXDISCOUNTID | Type: | DOUBLE |
| Field: | PRICINGMATRIXID | Type: | DOUBLE |
| Field: | SOURCESYSUNIQUEID | Type: | DOUBLE |
| Field: | LINESYSUNIQUEID | Type: | DOUBLE |
| Field: | HEADERSYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |