Manufacturer Id |
Base Entity | Manufacturer |
Attribute Name | Manufacturer Id |
Logical Rolename | |
ColumnName | MNFCTR_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Manufacturer Identifier: The unique code used to identify a manufacturer. |
Note |
Manufacturer Id Logical Attribute Properties |
Logical Attribute Name | Manufacturer Id |
Datatype | VARCHAR(20) |
Nullable | NO |
Manufacturer Id Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Manufacturer Id Security Types |
Name | Current Value |
Manufacturer Id Bound Attachments |
Name | Current Value |
Manufacturer Id Data Movement Rules |
Name | Type | Rule Text/Value |
Manufacturer 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 |
Manufacturer Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Name |
Base Entity | Manufacturer |
Attribute Name | Manufacturer Name |
Logical Rolename | |
ColumnName | MNFCTR_NM |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Manufacturer Name: The full name of the manufacturer. |
Note |
Manufacturer Name Logical Attribute Properties |
Logical Attribute Name | Manufacturer Name |
Datatype | VARCHAR(120) |
Nullable | NO |
Manufacturer Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Manufacturer Name Security Types |
Name | Current Value |
Manufacturer Name Bound Attachments |
Name | Current Value |
Manufacturer Name Data Movement Rules |
Name | Type | Rule Text/Value |
Manufacturer Name 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 |
Manufacturer Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Type Identifier |
Base Entity | Manufacturer |
Attribute Name | Manufacturer Type Identifier |
Logical Rolename | |
ColumnName | MNFCTR_TYPE_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Manufacturer Type Identifier Logical Attribute Properties |
Logical Attribute Name | Manufacturer Type Identifier |
Datatype | VARCHAR(20) |
Nullable | NO |
Manufacturer Type Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Manufacturer Type Identifier Security Types |
Name | Current Value |
Manufacturer Type Identifier Bound Attachments |
Name | Current Value |
Manufacturer Type Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Manufacturer Type Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Manufacturer Type Identifier |
NO | ||
BICS (Oracle) MNFCTR MNFCTR_TYPE_ID |
NO | ||
EQUIP (Oracle) MNFCTR MNFCTR_TYPE_ID |
NO |
Manufacturer Type Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Type Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Type Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Type Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Status Identifier |
Base Entity | Manufacturer |
Attribute Name | Manufacturer Status Identifier |
Logical Rolename | |
ColumnName | MNFCTR_STAT_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Manufacturer Status Identifier Logical Attribute Properties |
Logical Attribute Name | Manufacturer Status Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Manufacturer Status Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Manufacturer Status Identifier Security Types |
Name | Current Value |
Manufacturer Status Identifier Bound Attachments |
Name | Current Value |
Manufacturer Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Manufacturer Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Manufacturer Status Identifier |
NO | ||
BICS (Oracle) MNFCTR MNFCTR_STAT_ID |
NO | ||
EQUIP (Oracle) MNFCTR MNFCTR_STAT_ID |
NO |
Manufacturer Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GSA Certification Identifier |
Base Entity | Manufacturer |
Attribute Name | GSA Certification Identifier |
Logical Rolename | |
ColumnName | GSA_CERT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
GSA Certification Identifier Logical Attribute Properties |
Logical Attribute Name | GSA Certification Identifier |
Datatype | VARCHAR(50) |
Nullable | YES |
GSA Certification Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
GSA Certification Identifier Security Types |
Name | Current Value |
GSA Certification Identifier Bound Attachments |
Name | Current Value |
GSA Certification Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
GSA Certification Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer GSA Certification Identifier |
NO | ||
BICS (Oracle) MNFCTR GSA_CERT_ID |
NO | ||
EQUIP (Oracle) MNFCTR GSA_CERT_ID |
NO |
GSA Certification Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GSA Certification Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GSA Certification Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GSA Certification Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Address 1 |
Base Entity | Manufacturer |
Attribute Name | Address 1 |
Logical Rolename | |
ColumnName | ADDR_1 |
RoleName | |
Domain | Address 1 |
Logical Only | NO |
Definition | |
Note |
Address 1 Logical Attribute Properties |
Logical Attribute Name | Address 1 |
Datatype | VARCHAR(120) |
Nullable | YES |
Address 1 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Address 1 Security Types |
Name | Current Value |
Address 1 Bound Attachments |
Name | Current Value |
Address 1 Data Movement Rules |
Name | Type | Rule Text/Value |
Address 1 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Address 1 |
NO | ||
BICS (Oracle) MNFCTR ADDR_1 |
NO | ||
EQUIP (Oracle) MNFCTR ADDR_1 |
NO |
Address 1 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Address 1 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Address 1 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Address 1 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Address 2 |
Base Entity | Manufacturer |
Attribute Name | Address 2 |
Logical Rolename | |
ColumnName | ADDR_2 |
RoleName | |
Domain | Address 2 |
Logical Only | NO |
Definition | |
Note |
Address 2 Logical Attribute Properties |
Logical Attribute Name | Address 2 |
Datatype | VARCHAR(120) |
Nullable | YES |
Address 2 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Address 2 Security Types |
Name | Current Value |
Address 2 Bound Attachments |
Name | Current Value |
Address 2 Data Movement Rules |
Name | Type | Rule Text/Value |
Address 2 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Address 2 |
NO | ||
BICS (Oracle) MNFCTR ADDR_2 |
NO | ||
EQUIP (Oracle) MNFCTR ADDR_2 |
NO |
Address 2 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Address 2 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Address 2 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Address 2 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
City |
Base Entity | Manufacturer |
Attribute Name | City |
Logical Rolename | |
ColumnName | CITY |
RoleName | |
Domain | City |
Logical Only | NO |
Definition | City: |
Note |
City Logical Attribute Properties |
Logical Attribute Name | City |
Datatype | VARCHAR(75) |
Nullable | YES |
City Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
City Security Types |
Name | Current Value |
City Bound Attachments |
Name | Current Value |
City Data Movement Rules |
Name | Type | Rule Text/Value |
City Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer City |
NO | ||
BICS (Oracle) MNFCTR CITY |
NO | ||
EQUIP (Oracle) MNFCTR CITY |
NO |
City Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
City Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
City Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
City Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
State |
Base Entity | Manufacturer |
Attribute Name | State |
Logical Rolename | |
ColumnName | STATE |
RoleName | |
Domain | State |
Logical Only | NO |
Definition | State: State within the United States for America. |
Note |
State Logical Attribute Properties |
Logical Attribute Name | State |
Datatype | VARCHAR(50) |
Nullable | YES |
State Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
State Security Types |
Name | Current Value |
State Bound Attachments |
Name | Current Value |
State Data Movement Rules |
Name | Type | Rule Text/Value |
State Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer State |
NO | ||
BICS (Oracle) MNFCTR STATE |
NO | ||
EQUIP (Oracle) MNFCTR STATE |
NO |
State Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
State Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
State Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
State Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Postal Code |
Base Entity | Manufacturer |
Attribute Name | Postal Code |
Logical Rolename | |
ColumnName | POSTAL_CD |
RoleName | |
Domain | Postal Code |
Logical Only | NO |
Definition | |
Note |
Postal Code Logical Attribute Properties |
Logical Attribute Name | Postal Code |
Datatype | VARCHAR(10) |
Nullable | YES |
Postal Code Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Postal Code Security Types |
Name | Current Value |
Postal Code Bound Attachments |
Name | Current Value |
Postal Code Data Movement Rules |
Name | Type | Rule Text/Value |
Postal Code Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Postal Code |
NO | ||
BICS (Oracle) MNFCTR POSTAL_CD |
NO | ||
EQUIP (Oracle) MNFCTR POSTAL_CD |
NO |
Postal Code Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Postal Code Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Postal Code Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Postal Code Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Phone |
Base Entity | Manufacturer |
Attribute Name | Phone |
Logical Rolename | |
ColumnName | PHONE |
RoleName | |
Domain | Phone |
Logical Only | NO |
Definition | |
Note |
Phone Logical Attribute Properties |
Logical Attribute Name | Phone |
Datatype | VARCHAR(20) |
Nullable | YES |
Phone Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Phone Security Types |
Name | Current Value |
Phone Bound Attachments |
Name | Current Value |
Phone Data Movement Rules |
Name | Type | Rule Text/Value |
Phone Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Phone |
NO | ||
BICS (Oracle) MNFCTR PHONE |
NO | ||
EQUIP (Oracle) MNFCTR PHONE |
NO |
Phone Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Phone Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Phone Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Phone Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Fax Number |
Base Entity | Manufacturer |
Attribute Name | Fax Number |
Logical Rolename | |
ColumnName | FAX_NBR |
RoleName | |
Domain | Fax Number |
Logical Only | NO |
Definition | |
Note |
Fax Number Logical Attribute Properties |
Logical Attribute Name | Fax Number |
Datatype | VARCHAR(20) |
Nullable | YES |
Fax Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Fax Number Security Types |
Name | Current Value |
Fax Number Bound Attachments |
Name | Current Value |
Fax Number Data Movement Rules |
Name | Type | Rule Text/Value |
Fax Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Fax Number |
NO | ||
BICS (Oracle) MNFCTR FAX_NBR |
NO | ||
EQUIP (Oracle) MNFCTR FAX_NBR |
NO |
Fax Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Fax Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Fax Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Fax Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sales Contact Name |
Base Entity | Manufacturer |
Attribute Name | Sales Contact Name |
Logical Rolename | |
ColumnName | SALES_CONT_NM |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
Sales Contact Name Logical Attribute Properties |
Logical Attribute Name | Sales Contact Name |
Datatype | VARCHAR(120) |
Nullable | YES |
Sales Contact Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Sales Contact Name Security Types |
Name | Current Value |
Sales Contact Name Bound Attachments |
Name | Current Value |
Sales Contact Name Data Movement Rules |
Name | Type | Rule Text/Value |
Sales Contact Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Sales Contact Name |
NO | ||
BICS (Oracle) MNFCTR SALES_CONT_NM |
NO | ||
EQUIP (Oracle) MNFCTR SALES_CONT_NM |
NO |
Sales Contact Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sales Contact Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sales Contact Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sales Contact Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Technical Support Name |
Base Entity | Manufacturer |
Attribute Name | Technical Support Name |
Logical Rolename | |
ColumnName | TECH_SUPP_NM |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
Technical Support Name Logical Attribute Properties |
Logical Attribute Name | Technical Support Name |
Datatype | VARCHAR(120) |
Nullable | YES |
Technical Support Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Technical Support Name Security Types |
Name | Current Value |
Technical Support Name Bound Attachments |
Name | Current Value |
Technical Support Name Data Movement Rules |
Name | Type | Rule Text/Value |
Technical Support Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Technical Support Name |
NO | ||
BICS (Oracle) MNFCTR TECH_SUPP_NM |
NO | ||
EQUIP (Oracle) MNFCTR TECH_SUPP_NM |
NO |
Technical Support Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Technical Support Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Technical Support Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Technical Support Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Web Addr |
Base Entity | Manufacturer |
Attribute Name | Web Addr |
Logical Rolename | |
ColumnName | Web Addr |
RoleName | |
Domain | URL |
Logical Only | NO |
Definition | Website Address" The internet website address (URL) for the manufacturer. |
Note |
Web Addr Logical Attribute Properties |
Logical Attribute Name | Web Addr |
Datatype | VARCHAR(2048) |
Nullable | YES |
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 |
Buy American Documentation |
Base Entity | Manufacturer |
Attribute Name | Buy American Documentation |
Logical Rolename | |
ColumnName | BUY_AMER_DOC |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Buy American Documentation Logical Attribute Properties |
Logical Attribute Name | Buy American Documentation |
Datatype | VARBINARY/BLOB(50) |
Nullable | YES |
Buy American Documentation Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Buy American Documentation Security Types |
Name | Current Value |
Buy American Documentation Bound Attachments |
Name | Current Value |
Buy American Documentation Data Movement Rules |
Name | Type | Rule Text/Value |
Buy American Documentation Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Buy American Documentation |
NO | ||
BICS (Oracle) MNFCTR BUY_AMER_DOC |
NO | ||
EQUIP (Oracle) MNFCTR BUY_AMER_DOC |
NO |
Buy American Documentation Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Buy American Documentation Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Buy American Documentation Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Buy American Documentation Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Justification Documentation |
Base Entity | Manufacturer |
Attribute Name | Justification Documentation |
Logical Rolename | |
ColumnName | JUST_DOC |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Justification Documentation Logical Attribute Properties |
Logical Attribute Name | Justification Documentation |
Datatype | VARBINARY/BLOB(50) |
Nullable | YES |
Justification Documentation Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Justification Documentation Security Types |
Name | Current Value |
Justification Documentation Bound Attachments |
Name | Current Value |
Justification Documentation Data Movement Rules |
Name | Type | Rule Text/Value |
Justification Documentation Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Manufacturer Justification Documentation |
NO | ||
BICS (Oracle) MNFCTR JUST_DOC |
NO | ||
EQUIP (Oracle) MNFCTR JUST_DOC |
NO |
Justification Documentation Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Justification Documentation Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Justification Documentation Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Justification Documentation Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |