Business Data Model Data Model

Entity

Entity Purchase Order Line

Description

A request for the supply of a specific item usually specifying quantity, packaging and price.

Attributes
Availability Confirmed Ind
Currency
Emergency Purchase Ind
Item Num
Line Num
On Contract Ind
Order Descr
Ordered Qty
Ordered Quantity Unit Of Measure
Product Cleansing Status
Requested Ts
Requested Unit Price Amt
Verified Unit Price Amt

Relationship
Contains
is Manufacturer
Purchase Order Line_Organization_FK
Purchase Order Line_Item Master_FK
Purchase Order Line_Purchase Contract_FK
Purchase Order Line_Money Item_FK
order ship to

Dependencies
NONE

Reverse Dependencies

Attribute Details

Availability Confirmed Ind

Description	Indicates whether the availability of the requested quantity was confirmed at the time of order or not.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
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

Emergency Purchase Ind

Description	Indicates whether this item is ordered for a patient or business emergency.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
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

Line Num

Description	Indicates a unique number for each line within the invoice.
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

On Contract Ind

Description	Indicates whether the order is made within the context of a Purchase Contract between the Purchaser and the Supplier.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Order Descr

Description	Indicates the Ordering Organization's description of the ordered product.
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

Ordered Qty

Description	Indicates the quantity of the product being ordered.
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

Ordered Quantity Unit Of Measure

Description	Indicates the unit of measure for the ordered amount. For example: Case Pallet Gallons Drums Liters
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

Product Cleansing Status

Description	The current cleansing status for product data on the Purchase Order Line record. For example: PCLN - Cleansed/Product Id Number found. SCLN - Cleansed/PIN found by Third-party Supply Line SBSL - Submitted for cleansing UNCL - Uncleansable as identified by the PO processing.
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

Requested Ts

Description	The date and time upon which the item is requested to be delivered.
Data Type	Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requested Unit Price Amt

Description	Indicates the unit price recorded for the product.
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

Verified Unit Price Amt

Description	Indicates the price verified by the contract validation system.
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

Contains

Is Identifying Relationship	false
Child Table	Purchase Order Line
Child Role Name	is part of
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 Order
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

is Manufacturer

Is Identifying Relationship	false
Child Table	Purchase Order Line
Child Role Name	is manufacturer
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	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Purchase Order Line_Organization_FK

Is Identifying Relationship	false
Child Table	Purchase Order Line
Child Role Name	is distributor
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	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Purchase Order Line_Item Master_FK

Is Identifying Relationship	false
Child Table	Purchase Order Line
Child Role Name	is ordered 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	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Purchase Order Line_Purchase Contract_FK

Is Identifying Relationship	false
Child Table	Purchase Order Line
Child Role Name	is controlled by
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	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Purchase Order Line_Money Item_FK

Is Identifying Relationship	false
Child Table	Purchase Order Line
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	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

order ship to

Is Identifying Relationship	false
Child Table	Purchase Order Line
Child Role Name	order ship to
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	Address
Parent Multiplicity	ZERO_TO_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