Listed below are each journal along with the page code (when applicable) for online query. Those items listed with a ’*’ are ones that have a specific use pre-defined.
Page Code |
Journal Name |
Data Object |
J1099 |
JRNL_1099 |
|
JACTG |
JRNL_ACTG |
|
JBFYNOTFY |
JRNL_BFYNOTFY |
|
JBUD |
JRNL_BUD |
|
JCASH |
JRNL_CASH |
|
JCOMM |
JRNL_COMM |
|
JCA |
JRNL_COST |
|
JFAAJ |
JRNL_FA |
|
JFACJ |
JRNL_COMP |
|
JINT |
JRNL_INT |
While most fields found on journals are general fields defined at various points in the Transactions User Guide, because all journal updates originate from transactions, the table below defines those fields not commonly found on transactions but are found on most journals.
Please note that all fields may not be displayed on this inquiry page. These fields are either marked as hidden or tertiary on Configure Page (DESIGNER). One such field is Closing Classification. Values in this field are the same groupings of posting codes used by Annual Close and various reports. They enable a user to search for multiple posting codes without having to enter the individual codes to query for all revenues, spending, liabilities, and so forth.
Field Name |
Field Description |
Fiscal Quarter |
Each accounting period is defined with a default fiscal quarter that infers automatically. |
Increase/Decrease |
Most journal records have the increase indication, but those recording a reduction through either a modification or a cancellation will record a decrease. |
Internal Department |
When posting lines are generated using the clearing accounts of Due To and Due From, the department from each side of the internal accounting event is recorded on the entries of the other. |
Internal Fund |
When posting lines are generated using the clearing accounts of Due To and Due From, the fund from each side of the internal accounting event is recorded on the entries of the other. |
Internal Sub Fund |
When posting lines are generated using the clearing accounts of Due To and Due From, the sub fund from each side of the internal accounting event is recorded on the entries of the other. |
Line Function |
Values are Standard, Non-Standard, and Liquidation. Standard lines are available to be liquidated later by a referencing transaction (e.g. a receivable liquidated by a cash receipt), whereas non-standard lines will not get liquidated (e.g. postings from a check). Liquidation lines are those being liquidated (or unliquidated) by a referencing transaction. |
Posting Amount |
The amount recorded with each individual debit and credit. |
Run Date / Run Time |
In the filter sections of most journal inquiry pages, there is a Run Date field that corresponds to the Run Time result field. However, the filter field does not have the time component. When searching for records before or after a particular time, first search for records using a date and then use the sorting capability of the Run Time field to order records in descending or ascending order by time to locate the point in time desired. |