Subclass
In ScopeTechnical: SUBCLASS | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- SUBCLASS
Field Definitions(15)
Rules & Considerations(22)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 1101 | 1111 | Subclass Primary | USERENV | 1000000001 | RETAIL_CTX | 2026-01-01 | 2026-01-01 | N | value | NULL | N | N | N |
default
- DEPTRPK
- 1001
- CLASSR
- 1101
- SUBCLASSR
- 1111
- SUB_NAMER
- Subclass Primary
- CREATE_IDR
- USERENV
- SUBCLASS_IDR
- 1000000001
- LAST_UPDATE_IDR
- RETAIL_CTX
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- INCLUDE_UP_CHRG_IN_PRC_COSTR
- N
- DEFAULT_IC_TSF_PRICE
- value
- 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