EXTOL/SAP 810 Outbound Map Template

Download xls file

0








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 Ten Blank Positions




ISA03 Security information Qualifier

"00" No Security Information




ISA04 Security information Ten Blank Positions




ISA05 Interchange ID Qualifier 0




ISA06 Interchange Sender ID 0




ISA07 Interchange ID Qualifier 0




ISA08 Intechange Receiver ID 0




ISA09 Interchange Date





ISA10 Interchange Time





ISA11 Interchange Standards Identifier :




ISA12 Interchange version ID 00403




ISA13 Interchange Control Number





ISA14 Acknowledgement Requested 0




ISA15 Test Indicator P




ISA16 Component Element Separator >














GS - Functional Group Header
GS01 Functional ID "IN" Invoice




GS02 Application Senders Code 0




GS03 Application Receiver's Code 0




GS04 Date





GS05 Time





GS06 Group Control Number





GS07 Responsible agency code X




GS08 Version 004030














ST -Transaction Header
ST01 Transaction Set ID "810"




ST02 Transaction Set Control Number















BIG - Beginning Segment (MANDATORY)
BIG01 Date Invoice Date E1EDK03 DATUM IDDAT "012" CCYYMMDD
BIG02 Invoice Number
E1EDK01 BELNR


BIG04 Purchase order Number
E1EDK02 BELNR QUALF "001"










REF - Reference Identifier (PD)
REF01 Reference Identification Qualifier Promotional deal number




REF02 Reference Identification
E1EDKT2 TDLINE TDID ZE1T Qualif: "PD:"










REF - Reference Identifier (IA) (MANDATORY)
REF01 Reference Identification Qualifier "IA" Internal Vendor Number




REF02 Reference Identification "123456789" E1EDKT2 TDLINE TDID ZE1T Qualif: "IA:".










N1 - Name (BY) (MANDATORY)
N101 Entity Identifier Code "BY" Buying Party




N103 Identification Code Qualifier "92"




N104 Identification Code
E1EDKA1 KNREF PARVW WE 4 Digit location or consolidated SCAC entered in Partner Description field on the Partners tab of the customer master. No ST segment is sent because Maisto receive no orders that have a separate ST segment that differs from the BY segment in the 850










ITD - Terms of Sale (MANDATORY)
ITD01 Terms Type Code "01"



Basic
ITD02 Terms Basic Date Code "2"


Delivery Date
ITD07 Terms net Days Net Days E1EDK18 TAGE QUALF "001"










DTM -- DATE/Time Reference (MANDATORY)
DTM01 Date/Time Qualifier "011" Shipped




DTM02 Date Date Shipped E1EDK03 DATUM IDDAT "001" Date Shipped










IT1 - Baseline of Item Data (MANDATORY)
IT102 Quantity Invoiced
E1EDP01 MENGE


IT103 Unit of Measure code "EA" E1EDP01 MENEE

Must invoice in eaches
IT104 Unit price Price per U of M E1EDP26 BETRG QUALF "001" Must use decimal point
IT106 Product/Service ID Qualifier "CB" Buyers catlaog number




IT107 Product/Service ID Buyers number E1EDPT2 TDLINE TDLINE "CB:" E1EDPT1 = Z2ET. In E1EDP19 segment as well
IT108 Product/Service ID Qualifier "UP" UPC Customer Package Code




IT109 Product/Service ID UPC Number E1EDPT2 TDLINE TDLINE "UP:" E1EDPT1 = Z2ET. In E1EDP19 segment as well











PID - Product / Item Description

PID01 Item Description Type "F" Free Form





PID05 Description
E1EDP19 KTEXT QUALF "002"











PO4 -- Packing Information (MANDATORY)

PO401 Pack
E1EDPT2 TDLINE TDLINE "PACK:"










TDS - Total Monetary Amount (MANDATORY)
TDS01 Amount
E1EDS01 SUMME SUMID "011" Formatting: Two decimal places are assumed. Example 1526 will be interpreted as 15.26.










CAD - Carrier Detail (MANDATORY)
CAD01 Mode "M" Motor (Common Carrier)




CAD04 SCAC
E1EDKA1 LIFNR PARVW "SP"
CAD05 Routing Carrier's Name E1EDKA1 NAME1 PARVW "SP"
CAD07 Carrier Reference Number Quailifier "CN"




CAD08 Reference Number
E1EDK01 AUGRU_BEZ

From conversion rule BOLNR. The BOL number must be entered in the delivery header field LIKP-BOLNR located on the Delivery Header - Transport Rel. Info screen - Bill of Lading number










SAC -- Allowances and Charges
SAC01 Allowance or Charge Indicator "A" Allowance E1EDS01 SUMID

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 C310 or H000



I410
SAC05 Amount
E1EDS01 SUMME

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.
SAC12 Allowance or Charge Method of Handling Code "02"














ISS -- Invoice Shipment Sumary (MANDATORY)
ISS01 Number of Units Shipped Sum IT102



Calculated by the translator
ISS02 Unit of Measure IT103




ISS03 Weight
E1EDK01 BRGEW


ISS04 Unit of Measure
E1EDK01 GEWEI

Convert LBR to LB










CTT -- Transaction Totals (MANDATORY)
CTT01 Number of Line Items
E1EDS01 SUMME SUMID "001" Can be calculated