MERCHANDISE_ORDER_INFO

Description: |
This table contains the order level information of merchandise orders.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier for the order record.
2 | MERCH_SUPPLY_ID | VARCHAR | No |
The unique identifier for the merchandise record for the merchandise order.
3 | MERCH_SUPPLY_ID_SUPPLY_NAME | VARCHAR | No |
The name of the inventory item.
4 | MERCH_ORIG_UNIT_PR | NUMERIC | No |
This column contains the original unit price from the merchandise record when the it was sold from the outpatient pharmacy.
5 | ELIGIBLE_HEALTHCARE_EXPENSE_YN | VARCHAR | No |
Indicates whether merchandise item sold was an eligible healthcare expense at the time of sale, which qualifies it to be paid for with a healthcare expense account such as an FSA, HSA, or HRA. This is applicable only to retail merchandise sales. 'N' or NULL indicate that the merchandise is not considered an eligible healthcare expense. 'Y' indicates that the merchandise is considered an eligible healthcare expense.
May contain organization-specific values: No
Category Entries:
No
Yes
6 | DISPLAY_NAME | VARCHAR | No |
This column contains the display name for the merchandise order.
7 | PHARMACY_ID | NUMERIC | No |
The unique identifier for the pharmacy record where the merchandise was sold.
8 | PHARMACY_ID_PHARMACY_NAME | VARCHAR | No |
The name of the pharmacy.
9 | FEE_TYPE_C_NAME | VARCHAR | No |
For pharmacy fee orders, this is the fee type category ID for the order.
May contain organization-specific values: Yes
Category Entries:
Delivery Fee