MNFCTR_ID |
Base Object | MNFCTR |
Attribute Name | Mnfctr Id |
ColumnName | MNFCTR_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Manufacturer Identifier: The unique code used to identify a manufacturer. |
Note |
MNFCTR_ID Column Properties |
Datatype | NUMBER(4, 0) |
Nullable | NO |
MNFCTR_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
MNFCTR_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MNFCTR_ID Security Types |
Name | Current Value |
MNFCTR_ID Bound Attachments |
Name | Current Value |
MNFCTR_ID Data Movement Rules |
Name | Type | Rule Text/Value |
MNFCTR_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Manufacturer Id |
NO | ||
BICS (Oracle) MNFCTR MNFCTR_ID |
NO | ||
EQUIP (Oracle) MNFCTR MNFCTR_ID |
NO |
MNFCTR_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_NM |
Base Object | MNFCTR |
Attribute Name | Mnfctr Nm |
ColumnName | MNFCTR_NM |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Manufacturer Name: The full name of the manufacturer. |
Note |
MNFCTR_NM Column Properties |
Datatype | VARCHAR2(120) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
MNFCTR_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
MNFCTR_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MNFCTR_NM Security Types |
Name | Current Value |
MNFCTR_NM Bound Attachments |
Name | Current Value |
MNFCTR_NM Data Movement Rules |
Name | Type | Rule Text/Value |
MNFCTR_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Manufacturer Name |
NO | ||
BICS (Oracle) MNFCTR MNFCTR_NM |
NO | ||
EQUIP (Oracle) MNFCTR MNFCTR_NM |
NO |
MNFCTR_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MNFCTR_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
WEB_ADDR |
Base Object | MNFCTR |
Attribute Name | Web Addr |
ColumnName | WEB_ADDR |
Logical Rolename | |
RoleName | |
Domain | URL |
Physical Only | NO |
Definition | Website Address" The internet website address (URL) for the manufacturer. |
Note |
WEB_ADDR Column Properties |
Datatype | VARCHAR2(2048) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
WEB_ADDR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
WEB_ADDR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WEB_ADDR Security Types |
Name | Current Value |
WEB_ADDR Bound Attachments |
Name | Current Value |
WEB_ADDR Data Movement Rules |
Name | Type | Rule Text/Value |
WEB_ADDR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Web Addr |
NO | ||
BICS (Oracle) MNFCTR WEB_ADDR |
NO | ||
EQUIP (Oracle) MNFCTR WEB_ADDR |
NO |
WEB_ADDR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WEB_ADDR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WEB_ADDR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WEB_ADDR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |