Personality Knowledgebase 5.05
HighLine
Wiki
G’day (anonymous guest)
User Preferences
Log in
Register a new user!
For full search, hit enter...
Recent Searches
INF_CV_GLFUNDS
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.4 mins, 95 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVDGF
#
(INF_CV_GLFUNDS)
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
GL_FUND_CODE
Varchar2(16)
CODE
Y
DESCRIPTION
Varchar2(50)
DESCRIPTION
ENTITY_CODE
Varchar2(16)
CODE
Y
DEPARTMENT_CODE
Varchar2(16)
CODE
DISTRIBUTION_MASK
Varchar2(50)
DISTRIBUTION
GL_SEGMENT_NUMBER
Number(5)
NUMBER5
LEVEL_OF_SEG_TOTAL
Number(5)
NUMBER5
START_DATE
Date()
DATE
Y
END_DATE
Date()
DATE
PROGRAM_CODE
Varchar2(16)
CODE
PROGRAM_DESC
Varchar2(50)
DESCRIPTION
FUND_TYPE
Varchar2(30)
VARCHAR30
GRANT_CODE
Varchar2(16)
CODE
GRANT_TYPE
Varchar2(30)
VARCHAR30
ACTIVITY_CODE
Varchar2(16)
CODE
ACCOUNT_MANAGER
Varchar2(50)
VARCHAR50
RESPONSIBLE_PERSON
Varchar2(50)
VARCHAR50
FUND_CALC_METHOD
Varchar2(30)
VARCHAR30
USER_CALC_CODE
Varchar2(16)
CODE
USER_NAME
Varchar2(30)
VARCHAR30
LAST_EVAL_DATE
Date()
DATE
FUND_GIVEN
Number(18)
AMT12V6
FUND_ACTUAL
Number(18)
AMT12V6
FUND_BALANCE
Number(18)
AMT12V6
BALANCE_TO_COMPLETE
Number(18)
AMT12V6
BALANCE_SENT_TODATE
Number(18)
AMT12V6
FUND_ELEMENT_CODE1
Varchar2(16)
CODE
FUND_ELEMENT_TYPE1
Varchar2(30)
VARCHAR30
FUND_ELEMENT_DESCRIPTION1
Varchar2(50)
DESCRIPTION
FUND_ELEMENT_AMOUNT1
Number(18)
AMT12V6
FUND_ELEMENT_CODE2
Varchar2(16)
CODE
FUND_ELEMENT_TYPE2
Varchar2(30)
VARCHAR30
FUND_ELEMENT_DESCRIPTION2
Varchar2(50)
DESCRIPTION
FUND_ELEMENT_AMOUNT2
Number(18)
AMT12V6
FUND_ELEMENT_CODE3
Varchar2(16)
CODE
FUND_ELEMENT_TYPE3
Varchar2(30)
VARCHAR30
FUND_ELEMENT_DESCRIPTION3
Varchar2(50)
DESCRIPTION
FUND_ELEMENT_AMOUNT3
Number(18)
AMT12V6
CREATE_DATE
Date()
DATE
CREATE_USER
Varchar2(30)
VARCHAR30
CHANGE_DATE
Date()
DATE
CHANGE_USER
Varchar2(30)
VARCHAR30
Hello, 10.86.0.2
Index
Recent Updates
Wiki Formatting
Search Help