Stage Fixed Deal Header
In ScopeTechnical: STAGE_FIXED_DEAL_HEAD | ID: OR-CST-STAGE_FIXED_DEAL_HEAD-STAGE_FIXED_DEAL_HEADER
This table is used to stage fixed 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_FIXED_DEAL_HEAD
Field Definitions(5)
Sample Load Data(4)
| _scenario | INCOMER | VENDORR | DEAL_NOR | CURRENCYR | VENDOR_TYPER | LOCATION | VAT_CODE | VAT_RATE | UPLOAD_IND | ORG_UNIT_ID | DEB_CRED_IND | NON_MERCH_IND | TSF_ENTITY_ID | NON_MERCH_CODE | COLLECTION_DATE | SET_OF_BOOKS_ID | INVOICE_PROCESSING_LOGIC |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | SAMPLE | 1 | SAM | SAMPLE | 1 | SAMPLE | 1.0000000000 | S | 1 | SAMPLE | S | 1 | SAMPLE | 2026-01-01 | 1 | SAMPLE |
| default | 12.5000 | Stage Fixe | 4 | Sta | Stage | 3 | ALT-ST | 12.5000000000 | N | 1000000003 | Stage | S | 1000000003 | ALT-ST | 2026-01-03 | 1000000003 | Stage |
| default | 14.0000 | Stage Fixe | 6 | Sta | Stage | 5 | EDGE-S | 14.0000000000 | N | 1000000005 | Stage | S | 1000000005 | EDGE-S | 2026-01-05 | 1000000005 | Stage |
Example values from field definitions
- INCOMER
- 1.0000
- VENDORR
- SAMPLE
- DEAL_NOR
- 1
- CURRENCYR
- SAM
- VENDOR_TYPER
- SAMPLE
- LOCATION
- 1
- VAT_CODE
- SAMPLE
- VAT_RATE
- 1.0000000000
- UPLOAD_IND
- S
- ORG_UNIT_ID
- 1
- DEB_CRED_IND
- SAMPLE
- NON_MERCH_IND
- S
- TSF_ENTITY_ID
- 1
- NON_MERCH_CODE
- SAMPLE
- COLLECTION_DATE
- 2026-01-01
- SET_OF_BOOKS_ID
- 1
- INVOICE_PROCESSING_LOGIC
- SAMPLE
default
- INCOMER
- 12.5000
- VENDORR
- Stage Fixe
- DEAL_NOR
- 4
- CURRENCYR
- Sta
- VENDOR_TYPER
- Stage
- LOCATION
- 3
- VAT_CODE
- ALT-ST
- VAT_RATE
- 12.5000000000
- UPLOAD_IND
- N
- ORG_UNIT_ID
- 1000000003
- DEB_CRED_IND
- Stage
- NON_MERCH_IND
- S
- TSF_ENTITY_ID
- 1000000003
- NON_MERCH_CODE
- ALT-ST
- COLLECTION_DATE
- 2026-01-03
- SET_OF_BOOKS_ID
- 1000000003
- INVOICE_PROCESSING_LOGIC
- Stage
default
- INCOMER
- 14.0000
- VENDORR
- Stage Fixe
- DEAL_NOR
- 6
- CURRENCYR
- Sta
- VENDOR_TYPER
- Stage
- LOCATION
- 5
- VAT_CODE
- EDGE-S
- VAT_RATE
- 14.0000000000
- UPLOAD_IND
- N
- ORG_UNIT_ID
- 1000000005
- DEB_CRED_IND
- Stage
- NON_MERCH_IND
- S
- TSF_ENTITY_ID
- 1000000005
- NON_MERCH_CODE
- EDGE-S
- COLLECTION_DATE
- 2026-01-05
- SET_OF_BOOKS_ID
- 1000000005
- INVOICE_PROCESSING_LOGIC
- Stage
Rule Validation Summary
- Source Rule Count
- 35
- Governed Rule Count
- 25