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

1. 0100 · ST · Transaction Set Header · Max 1 · Mandatory

   To indicate the start of a transaction set and to assign a control number

2. 0200 · BSC · Beginning Segment for Commission Sales Report · Max 1 · Mandatory

   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. 0250 · CUR · Currency · Max 1 · Optional

   To specify the currency (dollars, pounds, francs, etc.) used in a transaction

4. N11 Loop Mandatory Repeat 999

   1. 0300 · N11 · Store Number · Max 1 · Mandatory

      To specify store numbers related to specific addresses for deliveries

   2. 0400 · REF · Reference Identification · Max 5 · Optional

      To specify identifying information

   3. 0500 · AMT · Monetary Amount · Max 5 · Optional

      To indicate the total monetary amount

   4. LIN Loop Optional Repeat 999

      1. 0600 · LIN · Item Identification · Max 1 · Mandatory

         To specify basic item identification data

      2. 0700 · PID · Product/Item Description · Max 5 · Optional

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

      3. 0800 · AMT · Monetary Amount · Max 5 · Optional

         To indicate the total monetary amount

   5. NM1 Loop Optional Repeat 999

      1. 0900 · NM1 · Individual or Organizational Name · Max 1 · Mandatory

         To supply the full name of an individual or organizational entity

      2. 0920 · SCD · Sales Commission Employee Detail · Max 1 · Optional

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

      3. 0940 · N3 · Address Information · Max 2 · Optional

         To specify the location of the named party

      4. 0950 · N4 · Geographic Location · Max 1 · Optional

         To specify the geographic place of the named party

      5. 0980 · DTM · Date/Time Reference · Max 1 · Optional

         To specify pertinent dates and times

      6. 0990 · AMT · Monetary Amount · Max 5 · Optional

         To indicate the total monetary amount

      7. SAL Loop Optional Repeat 99

         1. 1000 · SAL · Salary Information · Max 1 · Mandatory

            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. 1100 · AMT · Monetary Amount · Max 10 · Mandatory

            To indicate the total monetary amount

      8. LIN Loop Optional Repeat 999

         1. 1200 · LIN · Item Identification · Max 1 · Mandatory

            To specify basic item identification data

         2. 1300 · PID · Product/Item Description · Max 5 · Optional

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

         3. 1400 · AMT · Monetary Amount · Max 5 · Optional

            To indicate the total monetary amount

5. 1500 · SE · Transaction Set Trailer · Max 1 · Mandatory

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