Journal Generator Required Field Names

This table lists the fields that must be in the Accounting Entry table to run Journal Generator. Fields shown in upper case are exact field names that are required in the table. Mixed-case field names indicate that you can specify the field name on the Accounting Entry Definition page:

Field Name	Description
Accounting Date	Reflects the date of the accounting entry recognized in general ledger.
Foreign Amount	Foreign (transaction currency) amount.
Monetary Amount	Base currency amount.
ACCOUNTING_PERIOD and FISCAL_YEAR	The Journal Generator process populates the accounting period and fiscal year after it distributes the accounting entry to a general ledger journal based on the journal date.
APPL_JRNL_ID	Journal generator template ID. Identifies the journal defaults and summarization options for the accounting entry.
BUSINESS_UNIT	Application business unit.
BUSINESS_UNIT_GL	General Ledger business unit for the entry.
CURRENCY_CD	Currency code for the base currency amount.
FOREIGN_CURRENCY	Currency code of the foreign amount.
GL_DISTRIB_STATUS	General Ledger Distribution Status indicates the posting status for the distribution lines. The value is N (none) when the accounting entry is created and ready for the Journal Generator process. The Journal Generator process changes the value to D (distributed) when it distributes the accounting entry to a general ledger journal. The Journal Generator ignores any other values.
JOURNAL_ID and JOURNAL_DATE	The Journal Generator process populates the journal ID and journal date fields after it distributes the accounting entry to a general ledger journal.
JOURNAL_LINE	Populated by the Journal Generator after it distributes the accounting entry to a general ledger journal if the Cross Product Drill Down option on the Accounting Entry Definition page is selected.
LEDGER	Specific ledger to which an accounting entry posts. If this field is blank, Journal Generator uses by default the primary ledger of the ledger group.
LEDGER_GROUP	Ledger group to which an accounting entry posts. If this field is blank, the Journal Generator creates the journal to the default ledger group specified on the Ledger for a Unit - Definitions page.
PROCESS_INSTANCE	Populated by Journal Generator when it distributes the accounting entry to a general ledger journal.

This table lists optional fields for the Journal Generator process. Uppercase fields are exact field names that are used in the Accounting Entry table. Mixed-case names indicate that you can specify the field name on the Accounting Entry Definition page:

Field Name	Description
Statistical Amount	Statistical amount.
Journal Ref (journal reference)	Journal line reference used to track the source of the transaction.
Journal Descr (journal description)	Journal description used to describe a transaction.
Open Item Key	Open item key provides the link between related open item entries.
ChartFields	ChartFields that map directly to the General Ledger ChartFields. The Journal Generator process uses these ChartFields when it summarizes the accounting entries and creates journals.
KK_AMOUNT_TYPE	Commitment Control Amount Type provides commitment control accounting entries for budget checking in General Ledger on the journals created.
DOC_TYPE	Use document type for document sequencing. Use this field and the Document Type mapping feature on the journal generator template to group accounting entries according to the general ledger document type into different journals.
DOC_SEQ_NBR	Sequence number of the document.
DOC_SEQ_DATE	Date the document sequence number was assigned or validated.
MOVEMENT_FLAG	Defines the sign of the amount if you enabled the Separate Debit/Credit option. Otherwise Journal Generator ignores this flag. The values are: N: Natural sign of the monetary amount of the transaction. This is the default. For suspense balancing, base currency rounding adjustments, currency position, and interunit from and to lines, this field is always N. R: Reverse sign of the monetary amount of the transaction. If the Enable Separate Debit/Credit option is selected on the Ledgers For A Unit - Definition Page and you enabled separate debits and credits for your system, you can toggle this field to represent a reversing debit or credit amount.
ADB_DATE	If the Average Daily Balance Date field exists on the accounting entry table, Journal Generator uses it to populate the ADB date of the journal header.
BOOK_CODE	If the Book Code field exists in the accounting entry table and if Book Code has been activated on the Overall Installation Options page, Journal Generator groups accounting entries into different journals according to the Book Code.