|
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 |
|
|