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(5)
Rules & Considerations(28)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTRPK | CLASSRPK | SUBCLASSRPK | SUB_NAMER | CREATE_IDR | SUBCLASS_ID | LAST_UPDATE_ID | CREATE_DATETIME | DEFAULT_IC_TSF_PRICE | LAST_UPDATE_DATETIME | INCLUDE_UP_CHRG_IN_PRC_COST | 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 | SAMPLE | 2026-01-01 | S | 1.0000 | S | S | S |
| default | 1003 | 1103 | 1113 | Subclass Secondary | C LIENT_INFO | 1000000003 | APP_USER_ID | 2026-01-03 | value | 2026-01-03 | N | NULL | N | N | N |
| default | 1005 | 1105 | 1115 | Subclass Core | USE RENV | 1000000005 | USERENV | 2026-01-05 | value | 2026-01-05 | N | NULL | N | N | N |
Example values from field definitions
- DEPTRPK
- 1
- CLASSRPK
- 1
- SUBCLASSRPK
- 1
- SUB_NAMER
- SAMPLE
- CREATE_IDR
- SAMPLE
- SUBCLASS_ID
- 1
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- DEFAULT_IC_TSF_PRICE
- SAMPLE
- LAST_UPDATE_DATETIME
- 2026-01-01
- INCLUDE_UP_CHRG_IN_PRC_COST
- S
- 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
default
- DEPTRPK
- 1003
- CLASSRPK
- 1103
- SUBCLASSRPK
- 1113
- SUB_NAMER
- Subclass Secondary
- CREATE_IDR
- C LIENT_INFO
- SUBCLASS_ID
- 1000000003
- LAST_UPDATE_ID
- APP_USER_ID
- CREATE_DATETIME
- 2026-01-03
- DEFAULT_IC_TSF_PRICE
- value
- LAST_UPDATE_DATETIME
- 2026-01-03
- INCLUDE_UP_CHRG_IN_PRC_COST
- N
- MIN_UNITS_FOR_SELL_DATE_RESET
- NULL
- UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND
- N
- UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND
- N
- UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND
- N
default
- DEPTRPK
- 1005
- CLASSRPK
- 1105
- SUBCLASSRPK
- 1115
- SUB_NAMER
- Subclass Core
- CREATE_IDR
- USE RENV
- SUBCLASS_ID
- 1000000005
- LAST_UPDATE_ID
- USERENV
- CREATE_DATETIME
- 2026-01-05
- DEFAULT_IC_TSF_PRICE
- value
- LAST_UPDATE_DATETIME
- 2026-01-05
- INCLUDE_UP_CHRG_IN_PRC_COST
- N
- MIN_UNITS_FOR_SELL_DATE_RESET
- NULL
- UPD_SELL_DATE_ON_ST2ST_RECEIPT_IND
- N
- UPD_SELL_DATE_ON_WH2ST_RECEIPT_IND
- N
- UPD_SELL_DATE_ON_ST_ORD_RECEIPT_IND
- N
Rule Validation Summary
- Source Rule Count
- 49
- Governed Rule Count
- 28