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