V_EHI_PTS_PB_TX_SET_INVOICE

Description:

This view filters out premium billing payment data that is not appropriate for member level EHI exports when group billing is used.

Primary Key

Column Name	Ordinal Position
PB_TXSET_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PB_TXSET_ID	VARCHAR	No
	The unique ID of the premium billing transaction set.
2	LINE	INTEGER	No
	The line count for the invoice on the transaction set.
3	INV_TX_SET_AMT	NUMERIC	No
	The invoice amount associated with the transaction set.
4	INVOICE_PAYMENT_AMOUNT	NUMERIC	No
	This field stores the payment amount for this invoice.
5	INVOICE_ADJ_AMOUNT	NUMERIC	No
	This field stores the adjustment amount for this invoice.
6	PB_INVC_ID	VARCHAR	No
	The unique ID of the invoice associated with the transaction set.