Entity Contract Tier Item Price

DescriptionThe pricing of a specific item on a purchase contract tier.

Attributes
Pricing MethodPricing Method

Relationship
Offered Price_Product Master_FKOffered Price_Product Master_FK
Contract Tier Item Price_Purchase Contract Tier_FKContract Tier Item Price_Purchase Contract Tier_FK
Contract Tier Item Price_Organization_FKContract Tier Item Price_Organization_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Pricing Method
DescriptionIndicates the type of pricing method employed.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Offered Price_Product Master_FK
Is Identifying Relationshiptrue
Child TableContract Tier Item Price
Child Role Nameis priced by
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableItem Master
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Contract Tier Item Price_Purchase Contract Tier_FK
Is Identifying Relationshipfalse
Child TableContract Tier Item Price
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePurchase Contract Tier
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Contract Tier Item Price_Organization_FK
Is Identifying Relationshipfalse
Child TableContract Tier Item Price
Child Role Nameis alliance member-specific item
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrganization
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE