ReSA Expdw Rdwt Detail Prg History

In Scope

Technical: SA_EXPDW_RDWT_DETAIL_PRG_HIST | ID: OR-RSA-SA_EXPDW_RDWT_DETAIL_PRG_HIST-RESA_EXPDW_RDWT_DETAIL_PRG_HISTORY

Stores program or batch execution history for SA expdw rdwt detail prg hist in Oracle Retail Merchandising, including run identifiers, start and end timestamps, status, and processing counts. Used for...

See how this object fits into Sales Audit

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: SA_EXPDW_RDWT_DETAIL_PRG_HIST

Field Definitions(5)

Rules & Considerations(30)

constraint

validation

Sample Load Data(4)

_scenario	PROCESS_IDR	RDWT_HEAD_IDR	RDWT_DETAIL_IDR	EXPORT_DATETIMER	REF_NO13	REF_NO14	REF_NO15	REF_NO16	COUPON_NO	CREATE_ID	PROMOTION	SALES_QTY	PROMO_COMP	PROMO_TYPE	SALES_VALUE	COUPON_REF_NO	DISCOUNT_TYPE	DISCOUNT_VALUE	LAST_UPDATE_ID	CREATE_DATETIME	HIST_WRITTEN_DATE	LAST_UPDATE_DATETIME
Example values from field definitions	1	1	1	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1.0000	1	SAMPLE	1.0000	SAMPLE	SAMPLE	1.0000	SAMPLE	2026-01-01	2026-01-01	2026-01-01
default	1000000003	1000000003	1000000003	2026-01-03	SA Expdw Rdwt Detail Prg Hist-	SA Expdw Rdwt Detail Prg Hist-	SA Expdw Rdwt Detail Prg Hist-	SA Expdw Rdwt Detail Prg Hist-	SA Expdw Rdwt Detail Prg Hist-002-ALT	MDM_USER	3	12.5000	3	SA Exp	12.5000	SA Expdw Rdwt De	SA Exp	12.5000	MDM_USER	2026-01-03	2026-01-03	2026-01-03
default	1000000005	1000000005	1000000005	2026-01-05	SA Expdw Rdwt Detail Prg Hist-	SA Expdw Rdwt Detail Prg Hist-	SA Expdw Rdwt Detail Prg Hist-	SA Expdw Rdwt Detail Prg Hist-	SA Expdw Rdwt Detail Prg Hist-003-EDGE	BATCH_USER	5	14.0000	5	SA Exp	14.0000	SA Expdw Rdwt De	SA Exp	14.0000	BATCH_USER	2026-01-05	2026-01-05	2026-01-05

Example values from field definitions

PROCESS_IDR: 1
RDWT_HEAD_IDR: 1
RDWT_DETAIL_IDR: 1
EXPORT_DATETIMER: 2026-01-01
REF_NO13: SAMPLE
REF_NO14: SAMPLE
REF_NO15: SAMPLE
REF_NO16: SAMPLE
COUPON_NO: SAMPLE
CREATE_ID: SAMPLE
PROMOTION: 1
SALES_QTY: 1.0000
PROMO_COMP: 1
PROMO_TYPE: SAMPLE
SALES_VALUE: 1.0000
COUPON_REF_NO: SAMPLE
DISCOUNT_TYPE: SAMPLE
DISCOUNT_VALUE: 1.0000
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
HIST_WRITTEN_DATE: 2026-01-01
LAST_UPDATE_DATETIME: 2026-01-01

default

PROCESS_IDR: 1000000003
RDWT_HEAD_IDR: 1000000003
RDWT_DETAIL_IDR: 1000000003
EXPORT_DATETIMER: 2026-01-03
REF_NO13: SA Expdw Rdwt Detail Prg Hist-
REF_NO14: SA Expdw Rdwt Detail Prg Hist-
REF_NO15: SA Expdw Rdwt Detail Prg Hist-
REF_NO16: SA Expdw Rdwt Detail Prg Hist-
COUPON_NO: SA Expdw Rdwt Detail Prg Hist-002-ALT
CREATE_ID: MDM_USER
PROMOTION: 3
SALES_QTY: 12.5000
PROMO_COMP: 3
PROMO_TYPE: SA Exp
SALES_VALUE: 12.5000
COUPON_REF_NO: SA Expdw Rdwt De
DISCOUNT_TYPE: SA Exp
DISCOUNT_VALUE: 12.5000
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
HIST_WRITTEN_DATE: 2026-01-03
LAST_UPDATE_DATETIME: 2026-01-03