REF_STRUC |
Default Table Name | REF_STRUC |
Definition |
REF_STRUC Columns |
ColumnName | Domain | Datatype | NULL | Definition |
REF_STRUC_ID![]() |
VARCHAR2(20) | NO | ||
REF_STRUC_TOP_FL | VARCHAR2(1) | NO | ||
LVL_NO | NUMBER(5, 0) | NO | ||
REF_STRUC_NAME | VARCHAR2(25) | NO | ||
REF_STRUC_LVLS_NO | NUMBER(5, 0) | NO | ||
REF_DATA_ENTRY_FL | VARCHAR2(1) | NO | ||
S_REF_ENTRY_CD | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
L1_REF_STRUC_NAME | VARCHAR2(25) | YES | ||
L2_REF_STRUC_NAME | VARCHAR2(25) | YES | ||
L3_REF_STRUC_NAME | VARCHAR2(25) | YES | ||
L4_REF_STRUC_NAME | VARCHAR2(25) | YES | ||
L5_REF_STRUC_NAME | VARCHAR2(25) | YES | ||
L6_REF_STRUC_NAME | VARCHAR2(25) | YES | ||
L7_REF_STRUC_NAME | VARCHAR2(25) | YES | ||
L8_REF_STRUC_NAME | VARCHAR2(25) | YES | ||
L9_REF_STRUC_NAME | VARCHAR2(25) | YES | ||
L1_REF_SEG_ID | VARCHAR2(20) | YES | ||
L2_REF_SEG_ID | VARCHAR2(18) | YES | ||
L3_REF_SEG_ID | VARCHAR2(16) | YES | ||
L4_REF_SEG_ID | VARCHAR2(14) | YES | ||
L5_REF_SEG_ID | VARCHAR2(12) | YES | ||
L6_REF_SEG_ID | VARCHAR2(10) | YES | ||
L7_REF_SEG_ID | VARCHAR2(8) | YES | ||
L8_REF_SEG_ID | VARCHAR2(6) | YES | ||
L9_REF_SEG_ID | VARCHAR2(4) | YES | ||
L10_REF_SEG_ID | VARCHAR2(2) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
REF_STRUC Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0025 | PrimaryKey | REF_STRUC_ID, COMPANY_ID |
REF_STRUC Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
ALLOC_BASIS_JNL | Non-Identifying | One To Zero or More | F00190 | NO | NO | NO | |||
ALLOC_BASIS_JNL | Non-Identifying | One To Zero or More | F00200 | NO | NO | NO | |||
POOL_ALLOC | Non-Identifying | One To Zero or More | F02710 | NO | NO | NO | |||
POOL_ALLOC | Non-Identifying | One To Zero or More | F02720 | NO | NO | NO | |||
POOL_ALLOC | Non-Identifying | One To Zero or More | F02730 | NO | NO | NO | |||
POOL_ALLOC | Non-Identifying | One To Zero or More | F02740 | NO | NO | NO | |||
POOL_BASE_ACCT | Non-Identifying | One To Zero or More | F02790 | NO | NO | NO | |||
POOL_BASE_ACCT | Non-Identifying | One To Zero or More | F02800 | NO | NO | NO | |||
POOL_BASE_ACCT | Non-Identifying | One To Zero or More | F02810 | NO | NO | NO | |||
POOL_BASE_ACCT | Non-Identifying | One To Zero or More | F02820 | NO | NO | NO | |||
POOL_BASE_ACCT | Non-Identifying | One To Zero or More | F02830 | NO | NO | NO | |||
POOL_BASE_ACCT | Non-Identifying | One To Zero or More | F02840 | NO | NO | NO | |||
POOL_INFO | Non-Identifying | One To Zero or More | F02890 | NO | NO | NO | |||
POOL_INFO | Non-Identifying | One To Zero or More | F02900 | NO | NO | NO | |||
POOL_INFO | Non-Identifying | One To Zero or More | F02910 | NO | NO | NO | |||
POOL_INFO | Non-Identifying | One To Zero or More | F02920 | NO | NO | NO | |||
TOP_REF_STRUC_LVLS | Identifying | One To Zero or More | F04790 | NO | NO | NO | |||
REF_BUD | Identifying | One To Zero or More | F06000 | NO | NO | NO | |||
AR_DFLT_ACCT | Non-Identifying | One To Zero or More | F06403 | NO | NO | NO | |||
AR_DFLT_ACCT | Non-Identifying | One To Zero or More | F06404 | NO | NO | NO | |||
AR_TRNSF_ACCT | Non-Identifying | One To Zero or More | F06405 | NO | NO | NO | |||
AR_TRNSF_ACCT | Non-Identifying | One To Zero or More | F06406 | NO | NO | NO | |||
CUST_DFLT_ACCT | Non-Identifying | One To Zero or More | F06410 | NO | NO | NO | |||
CUST_DFLT_ACCT | Non-Identifying | One To Zero or More | F06411 | NO | NO | NO | |||
DFLT_AP_ACCTS | Non-Identifying | One To Zero or More | F06412 | NO | NO | NO | |||
DFLT_AP_ACCTS | Non-Identifying | Zero or One to Zero or More | F06413 | NO | NO | NO | |||
DFLT_CASH_ACCTS | Non-Identifying | One To Zero or More | F06414 | NO | NO | NO | |||
DFLT_CASH_ACCTS | Non-Identifying | Zero or One to Zero or More | F06415 | NO | NO | NO | |||
DED_CD | Non-Identifying | One To Zero or More | F06416 | NO | NO | NO | |||
DED_CD | Non-Identifying | One To Zero or More | F06417 | NO | NO | NO | |||
DED_CD | Non-Identifying | One To Zero or More | F06418 | NO | NO | NO | |||
DED_CD | Non-Identifying | One To Zero or More | F06419 | NO | NO | NO | |||
DED_CD | Non-Identifying | One To Zero or More | F06420 | NO | NO | NO | |||
DED_CD | Non-Identifying | One To Zero or More | F06421 | NO | NO | NO | |||
FA_SETTINGS | Non-Identifying | One To Zero or More | F06424 | NO | NO | NO | |||
FA_SETTINGS | Non-Identifying | One To Zero or More | F06425 | NO | NO | NO | |||
AR_HDR_HS | Non-Identifying | One To Zero or More | F08171 | NO | NO | NO | |||
AR_HDR_HS | Non-Identifying | One To Zero or More | F08172 | NO | NO | NO | |||
REF_SUM | Identifying | One To Zero or More | F08279 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08672 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08673 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08674 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08675 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08676 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08677 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08678 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08679 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08680 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08681 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08682 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08683 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08684 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08685 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08686 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08687 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08688 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08689 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08690 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08691 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08692 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08693 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08694 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08695 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08698 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | Zero or One to Zero or More | F08699 | NO | NO | NO | |||
UNITS_USAGE_LN | Non-Identifying | One To Zero or More | F09043 | NO | NO | NO | |||
UNITS_USAGE_LN | Non-Identifying | One To Zero or More | F09044 | NO | NO | NO | |||
ALLOC_BASIS_JNL_HS | Non-Identifying | One To Zero or More | F09352 | NO | NO | NO | |||
ALLOC_BASIS_JNL_HS | Non-Identifying | One To Zero or More | F09353 | NO | NO | NO | |||
UNITS_USAGE_LN_HS | Non-Identifying | One To Zero or More | F09505 | NO | NO | NO | |||
UNITS_USAGE_LN_HS | Non-Identifying | One To Zero or More | F09506 | NO | NO | NO | |||
ACCUM_DEPR_ACCT | Non-Identifying | One To Zero or More | F09523 | NO | NO | NO | |||
ACCUM_DEPR_ACCT | Non-Identifying | One To Zero or More | F09524 | NO | NO | NO | |||
DEPR_EXP_ALC_ACCT | Non-Identifying | One To Zero or More | F09531 | NO | NO | NO | |||
DEPR_EXP_ALC_ACCT | Non-Identifying | One To Zero or More | F09532 | NO | NO | NO | |||
FA_TEMPLATE | Non-Identifying | One To Zero or More | F09773 | NO | NO | NO | |||
FA_TEMPLATE | Non-Identifying | One To Zero or More | F09774 | NO | NO | NO | |||
POOL_BASE_WILDCARD | Non-Identifying | One To Zero or More | F09809 | NO | NO | NO | |||
POOL_BASE_WILDCARD | Non-Identifying | One To Zero or More | F09810 | NO | NO | NO | |||
POOL_BASE_WILDCARD | Non-Identifying | One To Zero or More | F09811 | NO | NO | NO | |||
POOL_BASE_WILDCARD | Non-Identifying | One To Zero or More | F09812 | NO | NO | NO | |||
POOL_BASE_WILDCARD | Non-Identifying | One To Zero or More | F09813 | NO | NO | NO | |||
POOL_BASE_WILDCARD | Non-Identifying | One To Zero or More | F09814 | NO | NO | NO | |||
VEND_EXP_ACCT | Non-Identifying | One To Zero or More | F09823 | NO | NO | NO | |||
VEND_EXP_ACCT | Non-Identifying | One To Zero or More | F09824 | NO | NO | NO | |||
CO_PAID_MATCH | Non-Identifying | One To Zero or More | F09994 | NO | NO | NO | |||
CO_PAID_MATCH | Non-Identifying | One To Zero or More | F09995 | NO | NO | NO | |||
FA_DISP_EDIT | Non-Identifying | One To Zero or More | F10009 | NO | NO | NO | |||
FA_DISP_EDIT | Non-Identifying | One To Zero or More | F10010 | NO | NO | NO | |||
ASSET | Non-Identifying | One To Zero or More | F20206 | NO | NO | NO | |||
ASSET | Non-Identifying | One To Zero or More | F20207 | NO | NO | NO | |||
SO_HDR | Non-Identifying | One To Zero or More | F20317 | NO | NO | NO | |||
SO_HDR | Non-Identifying | One To Zero or More | F20318 | NO | NO | NO | |||
SO_INVC_HDR | Non-Identifying | One To Zero or More | F20320 | NO | NO | NO | |||
SO_INVC_HDR | Non-Identifying | One To Zero or More | F20321 | NO | NO | NO | |||
BANK_GL_CASH_ACCT | Non-Identifying | One To Zero or More | F20345 | NO | NO | NO | |||
BANK_GL_CASH_ACCT | Non-Identifying | One To Zero or More | F20346 | NO | NO | NO | |||
SO_HDR | Non-Identifying | Zero or One to Zero or More | F20510 | NO | NO | NO | |||
SO_HDR | Non-Identifying | One To Zero or More | F20511 | NO | NO | NO | |||
SO_INVC_HDR | Non-Identifying | One To Zero or More | F20514 | NO | NO | NO | |||
SO_INVC_HDR | Non-Identifying | One To Zero or More | F20515 | NO | NO | NO | |||
TVL_ACCT_CD_ACCTS | Non-Identifying | One To Zero or More | F20595 | NO | NO | NO | |||
TVL_ACCT_CD_ACCTS | Non-Identifying | One To Zero or More | F20596 | NO | NO | NO | |||
POOL_VAR_ACCT | Non-Identifying | One To Zero or More | F20607 | NO | NO | NO | |||
POOL_VAR_ACCT | Non-Identifying | One To Zero or More | F20608 | NO | NO | NO | |||
POOL_VAR_ACCT | Non-Identifying | One To Zero or More | F20609 | NO | NO | NO | |||
POOL_VAR_ACCT | Non-Identifying | One To Zero or More | F20610 | NO | NO | NO | |||
BUD_CO_LN | Non-Identifying | One To Zero or More | F20965 | NO | NO | NO | |||
ALLOWANCE_CD | Non-Identifying | One To Zero or More | F21269 | NO | NO | NO | |||
ALLOWANCE_CD | Non-Identifying | One To Zero or More | F21270 | NO | NO | NO | |||
FA_DEPR_HS | Non-Identifying | One To Zero or More | F21522 | NO | NO | NO | |||
FA_DEPR_HS | Non-Identifying | One To Zero or More | F21523 | NO | NO | NO |