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 Fill Returned Fill 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 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.