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 |