EDI Daily Sales
In ScopeTechnical: EDI_DAILY_SALES | ID: OR-INV-EDI_DAILY_SALES-EDI_DAILY_SALES
Stores daily sales information and an inventory snapshot of items used by the EDI Daily Sales and Stock on Hand Report download (EDI852) from RMS, which is transmitted to the...
See how this object fits into Inventory Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- EDI_DAILY_SALES
Field Definitions(5)
Rules & Considerations(18)
validation
constraint
Sample Load Data(4)
| _scenario | LOCRPK | ITEMRPK | LOC_TYPERPK | SALES_QTYR | TRAN_DATERPK | STOCK_ON_HAND | IN_TRANSIT_QTY |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 |
| default | 3 | EDI Daily Sales-002-ALT | S | 12.5000 | 2026-01-03 | 12.5000 | 12.5000 |
| default | 5 | EDI Daily Sales-003-EDGE | S | 14.0000 | 2026-01-05 | 14.0000 | 14.0000 |
Example values from field definitions
- LOCRPK
- 1
- ITEMRPK
- SAMPLE
- LOC_TYPERPK
- S
- SALES_QTYR
- 1.0000
- TRAN_DATERPK
- 2026-01-01
- STOCK_ON_HAND
- 1.0000
- IN_TRANSIT_QTY
- 1.0000
default
- LOCRPK
- 3
- ITEMRPK
- EDI Daily Sales-002-ALT
- LOC_TYPERPK
- S
- SALES_QTYR
- 12.5000
- TRAN_DATERPK
- 2026-01-03
- STOCK_ON_HAND
- 12.5000
- IN_TRANSIT_QTY
- 12.5000
default
- LOCRPK
- 5
- ITEMRPK
- EDI Daily Sales-003-EDGE
- LOC_TYPERPK
- S
- SALES_QTYR
- 14.0000
- TRAN_DATERPK
- 2026-01-05
- STOCK_ON_HAND
- 14.0000
- IN_TRANSIT_QTY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 28
- Governed Rule Count
- 18