Overview Top Package Entity

Business Data Model Data Model

---

Entity Vendor Rebate

Description

A monetary discount that a seller retrospectively pays to a purchaser.

Attributes

Check Num

Currency

Item Descr

Item Num

Purchase Qty

Purchase Quantity Unit Of Measure

Rebate Amt

Rebate Payment Date

Rebate Period End Date

Rebate Period Start Date

Unit Price Amt

Relationship

Vendor Rebate_Organization_FK1

Vendor Rebate_Purchase Contract_FK

Vendor Rebate_Item Master_FK

Vendor Rebate_Money Item_FK

Vendor Rebate_Organization_FK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 Check Num

Description	A reference number identifying the bank check used for payment.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Currency

Description	The currency that is used as the basis for all monetary amounts.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Item Descr

Description	The description of the item as reported by the supplier.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Item Num

Description	Indicates the number used by the supplier to identify an item.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Purchase Qty

Description	Indicates the quantity of the purchased item.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Purchase Quantity Unit Of Measure

Description	Indicates the unit of measure for the purchase quantity.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Rebate Amt

Description	Indicates the amount being rebated by vendor.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Rebate Payment Date

Description	The date upon which a deduction from an amount is paid by a vendor.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Rebate Period End Date

Description	The data upon which the rebate period ends.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Rebate Period Start Date

Description	The date upon which the rebate period commenced.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Unit Price Amt

Description	Indicates the unit price of the item as reported by the Supplier.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

 Vendor Rebate_Organization_FK1

Is Identifying Relationship	false
Child Table	Vendor Rebate
Child Role Name	is alliance member receiving
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Organization
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Vendor Rebate_Purchase Contract_FK

Is Identifying Relationship	false
Child Table	Vendor Rebate
Child Role Name	can have
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Purchase Contract
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Vendor Rebate_Item Master_FK

Is Identifying Relationship	false
Child Table	Vendor Rebate
Child Role Name	is rebate item
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Item Master
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Vendor Rebate_Money Item_FK

Is Identifying Relationship	false
Child Table	Vendor Rebate
Child Role Name	is amount(s) for
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Money Item
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Vendor Rebate_Organization_FK

Description	Amount being rebated by vendor to receiving alliance member.
Is Identifying Relationship	false
Child Table	Vendor Rebate
Child Role Name	is vendor giving
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Organization
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

Overview Top Package Entity

Business Data Model Data Model