|
Association
of American Warehouse Control Officials
Electronic
Data Interchange (EDI) Specifications
For
further information please contact your state warehouse licensing
authority
| Standard Date: |
August 1, 1995
|
| File Type: |
PC-DOS, Delimited,
ASCII text file |
| File Name: |
EDI.DAT
|
| Field Delimiter: |
Comma |
| Record Delimiter: |
CR/LF sequence. |
Double Quotes...
All data for
fields labeled TEXT (see page 3) must be contained in DOUBLE QUOTES
("string"). For example, a record containing yellow corn would have
a grain code text string appear in EDI.DAT as:
"CORN"
Numeric fields
can have double quotes around the number but this is not required.
Padding...
DO NOT pad
any text fields with blanks. Likewise, do not pad numeric fields
with zeros.
When Data is Not Available
or Not Applicable...
If the warehouseman's
grain software system data files does not contain, or for any reason
can not supply, a particular type(s) of record code (for example,
code 43 - Outstanding Checks) simply omit these data records (code
43) from the EDI.DAT file. ALL RECORD CODES NEED NOT BE PRESENT
IN EDI.DAT.
If the warehouseman's
grain software system does not contain or for any reason can not
supply a particular data field in a particular type of record (record
code) then simply skip that data field by writing a delimiter to
the file. ALL FIELDS NEED NOT BE PRESENT WITHIN A RECORD as long
as the omitted field is properly skipped. For example:
Aville Elevator
has only 1 location.
Aville’s EDI.DAT file contains a data record for a Neg. Cust.
W/R (Record Code 1) that looks like this...
1,,100412,"Bob Customer", "CORN".......etc.
where 1 is
the record type. The first comma represents the record code delimiter.
The second comma indicates the location delimiter (since there is
no location, the location delimiter appears directly after the record
code delimiter). 100412 is the WR serial number. "Bob Customer"
is the W/R owner's name. CORN is the grain code, etc..
Grain Codes...
The grain code
field (field 5) for each data record must contain one of the text
string grain codes found in the right hand column in the Grain Table
(page 2).
Locations...
If any type
of record (especially W/Rs and Contracts) use a "Location ID", place
that string in the LOCATION field (field 2). If facilities are not
separated by location simply omit this information (see above).
If the location ID is a number such as 1,2,3, etc., using the number
itself is acceptable. Double quotes are not necessary in the case
of a numeric location ID unless there are blanks appearing within
the number.
| AAWCO
EDI 1995 Grain Table |
| Grain
Description |
Grain
Code (field 5) |
| Barley
|
BARLY |
| Buckwheat
|
BWHT |
| Canola
|
CNOLA |
| Corn (Popcorn)
|
POPCN |
| Corn (Waxy)
|
WAXYC |
| Corn (White)
|
WCORN |
| Corn (Yellow)
|
CORN |
| Corn (Screenings)
|
CSCRN |
| Edible
Bean (Brown) |
SWBRN |
| Edible
Bean (Cranberry) |
CRANB |
| Edible
Bean (Navy) |
NAVYB |
| Edible
Bean (Pinto) |
PINTB |
| Edible
Bean (Dark Red Kid) |
DRKID |
| Edible
Bean (Large Red Kid) |
LRKID |
| Edible
Bean (Black Turtle) |
BTURT |
| Edible
Bean (Red Turtle) |
RTURT |
| Edible
Bean (White Turtle) |
WTURT |
| Flaxseed
|
FLAXS |
| Millet
|
MILLT |
| Mixed
Grain |
MIXGR |
| Non-Standard
Grain |
NSTDG |
| Oats |
OATS |
| Rye |
RYE |
| Triticale
|
TRIT |
| Sorghum/Milo
|
SORGH |
| Soybeans
|
SOYBN |
| Spelt
|
SPLTZ |
| Sunflower
(Confection) |
SFLRC |
| Sunflower
(Oil) |
SFLRO |
| Wheat
(Soft Red) |
SRWHT |
| Wheat
(White) |
WWHT |
| AAWCO
EDI 1995 File Layout (EDI.DAT) |
| Field
Number |
Description |
Data
Type |
Length |
| 1 |
Record
Code (see pg. 4) |
INTEGER |
2 |
| 2 |
Location |
TEXT |
15 |
| 3 |
Document
number |
INTEGER |
8 |
| 4 |
Name |
TEXT |
25 |
| 5 |
Grain
(see pg. 2) |
TEXT |
5 |
| 6 |
Grade |
TEXT |
2 |
| 7 |
Bushel
Quantity |
FLOAT |
16 |
| 8 |
Issue
Date |
DATE |
MM/DD/YY |
| 9 |
Cancel
Date |
DATE |
MM/DD/YY |
| 10 |
Disposition |
TEXT |
15 |
| 11 |
Price
per bushel |
FLOAT |
16 |
| 12 |
Option
Month |
TEXT |
MM/YY |
| 13 |
Dollar
Amount |
FLOAT |
16 |
| 14 |
Accrued
Charges |
FLOAT |
16 |
| END |
|
|
|
Note: Date
Type "FLOAT" means a numeric only field with a floating
decimal.
Fields with
Data Type - INTEGER (fields 1 & 4) must not have a decimal
point, spaces, or alpha characters present. Alpha characters in
warehouseman's data may either be stripped and moved to the "location"
field 2 or converted to an additional integer. For example, contract
serial number A90302 would appear in the EDI.DAT file as 190302.
Fields with
DataType - FLOAT (fields 7,11,13,14) may (but are not required
to) have a decimal point at any position in the number so long as
the total number of signficant digits (ROD & LOD) add to 16
or less.
| AAWCO
EDI 1995 - Description of Record Codes |
|
Each record
present in EDI.DAT must be identified by one of the integer
codes below in field 1 of EDI.DAT
|
| Code |
Description |
| 1 |
Negotiable
CCC Warehouse Receipt |
| 2 |
Negotiable
COMPANY OWNED (Collateral) Warehouse Receipt |
| 3 |
Negotiable
CUSTOMER Warehouse Receipt |
| 4 |
Non -
Negotiable CUSTOMER Warehouse Receipt |
| 5 |
Non -
Negotiable CCC Loading Order |
| 6 |
Non-Negotiable
Grain Bank Warehouse Receipt |
| 7 |
Purchase
Contract - Price Later/Delay Price/Credit Sale (Delivered Bushels) |
| 8 |
Purchase
Contract - Basis (Delivered Bushels) |
| 9 |
Purchase
Contract - Basis (Remaining Balance) |
| 10 |
Purchase
Contract - Priced (Remaining Balance) |
| 11 |
Purchase
Contract - Hedged-To-Arrive (Remaining Balance) |
| 12 |
Purchase
Contract - Guaranteed Min. Price (hedged w/Call & BoT Short)
(Remain. Bal.) |
| 13 |
Purchase
Contract - Guaranteed Min. Price (hedged w/Put alone) (Delivered
Bushels) |
| 14 |
Purchase
Contract - Board of Trade Futures Contract (Long) |
| 15 |
Purchase
Contract - Purchase of Board of Trade CALL option (Overall Position
Hedge) |
| 16 |
Purchase
Contract - Purchase of Board of Trade CALL option (GMP component) |
| 17 |
Purchase
Contract - Sale of (Write) Board of Trade CALL option |
| 18 |
Sale Contract
- Price Later/Delay Price/Credit Sale (Delivered Bushels) |
| 19 |
Sale Contract
- Basis (Delivered Bushels) |
| 20 |
Sale Contract
- Basis (Remaining Balance) |
| 21 |
Sale Contract
- Priced (Remaining Balance) |
| 22 |
Sale Contract
- Hedged-To-Arrive (Remaining Balance) |
| 23 |
Sale Contract
- Guaranteed Min. Price (hedged w/CALL & BoT Short) (Remain.
Bal.) |
| 24 |
Sale Contract
- Guaranteed Min. Price (hedged w/PUT alone) (Delivered Bushels) |
| 25 |
Sale Contract
- Board of Trade Futures Contract (Short) |
| 26 |
Sale Contract
- Purchase of Board of Trade PUT option (Overall Position Hedge) |
| 27 |
Sale Contract
- Purchase of Board of Trade PUT option (GMP component) |
| 28 |
Sale Contract
- Sale of (Write) Board of Trade PUT option |
| 29 |
Customer
Open Storage |
| 30 |
Forwarded
Grain |
| 31 |
Grain
Bank Storage Account |
| 32 |
CCC Open
Storage |
| 33 |
Storage
Load Order (CCC) |
| 34 |
Owned
Grain Intransit |
| 35 |
Grain
Payable 0-30 |
| 36 |
Grain
Payable 31-60 |
| 37 |
Grain
Payable 61-120 |
| 38 |
Grain
Payable >120 |
| 39 |
Deferred
Payment Contract |
| 40 |
Trade
Payable |
| 41 |
Grain
Receivable |
| 42 |
Trade
Receivable |
| 43 |
Outstanding
Check |
| 44 |
Outstanding
Deposit |
| END |
|
Back
to top | Back to EDI Menu
|
