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 | 50 | 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 | 50 | Y | ||
| 24 | SALES_STORE | VARCHAR2 | 40 | Y | ||
| 25 | SOLN_ROW_ID | VARCHAR2 | 40 | Y | DEPRECATED! | |
| 26 | ASSET_ID | VARCHAR2 | 20 | Y | DEPRECATED! | |
| 27 | ACC_ID | VARCHAR2 | 20 | Y | DEPRECATED! | |
| 28 | ENTERED_BY | VARCHAR2 | 40 | Y | ||
| 29 | USAGE_CONTROL_MINIMUM_ENABLED | NUMBER | 22 | Y | ||
| 30 | USAGE_CONTROL_MINIMUM_DATE | DATE | 7 | Y | ||
| 31 | LAST_BALANCE_UPDATE | DATE | 7 | Y | ||
| 32 | BRAND_ID | NUMBER | 22 | Y | Foreign key referencing BRAND.ID | |
| 33 | PARENT_ID | NUMBER | 22 | Y | ||
| 34 | ORDER_ID | VARCHAR2 | 25 | Y | ||
| 35 | CONCURRENCY_KEY | NUMBER | 22 | Y | ||
| 36 | NON_REFUNDABLE_BALANCE | NUMBER | 22 | Y | ||
| 37 | NON_REFUNDABLE_BALANCE_DATE | DATE | 7 | Y | ||
| 38 | CHURN_STATUS | NUMBER | 22 | Y | ||
| 39 | CA_NICKNAME | VARCHAR2 | 200 | Y |
Contains all Subscriptions/SIMs