Field Listing for Table POSLINES
| Field: | SALENUMBER | 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: | ORDERQTY | Type: | DOUBLE |
| Field: | ORDERUNITPRICE | Type: | DOUBLE |
| Field: | ORDERUNITTAX | Type: | DOUBLE |
| Field: | ORDERUNITPRICEWITHTAX | 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: | LINENOTES | Type: | BLOB |
| 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: | ORDERUNITPROFIT | Type: | DOUBLE |
| Field: | EXTENDEDORDERCOST | Type: | DOUBLE |
| Field: | EXTENDEDORDERPROFIT | Type: | DOUBLE |
| Field: | LINKEDCATALOGUENAME | Type: | VARCHAR Length: 20 |
| Field: | CUSTOMERCODE | Type: | VARCHAR Length: 50 |
| 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: | WAREHOUSECODE | Type: | VARCHAR Length: 20 |
| Field: | LOCATIONCODE | Type: | VARCHAR Length: 20 |
| Field: | SERIALNO | Type: | VARCHAR Length: 30 |
| Field: | EXPIRYDATE | Type: | DATE |
| Field: | BATCHNO | Type: | VARCHAR Length: 50 |
| Field: | REVISIONNO | Type: | VARCHAR Length: 10 |
| Field: | ITEMGRADE | Type: | VARCHAR Length: 50 |
| Field: | ITEMCOLOUR | Type: | VARCHAR Length: 50 |
| Field: | ITEMSIZE | Type: | VARCHAR Length: 50 |
| Field: | WARRANTYAPPLIES | Type: | BOOLEAN |
| Field: | WARRANTYDESCRIPTION | Type: | VARCHAR Length: 50 |
| Field: | FIRSTDATE | Type: | DATE |
| Field: | SECONDDATE | Type: | DATE |
| Field: | THIRDDATE | Type: | DATE |
| Field: | DELIVERYMODE | Type: | VARCHAR Length: 10 |
| Field: | RENTALPERIOD | Type: | DOUBLE |
| Field: | RENTALUNIT | Type: | VARCHAR Length: 15 |
| Field: | LINEFINISHED | Type: | BOOLEAN |
| Field: | SHIPPINGREFERENCE | Type: | VARCHAR Length: 30 |
| Field: | SHIPPINGNOTES | Type: | BLOB |
| 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: | ORDERLINE | Type: | BOOLEAN |
| Field: | ORIGINALDISCOUNTPERCENT | Type: | DOUBLE |
| Field: | ORIGINALDISCOUNTAMOUNT | Type: | DOUBLE |
| Field: | ORIGINALORDERUNITPRICE | Type: | DOUBLE |
| Field: | ORDERDISCOUNTAPPLIES | Type: | BOOLEAN |
| Field: | ORIGINALTAXAMOUNT | Type: | DOUBLE |
| Field: | PRICINGMATRIXDISCOUNTID | Type: | DOUBLE |
| Field: | PRICINGMATRIXID | Type: | DOUBLE |
| Field: | ORIGINALORDERQTY | Type: | DOUBLE |
| Field: | REMAININGQTY | Type: | DOUBLE |
| Field: | INVOICEDTODATEQTY | Type: | DOUBLE |
| Field: | ORDERNETTPRICE | Type: | DOUBLE |
| Field: | ORDERTAX | Type: | DOUBLE |
| Field: | ORDERTOTALPRICE | Type: | DOUBLE |
| Field: | OVERRIDEWAREHOUSECODE | Type: | VARCHAR Length: 20 |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |