ORG |
Default Table Name | ORG |
Definition |
ORG Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ORG_ID![]() |
VARCHAR2(20) | NO | ||
ORG_NAME | VARCHAR2(25) | NO | ||
ORG_TOP_FL | VARCHAR2(1) | NO | ||
LVL_NO | NUMBER(5, 0) | NO | ||
TAXBLE_ENTITY_ID![]() |
VARCHAR2(10) | NO | ||
ACTIVE_FL | VARCHAR2(1) | NO | ||
FY_CD_FR![]() |
VARCHAR2(6) | YES | ||
PD_NO_FR![]() |
NUMBER(5, 0) | YES | ||
FY_CD_TO![]() |
VARCHAR2(6) | YES | ||
PD_NO_TO![]() |
NUMBER(5, 0) | YES | ||
IC_TRCKNG_LVL_NO | NUMBER(5, 0) | NO | ||
ORG_LVLS_NO | NUMBER(5, 0) | NO | ||
ORG_ABBRV_CD | VARCHAR2(6) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
L1_ORG_NAME | VARCHAR2(25) | YES | ||
L2_ORG_NAME | VARCHAR2(25) | YES | ||
L3_ORG_NAME | VARCHAR2(25) | YES | ||
L4_ORG_NAME | VARCHAR2(25) | YES | ||
L5_ORG_NAME | VARCHAR2(25) | YES | ||
L6_ORG_NAME | VARCHAR2(25) | YES | ||
L7_ORG_NAME | VARCHAR2(25) | YES | ||
L8_ORG_NAME | VARCHAR2(25) | YES | ||
L9_ORG_NAME | VARCHAR2(25) | YES | ||
L1_ORG_SEG_ID | VARCHAR2(20) | YES | ||
L2_ORG_SEG_ID | VARCHAR2(18) | YES | ||
L3_ORG_SEG_ID | VARCHAR2(16) | YES | ||
L4_ORG_SEG_ID | VARCHAR2(14) | YES | ||
L5_ORG_SEG_ID | VARCHAR2(12) | YES | ||
L6_ORG_SEG_ID | VARCHAR2(10) | YES | ||
L7_ORG_SEG_ID | VARCHAR2(8) | YES | ||
L8_ORG_SEG_ID | VARCHAR2(6) | YES | ||
L9_ORG_SEG_ID | VARCHAR2(4) | YES | ||
L10_ORG_SEG_ID | VARCHAR2(2) | YES | ||
ICR_ACCT_ID_FR | VARCHAR2(15) | YES | ||
ICR_REF1_ID_FR | VARCHAR2(20) | YES | ||
ICR_REF2_ID_FR | VARCHAR2(20) | YES | ||
ICR_ACCT_ID_TO | VARCHAR2(15) | YES | ||
ICR_REF1_ID_TO | VARCHAR2(20) | YES | ||
ICR_REF2_ID_TO | VARCHAR2(20) | YES | ||
EC_APP_PROC_CD | VARCHAR2(8) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
TC_ORG_FL | VARCHAR2(1) | NO | ||
COBRA_ORG | VARCHAR2(59) | YES | ||
SFT_FL | VARCHAR2(1) | YES | ||
MES_FL | VARCHAR2(1) | YES |
ORG Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0058 | PrimaryKey | ORG_ID |
ORG Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
TAXBLE_ENTITY | Non-Identifying | One To Zero or More | F02380 | TAXBLE_ENTITY_ID | NO | NO | NO | ||
ACCTING_PD | Non-Identifying | Zero or One to Zero or More | F06435 | FY_CD_FR, PD_NO_FR | NO | NO | NO | ||
ACCTING_PD | Non-Identifying | Zero or One to Zero or More | F06436 | FY_CD_TO, PD_NO_TO | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
DFLT_REG_TS | Non-Identifying | One To Zero or More | F00860 | NO | NO | NO | |||
DFLT_OT_TS | Non-Identifying | One To Zero or More | F00861 | NO | NO | NO | |||
ORG_ACCT | Identifying | One To Zero or More | F02420 | NO | NO | NO | |||
ORG_LVL | Identifying | One To Zero or More | F02470 | NO | NO | NO | |||
PROJ | Non-Identifying | One To Zero or More | F03800 | NO | NO | NO | |||
ETC_FEE | Identifying | One To Zero or More | F08188 | NO | NO | NO | |||
PROJ_BUD_FEE | Identifying | One To Zero or More | F08202 | NO | NO | NO | |||
PROJ_TOT_BUD_FEE | Identifying | One To Zero or More | F08219 | NO | NO | NO | |||
RQ_HDR | Non-Identifying | One To Zero or More | F09448 | NO | NO | NO | |||
VEND_EXP_ACCT | Non-Identifying | One To Zero or More | F09822 | NO | NO | NO | |||
GL_CONFIG | Non-Identifying | One To Zero or More | F09832 | NO | NO | NO | |||
ORG_MGR_DFLT | Identifying | One To Zero or More | F09896 | NO | NO | NO | |||
HS_ORG_BUD | Identifying | One To Zero or More | F09929 | NO | NO | NO | |||
GL_CONFIG | Non-Identifying | One To Zero or More | F10002 | NO | NO | NO | |||
H_DETL_POS_DESC | Non-Identifying | One To Zero or More | F20420 | NO | NO | NO | |||
H_POS_RQ_RQST | Identifying | One To Zero or More | F20482 | NO | NO | NO | |||
H_RQ_APPRVR | Identifying | One To Zero or More | F20487 | NO | NO | NO | |||
REORG_ORG_LINK | Identifying | One To Zero or More | F20518 | NO | NO | NO | |||
BILL_OTH_CHGS | Non-Identifying | One To Zero or More | F20520 | NO | NO | NO | |||
EQUIP | Non-Identifying | One To Zero or More | F20676 | NO | NO | NO | |||
WORKCENTER | Non-Identifying | One To Zero or More | F20690 | NO | NO | NO | |||
OPERATION | Non-Identifying | One To Zero or More | F20710 | NO | NO | NO | |||
ROUTING_LN | Non-Identifying | One To Zero or More | F20731 | NO | NO | NO | |||
PLANNER | Non-Identifying | One To Zero or More | F20757 | NO | NO | NO | |||
MO_HDR | Non-Identifying | One To Zero or More | F20775 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20806 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20807 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | Zero or One to Zero or More | F20808 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20809 | NO | NO | NO | |||
DOCUMENT | Non-Identifying | One To Zero or More | F21052 | NO | NO | NO | |||
EMPL_TS_LN_TYPE_DF | Non-Identifying | One To Zero or More | F21076 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21120 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21122 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21124 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | Zero or One to Zero or More | F21126 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21128 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21130 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21132 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21134 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21136 | NO | NO | NO | |||
ALLOWANCE_CD | Non-Identifying | Zero or One to Zero or More | F21267 | NO | NO | NO | |||
EMPL_ALLOW_CD | Non-Identifying | One To Zero or More | F21275 | NO | NO | NO | |||
UNION_PROFLE_FRNG | Non-Identifying | One To Zero or More | F21382 | NO | NO | NO | |||
PROP_HDR | Non-Identifying | One To Zero or More | F21493 | NO | NO | NO | |||
H_POS_RQ_RQST | Non-Identifying | One To Zero or More | FK_H_POS_RQ_RQST_DFCH_IDX | NO | NO | NO | |||
HS_PROJ | Non-Identifying | One To Zero or More | FK_HS_PROJ_OR_IDX | NO | NO | NO |