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