SUBSCRIPTION

Col #	Column Name	Data Type	Field Length	Not Null?	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