Alias: IVPJE#
(INF_CV_JOURNALENTRIES)Journal Entries
Table Columns#
Column name | Data Type / Size | Domain | Mand. | Notes |
---|---|---|---|---|
ID | Number(10) | ID | ||
GL_COMPANY_CODE | Varchar2(16) | CODE | Y | |
CALENDAR_PERIOD | Number(10) | NUMBER10 | Y | |
GL_ACCOUNT_CODE | Varchar2(16) | CODE | Y | |
DISTRIBUTION_CODE | Varchar2(50) | DISTRIBUTION | Y | |
GL_EFFECTIVE_DATE | Date() | DATE | ||
GLPOST_NUMBER | Number(10) | NUMBER10 | ||
GLPOST_SEQUENCE | Number(5) | NUMBER5 | ||
TRIAL_JOURNAL | Varchar2(4) | VARCHAR4 | ||
PERSON_CODE | Varchar2(16) | CODE | ||
PAY_NUMBER | Number(5) | NUMBER5 | ||
PC_CODE | Varchar2(4) | CODE | ||
GL_AMOUNT | Number(18) | AMT12V6 | ||
SPLIT_PERCENT | Number(5) | PERCENT | ||
GL_DETAIL_SEQUENCE | Number(5) | NUMBER5 | ||
WORK_ORDER | Varchar2(50) | VARCHAR50 | ||
GL_POINTER | Varchar2(30) | VARCHAR30 | ||
GL_FUND_CODE | Varchar2(16) | CODE | ||
CREATE_DATE | Date() | DATE | ||
CREATE_USER | Varchar2(30) | VARCHAR30 | ||
CHANGE_DATE | Date() | DATE | ||
CHANGE_USER | Varchar2(30) | VARCHAR30 |