-
Print
-
DarkLight
-
PDF
Inbound Journal Entry (GLI006)
-
Print
-
DarkLight
-
PDF
Interface Description
GLI006 is an Inbound Journal Entry interface that supports a method of entry to receive General Ledger journals from external systems. Agencies can make the journal entries in their own system and import them into Florida PALM. This allows for a way to have journal entries in Florida PALM that are made independently from the Florida PALM system.
Click below to view the interface file layout and sample data file.
Business Process Model
This interface can be found in the following business processes:
Selection Criteria
N/A
File Layout
Field names and descriptions from the interface layout are provided below.
Data Field Name | Record Type | Data Field Description |
---|---|---|
Record Code | Journal Header | Record Code identifying the information on the record. |
Business Unit | Journal Header | Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions. |
Journal Date | Journal Header | Specifies the date the journal was created. |
Adjusting Entry | Journal Header | Adjusting entry is an entry recorded at the end of the accounting period to record month-end or year-end adjustments, which includes audit adjustments, and adjustments performed to support financial reporting like GAAP, Full Accrual, etc. |
Adjusting Period | Journal Header | Month-end or Year-end adjustments are segregated from the regular accounting period(s). Adjustment period is used to record the month end or year-end adjustment |
Ledger Group | Journal Header | One or more ledgers indicating where journal entries will be posted to affect financial balances. |
Ledger | Journal Header | Identifies where the journal entries will be recorded to impact financial balances. |
Reversal Code | Journal Header | A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process. |
Reversal Date | Journal Header | Specifies the date for an automatic reversal journal entry. |
Reversal Adjustment Period | Journal Header | Indicates the Accounting Period for a reversal adjustment journal. |
Source | Journal Header | Identifies the origin of a journal entry to facilitate inquiries and reporting. |
Transaction Reference Number | Journal Header | Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal entry. The journal reference is helpful if you need to trace back to the source of the transaction. |
Description | Journal Header | Used to provide a short description reflecting the purpose of the journal. |
Journal Class | Journal Header | Used to categorize types of journals. |
Long Description | Journal Header | Used to provide a long description reflecting the purpose of the journal. |
Record Code | Journal Line | Record Code identifying the information on the record. |
Business Unit | Journal Line | Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions. |
GL Journal Line Number | Journal Line | Sequential number of lines in the journal. |
Ledger | Journal Line | Identifies where the journal entries will be recorded to impact financial balances. |
Organization | Journal Line | Organization ChartField tracks information according to a breakdown of your organization. |
Account | Journal Line | Provides functionality to capture detailed transactional data. Can be specified as a balance sheet account or operating account. |
Fund | Journal Line | Segregates and captures specific activities or classifies certain objectives in accordance with special regulations, restrictions, or limitations. |
Budget Entity | Journal Line | Budget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program. |
Category | Journal Line | Category ChartField represents both appropriation categories and revenue source codes. |
State Program | Journal Line | Stores Chart of Accounts information and provides the basic structure to segregate and categorize transactional and budget data. |
Grant | Journal Line | Grant ChartField is used for tracking grants funding. |
Contract | Journal Line | Contract ChartField captures expenditure and revenue transactions for two party agreements. |
OA1 | Journal Line | OA1 tracks optional organization reporting, cost pools, expenditures, revenues, or other specific use. |
OA2 | Journal Line | OA2 tracks optional organization reporting, cost pools, expenditures, revenues, or other specific use. |
PC Business Unit | Journal Line | Project Costing Business Unit. |
Project | Journal Line | Project ChartField is used to capture a planned undertaking of something to be accomplished or produced, having a beginning and ending date, for which expenditures/costs and revenues are to be tracked. |
Activity | Journal Line | Tracks specific tasks that make up a Project and records transactional details; a Project must have at least one associated Activity ID. |
PC Source Type | Journal Line | PC Source types identify the purpose or origin of a transaction. |
PC Proj Category | Journal Line | PC Project Category provides more flexibility and granularity in tracking and analyzing costs; not required. |
PC Subcategory | Journal Line | PC Subcategories provides more flexibility and granularity in tracking and analyzing costs; not required. |
Analysis Type | Journal Line | Type of project transaction. |
Monetary Amount | Journal Line | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. Value includes decimal point and two decimals i.e. 9999.99. |
Journal Line Reference | Journal Line | May be used to reflect a legacy system transaction number. |
Journal Line Description | Journal Line | Description of the journal line which is populated with the Account ChartField value description as a default unless a specified value is provided. |
Budget Date | Journal Line | Indicates the date within the correlating budget period that the journal is eligible to be budget checked against. |
Inter/IntraUnit Group Number | Journal Line | Groups a set of journal lines as a set of InterUnit or IntraUnit transactions. |
Inter/IntraUnit Anchor | Journal Line | Indicates which journal line contains the anchor Business Unit value for the InterUnit or IntraUnit transactions. |
Filler1 | Journal Line | This field is reserved for future use in Florida PALM. |
Filler2 | Journal Line | This field is reserved for future use in Florida PALM. |
Version History
Date | Revision Description |
---|---|
11/29/2023 | Original Version |
01/17/2024 | Removed Commitment Control Amount Type, Journal ID and System Source fields from File Layout section to conform to Financial Wave requirements. |