INF_CV_GLFUNDS
Back to current versionRestore this version

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation