Terms Detail
In ScopeTechnical: TERMS_DETAIL | ID: OR-MFCS-TERMS_DETAIL
This table is to create a hierarchical table structure to enhance performance for integration with 3rd party finance systems.
See how this object fits into Configuration
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Information Type
- Configuration
Target Structure
- Load Approach
- Table
- Target Objects
- TERMS_DETAIL
Field Definitions(15)
Rules & Considerations(40)
Sample Load Data(4)
| _scenario | TERMSRPK | PERCENTR | TERMS_SEQR | CUTOFF_DAYR | ENABLED_FLAGR | DUE_MAX_AMOUNTR | DUEDAYS | DUE_DOM | DISCDAYS | DISC_DOM | DUE_MM_FWD | FIXED_DATE | DISC_MM_FWD | END_DATE_ACTIVE | START_DATE_ACTIVE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Terms Detail-001 | 11.0000 | 1 | 01 | Terms Detail-001 | 11.0000 | 001 | 01 | 001 | 01 | 001 | 2026-01-01 | 001 | 2026-01-01 | 2026-01-01 |
default
- TERMSRPK
- Terms Detail-001
- PERCENTR
- 11.0000
- TERMS_SEQR
- 1
- CUTOFF_DAYR
- 01
- ENABLED_FLAGR
- Terms Detail-001
- DUE_MAX_AMOUNTR
- 11.0000
- DUEDAYS
- 001
- DUE_DOM
- 01
- DISCDAYS
- 001
- DISC_DOM
- 01
- DUE_MM_FWD
- 001
- FIXED_DATE
- 2026-01-01
- DISC_MM_FWD
- 001
- END_DATE_ACTIVE
- 2026-01-01
- START_DATE_ACTIVE
- 2026-01-01