Terms Detail
In ScopeTechnical: TERMS_DETAIL | ID: OR-CFG-TERMS_DETAIL-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
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- TERMS_DETAIL
Field Definitions(5)
Rules & Considerations(20)
validation
constraint
Sample Load Data(4)
| _scenario | TERMSRPK | TERMS_SEQRPK | DUE_MAX_AMOUNTR | DUEDAYS | DUE_DOM | PERCENT | DISCDAYS | DISC_DOM | CUTOFF_DAY | DUE_MM_FWD | FIXED_DATE | DISC_MM_FWD | ENABLED_FLAG | END_DATE_ACTIVE | START_DATE_ACTIVE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | 1 | 1 | 1.0000 | 1 | 1 | 1 | 1 | 2026-01-01 | 1 | S | 2026-01-01 | 2026-01-01 |
| default | Terms Detail-00 | 3 | 12.5000 | 3 | 3 | 12.5000 | 3 | 3 | 3 | 3 | 2026-01-03 | 3 | T | 2026-01-03 | 2026-01-03 |
| default | Terms Detail-00 | 5 | 14.0000 | 5 | 5 | 14.0000 | 5 | 5 | 5 | 5 | 2026-01-05 | 5 | T | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- TERMSRPK
- SAMPLE
- TERMS_SEQRPK
- 1
- DUE_MAX_AMOUNTR
- 1.0000
- DUEDAYS
- 1
- DUE_DOM
- 1
- PERCENT
- 1.0000
- DISCDAYS
- 1
- DISC_DOM
- 1
- CUTOFF_DAY
- 1
- DUE_MM_FWD
- 1
- FIXED_DATE
- 2026-01-01
- DISC_MM_FWD
- 1
- ENABLED_FLAG
- S
- END_DATE_ACTIVE
- 2026-01-01
- START_DATE_ACTIVE
- 2026-01-01
default
- TERMSRPK
- Terms Detail-00
- TERMS_SEQRPK
- 3
- DUE_MAX_AMOUNTR
- 12.5000
- DUEDAYS
- 3
- DUE_DOM
- 3
- PERCENT
- 12.5000
- DISCDAYS
- 3
- DISC_DOM
- 3
- CUTOFF_DAY
- 3
- DUE_MM_FWD
- 3
- FIXED_DATE
- 2026-01-03
- DISC_MM_FWD
- 3
- ENABLED_FLAG
- T
- END_DATE_ACTIVE
- 2026-01-03
- START_DATE_ACTIVE
- 2026-01-03
default
- TERMSRPK
- Terms Detail-00
- TERMS_SEQRPK
- 5
- DUE_MAX_AMOUNTR
- 14.0000
- DUEDAYS
- 5
- DUE_DOM
- 5
- PERCENT
- 14.0000
- DISCDAYS
- 5
- DISC_DOM
- 5
- CUTOFF_DAY
- 5
- DUE_MM_FWD
- 5
- FIXED_DATE
- 2026-01-05
- DISC_MM_FWD
- 5
- ENABLED_FLAG
- T
- END_DATE_ACTIVE
- 2026-01-05
- START_DATE_ACTIVE
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 20