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