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 |