Stage Complex Deal Detail
In ScopeTechnical: STAGE_COMPLEX_DEAL_DETAIL | ID: OR-CST-STAGE_COMPLEX_DEAL_DETAIL-STAGE_COMPLEX_DEAL_DETAIL
This table is used to stage the details of complex deal invoicing information to Oracle Retail Invoice Matching.
See how this object fits into Cost
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
- STAGE_COMPLEX_DEAL_DETAIL
Field Definitions(5)
Sample Load Data(4)
| _scenario | SEQ_NOR | DEAL_IDRPK | LOCATIONR | LOC_TYPER | DEAL_DETAIL_IDR | ITEM | ORDER_NO | VAT_CODE | VAT_RATE | TSF_ENTITY_ID | LOCAL_CURRENCY | SET_OF_BOOKS_ID | INCOME_DEAL_CURRENCY | ACTUAL_TURNOVER_UNITS | INCOME_LOCAL_CURRENCY | TAX_AMT_DEAL_CURRENCY | ACTUAL_TURNOVER_REVENUE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | 1 | SAMPLE | 1 | SAMPLE | 1.0000 | 1 | SAM | 1 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 |
| default | 4 | 1000000003 | 3 | S | 1000000003 | Stage Complex Deal Detail | 4 | ALT-ST | 12.5000 | 1000000003 | Sta | 1000000003 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 |
| default | 6 | 1000000005 | 5 | S | 1000000005 | Stage Complex Deal Detail | 6 | EDGE-S | 14.0000 | 1000000005 | Sta | 1000000005 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- SEQ_NOR
- 1
- DEAL_IDRPK
- 1
- LOCATIONR
- 1
- LOC_TYPER
- S
- DEAL_DETAIL_IDR
- 1
- ITEM
- SAMPLE
- ORDER_NO
- 1
- VAT_CODE
- SAMPLE
- VAT_RATE
- 1.0000
- TSF_ENTITY_ID
- 1
- LOCAL_CURRENCY
- SAM
- SET_OF_BOOKS_ID
- 1
- INCOME_DEAL_CURRENCY
- 1.0000
- ACTUAL_TURNOVER_UNITS
- 1.0000
- INCOME_LOCAL_CURRENCY
- 1.0000
- TAX_AMT_DEAL_CURRENCY
- 1.0000
- ACTUAL_TURNOVER_REVENUE
- 1.0000
default
- SEQ_NOR
- 4
- DEAL_IDRPK
- 1000000003
- LOCATIONR
- 3
- LOC_TYPER
- S
- DEAL_DETAIL_IDR
- 1000000003
- ITEM
- Stage Complex Deal Detail
- ORDER_NO
- 4
- VAT_CODE
- ALT-ST
- VAT_RATE
- 12.5000
- TSF_ENTITY_ID
- 1000000003
- LOCAL_CURRENCY
- Sta
- SET_OF_BOOKS_ID
- 1000000003
- INCOME_DEAL_CURRENCY
- 12.5000
- ACTUAL_TURNOVER_UNITS
- 12.5000
- INCOME_LOCAL_CURRENCY
- 12.5000
- TAX_AMT_DEAL_CURRENCY
- 12.5000
- ACTUAL_TURNOVER_REVENUE
- 12.5000
default
- SEQ_NOR
- 6
- DEAL_IDRPK
- 1000000005
- LOCATIONR
- 5
- LOC_TYPER
- S
- DEAL_DETAIL_IDR
- 1000000005
- ITEM
- Stage Complex Deal Detail
- ORDER_NO
- 6
- VAT_CODE
- EDGE-S
- VAT_RATE
- 14.0000
- TSF_ENTITY_ID
- 1000000005
- LOCAL_CURRENCY
- Sta
- SET_OF_BOOKS_ID
- 1000000005
- INCOME_DEAL_CURRENCY
- 14.0000
- ACTUAL_TURNOVER_UNITS
- 14.0000
- INCOME_LOCAL_CURRENCY
- 14.0000
- TAX_AMT_DEAL_CURRENCY
- 14.0000
- ACTUAL_TURNOVER_REVENUE
- 14.0000
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 32