Outbound Inter/IntraUnit Interface (IUI003)
-
Print
-
DarkLight
-
PDF
Outbound Inter/IntraUnit Interface (IUI003)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Interface Description
The Inter/IntraUnit (IU) module allows State agencies to engage in transactions with each other or within their agency. These transactions can take several forms, including loans, transfer of resources, reclassifications, and the provision of services between funds. For instance, one agency may provide a service to another agency and subsequently be reimbursed for the cost incurred. Alternatively, one agency might transfer funds to another to support specific projects or initiatives.
The Outbound Inter/IntraUnit Interface (IUI003) provides the following data:
- New IU Transactions - Newly received IU transactions are included on the reciprocating agency outbound file so the agency can obtain the initial IU transaction ID generated when the transaction was initiated.
- Updated IU Transactions - An IU transaction that was updated will be included in the file with all details. The updated IU transaction will be included in the file for both the initiating and reciprocating agency.
- Posted IU Transactions - Once the IU transaction is approved and posted to the GL, both initiating and reciprocating agencies will receive both sides of the IU transaction in their outbound file.
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:
- 100.7.3 Process Redistributions
- 110.1.1 Create and Maintain Inter/IntraUnit Encumbrances
- 110.1.2 Monitor Inter/IntraUnit Encumbrances
- 110.2.1 Create and Maintain Inter/IntraUnit Accruals
- 110.2.2 Monitor Inter/IntraUnit Accruals
- 110.3.1 Agency Record Inter/IntraUnit Transactions
- 110.3.2 Enterprise Record Inter/IntraUnit Transactions
- 110.3.3 Process GR Service Charge
- 110.3.4 Manage Trust Fund Loans
- 110.3.5 Inter/IntraUnit Reclassifications
- 110.4.1 Inter/IntraUnit Period Close
- 110.4.2 Inter/IntraUnit Carry Forward Process
Selection Criteria
The interface data selection criteria includes the following:
Data Field | Data Field Details |
|---|---|
Business Unit | Required |
BU Distribution Only | Optional |
From Date | Conditional |
To Date | Conditional |
Full Extract | Optional |
Delta Extract | Optional |
Adhoc | Optional |
Batch | Optional |
File Layout
Field names and descriptions from the interface layout are provided below.
| Field Name | Record Type | Description |
|---|---|---|
| Record Code | Header | Record code to indicate the Header record. |
| IU Transaction ID | Header | Auto-generated transaction ID of an existing IU transaction in Florida PALM. This value should only be used when updating an existing IU transaction. |
| Transaction Type | Header | Used to classify the IU Transaction including: Encumbrances, Accruals, Expenditure/Revenue, Transfer, Reclassification, Reverse IU Transaction |
| Transaction Subtype | Header | A more granular classification of the Transaction Type including Payable/Receivable, Due To/Due From, Advance Issuance, Advance Repayment, Trust Fund Loan Issuance, Trust Fund Loan Repayment, Accrual Balance Adjustment, Transfer, General Revenue Transfer, Federal Funds Transfer, Residual Equity Transfer, GR Service Charge Payment, IU Transaction Reclassification, Payroll Reclassification, Expenditure Reclassification, Revenue Reclassification, Revenue to Revenue, Reverse IU Transaction |
| Initiating Side | Header | The side of the transaction initiated. Typically, the sending agency (S) initiates the transaction. However, the receiving agency (R) may initiate the transaction for Payables/Receivables and Due To/ Due From transactions. |
| Sending BU | Header | The GL Business Unit of the agency who is on the sending side of the transaction. Typically, this is the agency who sends the transaction. However, for payable/receivable and due to/due from transaction types this is the agency with the payable side. |
| Receiving BU | Header | The GL Business Unit of the agency who is on the receiving side of the transaction. Typically, this is the agency who receives the transaction. However, for payable/receivable and due to/due from transaction types this is the agency with the receivable side. |
| Receiving Fund | Header | Fund of the receiving agency. This is applicable for Transfer transaction types, Payables/Receivables, Due To/Due From, Trust Fund Issuance, and Advance Issuance transactions. |
| Accounting Date | Header | Accounting date of the IU transaction. |
| Total Amount | Header | Total dollar amount of the IU transaction. This should be the summation of the distribution lines. |
| Inter vs Intra | Header | The value will be systematically assigned based on the on the Sending and Receiving Agency values. InterUnit – Sending is different from Receiving Agency IntraUnit – Sending and Receiving agency are the same or only Sending Agency is supplied. |
| IU Transaction Status | Header | Will be populated with the lifecycle status of the IU transaction |
| IU ID Reference | Header | Transaction ID of an existing IU transaction in Florida PALM. |
| Agency Invoice ID | Header | Invoice ID generated in external system that can be referenced on a Florida PALM IU transaction. |
| IU Encumbrance ID | Header | This is the IU Transaction ID of an existing IU Encumbrance that will be used to relieve the balance when creating the following IU Transactions: Payables/Receivables Due To/Due From Expenditure/Revenue All Transfer Types/Subtypes except Revenue to Revenue |
| Final Payment Flag | Header | This is a flag that will enable the system to auto liquidate the remaining encumbrance or accrual balance and close the encumbrance or accrual that was selected. |
| IU Accrual ID | Header | This is the IU Transaction ID of an existing IU Encumbrance that will be used to relieve when creating the following IU Transactions: Expenditure/Revenue Transfer Subtypes Encumbrance Trust Fund Loans Repayments Advance Repayments |
| Description (Sending) | Header | This is a free form text field that can be used to capture any additional data. |
| External Reference (Sending) | Header | This field can be used to reference any existing external identifier related to the transaction in Florida PALM |
| Description (Receiving) | Header | This is a free form text field that can be used to capture any additional data. |
| External Reference (Receiving) | Header | This field can be used to reference any existing external identifier related to the transaction in Florida PALM |
| Last Update Date | Header | The date the IU transaction was last updated. |
| Filler1 | Header | This field is reserved for future use in Florida PALM. |
| Filler2 | Header | This field is reserved for future use in Florida PALM. |
| Filler3 | Header | This field is reserved for future use in Florida PALM. |
| Filler4 | Header | This field is reserved for future use in Florida PALM. |
| Filler5 | Header | This field is reserved for future use in Florida PALM. |
| Record Code | Detail | Record code to indicate the Detail record. |
| IU Transaction ID | Detail | Auto-generated transaction ID of an existing IU transaction in Florida PALM. This value should only be used when updating an existing IU transaction. |
| Transaction Type | Detail | Used to classify the IU Transaction including: Encumbrances, Accruals, Expenditure/Revenue, Transfer, Reclassification, Reverse IU Transaction |
| Transaction Subtype | Detail | A more granular classification of the Transaction Type including Payable/Receivable, Due To/Due From, Advance Issuance, Advance Repayment, Trust Fund Loan Issuance, Trust Fund Loan Repayment, Accrual Balance Adjustment, Transfer, General Revenue Transfer, Federal Funds Transfer, Residual Equity Transfer, GR Service Charge Payment, IU Transaction Reclassification, Payroll Reclassification, Expenditure Reclassification, Revenue Reclassification, Revenue to Revenue, Reverse IU Transaction |
| Initiating Side | Detail | The side of the transaction initiated. Typically, the sending agency (S) initiates the transaction. However, the receiving agency (R) may initiate the transaction for Payables/Receivables and Due To/ Due From transactions. |
| Sending BU | Detail | The GL Business Unit of the agency who is on the sending side of the transaction. Typically, this is the agency who sends the transaction. However, for payable/receivable and due to/due from transaction types this is the agency with the payable side. |
| Receiving BU | Detail | The GL Business Unit of the agency who is on the receiving side of the transaction. Typically, this is the agency who receives the transaction. However, for payable/receivable and due to/due from transaction types this is the agency with the receivable side. |
| Sending/Receiving Flag | Detail | The side of the transaction applicable to the distribution line. (S) represents the sending side of the IU transaction. (R) represents the receiving side of the transaction. |
| Distribution Sequence No | Detail | Numeric sequence number for the accounting distribution line for the payment. Start with 1 and increase for each row of accounting distribution in the payment. If there is only one accounting distribution for the payment, then provide the number 1. |
| Speed Key | Detail | Code that defines ChartField distribution line information for IU Transactions. The full ChartField string as defined in the SpeedKey will be populated during the file load process. This is only used when IU transaction selected is a Payroll Reclassification. When provided, value needs to be validated against the FIN HR Accounting Line record along with the other HR fields |
| Budget Date | Detail | Represents the budget date/appropriation date including the fiscal year for the budget associated with the payment. |
| GL Business Unit | Detail | Equivalent to the Florida PALM GL Business Unit for the Agency. Must be a valid value within Florida PALM. |
| Organization | Detail | Organization ChartField tracks information according to a breakdown of your organization. |
| Account | Detail | Provides functionality to capture detailed transactional data. Can be specified as a balance sheet account or operating account. |
| Fund | Detail | Segregates and captures specific activities or classifies certain objectives in accordance with special regulations, restrictions, or limitations. |
| Budget Entity | Detail | Budget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program. |
| Category | Detail | Category ChartField represents both appropriation categories and revenue source codes. |
| State Program | Detail | State Program is used to identify the plan for an organization and use of resources to meet specified objectives of the State. |
| Asset ID | Detail | Florida PALM generated Asset ID. Asset Identification represents asset being transferred or retired. |
| Grant | Detail | Grant ChartField is used for tracking grants funding. |
| Contract | Detail | Contract ChartField captures expenditure and revenue transactions for two party agreements. |
| OA1 | Detail | Other Accumulator 1 is a flexible ChartField reserved for tracking for optional reporting or specific use. |
| OA2 | Detail | Other Accumulator 2 is a flexible ChartField reserved for tracking for optional reporting or specific use. |
| PC Business Unit | Detail | Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for Project related ChartFields. |
| Project | Detail | 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 | Detail | 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 | Detail | Source types identify the purpose or origin of a transaction. |
| PC Category | Detail | Project Category provides more flexibility and granularity in tracking and analyzing financial activity associated with a Project. |
| PC Subcategory | Detail | Subcategories provides more flexibility and granularity in tracking and analyzing financial activity associated with a Project. |
| IU Line Description | Detail | User Entered text to provide additional information to the IU Line transaction being performed |
| Foreign Amount | Detail | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FORIEGN_AMOUNT values should equal the total amount of the IU transaction. |
| Accounting Date | Detail | Same value as the Header Accounting Date. This value is being included here in case there is a need in the future for having accounting dates that vary by line. |
| Journal ID | Detail | Journal ID generated when the IU transaction is distributed to the general ledger. |
| Fiscal Year | Detail | Fiscal Year |
| Accounting Period | Detail | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| GL Distribution Status | Detail | Displays the Florida PALM General Ledger distribution status. |
| Journal Line | Detail | Uniquely identifies a journal line with a sequence number. |
| Journal Date | Detail | Specifies the date the journal was created. |
| Journal Line Ref | Detail | This is a free form text field can be used to reference information. This can also be used to include the GL Journal ID or Paycheck Number from FIN HR Accounting Line for Payroll Reclassifications transactions. |
| Employee ID | Detail | This is a free form text field can be used to reference the Employee ID from FIN HR Accounting Line for Payroll Reclassifications transactions only. |
| Position | Detail | This is a free form text field can be used to reference the Position from FIN HR Accounting Line for Payroll Reclassifications transactions only. |
| IU Encumbrance ID | Detail | This is the IU Transaction ID of an existing IU Encumbrance that will be used to relieve when creating only the following IU Transactions: Payables/Receivables Due To/Due From Expenditure/Revenue All Transfer Types/Subtypes except Revenue to Revenue |
| Encumbrance Reference Line No | Detail | Numeric sequence number that reference the IU encumbrance distribution line being updated. |
| IU Accrual ID | Detail | This is the IU Transaction ID of an existing IU Accrual that will be used to relieve when creating only the following IU Transactions: Expenditure/Revenue Transfer Subtypes Encumbrance Trust Fund Loans Repayments Advance Repayments |
| Accrual Reference Line No | Detail | Numeric sequence number that reference the IU Accrual distribution line being updated. |
| Last Modified Date | Detail | The date the individual IU transaction line was last updated. |
| Filler1 | Detail | This field is reserved for future use in Florida PALM. |
| Filler2 | Detail | This field is reserved for future use in Florida PALM. |
| Filler3 | Detail | This field is reserved for future use in Florida PALM. |
| Filler4 | Detail | This field is reserved for future use in Florida PALM. |
| Filler5 | Detail | This field is reserved for future use in Florida PALM. |
| Filler6 | Detail | This field is reserved for future use in Florida PALM. |
| Filler7 | Detail | This field is reserved for future use in Florida PALM. |
| Filler8 | Detail | This field is reserved for future use in Florida PALM. |
| Filler9 | Detail | This field is reserved for future use in Florida PALM. |
| Filler10 | Detail | This field is reserved for future use in Florida PALM. |
Version History
Date | Revision Description |
|---|---|
| 06/11/2024 | Original Version |
| 07/02/2024 | Removed 110.4.3 Inter/IntraUnit Certified Forward Process business process model. |
| 10/08/2024 | Updated per version history date 9/12/2024: DD ID 0686 – additional design changes related to interfaces
|
Was this article helpful?
