Wf Order Audit
In ScopeTechnical: WF_ORDER_AUDIT | ID: OR-FND-WF_ORDER_AUDIT-WF_ORDER_AUDIT
This table keeps an audit trail for all submitted Franchise Orders in the system. It captures any changes made to a Franchise Order once it has been submitted.
See how this object fits into Foundation Data
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
- WF_ORDER_AUDIT
Field Definitions(5)
Rules & Considerations(11)
constraint
validation
Sample Load Data(4)
| _scenario | SEQ_NORPK | WF_ORDER_NORPK | WF_ORDER_LINE_NOR | MODIFIED_QTY | ITEM_CANCELLED_IND |
|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1.0000 | S |
| default | 4 | 4 | 4 | 12.5000 | W |
| default | 6 | 6 | 6 | 14.0000 | W |
Example values from field definitions
- SEQ_NORPK
- 1
- WF_ORDER_NORPK
- 1
- WF_ORDER_LINE_NOR
- 1
- MODIFIED_QTY
- 1.0000
- ITEM_CANCELLED_IND
- S
default
- SEQ_NORPK
- 4
- WF_ORDER_NORPK
- 4
- WF_ORDER_LINE_NOR
- 4
- MODIFIED_QTY
- 12.5000
- ITEM_CANCELLED_IND
- W
default
- SEQ_NORPK
- 6
- WF_ORDER_NORPK
- 6
- WF_ORDER_LINE_NOR
- 6
- MODIFIED_QTY
- 14.0000
- ITEM_CANCELLED_IND
- W
Rule Validation Summary
- Source Rule Count
- 14
- Governed Rule Count
- 11