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
12 REFUND_INVOICE_YN VARCHAR No
This item is set to yes when the invoice that has been generated was done through refunding.
The category values for this column were already listed for column: GRACE_EXCLUSION_YN