|
Name |
Type |
Discontinued? |
|
| 1 |
PB_ACCT_ID |
VARCHAR |
No |
|
|
|
| The unique ID for the premium billing account. |
|
|
| 2 |
BILL_ADDR1 |
VARCHAR |
No |
|
|
|
| Street address line 1 for premium billing account billing address. |
|
|
| 3 |
BILL_ADDR2 |
VARCHAR |
No |
|
|
|
| Street address line 2 for premium billing account billing address. |
|
|
| 4 |
BILL_CITY |
VARCHAR |
No |
|
|
|
| City for premium billing account billing address. |
|
|
| 5 |
BILL_STATE_C_NAME |
VARCHAR |
No |
|
|
|
| State for premium billing account billing address. |
| May contain organization-specific values: Yes |
|
|
| 6 |
BILL_ZIP |
VARCHAR |
No |
|
|
|
| ZIP Code for premium billing account billing address. |
|
|
| 7 |
BILL_COUNTY_C_NAME |
VARCHAR |
No |
|
|
|
| County for premium billing account billing address. |
| May contain organization-specific values: Yes |
|
|
| 8 |
BILL_COUNTRY_C_NAME |
VARCHAR |
No |
|
|
|
| Country for premium billing account billing address. |
| May contain organization-specific values: Yes |
|
|
| 9 |
BILL_PHONE |
VARCHAR |
No |
|
|
|
| Billing phone number for premium billing account. |
|
|
| 10 |
BILL_FAX |
VARCHAR |
No |
|
|
|
| Billing fax number for premium billing account. |
|
|
| 11 |
BILL_EMAIL |
VARCHAR |
No |
|
|
|
| Billing e-mail address for premium billing account. |
|
|
| 12 |
INVMSG_NOTE_ID |
VARCHAR |
No |
|
|
|
| The unique ID of note to be included on premium billing invoices for the premium billing account. |
|
|
| 13 |
BAL_DUE |
NUMERIC |
No |
|
|
|
| Balance due for the premium billing account. |
|
|
| 14 |
HIX_ACCT_BAL_DUE |
NUMERIC |
No |
|
|
|
| This item contains the subscriber's portion of the balance due on the associated group premium billing account. |
|
|
| 15 |
TOTAL_BAL_DUE |
NUMERIC |
No |
|
|
|
| This item contains the total of the account balance plus the subscriber's portion of the balance due on the associated group premium billing account. |
|
|
| 16 |
AR_ACCT_BALANCE |
NUMERIC |
No |
|
|
|
| The account balance stores the sum of all transaction amounts for transactions that have filed to the account. |
|
|
| 17 |
BILL_HOUSE_NUM |
VARCHAR |
No |
|
|
|
| House number for premium billing account billing address. |
|
|
| 18 |
BILL_DISTRICT_C_NAME |
VARCHAR |
No |
|
|
|
| District for the premium billing account billing address. |
| May contain organization-specific values: Yes |
|
|
