Outbound Inter/IntraUnit Interface (IUI003)

Business Unit

Required

BU Distribution Only

Optional

From Date

Conditional

To Date

Conditional

Full Extract

Optional

Delta Extract

Optional

Adhoc

Optional

Batch

Optional

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

• 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, Close Accrual, 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 intitiated. Typically, the sending agency (S) intiates the transaction. However, the receiving agency (R) may initiate the transaction for Paybles/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/receviable 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/receviable 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

• 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

• 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

• 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.

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

• Payables/Recevables
• Due To/Due From
• Expenditure/Revenue
• All Transfer Types/Subtypes except Revenue to Revenue

IU Accrual ID

Detail

• Expenditure/Revenue
• Transfer Subtypes
• Encumbrance
• Trust Fund Loans Repayments
• Advance Repayments

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.

Original Version