ORD_MED_RX_NUM_NDC_TABLE
Description:
This table contains the prescription numbers associated with NDC records when the pharmacy sends multiple adjudication messages for unique NDCs, without including the compound segment in the adjudication message.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier (.1 item) for the order record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 RX_NUMBER_RAW VARCHAR No
Stores the compiled prescription number for each NDC when the pharmacy sends multiple adjudication messages for unique NDCs, without including the compound segment in the adjudication message.
4 RX_NUMBER VARCHAR No
Stores the formatted prescription number for each NDC when the pharmacy sends multiple adjudication messages for unique NDCs, without including the compound segment in the adjudication message.