Dc Terms Detail

In Scope

Technical: DC_TERMS_DETAIL | ID: OR-FND-DC_TERMS_DETAIL-DC_TERMS_DETAIL

This table is a staging table for data conversion and will hold data for TERM_DETAIL table.

See how this object fits into Foundation Data

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: DC_TERMS_DETAIL

Field Definitions(5)

Rules & Considerations(12)

Sample Load Data(4)

_scenario	TERMS	DUEDAYS	DUE_DOM	PERCENT	DISCDAYS	DISC_DOM	TERMS_SEQ	CUTOFF_DAY	DUE_MM_FWD	FIXED_DATE	DISC_MM_FWD	ENABLED_FLAG	DUE_MAX_AMOUNT	END_DATE_ACTIVE	START_DATE_ACTIVE
Example values from field definitions	SAMPLE	1	1	1.0000	1	1	1	1	1	2026-01-01	1	S	1.0000	2026-01-01	2026-01-01
default	Dc Terms Detail	3	3	12.5000	3	3	3	3	3	2026-01-03	3	D	12.5000	2026-01-03	2026-01-03
default	Dc Terms Detail	5	5	14.0000	5	5	5	5	5	2026-01-05	5	D	14.0000	2026-01-05	2026-01-05

Example values from field definitions

TERMS: SAMPLE
DUEDAYS: 1
DUE_DOM: 1
PERCENT: 1.0000
DISCDAYS: 1
DISC_DOM: 1
TERMS_SEQ: 1
CUTOFF_DAY: 1
DUE_MM_FWD: 1
FIXED_DATE: 2026-01-01
DISC_MM_FWD: 1
ENABLED_FLAG: S
DUE_MAX_AMOUNT: 1.0000
END_DATE_ACTIVE: 2026-01-01
START_DATE_ACTIVE: 2026-01-01

default

TERMS: Dc Terms Detail
DUEDAYS: 3
DUE_DOM: 3
PERCENT: 12.5000
DISCDAYS: 3
DISC_DOM: 3
TERMS_SEQ: 3
CUTOFF_DAY: 3
DUE_MM_FWD: 3
FIXED_DATE: 2026-01-03
DISC_MM_FWD: 3
ENABLED_FLAG: D
DUE_MAX_AMOUNT: 12.5000
END_DATE_ACTIVE: 2026-01-03
START_DATE_ACTIVE: 2026-01-03

default

TERMS: Dc Terms Detail
DUEDAYS: 5
DUE_DOM: 5
PERCENT: 14.0000
DISCDAYS: 5
DISC_DOM: 5
TERMS_SEQ: 5
CUTOFF_DAY: 5
DUE_MM_FWD: 5
FIXED_DATE: 2026-01-05
DISC_MM_FWD: 5
ENABLED_FLAG: D
DUE_MAX_AMOUNT: 14.0000
END_DATE_ACTIVE: 2026-01-05
START_DATE_ACTIVE: 2026-01-05

Rule Validation Summary

Source Rule Count: 15
Governed Rule Count: 12