Svc Posupld DSD Helper Gtt
Out of ScopeTechnical: SVC_POSUPLD_DSD_HELPER_GTT | ID: OR-MFCS-SVC_POSUPLD_DSD_HELPER_GTT
Daily sales discount working table. Used to help in the population of DAILY_SALES_DISCOUNT rows resulting from the sale.
See how this object fits into Foundation Data
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- SVC_POSUPLD_DSD_HELPER_GTT
Field Definitions(15)
Rules & Considerations(5)
Sample Load Data(4)
| _scenario | CHUNK_IDR | SALES_PROCESS_IDR | ITEM | STORE | DATA_DATE | PROMOTION | PROM_TYPE | SALES_QTY | TRAN_TYPE | DISCOUNT_AMT | SALES_RETAIL | ACTUAL_RETAIL | PROM_COMPONENT | EXPECTED_RETAIL | GROSS_PROFIT_AMT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1000000001 | 1000000001 | Svc Posupld DSD Helper Gtt-001 | 1001 | 2026-01-01 | 1 | Svc Posupld DSD Helper Gtt-001 | 11.0000 | Svc Posupld DSD Helper Gtt-001 | 11.0000 | 11.0000 | 11.0000 | 1 | 11.0000 | 11.0000 |
default
- CHUNK_IDR
- 1000000001
- SALES_PROCESS_IDR
- 1000000001
- ITEM
- Svc Posupld DSD Helper Gtt-001
- STORE
- 1001
- DATA_DATE
- 2026-01-01
- PROMOTION
- 1
- PROM_TYPE
- Svc Posupld DSD Helper Gtt-001
- SALES_QTY
- 11.0000
- TRAN_TYPE
- Svc Posupld DSD Helper Gtt-001
- DISCOUNT_AMT
- 11.0000
- SALES_RETAIL
- 11.0000
- ACTUAL_RETAIL
- 11.0000
- PROM_COMPONENT
- 1
- EXPECTED_RETAIL
- 11.0000
- GROSS_PROFIT_AMT
- 11.0000