Model STVDEPT
| Object Name | Object Type | Layer Name |
|---|---|---|
| ADBDESG | TABLE | ERD |
| APRADEG | TABLE | ERD |
| GTVEMPH | TABLE | ERD |
| SARADAP | TABLE | ERD |
| SARQKER | TABLE | ERD |
| SARWADF | TABLE | ERD |
| SCBCDEP | TABLE | ERD |
| SCBCDTL | TABLE | ERD |
| SCBCRSE | TABLE | ERD |
| SCRCDTX | TABLE | ERD |
| SFRRGFE | TABLE | ERD |
| SGBSTDN | TABLE | ERD |
| SGRASSI | TABLE | ERD |
| SHBCOMI | TABLE | ERD |
| SHBGSCH | TABLE | ERD |
| SHRCOMM | TABLE | ERD |
| SHRDGMR | TABLE | ERD |
| SHRTCKN | TABLE | ERD |
| SIRDPCL | TABLE | ERD |
| SIRNIST | TABLE | ERD |
| SIRNLVA | TABLE | ERD |
| SMRACAA | TABLE | ERD |
| SMRAQUA | TABLE | ERD |
| SMRAREX | TABLE | ERD |
| SMRARSA | TABLE | ERD |
| SMRARUL | TABLE | ERD |
| SMRGCAA | TABLE | ERD |
| SMRGREX | TABLE | ERD |
| SMRGRSA | TABLE | ERD |
| SMRGRUL | TABLE | ERD |
| SMRIEDP | TABLE | ERD |
| SMRPCRS | TABLE | ERD |
| SMRPRSA | TABLE | ERD |
| SMRRQCM | TABLE | ERD |
| SMRSACA | TABLE | ERD |
| SMRSARE | TABLE | ERD |
| SMRSARS | TABLE | ERD |
| SMRSARU | TABLE | ERD |
| SMRSGCA | TABLE | ERD |
| SMRSGRE | TABLE | ERD |
| SMRSGRS | TABLE | ERD |
| SMRSGRU | TABLE | ERD |
| SMRSPRS | TABLE | ERD |
| SOBODTE | TABLE | ERD |
| SORCMJR | TABLE | ERD |
| SORCOMM | TABLE | ERD |
| SOREXTN | TABLE | ERD |
| SORLFOS | TABLE | ERD |
| SORMDPT | TABLE | ERD |
| SORRFND | TABLE | ERD |
| SORRSTS | TABLE | ERD |
| SRBPRED | TABLE | ERD |
| SRBRECR | TABLE | ERD |
| SRTPREL | TABLE | ERD |
| SSBDFEE | TABLE | ERD |
| SSBOVRR | TABLE | ERD |
| STVDEPT | TABLE | Tables |

Table ADBDESG
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| ADBDESG_DESG | ADBDESG_DESG | VARCHAR2(10) | No | * | * |
| ADBDESG_NAME | ADBDESG_NAME | VARCHAR2(60) | No | ||
| ADBDESG_GL_NO_CREDIT | ADBDESG_GL_NO_CREDIT | VARCHAR2(60) | Yes | ||
| ADBDESG_GL_NO_DEBIT | ADBDESG_GL_NO_DEBIT | VARCHAR2(60) | Yes | ||
| ADBDESG_RESTR_IND | ADBDESG_RESTR_IND | VARCHAR2(1) | No | ||
| ADBDESG_COLL_CODE | ADBDESG_COLL_CODE | VARCHAR2(2) | Yes | * | |
| ADBDESG_CMTP_CODE | ADBDESG_CMTP_CODE | VARCHAR2(2) | Yes | * | |
| ADBDESG_CFAE_CODE | ADBDESG_CFAE_CODE | VARCHAR2(5) | No | * | |
| ADBDESG_AMT_PLEDGED | ADBDESG_AMT_PLEDGED | NUMBER(13,2) | Yes | ||
| ADBDESG_AMT_PLEDGED_PAID | ADBDESG_AMT_PLEDGED_PAID | NUMBER(13,2) | Yes | ||
| ADBDESG_AMT_GIFT | ADBDESG_AMT_GIFT | NUMBER(13,2) | Yes | ||
| ADBDESG_ACTIVITY_DATE | ADBDESG_ACTIVITY_DATE | DATE | No | ||
| ADBDESG_COAS_CODE | ADBDESG_COAS_CODE | VARCHAR2(1) | Yes | ||
| ADBDESG_ACCI_CODE | ADBDESG_ACCI_CODE | VARCHAR2(6) | Yes | ||
| ADBDESG_FUND_CODE | ADBDESG_FUND_CODE | VARCHAR2(6) | Yes | ||
| ADBDESG_ORGN_CODE | ADBDESG_ORGN_CODE | VARCHAR2(6) | Yes | ||
| ADBDESG_ACCT_CODE | ADBDESG_ACCT_CODE | VARCHAR2(6) | Yes | ||
| ADBDESG_PROG_CODE | ADBDESG_PROG_CODE | VARCHAR2(6) | Yes | ||
| ADBDESG_ACTV_CODE | ADBDESG_ACTV_CODE | VARCHAR2(6) | Yes | ||
| ADBDESG_LOCN_CODE | ADBDESG_LOCN_CODE | VARCHAR2(6) | Yes | ||
| ADBDESG_DSTP_CODE | ADBDESG_DSTP_CODE | VARCHAR2(5) | No | * | |
| ADBDESG_COAS_CODE_PLDG | ADBDESG_COAS_CODE_PLDG | VARCHAR2(1) | Yes | ||
| ADBDESG_ACCI_CODE_PLDG | ADBDESG_ACCI_CODE_PLDG | VARCHAR2(6) | Yes | ||
| ADBDESG_FUND_CODE_PLDG | ADBDESG_FUND_CODE_PLDG | VARCHAR2(6) | Yes | ||
| ADBDESG_ORGN_CODE_PLDG | ADBDESG_ORGN_CODE_PLDG | VARCHAR2(6) | Yes | ||
| ADBDESG_ACCT_CODE_PLDG | ADBDESG_ACCT_CODE_PLDG | VARCHAR2(6) | Yes | ||
| ADBDESG_PROG_CODE_PLDG | ADBDESG_PROG_CODE_PLDG | VARCHAR2(6) | Yes | ||
| ADBDESG_ACTV_CODE_PLDG | ADBDESG_ACTV_CODE_PLDG | VARCHAR2(6) | Yes | ||
| ADBDESG_LOCN_CODE_PLDG | ADBDESG_LOCN_CODE_PLDG | VARCHAR2(6) | Yes | ||
| ADBDESG_GL_NO_CREDIT_PLDG | ADBDESG_GL_NO_CREDIT_PLDG | VARCHAR2(60) | Yes | ||
| ADBDESG_USER | ADBDESG_USER | VARCHAR2(30) | No | ||
| ADBDESG_START_DATE | ADBDESG_START_DATE | DATE | Yes | ||
| ADBDESG_END_DATE | ADBDESG_END_DATE | DATE | Yes | ||
| ADBDESG_DSTA_CODE | ADBDESG_DSTA_CODE | VARCHAR2(1) | Yes | * | |
| ADBDESG_DGRP_CODE | ADBDESG_DGRP_CODE | VARCHAR2(5) | Yes | * | |
| ADBDESG_DEPT_CODE | ADBDESG_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| ADBDESG_COAS_CODE_EXPND | ADBDESG_COAS_CODE_EXPND | VARCHAR2(1) | Yes | ||
| ADBDESG_ACCI_CODE_EXPND | ADBDESG_ACCI_CODE_EXPND | VARCHAR2(6) | Yes | ||
| ADBDESG_FUND_CODE_EXPND | ADBDESG_FUND_CODE_EXPND | VARCHAR2(6) | Yes | ||
| ADBDESG_ORGN_CODE_EXPND | ADBDESG_ORGN_CODE_EXPND | VARCHAR2(6) | Yes | ||
| ADBDESG_ACCT_CODE_EXPND | ADBDESG_ACCT_CODE_EXPND | VARCHAR2(6) | Yes | ||
| ADBDESG_PROG_CODE_EXPND | ADBDESG_PROG_CODE_EXPND | VARCHAR2(6) | Yes | ||
| ADBDESG_ACTV_CODE_EXPND | ADBDESG_ACTV_CODE_EXPND | VARCHAR2(6) | Yes | ||
| ADBDESG_LOCN_CODE_EXPND | ADBDESG_LOCN_CODE_EXPND | VARCHAR2(6) | Yes | ||
| ADBDESG_GL_NO_CREDIT_EXPND | ADBDESG_GL_NO_CREDIT_EXPND | VARCHAR2(60) | Yes | ||
| ADBDESG_COAS_CODE_PYMNT | ADBDESG_COAS_CODE_PYMNT | VARCHAR2(1) | Yes | ||
| ADBDESG_ACCI_CODE_PYMNT | ADBDESG_ACCI_CODE_PYMNT | VARCHAR2(6) | Yes | ||
| ADBDESG_FUND_CODE_PYMNT | ADBDESG_FUND_CODE_PYMNT | VARCHAR2(6) | Yes | ||
| ADBDESG_ORGN_CODE_PYMNT | ADBDESG_ORGN_CODE_PYMNT | VARCHAR2(6) | Yes | ||
| ADBDESG_ACCT_CODE_PYMNT | ADBDESG_ACCT_CODE_PYMNT | VARCHAR2(6) | Yes | ||
| ADBDESG_PROG_CODE_PYMNT | ADBDESG_PROG_CODE_PYMNT | VARCHAR2(6) | Yes | ||
| ADBDESG_ACTV_CODE_PYMNT | ADBDESG_ACTV_CODE_PYMNT | VARCHAR2(6) | Yes | ||
| ADBDESG_LOCN_CODE_PYMNT | ADBDESG_LOCN_CODE_PYMNT | VARCHAR2(6) | Yes | ||
| ADBDESG_GL_NO_CREDIT_PYMNT | ADBDESG_GL_NO_CREDIT_PYMNT | VARCHAR2(60) | Yes | ||
| ADBDESG_WEB_GIFT_IND | ADBDESG_WEB_GIFT_IND | VARCHAR2(1) | Yes | ||
| ADBDESG_WEB_PLDG_IND | ADBDESG_WEB_PLDG_IND | VARCHAR2(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| ADBDESG_CFAE_CODE | ATVCFAE_CODE | ATVCFAE |
| ADBDESG_CMTP_CODE | ATVCMTP_CODE | ATVCMTP |
| ADBDESG_DGRP_CODE | ATVDGRP_CODE | ATVDGRP |
| ADBDESG_DSTA_CODE | ATVDSTA_CODE | ATVDSTA |
| ADBDESG_DSTP_CODE | ATVDSTP_CODE | ATVDSTP |
| ADBDESG_COLL_CODE | STVCOLL_CODE | STVCOLL |
| ADBDESG_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| ADBDESG_DESG | AGRGDES_DESG | AGRGDES |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_ADBDESG | Unique | ADBDESG_DESG |