Entity Order Master Identifier

DescriptionA list of identifiers that are used to uniquely identify any item within the order master.

For example:
Bar code
Inventory Number
Manufacturer Catalog Number
Distributor Catalog Number
Formulary Id
Compound Id

Attributes
Order Master IdentifierOrder Master Identifier
Order Master Identifier Configuration CodeOrder Master Identifier Configuration Code
Order Master Identifier TypeOrder Master Identifier Type

Relationship
Order Master Identifier_Order Master_FKOrder Master Identifier_Order Master_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Order Master Identifier
DescriptionAlphanumeric identifier of the orderable item.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Master Identifier Configuration Code
DescriptionIndicates how the identifier is formatted.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Master Identifier Type
DescriptionIndicates the type of the orderable item identifier.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Order Master Identifier_Order Master_FK
Is Identifying Relationshiptrue
Child TableOrder Master Identifier
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrder Master
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE