ACCT |
Default Table Name | ACCT |
Definition |
ACCT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
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 | ||
ACCT_ENTR_GRP_CD | VARCHAR2(6) | YES | ||
PROJ_REQD_FL | VARCHAR2(1) | NO | ||
S_ACCT_TYPE_CD![]() |
VARCHAR2(1) | YES | ||
DETL_FL | VARCHAR2(1) | YES | ||
ACCT_NAME | VARCHAR2(25) | YES | ||
TOP_FL | VARCHAR2(1) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
L1_ACCT_NAME | VARCHAR2(25) | YES | ||
L2_ACCT_NAME | VARCHAR2(25) | YES | ||
L3_ACCT_NAME | VARCHAR2(25) | YES | ||
L4_ACCT_NAME | VARCHAR2(25) | YES | ||
L5_ACCT_NAME | VARCHAR2(25) | YES | ||
L6_ACCT_NAME | VARCHAR2(25) | YES | ||
L7_ACCT_NAME | VARCHAR2(25) | YES | ||
LVL_NO | NUMBER(5, 0) | YES | ||
L1_ACCT_SEG_ID | VARCHAR2(15) | YES | ||
L2_ACCT_SEG_ID | VARCHAR2(13) | YES | ||
L3_ACCT_SEG_ID | VARCHAR2(11) | YES | ||
L4_ACCT_SEG_ID | VARCHAR2(9) | YES | ||
L5_ACCT_SEG_ID | VARCHAR2(7) | YES | ||
L6_ACCT_SEG_ID | VARCHAR2(5) | YES | ||
L7_ACCT_SEG_ID | VARCHAR2(3) | YES | ||
L8_ACCT_SEG_ID | VARCHAR2(1) | YES | ||
TC_ACCT_TYPE_CD | VARCHAR2(10) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
SFT_FL | VARCHAR2(1) | YES | ||
MES_FL | VARCHAR2(1) | YES |
ACCT Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0039 | PrimaryKey | ACCT_ID |
ACCT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
S_ACCT_TYPE | Non-Identifying | Zero or One to Zero or More | F00020 | S_ACCT_TYPE_CD | NO | NO | NO | ||
ACCTING_PD | Non-Identifying | Zero or One to Zero or More | F06400 | FY_CD_FR, PD_NO_FR | NO | NO | NO | ||
ACCTING_PD | Non-Identifying | Zero or One to Zero or More | F06401 | 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 |
ACCT_GRP_SETUP | Identifying | One To Zero or More | F00080 | NO | NO | NO | |||
DFLT_REG_TS | Non-Identifying | One To Zero or More | F00870 | NO | NO | NO | |||
DFLT_OT_TS | Non-Identifying | One To Zero or More | F00871 | NO | NO | NO | |||
FS_LN_ACCT | Identifying | One To Zero or More | F00940 | NO | NO | NO | |||
GL_CONFIG | Non-Identifying | One To Zero or More | F01040 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F01180 | NO | NO | NO | |||
INVT_SETTINGS | Non-Identifying | One To Zero or More | F01190 | NO | NO | NO | |||
LAB_SETTINGS | Non-Identifying | One To Zero or More | F02180 | NO | NO | NO | |||
LAB_SETTINGS | Non-Identifying | One To Zero or More | F02200 | NO | NO | NO | |||
LN_CHG_TYPE | Non-Identifying | Zero or One to Zero or More | F02260 | NO | NO | NO | |||
LN_CHG_TYPE | Non-Identifying | One To Zero or More | F02270 | NO | NO | NO | |||
LV_TYPE | Non-Identifying | One To Zero or More | F02340 | NO | NO | NO | |||
LV_TYPE | Non-Identifying | One To Zero or More | F02350 | NO | NO | NO | |||
ORG_ACCT | Identifying | One To Zero or More | F02410 | NO | NO | NO | |||
CONS_EQTY_ACCT_OVD | Identifying | One To Zero or More | F04741 | NO | NO | NO | |||
WD_FRNG_HANDLING | Non-Identifying | One To Zero or More | F05380 | NO | NO | NO | |||
REF_BUD | Identifying | One To Zero or More | F06100 | NO | NO | NO | |||
CEIL_DIR_CST | Identifying | One To Zero or More | F07003 | NO | NO | NO | |||
VCHR_SETTINGS | Non-Identifying | Zero or One to Zero or More | F07055 | NO | NO | NO | |||
OVRIDE_FEE_ON_DIR | Identifying | One To Zero or More | F08090 | NO | NO | NO | |||
REF_SUM | Identifying | One To Zero or More | F08278 | NO | NO | NO | |||
DED_CD | Non-Identifying | One To Zero or More | F08341 | NO | NO | NO | |||
DED_CD | Non-Identifying | One To Zero or More | F08346 | NO | NO | NO | |||
DED_CD | Non-Identifying | One To Zero or More | F08349 | NO | NO | NO | |||
LOCALITY | Non-Identifying | One To Zero or More | F08360 | NO | NO | NO | |||
STATE_TAX_INFO | Non-Identifying | One To Zero or More | F08620 | NO | NO | NO | |||
STATE_TAX_INFO | Non-Identifying | One To Zero or More | F08621 | NO | NO | NO | |||
STATE_TAX_INFO | Non-Identifying | One To Zero or More | F08622 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08660 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08661 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08662 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08663 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08664 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08665 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08666 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08667 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | Zero or One to Zero or More | F08668 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08669 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08670 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08671 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F08697 | NO | NO | NO | |||
PROJ_CASH_BASIS | Identifying | One To Zero or More | F09153 | NO | NO | NO | |||
OT_PREM_RECAST | Non-Identifying | One To Zero or More | F09770 | NO | NO | NO | |||
VEND_EXP_ACCT | Non-Identifying | One To Zero or More | F09820 | NO | NO | NO | |||
GL_CONFIG | Non-Identifying | One To Zero or More | F09831 | NO | NO | NO | |||
FS_LN | Non-Identifying | One To Zero or More | F09851 | NO | NO | NO | |||
FS_LN | Non-Identifying | One To Zero or More | F09852 | NO | NO | NO | |||
POOL_ALLOC | Non-Identifying | One To Zero or More | F09853 | NO | NO | NO | |||
POOL_ALLOC | Non-Identifying | One To Zero or More | F09854 | NO | NO | NO | |||
ASSET_ACCT | Identifying | One To Zero or More | F09935 | NO | NO | NO | |||
GL_CONFIG | Non-Identifying | One To Zero or More | F10001 | NO | NO | NO | |||
BL_SALES_TAX_ACCT | Identifying | One To Zero or More | F10122 | NO | NO | NO | |||
PROJ_ALLOC_QTYBASE | Non-Identifying | One To Zero or More | F10133 | NO | NO | NO | |||
BILLING_ACCTS | Identifying | One To Zero or More | F20507 | NO | NO | NO | |||
BILL_OTH_CHGS | Non-Identifying | One To Zero or More | F20519 | NO | NO | NO | |||
AR_HDR_HS | Non-Identifying | One To Zero or More | F20543 | NO | NO | NO | |||
AR_HDR_HS | Non-Identifying | Zero or One to Zero or More | F20544 | NO | NO | NO | |||
PROJ_LN_ITEM_BUD | Identifying | One To Zero or More | F20556 | NO | NO | NO | |||
TVL_ADV_TYPE | Non-Identifying | One To Zero or More | F20562 | NO | NO | NO | |||
BILL_SCHEDULE | Non-Identifying | One To Zero or More | F20746 | NO | NO | NO | |||
HB_SETTINGS | Non-Identifying | One To Zero or More | F20988 | NO | NO | NO | |||
MULTI_CO_ST_OVRD | Non-Identifying | One To Zero or More | F21008 | NO | NO | NO | |||
MULTI_CO_ST_OVRD | Non-Identifying | One To Zero or More | F21009 | NO | NO | NO | |||
MULTI_CO_ST_OVRD | Non-Identifying | One To Zero or More | F21010 | NO | NO | NO | |||
MULTI_CO_LOC_OVRD | Non-Identifying | One To Zero or More | F21012 | NO | NO | NO | |||
EMPL_TS_LN_TYPE_DF | Non-Identifying | One To Zero or More | F21075 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21119 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21121 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21123 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21125 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21127 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21129 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21131 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21133 | NO | NO | NO | |||
TS_LN_TYPE_DFLT | Non-Identifying | One To Zero or More | F21135 | NO | NO | NO | |||
PROJ_XFER_ACCT | Identifying | One To Zero or More | F21140 | NO | NO | NO | |||
PROJ_XFER_ACCT | Non-Identifying | One To Zero or More | F21141 | NO | NO | NO | |||
PROJ_XFER_ACCT | Non-Identifying | One To Zero or More | F21142 | NO | NO | NO | |||
OVRIDE_MLT_ON_DIR | Identifying | One To Zero or More | F21160 | NO | NO | NO | |||
OVRIDE_MLT_ON_DIR | Non-Identifying | One To Zero or More | F21161 | NO | NO | NO | |||
ALLOWANCE_CD | Non-Identifying | One To Zero or More | F21266 | NO | NO | NO | |||
EMPL_ALLOW_CD | Non-Identifying | One To Zero or More | F21273 | NO | NO | NO | |||
EXP_ACCRL_SETTINGS | Non-Identifying | One To Zero or More | F21285 | NO | NO | NO | |||
UNION_PROFLE_FRNG | Non-Identifying | One To Zero or More | F21340 | NO | NO | NO | |||
UNION_PROFLE_FRNG | Non-Identifying | One To Zero or More | F21341 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F21372 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F21373 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | One To Zero or More | F21374 | NO | NO | NO | |||
PR_SETTINGS | Non-Identifying | Zero or One to Zero or More | F21375 | NO | NO | NO | |||
STATE_TAX_INFO | Non-Identifying | One To Zero or More | F21376 | NO | NO | NO | |||
MULTI_CO_ST_OVRD | Non-Identifying | One To Zero or More | F21377 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21597 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21598 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21599 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21600 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21601 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21602 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21603 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21604 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21605 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21606 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21607 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21608 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21609 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21610 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21611 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21612 | NO | NO | NO | |||
FED_ACCT_OVRD | Non-Identifying | One To Zero or More | F21613 | NO | NO | NO | |||
BSRV_EQTY_ACCT_OVD | Identifying | One To Zero or More | F21635 | NO | NO | NO | |||
CFT_TMPLT_LN_ACCT | Identifying | One To Zero or More | F21652 | NO | NO | NO | |||
CFT_CASH_ACCTS | Identifying | One To Zero or More | F21653 | NO | NO | NO | |||
ACCR_SAL_OVRD | Non-Identifying | One To Zero or More | FK_ACCR_SAL_OVRD_OV_IDX | NO | NO | NO | |||
H_POS_RQ_RQST | Non-Identifying | One To Zero or More | FK_H_POS_RQ_RQST_DFAC_IDX | NO | NO | NO | |||
HS_CEIL_DIR_CST | Identifying | One To Zero or More | FK_HS_CEIL_DIR_CST_AC_IDX | NO | NO | NO | |||
HS_OVRIDE_FEE_ON_DIR | Identifying | One To Zero or More | FK_HS_OVRIDE_FEE_ON_DIR_AC_IDX | NO | NO | NO | |||
HS_OVRIDE_MLT_ON_DIR | Non-Identifying | One To Zero or More | FK_HS_OVRIDE_MLT_ON_DIR_EN_IDX | NO | NO | NO | |||
HS_OVRIDE_MLT_ON_DIR | Identifying | One To Zero or More | FK_HS_OVRIDE_MLT_ON_DIR_SA_IDX | NO | NO | NO | |||
LV_TYPE_CUR | Non-Identifying | One To Zero or More | FK_LV_TYPE_CUR_AC_IDX | NO | NO | NO | |||
LV_TYPE_CUR | Non-Identifying | One To Zero or More | FK_LV_TYPE_CUR_EX_IDX | NO | NO | NO | |||
OPERATION_ACCT_DFLT | Non-Identifying | One To Zero or More | FK_OPERATION_ACCT_DFLT_AC_IDX | NO | NO | NO |