EDI 818 Commission Sales Report

Functional Group RP

X12M Supply Chain Subcommittee

This Draft Standard for Trial Use contains the format and establishes the data contents of the Commission Sales Report Transaction Set (818) 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. 010 · ST · Transaction Set Header · Max 1 · Mandatory

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

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

   To indicate the beginning of the 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. N11 Loop Mandatory Repeat 999

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

      To specify store numbers related to specific addresses for deliveries

   2. 040 · REF · Reference Numbers · Max 5 · Optional

      To specify identifying numbers.

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

      To indicate the total monetary amount.

   4. LIN Loop Optional Repeat 999

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

         To specify basic item identification data.

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

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

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

         To indicate the total monetary amount.

   5. N1 Loop Optional Repeat 999

      1. 090 · N1 · Name · Max 1 · Mandatory

         To identify a party by type of organization, name and code

      2. 100 · SAL · Salary Information · Max 4 · Optional

         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.

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

         To indicate the total monetary amount.

      4. LIN Loop Optional Repeat 999

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

            To specify basic item identification data.

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

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

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

            To indicate the total monetary amount.

4. 150 · 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).