GL_ACCESS_SET_ASSIGN_INT

This table is used for internal processing only

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: TABLE

Columns

Name

ACCESS_SET_IDNUMBER18YesThis column is used for internal processing only

LEDGER_IDNUMBER18YesThis column is used for internal processing only

SEGMENT_VALUEVARCHAR225YesThis column is used for internal processing only

ACCESS_PRIVILEGE_CODEVARCHAR21YesThis column is used for internal processing only

PARENT_RECORD_IDNUMBER18YesThis column is used for internal processing only

STATUS_CODEVARCHAR21YesThis column is used for internal processing only

CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row.

CREATED_BYVARCHAR264YesWho column: indicates the user who created the row.

LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row.

LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row.

LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row.

START_DATEDATEThis column is used for internal processing only

END_DATEDATEThis column is used for internal processing only

Indexes

Index Uniqueness Columns
GL_ACCESS_SET_ASSIGN_INT_U1 Unique ACCESS_SET_ID, PARENT_RECORD_ID, LEDGER_ID, SEGMENT_VALUE, ACCESS_PRIVILEGE_CODE, STATUS_CODE, START_DATE, END_DATE