Sap Invoice Sample - Excel by xpz21332

VIEWS: 299 PAGES: 3

More Info
									                               f0a75737-7dff-40b6-b1a2-9d7afa777e93.xls



                                     810 mapping document
                     X12 Transaction                            810
                     X12 Version                                4010
                     Idoc Type                              INVOIC01
                     Message Type                             INVOIC
                     Direction to SAP                        Outbound
                     Created by                            Kevin Wilson
                     System ID                               SAPPRD
                     Sender Port                             SAPEDI
                     Logical System                        LOGSYS100
                     Client                                     100
                     Partner Number                         100000001
                     Remit To                                Partner A
                     Order Type                                ZF02
                     Sales Org                                  0001
                     Dist Channel                                10
                     Division                                    10
                     Unit of Measure                             CS
                     Language                                     E
                     Currency                                   USD
                     Sender ID                             1234567890
                     Sender ID Qual                              01
                     Receiver ID                           4444455555
                     Receiver ID Qual                            01
                     GS02                                      12345
                     GS03                                       4455




The Wella Corporation Confidential             8/9/2011                   Page 1
Fred Meyer Outbound 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            01
ISA06      Interchange Sender ID               1234567890
ISA07      Interchange ID Qualifier            01
ISA08      Intechange Receiver ID              4444455555
ISA09      Interchange Date
ISA10      Interchange Time
ISA11      Interchange Standards Identifier    U
ISA12      Interchange version ID              401
ISA13      Interchange Control Number
ISA14      Acknowledgement Requested           0
ISA15      Test Indicator                      T or P
ISA16      Component Element Separator         >

GS - Functional Group Header
GS01       Functional ID                        "IN" Invoice
GS02       Application Senders Code             12345
GS03       Application Receiver's Code          4455
GS04       Date
GS05       Time
GS06       Group Control Number
GS07       Responsible agency code              X
GS08       Version                              004010

ST -Transaction Header
ST01       Transaction Set ID                   "810"
ST02       Transaction Set Control Number

BIG - Beginning Segment
BIG01      Date                                                                       E1EDK02     DATUM      QUALF            "009"     Invoice Date
BIG02      Invoice Number                                                             E1EDK02     BELNR      QUALF            "009"
BIG03      Date                                                                       E1EDK02     DATUM      QUALF            "001"     Date IDOC created
BIG04      Purchase order Number                                                      E1EDK02     BELNR      QUALF            "001"

N1 - Name Ship To
N101       Entity Identifier Code               "ST" Ship To
N102       Name                                                                      E1EDKA1      BNAME      PARVW            WE        Implemented in user exit
N103       Identification Code Qualifier        "92" Assigned by Buyer
N104       Identification Code                                                       E1EDKA1      IHREZ      PARVW            WE        Implemented in user exit

N1 - Name Remit To
N101       Entity Identifier Code               "RE" Remit To
N102       Name                                 Partner A
N103       Identification Code Qualifier        9
N104       Identification Code                  1234567890

        Wella Corp. Confidential                                                   810 template                                                              Page 2
Fred Meyer Outbound 810 Invoice Mapping Document
Segment              Data Element Name      Codes and comments                         Idoc Segment     Field     Qualifier Field Qualifier Value Notes on Mapping Document

            N3 - Address Information
            N301          Address Information     "Box 555"

            N4 - Geographic Location
            N401              City Name        "City"
            N402        State or Province Code "CA"
            N403             Postal Code       "10004"

ITD - Terms of Sale
ITD01      Terms Type Code                        "01" Basic                              E1EDK18                    QUALF           "001"
ITD02      Terms Basis Date Code                  "3" Invoice Date
ITD03      Terms Discount Percent                                                         E1EDK18      PRZNT         QUALF           "001"
                                                  Please note: the mapping is "date"                                                           (E1EDK03-QUALF "028") DATUM
ITD04       Terms Discount Due Date               arithmetic.                             E1EDK18                    QUALF           "001"     minus 1
ITD05       Terms Discount Days Due                                                       E1EDK18        TAGE        QUALF           "001"
ITD06       Terms Net Due Date                                                            E1EDK03       DATUM        QUALF           "028"
ITD07       Terms net Days                                                                E1EDK18        TAGE        QUALF           "002"
ITD08       Terms Discount Amount                                                         E1EDK18     ZTERM_TXT      QUALF           "001"

DTM -- DATE/Time Reference
DTM01     Date/Time Qualifier                     "011" Shipped
DTM02     Date                                                                           E1EDK03       DATUM         IDDAT           "001"

FOB - F.O.B. Related Instructions
FOB01      Shipment Method of Payment             "PP" Prepaid

IT1 - Baseline of Item Data
IT102        Quantity Invoices                                                            E1EDP01      MENGE
IT103        Unit of Measure code                                                         E1EDP01      MENEE                                   Convert "CS" to "CA"
                                                                                                                                               E1EDP26-QUALF '003' BETRG
                                                                                                                                               Divided By
IT104       Unit price                            Price per U of M                        E1EDP26      BETRG         QUALF           "001"     E1EDP01-MENGE
IT106       Product/Service ID Qualifier          "VC" Vendor's Catalog Number
IT107       Product/Service ID                                                            E1EDP19       IDTNR        QUALF           "002"
IT108       Product/Service ID Qualifier          "CB" Buyer's Item Number
IT109       Product/Service ID                                                            E1EDP19       IDTNR        QUALF           "001"

            PID - Product / Item Description
            PID01                   Item
                                    Description
                                    Type          "F" Free Form
            PID05                   Description                                           E1EDP19       KTEXT        QUALF           "002"

TDS - Total Monetary Amount
TDS01       Amount                                                                        E1EDS01      SUMME         SUMID           "011"




        Wella Corp. Confidential                                                       810 template                                                               Page 3

								
To top