EC Task Force EDIPro Flat File - DRAFT

832H – Header Record Layout

Field # / Field Name / Type/Size / Req. / Comments / (Examples)
ST_01 / Transaction ID / X(4) / M / “832H”
DTM02 / Transaction Date / X(8) / M / (19991231)
DTM02 / Effective Date (20000101) / X(8) / O / YYYYMMDD (Century|Year|Month|Day)
N1_04 / Seller’s Duns+4 / X(13) / M / 9-digit D&B Company ID + 4-digit Location code
N1_04 / Buyer’s Duns+4 / X(13) / O / Used only to restrict issuance to a customer or group

832I – Item Detail Record Layout

Field # / Field Name / Type/Size / Req. / Comments / (Examples)
ST_01 / Transaction ID / X(4) / M / “832I”
G5301 / Maintenance Type / ID(3) / M / (001-Change, 002-Delete, 021-Add)
LIN03 / UPC (1-5-5) / X(11) / O / Required by several industry groups
G5502 / UCC-14 (1-2-5-5-1) / X(14) / O / Pack Indicator|Country|Vendor|Item #|Check Digit
LIN05 / Catalog Number / X(48) / M / Some systems have a 15 character maximum
PID02 / Description / X(80) /

M

/ Some systems have a 24 character maximum
XXXX* / Extended Item Description – Not X-12 / 240 /

O

/ Full, searchable, sortable (Ariba, CommerceOne) Description
PID05 / General Product Category / X(12) / O / IBCA EC Task Force recommends UN/SPSC
PID05 / Industry Product Category / X(12) / O / (AAIA Parts Definition, ATA VMRS, NEMA)
CTB04 / Incremental Purchase Quantity (EA) / R(8) / M / Resale, Pack, Container, Layer, Pallet Quantities

832P – Pricing Detail Record Layout

Field # / Field Name / Type/Size / Req. / Comments / (Examples)
ST_01 / Transaction ID / X(4) / M / “832P”
G5301 / Maintenance Type / ID(3) / M / (001-Change, 002-Delete, 021-Add)
BCT02 / Price Sheet Number/Description / X(15) / M / Price Sheet Number and Description
CTP03 / Price / R(17) / M / (12.50)
CTP09 / Unit of Measure /

ID(2)

/ M / (PE, HP, TP)

SAMPLE (2 Items)

832H,19991230,20000101,1111111111111,2222222222222

832I,021,11111100001,00111111000012,WID001, WIDGET-LEFT HANDED-GREEN,02020202,2100,1

832P,021,BLUE,1.35,PE

832P,021,GOLD,1.00,PE

832I,021,11111100001,30111111000018,WID001, WIDGET-LEFT HANDED-GREEN,02020202,2100,10

832P,021,BLUE,1.35,PE

832P,021,GOLD,.905,PE

832I,021,11111100001,50111111000016,WID001, WIDGET-LEFT HANDED-GREEN,02020202,2100,100

832P,021,BLUE,1.35,PE

832P,021,GOLD,.875,PE

832P,021,SPECIAL,.85,PE

832I,021,11111100002,00111111000024,WID002, WIDGET-RIGHT HANDED-GREEN,02020202,2100,1

832P,021,BLUE,1.45,PE

832P,021,GOLD,1.05,PE

ETC.

OPTIONAL

832H,19991230,20000101,1111111111111,2222222222222

832I,021,11111100001,00111111000012,WID001, WIDGET-LEFT HANDED-GREEN,02020202,2100,1

832P,021,BLUE,1.35,PE

832P,021,GOLD,1.00,PE

832I,021,11111100001,30111111000018,,,,,10

832P,021,BLUE,1.35,PE

832P,021,GOLD,.905,PE

832I,021,11111100001,50111111000016,,,,,100

832P,021,BLUE,1.35,PE

832P,021,GOLD,.875,PE

832P,021,SPECIAL,.85,PE

832I,021,11111100002,00111111000024,WID002, WIDGET-RIGHT HANDED-GREEN,02020202,2100,1

832P,021,BLUE,1.45,PE

832P,021,GOLD,1.05,PE

ETC.

832X – Extended Product Information (EPI)

Field # / Field Name / Type/Size / Req. / Comments / (Examples)
ST 01 / Transaction ID / X(4) / M / “832X”
G5301 / Maintenance Type / ID(3) / M / (001-Change, 002-Delete, 021-Add)
PID05 / Code / Description (See EDIPro EPI list below) / X(80) /

M

/ (TXASC Compatible with Gidget GID001)

PRSC1Seller’s Class Code – “Widget”

PRSC2Seller Sub-Class Code = - “Widget005”

SPCFACertification Agency – “UL”

SPCFNCertification Code – “RBY52T6341”

SPFCCFreight Classification Code – “77”

SPSICStock Indicator Code (Stock, Non-Stock, Quick Ship) – “S”

TXASCAssociated Comments – “Compatible with Gidget GID001”

TXBROBrochure Filename – “BROCHUREAAA001EN.GIF”

TXBULTechnical Bulletin Filename– “TECHBULLETINGAAA001.BMP”

TXCATCatalog Description – “Widget with red handle”

TXDRWTechnical Drawing Filename – “TECHDRWGAAA001.BMP”

TXFENFull Engineering Drawing Filename – “ENGDRWGAAA001.BMP”

TXINSInstallation Instructions Filename – “INSTALLWIDGET.RTF”

TXINVInvoice Description - – “Widget Green Left-Handed”

TXLBLLabel Description – “Widget, red handle”

TXLINLine Drawing Filename - “LINEDRWGAAA001.BMP”

TXLLADescription Language Code – “EN”

TXMSDMaterial Safety Data Sheet (MSDS) Filename – “WIDGET MSDS.TXT”

TXPCDPallet Configuration Drawing Filename – “PALLETCONTPLTAAA001.TXT”

TXPICPicture Filename – “ITEMPIC.PIC”

TXPOLProduct General Policies – “No returns allowed”

TXPORProduct Ordering Restrictions – “Quantities larger than a pallet require additional lead time”

TXSDKSeller Defined Key Words – “Widget Red-Handle Green Left-Handed”

TXSHRShipping Restrictions – “Pallets must be shrink wrapped”

TXSLASlang Description – “One Hand Widget”

TXSPESpecification Sheet Filename – “ITEMSPECEN.TXT”

URBROBrochure URL – “

URBULTechnical Bulletin URL - “

URDRWTechnical Drawing URL – “

URFENFull Engineering Drawing URL – “

URINSInstallation Instructions URL – “

URLINLine Drawing URL – “

URMSDMaterial Safety Data Sheet (MSDS) URL – “ WIDGET HAZARDS”

URPCDPallet Configuration Drawing URL – “

URPICPicture URL – “

URSPESpecification Sheet URL – “

850 Purchase Order

Field # / Field Name / Type/Size / Req. / Comments / (Examples) / X.12 Ref
85001 / Transaction ID / X(4) / M / “850Z” / ST_01
85002 / Transaction Date / Date / M / CCYYMMDD / BEG05
85003 / Buyer’s Duns+4 / X(13) / M / (1234567890001) / N1_04
85004 / Seller’s Duns+4 / X(13) / M / (2345678910000) / N1_04
85005 / PO Type / ID(2) / O / Rush, New, Drop Ship… (DS, PR, EO, RO, NE) / BEG02
85006 / PO Number / X(22) / M / (A234567) / BEG03
85007 / Line Number Loop / X(4) / M / (0001) / PO101
85008 / Quantity / X(11) / M / (100) / PO102
85009 / Price / R(17) / O / (12.345} / PO104
85010 / Catalog Number / X(48) / C / (WID001) / PO107
85011 / UPC / X(11) / C / (78123412345) / PO109
85012 / Buyer Part Number / X(25) / O / (ACM-WID1) / PO111
85013 / Line Number Loop / X(4) / M / (0002) / PO101
85014 / Quantity / X(11) / M / (50) / PO102
85015 / Price / R(17) / O / (23.45} / PO104
85016 / Catalog Number / X(48) / C / (WID002) / PO107
85017 / UPC / X(11) / C / (78123454321) / PO109
85018 / Buyer Part Number / X(25) / C / (ACM-WID2) / PO111

Example: 850Z,20000531,1234567890001,2345678910000,NE,A234567,0001,100,12.345,WID001,78123412345, ACM-WID001,0002,50,23.45,78123454321,ACM-WID2^

Notes:

852 Product Activity
Field # / Field Name / Type/Size / Req. / Comments / (Examples)
ST_01 / Transaction ID / X(4) / M / “852F”
XQ_01 / Transaction Date / Date / M / CCYYMMDD
XPO01 / First PO# of Range / X(22) / O / (000100)
XPO02 / Last PO# of Range / X(22) / O / (000199)
N1_04 / Reporting Location Duns+4 / X(13) / M / (1234567890001)
N1_04 / Seller’s Duns+4 / X(13) / M / (2345678910000)
LIN03 / Catalog Number / X(16) / C / WID001
LIN05 / UPC (1-5-5) / X(11) / C / 12345612345
ZA_01 / Activity Code* / ID / M / (QS)
ZA_02 / Quantity / R / M / 25
ZA_01 / Activity Code* / ID / M / (OC)
ZA_02 / Quantity / R / M / 2

*Possible Activity Codes are:

OQPlanned Order QuantityQAAvailable InventoryQLMinimum (Order Point)

QOOut of Stock (Backordered)QPOn-Order (Outside System)QRReceived

QSSold (Orders Entered)***OCTimes Sold (Occurrences)

______

*** Method of Transmitting (up-to 25 Months) Sales History

ST_01 / Transaction ID / X(4) / M / “852H”

ZA*QS*432*EA**19991227*ZZ*003^ - Dec. 1999 To-Date had 3 sales for 432 items.

ZA*QS*56*EA**19991101*ZZ*002^ - November of 1999 had 2 sales for 56 items.

… (Another NN months) … - October of 1999 back through November 1997.

ZA*QS*765*EA**19971201*ZZ*007^ - December of 1997 had 7 sales for 765 items.

852 Product Activity History
Field # / Field Name / Type/Size / Req. / Comments / (Examples)
ST_01 / Transaction ID / X(4) / M / “852H”
XQ_01 / Transaction Date / Date / M / (19991231)
N1_04 / Reporting Location Duns+4 / X(13) / M / (1234567890001)
N1_04 / Seller’s Duns+4 / X(13) / M / (2345678910000)
LIN03 / Catalog Number / X(16) / C / WID001
LIN05 / UPC (1-5-5) / X(11) / C / 12345612345
ZA_01 / Activity Code / ID / M / (QA)
ZA_02 / Quantity / R / M / (668) – Available Inventory
ZA_01 / Activity Code / ID / M / (OQ)
ZA_02 / Quantity / R / M / (500) – Planned Order Quantity
ZA_01 / Activity Code / ID / M / (QL)
ZA_02 / Quantity / R / M / (750) – Planned Order Point
ZA_01 / Activity Code / ID / M / (QS)
ZA_02 / Quantity / R / M / 432 - Dec. 1999 To-Date had sales of 432 units
ZA_05 / Sales Period – Month-to-Date / Date / M / (19991227)
ZA_01 / Activity Code / ID / M / (OC)
ZA_02 / Quantity / R / M / (13) - Dec. 1999 To-Date it was sold 13 times
ZA_01 / Activity Code / ID / M / (QS)
ZA_02 / Quantity / R / M / 432 - November 1999 had sales of 356 units
ZA_05 / Sales Period – Month Beginning / Date / M / (19991101)
ZA_01 / Activity Code / ID / M / (OC)
ZA_02 / Quantity / R / M / (22) – In November it was sold 22 times
XXXX / … (Another NN months) / XX / X / …. October of 1999 back through November 1997…
ZA_01 / Activity Code / ID / M / (QS)
ZA_02 / Quantity / R / M / 265 - December 1997 had sales of 265 units
ZA_05 / Sales Period – Month Beginning / Date / M / (1991201)
ZA_01 / Activity Code / ID / M / (OC)
ZA_02 / Quantity / R / M / (12) – In December 1999 it was sold 12 times
855 Purchase Order Acknowledgement
Field # / Field Name / Type/Size / Req. / Comments / (Examples)
ST_01 / Transaction ID / X(4) / M / “855F”
BAK02 / Acknowledgement Type / X(2) / M / W/Change, No Change, VMI (AC, AD, AP)
BAK03 / PO Number / X(22) / M / (A234567)
BAK04 / PO Date / Date / M / CCYYMMDD
BAK08 / Order Number – Seller / X(30) / M / (987654)
BAK09 / Acknowledgement Date / Date / M / CCYYMMDD
N1_04 / Buyer’s Duns+4 / X(13) / M / (1234567890001)
N1_04 / Seller’s Duns+4 / X(13) / M / (2345678910000)
PO101 / Line Number / X(11) / M / (0001)
PO102 / Quantity / R / M / (100)
PO107 / Catalog Number / X(16) / C / (WID001)
PO109 / UPC / X(11) / C / (12345612345)
PO101 / Line Number / X(11) / M / (0002)
PO102 / Quantity / R / M / (50)
PO107 / Catalog Number / X(16) / C / (WID002)
PO109 / UPC / X(11) / C / (12345623456)

Notes:

856 Advance Ship Notice
Field # / Field Name / Type/Size / Req. / Comments / (Examples)
ST_01 / Transaction ID / X(4) / M / “856F”
BSN02 / Reference Number (Seller Order #) / X(30) / M / 987654
BSN03 / Date Shipped / Date / M / CCYYMMDD
N1_04 / Ship-To Duns+4 / X(13) / M / (1234567890001)
N1_04 / Seller’s Duns+4 / X(13) / M / (2345678910000)
PRF01 / PO Number / X(22) / M / (A234567)
LIN01 / Line Number / X(11) / M / (0001)
LIN03 / Catalog Number / X(48) / C / WID001
LIN04 / UPC / X(11) / C / 12345612345
SN102 / Quantity Shipped / R(10) / M / 100
LIN01 / Line Number / X(11) / M / (0002)
LIN03 / Catalog Number / X(48) / C / WID002
LIN04 / UPC / X(11) / C / 12345623456
SN102 / Quantity Shipped / R(10) / M / 50

Notes:

810 Invoice

Field # / Field Name / Type/Size / Req. / Comments / (Examples) / X.12 Ref
81001 / Transaction ID / X(4) / M / “810Z” / ST_01
81002 / Buyer’s Duns+4 / X(13) / M / (1234567890001) / N1_04
81003 / Seller’s Duns+4 / X(13) / M / (2345678910000) / N1_04
81004 / Invoice Date / Date / M / CCYYMMDD / BIG01
81005 / Invoice Number / X(22) / M / (987654) / BIG02
81006 / PO Number / X(22) / M / (A234567) / BIG04
81007 / Invoice Line Number Loop / X(4) / M / (0001) / ITI01
81008 / Quantity Ordered (Shipped) / X(11) / O / (100) / ITI02
81009 / Price / R(17) / O / (12.345} / ITI04
81010 / Catalog Number / X(48) / C / (WID001) / ITI07
81011 / UPC / X(11) / C / 1-5-5 / ITI09
81012 / Buyer Part Number / X(25) / O / ACM-WID1 / ITI11
81013 / Invoice Line Number Loop / X(4) / M / (0002) / ITI01
81014 / Quantity Ordered (Shipped) / X(11) / O / (50) / ITI02
81015 / Price / R(17) / O / (23.45} / ITI04
81016 / Catalog Number / X(48) / C / (WID002) / ITI07
81017 / UPC / X(11) / C / 1-5-5 / ITI09
81018 / Buyer Part Number / X(25) / O / ACM-WID2 / ITI11
81019 / Total Invoice Amount / R(15) / M / (12345) - Interpreted as $123.45 / TDS01
81020 / Tax Amount / R(15) / O / (6.54) / TXI01
81021 / Allowance/Charge ID / ID / M / (A010-Minimum, D240-Freight, D500-Handling) / SAC02
81022 / Amount / R(15) / M / (1000) – Interpreted as $10.00 / SAC05

Example: 810Z,1234567890001,2345678910000,20000531,987654,A234567,0001,100.12.345,WID001,78123412345, ACM-WID1,0002,50,23.45,WID002,78123454321,ACM-WID2,12345,6.54,D240,1000^

Notes:

IBCA EC Task Force Documentation Provided by Profile SystemsPage 1