EDI

API DocsTerminal
NEW!
Programmatically translate EDI to JSON with the EDI Core REST API
Get started in minutes →
Transaction Set
in
X12 Release 004040

818 Commission Sales Report

Functional Group RP

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

Sequence
Segment
Name
Max use
0100
Transaction Set HeaderMandatory
Max 1
To indicate the start of a transaction set and to assign a control number
0200
Beginning Segment for Commission Sales ReportMandatory
Max 1
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.
0250
Currency
Max 1
To specify the currency (dollars, pounds, francs, etc.) used in a transaction
N11 Loop
Repeat 999
0300
Store NumberMandatory
Max 1
To specify store numbers related to specific addresses for deliveries
0400
Reference Identification
Max 5
To specify identifying information
0500
Monetary Amount
Max 5
To indicate the total monetary amount
LIN Loop
Repeat 999
0600
Item Identification
Max 1
To specify basic item identification data
0700
Product/Item Description
Max 5
To describe a product or process in coded or free-form format
0800
Monetary Amount
Max 5
To indicate the total monetary amount
NM1 Loop
Repeat 999
0900
Individual or Organizational Name
Max 1
To supply the full name of an individual or organizational entity
0920
Sales Commission Employee Detail
Max 1
To provide additional detail for an employee participating in a sales commission program
0940
Address Information
Max 2
To specify the location of the named party
0950
Geographic Location
Max 1
To specify the geographic place of the named party
0980
Date/Time Reference
Max 1
To specify pertinent dates and times
0990
Monetary Amount
Max 5
To indicate the total monetary amount
SAL Loop
Repeat 99
1000
Salary Information
Max 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.
1100
Monetary AmountMandatory
Max 10
To indicate the total monetary amount
LIN Loop
Repeat 999
1200
Item Identification
Max 1
To specify basic item identification data
1300
Product/Item Description
Max 5
To describe a product or process in coded or free-form format
1400
Monetary Amount
Max 5
To indicate the total monetary amount
1500
Transaction Set TrailerMandatory
Max 1
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 and Mapping Guides are provided for marketing purposes and are 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.
Stedi is a registered trademark of Stedi, Inc. Stedi's EDI Reference and Mapping Guides are provided for marketing purposes and are 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.