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