Alias: IVDGF#
(INF_CV_GLFUNDS)Table Columns#
Column name | Data Type / Size | Mand. | Notes |
---|---|---|---|
ID | Number(10) | Used internally to define a unique identification for the record. This field would not be loaded. | |
GL_FUND_CODE | Varchar2(16) | Y | |
DESCRIPTION | Varchar2(50) | ||
ENTITY_CODE | Varchar2(16) | Y | |
DEPARTMENT_CODE | Varchar2(16) | ||
DISTRIBUTION_MASK | Varchar2(50) | ||
GL_SEGMENT_NUMBER | Number(5) | ||
LEVEL_OF_SEG_TOTAL | Number(5) | ||
START_DATE | Date() | Y | |
END_DATE | Date() | ||
PROGRAM_CODE | Varchar2(16) | ||
PROGRAM_DESC | Varchar2(50) | ||
FUND_TYPE | Varchar2(30) | ||
GRANT_CODE | Varchar2(16) | ||
GRANT_TYPE | Varchar2(30) | ||
ACTIVITY_CODE | Varchar2(16) | ||
ACCOUNT_MANAGER | Varchar2(50) | ||
RESPONSIBLE_PERSON | Varchar2(50) | ||
FUND_CALC_METHOD | Varchar2(30) | ||
USER_CALC_CODE | Varchar2(16) | ||
USER_NAME | Varchar2(30) | ||
LAST_EVAL_DATE | Date() | ||
FUND_GIVEN | Number(18) | ||
FUND_ACTUAL | Number(18) | ||
FUND_BALANCE | Number(18) | ||
BALANCE_TO_COMPLETE | Number(18) | ||
BALANCE_SENT_TODATE | Number(18) | ||
FUND_ELEMENT_CODE1 | Varchar2(16) | ||
FUND_ELEMENT_TYPE1 | Varchar2(30) | ||
FUND_ELEMENT_DESCRIPTION1 | Varchar2(50) | ||
FUND_ELEMENT_AMOUNT1 | Number(18) | ||
FUND_ELEMENT_CODE2 | Varchar2(16) | ||
FUND_ELEMENT_TYPE2 | Varchar2(30) | ||
FUND_ELEMENT_DESCRIPTION2 | Varchar2(50) | ||
FUND_ELEMENT_AMOUNT2 | Number(18) | ||
FUND_ELEMENT_CODE3 | Varchar2(16) | ||
FUND_ELEMENT_TYPE3 | Varchar2(30) | ||
FUND_ELEMENT_DESCRIPTION3 | Varchar2(50) | ||
FUND_ELEMENT_AMOUNT3 | Number(18) | ||
CREATE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
CREATE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
CHANGE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
CHANGE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |