Cab Id |
Base Entity | Part Cab Dr Bin |
Attribute Name | Cab Id |
Logical Rolename | |
ColumnName | CAB_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Cabinet Identifer: A unique identiefer for the cabinet made up of the equipment category and a number. |
Note |
Cab Id Logical Attribute Properties |
Logical Attribute Name | Cab Id |
Datatype | VARCHAR(12) |
Nullable | NO |
Cab Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Cab Id Security Types |
Name | Current Value |
Cab Id Bound Attachments |
Name | Current Value |
Cab Id Data Movement Rules |
Name | Type | Rule Text/Value |
Cab Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Cab Dr Bin Cab Id |
NO | ||
PART (Oracle) PART_CAB_DR_BIN CAB_ID |
NO |
Cab Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Cab Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Cab Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Cab Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Dr Id |
Base Entity | Part Cab Dr Bin |
Attribute Name | Dr Id |
Logical Rolename | |
ColumnName | DR_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Drawer Identifier: A unique identifier for a drawer or tray in a cabinet. |
Note |
Dr Id Logical Attribute Properties |
Logical Attribute Name | Dr Id |
Datatype | VARCHAR(5) |
Nullable | NO |
Dr Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Dr Id Security Types |
Name | Current Value |
Dr Id Bound Attachments |
Name | Current Value |
Dr Id Data Movement Rules |
Name | Type | Rule Text/Value |
Dr Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Cab Dr Bin Dr Id |
NO | ||
PART (Oracle) PART_CAB_DR_BIN DR_ID |
NO |
Dr Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Dr Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Dr Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Dr Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Bin Id |
Base Entity | Part Cab Dr Bin |
Attribute Name | Bin Id |
Logical Rolename | |
ColumnName | BIN_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Bin Identifer: Identifer for a unique bin within a drawer. |
Note |
Bin Id Logical Attribute Properties |
Logical Attribute Name | Bin Id |
Datatype | VARCHAR(5) |
Nullable | NO |
Bin Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Bin Id Security Types |
Name | Current Value |
Bin Id Bound Attachments |
Name | Current Value |
Bin Id Data Movement Rules |
Name | Type | Rule Text/Value |
Bin Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Cab Dr Bin Bin Id |
NO | ||
PART (Oracle) PART_CAB_DR_BIN BIN_ID |
NO |
Bin Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Bin Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Bin Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Bin Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Part Id |
Base Entity | Part Cab Dr Bin |
Attribute Name | Part Id |
Logical Rolename | |
ColumnName | PART_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Part Identifier: Abbreviated identifer for a part. |
Note |
Part Id Logical Attribute Properties |
Logical Attribute Name | Part Id |
Datatype | VARCHAR(25) |
Nullable | YES |
Part Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Part Id Security Types |
Name | Current Value |
Part Id Bound Attachments |
Name | Current Value |
Part Id Data Movement Rules |
Name | Type | Rule Text/Value |
Part Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Cab Dr Bin Part Id |
NO | ||
PART (Oracle) PART_CAB_DR_BIN PART_ID |
NO |
Part Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Part Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Part Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Part Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |