EDI Mapping for INBOUND INVOICES (880)
Version 4010UCS
Segments used by Grocers
Header Description
ST Transaction
Set Header
G01 Invoice
Identification
N9 Reference
Number
G62 Date/Time
NTE Note/Special
Instruction
G27 Carrier Detail
G23 Terms
of Sale
G25 F.O.B.
Information
N1 Name
N3 Address
Information
N4 Geographic
Location
G72 Allowance
or Charge
G73 Allowance
or Charge Description
Detail Description
G17 Item
Detail Invoice
G69 Line
Item Detail - Description
G72 Allowance or Charge
G73 Allowance
or Charge Description
Summary Description
G31 Total
Invoice Quantity
G33 Total
Dollars Summary
SE Transaction
Set Trailer
ST01 '880' Transaction Set ID
Code
ST02 Transaction
Set Control Number
G0101 yyyymmdd Invoice Date
G0102 Invoice
Number (up to 10 digits)
G0103 yyyymmdd PO Date
G0104 PO
Number
N901 ‘BM’ Reference Number
Qualifier (if applies)
N902 Bill
of Lading # (if applies)
G6201 '11' Date Shipped
Qualifier
G6202 ship
date Date Shipped
NTE02 Free
Form Message
G2701 'M'
or “H’ Transportation
Type Code
G2705 Carrier
Name
G2301 Terms
Type Code
G2302 Terms
Basis Date Code
G2303 yyyymmdd Terms Start Date
G2304 Terms
Due Date Qualifier
G2305 Terms
Discount Percent
G2306 yyyymmdd Terms Discount Due Date
G2307 Terms
Discount Days Due
G2308 yyyymmdd Terms Net Due Date
G2309 Terms
Net Days
G2310 Terms
Discount Amount
G2311 Discounted
Amount Due
G2315 Free-Form
Message
G2501 Ship
Method of Payment
G2502 F.O.B.
Point Code
G2503 F.O.B.
Point
N101 'VN'
Entity ID
Code
N102 vendor Vendor Name
N101 'RE'
Entity ID Code
N102 vendor Remit to Name
N301 Remit
to address
N401 Remit
to City
N402 Remit
to State
N403 Remit
to Zip
N101 'BT'
Entity ID
Code
N102 Grocers
Supply Co. Bill to Name
N103 '9' ID Code
Qualifier
N104 ID
Code (Bill to Duns)
N301 Address
Info-1
N401 City
N402 State
N403 Zip
N101 'ST'
Entity ID
Code
N102 Grocers
Supply Co. Bill to Name
N103 '9' ID Code
Qualifier
N104 ‘0079314390000’ ID Code (Ship to Duns)
N301 ‘P.O.
Box 14200’ Ship to Address I
N401 ‘Houston’ Ship to City
N402 ‘TX’ Ship
to State
N403 ‘77221’ Ship
to Zip
G7201 Allowance/Charge
Code
G7202 Allow/Charge
Handling Code
G7208 Allowance/Charge
Total Amount
G7301 Free-Form
Description of Allowance
G1701 Quantity
Invoiced
G1702 Unit
of Measure
G1703 Item
List Cost
G1704 UPC
Case Code
G1705 Product
ID Qualifier
G1706 Product
ID
G6901 Free-Form
Description
G7201 Allow/Charge
Code
G7202 Allow/Charge
Handle Code
G7203 Allow/Charge
Number
G7205 Allow/Charge
Rate
G7206 Allow/Charge
Quantity
G7207 Allow/Charge
Unit Measure Code
G7208 Allow/Charge
Total Amount
G7301 Free-Form
Description
Segment Data
Entered Description
G3101 Number
of Units Shipped
G3102 Unit
of Measure Code
G3103 Weight
G3204 Unit
of Measure Code (Weight)
G3208 Price
Bracket ID
G3301 Total
Invoice Amount
SE01 Number
of Included Segments
SE02 Transaction
Set Control Number
|