ReSA Reference
In ScopeTechnical: SA_REFERENCE | ID: OR-RSA-SA_REFERENCE-RESA_REFERENCE
This table defines the type of information stored in the ref_no columns on the sa_tran_head, sa_tran_item and sa_tran_tender tables based on the transaction type.
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_REFERENCE
Field Definitions(5)
Rules & Considerations(11)
constraint
validation
Sample Load Data(4)
| _scenario | REF_NOR | TRAN_TYPER | REF_SEQ_NORPK | REASON_CODE | SUB_TRAN_TYPE | REF_LABEL_CODE |
|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE |
| default | 4 | SA Ref | 4 | ALT-SA | SA Ref | ALT-SA |
| default | 6 | SA Ref | 6 | EDGE-S | SA Ref | EDGE-S |
Example values from field definitions
- REF_NOR
- 1
- TRAN_TYPER
- SAMPLE
- REF_SEQ_NORPK
- 1
- REASON_CODE
- SAMPLE
- SUB_TRAN_TYPE
- SAMPLE
- REF_LABEL_CODE
- SAMPLE
default
- REF_NOR
- 4
- TRAN_TYPER
- SA Ref
- REF_SEQ_NORPK
- 4
- REASON_CODE
- ALT-SA
- SUB_TRAN_TYPE
- SA Ref
- REF_LABEL_CODE
- ALT-SA
default
- REF_NOR
- 6
- TRAN_TYPER
- SA Ref
- REF_SEQ_NORPK
- 6
- REASON_CODE
- EDGE-S
- SUB_TRAN_TYPE
- SA Ref
- REF_LABEL_CODE
- EDGE-S
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 11