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.