Field Listing for Table SALESLINES

Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:LINESTATUS Type: VARCHAR Length: 20
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:ORDERQTY Type: DOUBLE
Field:ORDERUNITPRICE Type: DOUBLE
Field:ORDERUNITTAX Type: DOUBLE
Field:ORDERUNITINCLPRICE Type: DOUBLE
Field:DISCOUNTPERCENT Type: DOUBLE
Field:DISCOUNTAMOUNT Type: DOUBLE
Field:EXTENDEDNETTPRICE Type: DOUBLE
Field:EXTENDEDTAX Type: DOUBLE
Field:EXTENDEDTOTALPRICE Type: DOUBLE
Field:TAXCODE Type: VARCHAR Length: 10
Field:ANALYSISCODE Type: VARCHAR Length: 20
Field:CUSTOMERCODE Type: VARCHAR Length: 50
Field:REQUIREDDATE Type: DATE
Field:EARLIESTSUPPLYDATE Type: DATE
Field:LINENOTES Type: BLOB
Field:REMAININGQTY Type: DOUBLE
Field:TOTALPICKEDQTY Type: DOUBLE
Field:TOTALINVOICEDQTY Type: DOUBLE
Field:PRICEOVERRIDE Type: BOOLEAN
Field:ADDONSALESLINKID Type: DOUBLE
Field:ADDONSALESEXTWARRANTY Type: BOOLEAN
Field:STANDARDUNITPRICE Type: DOUBLE
Field:CUSTOMERUNITPRICE Type: DOUBLE
Field:ORDERUNITCOST Type: DOUBLE
Field:ACTUALUNITCOST Type: DOUBLE
Field:COSTCALCULATEDBYCONTENTS Type: BOOLEAN
Field:ORDERUNITMARKUP Type: DOUBLE
Field:ORDERUNITMARGIN Type: DOUBLE
Field:LINKEDCATALOGUENAME Type: VARCHAR Length: 20
Field:LOCALORDERUNITPRICE Type: DOUBLE
Field:LOCALORDERUNITTAX Type: DOUBLE
Field:LOCALDISCOUNTAMOUNT Type: DOUBLE
Field:LOCALEXTENDEDNETTPRICE Type: DOUBLE
Field:LOCALEXTENDEDTAX Type: DOUBLE
Field:LOCALEXTENDEDTOTALPRICE Type: DOUBLE
Field:LOCALSTANDARDUNITPRICE Type: DOUBLE
Field:LOCALCUSTOMERUNITPRICE Type: DOUBLE
Field:CUSTOMERDESCRIPTION Type: VARCHAR Length: 255
Field:SALESUNIT Type: VARCHAR Length: 15
Field:SALESCONVERSION Type: DOUBLE
Field:LINEUNITWEIGHT Type: DOUBLE
Field:LINEUNITVOLUME Type: DOUBLE
Field:LINEUNITAREA Type: DOUBLE
Field:LINETOTALWEIGHT Type: DOUBLE
Field:LINETOTALVOLUME Type: DOUBLE
Field:LINETOTALAREA Type: DOUBLE
Field:RENTALLINE Type: BOOLEAN
Field:RENTALITEMCODE Type: VARCHAR Length: 50
Field:RENTALQTY Type: DOUBLE
Field:RENTALRETURNED Type: BOOLEAN
Field:RENTALDESCRIPTION Type: VARCHAR Length: 255
Field:CALCULATEDUNITPRICE Type: DOUBLE
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:BATCHID Type: DOUBLE
Field:PACKSIZEQTY Type: DOUBLE
Field:ONESTEPPICKQTY Type: DOUBLE
Field:ONESTEPPREVIOUSQTY Type: DOUBLE
Field:ONESTEPPREVIOUSOLDQTY Type: DOUBLE
Field:ORDERMATRIXID Type: DOUBLE
Field:MATRIXDIMENSIONX Type: VARCHAR Length: 30
Field:MATRIXDIMENSIONY Type: VARCHAR Length: 30
Field:MATRIXDIMENSIONZ Type: VARCHAR Length: 30
Field:SPECIALINSTRUCTIONS Type: VARCHAR Length: 250
Field:ORIGINALDISCOUNTPERCENT Type: DOUBLE
Field:ORIGINALDISCOUNTAMOUNT Type: DOUBLE
Field:ORIGINALORDERUNITPRICE Type: DOUBLE
Field:ORIGINALTAXAMOUNT Type: DOUBLE
Field:ORDERDISCOUNTAPPLIES Type: BOOLEAN
Field:NOTRIGGERUPDATE Type: INTEGER
Field:PRICINGMATRIXDISCOUNTID Type: DOUBLE
Field:PRICINGMATRIXID Type: DOUBLE
Field:CREATIONSOURCEID Type: DOUBLE
Field:HEADERSYSUNIQUEID Type: DOUBLE
Field:ORIGINALQUOTELINEID Type: DOUBLE
Field:QUOTEDPRIMARYSUPPLIER Type: VARCHAR Length: 50
Field:QUOTEDITEMREVISIONNO Type: VARCHAR Length: 10
Field:QUOTEDCODESTATUS Type: VARCHAR Length: 20
Field:QUOTEDBUYPRICE Type: DOUBLE
Field:CONFIGUREDITEMCREATED Type: BOOLEAN
Field:PICKTIMEMINUTES Type: DOUBLE
Field:ORDERANDREQDATE Type: VARCHAR Length: 26
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30