CurrencyPurchase Order DatePurchase Order NumPurchase Order Release NumPurchase Order TypeTotal Cost Amt
| Business Data Model Data Model |
| Description | A request for the supply of materials item comprising one or more individual purchase order lines. |
| Attributes | |
| Currency |
|
| Purchase Order Date |
|
| Purchase Order Num |
|
| Purchase Order Release Num |
|
| Purchase Order Type |
|
| Total Cost Amt |
|
| Relationship | |
 is provider |
|
| is Purchaser |
|
| is Cost Center |
|
| Purchase Order_Organization_FK |
|
| Purchase Order_Money Item_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
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 |
Purchase Order Date
| Description | The date upon which the purchase item was ordered from the supplier. |
| 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 |
Purchase Order Num
| Description | A unique identifying value assigned to the order request issued by the ordering organization. |
| 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 Order Release Num
| Description | Used to track "Releases on Blanket and Standing Orders". Value is based on Number of releases allowed and used |
| 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 Order Type
| Description | Indicates the type of Purchase Order. For example: Repeat Order Regular Order Emergency Order |
| 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 |
Total Cost Amt
| Description | Indicates the sum of the total line cost for all of the purchase order Lines for this Purchase Order. |
| 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 |
is provider
| Is Identifying Relationship | false |
| Child Table | Purchase Order |
| Child Role Name | is provider |
| 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 |
is Purchaser
| Is Identifying Relationship | false |
| Child Table | Purchase Order |
| Child Role Name | is ordering party |
| 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 | Party |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
is Cost Center
| Is Identifying Relationship | false |
| Child Table | Purchase Order |
| Child Role Name | is cost center |
| 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 |
Purchase Order_Organization_FK
| Is Identifying Relationship | false |
| Child Table | Purchase Order |
| Child Role Name | is alliance member 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 | Organization |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Purchase Order_Money Item_FK
| Is Identifying Relationship | false |
| Child Table | Purchase Order |
| 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 |
| Business Data Model Data Model |