Alias: IVDGF#

(INF_CV_GLFUNDS)

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
GL_FUND_CODEVarchar2(16)CODEY
DESCRIPTIONVarchar2(50)DESCRIPTION
ENTITY_CODEVarchar2(16)CODEY
DEPARTMENT_CODEVarchar2(16)CODE
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
GL_SEGMENT_NUMBERNumber(5)NUMBER5
LEVEL_OF_SEG_TOTALNumber(5)NUMBER5
START_DATEDate()DATEY
END_DATEDate()DATE
PROGRAM_CODEVarchar2(16)CODE
PROGRAM_DESCVarchar2(50)DESCRIPTION
FUND_TYPEVarchar2(30)VARCHAR30
GRANT_CODEVarchar2(16)CODE
GRANT_TYPEVarchar2(30)VARCHAR30
ACTIVITY_CODEVarchar2(16)CODE
ACCOUNT_MANAGERVarchar2(50)VARCHAR50
RESPONSIBLE_PERSONVarchar2(50)VARCHAR50
FUND_CALC_METHODVarchar2(30)VARCHAR30
USER_CALC_CODEVarchar2(16)CODE
USER_NAMEVarchar2(30)VARCHAR30
LAST_EVAL_DATEDate()DATE
FUND_GIVENNumber(18)AMT12V6
FUND_ACTUALNumber(18)AMT12V6
FUND_BALANCENumber(18)AMT12V6
BALANCE_TO_COMPLETENumber(18)AMT12V6
BALANCE_SENT_TODATENumber(18)AMT12V6
FUND_ELEMENT_CODE1Varchar2(16)CODE
FUND_ELEMENT_TYPE1Varchar2(30)VARCHAR30
FUND_ELEMENT_DESCRIPTION1Varchar2(50)DESCRIPTION
FUND_ELEMENT_AMOUNT1Number(18)AMT12V6
FUND_ELEMENT_CODE2Varchar2(16)CODE
FUND_ELEMENT_TYPE2Varchar2(30)VARCHAR30
FUND_ELEMENT_DESCRIPTION2Varchar2(50)DESCRIPTION
FUND_ELEMENT_AMOUNT2Number(18)AMT12V6
FUND_ELEMENT_CODE3Varchar2(16)CODE
FUND_ELEMENT_TYPE3Varchar2(30)VARCHAR30
FUND_ELEMENT_DESCRIPTION3Varchar2(50)DESCRIPTION
FUND_ELEMENT_AMOUNT3Number(18)AMT12V6
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30