JV_CODE_COMBINATIONS_GT

This global temporary table will be used to store code combination IDs that identify transactions that are determined to be distributable for a joint venture or correspond to an account set.

Details

• Schema: FUSION

• Object owner: JV

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
JV_CODE_COMBINATIONS_GT_PK	JOB_REQUEST_ID, JOINT_VENTURE_ID, ACCOUNT_SET_ID, CODE_COMBINATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
JOB_REQUEST_ID	NUMBER		18	Yes	Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOINT_VENTURE_ID	NUMBER		18	Yes	Unique identifier for the joint venture.
ACCOUNT_SET_ID	NUMBER		18	Yes	Unique identifier for the account set that the code combination ids are associated with.
CODE_COMBINATION_ID	NUMBER		18	Yes	Key flexfield combination defining column.
ACCOUNT_TYPE	VARCHAR2	1		Yes	Key flexfield combination type (Asset, Liability, etc).
ENABLED_FLAG	VARCHAR2	1		Yes	Indicates if this account combination is enabled.
SUMMARY_FLAG	VARCHAR2	1		Yes	Indicates if summary is allowed for this account combination.

Indexes

Index	Uniqueness	Columns
JV_CODE_COMBINATIONS_GT_PK	Unique	JOB_REQUEST_ID, JOINT_VENTURE_ID, ACCOUNT_SET_ID, CODE_COMBINATION_ID