TRADACOMS ›
Location Planning › LPRDET
LPRDET: Location Planning Report Details
The LPRDET message is part of the TRADACOMS Location Planning file: location-level planning information.
The Location Planning file contains: LPRHDR → LPRDET → LPRTLR.
Message structure
| Segment | Name | Usage |
|---|---|---|
MHD | Message Header | One message for each report |
SFR | Planning Report Rules | |
SLO | Outlet Location Details | Repeat as necessary |
PDS | Product Details | Repeat as necessary |
SFP | Planning Report Data | Repeat as necessary |
SFS | Function Report Data | Repeat as necessary |
RFD | Report References and Dates | Repeat as necessary |
SFC | Time Base Control Totals | Repeat as necessary |
SFX | Functional Data Time Base Control | Repeat as necessary |
SFL | Planning Report Trailer | |
MTR | Message Trailer |
Segments and data elements
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
MSRF | Message Reference | M | V | 9(12) | Consecutive count of messages within the transmission |
TYPE | Type of Message composite | M | 'LPRDET' '2' for this version | ||
| Type | M | F | X(6) | ||
| Version Number | M | F | 9(1) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
RTRS | Report Time Rules composite | M | Date of first record in each row of the report. Format: YYMMDD Code which specifies the time period covered by each repeat of data segment. Code Values List 27 Specifies the number of data segments for each product or location Date of last record in each line Indicates the number of periods before the same reporting period repeats, eg the number of working days reported between Mondays, etc · code list 27 | ||
| Date of First Entry | M | F | 9(6) | ||
| Report Period Base | M | V | X(3) | ||
| Number of Report Segments per Row | M | V | 9(3) | ||
| Date at End of Period | C | F | 9(6) | ||
| Number of Periods in a Base Cycle | C | V | 9(3) | ||
REPT | Report Type | M | V | X(3) | Indicates whether the data which follows is B = "Budget"; A = "Actual"; or F = "Forecast" |
REPU | Report Function Indicator | C | F | X(3) | Indicates which function is being reported, eg. SALES, ORDERS, STOCK, etc. - Code List 29 · code list 29 |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and is incremented by 1 for each segment of this type |
CLOC | Customer's Location composite | M | One of the following 3 references must be present EAN Location number identifying the customer's location Customer's identity for location Supplier's identity for customer's location | ||
| Customer's EAN Location Number | C | F | 9(13) | ||
| Customer's Own Location Code | C | V | X(17) | ||
| Supplier's Own Location code | C | V | X(17) | ||
CNAM | Customer's Name | C | V | X(40) | Customer's registered legal name |
CADD | Customer's Address composite | C | A maximum of five lines to give the customers address | ||
| Customer's Address Line 1 | C | V | X(35) | ||
| Customer's Address Line 2 | C | V | X(35) | ||
| Customer's Address Line 3 | C | V | X(35) | ||
| Customer's Address Line 4 | C | V | X(35) | ||
| Customer's Post Code | C | V | X(8) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Take value of preceding SLO if used or starts at 1 and increases |
SEQB | Second Level Sequence Number | M | V | 9(10) | Starts at 1 and increases for each repeat of this segment Defines the row of the report |
SPRO | Supplier's Product Number composite | C | Either EAN or supplier's code must be quoted EAN article number allocated to the unit of trade Supplier's internal reference (non-EAN) identifying the traded unit Code for traded unit allocated under EAN-DUN14 | ||
| EAN-13 Article Number for the Traded Unit | C | F | 9(13) | ||
| Supplier's Code for the Traded Unit | C | V | X(30) | ||
| Dun-14 Code for Traded Unit | C | F | 9(14) | ||
CPRO | Customer's Product Number composite | C | Can be used for "own label" items allocated a customer's internal number Customer's internal reference for the item (non-EAN) | ||
| Customer's Own Brand EAN Number | C | F | 9(15) | ||
| Customer's Item Code | C | V | X(30) | ||
IDID | EAN/ISSN Number | C | V | 9(15) | EAN/ISSN Number inc. add-on for issue number |
TDES | Traded Unit Description composite | C | Full description of the item being traded. Consistent with Product Information data and any labels or packaging | ||
| Traded Unit Description Line 1 | C | V | X(40) | ||
| Traded Unit Description Line 2 | C | V | X(40) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Takes first level sequence from SLO |
SEQB | Second Level Sequence Number | M | V | 9(10) | Takes second level sequence from PDS |
SEQC | Third Level Sequence Number | M | V | 9(10) | Starts at 1; sequential for each column of data |
REFP | Period Reference composite | M | Use either of the sub-elements not both. Indicates by value: O = opening position or T = line total Indicates the report period to which the data applies Indicates date that period ends. Format: YYMMDD | ||
| Summary Period | C | F | X(1) | ||
| Report Period Number | C | V | 9(2) | ||
| Period End Date | C | F | 9(6) | ||
QPER | Quantity Data composite | C | Used if REPU specifies the function in SFR otherwise QPER in segment SFS should be used. Number of traded units. Weight or volume or variable unit reported. Must have associated unit of measure reported (Code List 4). Financial amount. Should have currency indicator unless currency already defined: Use Code Values List 31 | ||
| Total Traded units | C | V | 9(15) | ||
| Total Variable units | C | V | 9(10)V9(3) | ||
| Measure Indicator | C | V | X(6) | ||
| Total Financial units | C | V | 9(10)V9(2) | ||
| Currency indicator | C | F | X(3) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Takes first level sequence from SLO |
SEQB | Second Level Sequence Number | M | V | 9(10) | Takes second level sequence from PDS |
SEQC | Third Level Sequence Number | M | V | 9(10) | Takes third level sequence from SFP |
SEQD | Fourth Level Sequence Number | M | V | 9(10) | Starts at 1; sequential for each row of data |
REPU | Report Function Indicator | M | F | X(3) | Note used to indicate the function of the data being reported. Code list 29 · code list 29 |
QPER | Quantity Data composite | M | Quantity for each period by report type Number of traded units. Weight or volume or variable unit reported. Must have the associated unit of measure (Code List 4). Financial amount. Should have currency indicator, unless currency is already defined: Use Code Values List 31 | ||
| Total Traded Units | C | V | 9(15) | ||
| Total Variable Units | C | V | 9(10)V9(3) | ||
| Measure Indicator | C | V | X(6) | ||
| Total Financial Units | C | V | 9(10)V9(2) | ||
| Currency | C | F | X(3) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Takes first level sequence from SLO |
SEQB | Second Level Sequence Number | M | V | 9(10) | Takes second level sequence from PDS |
SEQC | Third Level Sequence Number | M | V | 9(10) | Set by SFP. Starts at 1; sequential for each column of data |
SEQD | Fourth Level Sequence Number | M | V | 9(10) | Starts at 1; increases for each column of data |
ORNO | Order Number and Date composite | M | Used to indicate outstanding order numbers Format YYMMDD Format YYMMDD | ||
| Customer's Order Number | C | V | X(17) | ||
| Supplier's Order Number | C | V | X(17) | ||
| Date Order Placed by Customer | C | F | 9(6) | ||
| Date Order Received by Supplier | C | F | 9(6) | ||
RDAT | Required Delivery Date | C | F | 9(6) | Date on which delivery is expected or required. Format YYMMDD |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and increases for each repeat, set by SLO |
SEQB | Second Level Sequence Number | M | V | 9(10) | Starts at 1 and repeats for column of data, set by PDS |
REFP | Period Reference composite | M | Use either of sub-elements not both Maybe O = Opening or T = Total Indicates the report period to which data applies Indicates date that period ends | ||
| Summary Period | C | F | X(1) | ||
| Report Period Number | C | V | 9(2) | ||
| Period End Date | C | F | 9(6) | ||
QPER | Quantity Data composite | C | Totals per time period, reported if REPU used at SFR indicating data where only one function is being reported. If not use QPER in SFX Code Values List 4 Financial Amount Use Code Values List 31 | ||
| Total Traded Units | C | V | 9(15) | ||
| Total Variable Units | C | V | 9(10)V9(3) | ||
| Measure Indicator | C | V | X(6) | ||
| Total Financial Units | C | V | 9(10)V9(2) | ||
| Currency Indicator | C | F | X(3) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Takes first level sequence from SLO |
SEQB | Second Level Sequence Number | M | V | 9(10) | Either sequential or takes second level sequence from PDS |
SEQC | Third Level Sequence Number | M | V | 9(10) | Starts at 1; sequential for each column of data |
REPU | Report Function Indicator | M | F | X(3) | Note: used to indicate the function of the data being reported. Code List 29 · code list 29 |
QPER | Quantity Data composite | M | |||
| Total Traded Units | C | V | 9(15) | ||
| Total Variable Units | C | V | 9(10)V9(3) | ||
| Measure Indicator | C | V | X(6) | ||
| Total Financial Units | C | V | 9(10)V9(2) | ||
| Currency Indicator | C | F | X(3) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
STLD | Data Lines | C | V | 9(10) | Number of SFP segments in the file |
STLN | Number of Locations Reported | C | V | 9(10) | The number of locations for which data is reported. (SLO segments) |
STPT | Number of Products Reported | C | V | 9(10) | Number of products reported within the file. Count of product reference numbers |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
NOSG | Number of Segments in Message | M | V | 9(10) | Control count of the number of segments comprising message. The count includes the MHD and MTR segments surrounding the message |
Need to exchange TRADACOMS messages with a UK retailer?
SupplyLens connects your ERP, e-commerce or accounting system to any TRADACOMS or EDIFACT trading partner: orders in, invoices out, fully managed.
Book a demo Learn about retail EDI →