ARB_USER_ACCT_SITES_GT
This table is used to store the account sites availiable of each customer.
Details
-
Schema: FUSION
-
Object owner: ARB
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USER_ID | NUMBER | 18 | Yes | User identifier. | |
| SESSION_ID | VARCHAR2 | 32 | Yes | User session identifier. | |
| USER_GUID | VARCHAR2 | 64 | Yes | The latest user Guid of the user. | |
| USER_NAME | VARCHAR2 | 100 | Yes | The latest principal username of the user. | |
| PARTY_ID | NUMBER | 18 | Yes | Party identifier. | |
| CUSTOMER_ID | NUMBER | 18 | Yes | Unique identifier for the account created for a party. | |
| SET_ID | NUMBER | 18 | Yes | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. | |
| CUSTOMER_SITE_USE_ID | NUMBER | 18 | Yes | Site use identifier. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ARB_USER_ACCT_SITES_GT_N1 | Non Unique | USER_GUID |