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(84)
Rules & Considerations(91)
constraint
validation
Sample Load Data(4)
| _scenario | STORER | REV_NOR | CREATE_IDR | TRAN_TYPER | PROCESS_IDR | TRAN_SEQ_NOR | RDWT_HEAD_IDRPK | BUSINESS_DATER | TRAN_DATETIMER | LAST_UPDATE_IDR | RTLOG_ORIG_SYSR | CREATE_DATETIMER | EXPORT_DATETIMER | LAST_UPDATE_DATETIMER | DEPT | ITEM | CLASS | VDATE | 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 | ITEM_TYPE | RETURN_WH | 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 | CUST_ID_TYPE | INVENTORY_ID | SELLING_ITEM | CUST_ORDER_NO | DROP_SHIP_IND | FUFILL_LOC_ID | POSTING_STORE | SUB_TRAN_TYPE | SALESPERSON_ID | 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 | NO_INVENTORY_RET_IND | TOTAL_ORIG_SALES_VALUE | INVENTORY_IDENTIFIER_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | 1 | 1 | 1 | 2026-01-01 | 2026-01-01 | SAMPLE | SAM | 2026-01-01 | 2026-01-01 | 2026-01-01 | 1 | SAMPLE | 1 | 2026-01-01 | 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 | 1 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 1 | S | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPL | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1 | 1 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | S | SAMPLE | 1.0000 | 1.0000 | SAMPLE | SAM | 1.0000 | 1 | 1 | SAMPLE | SAMPLE | 1 | S | 1.0000 | SAMPLE |
Example values from field definitions
- STORER
- 1
- REV_NOR
- 1
- CREATE_IDR
- SAMPLE
- TRAN_TYPER
- SAMPLE
- PROCESS_IDR
- 1
- TRAN_SEQ_NOR
- 1
- RDWT_HEAD_IDRPK
- 1
- BUSINESS_DATER
- 2026-01-01
- TRAN_DATETIMER
- 2026-01-01
- LAST_UPDATE_IDR
- SAMPLE
- RTLOG_ORIG_SYSR
- SAM
- CREATE_DATETIMER
- 2026-01-01
- EXPORT_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- VDATE
- 2026-01-01
- 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
- ITEM_TYPE
- SAMPLE
- RETURN_WH
- 1
- 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
- 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
- SALESPERSON_ID
- SAMPLE
- 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
- NO_INVENTORY_RET_IND
- S
- TOTAL_ORIG_SALES_VALUE
- 1.0000
- INVENTORY_IDENTIFIER_TYPE
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 101
- Governed Rule Count
- 91