ReSA Expdw Rdwt Detail
In ScopeTechnical: SA_EXPDW_RDWT_DETAIL | ID: OR-RSA-SA_EXPDW_RDWT_DETAIL-RESA_EXPDW_RDWT_DETAIL
Interface table to hold the RDWT detail level information.
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
Field Definitions(5)
Rules & Considerations(32)
constraint
validation
Sample Load Data(4)
| _scenario | PROCESS_IDR | RDWT_HEAD_IDR | RDWT_DETAIL_IDRPK | 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 | 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 |
| default | 1000000003 | 1000000003 | 1000000003 | 2026-01-03 | SA Expdw Rdwt Detail-002-ALT | SA Expdw Rdwt Detail-002-ALT | SA Expdw Rdwt Detail-002-ALT | SA Expdw Rdwt Detail-002-ALT | SA Expdw Rdwt Detail-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 |
| default | 1000000005 | 1000000005 | 1000000005 | 2026-01-05 | SA Expdw Rdwt Detail-003-EDGE | SA Expdw Rdwt Detail-003-EDGE | SA Expdw Rdwt Detail-003-EDGE | SA Expdw Rdwt Detail-003-EDGE | SA Expdw Rdwt Detail-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 |
Example values from field definitions
- PROCESS_IDR
- 1
- RDWT_HEAD_IDR
- 1
- RDWT_DETAIL_IDRPK
- 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
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- PROCESS_IDR
- 1000000003
- RDWT_HEAD_IDR
- 1000000003
- RDWT_DETAIL_IDRPK
- 1000000003
- EXPORT_DATETIMER
- 2026-01-03
- REF_NO13
- SA Expdw Rdwt Detail-002-ALT
- REF_NO14
- SA Expdw Rdwt Detail-002-ALT
- REF_NO15
- SA Expdw Rdwt Detail-002-ALT
- REF_NO16
- SA Expdw Rdwt Detail-002-ALT
- COUPON_NO
- SA Expdw Rdwt Detail-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
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- PROCESS_IDR
- 1000000005
- RDWT_HEAD_IDR
- 1000000005
- RDWT_DETAIL_IDRPK
- 1000000005
- EXPORT_DATETIMER
- 2026-01-05
- REF_NO13
- SA Expdw Rdwt Detail-003-EDGE
- REF_NO14
- SA Expdw Rdwt Detail-003-EDGE
- REF_NO15
- SA Expdw Rdwt Detail-003-EDGE
- REF_NO16
- SA Expdw Rdwt Detail-003-EDGE
- COUPON_NO
- SA Expdw Rdwt Detail-003-EDGE
- CREATE_ID
- BATCH_USER
- PROMOTION
- 5
- SALES_QTY
- 14.0000
- PROMO_COMP
- 5
- PROMO_TYPE
- SA Exp
- SALES_VALUE
- 14.0000
- COUPON_REF_NO
- SA Expdw Rdwt De
- DISCOUNT_TYPE
- SA Exp
- DISCOUNT_VALUE
- 14.0000
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 38
- Governed Rule Count
- 32