MERCHANDISE_ORD_SALE_INFO

Description: |
This table stores the sale level information of merchandise orders.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier for the merchandise order record.
2 | CONTACT_DATE_REAL | FLOAT | No |
This column contains a unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | CONTACT_DATE | DATETIME | No |
This column contains the date of this contact in calendar format.
4 | MERCH_UNIT_PR | NUMERIC | No |
This column contains the final sale price for a merchandise in an order. If the price was overridden, this column contains the override price, and the original price is stored in Merchandise Original Unit Price column.
5 | MERCH_RETURN_RSN_C_NAME | VARCHAR | No |
The merchandise return reason category ID for the order.
May contain organization-specific values: Yes
Category Entries:
Not Needed
Wrong Product
Damaged Product
Price Match
Other
6 | QUANTITY | NUMERIC | No |
This column holds the quantity of merchandise sold in the sale contact.
7 | STATUS_C_NAME | VARCHAR | No |
The current status category ID for the sale contact.
May contain organization-specific values: Yes
Category Entries:
New
Pending Rx Entry
Pending E-Transfer
Scheduled Fill
Pending Fill
Fill Rejected
Waiting For Approval
Ready to Fill
Fill Initiated
Filled
Ready to Verify
Fill Rejected
Verified
Ready to Package
Ready to Transport
In Transit
Received
Waiting for Filling Pharmacies
Ready to Dispense
Dispense Documented
Dispense Received from External System
Dispensed
Shipped
Delivered
Consult
Completed
Approved Refill Request
Denied Refill Request
Profiled
Canceled
Order Edited
Flag Removed
Returned to Stock
Wasted
Clinically Reviewed
Clinical Changes Reviewed
Charge
Payment
Bagged
Toted
Trucked
Boxed
Packaged
Sealed
Barcode Scan
Patient Notification
Abandoned Rx Sale
Needs Tracking Number
No Sale Completed
Authentication
Payment Amount Changed
Invalidated Billing Item
Prescription Revision Needed
Prescription Revised
IP Dispense Prepared
IP Dispense Prep Started
IP Dispense Prep Saved Work
IP Dispense Prep Pending Final Review
IP Reused For Another Dose Dispense Prep
IP Reused From Previous Dose Dispense Prep
IP Dispense Prep Partial Complete
IP Dispense Prep Resumed
IP Dispense Prep Stopped
IP Dispense Prep Saved on Admin
IP Dispense Checked
IP Dispense Prep Partial Check
IP Dispense Prep Revise
IP Dispense Prep Requeued
IP Dispense Rejected
IP Dispense Prep Reuse Started
IP Dispense Prep Reuse Stopped
IP Queued For Dispense Check Without Prep
IP Dispense Check Removed
IP Dispense Check Started
IP Second Dispense Check
IP Dispense Final Label Check
IP Final Label Check Deferred
IP Final Label Check Overridden
IP Added to Dispense Queue
IP Printed From Dispense Queue
IP Automatically Removed From Dispense Queue
IP Manually Removed From Dispense Queue
Rx Dispense Sent
Rx Dispense Received
Rx Cancel Tracking Action
IP Dispense Prepared via Interface
Download Request Pending
Download Request Submitted
Download Successful
Download Request Rejected
Download Request Canceled
Download Error
Download Not Attempted
E-Transfer Request Pending Send
E-Transfer Request Sent
E-Transfer Request Sent Successfully
E-Transfer Request Sending Error
E-Transfer Request Approved
E-Transfer Request Denied
E-Transfer Pending Reconciliation
E-Transfer Reconciled
E-Transfer Confirmation Sent
E-Transfer Confirmation Success
E-Transfer Confirmation Error
E-Transfer Request Received
E-Transfer Response Pending Send
E-Transfer Response Sent
E-Transfer Response Sent Successfully
E-Transfer Response Sending Error
E-Transfer Response Denied
E-Transfer Confirmation Received
Sale Completed
Sale Updated
Sale Canceled
Sale Price Override Approved
Sale Pending
Fee Sold in POS
Waiting on Third Party
Tax Exemption Applied
Tax Exemption Removed
Tax Charge
Rx Inv Stock Location Overridden
Rx Inv Stock Location Override Removed
Not Dispensed
HI Shipment Started
HI Shipment Audited
HI Dispensed
HI Worksheet Printed
HI New Revision
HI Meds Staged
HI Supplies Staged
HI Meds Stage Checked
HI Supplies Stage Checked
HI Staged
HI Stage Checked
HI Meds Packed
HI Supplies Packed
HI Packed
HI Ready To Ship
HI Post Shipment Change
HI In Transit
HI Delivered
HI Complete
HI Canceled
8 | STATUS_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
This column contains the instant that sale contact moved to its current status.
9 | CHARGING_CSN | NUMERIC | No |
The unique contact serial number of the patient of the pharmacy visit contact to use for charge and payment posting.
10 | UNIT_ACQUISITION_COST | NUMERIC | No |
This column contains the acquisition cost for the merchandise.
11 | CASH_PRICE | NUMERIC | No |
This column contains the total cash price for the merchandise sale.
12 | CASH_PRICE_CALCULATED | NUMERIC | No |
This column holds the original total cash price for the merchandise sale when the cash price was overridden.
13 | CASH_PRICE_OVERRIDE_REASON_C_NAME | VARCHAR | No |
The reason category ID for the cash price override for a merchandise sale.
May contain organization-specific values: Yes
14 | CASH_PRICE_OVERRIDE | NUMERIC | No |
This column holds the user specified value for the cash price for the merchandise sale.
15 | TAX_DUE_TOTAL | NUMERIC | No |
This column contains the rounded value for total taxes due for the merchandise sale.
16 | PAT_PAY_AMOUNT | NUMERIC | No |
This column contains the total cost of the merchandise including any taxes applicable to the merchandise sale.
17 | TAX_EXEMPT_YN | VARCHAR | No |
Indicates whether the tax was exempted for the merchandise sale.
May contain organization-specific values: No
Category Entries:
No
Yes
18 | RX_TAX_ROUNDING_METHOD_C_NAME | VARCHAR | No |
The rounding method category ID used to calculate the total taxes for a merchandise sale.
May contain organization-specific values: No
Category Entries:
Standard
Round Up
19 | TAX_EXEMPTED_TOTAL | NUMERIC | No |
This column contains the rounded value for total amount of taxes exempted for a merchandise sale.
20 | SALE_PHARMACY_ID | NUMERIC | No |
The unique identifier for the pharmacy record associated with the merchandise sale contact.
21 | SALE_PHARMACY_ID_PHARMACY_NAME | VARCHAR | No |
The name of the pharmacy.
22 | RX_CHARGE_DROP_INST_UTC_DTTM | DATETIME (UTC) | No |
This column contains the latest instant the charge associated with this contact was dropped/credited.
23 | PHARMACY_SALE_ITEM_ID | VARCHAR | No |
The unique identifier for the fee or merchandise record for the pharmacy sale.
24 | PHARMACY_SALE_ITEM_ID_SUPPLY_NAME | VARCHAR | No |
The name of the inventory item.