EDI 810 SAMPLE TEMPLETE

[Former Member]

HAI,

Can any one send me the sample templete of EDI810 sheet.

Thanks

avi

[Former Member]

Hi,

Generic 810 Invoice Mapping Document

Segment Data Element Name Codes and comments Idoc Segment Field Qualifier Field Qualifier Value Notes on Mapping Document

ISA01 Authorization Information Qualifier "00" No Authorization information

ISA02 Authorization information

ISA03 Security information Qualifier "00" No Security Information

ISA04 Security information Ten Blank Positions

ISA05 Interchange ID Qualifier

ISA06 Interchange Sender ID

ISA07 Interchange ID Qualifier

ISA08 Intechange Receiver ID

ISA09 Interchange Date

ISA10 Interchange Time

ISA11 Interchange Standards Identifier

ISA12 Interchange version ID

ISA13 Interchange Control Number

ISA14 Acknowledgement Requested

ISA15 Test Indicator

ISA16 Component Element Separator

GS - Functional Group Header

GS01 Functional ID "IN" Invoice

GS02 Application Senders Code Same ID as ISA06

GS03 Application Receiver's Code Same ID as ISA08

GS04 Date E1EDK03 DATUM IDDAT "012" "CREATION DATE INVOICE"

GS05 Time

GS06 Group Control Number

GS07 Responsible agency code

GS08 Version

ST -Transaction Header

ST01 Transaction Set ID "810"

ST02 Transaction Set Control Number

BIG - Beginning Segment

BIG01 Date E1EDK03 DATUM IDDAT "026" "BILLING DATE"

BIG02 Invoice Number E1EDK01 BELNR "INVOICE NUMBER"

BIG03 Date E1EDK03 DATUM IDDAT "021" " PRICING NUMBER"

BIG04 Purchase order Number E1EDK02 BELNR QUALF "001" "PO DATA"

REF - Reference Identifier

REF01 Reference Identification Qualifier E1EDKT1 TDID "0002"

REF02 Reference Identification E1EDKT2 TDLINE "HEADER NOTE"

REF - Reference Identificaiton

REF01 Reference Identification Qualifier "IA" Internal Supplier Number

REF02 Reference Identification E1EDKA1 LIFNR PARVW RS "VENDOR NUMBER"

N1 - Name

N101 Entity Identifier Code "BY" Buying Party E1EDKA1 PARVW AG

N102 Name E1EDKA1 NAME1 PARVW AG NAME

N103 Identification Code Qualifier

N104 Identification Code E1EDKA1 PARTN PARVW AG BUYING PARTY(SP)

N3 - Address Information

N301 Address Information E1EDKA1 STRAS PARVW RS HOUSE AND STREET NUMBER

N302 Address Information STRS2 PARVW

N4 - Geographic Location

N401 City Name E1EDKA1 ORT01 PARVW WE CITY

N402 State or Province Code E1EDKA1 REGIO PARVW WE REGION

N403 Postal Code E1EDKA1 PSTLZ PARVW WE PIN CODE

N404 Country Code E1EDKA1 LAND1 PARVW WE COUNTRY

N405 Location Qualifier

N406 Location Identifier

N1 - Name

N101 Entity Identifier Code "ST" Ship-to E1EDKA1 PARVW RE

N102 Name E1EDKA1 NAME1 PARVW RE NAME

N103 Identification Code Qualifier

N104 Identification Code E1EDKA1 PARTN PARVW RE BILL TO PARTY

N3 - Address Information

N301 Address Information E1EDKA1 STRAS PARVW RS INVOICING PARTY'S HOUSE NUMBER

N302 Address Information STRS2 PARVW RS ?????????????

N4 - Geographic Location

N401 City Name E1EDKA1 ORT01 PARVW RE BP-CITY

N402 State or Province Code E1EDKA1 REGIO PARVW RE REGION

N403 Postal Code E1EDKA1 PSTLZ PARVW RE PIN CODE

N404 Country Code E1EDKA1 LAND1 PARVW RE COUNTRY

N405 Location Qualifier

N406 Location Identifier

ITD - Terms of Sale

ITD01 Terms Type Code

ITD02 Terms Basic Data Code

ITD03 Terms Discount Percent E1EDK18 PRZNT QUALF "001"

ITD04 Terms Discount Due Date

ITD05 Terms Discount Days Due E1EDK18 TAGE QUALF "001"

ITD06 Terms Net Due Date

ITD07 Terms net Days E1EDK18 TAGE QUALF "002"

ITD08 Terms Discount Amount

ITD09 Terms Deffered Due Date

ITD10 Deffered Amount Due

ITD11 Percent of Invoice Payable

ITD12 Description E1EDK18 ZTERM_TXT QUALF "001" "PAYMENT TERM TEXT"

DTM -- DATE/Time Reference

DTM01 Date/Time Qualifier

DTM02 Date

FOB - F.O.B. Related Instructions

FOB01 Shipment Method of Payment "CC" Collect, "BX" box, "CA" case, "EA" Each, "FT" feet, "PK" Package, "PC" Piece, "PR" Pair, "RL" Roll, "ST" Set, "YD" Yard

IT1 - Baseline of Item Data

IT101 Assigned ID Purchase Order Line Number E1EDP02 ZEILE QUALF "002" " SALE ORDER ITEM NUMBER"

IT102 Quantity Invoices E1EDP01 MENGE " INVOICE QUANTITY"

IT103 Unit of Measure code E1EDP01 MENEE " SALES UNIT--- UNIT OF MEASURE"

IT104 Unit price Price per U of M E1EDP26 BETRG QUALF "002" " UNIT PRICE"

IT105 Basis of Unit Price

IT106 Product/Service ID Qualifier "CB" Buyers Catalogue Number

IT107 Product/Service ID E1EDP19 IDTNR QUALF "002" " MATERIAL"

IT108 Product/Service ID Qualifier

IT109 Product/Service ID E1EDP19 IDTNR QUALF "003"

IT110 Product/Service ID Qualifier

IT111 Product/Service ID E1EDP19 IDTNR QUALF "003"

PID - Product / Item Description

PID01 Item Description Type "F" Free Form

PID02 Product/Process Characteristic Code

PID03 Agency Qualifier Code

PID04 Product Description Code

PID05 Description E1EDP19 KTEXT QUALF "001" " KTEXT IS AVAILABLE IN QUALIFIER 002"

PID06 Surface/Layer/Position Code

PID07 Source Subqualifier

PID08 Yes/No Condition or Response Code

PID09 Language Code

PO4 -- Packing Information There is currently no Segments which present line item packing information within the IDoc. Commonly a user exit within the IDoc is created to provide this information on the outgoing IDoc transmission

PO401 Pack

PO402 Size

PO403 Unit or Basis for Measurement Code

PO404 Packaging Code

PO405 Weight Qualifier

PO406 Gross Weight per Pack

PO407 Unit or Basis for Measurement Code

PO408 Gross Volume per Pack

PO409 Unit or Basis for Measurement Code

PO410 Length

PO411 Width

PO412 Height

PO413 Unit or Basis for Measurement Code

PO414 Inner Pack

PO415 Surface/Layer/Position Code

PO416 Assigned Identification

PO417 Assigned Identification

PO418 Number

SAC -- Allowances and Charges

SAC01 Allowance or Charge Indicator "A" or "C" This value will be defined by the specific allowance or charge value that is presented in the E1EDP26-QUALF field

SAC02 Service, Promotion, Allowance, or Charge Code E1EDP26 QUALF A Conversion must often be performed in order to take the SAP R/3 value and convert it into the predefined EDI allowance or charge code.

SAC03 Agency Qualifier Code

SAC04 Agency Service, Promotion, Allowance, or Charge Code

SAC05 Amount E1EDP26 QUALF QUALF "003" "AMOUNT FIELD IS AVAIALABLE IN SEGMENT E1EDP26 WITH THE QUALIFIER QUALF 003 WITH THE FILED NAME BETRG

SAC06 Allowance/Charge Percent Qualifier

SAC07 Percent

SAC08 Rate

SAC09 Unit or Basis for Measurement Code

SAC10 Quantity

SAC11 Quantity

SAC12 Allowance or Charge Method of Handling Code

SAC13 Reference Identification

SAC14 Option Number

SAC15 Description

SAC16 Language Code

TDS - Total Monetary Amount

TDS01 Amount E1EDS01 SUMME SUMID "011" " INVOICE AMOUNT - NET VALUE"

CAD - Carrier Detail

CAD01 Mode

CAD02 Equipment Initial

CAD03 Equipment Number

CAD04 SCAC E1EDKA1 PARTN PARVW "SP" "SP- PARTNER"

CAD05 Routing Carrier's Name E1EDKA1 NAME1 PARVW "SP" "SP-NAME"

SAC -- Allowances and Charges To provide this segment with all the valid information required there is often development done to populate the E1EDS01 Segment with information pertaining to a valid allowance or charge. To avoid development there is also the option of adding up the respective values at the line item level and then populating the total in this segment.

SAC01 Allowance or Charge Indicator E1EDS01 SUMID SUMID "001" This value will be defined by the specific allowance or charge value that is presented in the E1EDS01-SUMIDF field

SAC02 Service, Promotion, Allowance, or Charge Code

SAC03 Agency Qualifier Code

SAC04 Agency Service, Promotion, Allowance, or Charge Code

SAC05 Amount E1EDS01 SUMME SUMID "001" A Conversion must often be performed in order to take the SAP R/3 value and convert it into the predefined EDI allowance or charge code.

SAC06 Allowance/Charge Percent Qualifier

SAC07 Percent

SAC08 Rate

SAC09 Unit or Basis for Measurement Code

SAC10 Quantity

SAC11 Quantity

SAC12 Allowance or Charge Method of Handling Code

SAC13 Reference Identification

SAC14 Option Number

SAC15 Description

SAC16 Language Code

ISS -- Invoice Shipment Sumary There is currently no segment within the IDoc that corresponds to the information in the ISS Segment. It is often common for a user exit to be used to populate information in another E1DEDS01 Segment in order to provide this information on the IDoc.

<b>Just copy it and past in Xcel it will be helpful

</b>

Thanks

Manju

[Former Member]

Hi Manju,

I have requirement to generate text file with X12 format for transaction set 850(Purchase Order), Please could you share Mapping Template for X12 850 with Message type ORDERS and iDOC type(ORDRS01 or ORDRS02 or ORDRS03 or ORDRS04).

Thanks!

Jelli

[Former Member]

Hi Manju,

Could you please provide Mapping sheet for X12 850 to message type ORDERS and iDOC type (ORDERS01, ORDERS02, ORDERS03, ORDERS04, ORDERS05). I am not able to completed development for  requirement(to Generate text file in X12 format).

Thanks!

Jelli

[Former Member]

Where is E1EDPT2 mapped in the above mapping?