Cab Id |
Base Entity | Part Loc Assoc |
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 | YES |
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 Loc Assoc 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 |
Qty |
Base Entity | Part Loc Assoc |
Attribute Name | Qty |
Logical Rolename | |
ColumnName | Qty |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Qty Logical Attribute Properties |
Logical Attribute Name | Qty |
Datatype | NUMERIC(4, 0) |
Nullable | YES |
Qty Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Qty Security Types |
Name | Current Value |
Qty Bound Attachments |
Name | Current Value |
Qty Data Movement Rules |
Name | Type | Rule Text/Value |
Qty Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Loc Assoc Qty |
NO |
Qty Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Qty Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Qty Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Qty Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Dr Id |
Base Entity | Part Loc Assoc |
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 | YES |
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 Loc Assoc 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 |
Part Id |
Base Entity | Part Loc Assoc |
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 Loc Assoc 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 |
Sec Id |
Base Entity | Part Loc Assoc |
Attribute Name | Sec Id |
Logical Rolename | |
ColumnName | SEC_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Section Identifer: Defines the sections in a bin. |
Note |
Sec Id Logical Attribute Properties |
Logical Attribute Name | Sec Id |
Datatype | VARCHAR(5) |
Nullable | NO |
Sec Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Sec Id Security Types |
Name | Current Value |
Sec Id Bound Attachments |
Name | Current Value |
Sec Id Data Movement Rules |
Name | Type | Rule Text/Value |
Sec Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Loc Assoc Sec Id |
NO |
Sec Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sec Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sec Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sec Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Bin Id |
Base Entity | Part Loc Assoc |
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 Loc Assoc 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 |