[{TableOfContents }] !!!GL FUNDS INTERFACE FILE The GL Funds Interface File screen is used to import GL Fund codes into the software data structures. Department Interface File data is maintained on the [INF_CV_GLFUNDS] table. ;[|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)| | [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IVDGF] [{InsertPage page='Internal.IVDGF' default='Click to create a new discussion page'}] }]