!!!Alias: IVDGF
(INF_CV_GLFUNDS)
\\


!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[GL_FUND_CODE]|Varchar2(16)|[CODE]|Y|
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[ENTITY_CODE]|Varchar2(16)|[CODE]|Y|
|[DEPARTMENT_CODE]|Varchar2(16)|[CODE]| |
|[DISTRIBUTION_MASK]|Varchar2(50)|[DISTRIBUTION]| |
|[GL_SEGMENT_NUMBER]|Number(5)|[NUMBER5|NUMBERn]| |
|[LEVEL_OF_SEG_TOTAL]|Number(5)|[NUMBER5|NUMBERn]| |
|[START_DATE]|Date()|[DATE]|Y|
|[END_DATE]|Date()|[DATE]| |
|[PROGRAM_CODE]|Varchar2(16)|[CODE]| |
|[PROGRAM_DESC]|Varchar2(50)|[DESCRIPTION]| |
|[FUND_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[GRANT_CODE]|Varchar2(16)|[CODE]| |
|[GRANT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ACTIVITY_CODE]|Varchar2(16)|[CODE]| |
|[ACCOUNT_MANAGER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[RESPONSIBLE_PERSON]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[FUND_CALC_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[USER_CALC_CODE]|Varchar2(16)|[CODE]| |
|[USER_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[LAST_EVAL_DATE]|Date()|[DATE]| |
|[FUND_GIVEN]|Number(18)|[AMT12V6|AMTnn]| |
|[FUND_ACTUAL]|Number(18)|[AMT12V6|AMTnn]| |
|[FUND_BALANCE]|Number(18)|[AMT12V6|AMTnn]| |
|[BALANCE_TO_COMPLETE]|Number(18)|[AMT12V6|AMTnn]| |
|[BALANCE_SENT_TODATE]|Number(18)|[AMT12V6|AMTnn]| |
|[FUND_ELEMENT_CODE1]|Varchar2(16)|[CODE]| |
|[FUND_ELEMENT_TYPE1]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[FUND_ELEMENT_DESCRIPTION1]|Varchar2(50)|[DESCRIPTION]| |
|[FUND_ELEMENT_AMOUNT1]|Number(18)|[AMT12V6|AMTnn]| |
|[FUND_ELEMENT_CODE2]|Varchar2(16)|[CODE]| |
|[FUND_ELEMENT_TYPE2]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[FUND_ELEMENT_DESCRIPTION2]|Varchar2(50)|[DESCRIPTION]| |
|[FUND_ELEMENT_AMOUNT2]|Number(18)|[AMT12V6|AMTnn]| |
|[FUND_ELEMENT_CODE3]|Varchar2(16)|[CODE]| |
|[FUND_ELEMENT_TYPE3]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[FUND_ELEMENT_DESCRIPTION3]|Varchar2(50)|[DESCRIPTION]| |
|[FUND_ELEMENT_AMOUNT3]|Number(18)|[AMT12V6|AMTnn]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |