ReSA Expdw Wc Ws Tmp
Out of ScopeTechnical: SA_EXPDW_WC_WS_TMP | ID: OR-RSA-SA_EXPDW_WC_WS_TMP-SA_EXPDW_WC_WS_TMP
Stores sales audit data for SA expdw wc ws tmp in Oracle Retail Merchandising. Used to support operational processing, integration, and reporting within the Oracle Retail application landscape.
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
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- SA_EXPDW_WC_WS_TMP
Field Definitions(5)
Rules & Considerations(15)
Sample Load Data(4)
| _scenario | TOTAL_SEQ_NOR | VALUE | EMP_ID | STATUS | CASHIER | REF_NO1 | REF_NO2 | REF_NO3 | REGISTER | TOTAL_ID | SIGN_VALUE | TOTAL_TYPE | PROCESS_IND | VALUE_REV_NO |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPL | SAMPLE | S | SAMPLE | S | 1 |
| default | 4 | 12.5000 | ALT-SA_EXP | PENDIN | SA Expdw W | SA Expdw Wc Ws Tmp-002-ALT | SA Expdw Wc Ws Tmp-002-ALT | SA Expdw Wc Ws Tmp-002-ALT | SA Ex | ALT-SA_EXP | S | SA Expdw W | S | 4 |
| default | 6 | 14.0000 | EDGE-SA_EX | ACTIVE | SA Expdw W | SA Expdw Wc Ws Tmp-003-EDGE | SA Expdw Wc Ws Tmp-003-EDGE | SA Expdw Wc Ws Tmp-003-EDGE | SA Ex | EDGE-SA_EX | S | SA Expdw W | S | 6 |
Example values from field definitions
- TOTAL_SEQ_NOR
- 1
- VALUE
- 1.0000
- EMP_ID
- SAMPLE
- STATUS
- SAMPLE
- CASHIER
- SAMPLE
- REF_NO1
- SAMPLE
- REF_NO2
- SAMPLE
- REF_NO3
- SAMPLE
- REGISTER
- SAMPL
- TOTAL_ID
- SAMPLE
- SIGN_VALUE
- S
- TOTAL_TYPE
- SAMPLE
- PROCESS_IND
- S
- VALUE_REV_NO
- 1
default
- TOTAL_SEQ_NOR
- 4
- VALUE
- 12.5000
- EMP_ID
- ALT-SA_EXP
- STATUS
- PENDIN
- CASHIER
- SA Expdw W
- REF_NO1
- SA Expdw Wc Ws Tmp-002-ALT
- REF_NO2
- SA Expdw Wc Ws Tmp-002-ALT
- REF_NO3
- SA Expdw Wc Ws Tmp-002-ALT
- REGISTER
- SA Ex
- TOTAL_ID
- ALT-SA_EXP
- SIGN_VALUE
- S
- TOTAL_TYPE
- SA Expdw W
- PROCESS_IND
- S
- VALUE_REV_NO
- 4
default
- TOTAL_SEQ_NOR
- 6
- VALUE
- 14.0000
- EMP_ID
- EDGE-SA_EX
- STATUS
- ACTIVE
- CASHIER
- SA Expdw W
- REF_NO1
- SA Expdw Wc Ws Tmp-003-EDGE
- REF_NO2
- SA Expdw Wc Ws Tmp-003-EDGE
- REF_NO3
- SA Expdw Wc Ws Tmp-003-EDGE
- REGISTER
- SA Ex
- TOTAL_ID
- EDGE-SA_EX
- SIGN_VALUE
- S
- TOTAL_TYPE
- SA Expdw W
- PROCESS_IND
- S
- VALUE_REV_NO
- 6
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 15