subscription

Header record for subscriptions.

Column name	Description	Data type
subscription	Primary key.	integer
usn	A public, unique identifier for the subscription.	text
username	Primary key. An identifier for the subscription that is unique within a certain scope.	text
company	Reference to `company`. Reference to `currency`.	smallint
account	Reference to `account`.	integer
master_subscription	If set, then this subscription inherits from the referenced subscription and also forwards usage to the referenced subscription. Reference to `subscription`.	integer *
service	What type of subscription this is. Reference to `service`.	integer
rating_cycle	Reference to `rating_cycle`.	character (1)
rating_cycle_day		smallint *
discount	Reference to `discount`.	integer *
created		timestamp with time zone
account_cost_centre	Reference to `account_cost_centre`.	integer *
description		text *
taxable	If false, this subscription's charges do not attract tax. The account's value may override this one.	boolean
currency	Reference to `currency`.	charcter varying (3) *
timezone	Reference to `timezone`.	integer
provisioned		timestamp with time zone *
activated		timestamp with time zone *
ordered		timestamp with time zone *
enabled		timestamp with time zone *
subscription_status	Reference to `subscription_status`.	text *
purchase_order	Reference to `account_purchase_order`.	uuid *