Atomic Warehouse Model Data Model

Entity

Entity Invoice Line Detail

Description

A request for payment for an individual item that is included on a bill (invoice) that is issued by a vendor to a purchaser.

Attributes
Administration Fee Amt
Assessed Impact Code Sk
Currency Code Sk
Delivery Dt
Delivery Variance Reason Code Sk
Direct Ind
Distributor Contract Nm
Distributor Contract Num
Effective From Dt
Effective To Dt
Emergency Purchase Ind
Extended Price Amt
Invoice Fulfillment Reason Code Sk
Invoice Line Period Num
Invoice Line Sk
Item Descr
Item Num
Line Num
Load Info Sk
Mfg Contract Nm
Mfg Contract Num
Order Dt
Purchase Qty
Purchase Type Code Sk
Purchase UOM Code Sk
Rx Ind
Shipped Qty
Source Code Sk
Tenant Sk
Type Code Sk
Unit Price Amt
Valid From Ts
Valid To Ts

Relationship
Invoice Line Detail_Invoice Line_FK

Primary Key
Invoice Line Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Administration Fee Amt

Description	Indicates the amount paid by a supplier either per transaction item sold (invoiced item) or per product item if the invoice line is by 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

Assessed Impact Code Sk

Description	Indicates the nature of disruption to delivery of health care service or running of the purchaser's business due to delivery variance of the item.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Currency Code Sk

Description	The currency used as the basis for all monetary amounts
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Delivery Dt

Description	The delivery date represents the date upon which the ordered item was received by the purchaser.
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

Delivery Variance Reason Code Sk

Description	Indicates the reason for a variance in the delivered item. For example: The delivered item is not equal to the ordered quantity. The delivered item is not the same as the item ordered.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Direct Ind

Description	Indicates whether the item is directly invoiced from a manufacturer 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

Distributor Contract Nm

Description	Indicates the distributor contract name.
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

Distributor Contract Num

Description	Indicates the contract number created by distributors.When some distributors receive the price file from the manufacturer, they may create their own contract IDs to track the pricing. A distributor does this because two different manufacturers may submit a price file with the same contract ID.
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

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
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

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

Extended Price Amt

Description	Indicates the price amount of the purchased quantity,that is ,price per unit x total quantity purchased.
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

Invoice Fulfillment Reason Code Sk

Description	Indicates the reason for order fulfillment.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Invoice Line Period Num

Description	Indicates the formatted representation of the period the purchases for this item. For example: YYYYMM (month) YYYYQ (quarter) YYYY (year)
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

Invoice Line Sk

Description	Surrogate key for the anchor entity.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
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

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

Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Mfg Contract Nm

Description	Indicates the manufacturer's contract name. For example: Some manufacturers will give the contract IDs a name like "Primary Health Tier 1" or "GNYHA Local" or "Courtesy" and distributors can use this in their system.
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

Mfg Contract Num

Description	Indicates the contract number that relates to contract nomenclatures.The Mfg Contract ID is what the industry refers to as the chargeback ID or rebate ID contained in the chargeback/rebate requests distributors submit to the manufacturers. Without it, a chargeback/rebate cannot be requested by the distributor.
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

Order Dt

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 Qty

Description	Indicates the quantity of the purchased Item.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Purchase Type Code Sk

Description	Indicates the type of Purchase contract that is, whether the item is purchased under a purchase contract or under no contract, or under a direct contract.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Purchase UOM Code Sk

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

Rx Ind

Description	Indicates whether the invoice line item is a pharmacy product 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

Shipped Qty

Description	Indicates the shipped quantity of the 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

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Type Code Sk

Description	Identifies the actual type of the entry based on the entity type hierarchy defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
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

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Invoice Line Detail_Invoice Line_FK

Is Identifying Relationship	true
Child Table	Invoice Line Detail
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	Invoice Line
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Invoice Line Detail PK

Key Attribute	Invoice Line Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model