V_EHI_PAX_PB_ACCT_TX_INV_NUM

Description:

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

Primary Key

Column Name	Ordinal Position
PB_ACT_TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PB_ACT_TX_ID	VARCHAR	No
	The unique ID of the premium account transaction.
2	LINE	INTEGER	No
	Line counter of the premium billing invoice history of the transaction.
3	PB_INVC_ID	VARCHAR	No
	The unique ID of the premium billing invoice.
4	INVOICE_AMT	NUMERIC	No
	Amount of the premium account transaction that appeared on the related premium billing invoice.