This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

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.