One Row For Each Class
In ScopeTechnical: CLASS | ID: OR-FND-CLASS-CLASS
Stores one row for each class within the company. Whenever a class name is used by Oracle Retail, or a class is validated, it is always selected from this 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
- CLASS
Field Definitions(5)
Rules & Considerations(20)
validation
constraint
Sample Load Data(4)
| _scenario | DEPTRPK | CLASSRPK | CREATE_IDR | CLASS_NAMER | CLASS_VAT_INDR | CLASS_ID | LAST_UPDATE_ID | CREATE_DATETIME | LAST_UPDATE_DATETIME | INVENTORY_LAYER_IDENTIFIER_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | S | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE |
| default | 1002 | 1102 | MDM_USER | Womenswear | N | 1000000003 | MDM_USER | 2026-01-03 | 2026-01-03 | E |
| default | 1003 | 1103 | BATCH_USER | Kidswear | Y | 1000000005 | BATCH_USER | 2026-01-05 | 2026-01-05 | S |
Example values from field definitions
- DEPTRPK
- 1
- CLASSRPK
- 1
- CREATE_IDR
- SAMPLE
- CLASS_NAMER
- SAMPLE
- CLASS_VAT_INDR
- S
- CLASS_ID
- 1
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
- INVENTORY_LAYER_IDENTIFIER_TYPE
- SAMPLE
default
- DEPTRPK
- 1002
- CLASSRPK
- 1102
- CREATE_IDR
- MDM_USER
- CLASS_NAMER
- Womenswear
- CLASS_VAT_INDR
- N
- CLASS_ID
- 1000000003
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
- INVENTORY_LAYER_IDENTIFIER_TYPE
- E
default
- DEPTRPK
- 1003
- CLASSRPK
- 1103
- CREATE_IDR
- BATCH_USER
- CLASS_NAMER
- Kidswear
- CLASS_VAT_INDR
- Y
- CLASS_ID
- 1000000005
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
- INVENTORY_LAYER_IDENTIFIER_TYPE
- S
Rule Validation Summary
- Source Rule Count
- 38
- Governed Rule Count
- 20