Entity Order Master

DescriptionThis is an anchor entity that anchors one or more detail entities. Relationships in AWM are created between anchor entities using associative entities.

Attributes
Load Info SkLoad Info Sk
Orderable Item BkOrderable Item Bk
Order Master SkOrder Master Sk
Tenant SkTenant Sk

Primary Key
Order Master PKOrder Master PK

Dependencies
 

Reverse Dependencies
 

Attribute Details

 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Orderable Item Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Order Master Sk
DescriptionAnchor surrogate key for the Orderable Item data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Primary Key Details

 Order Master PK
Key AttributeOrder Master Sk