Field Listing for Table SALESINVOICEGROUPING
Field: | INVOICENUMBER | Type: | VARCHAR Length: 15 |
Field: | GROUPNO | Type: | INTEGER |
Field: | GROUPORDERTYPE | Type: | VARCHAR Length: 20 |
Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
Field: | GROUPREFERENCE | Type: | VARCHAR Length: 150 |
Field: | GROUPINVOICEORIGIN | Type: | VARCHAR Length: 20 |
Field: | GROUPLINKINVOICENUMBER | Type: | VARCHAR Length: 15 |
Field: | ORDERTYPE | Type: | VARCHAR Length: 20 |
Field: | DELIVERYORSCHEDULE | Type: | VARCHAR Length: 20 |
Field: | DELIVERYORSCHEDULENO | Type: | INTEGER |
Field: | GROUPDATE | Type: | DATE |
Field: | GROUPCUSTOMER | Type: | VARCHAR Length: 50 |
Field: | GROUPADDRESS1 | Type: | VARCHAR Length: 50 |
Field: | GROUPADDRESS2 | Type: | VARCHAR Length: 50 |
Field: | GROUPADDRESS3 | Type: | VARCHAR Length: 50 |
Field: | GROUPPOSTALCODE | Type: | VARCHAR Length: 20 |
Field: | GROUPSTATE | Type: | VARCHAR Length: 20 |
Field: | GROUPCITY | Type: | VARCHAR Length: 30 |
Field: | GROUPCOUNTRY | Type: | VARCHAR Length: 30 |
Field: | GROUPCONTACT | Type: | VARCHAR Length: 100 |
Field: | GROUPPHONE | Type: | VARCHAR Length: 20 |
Field: | GROUPFAX | Type: | VARCHAR Length: 20 |
Field: | GROUPEMAIL | Type: | VARCHAR Length: 100 |
Field: | SHIPPINGMETHOD | Type: | VARCHAR Length: 20 |
Field: | SALESPERSON | Type: | VARCHAR Length: 30 |
Field: | CHARGEFREIGHT | Type: | BOOLEAN |
Field: | FREIGHTTAXABLE | Type: | BOOLEAN |
Field: | FREIGHTTAXCODE | Type: | VARCHAR Length: 10 |
Field: | FREIGHTNETTAMOUNT | Type: | DOUBLE |
Field: | FREIGHTTAXAMOUNT | Type: | DOUBLE |
Field: | FREIGHTTOTALAMOUNT | Type: | DOUBLE |
Field: | GROUPNOTES | Type: | BLOB |
Field: | GROUPNETTAMOUNT | Type: | DOUBLE |
Field: | GROUPRETENTIONAMOUNT | Type: | DOUBLE |
Field: | GROUPPURCHASEREF | Type: | VARCHAR Length: 30 |
Field: | GROUPSITENAME | Type: | VARCHAR Length: 50 |
Field: | GROUPLINKSCHEDULESYSID | Type: | DOUBLE |
Field: | SCHEDULESYSUNIQUEID | 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 |