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