GL Key Tables : GL_lines, gl_periods (3)

Categories: ERP Tables
GL_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.
« « GL Key Tables : GL_headers, gl_batches (2)                        GL Key Tables : GL_sets_of_books, gl_import_references,gl_daily_rates (4) » »

Comments are closed.