Code Detail
In ScopeTechnical: CODE_DETAIL | ID: OR-CFG-CODE_DETAIL-CODE_DETAIL
This table will contain code and decoded descriptions for each code type as defined in the CODE_HEAD table.
See how this object fits into Configuration
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Information Type
- Configuration
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- CODE_DETAIL
Field Definitions(5)
Rules & Considerations(25)
constraint
validation
Sample Load Data(4)
| _scenario | CODERPK | CODE_SEQR | CODE_DESCR | CODE_TYPERPK | REQUIRED_INDR | ID | REQUIRED | SEQUENCE | USED_IND | DESCRIPTION | CUSTOMER_INSERTED_IND | CUSTOMER_MODIFIED_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | SAMP | S | 1 | Y | 1 | S | SAMPLE | S | S |
| default | Code D | 3 | Code Detail-002-ALT | Code | C | — | — | — | Y | — | N | N |
| default | Code D | 5 | Code Detail-003-EDGE | Code | C | — | — | — | Y | — | N | N |
Example values from field definitions
- CODERPK
- SAMPLE
- CODE_SEQR
- 1
- CODE_DESCR
- SAMPLE
- CODE_TYPERPK
- SAMP
- REQUIRED_INDR
- S
- ID
- 1
- REQUIRED
- Y
- SEQUENCE
- 1
- USED_IND
- S
- DESCRIPTION
- SAMPLE
- CUSTOMER_INSERTED_IND
- S
- CUSTOMER_MODIFIED_IND
- S
default
- CODERPK
- Code D
- CODE_SEQR
- 3
- CODE_DESCR
- Code Detail-002-ALT
- CODE_TYPERPK
- Code
- REQUIRED_INDR
- C
- ID
- —
- REQUIRED
- —
- SEQUENCE
- —
- USED_IND
- Y
- DESCRIPTION
- —
- CUSTOMER_INSERTED_IND
- N
- CUSTOMER_MODIFIED_IND
- N
default
- CODERPK
- Code D
- CODE_SEQR
- 5
- CODE_DESCR
- Code Detail-003-EDGE
- CODE_TYPERPK
- Code
- REQUIRED_INDR
- C
- ID
- —
- REQUIRED
- —
- SEQUENCE
- —
- USED_IND
- Y
- DESCRIPTION
- —
- CUSTOMER_INSERTED_IND
- N
- CUSTOMER_MODIFIED_IND
- N
Rule Validation Summary
- Source Rule Count
- 50
- Governed Rule Count
- 25