PB_ACCT_TX_DTL
Description:
This table stores the linkages between the account posting transactions and their originating detail transactions.

Primary Key
Column Name Ordinal Position
TRANSACTION_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TRANSACTION_ID VARCHAR No
The unique identifier for the account transaction record resulting from a premium billing account posting.
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 DTL_TX_ID VARCHAR No
The unique ID of the premium billing detailed transaction.
4 DTL_TX_AMOUNT NUMERIC No
The amount on the associated detailed transaction that contributed towards the account transaction at the time of posting.