INF_CV_GLFUNDS
Back to current versionRestore this version

Alias: IVDGF#

(INF_CV_GLFUNDS)

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
GL_FUND_CODEVarchar2(16)Y
DESCRIPTIONVarchar2(50)
ENTITY_CODEVarchar2(16)Y
DEPARTMENT_CODEVarchar2(16)
DISTRIBUTION_MASKVarchar2(50)
GL_SEGMENT_NUMBERNumber(5)
LEVEL_OF_SEG_TOTALNumber(5)
START_DATEDate()Y
END_DATEDate()
PROGRAM_CODEVarchar2(16)
PROGRAM_DESCVarchar2(50)
FUND_TYPEVarchar2(30)
GRANT_CODEVarchar2(16)
GRANT_TYPEVarchar2(30)
ACTIVITY_CODEVarchar2(16)
ACCOUNT_MANAGERVarchar2(50)
RESPONSIBLE_PERSONVarchar2(50)
FUND_CALC_METHODVarchar2(30)
USER_CALC_CODEVarchar2(16)
USER_NAMEVarchar2(30)
LAST_EVAL_DATEDate()
FUND_GIVENNumber(18)
FUND_ACTUALNumber(18)
FUND_BALANCENumber(18)
BALANCE_TO_COMPLETENumber(18)
BALANCE_SENT_TODATENumber(18)
FUND_ELEMENT_CODE1Varchar2(16)
FUND_ELEMENT_TYPE1Varchar2(30)
FUND_ELEMENT_DESCRIPTION1Varchar2(50)
FUND_ELEMENT_AMOUNT1Number(18)
FUND_ELEMENT_CODE2Varchar2(16)
FUND_ELEMENT_TYPE2Varchar2(30)
FUND_ELEMENT_DESCRIPTION2Varchar2(50)
FUND_ELEMENT_AMOUNT2Number(18)
FUND_ELEMENT_CODE3Varchar2(16)
FUND_ELEMENT_TYPE3Varchar2(30)
FUND_ELEMENT_DESCRIPTION3Varchar2(50)
FUND_ELEMENT_AMOUNT3Number(18)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.