This exports a Contract file consisting of Bookings that can be used with Feed Mill Manager.
For more information on this export, see the Bookings Export tab here.
File Layouts
Feed Mill Contract Export File Format
| ASCII Field | PRQU Field | FMM Field | ASCII Length | PRQU Length | FMM Length | Type | Comments | Column |
| Contract Number (Booking Number) | Quote_code | RDI Contract Number | 15 | 15 | 15 | Char Upper | REQUIRED | 1-15 |
| Customer Number (Agvance Customer ID or Cross Ref from setup) | Quote_customer_code | Customer Number | 15 | 8 | 15 | Char Upper | REQUIRED
Change PRQU to 15 characters |
16-30 |
| Contract Date (Booking Date) | Quote_contract_date | Contract Date | 8 | 8 | 8 | Date | YYYYMMDD | 31-38 |
| Item Number (Agvance Prod ID or Cross Ref from setup | Quote_formula_code | Item Number | 30 | 15 | 30 | Char Upper | REQUIRED | 39-68 |
| Item Description (Name of Product entered on Booking) | Quote_formula_description | Item Description | 50 | 30 | 50 | Char |
|
69-118 |
| Contract Price | Quote_cost | U Of M Price (Ton Price) | 17 | * | 17 | Numeric | REQUIRED
Unit Price on Booking * Product Conversion Attribute value Rounded to 5 decimals Example: 99999999999.99999 |
119-135 |
| Contract Quantity |
|
Contract Quantity (in Tons if no Qty in Base is sent) | 17 | * | 17 | Numeric | REQUIRED QuantShare on the Booking/Product Billing Divisor/Product Conversion Attribute value Rounded to 5 decimals Example: 99999999999.99999 |
136-152 |
| Beginning Contract Date (Booking Start Date or Book Date) |
|
Shipping Period From | 8 |
|
8 | Date | REQUIRED
YYYYMMDD Booking Start Date used by default If Start Date is null or 01/01/1900, Book Date is used |
153-160 |
| Ending Contract Date (Booking Expiration Date) |
|
Shipping Period To | 8 |
|
8 | Date | REQUIRED
YYYYMMDD If Expiration Date is null or 01/01/1900, then 12/31/9999 is used |
161-168 |
| Contract Sequence Number |
|
RDI Contract Sequence Number | 10 |
|
10 | Long integer | Optional
If present, contract line with this contract sequence number will be updated or created. Right-justified, blank-filled |
169-178 |
| Qty in Base (Qty in Base Attribute Value) |
|
Qty In Base U Of M | 17 |
|
17 | Numeric | 99999999999.99999 | 179-195 |
| Quantity Remaining |
|
Qty Remaining | 17 |
|
17 | Numeric | QuantShare on the Booking/Product Conversion Attribute value
Rounded to 5 decimals Example: 99999999999.99999 |
196-212 |
| Zero Filled |
|
|
10 |
|
10 |
|
Right-justified, blank-filled | 213-222 |
| Location Description |
|
Location Name |
|
|
|
|
Booking Location name | 223-252 |
