Ordloc Discount

In Scope

Technical: ORDLOC_DISCOUNT | ID: OR-TRD-ORDLOC_DISCOUNT-ORDLOC_DISCOUNT

This table will hold the various deal components that apply to a ITEM on a PO. The table will be rebuilt nightly in a batch process driven off the DEAL_CALC_QUEUE...

See how this object fits into Trade 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: ORDLOC_DISCOUNT

Field Definitions(5)

Rules & Considerations(30)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	SEQ_NORPK	DEAL_IDR	LOCATIONR	ORDER_NORPK	PACK_NO	PAID_IND	DISCOUNT_TYPE	DEAL_DETAIL_ID	DISCOUNT_VALUE	LAST_CALC_DATE	APPLICATION_ORDER	DISCOUNT_AMT_PER_UNIT
Example values from field definitions	SAMPLE	1	1	1	1	SAMPLE	S	SAMPLE	1	1.0000	2026-01-01	1	1.0000
default	Ordloc Discount-002-ALT	4	1000000003	3	4	Ordloc Discount-002-ALT	Y	A	1000000003	12.5000	2026-01-03	3	12.5000
default	Ordloc Discount-003-EDGE	6	1000000005	5	6	Ordloc Discount-003-EDGE	Y	P	1000000005	14.0000	2026-01-05	5	14.0000

Example values from field definitions

ITEMR: SAMPLE
SEQ_NORPK: 1
DEAL_IDR: 1
LOCATIONR: 1
ORDER_NORPK: 1
PACK_NO: SAMPLE
PAID_IND: S
DISCOUNT_TYPE: SAMPLE
DEAL_DETAIL_ID: 1
DISCOUNT_VALUE: 1.0000
LAST_CALC_DATE: 2026-01-01
APPLICATION_ORDER: 1
DISCOUNT_AMT_PER_UNIT: 1.0000

default

ITEMR: Ordloc Discount-002-ALT
SEQ_NORPK: 4
DEAL_IDR: 1000000003
LOCATIONR: 3
ORDER_NORPK: 4
PACK_NO: Ordloc Discount-002-ALT
PAID_IND: Y
DISCOUNT_TYPE: A
DEAL_DETAIL_ID: 1000000003
DISCOUNT_VALUE: 12.5000
LAST_CALC_DATE: 2026-01-03
APPLICATION_ORDER: 3
DISCOUNT_AMT_PER_UNIT: 12.5000