One Row For Each Department/Subclass Combination
In ScopeTechnical: SUBCLASS | ID: OR-FND-SUBCLASS-SUBCLASS
Stores one row for each department/subclass combination within the company. Whenever a subclass name is used by Oracle Retail, or a subclass is validated, it is always selected from this…
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
- SUBCLASS
Field Definitions(15)
Rules & Considerations(24)
validation
constraint
Sample Load Data(4)
| _scenario | DEPTRPK | CLASSR | SUBCLASSR | SUB_NAMER | CREATE_IDR | SUBCLASS_IDR | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | INCLUDE_UP_CHRG_IN_PRC_COSTR | DEFAULT_IC_TSF_PRICE | MIN_UNITS_FOR_SELL_DATE_RESET | UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND | UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND | UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | S | SAMPLE | 1.0000 | S | S | S |
Example values from field definitions
- DEPTRPK
- 1
- CLASSR
- 1
- SUBCLASSR
- 1
- SUB_NAMER
- SAMPLE
- CREATE_IDR
- SAMPLE
- SUBCLASS_IDR
- 1
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- INCLUDE_UP_CHRG_IN_PRC_COSTR
- S
- DEFAULT_IC_TSF_PRICE
- SAMPLE
- MIN_UNITS_FOR_SELL_DATE_RESET
- 1.0000
- UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND
- S
- UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND
- S
- UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND
- S
Rule Validation Summary
- Source Rule Count
- 45
- Governed Rule Count
- 24