Field Listing for Table SALESHISTORY

Field:INVOICEDATE Type: DATE
Field:INVOICEORCREDIT Type: VARCHAR Length: 10
Field:INVOICENUMBER Type: VARCHAR Length: 15
Field:ORDERCUSTOMER Type: VARCHAR Length: 50
Field:BILLCUSTOMER Type: VARCHAR Length: 50
Field:CODETYPE Type: VARCHAR Length: 20
Field:LINECODE Type: VARCHAR Length: 50
Field:BASEUNIT Type: VARCHAR Length: 15
Field:INVOICEQTY Type: DOUBLE
Field:INVOICEUNITCOST Type: DOUBLE
Field:INVOICEUNITPRICE Type: DOUBLE
Field:STANDARDUNITPRICE Type: DOUBLE
Field:INVOICEEXTENDEDCOST Type: DOUBLE
Field:INVOICEEXTENDEDPRICE Type: DOUBLE
Field:HISTORYSOURCE Type: VARCHAR Length: 10
Field:CATALOGUECATEGORY Type: VARCHAR Length: 20
Field:CATALOGUEANALYSIS Type: VARCHAR Length: 20
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:EXCHANGERATE Type: DOUBLE
Field:SITENAME Type: VARCHAR Length: 50
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30