Field Listing for Table SALESMONTHLYHISTORY
Field: | SALESYEAR | Type: | INTEGER |
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: | JANINVOICEQTY | Type: | DOUBLE |
Field: | JANINVOICECOST | Type: | DOUBLE |
Field: | JANINVOICEPRICE | Type: | DOUBLE |
Field: | JANSTANDARDPRICE | Type: | DOUBLE |
Field: | FEBINVOICEQTY | Type: | DOUBLE |
Field: | FEBINVOICECOST | Type: | DOUBLE |
Field: | FEBINVOICEPRICE | Type: | DOUBLE |
Field: | FEBSTANDARDPRICE | Type: | DOUBLE |
Field: | MARINVOICEQTY | Type: | DOUBLE |
Field: | MARINVOICECOST | Type: | DOUBLE |
Field: | MARINVOICEPRICE | Type: | DOUBLE |
Field: | MARSTANDARDPRICE | Type: | DOUBLE |
Field: | APRINVOICEQTY | Type: | DOUBLE |
Field: | APRINVOICECOST | Type: | DOUBLE |
Field: | APRINVOICEPRICE | Type: | DOUBLE |
Field: | APRSTANDARDPRICE | Type: | DOUBLE |
Field: | MAYINVOICEQTY | Type: | DOUBLE |
Field: | MAYINVOICECOST | Type: | DOUBLE |
Field: | MAYINVOICEPRICE | Type: | DOUBLE |
Field: | MAYSTANDARDPRICE | Type: | DOUBLE |
Field: | JUNINVOICEQTY | Type: | DOUBLE |
Field: | JUNINVOICECOST | Type: | DOUBLE |
Field: | JUNINVOICEPRICE | Type: | DOUBLE |
Field: | JUNSTANDARDPRICE | Type: | DOUBLE |
Field: | JULINVOICEQTY | Type: | DOUBLE |
Field: | JULINVOICECOST | Type: | DOUBLE |
Field: | JULINVOICEPRICE | Type: | DOUBLE |
Field: | JULSTANDARDPRICE | Type: | DOUBLE |
Field: | AUGINVOICEQTY | Type: | DOUBLE |
Field: | AUGINVOICECOST | Type: | DOUBLE |
Field: | AUGINVOICEPRICE | Type: | DOUBLE |
Field: | AUGSTANDARDPRICE | Type: | DOUBLE |
Field: | SEPINVOICEQTY | Type: | DOUBLE |
Field: | SEPINVOICECOST | Type: | DOUBLE |
Field: | SEPINVOICEPRICE | Type: | DOUBLE |
Field: | SEPSTANDARDPRICE | Type: | DOUBLE |
Field: | OCTINVOICEQTY | Type: | DOUBLE |
Field: | OCTINVOICECOST | Type: | DOUBLE |
Field: | OCTINVOICEPRICE | Type: | DOUBLE |
Field: | OCTSTANDARDPRICE | Type: | DOUBLE |
Field: | NOVINVOICEQTY | Type: | DOUBLE |
Field: | NOVINVOICECOST | Type: | DOUBLE |
Field: | NOVINVOICEPRICE | Type: | DOUBLE |
Field: | NOVSTANDARDPRICE | Type: | DOUBLE |
Field: | DECINVOICEQTY | Type: | DOUBLE |
Field: | DECINVOICECOST | Type: | DOUBLE |
Field: | DECINVOICEPRICE | Type: | DOUBLE |
Field: | DECSTANDARDPRICE | Type: | DOUBLE |
Field: | HISTORYSOURCE | Type: | VARCHAR Length: 10 |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |