PB_TX_SET
Description:
The PB_TX_SET table contains the premium billing payment transaction sets.

Primary Key
Column Name Ordinal Position
PB_TXSET_ID 1

Column Information
Name Type Discontinued?
1 PB_TXSET_ID VARCHAR No
The unique ID of the premium billing transaction set.
2 PB_ACCT_ID VARCHAR No
The unique ID of the premium billing account associated with the transaction set.
3 PB_PMT_ID VARCHAR No
The unique ID of the premium billing payment associated with the transaction set.
4 CANCEL_PB_PMT_ID VARCHAR No
The unique ID of the cancelled premium billing payment associated with the transaction set.
5 PERIOD_FROM_DATE DATETIME No
Beginning date of period for the transaction set.
6 PERIOD_TO_DATE DATETIME No
Ending date of the period for the transaction set.
7 PMT_METH_C_NAME VARCHAR No
Payment method of the transaction set (balance forward or exception).
May contain organization-specific values: No
Category Entries:
Balance Forward
Exception
8 CUST_PAIDBY_PTS_C_NAME VARCHAR No
Describes portion of the invoice that this transaction set was targeted towards (entire invoice, custom portion, remaining invoice, or custom advice).
May contain organization-specific values: No
Category Entries:
Entire Invoice
Custom Portion of Invoice
Remaining Invoice
All Outstanding Txs
None. Custom PTS Advice used in PBU
9 CUST_PTS_CMT VARCHAR No
Comment associated with a customized transaction set.
10 LATEST_PB_INVC_ID VARCHAR No
The unique ID of the latest premium billing invoice record on the premium billing account when this payment was committed.
11 INC_EFF_FR_DT DATETIME No
Effective from date for transactions included in the custom transaction set.
12 EXC_EFF_FR_DT DATETIME No
Effective from date for transactions excluded from the custom transaction set.
13 EXC_EFF_TO_DT DATETIME No
Effective to date for transactions excluded from the custom transaction set.
14 UPDATE_DATE DATETIME (Local) No
The extract date and time of the record for this table.