Alias: IVPJE#

(INF_CV_JOURNALENTRIES)

Journal Entries

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
GL_COMPANY_CODEVarchar2(16)Y
CALENDAR_PERIODNumber(10)Y
GL_ACCOUNT_CODEVarchar2(16)Y
DISTRIBUTION_CODEVarchar2(50)Y
GL_EFFECTIVE_DATEDate()
GLPOST_NUMBERNumber(10)
GLPOST_SEQUENCENumber(5)
TRIAL_JOURNALVarchar2(4)
PERSON_CODEVarchar2(16)
PAY_NUMBERNumber(5)
PC_CODEVarchar2(4)
GL_AMOUNTNumber(18)
SPLIT_PERCENTNumber(5)
GL_DETAIL_SEQUENCENumber(5)
WORK_ORDERVarchar2(50)
GL_POINTERVarchar2(30)
GL_FUND_CODEVarchar2(16)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.


Notes #

Click to create a new notes page