|
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 |
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 Check Removed |
IP Dispense Check Started |
IP Second Dispense Check |
IP Dispense Final Label Check |
IP Final Label Check Deferred |
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 |
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. |
|
|