This page (revision-16) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
16 26-Nov-2021 10:22 1 KB rforbes to previous
15 26-Nov-2021 10:22 1 KB JMyers to previous | to last
14 26-Nov-2021 10:22 2 KB JMyers to previous | to last
13 26-Nov-2021 10:22 1 KB JMyers to previous | to last
12 26-Nov-2021 10:22 1 KB JMyers to previous | to last
11 26-Nov-2021 10:22 1 KB JMyers to previous | to last
10 26-Nov-2021 10:22 1 KB JMyers to previous | to last
9 26-Nov-2021 10:22 1 KB JMyers to previous | to last
8 26-Nov-2021 10:22 1 KB JMyers to previous | to last
7 26-Nov-2021 10:22 1 KB JMyers to previous | to last
6 26-Nov-2021 10:22 1 KB JMyers to previous | to last
5 26-Nov-2021 10:22 884 bytes JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links
IVPJE
IVPJE

Version management

Difference between version and

At line 1 changed one line
!!!JOURNAL ENTRIES INTERFACE FILE
!!!Alias: [IVPJE]
(INF_CV_JOURNALENTRIES)
\\
At line 3 changed one line
The Journal Entries Interface File screen is used to import journal entries into the software data structures.
Journal Entries
At line 5 changed one line
Journal Entries Interface File data is maintained on the [INF_CV_JOURNALENTRIES] table.
!!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.
At line 7 removed 18 lines
;[ID|ID]:This field uniquely identifies the journal entries record within the data base.
;[G/L Company|GL_COMPANY_CODE]:This field identifies the G/L company associated with the journal entry.
;[Calendar Period|CALENDAR_PERIOD]:This field identifies the calendar period for the journal entry.
;[G/L Account|GL_ACCOUNT_CODE]:This field identifies the G/L account associated with the journal entry.
;[Distribution Code|DISTRIBUTION_CODE]:This field identifies the distribution code associated with the journal entry.
;[G/L Effective Date|GL_EFFECTIVE_DATE]:This field displays the date that the journal entry is effective.
;[G/L Post Number|GLPOST_NUMBER]:
;[G/L Post Sequence|GLPOST_SEQUENCE]:This field identifies the sequential order of the G/L post.
;[Trial Journal|TRIAL_JOURNAL]:This field indicates that the Journal Entry is a trial journal after either the [UPLG] or [UPGL] is run.
;[Person Code|PERSON_CODE]:This field identifies the individual associated with the journal entry.
;[Pay #|PAY_NUMBER]:This field identifies the pay run number associated with the journal entry.
;[PC Code|PC_CODE]:This field identifies the pay component associated with the journal entry.
;[G/L Amount|GL_AMOUNT]:This field displays the amount of the journal entry.
;[Split Percent|SPLIT_PERCENT]:If a split rule is ‘by percent’ then this field indicates the percentage.
;[G/L Detail Sequence|GL_DETAIL_SEQUENCE]:
;[Work Order|WORK_ORDER]:This field identifies the work order attached to the journal entry.
;[G/L Pointer|GL_POINTER]:
;[G/L Fund|GL_FUND_CODE]:This field identifies the G/L fund attached to the journal entry.
At line 34 added 2 lines
[{If var='loginstatus' contains 'authenticated'
At line 27 changed 2 lines
![Notes|Edit:Internal.IVPJE]
[{InsertPage page='Internal.IVPJE' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IVPJE]
[{InsertPage page='Internal.IVPJE' default='Click to create a new discussion page'}]
}]
This page (revision-16) was last changed on 26-Nov-2021 10:22 by rforbesTop