INV_ACCESSIBLE_ORGS_GT
This table stores the organizations which are accessible for the current session
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
INV_ACCESSIBLE_ORGS_GT_PK |
USER_GUID, PRIVILEGE_NAME, ORGANIZATION_ID |
Columns
| Name |
|---|
|
USER_GUIDVARCHAR264Yesapplications user unique id PRIVILEGE_NAMEVARCHAR2400YesData Privilege ORGANIZATION_IDNUMBER18YesInventory Organization identifer ORGANIZATION_CODEVARCHAR218YesThis code indicates the inventory organization. ORGANIZATION_NAMEVARCHAR2240Name of the organization SET_OF_BOOKS_IDNUMBER18Identifier for Set of Books. CHART_OF_ACCOUNTS_IDNUMBER18Identifier for Chart of Accounts CURRENCY_CODEVARCHAR215This indicates the currency to use. DISTRIBUTED_ORGANIZATION_FLAGVARCHAR21This column indicates if the organization is LSP enabled. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| INV_ACCESSIBLE_ORGS_GT_U1 | Unique | USER_GUID, PRIVILEGE_NAME, ORGANIZATION_ID |