ZX_SUBSCRIPTION_OPTIONS

This table stores the list of date effective content subscription options for each regime of a first party organization defined in ZX_REGIMES_USAGES table.

Details

• Schema: FUSION

• Object owner: ZX

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
ZX_SUBSCRIPTION_OPTIONS_PK	SUBSCRIPTION_OPTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SUBSCRIPTION_OPTION_ID	NUMBER		18	Yes	Unique identifier
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SUBSCRIPTION_OPTION_CODE	VARCHAR2	30		Yes	Lookup code for content subscription option
REGIME_USAGE_ID	NUMBER		18	Yes	Regime usage identifier
PARENT_FIRST_PTY_ORG_ID	NUMBER		18		Party tax profile identifier for parent first party organization
EFFECTIVE_FROM	DATE			Yes	Effective from date
EFFECTIVE_TO	DATE				Effective to date
ENABLED_FLAG	VARCHAR2	1		Yes	Y or N indicates if the subscription option is enabled
ALLOW_SUBSCRIPTION_FLAG	VARCHAR2	1		Yes	Y or N indicates whether any other first party organization can subscribe to the regime of this subscription option for the time period of this subscription option.
RECORD_TYPE_CODE	VARCHAR2	30		Yes	Lookup code to indicate whether the record is migrated, seeded or defined by the user
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
EXCEPTION_OPTION_CODE	VARCHAR2	30			Lookup code for exceptions content subscription option

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZX_SUBSCRIPTION_OPTIONS	zx_party_tax_profile	PARENT_FIRST_PTY_ORG_ID
ZX_SUBSCRIPTION_OPTIONS	zx_regimes_usages	REGIME_USAGE_ID
zx_subscription_details	zx_subscription_options	SUBSCRIPTION_OPTION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ZX_SUBSCRIPTION_OPTIONS_U1	Unique	Default	SUBSCRIPTION_OPTION_ID
ZX_SUBSCRIPTION_OPTIONS_U2	Unique	Default	REGIME_USAGE_ID, EFFECTIVE_FROM, ENABLED_FLAG