...
| Field Name | Description | Field Limits and Notes |
|---|---|---|
| Trans Date | The Transaction Date of the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Doc No | The Document Reference of the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Order No | The Order Reference of the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Type of Sale | The Type of Sales Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Customer County Code | The County Code for the Customer. | This field is Read Only and Cannot be Modified Changed from here. |
| Customer Country | The Country for the Customer. | This field is Read Only and Cannot be Modified Changed from here. |
| Cust Analysis Code 1 | The 1st Customer Analysis Code. | This field is Read Only and Cannot be ModifiedChanged from here. |
| Customer Analysis Name 1 | The Name of the Analysis Code above. | This field is Read Only and Cannot be ModifiedChanged from here. |
| Cust Analysis Code 2 | The 2nd Customer Analysis Code. | This field is Read Only and Cannot be ModifiedChanged from here. |
| Customer Analysis Name 2 | The Name of the Analysis Code above. | This field is Read Only and Cannot be ModifiedChanged from here. |
| Cust Analysis Code 3 | The 3rd Customer Analysis Code. | This field is Read Only and Cannot be ModifiedChanged from here. |
| Customer Analysis Name 3 | The Name of the Analysis Code above. | This field is Read Only and Cannot be ModifiedChanged from here. |
| Cust Analysis Code 4 | The 4th Customer Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Customer Analysis Name 4 | The Name of the Analysis Code above. | This field is Read Only and Cannot be Modified Changed from here. |
| Cust Analysis Code 5 | The 5th Customer Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Customer Analysis Name 5 | The Name of the Analysis Code above. | This field is Read Only and Cannot be Modified Changed from here. |
| Cust Analysis Code 6 | The 6th Customer Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Customer Analysis Name 6 | The Name of the Analysis Code above. | This field is Read Only and Cannot be Modified Changed from here. |
| Cust Analysis Code 7 | The 7th Customer Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Customer Analysis Name 7 | The Name of the Analysis Code above. | This field is Read Only and Cannot be Modified Changed from here. |
| Group Account | The Group Account Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Group Name | The Name of the Group. | This field is Read Only and Cannot be Modified Changed from here. |
| Account No | The Code for the Customer. | This field is Read Only and Cannot be Modified Changed from here. |
| Account Name | The Name of the Customer. | This field is Read Only and Cannot be Modified Changed from here. |
| Supplier | The Code of the Supplier. | This field is Read Only and Cannot be Modified Changed from here. |
| Supplier Name | The Name of the above Supplier. | This field is Read Only and Cannot be Modified Changed from here. |
| Producer | The Code of the Producer. | This field is Read Only and Cannot be Modified Changed from here. |
| Producer Name | The Name of the above Producer. | This field is Read Only and Cannot be Modified Changed from here. |
| Country Code | The Product Country Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Country of Origin | The Country Name. | This field is Read Only and Cannot be Modified Changed from here. |
| Region Code | The Code for the Product Region. | This field is Read Only and Cannot be Modified Changed from here. |
| Region Name | The Name for the above Region. | This field is Read Only and Cannot be Modified Changed from here. |
| EP Campaign | The Campaign if this is an En Primeur (EP) Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Is Duty Paid | If this is a Duty Paid Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Prod Type | The Type of the Product. | This field is Read Only and Cannot be Modified Changed from here. |
| Prod Type Description | The Description of the Product Type. | This field is Read Only and Cannot be Modified Changed from here. |
| Product Group | The Group for the Product. | This field is Read Only and Cannot be Modified Changed from here. |
| Prod Grp Description | The Description of the Product Group. | This field is Read Only and Cannot be Modified Changed from here. |
| Prod Analysis Code 1 | The 1st Product Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Prod Analysis Name 1 | The Name of the above Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Prod Analysis Code 2 | The 2nd Product Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Prod Analysis Name 2 | The Name of the above Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Prod Analysis Code 3 | The 3rd Product Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Prod Analysis Name 3 | The Name of the above Analysis Code. | This field is Read Only and Cannot be Modified Changed from here. |
| Promotion | The Promotion for this Order if there was one. | This field is Read Only and Cannot be Modified Changed from here. |
| Location | The Location of the Stock. | This field is Read Only and Cannot be Modified Changed from here. |
| Product Code | The Code for the Product. | This field is Read Only and Cannot be Modified Changed from here. |
| Product Description | The Description of the above Product. | This field is Read Only and Cannot be Modified Changed from here. |
| Vintage | The Vintage of the above Product. | This field is Read Only and Cannot be Modified Changed from here. |
| Singles | The Number of Singles on the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Actual Cases | The Number of Actual Cases on the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Cases | The Number of Cases on the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| @xlitres | The Litreage Total on the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Sales Value | The Value of the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Cost Value | The Cost Value of the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Duty | The Duty Cost for the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| CCT | The CCT Cost for the Order. | This field is Read Only and Cannot be Modified Changed from here. |
| Rent | The Cost of the Rent. | This field is Read Only and Cannot be Modified Changed from here. |
| RH&D | The RH&D Costs. | This field is Read Only and Cannot be Modified Changed from here. |
| Shipping | The Freight and Insurance Costs. | This field is Read Only and Cannot be Modified Changed from here. |
| Delivery | Any Delivery Costs. | This field is Read Only and Cannot be Modified Changed from here. |
| Rep Group | The Sales Rep Group. | This field is Read Only and Cannot be Modified Changed from here. |
| Division | The Division. | This field is Read Only and Cannot be Modified Changed from here. |
| Outlet Code | The Code for the Outlet. | This field is Read Only and Cannot be Modified Changed from here. |
| Outlet Name | The Name for the above Outlet. | This field is Read Only and Cannot be Modified Changed from here. |
| Outlet Group | The Group Code for the Outlet. | This field is Read Only and Cannot be Modified Changed from here. |
| Total Cost | The Total of all Costs. | This field is Read Only and Cannot be Modified Changed from here. |
| Margin | The Margin on this Order. | This field is Read Only and Cannot be Modified Changed from here. |
| GP% | The GP Percentage %. | This field is Read Only and Cannot be Modified Changed from here. |
Once the results of the Report are retrieved you can filter on 1 or multiple fields to only show some records as per any search criteria you enter.
...