Posupld DSD Helper (Service Layer GTT)

Out of Scope

Technical: SVC_POSUPLD_DSD_HELPER_GTT | ID: OR-FND-SVC_POSUPLD_DSD_HELPER_GTT-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

Classification

Object Type: gtt

Target Structure

Load Approach: Table
Target Objects: SVC_POSUPLD_DSD_HELPER_GTT

Field Definitions(5)

Rules & Considerations(16)

constraint

validation

Sample Load Data(4)

_scenario	SALES_PROCESS_IDR	ITEM	STORE	CHUNK_ID	DATA_DATE	PROMOTION	PROM_TYPE	SALES_QTY	TRAN_TYPE	DISCOUNT_AMT	SALES_RETAIL	ACTUAL_RETAIL	PROM_COMPONENT	EXPECTED_RETAIL	GROSS_PROFIT_AMT
Example values from field definitions	1	SAMPLE	1	1	2026-01-01	1	SAMPLE	1.0000	S	1.000000	1.000000	1.000000	1	1.000000	1.0000
default	1000000003	Svc Posupld DSD Helper Gt	1003	1000000003	2026-01-03	3	Svc Po	12.5000	S	12.500000	12.500000	12.500000	3	12.500000	12.5000
default	1000000005	Svc Posupld DSD Helper Gt	1005	1000000005	2026-01-05	5	Svc Po	14.0000	S	14.000000	14.000000	14.000000	5	14.000000	14.0000

Example values from field definitions

SALES_PROCESS_IDR: 1
ITEM: SAMPLE
STORE: 1
CHUNK_ID: 1
DATA_DATE: 2026-01-01
PROMOTION: 1
PROM_TYPE: SAMPLE
SALES_QTY: 1.0000
TRAN_TYPE: S
DISCOUNT_AMT: 1.000000
SALES_RETAIL: 1.000000
ACTUAL_RETAIL: 1.000000
PROM_COMPONENT: 1
EXPECTED_RETAIL: 1.000000
GROSS_PROFIT_AMT: 1.0000

default

SALES_PROCESS_IDR: 1000000003
ITEM: Svc Posupld DSD Helper Gt
STORE: 1003
CHUNK_ID: 1000000003
DATA_DATE: 2026-01-03
PROMOTION: 3
PROM_TYPE: Svc Po
SALES_QTY: 12.5000
TRAN_TYPE: S
DISCOUNT_AMT: 12.500000
SALES_RETAIL: 12.500000
ACTUAL_RETAIL: 12.500000
PROM_COMPONENT: 3
EXPECTED_RETAIL: 12.500000
GROSS_PROFIT_AMT: 12.5000

default

SALES_PROCESS_IDR: 1000000005
ITEM: Svc Posupld DSD Helper Gt
STORE: 1005
CHUNK_ID: 1000000005
DATA_DATE: 2026-01-05
PROMOTION: 5
PROM_TYPE: Svc Po
SALES_QTY: 14.0000
TRAN_TYPE: S
DISCOUNT_AMT: 14.000000
SALES_RETAIL: 14.000000
ACTUAL_RETAIL: 14.000000
PROM_COMPONENT: 5
EXPECTED_RETAIL: 14.000000
GROSS_PROFIT_AMT: 14.0000

Rule Validation Summary

Source Rule Count: 19
Governed Rule Count: 16