[{TableOfContents }] !!!JOURNAL ENTRIES INTERFACE FILE The Journal Entries Interface File screen is used to import historical employee payroll information at a disbursement level into the software data structures. Disbursements Interface File data is maintained on the [INF_CV_DISBURSEMENTS] table. ;[ID|ID]:This field uniquely identifies the disbursement record within the data base. !!!Alias: [IVPJE] (INF_CV_JOURNALENTRIES) \\ Journal Entries !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[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'}] }]