ReSA Expdw Rdwt Header
In ScopeTechnical: SA_EXPDW_RDWT_HEAD | ID: OR-RSA-SA_EXPDW_RDWT_HEAD-RESA_EXPDW_RDWT_HEADER
Interface table to hold the RDWT header 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_HEAD
Field Definitions(5)
Rules & Considerations(91)
constraint
validation
Sample Load Data(4)
| _scenario | STORER | PROCESS_IDR | RDWT_HEAD_IDRPK | BUSINESS_DATER | EXPORT_DATETIMER | DEPT | ITEM | CLASS | VDATE | REV_NO | CASHIER | CUST_ID | REF_NO1 | REF_NO2 | REF_NO3 | REF_NO4 | REF_NO5 | REF_NO6 | REF_NO7 | REF_NO8 | TAX_IND | TRAN_NO | MEDIA_ID | REF_ITEM | REF_NO25 | REF_NO26 | REF_NO27 | REF_NO28 | REF_NO29 | REF_NO30 | REF_NO31 | REGISTER | SUBCLASS | BANNER_NO | CREATE_ID | ITEM_TYPE | RETURN_WH | TRAN_TYPE | UNIQUE_ID | VENDOR_NO | WASTE_PCT | ENTRY_MODE | ORIG_STORE | SALES_TYPE | WASTE_TYPE | EMPLOYEE_NO | ITEM_SEQ_NO | ITEM_STATUS | ORIG_REG_NO | REASON_CODE | RECEIPT_IND | RETAIL_TYPE | TRAN_SEQ_NO | CUST_ID_TYPE | INVENTORY_ID | SELLING_ITEM | CUST_ORDER_NO | DROP_SHIP_IND | FUFILL_LOC_ID | POSTING_STORE | SUB_TRAN_TYPE | TRAN_DATETIME | LAST_UPDATE_ID | RTLOG_ORIG_SYS | SALESPERSON_ID | CREATE_DATETIME | CUST_ORDER_DATE | EXPIRATION_DATE | FUFILL_LOC_TYPE | OVERRIDE_REASON | TOTAL_IGTAX_AMT | TOTAL_SALES_QTY | FULFILL_ORDER_NO | TRAN_PROCESS_SYS | TOTAL_SALES_VALUE | CUST_ORDER_LINE_NO | PVOID_ORIG_TRAN_NO | RETURN_DISPOSITION | RETURN_REASON_CODE | RETURN_ORIG_TRAN_NO | LAST_UPDATE_DATETIME | NO_INVENTORY_RET_IND | TOTAL_ORIG_SALES_VALUE | INVENTORY_IDENTIFIER_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 2026-01-01 | 2026-01-01 | 1 | SAMPLE | 1 | 2026-01-01 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPL | 1 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 1 | S | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPL | SAMPLE | SAMPLE | S | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | SAM | SAMPLE | 2026-01-01 | 2026-01-01 | 2026-01-01 | S | SAMPLE | 1.0000 | 1.0000 | SAMPLE | SAM | 1.0000 | 1 | 1 | SAMPLE | SAMPLE | 1 | 2026-01-01 | S | 1.0000 | SAMPLE |
| default | 1003 | 1000000003 | 1000000003 | 2026-01-03 | 2026-01-03 | 1003 | SA Expdw Rdwt Head-002-AL | 1103 | 2026-01-03 | 4 | SA Expdw R | ALT-SA_EXPDW-002 | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | S | 4 | 1000000003 | SA Expdw Rdwt Head-002-AL | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Expdw Rdwt Head-002-ALT | SA Ex | 1113 | 4 | MDM_USER | SA Exp | 9003 | SA Exp | ALT-SA_EXPDW-002 | SA Expdw R | 12.5000 | SA Exp | 1003 | S | SA Exp | SA Expdw Rdwt Head-002-ALT | 4 | PENDIN | SA Ex | ALT-SA | SA Expdw Rdwt Head-002-ALT | S | 4 | SA Exp | ALT-SA_EXPDW-002 | SA Expdw Rdwt Head-002-AL | SA Expdw Rdwt Head-002-ALT | S | 1000000003 | 1003 | SA Exp | 2026-01-03 | MDM_USER | SA | ALT-SA_EXP | 2026-01-03 | 2026-01-03 | 2026-01-03 | S | SA Exp | 12.5000 | 12.5000 | SA Expdw Rdwt Head-002-ALT | SA | 12.5000 | 4 | 4 | SA Expdw R | ALT-SA | 4 | 2026-01-03 | S | 12.5000 | L |
| default | 1005 | 1000000005 | 1000000005 | 2026-01-05 | 2026-01-05 | 1005 | SA Expdw Rdwt Head-003-ED | 1105 | 2026-01-05 | 6 | SA Expdw R | EDGE-SA_EXPDW-00 | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | S | 6 | 1000000005 | SA Expdw Rdwt Head-003-ED | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Expdw Rdwt Head-003-EDGE | SA Ex | 1115 | 6 | BATCH_USER | SA Exp | 9005 | SA Exp | EDGE-SA_EXPDW-003 | SA Expdw R | 14.0000 | SA Exp | 1005 | S | SA Exp | SA Expdw Rdwt Head-003-EDGE | 6 | ACTIVE | SA Ex | EDGE-S | SA Expdw Rdwt Head-003-EDGE | S | 6 | SA Exp | EDGE-SA_EXPDW-003 | SA Expdw Rdwt Head-003-ED | SA Expdw Rdwt Head-003-EDGE | S | 1000000005 | 1005 | SA Exp | 2026-01-05 | BATCH_USER | SA | EDGE-SA_EX | 2026-01-05 | 2026-01-05 | 2026-01-05 | S | SA Exp | 14.0000 | 14.0000 | SA Expdw Rdwt Head-003-EDGE | SA | 14.0000 | 6 | 6 | SA Expdw R | EDGE-S | 6 | 2026-01-05 | S | 14.0000 | E |
Example values from field definitions
- STORER
- 1
- PROCESS_IDR
- 1
- RDWT_HEAD_IDRPK
- 1
- BUSINESS_DATER
- 2026-01-01
- EXPORT_DATETIMER
- 2026-01-01
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- VDATE
- 2026-01-01
- REV_NO
- 1
- CASHIER
- SAMPLE
- CUST_ID
- SAMPLE
- REF_NO1
- SAMPLE
- REF_NO2
- SAMPLE
- REF_NO3
- SAMPLE
- REF_NO4
- SAMPLE
- REF_NO5
- SAMPLE
- REF_NO6
- SAMPLE
- REF_NO7
- SAMPLE
- REF_NO8
- SAMPLE
- TAX_IND
- S
- TRAN_NO
- 1
- MEDIA_ID
- 1
- REF_ITEM
- SAMPLE
- REF_NO25
- SAMPLE
- REF_NO26
- SAMPLE
- REF_NO27
- SAMPLE
- REF_NO28
- SAMPLE
- REF_NO29
- SAMPLE
- REF_NO30
- SAMPLE
- REF_NO31
- SAMPLE
- REGISTER
- SAMPL
- SUBCLASS
- 1
- BANNER_NO
- 1
- CREATE_ID
- SAMPLE
- ITEM_TYPE
- SAMPLE
- RETURN_WH
- 1
- TRAN_TYPE
- SAMPLE
- UNIQUE_ID
- SAMPLE
- VENDOR_NO
- SAMPLE
- WASTE_PCT
- 1.0000
- ENTRY_MODE
- SAMPLE
- ORIG_STORE
- 1
- SALES_TYPE
- S
- WASTE_TYPE
- SAMPLE
- EMPLOYEE_NO
- SAMPLE
- ITEM_SEQ_NO
- 1
- ITEM_STATUS
- SAMPLE
- ORIG_REG_NO
- SAMPL
- REASON_CODE
- SAMPLE
- RECEIPT_IND
- SAMPLE
- RETAIL_TYPE
- S
- TRAN_SEQ_NO
- 1
- CUST_ID_TYPE
- SAMPLE
- INVENTORY_ID
- SAMPLE
- SELLING_ITEM
- SAMPLE
- CUST_ORDER_NO
- SAMPLE
- DROP_SHIP_IND
- S
- FUFILL_LOC_ID
- 1
- POSTING_STORE
- 1
- SUB_TRAN_TYPE
- SAMPLE
- TRAN_DATETIME
- 2026-01-01
- LAST_UPDATE_ID
- SAMPLE
- RTLOG_ORIG_SYS
- SAM
- SALESPERSON_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- CUST_ORDER_DATE
- 2026-01-01
- EXPIRATION_DATE
- 2026-01-01
- FUFILL_LOC_TYPE
- S
- OVERRIDE_REASON
- SAMPLE
- TOTAL_IGTAX_AMT
- 1.0000
- TOTAL_SALES_QTY
- 1.0000
- FULFILL_ORDER_NO
- SAMPLE
- TRAN_PROCESS_SYS
- SAM
- TOTAL_SALES_VALUE
- 1.0000
- CUST_ORDER_LINE_NO
- 1
- PVOID_ORIG_TRAN_NO
- 1
- RETURN_DISPOSITION
- SAMPLE
- RETURN_REASON_CODE
- SAMPLE
- RETURN_ORIG_TRAN_NO
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
- NO_INVENTORY_RET_IND
- S
- TOTAL_ORIG_SALES_VALUE
- 1.0000
- INVENTORY_IDENTIFIER_TYPE
- SAMPLE
default
- STORER
- 1003
- PROCESS_IDR
- 1000000003
- RDWT_HEAD_IDRPK
- 1000000003
- BUSINESS_DATER
- 2026-01-03
- EXPORT_DATETIMER
- 2026-01-03
- DEPT
- 1003
- ITEM
- SA Expdw Rdwt Head-002-AL
- CLASS
- 1103
- VDATE
- 2026-01-03
- REV_NO
- 4
- CASHIER
- SA Expdw R
- CUST_ID
- ALT-SA_EXPDW-002
- REF_NO1
- SA Expdw Rdwt Head-002-ALT
- REF_NO2
- SA Expdw Rdwt Head-002-ALT
- REF_NO3
- SA Expdw Rdwt Head-002-ALT
- REF_NO4
- SA Expdw Rdwt Head-002-ALT
- REF_NO5
- SA Expdw Rdwt Head-002-ALT
- REF_NO6
- SA Expdw Rdwt Head-002-ALT
- REF_NO7
- SA Expdw Rdwt Head-002-ALT
- REF_NO8
- SA Expdw Rdwt Head-002-ALT
- TAX_IND
- S
- TRAN_NO
- 4
- MEDIA_ID
- 1000000003
- REF_ITEM
- SA Expdw Rdwt Head-002-AL
- REF_NO25
- SA Expdw Rdwt Head-002-ALT
- REF_NO26
- SA Expdw Rdwt Head-002-ALT
- REF_NO27
- SA Expdw Rdwt Head-002-ALT
- REF_NO28
- SA Expdw Rdwt Head-002-ALT
- REF_NO29
- SA Expdw Rdwt Head-002-ALT
- REF_NO30
- SA Expdw Rdwt Head-002-ALT
- REF_NO31
- SA Expdw Rdwt Head-002-ALT
- REGISTER
- SA Ex
- SUBCLASS
- 1113
- BANNER_NO
- 4
- CREATE_ID
- MDM_USER
- ITEM_TYPE
- SA Exp
- RETURN_WH
- 9003
- TRAN_TYPE
- SA Exp
- UNIQUE_ID
- ALT-SA_EXPDW-002
- VENDOR_NO
- SA Expdw R
- WASTE_PCT
- 12.5000
- ENTRY_MODE
- SA Exp
- ORIG_STORE
- 1003
- SALES_TYPE
- S
- WASTE_TYPE
- SA Exp
- EMPLOYEE_NO
- SA Expdw Rdwt Head-002-ALT
- ITEM_SEQ_NO
- 4
- ITEM_STATUS
- PENDIN
- ORIG_REG_NO
- SA Ex
- REASON_CODE
- ALT-SA
- RECEIPT_IND
- SA Expdw Rdwt Head-002-ALT
- RETAIL_TYPE
- S
- TRAN_SEQ_NO
- 4
- CUST_ID_TYPE
- SA Exp
- INVENTORY_ID
- ALT-SA_EXPDW-002
- SELLING_ITEM
- SA Expdw Rdwt Head-002-AL
- CUST_ORDER_NO
- SA Expdw Rdwt Head-002-ALT
- DROP_SHIP_IND
- S
- FUFILL_LOC_ID
- 1000000003
- POSTING_STORE
- 1003
- SUB_TRAN_TYPE
- SA Exp
- TRAN_DATETIME
- 2026-01-03
- LAST_UPDATE_ID
- MDM_USER
- RTLOG_ORIG_SYS
- SA
- SALESPERSON_ID
- ALT-SA_EXP
- CREATE_DATETIME
- 2026-01-03
- CUST_ORDER_DATE
- 2026-01-03
- EXPIRATION_DATE
- 2026-01-03
- FUFILL_LOC_TYPE
- S
- OVERRIDE_REASON
- SA Exp
- TOTAL_IGTAX_AMT
- 12.5000
- TOTAL_SALES_QTY
- 12.5000
- FULFILL_ORDER_NO
- SA Expdw Rdwt Head-002-ALT
- TRAN_PROCESS_SYS
- SA
- TOTAL_SALES_VALUE
- 12.5000
- CUST_ORDER_LINE_NO
- 4
- PVOID_ORIG_TRAN_NO
- 4
- RETURN_DISPOSITION
- SA Expdw R
- RETURN_REASON_CODE
- ALT-SA
- RETURN_ORIG_TRAN_NO
- 4
- LAST_UPDATE_DATETIME
- 2026-01-03
- NO_INVENTORY_RET_IND
- S
- TOTAL_ORIG_SALES_VALUE
- 12.5000
- INVENTORY_IDENTIFIER_TYPE
- L
default
- STORER
- 1005
- PROCESS_IDR
- 1000000005
- RDWT_HEAD_IDRPK
- 1000000005
- BUSINESS_DATER
- 2026-01-05
- EXPORT_DATETIMER
- 2026-01-05
- DEPT
- 1005
- ITEM
- SA Expdw Rdwt Head-003-ED
- CLASS
- 1105
- VDATE
- 2026-01-05
- REV_NO
- 6
- CASHIER
- SA Expdw R
- CUST_ID
- EDGE-SA_EXPDW-00
- REF_NO1
- SA Expdw Rdwt Head-003-EDGE
- REF_NO2
- SA Expdw Rdwt Head-003-EDGE
- REF_NO3
- SA Expdw Rdwt Head-003-EDGE
- REF_NO4
- SA Expdw Rdwt Head-003-EDGE
- REF_NO5
- SA Expdw Rdwt Head-003-EDGE
- REF_NO6
- SA Expdw Rdwt Head-003-EDGE
- REF_NO7
- SA Expdw Rdwt Head-003-EDGE
- REF_NO8
- SA Expdw Rdwt Head-003-EDGE
- TAX_IND
- S
- TRAN_NO
- 6
- MEDIA_ID
- 1000000005
- REF_ITEM
- SA Expdw Rdwt Head-003-ED
- REF_NO25
- SA Expdw Rdwt Head-003-EDGE
- REF_NO26
- SA Expdw Rdwt Head-003-EDGE
- REF_NO27
- SA Expdw Rdwt Head-003-EDGE
- REF_NO28
- SA Expdw Rdwt Head-003-EDGE
- REF_NO29
- SA Expdw Rdwt Head-003-EDGE
- REF_NO30
- SA Expdw Rdwt Head-003-EDGE
- REF_NO31
- SA Expdw Rdwt Head-003-EDGE
- REGISTER
- SA Ex
- SUBCLASS
- 1115
- BANNER_NO
- 6
- CREATE_ID
- BATCH_USER
- ITEM_TYPE
- SA Exp
- RETURN_WH
- 9005
- TRAN_TYPE
- SA Exp
- UNIQUE_ID
- EDGE-SA_EXPDW-003
- VENDOR_NO
- SA Expdw R
- WASTE_PCT
- 14.0000
- ENTRY_MODE
- SA Exp
- ORIG_STORE
- 1005
- SALES_TYPE
- S
- WASTE_TYPE
- SA Exp
- EMPLOYEE_NO
- SA Expdw Rdwt Head-003-EDGE
- ITEM_SEQ_NO
- 6
- ITEM_STATUS
- ACTIVE
- ORIG_REG_NO
- SA Ex
- REASON_CODE
- EDGE-S
- RECEIPT_IND
- SA Expdw Rdwt Head-003-EDGE
- RETAIL_TYPE
- S
- TRAN_SEQ_NO
- 6
- CUST_ID_TYPE
- SA Exp
- INVENTORY_ID
- EDGE-SA_EXPDW-003
- SELLING_ITEM
- SA Expdw Rdwt Head-003-ED
- CUST_ORDER_NO
- SA Expdw Rdwt Head-003-EDGE
- DROP_SHIP_IND
- S
- FUFILL_LOC_ID
- 1000000005
- POSTING_STORE
- 1005
- SUB_TRAN_TYPE
- SA Exp
- TRAN_DATETIME
- 2026-01-05
- LAST_UPDATE_ID
- BATCH_USER
- RTLOG_ORIG_SYS
- SA
- SALESPERSON_ID
- EDGE-SA_EX
- CREATE_DATETIME
- 2026-01-05
- CUST_ORDER_DATE
- 2026-01-05
- EXPIRATION_DATE
- 2026-01-05
- FUFILL_LOC_TYPE
- S
- OVERRIDE_REASON
- SA Exp
- TOTAL_IGTAX_AMT
- 14.0000
- TOTAL_SALES_QTY
- 14.0000
- FULFILL_ORDER_NO
- SA Expdw Rdwt Head-003-EDGE
- TRAN_PROCESS_SYS
- SA
- TOTAL_SALES_VALUE
- 14.0000
- CUST_ORDER_LINE_NO
- 6
- PVOID_ORIG_TRAN_NO
- 6
- RETURN_DISPOSITION
- SA Expdw R
- RETURN_REASON_CODE
- EDGE-S
- RETURN_ORIG_TRAN_NO
- 6
- LAST_UPDATE_DATETIME
- 2026-01-05
- NO_INVENTORY_RET_IND
- S
- TOTAL_ORIG_SALES_VALUE
- 14.0000
- INVENTORY_IDENTIFIER_TYPE
- E
Rule Validation Summary
- Source Rule Count
- 101
- Governed Rule Count
- 91