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 
Yes 
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