Groups
SUBSCRIPTION
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N | Primary key | |
2 | ACCOUNT_ID | NUMBER | 22 | Y | Foreign key referencing ACCOUNT.ID | |
3 | CUSTOMER_TYPE | VARCHAR2 | 200 | Y | ||
4 | OWNER_ID | NUMBER | 22 | Y | Foreign key referencing USERS.ID | |
5 | START_DATE | DATE | 7 | Y | ||
6 | END_DATE | DATE | 7 | Y | ||
7 | BLOCKED | NUMBER | 22 | Y | ||
8 | FOREIGN_CALLS | NUMBER | 22 | Y | ||
9 | PHONEBOOK_ENTRY | NUMBER | 22 | Y | ||
10 | LAST_CHANGED_DATE | DATE | 7 | Y | ||
11 | LAST_WARNING_DATE | DATE | 7 | Y | ||
12 | CANCEL_DATE | DATE | 7 | Y | ||
13 | ESTABLISH_DATE | DATE | 7 | Y | ||
14 | STATUS_ID | NUMBER | 22 | Y | Foreign key referencing STATUS.ID | |
15 | PRODUCT_ID | NUMBER | 22 | Y | Foreign key referencing PRODUCT.ID | |
16 | CURRENT_BALANCE | NUMBER | 22 | Y | ||
17 | ALERT_GROUP_ID | NUMBER | 22 | Y | Foreign key referencing ALERT_GROUP.ID | |
18 | USAGE_CONTROL_ENABLED | NUMBER | 22 | Y | ||
19 | USAGE_CONTROL_LAST_DATE | DATE | 7 | Y | ||
20 | NEG_BALANCE_DAYS | NUMBER | 22 | Y | ||
21 | BILLING_GROUP_ID | NUMBER | 22 | Y | DEPRECATED! | |
22 | MAX_USAGE_VALUE | NUMBER | 22 | Y | ||
23 | SALES_REP | VARCHAR2 | 200 | Y | ||
24 | SALES_STORE | VARCHAR2 | 160 | Y | ||
25 | SOLN_ROW_ID | VARCHAR2 | 160 | Y | DEPRECATED! | |
26 | ASSET_ID | VARCHAR2 | 80 | Y | DEPRECATED! | |
27 | ACC_ID | VARCHAR2 | 80 | Y | DEPRECATED! | |
28 | ENTERED_BY | VARCHAR2 | 160 | Y | ||
29 | USAGE_CONTROL_MINIMUM_ENABLED | NUMBER | 22 | Y | ||
30 | USAGE_CONTROL_MINIMUM_DATE | DATE | 7 | Y | ||
31 | BONUS_USAGE | NUMBER | 22 | Y | ||
32 | BONUS_VALUE | NUMBER | 22 | Y | ||
33 | SHIPPING_USER_ID | NUMBER | 22 | Y | ||
34 | LAST_BALANCE_UPDATE | DATE | 7 | Y | ||
35 | BRAND_ID | NUMBER | 22 | Y | Foreign key referencing BRAND.ID | |
36 | PARENT_ID | NUMBER | 22 | Y | ||
37 | ORDER_ID | VARCHAR2 | 100 | Y | ||
38 | CONCURRENCY_KEY | NUMBER | 22 | Y | ||
39 | NON_REFUNDABLE_BALANCE | NUMBER | 22 | Y | ||
40 | NON_REFUNDABLE_BALANCE_DATE | DATE | 7 | Y | ||
41 | CHURN_STATUS | NUMBER | 22 | Y |
Contains all Subscriptions/SIMs