RXW_DISPENSE_PSE_TXS
Description:
This table contains the list of pseudoephedrine sales compliance database transactions associated with a point of sale transaction.

Primary Key
Column Name Ordinal Position
RECORD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier (.1 item) for the work request 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 PSE_SALE_TX_IDENT VARCHAR No
The pseudoephedrine sales compliance system transaction IDs. The first ID will always be the initial Pseudoephedrine Transaction ID from the initial purchase. For returns, the Pseudoephedrine Return ID will be stored on the subsequent lines.