If you are new here, you may want to subscribe to the following feeds GL Key Tables : GL_lines, gl_periods (3)
Written by Nilesh JethwaGL_JE_LINES stores the journal entry lines that you enter in the Enter Journals form. There is a one–to–many relationship between journal entries and journal entry lines. Each row in this table stores the associated journal entry header ID, the line number, the associated code combination ID, and the debits or credits associated with the journal
line. STATUS is ’U’ for unposted or ’P’ for posted.
GL_PERIODS stores information about the accounting periods you define using the Accounting Calendar form. Each row includes the start date and end date of the period, the period type, the fiscal year, the period number, and other information. There is a one–to–many relationship between a row in the GL_PERIOD_SETS table and rows in
this table.
Posted in ERP Tables |
One Comment to “GL Key Tables : GL_lines, gl_periods (3)”
Leave a Comment
Free Dashboards and KPI examples
October 17th, 2006 at 10:50 pm
[…] If you query the gl_periods table , you will find columns such as period number, period_name, period year. […]