About AAWCO
Membership
Meetings
Laws & Regs
Computerization
Related Links
Home

Computerization: EWR:
Appendix A - Data Record

Appendix A — DATA RECORD
AAWCO ELECTRONIC WAREHOUSE RECEIPT SYSTEM: REVISION 9
Changes from Revision 8 are shown in Purple

Field #

Description

Data Type Bytes

1)

Warehouse License ID Number Character Field 8 KEY

2)

Licensed Warehouse Name Character Field 40

3)

Licensed Warehouse City Character Field 40

4)

Licensed Warehouse State Character Field 40

5)

Warehouse Facility ID Character Field 8 KEY

6)

Warehouse Facility Name Character Field 40

7)

Warehouse Facility City Character Field 40

8)

Warehouse Facility State Character Field 2

9)

Holder ID Number Character Field 8 KEY

10)

Holder Name Character Field 40

11)

Holder City Character Field 40

12)

Holder State Character Field 2

13)

Warehouse Receipt Number Character Field 7

14)

Grain Type Character Field 10

15)

Grade Character Field 40

16)

Issuance Date (MM/DD/YYYY) Date Field 10

16.1)

Issuance Date Time Stamp (HH:MM:SS) Time Field 8

17)

Cancellation Date (MM/DD/YYYY) Date Field 10

17.1)

Cancellation Date Time Stamp (HH:MM:SS) Time Field 8

18)

Expiration Date (MM/DD/YYYY) Date Field 10

18.1)

Expiration Date Time Stamp (HH:MM:SS) Time Field 8

19)

Storage Paid Through Date (MM/DD/YYYY) Date Field 10

19.1)

Storage Paid Thru Time Stamp (HH:MM:SS) Time Field 8

20)

Date of Deposit (MM/DD/YYYY) Date Field 10

20.1)

Date of Deposit Time Stamp (HH:MM:SS) Time Field 8

21)

Unit of Measure: "Units": (i.e. "bushel") Character Field 10

22)

Pounds Per Unit (for 23, 24, and 25) 4 ROD Numeric Field 16

23)

Gross Pounds (inc. dockage): 16 digits 4 ROD Numeric Field 16

24)

Dockage Pounds: 16 digits 4 ROD Numeric Field 16

25)

Net Pounds: 16 digits 4 ROD Numeric Field 16

26)

Gross Units: 16 digits 4 ROD Numeric Field 16

27)

Dockage Units: 16 digits, 4 ROD Numeric Field 16

28)

Net Units: 16 digits 4 ROD Numeric Field 16

29)

Test Weight (Lbs per Unit): 16 digits, 4 ROD Numeric Field 16

30)

Moisture %: 5 digits, 2 ROD * Numeric Field 5

31)

Total Damage %: 5 digits, 2 ROD * Numeric Field 5

32)

Heat Damage %: 5 digits, 2 ROD * Numeric Field 5

33)

Foreign Material %: 5 digits, 2 ROD * Numeric Field 5

34)

Protein %: 5 digits, 2 ROD * Numeric Field 5

35)

Splits %: 5 digits, 2 ROD * Numeric Field 5

36)

Sounds %: 5 digits, 2 ROD * Numeric Field 5

37)

Shrunken & Broken %: 5 digits, 2 ROD * Numeric Field 5

38)

Total Defects %: 5 digits, 2 ROD * Numeric Field 5

39)

Other Quality Factors %: 5 digits, 2 ROD * Numeric Field 5

40)

Elevation Charges - Inbound: 16 digits, 4 ROD Numeric Field 16

41)

Elevation Charges - Outbound: 16 digit, 4 ROD Numeric Field 16

42)

Applicable Storage Tariff (cents/unit/day) 16 digit, 8 ROD Numeric Field 16

42.1)

Processing Charge (cents/unit) 16 digit, 8 ROD Numeric Field 16

43)

Receipt Status: 2 character Character Field 2
(O=Open, C=Canceled, A=Replaced By Paper, B=Replaced Paper, L = Open with Lienholder)
In additon, additional codes may further describe status "C"(canceled). For example,"CO" = canceled to open store "CW" = canceled to another warehouse receipt "CS" =canceled and sold to warehouseman "CM"= canceled and shipped by holder.

43.1)

Negotiable Status: (N=Negotiable, O=Non-Negotiable) Character Field 1

44)

Received Via: (T = Truck, R = Rail, B = Barge) Character Field 1

45)

Remarks/Terms and Conditions Character Field 254

46)

Name Of Person Signing Receipt Character Field 40

47)

Lienholder ID Number Character Field 10 KEY

48)

Lienholder Name Character Field 40

49)

Lienholder City Character Field 40

50)

Lieholder State Character Field 2

51)

CCC Code No. Character Field 6

52)

U.S. Warehouse Code Character Field 6

53)

Paper Warehouse Receipt Number Character Field 7

54)

Disclosure Statement Character Field 254

55)

Unofficial Comment Area Character Field 254

56)

Identity Preservation Number (IP#) Character Field 8

Proposed Standard of Operation | Appendix B - Change Record | Appendix C - Transmission Requirements | Appendix D - EWR Committee Members | Request for Comments

Back to top

Ken Henderson, AAWCO Secretary • Grain Regulatory Services • Missouri Department of Agriculture
1616 Missouri Blvd, P.O. Box 630 • Jefferson City, MO 65102 • 573-751-5514 • 573-751-5516 Fax
Ken.Henderson@mda.mo.gov