ORG_ACCT |
Default Table Name | ORG_ACCT |
Definition |
ORG_ACCT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ORG_ID![]() |
VARCHAR2(20) | NO | ||
ACCT_ID![]() |
VARCHAR2(15) | 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 | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
RQ_APPR_PROC_CD | VARCHAR2(8) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
ORG_ACCT Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0060 | PrimaryKey | ORG_ID, ACCT_ID |
ORG_ACCT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
ACCT | Identifying | One To Zero or More | F02410 | ACCT_ID | NO | NO | NO | ||
ORG | Identifying | One To Zero or More | F02420 | ORG_ID | NO | NO | NO | ||
ACCTING_PD | Non-Identifying | Zero or One to Zero or More | F06438 | FY_CD_FR, PD_NO_FR | NO | NO | NO | ||
ACCTING_PD | Non-Identifying | Zero or One to Zero or More | F06439 | 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 |
BUYER_ORG_ACCT | Identifying | One To Zero or More | F00460 | NO | NO | NO | |||
DFLT_OT_TS | Non-Identifying | One To Zero or More | F00851 | NO | NO | NO | |||
IC_ORG_ACCT_REL | Identifying | One To Zero or More | F01050 | NO | NO | NO | |||
IC_ORG_ACCT_REL | Identifying | One To Zero or More | F01060 | NO | NO | NO | |||
INVT_TRN_LN | Non-Identifying | One To Zero or More | F01440 | NO | NO | NO | |||
JE_TRN | Non-Identifying | One To Zero or More | F01940 | NO | NO | NO | |||
ORG_ACCT_REF_STRUC | Identifying | One To Zero or More | F02450 | NO | NO | NO | |||
POOL_ALLOC | Non-Identifying | One To Zero or More | F02770 | NO | NO | NO | |||
POOL_BASE_ACCT | Identifying | One To Zero or More | F02860 | NO | NO | NO | |||
POOL_BASE_ACCT | Non-Identifying | One To Zero or More | F02870 | NO | NO | NO | |||
POOL_BASE_ACCT | Non-Identifying | One To Zero or More | F02880 | NO | NO | NO | |||
POOL_BASE_ACCT | Non-Identifying | One To Zero or More | F03030 | NO | NO | NO | |||
POOL_COST_ACCT | Identifying | One To Zero or More | F03070 | NO | NO | NO | |||
PO_LN_ACCT | Non-Identifying | One To Zero or More | F03430 | NO | NO | NO | |||
PROJ_ORG_ACCT | Identifying | One To Zero or More | F04050 | NO | NO | NO | |||
RES_HDR | Non-Identifying | One To Zero or More | F04450 | NO | NO | NO | |||
TS_LN | Non-Identifying | One To Zero or More | F04930 | NO | NO | NO | |||
WD_FRNG_HANDLING | Non-Identifying | One To Zero or More | F05390 | NO | NO | NO | |||
ORG_ACCT_BUD | Identifying | One To Zero or More | F05570 | NO | NO | NO | |||
SALES_TAX_ACCT | Non-Identifying | One To Zero or More | F06220 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06245 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06260 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06280 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06300 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06310 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06320 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06340 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06360 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06380 | NO | NO | NO | |||
INVT_ABBRV_CD | Non-Identifying | One To Zero or More | F06390 | NO | NO | NO | |||
AR_DFLT_ACCT | Non-Identifying | One To Zero or More | F06402 | NO | NO | NO | |||
FA_SETTINGS | Non-Identifying | One To Zero or More | F06422 | NO | NO | NO | |||
POOL_INFO | Non-Identifying | Zero or One to Zero or More | F06448 | NO | NO | NO | |||
POOL_INFO | Non-Identifying | One To Zero or More | F06449 | NO | NO | NO | |||
DFLT_AP_ACCTS | Non-Identifying | One To Zero or More | F07004 | NO | NO | NO | |||
DFLT_CASH_ACCTS | Non-Identifying | One To Zero or More | F07007 | NO | NO | NO | |||
VCHR_LN_ACCT | Non-Identifying | One To Zero or More | F07042 | NO | NO | NO | |||
AR_TRNSF_ACCT | Non-Identifying | One To Zero or More | F08096 | NO | NO | NO | |||
CUST_DFLT_ACCT | Non-Identifying | One To Zero or More | F08112 | NO | NO | NO | |||
FS_SUM | Identifying | One To Zero or More | F08136 | NO | NO | NO | |||
CASH_RECPT_TRN | Non-Identifying | One To Zero or More | F08179 | NO | NO | NO | |||
ETC_DIR_CST | Identifying | One To Zero or More | F08186 | NO | NO | NO | |||
PROJ_BUD_DIR | Non-Identifying | One To Zero or More | F08199 | NO | NO | NO | |||
PROJ_TOT_BUD_DIR | Identifying | One To Zero or More | F08217 | NO | NO | NO | |||
VCHR_HDR | Non-Identifying | One To Zero or More | F08271 | NO | NO | NO | |||
VCHR_HDR | Non-Identifying | One To Zero or More | F08272 | NO | NO | NO | |||
UNITS_USAGE_LN | Non-Identifying | One To Zero or More | F09041 | NO | NO | NO | |||
VEND_CHK | Identifying | One To Zero or More | F09180 | NO | NO | NO | |||
PRICE_CATLG_ACCTS | Non-Identifying | One To Zero or More | F09267 | NO | NO | NO | |||
PROD_CATLG_ACCTS | Non-Identifying | One To Zero or More | F09280 | NO | NO | NO | |||
PROJ_CLIN_ACCTS | Non-Identifying | One To Zero or More | F09310 | NO | NO | NO | |||
CLIN_PROD_ACCTS | Non-Identifying | One To Zero or More | F09316 | NO | NO | NO | |||
ALLOC_BASIS_JNL | Non-Identifying | One To Zero or More | F09361 | NO | NO | NO | |||
VEND_RTRN_LN_ACCT | Non-Identifying | One To Zero or More | F09405 | NO | NO | NO | |||
ACCUM_DEPR_ACCT | Non-Identifying | One To Zero or More | F09521 | NO | NO | NO | |||
DEPR_EXP_ALC_ACCT | Non-Identifying | One To Zero or More | F09529 | NO | NO | NO | |||
FA_TEMPLATE | Non-Identifying | One To Zero or More | F09771 | NO | NO | NO | |||
ICR_TRN | Non-Identifying | One To Zero or More | F09801 | NO | NO | NO | |||
RQ_LN_ACCT | Non-Identifying | One To Zero or More | F09804 | NO | NO | NO | |||
POOL_BASE_WILDCARD | Non-Identifying | One To Zero or More | F09806 | NO | NO | NO | |||
POOL_BASE_WILDCARD | Non-Identifying | One To Zero or More | F09807 | NO | NO | NO | |||
POOL_BASE_WILDCARD | Non-Identifying | One To Zero or More | F09808 | NO | NO | NO | |||
TVL_ADV_LN | Non-Identifying | One To Zero or More | F09879 | NO | NO | NO | |||
TVL_EXP_LN | Non-Identifying | One To Zero or More | F09901 | NO | NO | NO | |||
TVL_ADV_LN_HS | Non-Identifying | One To Zero or More | F09911 | NO | NO | NO | |||
CO_EXP_LN | Non-Identifying | One To Zero or More | F09940 | NO | NO | NO | |||
TVL_EXP_LN_HS | Non-Identifying | One To Zero or More | F09951 | NO | NO | NO | |||
CO_EXP_LN_HS | Non-Identifying | One To Zero or More | F09963 | NO | NO | NO | |||
CO_PAID_MATCH | Non-Identifying | One To Zero or More | F09990 | NO | NO | NO | |||
FA_DISP_EDIT | Non-Identifying | One To Zero or More | F10007 | NO | NO | NO | |||
NASA_FM_LN_ACCT | Non-Identifying | One To Zero or More | F10014 | NO | NO | NO | |||
SO_HDR | Non-Identifying | One To Zero or More | F10070 | NO | NO | NO | |||
PROJ_ALLOC | Non-Identifying | One To Zero or More | F10128 | NO | NO | NO | |||
PROJ_ALLOC_QTYBASE | Non-Identifying | One To Zero or More | F10134 | NO | NO | NO | |||
PROJ_ALLOC_PCTBASE | Non-Identifying | One To Zero or More | F10137 | NO | NO | NO | |||
PROJ_ALLOC_HS | Non-Identifying | One To Zero or More | F10141 | NO | NO | NO | |||
SO_INVC_HDR | Non-Identifying | One To Zero or More | F10148 | NO | NO | NO | |||
ASSET | Non-Identifying | One To Zero or More | F20204 | NO | NO | NO | |||
BANK_GL_CASH_ACCT | Non-Identifying | One To Zero or More | F20344 | NO | NO | NO | |||
CO_EXP_HDR | Non-Identifying | One To Zero or More | F20356 | NO | NO | NO | |||
CO_EXP_HDR | Non-Identifying | One To Zero or More | F20357 | NO | NO | NO | |||
TVL_ADV_HDR | Non-Identifying | One To Zero or More | F20363 | NO | NO | NO | |||
TVL_ADV_HDR | Non-Identifying | One To Zero or More | F20364 | NO | NO | NO | |||
TVL_EXP_HDR | Non-Identifying | One To Zero or More | F20369 | NO | NO | NO | |||
TVL_EXP_HDR | Non-Identifying | One To Zero or More | F20370 | NO | NO | NO | |||
SUBCTR_PRG_PMT | Non-Identifying | One To Zero or More | F20378 | NO | NO | NO | |||
SO_HDR | Non-Identifying | One To Zero or More | F20508 | NO | NO | NO | |||
SO_INVC_HDR | Non-Identifying | One To Zero or More | F20512 | NO | NO | NO | |||
TVL_ACCT_CD_ACCTS | Non-Identifying | One To Zero or More | F20593 | NO | NO | NO | |||
POOL_VAR_ACCT | Non-Identifying | One To Zero or More | F20604 | NO | NO | NO | |||
POOL_VAR_ACCT | Non-Identifying | One To Zero or More | F20605 | NO | NO | NO | |||
POOL_VAR_ACCT | Identifying | One To Zero or More | F20606 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20794 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20795 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20796 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20798 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20799 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20800 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20801 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20802 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20803 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20804 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F20805 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20811 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20812 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20814 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20815 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20816 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20817 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20818 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20819 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20820 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20821 | NO | NO | NO | |||
INVT_BURD_SUM | Identifying | One To Zero or More | F20845 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F20962 | NO | NO | NO | |||
FA_PRJTD_PURCHASE | Non-Identifying | One To Zero or More | F21178 | NO | NO | NO | |||
CREW_TS_LN | Non-Identifying | One To Zero or More | F21317 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F21458 | NO | NO | NO | |||
INVT_PROJ | Non-Identifying | One To Zero or More | F21459 | NO | NO | NO | |||
FA_DEPR_HS | Non-Identifying | One To Zero or More | F21520 | NO | NO | NO | |||
INVT_BURD_SUM_DETL | Identifying | One To Zero or More | F21692 | NO | NO | NO | |||
RQ_TYPE | Non-Identifying | One To Zero or More | F21694 | NO | NO | NO |