|
Association
of American Warehouse Control Officials Electronic Data Interface
(EDI) Specifications
Revision
Date: April 11, 2000
Background
April 2000
marks 5 years since the establishment of the AAWCO EDI Standard.
Since that time, at least 10 grain accounting software firms have
incorporated AAWCO EDI capability into their software products.
On the other side of the equation, five states currently accept
EDI data from warehousemen on a regular basis during the examination
process. At many locations, examiners have been performing EDI exams
for 5 years.
Thus, the AAWCO
EDI standard has and will continue to save AAWCO member states and
the grain industry time and effort during the examination process.
AAWCO recognizes and commends the participating grain companies
and grain accounting software vendors for their support of the standard
and for their cooperation in increasing examination efficiency.
AAWCO remains committed to building on our present success as well
as expanding the appeal of EDI examinations to all member states
and their clients. To this end, we present the 2000 revision of
the AAWCO EDI.
Overview
The first,
and perhaps most important, aspect of the 2000 revision does not
mandate any changes to those EDI programs now up and running.
No software revisions of existing EDI software are necessary (for
warehouseman or examiner) to operate under the 2000 revision. Instead,
the 2000 revision focuses on adding capabilities to the standard
that were not defined originally in 1995. The major additions are:
- New EDI
code 45 for transmitting scale ticket documents for purposes of
verifying first purchaser checkoff assessment procedures.
- New EDI
code 46 for transmitting contract documents for grain delivered
with a "price later" disposition but have not yet been applied
to a "price later" contract. This is record is identical to record
#7 except that no contract number is present.
- New EDI
code 47 for transmitting contract documents for grain delivered
with a "basis" disposition but have not yet been applied to a
"basis" contract. This record is identical to record #8 except
that no contract number is present.
- New grain
codes to accommodate the rapidly expanding numbers of grains that
are not necessarily new but have increasingly diverse value traits.
1. New EDI
Code 45 (First Purchaser Assessment Record)
The Computer
and Technology subcommittee has been at work on this project since
October of 1998. The project was undertaken because several AAWCO
members were performing SPARC audits and the committee felt that
a Uniform Checkoff Audit Procedure (UCAP) for AAWCO members would
provide the opportunity for uniformity, consistency, and automation
via AAWCO EDI for those AAWCO members providing checkoff audit services
now and in the future.
At AAWCO's
spring 1999 meeting in Indianapolis, Ms. Janice Grauberger, Executive
Director of USB addressed members and offered the assistance of
USB and the various state QSSB 's in developing
the SPARC implementation
of the (UCAP). In March of 2000, QSSB's approved the AAWCO implemenation
of UCAP for the SPARC audit.
Although the
most specific need was for SPARC (soybean) checkoff audits, the
committee's goal was to create an underlying set of principals that
could be applied to any commodity checkoff audit. However,
a significant complication arose. Some checkoff audit situations
are routine, while others involve greater levels of scrutiny based
on the customer's wishes. It was resolved that for the 2000 revision
AAWCO would design and specify a so-called "Level I" or "routine"
audit with more complicated "response" audits to be developed in
the future.
Attached to
this document is the proposed Uniform SPARC audit for AAWCO members.
Upon approval it is expected that each AAWCO members state shall
adopt these procedures for performing SPARC audits for their respective
state USSB.
Note that this
document describes SPARC audit performed without the aid of AAWCO's
EDI (AEDI). The committee and USB both recognize the tremendous
potential for AEDI system to gather checkoff information. To that
end, the T&C committee has designed a specification for AEDI,
a new 45th record type. It is our hope that grain software vendors
will update their AEDI specification as soon as practical to include
this information.
| AEDI
New Record #45 -- Checkoff |
| Field No. |
Description |
Data
Type |
Length |
| 1 |
Record
Code |
INTEGER |
2 |
| 2 |
Location |
TEXT |
15 |
| 3 |
Document
number |
INTEGER |
8 |
| 4 |
Name |
TEXT |
25 |
| 5 |
Grain |
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 |
2. &
3. Purchased unapplied Price Later & Basis Contract Record
(#46 & #47)
In some states,
it is acceptable practice for the grain dealer to hold producer-delivered
grain with the intention to apply the grain to a Price Later (Basis)
contract within a specified period of time. This grain is considered,
for the purposes of EDI, to have a disposition of Price Later (Basis)
but would be segregated from #7 applied Price Later (#8 - Basis)
and given the code #46 unapplied Price Later (#47 Basis).
4. Additional
Grain Codes
For the past
2 years, it has been very difficult to attend any grain industry
meeting without hearing about GMOs, value traits, specialty crops,
and biotechnology. Given this fact, it is hardly surprising that
our AEDI system is under increasing pressure to provide methods
to segregate and preserve the identity of grains (even those of
the same specie) who's value traits differ significantly. This is
especially true for those AAWCO members who rely on financial valuations
at audit/exam time to determine violations.
To that end,
the C&T committee has been at work gathering and coding the
various types of grain and their specific characterisics for inclusion
AEDI. Without these specific additions, two significant problems
can arise:
a) Warehouseman/Buyer
and Examiner are forced to electronically comingle grains of differing
value traits.
b) Warehouseman/Buyer
and Examiner are forced to use an unused grain as a placemarker.
c) Warehouseman/Buyer
and Examiner agree to use a non-standard translation grain code
to perform AEDI.
Any of these
3 situations are undesirable for the the AEDI. Therefore, the C&T
committee is resolved to step up efforts to add grain codes as they
become implemented by industry or state agencies.
The following
spreadsheet summarizes AEDI's grain descriptions on the left and
the AEDI codes in the middle column with the year added in the rightmost
column.
|
Grain
Description
|
Code
|
Year
|
|
Amaranth
|
AMR
|
2000
|
|
Barley
(all types)
|
BARLY
|
1995
|
|
Barley
(Blue Malting)
|
BLMB
|
1997
|
|
Barley
(Blue)
|
BLY
|
1997
|
|
Barley
(Malting)
|
MB
|
1997
|
|
Barley
(Six Row)
|
SRB
|
1997
|
|
Bean (Caster)
|
CSTB
|
1997
|
|
Buckwheat
|
BWHT
|
1995
|
|
Canola
|
CNOLA
|
1995
|
|
Corn
(Blue Food Grade)
|
CBFG
|
2000
|
|
Corn
(Food Grade - all types)
|
CFGC
|
2000
|
|
Corn (Mixed)
|
MC
|
1997
|
|
Corn (Popcorn)
|
POPCN
|
1995
|
|
Corn (Screenings
- all types)
|
CSCRN
|
1995
|
|
Corn (Waxy
Yellow)
|
WAXYC
|
1995
|
|
Corn
(White Food Grade)
|
CWFG
|
2000
|
|
Corn
(White Waxy)
|
CWWX
|
2000
|
|
Corn (White)
|
WCORN
|
1995
|
|
Corn
(Yellow Food Grade)
|
CYFG
|
2000
|
|
Corn
(Yellow High Lysine)
|
CYHL
|
2000
|
|
Corn
(Yellow High Oil)
|
CYHO
|
2000
|
|
Corn (Yellow)
|
CORN
|
1995
|
|
Edible
Bean (Abzuka)
|
BAB
|
2000
|
|
Edible
Bean (Adzuki)
|
BAD
|
2000
|
|
Edible
Bean (Anasazi)
|
BAN
|
2000
|
|
Edible
Bean (Black Turtle)
|
BTURT
|
1995
|
|
Edible
Bean (Brown)
|
SWBRN
|
1995
|
|
Edible
Bean (BTS)
|
BBT
|
2000
|
|
Edible
Bean (Cranberry)
|
CRANB
|
1995
|
|
Edible
Bean (Dark Red Kidney)
|
DRKID
|
1995
|
|
Edible
Bean (Garbonzos)
|
BGA
|
2000
|
|
Edible
Bean (Great Northern)
|
BGN
|
2000
|
|
Edible
Bean (Large Lima)
|
BLL
|
2000
|
|
Edible
Bean (Large Red Kidney)
|
LRKID
|
1995
|
|
Edible
Bean (Light Red Kidney)
|
LRK
|
2000
|
|
Edible
Bean (Navy)
|
NAVYB
|
1995
|
|
Edible
Bean (Pinto)
|
PINTB
|
1995
|
|
Edible
Bean (Red Turtle)
|
RTURT
|
1995
|
|
Edible
Bean (Small Red)
|
BSR
|
2000
|
|
Edible
Bean (Small White)
|
BSW
|
2000
|
|
Edible
Bean (Vinton)
|
BVN
|
2000
|
|
Edible
Bean (White Kidney)
|
BWK
|
2000
|
|
Edible
Bean (White Turtle)
|
WTURT
|
1995
|
|
Edible
Bean (Yellow Eye)
|
BYE
|
2000
|
|
Edible
Beans (Pink)
|
BPK
|
2000
|
|
Flaxseed
(all types)
|
FLAXS
|
1995
|
|
Flint
|
FLIN
|
1997
|
|
Grain
(Mixed)
|
MIXGR
|
1995
|
|
Grain
(Non-Standard)
|
NSTDG
|
1995
|
|
Millet
(all types)
|
MILLT
|
1995
|
|
Millet
(White)
|
MWH
|
2000
|
|
Millet
(Yellow)
|
MYE
|
2000
|
|
Mustard
Seed
|
MUS
|
2000
|
|
Mustartd
Seed (Brown)
|
MBR
|
2000
|
|
Oats
|
OATS
|
1995
|
|
Peas
- Chick Gargonzo
|
PCG
|
2000
|
|
Peas
- Dry Whole
|
PDW
|
2000
|
|
Peas
- Green
|
PGN
|
2000
|
|
Peas
- Lentil Chilean
|
PLC
|
2000
|
|
Peas
- Lentil Persian
|
PLP
|
2000
|
|
Peas
- Split
|
PSP
|
2000
|
|
Peas
- Yellow
|
PYL
|
2000
|
|
Proso
(Golden German)
|
PGG
|
2000
|
|
Proso
(Hungarian)
|
PHN
|
2000
|
|
Proso
(Org. White)
|
POW
|
2000
|
|
Proso
(Red)
|
PRD
|
2000
|
|
Proso
(White)
|
PWT
|
2000
|
|
Rapeseed
|
RPE
|
2000
|
|
Rice
(Long Grain)
|
RLG
|
2000
|
|
Rice
(Med. Grain)
|
RMG
|
2000
|
|
Rye
|
RYE
|
1995
|
|
Safflower
Seed
|
SAFF
|
2000
|
|
Sorghum/Milo
(Mixed)
|
XS
|
1997
|
|
Sorghum/Milo
(Yellow)
|
SORGH
|
1995
|
|
Soybean
(Edible - all types)
|
SED
|
2000
|
|
Soybean
(Mixed)
|
XSB
|
1997
|
|
Soybean
(STS)
|
SSTS
|
2000
|
|
Soybean
(White HighLum)
|
SHL
|
2000
|
|
Soybean
(Yellow Chemical Free)
|
SCF
|
2000
|
|
Soybean
(Yellow Organically Grown)
|
SOG
|
2000
|
|
Soybean
(Yellow)
|
SOYBN
|
1995
|
|
Soybeans
(Black)
|
SBB
|
2000
|
|
Spelt
|
SPLTZ
|
1995
|
|
Sunflower
(Bird Seed)
|
SBS
|
2000
|
|
Sunflower
(Black Oil)
|
SFLRO
|
1995
|
|
Sunflower
(Confection)
|
SFLRC
|
1995
|
|
Triticale
|
TRIT
|
1995
|
|
Wheat
(Amber Durum)
|
ADU
|
1997
|
|
Wheat
(Dark Northern Spring)
|
DNS
|
1997
|
|
Wheat
(Hard Amber Durum)
|
HADU
|
1997
|
|
Wheat
(Hard Red Spring)
|
HRS
|
1997
|
|
Wheat
(Hard Red Winter)
|
HRW
|
1997
|
|
Wheat
(Hard White)
|
HDWH
|
1997
|
|
Wheat
(Mixed)
|
XWHT
|
1997
|
|
Wheat
(Northern Spring)
|
NS
|
1997
|
|
Wheat
(Other White)
|
OWH
|
1997
|
|
Wheat
(Red Spring)
|
RS
|
1997
|
|
Wheat
(Soft Red Mixed)
|
SRWHT
|
1995
|
|
Wheat
(Soft Red Spring)
|
WSRS
|
2000
|
|
Wheat
(Soft Red Winter)
|
WSRW
|
2000
|
|
Wheat
(Soft White)
|
WSW
|
2000
|
|
Wheat
(White)
|
WWHT
|
1995
|
END.
Back
to top | Back to EDI Menu
|