Fixed Deal
In ScopeTechnical: FIXED_DEAL | ID: OR-MFCS-FIXED_DEAL
This table will hold the basic fixed deal information to include the amount of money that will be collected from the specified supplier and when to collect that money from…
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
Target Structure
- Load Approach
- Table
- Target Objects
- FIXED_DEAL
Field Definitions(25)
Rules & Considerations(78)
Sample Load Data(4)
| _scenario | TYPER | STATUSR | DEAL_NORPK | USER_IDR | VAT_INDR | SUPPLIERPK | DEAL_DESCR | MERCH_INDR | COLLECT_BYR | PARTNER_TYPERPK | CURRENCY_CODER | FIXED_DEAL_AMTR | NON_MERCH_CODEPK | COLLECT_PERIODSR | COLLECT_END_DATER | COLLECT_START_DATER | COMMENTS | VAT_CODE | VAT_RATE | PROMOTION | EXT_REF_NO | PARTNER_ID | ORG_UNIT_ID | DEB_CRED_IND | INVOICE_PROCESSING_LOGIC |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Fixed Deal-001 | I | 2 | STD-FIXED_DEAL-001 | Y | 1 | Fixed Deal-001 | Y | D | S | STD-FIXED_DEAL-001 | 11.0000 | STD-FIXED_DEAL-001 | 01 | 2026-01-01 | 2026-01-01 | Fixed Deal-001 | STD-FIXED_DEAL-001 | 11.0000 | 1 | Fixed Deal-001 | STD-FIXED_DEAL-001 | 1000000001 | note | NO |
default
- TYPER
- Fixed Deal-001
- STATUSR
- I
- DEAL_NORPK
- 2
- USER_IDR
- STD-FIXED_DEAL-001
- VAT_INDR
- Y
- SUPPLIERPK
- 1
- DEAL_DESCR
- Fixed Deal-001
- MERCH_INDR
- Y
- COLLECT_BYR
- D
- PARTNER_TYPERPK
- S
- CURRENCY_CODER
- STD-FIXED_DEAL-001
- FIXED_DEAL_AMTR
- 11.0000
- NON_MERCH_CODEPK
- STD-FIXED_DEAL-001
- COLLECT_PERIODSR
- 01
- COLLECT_END_DATER
- 2026-01-01
- COLLECT_START_DATER
- 2026-01-01
- COMMENTS
- Fixed Deal-001
- VAT_CODE
- STD-FIXED_DEAL-001
- VAT_RATE
- 11.0000
- PROMOTION
- 1
- EXT_REF_NO
- Fixed Deal-001
- PARTNER_ID
- STD-FIXED_DEAL-001
- ORG_UNIT_ID
- 1000000001
- DEB_CRED_IND
- note
- INVOICE_PROCESSING_LOGIC
- NO
