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 |