Distributor Identifer |
Base Entity | Distributor |
Attribute Name | Distributor Identifer |
Logical Rolename | |
ColumnName | DISTR_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Manufacturer Identifier: The unique code used to identify a manufacturer. |
Note |
Distributor Identifer Logical Attribute Properties |
Logical Attribute Name | Distributor Identifer |
Datatype | VARCHAR(20) |
Nullable | NO |
Distributor Identifer Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Distributor Identifer Security Types |
Name | Current Value |
Distributor Identifer Bound Attachments |
Name | Current Value |
Distributor Identifer Data Movement Rules |
Name | Type | Rule Text/Value |
Distributor Identifer Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Distributor Distributor Identifer |
NO | ||
BICS (Oracle) DISTR DISTR_ID |
NO |
Distributor Identifer Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Identifer Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Identifer Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Identifer Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Name |
Base Entity | Distributor |
Attribute Name | Distributor Name |
Logical Rolename | |
ColumnName | DISTR_NM |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Manufacturer Name: The full name of the manufacturer. |
Note |
Distributor Name Logical Attribute Properties |
Logical Attribute Name | Distributor Name |
Datatype | VARCHAR(120) |
Nullable | NO |
Distributor Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Distributor Name Security Types |
Name | Current Value |
Distributor Name Bound Attachments |
Name | Current Value |
Distributor Name Data Movement Rules |
Name | Type | Rule Text/Value |
Distributor Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Distributor Distributor Name |
NO | ||
BICS (Oracle) DISTR DISTR_NM |
NO |
Distributor Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Type Identifier |
Base Entity | Distributor |
Attribute Name | Distributor Type Identifier |
Logical Rolename | |
ColumnName | DISTR_TYPE_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Distributor Type Identifier Logical Attribute Properties |
Logical Attribute Name | Distributor Type Identifier |
Datatype | VARCHAR(20) |
Nullable | NO |
Distributor Type Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Distributor Type Identifier Security Types |
Name | Current Value |
Distributor Type Identifier Bound Attachments |
Name | Current Value |
Distributor Type Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Distributor Type Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Distributor Distributor Type Identifier |
NO | ||
BICS (Oracle) DISTR DISTR_TYPE_ID |
NO |
Distributor Type Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Type Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Type Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Type Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Status Identifier |
Base Entity | Distributor |
Attribute Name | Distributor Status Identifier |
Logical Rolename | |
ColumnName | DISTR_STAT_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Distributor Status Identifier Logical Attribute Properties |
Logical Attribute Name | Distributor Status Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Distributor Status Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Distributor Status Identifier Security Types |
Name | Current Value |
Distributor Status Identifier Bound Attachments |
Name | Current Value |
Distributor Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Distributor Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Distributor Distributor Status Identifier |
NO | ||
BICS (Oracle) DISTR DISTR_STAT_ID |
NO |
Distributor Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Distributor Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GSA Certification Identifier |
Base Entity | Distributor |
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 Distributor GSA Certification Identifier |
NO | ||
BICS (Oracle) DISTR 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 |
ISO 9000 Indicator |
Base Entity | Distributor |
Attribute Name | ISO 9000 Indicator |
Logical Rolename | |
ColumnName | ISO_9000_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
ISO 9000 Indicator Logical Attribute Properties |
Logical Attribute Name | ISO 9000 Indicator |
Datatype | CHAR(1) |
Nullable | NO |
ISO 9000 Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
ISO 9000 Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
ISO 9000 Indicator Security Types |
Name | Current Value |
ISO 9000 Indicator Bound Attachments |
Name | Current Value |
ISO 9000 Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
ISO 9000 Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Distributor ISO 9000 Indicator |
NO | ||
BICS (Oracle) DISTR ISO_9000_IND |
NO |
ISO 9000 Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ISO 9000 Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ISO 9000 Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ISO 9000 Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Address 1 |
Base Entity | Distributor |
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 Distributor Address 1 |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor Address 2 |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor City |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor State |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor Postal Code |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor Phone |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor Fax Number |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor Sales Contact Name |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor Technical Support Name |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor Web Addr |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor Buy American Documentation |
NO | ||
BICS (Oracle) DISTR 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 | Distributor |
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 Distributor Justification Documentation |
NO | ||
BICS (Oracle) DISTR 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 |