DW_GIC_FUN_INTERCO_ORG_D (Preview)
This table requires activation of Global Intercompany functional area. This table contains the details of the intercompany organizations
Details
Module:
Key Columns
INTERCO_ORG_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| INTERCO_ORG_ID | NUMBER | 38 | 0 | True | Intercompany organization identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. | ||||
| CONTACT_PERSON_ID | NUMBER | 38 | 0 | Contact person identifier for the intercompany organization. | |||
| CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| DESCRIPTION | VARCHAR2 | 512 | Intercompany organization description. | ||||
| ENABLED_FLAG | VARCHAR2 | 16 | Enabled flag for the intercompany organization. | ||||
| INTERCO_ORG_NAME | VARCHAR2 | 512 | Intercompany organization name. | ||||
| LAST_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier associated with the intercompany organization. | |||
| ORGANIZATION_SHORT_CODE | VARCHAR2 | 16 | Short code for the intercompany organization | ||||
| PAY_BU_ID | NUMBER | 38 | 0 | Payables business unit identifier. | |||
| REC_BU_ID | NUMBER | 38 | 0 | Receivables business unit identifier. | |||
| REGISTRATION_ID | NUMBER | 38 | 0 | Unique identifier for registration. |