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	PB_INVC_ID	VARCHAR	No
	As of system 2002 MU4, this column is discontinued and replaced by the PB_TX_SET_INVOICE table. The unique ID of the premium billing invoice associated with the transaction set.
6	CANCEL_PB_INVC_ID	VARCHAR	No
	As of system 2002 MU4, this column is discontinued and replaced by the PB_TX_SET_CNCL_INV table. The unique ID of the cancelled premium billing invoice associated with the transaction set.
7	PERIOD_FROM_DATE	DATETIME	No
	Beginning date of period for the transaction set.
8	PERIOD_TO_DATE	DATETIME	No
	Ending date of the period for the transaction set.
9	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
10	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
11	CUST_PTS_CMT	VARCHAR	No
	Comment associated with a customized transaction set.
12	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.
13	INC_EFF_FR_DT	DATETIME	No
	Effective from date for transactions included in the custom transaction set.
14	INC_EFF_TO_DT	DATETIME	No
	Effective to date for transactions included in the custom transaction set.
15	EXC_EFF_FR_DT	DATETIME	No
	Effective from date for transactions excluded from the custom transaction set.
16	EXC_EFF_TO_DT	DATETIME	No
	Effective to date for transactions excluded from the custom transaction set.
17	UPDATE_DATE	DATETIME (Local)	No
	The extract date and time of the record for this table.