Employee.PK_EMPLOYEE Index Columns

ColumnName	Sort Order
Badge Number

Employee.PK_EMPLOYEE Bound Attachments

Name	Current Value

Employee Storage Location Association.PK_EMP_STOR_LOC_ASSC Index Columns

ColumnName	Sort Order
Storage Identifier
Badge Number

Employee Storage Location Association.PK_EMP_STOR_LOC_ASSC Bound Attachments

Name	Current Value

Inventory Control Activity.PK_INVT_CTRL_ACT Index Columns

ColumnName	Sort Order
Activity Identifier

Inventory Control Activity.PK_INVT_CTRL_ACT Bound Attachments

Name	Current Value

Inventory Control Area.PK_INVT_CTRL_AREA Index Columns

ColumnName	Sort Order
ControlArea Identifier

Inventory Control Area.PK_INVT_CTRL_AREA Bound Attachments

Name	Current Value

Inventory Control Area.fk_invt_ctrl_area_to_stor_loc Index Columns

ColumnName	Sort Order
Storage Identifier

Inventory Control Area.fk_invt_ctrl_area_to_stor_loc Bound Attachments

Name	Current Value

Inventory Control Area.fk_invt_ctrl_area_to_nssd_room Index Columns

ColumnName	Sort Order
Building
Room

Inventory Control Area.fk_invt_ctrl_area_to_nssd_room Bound Attachments

Name	Current Value

Inventory Control Area Subarea.PK_CTRL_AREA_SUBAREA Index Columns

ColumnName	Sort Order
ControlArea Identifier
SubArea Identifier

Inventory Control Area Subarea.PK_CTRL_AREA_SUBAREA Bound Attachments

Name	Current Value

Inventory Control Area Subarea.fk_icas_to_ctrl_area Index Columns

ColumnName	Sort Order
ControlArea Identifier

Inventory Control Area Subarea.fk_icas_to_ctrl_area Bound Attachments

Name	Current Value

Inventory Control Group.PK_INVT_CTRL_GRP Index Columns

ColumnName	Sort Order
Group Identifier

Inventory Control Group.PK_INVT_CTRL_GRP Bound Attachments

Name	Current Value

Inventory Control Infor Item.PK_INVT_CTRL_INFOR_ITEM Index Columns

ColumnName	Sort Order
Item Identifier

Inventory Control Infor Item.PK_INVT_CTRL_INFOR_ITEM Bound Attachments

Name	Current Value

Inventory Control Item.PK_INVT_CTRL_ITEM Index Columns

ColumnName	Sort Order
Item Identifier

Inventory Control Item.PK_INVT_CTRL_ITEM Bound Attachments

Name	Current Value

Inventory Control Item.fk_ici_to_invt_ctrl_item Index Columns

ColumnName	Sort Order
Parent Item Identifier

Inventory Control Item.fk_ici_to_invt_ctrl_item Bound Attachments

Name	Current Value

Inventory Control Item.fk_invt_ctrl_item_to_type Index Columns

ColumnName	Sort Order
Inventory Type Identifier

Inventory Control Item.fk_invt_ctrl_item_to_type Bound Attachments

Name	Current Value

Inventory Control Item.fk_invt_ctrl_item_to_status Index Columns

ColumnName	Sort Order
Status Identifier

Inventory Control Item.fk_invt_ctrl_item_to_status Bound Attachments

Name	Current Value

Inventory Control Item.fk_invt_ctrl_item_to_icas Index Columns

ColumnName	Sort Order
ControlArea Identifier
SubArea Identifier

Inventory Control Item.fk_invt_ctrl_item_to_icas Bound Attachments

Name	Current Value

Inventory Control Item.fk_invt_ctrl_item_to_ica Index Columns

ColumnName	Sort Order
ControlArea Identifier

Inventory Control Item.fk_invt_ctrl_item_to_ica Bound Attachments

Name	Current Value

Inventory Control Item.fk_invt_ctrl_item_to_icg Index Columns

ColumnName	Sort Order
Group Identifier

Inventory Control Item.fk_invt_ctrl_item_to_icg Bound Attachments

Name	Current Value

Inventory Control Item Verification.PK_INVT_CTRL_ITEM_VERIF Index Columns

ColumnName	Sort Order
Item Identifier
Creat Date

Inventory Control Item Verification.PK_INVT_CTRL_ITEM_VERIF Bound Attachments

Name	Current Value

Inventory Control Item Verification.fk_invt_ctrl_item_verf_to_ici Index Columns

ColumnName	Sort Order
Item Identifier

Inventory Control Item Verification.fk_invt_ctrl_item_verf_to_ici Bound Attachments

Name	Current Value

Inventory Control Item Verification.fk_invt_ctrl_item_verf_to_emp Index Columns

ColumnName	Sort Order
Badge Number

Inventory Control Item Verification.fk_invt_ctrl_item_verf_to_emp Bound Attachments

Name	Current Value

Inventory Control Log.PK_INVT_CTRL_LOG Index Columns

ColumnName	Sort Order
Item Identifier
Activity Identifier
Current Date

Inventory Control Log.PK_INVT_CTRL_LOG Bound Attachments

Name	Current Value

Inventory Control Log.FK_SMPL_LOG_TO_INCT_CTRL_ACT Index Columns

ColumnName	Sort Order
Activity Identifier

Inventory Control Log.FK_SMPL_LOG_TO_INCT_CTRL_ACT Bound Attachments

Name	Current Value

Inventory Control Log.FK_SMPL_LOG_TO_INVT_CTRL_ITEM Index Columns

ColumnName	Sort Order
Item Identifier

Inventory Control Log.FK_SMPL_LOG_TO_INVT_CTRL_ITEM Bound Attachments

Name	Current Value

Inventory Control Role.PK_INVT_CTRL_ROLE Index Columns

ColumnName	Sort Order
Role Identifer

Inventory Control Role.PK_INVT_CTRL_ROLE Bound Attachments

Name	Current Value

Inventory Control Role Association.PK_INVT_CTRL_ROLE_ASSC Index Columns

ColumnName	Sort Order
Role Identifer
Bn

Inventory Control Role Association.PK_INVT_CTRL_ROLE_ASSC Bound Attachments

Name	Current Value

Inventory Control Role Association.fk_invt_ctrl_role_assc_to_icr Index Columns

ColumnName	Sort Order
Role Identifer

Inventory Control Role Association.fk_invt_ctrl_role_assc_to_icr Bound Attachments

Name	Current Value

Inventory Control Status.PK_INVT_CTRL_STAT Index Columns

ColumnName	Sort Order
Status Identifier

Inventory Control Status.PK_INVT_CTRL_STAT Bound Attachments

Name	Current Value

Inventory Control Transfer.PK_INVT_CTRL_TRANS Index Columns

ColumnName	Sort Order
Item Identifier
Current Date
To Badge Number

Inventory Control Transfer.PK_INVT_CTRL_TRANS Bound Attachments

Name	Current Value

Inventory Control Type.PK_INVT_CTRL_TYPE Index Columns

ColumnName	Sort Order
Inventory Type Identifier

Inventory Control Type.PK_INVT_CTRL_TYPE Bound Attachments

Name	Current Value

Inventory Item Attachment.PK_INVT_ITEM_ATTACH Index Columns

ColumnName	Sort Order
Attachment Identifier

Inventory Item Attachment.PK_INVT_ITEM_ATTACH Bound Attachments

Name	Current Value

Inventory Item Attachment Association.PK_INVT_ITEM_ATTACH_ASSC Index Columns

ColumnName	Sort Order
Item Identifier
Attachment Identifier

Inventory Item Attachment Association.PK_INVT_ITEM_ATTACH_ASSC Bound Attachments

Name	Current Value

Inventory Item Attachment Association.FK_IIA_ASSC_TO_ICI Index Columns

ColumnName	Sort Order
Item Identifier

Inventory Item Attachment Association.FK_IIA_ASSC_TO_ICI Bound Attachments

Name	Current Value

Inventory Item Attachment Association.fk_invt_item_attach_to_iiaa Index Columns

ColumnName	Sort Order
Attachment Identifier

Inventory Item Attachment Association.fk_invt_item_attach_to_iiaa Bound Attachments

Name	Current Value

Neutron Scattering Science Directorate Room.PK_NSSD_ROOM Index Columns

ColumnName	Sort Order
Building
Room

Neutron Scattering Science Directorate Room.PK_NSSD_ROOM Bound Attachments

Name	Current Value

Purchase Order.PK_PO Index Columns

ColumnName	Sort Order
Purchase Order Number
Purchase Order Item Number

Purchase Order.PK_PO Bound Attachments

Name	Current Value

Purchase Order History.PK_PO_HIST Index Columns

ColumnName	Sort Order
Purchase Order Item Number
Purchase Order Number
Current Date

Purchase Order History.PK_PO_HIST Bound Attachments

Name	Current Value

Storage Location.PK_STOR_LOC Index Columns

ColumnName	Sort Order
Storage Identifier

Storage Location.PK_STOR_LOC Bound Attachments

Name	Current Value