Table of Contents
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
- 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. |
