DW_NS_subscriptionTerm_D
This table contains the list of subscription terms created which is used to define the tenure of a subscription.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| isinactive | VARCHAR2 | 16 | Inactive | ||||
| name | VARCHAR2 | 256 | Name | ||||
| subscriptiontermduration | NUMBER | 38 | 0 | Duration | |||
| subscriptiontermtype | VARCHAR2 | 32 | Type | DW_NS_subscriptiontermtype_D | key | ||
| subscriptiontermunit | VARCHAR2 | 32 | Units | DW_NS_subscriptiontermunit_D | id |