The AgriDigital deliveries Import enables you to bulk import deliveries into the AgriDigital platform. We have an AgriDigital deliveries template that must be followed to successfully import your deliveries, the template can be downloaded from the platform or by clicking on the below button.
The AgriDigital deliveries template provides some instructional text and example data to get you started but this article aims to provide a detailed overview of the template. The below table describes the data included in the template, specifically the required data, a description of this data, any data generated as part of the import and finally an example the data format expected by the import.
Column | Description | Mandatory (if uploading as a buyer user) | Generated by AgriDigital | Example |
Delivery no | A unique number identifying the delivery | Yes, only for storage deliveries at non-AgriDigital sites. If not mandatory and not supplied, AgriDigital will generate a unique number if one isn't provided. | Yes (only if not provided by user) | D0001568 |
Action type | Add, Delete or Edit a delivery. Currently the system only supports 'Add'. | Yes | No | add |
Date | The date and time (24 hour) at which the delivery was made | Yes | No | 23/06/2017 13:45:30 +10:00 |
Transfer date | For deliveries onto contracts, the date at which the delivery was transferred onto a contract. For cash deliveries, this be will the same as the Delivery date. | Yes (only when the delivery is onto an order or contract) If at a managed site and the delivery will be created in progress it is not required | No | 23/06/2017 13:45:30 +10:00 |
Type | Identifies the type of delivery. | Yes | No | Transaction deliveries: (Buyer)
Storage deliveries: (Site Operator)
|
Contract no | For deliveries onto contracts, the number of the contract. | Yes, for contract deliveries. Otherwise, n/a. | No | C0001589 |
Order no | For deliveries onto orders, the number of the order. | Yes, for order deliveries. Otherwise n/a. | No | L0001222 |
Cash price | For cash deliveries, the price paid on delivery into a site | Yes, for cash deliveries. Otherwise, n/a. | No | 100 |
Supplier ID no | Supplier's NGR (if grower type delivery) or ABN (if buyer type delivery) | Yes | No | 60144871 |
Account Name | Supplier's Account Name | No | No | AgiTrade Exports (Account Name), NOT AgiTrade Exports Pty Ltd (Legal Name) |
Paddock | Paddock of origin | No | No | Paddock 3 |
Location owner | The Company Name of the Site Operator where the grain has been delivered | Yes | No | AgriTrade Exports |
Location | The name of the Location where the grain has been delivered | Yes | No | Dubbo |
Season | The season of delivery | Yes | No | 2016 |
Commodity | The commodity delivered | Yes | No | Wheat |
Grade | The Grade of the commodity delivered | Yes | No | APW1 |
Variety | The Variety of the commodity delivered | Yes - ensure it is the exact text accepted by AgriDigital otherwise it will be uploaded as 'Other'. | No | 2248 |
Vehicle registration | Registration of delivery vehicle | No | No | CEM78F |
Vehicle Type | Vehicle type, see the Vehicle types excel in Knowledge Base for options available in AgriDigital. | No | No | (1) Rigid Truck 2 Axle - GML (15mt) |
Vehicle Driver | Name of the vehicle driver for the delivery. | No | No | Jess |
Delivery Qty (Gross) | Gross delivery weight (mt) | Yes, for AgriDigital managed sites | No (But if any two of the net, gross, tare values are provided, the missing value is calculated by AD). | 30.33 |
Delivery Qty (Tare) | Tare delivery weight (mt) | Yes, for AgriDigital managed sites | No (But if any two of the net, gross, tare values are provided, the missing value is calculated by AD). | 3.12 |
Net weight | Net weight (mt) | Yes | No (But if any two of the net, gross, tare values are provided, the missing value is calculated by AD). | 44.94 |
Net shrunk weight | Net shrunk weight (mt) | No | Yes, if shrink is not provided and the delivery type uses it then we calculate it using internal shrink rates. If no shrink rate for the site, but if no shrink rate for the site 0% rate is used. | 44.21 |
Protein | Test results (Protein) | No | No | 11.1 |
Moisture | Test results (Moisture) | No | No | 12.3 |
Screenings | Test results (screenings) | No | No | 1.3 |
Test weight | Test weight (mt) | No | No | 80 |
Falling numbers | Falling numbers (mt) | No | No | 500 |
Vitreous | Test results (Vitreous) | No | No | 12 |
Oil | Test results (Oil) | No (For canola commodity type this is required) | No | 46.5 |
Impurities | Test results (Impurities) | No | No | 2.1 |
Retention | Test results (Retention) | No | No | 10 |
Purity | Test results (Purity) | No | No | 12 |
Defective | Test results (Defective) | No | No | 0.5 |
Free fatty acid | Test results (Defective) | No | No | 0.9 |
Seg | Bin segregation name | Yes, for deliveries at AgriDigital owned sites | No | Bin seg 1 |
Unload Point | Unload point name | No - Optional for deliveries at AgriDigital owned sites | No | Unload point 1 |
Container no | For both storage and transaction deliveries, container numbers can be added | No | No | TRU555J11 |
Seal 1 | Seal number for a container or bag | No | No | Seal 1111 |
Seal 2 | Additional seal number for a container or bag | No | No | Seal 2222 |
Comments | Any additional comments for the delivery (comments box) | No | No | Delivery due date updated |