Fixed Deal
In ScopeTechnical: FIXED_DEAL | ID: OR-CST-FIXED_DEAL-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- FIXED_DEAL
Field Definitions(5)
Rules & Considerations(45)
validation
constraint
Sample Load Data(4)
| _scenario | TYPER | DEAL_NORPK | DEAL_DESCR | FIXED_DEAL_AMTR | STATUS | USER_ID | VAT_IND | COMMENTS | SUPPLIER | VAT_CODE | VAT_RATE | MERCH_IND | PROMOTION | COLLECT_BY | EXT_REF_NO | PARTNER_ID | ORG_UNIT_ID | DEB_CRED_IND | PARTNER_TYPE | CURRENCY_CODE | NON_MERCH_CODE | COLLECT_PERIODS | COLLECT_END_DATE | COLLECT_START_DATE | INVOICE_PROCESSING_LOGIC |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | 1.0000 | S | SAMPLE | S | SAMPLE | 1 | SAMPLE | 1.0000000000 | S | 1 | S | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAM | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | SAMPLE |
| default | Fixed | 4 | Fixed Deal-002-ALT | 12.5000 | A | ALT-FIXED_DEAL-002 | Y | Fixed Deal-002-ALT | 3 | ALT-FI | 12.5000000000 | Y | 3 | M | Fixed Deal-002-ALT | ALT-FIXED_ | 1000000003 | note | SS | ALT | ALT-FI | 3 | 2026-01-03 | 2026-01-03 | AA |
| default | Fixed | 6 | Fixed Deal-003-EDGE | 14.0000 | I | EDGE-FIXED_DEAL-003 | Y | Fixed Deal-003-EDGE | 5 | EDGE-F | 14.0000000000 | Y | 5 | Q | Fixed Deal-003-EDGE | EDGE-FIXED | 1000000005 | note | S1 | EDG | EDGE-F | 5 | 2026-01-05 | 2026-01-05 | MA |
Example values from field definitions
- TYPER
- SAMPLE
- DEAL_NORPK
- 1
- DEAL_DESCR
- SAMPLE
- FIXED_DEAL_AMTR
- 1.0000
- STATUS
- S
- USER_ID
- SAMPLE
- VAT_IND
- S
- COMMENTS
- SAMPLE
- SUPPLIER
- 1
- VAT_CODE
- SAMPLE
- VAT_RATE
- 1.0000000000
- MERCH_IND
- S
- PROMOTION
- 1
- COLLECT_BY
- S
- EXT_REF_NO
- SAMPLE
- PARTNER_ID
- SAMPLE
- ORG_UNIT_ID
- 1
- DEB_CRED_IND
- SAMPLE
- PARTNER_TYPE
- SAMPLE
- CURRENCY_CODE
- SAM
- NON_MERCH_CODE
- SAMPLE
- COLLECT_PERIODS
- 1
- COLLECT_END_DATE
- 2026-01-01
- COLLECT_START_DATE
- 2026-01-01
- INVOICE_PROCESSING_LOGIC
- SAMPLE
default
- TYPER
- Fixed
- DEAL_NORPK
- 4
- DEAL_DESCR
- Fixed Deal-002-ALT
- FIXED_DEAL_AMTR
- 12.5000
- STATUS
- A
- USER_ID
- ALT-FIXED_DEAL-002
- VAT_IND
- Y
- COMMENTS
- Fixed Deal-002-ALT
- SUPPLIER
- 3
- VAT_CODE
- ALT-FI
- VAT_RATE
- 12.5000000000
- MERCH_IND
- Y
- PROMOTION
- 3
- COLLECT_BY
- M
- EXT_REF_NO
- Fixed Deal-002-ALT
- PARTNER_ID
- ALT-FIXED_
- ORG_UNIT_ID
- 1000000003
- DEB_CRED_IND
- note
- PARTNER_TYPE
- SS
- CURRENCY_CODE
- ALT
- NON_MERCH_CODE
- ALT-FI
- COLLECT_PERIODS
- 3
- COLLECT_END_DATE
- 2026-01-03
- COLLECT_START_DATE
- 2026-01-03
- INVOICE_PROCESSING_LOGIC
- AA
default
- TYPER
- Fixed
- DEAL_NORPK
- 6
- DEAL_DESCR
- Fixed Deal-003-EDGE
- FIXED_DEAL_AMTR
- 14.0000
- STATUS
- I
- USER_ID
- EDGE-FIXED_DEAL-003
- VAT_IND
- Y
- COMMENTS
- Fixed Deal-003-EDGE
- SUPPLIER
- 5
- VAT_CODE
- EDGE-F
- VAT_RATE
- 14.0000000000
- MERCH_IND
- Y
- PROMOTION
- 5
- COLLECT_BY
- Q
- EXT_REF_NO
- Fixed Deal-003-EDGE
- PARTNER_ID
- EDGE-FIXED
- ORG_UNIT_ID
- 1000000005
- DEB_CRED_IND
- note
- PARTNER_TYPE
- S1
- CURRENCY_CODE
- EDG
- NON_MERCH_CODE
- EDGE-F
- COLLECT_PERIODS
- 5
- COLLECT_END_DATE
- 2026-01-05
- COLLECT_START_DATE
- 2026-01-05
- INVOICE_PROCESSING_LOGIC
- MA
Rule Validation Summary
- Source Rule Count
- 69
- Governed Rule Count
- 45