Outbound Inter/IntraUnit Interface (IUI003)

Print
Share
Dark

Light
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.
Created/Updated IU Transactions - An IU transaction that was created/updated will be included in the file with all details. The 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 their side of the IU transaction in their outbound file.

Click below to view the interface file layout and sample data file.

IUI003-Outbound Inter-IntraUnit Interface-Layout.xlsx

IUI003-Sample Data.txt

DFS_IUI003_Payment_Sample Data.txt

DMS_IUI003_Receipt_Sample_Data.txt

Business Process Model

This interface can be found in the following business processes:

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
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 Reclassification, Payroll Reclassification, Revenue to Revenue
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 Payables/Receivables 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 Payables/Receivables 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. The total of the user-entered (not offset) debit or credit lines on the sending side equals the Header Total Amount. The total of the user-entered (not offset) debit or credit lines on the receiving side equals the reversal of the Header Total Amount. For example, if the user-entered lines total -500, the Header Total Amount is 500, and vice versa. (This is not applicable to Encumbrances or Reclassifications) For Trust Fund Loan Issuance and Advance Issuance, the user-entered debit lines on the sending side equals the Header Total Amount. Conversely, the user-entered credit lines on the receiving side equals the reversal of the Header Total Amount.
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 balance and close the encumbrance that was selected.
IU Accrual ID	Header	This is the IU Transaction ID of an existing IU Accrual 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 Reclassification, Payroll Reclassification, Revenue to Revenue
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 number used to identify the distribution line for the transaction.
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.
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 the debit or credit accounting entry line.
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.
Reference 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 For Reclassifications, this is the IU Transaction ID of an existing IU Transaction being reclassified.
Reference Line No	Detail	For transactions referencing an Accrual, this is the numeric sequence number that reference the IU Accrual distribution line being updated. For Reclassification, this is the numeric sequence number of the IU Transaction ID being reclassified.
Last Modified Date	Detail	The date the individual IU transaction line was last updated.
Budget/Cash Check Line Status	Detail	This field shows the Budget / Cash check status of the IU Transaction.
Offset Indicator	Detail	This field will be populated when the line is an offset entry.
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 Replace Close Accrual transaction subtype to Accrual Balance Adjustment Added the following fields to the Detail Record Type: Added IU Transaction ID Transaction Type Transaction SubType Sending BU Initiating Side Receiving BU Encumbrance Reference Line No Accrual Reference Line No
1/9/2025	Updated Filler1 field to the Budget / Cash Check Line Status
03/17/2025	Added DFS_IUI003_Payment_Sample_Data & DMS_IUI003_Receipt_Sample_Data
03/24/2025	Administrative updates to apply the following changes based on layout update dated 03/05/2025: 1. Changed the IU Accrual ID field name to Reference ID on the Detail record and updated the description. 2. Changed the Accrual Reference Line No field name to Reference Line No on the Detail record, updated description and processing rules. 3. Changed the Filler2 field on the Detail Record to Offset Indicator and its description as requested by agencies. This is to be able to identify that a line is an offset entry. 4. Updated Header Total Amount description to clarify the amount calculation for the sending and receiving sides. 5. Updated the description of the Final Payment Flag field to remove references of accruals. 6. Added Encumbrances and removed IU Reverse Transactions as valid values for the Transaction Subtype field. 7. Updated description of SpeedKey field to remove reference of Payroll Updated IUI003 article description to clarify: a) Created IU transactions will be received in the file b) Posted IU transactions received in the IUI003 file will only include their side of the IU transaction, as opposed to both sides of the transaction.

Was this article helpful?

What's Next

Outbound Salary Detail File (PRI007)

Table of contents

Interface Description
Business Process Model
Selection Criteria
File Layout
Version History