ReSA Expdw Rdwf Detail
In ScopeTechnical: SA_EXPDW_RDWF_DETAIL | ID: OR-RSA-SA_EXPDW_RDWF_DETAIL-RESA_EXPDW_RDWF_DETAIL
Interface table to hold the RDWF 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_RDWF_DETAIL
Field Definitions(5)
Rules & Considerations(41)
validation
constraint
Sample Load Data(4)
| _scenario | STORER | PROCESS_IDR | BUSINESS_DATER | RDWF_DETAIL_IDRPK | EXPORT_DATETIMER | CC_NO | VDATE | REV_NO | CASHIER | REF_NO9 | REF_NO10 | REF_NO11 | REF_NO12 | REGISTER | COUPON_NO | CREATE_ID | TRAN_TYPE | TENDER_AMT | VOUCHER_NO | TRAN_SEQ_NO | VOUCHER_AGE | ESCHEAT_DATE | CC_ENTRY_MODE | COUPON_REF_NO | TRAN_DATETIME | LAST_UPDATE_ID | TENDER_TYPE_ID | CREATE_DATETIME | TENDER_TYPE_GROUP | TRANSACTION_STATUS | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 2026-01-01 | 1 | 2026-01-01 | SAMPLE | 2026-01-01 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPL | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 1 | 1 | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | SAMPLE | S | 2026-01-01 |
| default | 1003 | 1000000003 | 2026-01-03 | 1000000003 | 2026-01-03 | SA Expdw Rdwf Detail-002-ALT | 2026-01-03 | 4 | SA Expdw R | SA Expdw Rdwf Detail-002-ALT | SA Expdw Rdwf Detail-002-ALT | SA Expdw Rdwf Detail-002-ALT | SA Expdw Rdwf Detail-002-ALT | SA Ex | SA Expdw Rdwf Detail-002-ALT | MDM_USER | SA Exp | 12.5000 | SA Expdw Rdwf Detail-002- | 4 | 3 | 2026-01-03 | SA Exp | SA Expdw Rdwf De | 2026-01-03 | MDM_USER | 100003 | 2026-01-03 | SA Exp | P | 2026-01-03 |
| default | 1005 | 1000000005 | 2026-01-05 | 1000000005 | 2026-01-05 | SA Expdw Rdwf Detail-003-EDGE | 2026-01-05 | 6 | SA Expdw R | SA Expdw Rdwf Detail-003-EDGE | SA Expdw Rdwf Detail-003-EDGE | SA Expdw Rdwf Detail-003-EDGE | SA Expdw Rdwf Detail-003-EDGE | SA Ex | SA Expdw Rdwf Detail-003-EDGE | BATCH_USER | SA Exp | 14.0000 | SA Expdw Rdwf Detail-003- | 6 | 5 | 2026-01-05 | SA Exp | SA Expdw Rdwf De | 2026-01-05 | BATCH_USER | 100005 | 2026-01-05 | SA Exp | A | 2026-01-05 |
Example values from field definitions
- STORER
- 1
- PROCESS_IDR
- 1
- BUSINESS_DATER
- 2026-01-01
- RDWF_DETAIL_IDRPK
- 1
- EXPORT_DATETIMER
- 2026-01-01
- CC_NO
- SAMPLE
- VDATE
- 2026-01-01
- REV_NO
- 1
- CASHIER
- SAMPLE
- REF_NO9
- SAMPLE
- REF_NO10
- SAMPLE
- REF_NO11
- SAMPLE
- REF_NO12
- SAMPLE
- REGISTER
- SAMPL
- COUPON_NO
- SAMPLE
- CREATE_ID
- SAMPLE
- TRAN_TYPE
- SAMPLE
- TENDER_AMT
- 1.0000
- VOUCHER_NO
- SAMPLE
- TRAN_SEQ_NO
- 1
- VOUCHER_AGE
- 1
- ESCHEAT_DATE
- 2026-01-01
- CC_ENTRY_MODE
- SAMPLE
- COUPON_REF_NO
- SAMPLE
- TRAN_DATETIME
- 2026-01-01
- LAST_UPDATE_ID
- SAMPLE
- TENDER_TYPE_ID
- 1
- CREATE_DATETIME
- 2026-01-01
- TENDER_TYPE_GROUP
- SAMPLE
- TRANSACTION_STATUS
- S
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- STORER
- 1003
- PROCESS_IDR
- 1000000003
- BUSINESS_DATER
- 2026-01-03
- RDWF_DETAIL_IDRPK
- 1000000003
- EXPORT_DATETIMER
- 2026-01-03
- CC_NO
- SA Expdw Rdwf Detail-002-ALT
- VDATE
- 2026-01-03
- REV_NO
- 4
- CASHIER
- SA Expdw R
- REF_NO9
- SA Expdw Rdwf Detail-002-ALT
- REF_NO10
- SA Expdw Rdwf Detail-002-ALT
- REF_NO11
- SA Expdw Rdwf Detail-002-ALT
- REF_NO12
- SA Expdw Rdwf Detail-002-ALT
- REGISTER
- SA Ex
- COUPON_NO
- SA Expdw Rdwf Detail-002-ALT
- CREATE_ID
- MDM_USER
- TRAN_TYPE
- SA Exp
- TENDER_AMT
- 12.5000
- VOUCHER_NO
- SA Expdw Rdwf Detail-002-
- TRAN_SEQ_NO
- 4
- VOUCHER_AGE
- 3
- ESCHEAT_DATE
- 2026-01-03
- CC_ENTRY_MODE
- SA Exp
- COUPON_REF_NO
- SA Expdw Rdwf De
- TRAN_DATETIME
- 2026-01-03
- LAST_UPDATE_ID
- MDM_USER
- TENDER_TYPE_ID
- 100003
- CREATE_DATETIME
- 2026-01-03
- TENDER_TYPE_GROUP
- SA Exp
- TRANSACTION_STATUS
- P
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- STORER
- 1005
- PROCESS_IDR
- 1000000005
- BUSINESS_DATER
- 2026-01-05
- RDWF_DETAIL_IDRPK
- 1000000005
- EXPORT_DATETIMER
- 2026-01-05
- CC_NO
- SA Expdw Rdwf Detail-003-EDGE
- VDATE
- 2026-01-05
- REV_NO
- 6
- CASHIER
- SA Expdw R
- REF_NO9
- SA Expdw Rdwf Detail-003-EDGE
- REF_NO10
- SA Expdw Rdwf Detail-003-EDGE
- REF_NO11
- SA Expdw Rdwf Detail-003-EDGE
- REF_NO12
- SA Expdw Rdwf Detail-003-EDGE
- REGISTER
- SA Ex
- COUPON_NO
- SA Expdw Rdwf Detail-003-EDGE
- CREATE_ID
- BATCH_USER
- TRAN_TYPE
- SA Exp
- TENDER_AMT
- 14.0000
- VOUCHER_NO
- SA Expdw Rdwf Detail-003-
- TRAN_SEQ_NO
- 6
- VOUCHER_AGE
- 5
- ESCHEAT_DATE
- 2026-01-05
- CC_ENTRY_MODE
- SA Exp
- COUPON_REF_NO
- SA Expdw Rdwf De
- TRAN_DATETIME
- 2026-01-05
- LAST_UPDATE_ID
- BATCH_USER
- TENDER_TYPE_ID
- 100005
- CREATE_DATETIME
- 2026-01-05
- TENDER_TYPE_GROUP
- SA Exp
- TRANSACTION_STATUS
- A
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 47
- Governed Rule Count
- 41
