[{TableOfContents }] !!!JOURNAL ENTRIES INTERFACE FILE The Journal Entries Interface File screen is used to import journal entries into the software data structures. Journal Entries Interface File data is maintained on the [INF_CV_JOURNALENTRIES] table. ;[ID|ID]:This field uniquely identifies the journal entries record within the data base. |[GL_COMPANY_CODE]|Varchar2(16)|Y| |[CALENDAR_PERIOD]|Number(10)|Y| |[GL_ACCOUNT_CODE]|Varchar2(16)|Y| |[DISTRIBUTION_CODE]|Varchar2(50)|Y| |[GL_EFFECTIVE_DATE]|Date()| | |[GLPOST_NUMBER]|Number(10)| | |[GLPOST_SEQUENCE]|Number(5)| | |[TRIAL_JOURNAL]|Varchar2(4)| | |[PERSON_CODE]|Varchar2(16)| | |[PAY_NUMBER]|Number(5)| | |[PC_CODE]|Varchar2(4)| | |[GL_AMOUNT]|Number(18)| | |[SPLIT_PERCENT]|Number(5)| | |[GL_DETAIL_SEQUENCE]|Number(5)| | |[WORK_ORDER]|Varchar2(50)| | |[GL_POINTER]|Varchar2(30)| | |[GL_FUND_CODE]|Varchar2(16)| | |[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IVPJE] [{InsertPage page='Internal.IVPJE' default='Click to create a new discussion page'}] }]