ReSA Expdw Wc Ws (Temporary)
Out of ScopeTechnical: SA_EXPDW_WC_WS_TEMP | ID: OR-RSA-SA_EXPDW_WC_WS_TEMP-SA_EXPDW_WC_WS_TEMP
Temporary work table used during sales audit processing in Oracle Retail Merchandising to store intermediate records needed by batch programs or online workflows. It supports short-lived calculations, selection sets, or...
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_TEMP
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 Temp-002-ALT | SA Expdw Wc Ws Temp-002-ALT | SA Expdw Wc Ws Temp-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 Temp-003-EDGE | SA Expdw Wc Ws Temp-003-EDGE | SA Expdw Wc Ws Temp-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 Temp-002-ALT
- REF_NO2
- SA Expdw Wc Ws Temp-002-ALT
- REF_NO3
- SA Expdw Wc Ws Temp-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 Temp-003-EDGE
- REF_NO2
- SA Expdw Wc Ws Temp-003-EDGE
- REF_NO3
- SA Expdw Wc Ws Temp-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