PB_INVOICE

Description:

The PB_INVOICE table contains information about premium billing invoices.

Primary Key

Column Name	Ordinal Position
PB_INVC_ID	1

Column Information

	Name	Type	Discontinued?
1	PB_INVC_ID	VARCHAR	No
	The unique ID of the premium billing invoice.
2	INV_CREATE_DATE	DATETIME	No
	Date invoice was created.
3	INV_DUE_DATE	DATETIME	No
	Due date for the invoice.
4	INV_STAT_C_NAME	VARCHAR	No
	Indicates the current status of the invoice (printed, payment received, etc.) May contain organization-specific values: No Category Entries: Created Printed Payment Received Closed Cancelled Approved Rejected Released Disputed Not Printed - Paperless
5	PB_ACCT_ID	VARCHAR	No
	The unique ID of the premium billing account associated with the invoice.
6	EFF_MONTH	DATETIME	No
	Effective period for the invoice. This date will correspond to the cycle date of the billing cycle used to generate this invoice.
7	INV_NUM	VARCHAR	No
	Invoice number generated using the account ID and the account invoicing sequence number.
8	CYL_DATE	DATETIME	No
	Cycle date for the invoice.
9	UPDATE_DATE	DATETIME (Local)	No
	The extract date and time of the record for this table.
10	PRESUMED_PAYMENT_ID	VARCHAR	No
	The ID of the payment that pays this invoice.
11	GRACE_EXCLUSION_YN	VARCHAR	No
	Controls whether an invoice is considered an exception to the FFM grace period rules May contain organization-specific values: No Category Entries: No Yes