EDI 818 Commission Sales Report

Functional Group RP

X12M Supply Chain Subcommittee

This X12 Transaction Set contains the format and establishes the data contents of the Commission Sales Report Transaction Set (818) for use within the context of an Electronic Data Interchange (EDI) environment. This transaction set can be used to allow a retailer to advise a trading partner of commission sales and salary information. Commission data enables a trading partner to reconcile commission payments and salary support.

Heading

Position
Segment
Name
Max use
  1. To indicate the start of a transaction set and to assign a control number

  2. To indicate the beginning of a commission sales report transaction set and transmit reporting period dates

    SAL06 is required if the reporting period start date is different from the reporting period start date in BSC03. If SAL06 is used, it overrides the date sent in BSC03.
    SAL07 is required if the reporting period end date is different from the reporting period end date in BSC04. If SAL07 is used, it overrides the date sent in BSC04.
  3. To specify the currency (dollars, pounds, francs, etc.) used in a transaction

  4. N11 Loop Mandatory
    Repeat 999
    1. To specify store numbers related to specific addresses for deliveries

    2. To specify identifying information

    3. To indicate the total monetary amount

    4. LIN Loop Optional
      Repeat 999
      1. To specify basic item identification data

      2. To describe a product or process in coded or free-form format

      3. To indicate the total monetary amount

    5. NM1 Loop Optional
      Repeat 999
      1. To supply the full name of an individual or organizational entity

      2. To provide additional detail for an employee participating in a sales commission program

      3. To specify the location of the named party

      4. To specify the geographic place of the named party

      5. To specify pertinent dates and times

      6. To indicate the total monetary amount

      7. SAL Loop Optional
        Repeat 99
        1. To specify details of commission salary information

          SAL06 is required if the reporting period start date is different from the reporting period start date in BSC03. If SAL06 is used, it overrides the date sent in BSC03.
          SAL07 is required if the reporting period end date is different from the reporting period end date in BSC04. If SAL07 is used, it overrides the date sent in BSC04.
        2. To indicate the total monetary amount

      8. LIN Loop Optional
        Repeat 999
        1. To specify basic item identification data

        2. To describe a product or process in coded or free-form format

        3. To indicate the total monetary amount

  5. To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)

Stedi is a registered trademark of Stedi, Inc. Stedi's EDI Reference is provided for marketing purposes and is free of charge. All names, logos, and brands of third parties listed on our site are trademarks of their respective owners (including “X12”, which is a trademark of X12 Incorporated). Stedi, Inc. and its products and services are not endorsed by, sponsored by, or affiliated with these third parties. Our use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.