Outbound Contract Expenditure Data (CTI003)
  • 29 May 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Outbound Contract Expenditure Data (CTI003)

  • Dark
    Light
  • PDF

Article summary

Interface Description

The Outbound Contract Expenditure Interface provides daily contract expenditures transactions processed in Florida PALM to the FACTS application. Only expenditures associated with contracts applicable to FACTS, as indicated by the Contract ChartField (ChartField) value and FACTS indicator on the custom Contracts Information File (CTE001), are included in this outbound interface.

This information is generated in Florida PALM from several source modules: Accounts Payables, General Ledger, and Interunit by extracting details from the source records and generating an outbound file. The outbound file is sent daily to FACTS by Florida PALM's application engine.

The application engine will execute a program to call the source records, pull the data based on established criteria, load data into a temporary table, validate the data, and generate the outbound file to send to FACTS.

The application engine will provide a processing report that provides details of any lines rejected due to errors, an explanation of errors, and the number of transactions that were processed with success.

The file format will be pipe delimited. All references to custom Application Engines/Pages/Records/Fields are subject to change.

Business Process Model

This interface can be found in the following business processes:

Selection Criteria

The interface data selection criteria include the following:

Data Field

Data Field Details

SetID

Optional

As of Date

Required

File path

Required

File Layout

Field names and descriptions from the interface layout are provided below.

Data Field Name

Record Type

Data Field Description

Record Code

Header

This field is the row identifier and should be added at the start of each header row.

Total Count of Journals

Header

The total count of journals is included in the detail section.

ASoftDate

Header

TBD

Record Code

Detail

This field is the row identifier and should be added at the start of each Detail row.

Business Unit GL

Detail

Used to define an organization or organizational subset that is independent of one or more accounting or operational functions for Contracts.

Journal ID

Detail

Identifies a journal entry consisting of a header and one or more lines. NEXT functionality creates auto-numbered unique journal IDs in Florida PALM.

Contract ID

Detail

Contract ID used identity Contract managed by agencies in FACTS.

Voucher ID

Detail

Voucher ID is a unique identifier, a sequential number that cannot be duplicated within an AP Business Unit.

Accounting Date

Detail

Accounting Date for the transaction. This value is derived from the budget date on the transaction.

Budget Period

Detail

Used to define the budget period in which a transaction is associated. This value is derived from the budget date and transaction.

Account

Detail

Identifies the General Ledger account value that will be used to record the transaction (i.e., ChartField value for expense).

Fund

Detail

Segregates and captures specific activities or classifies particular objectives under 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

Amount

Detail

Maximum of 23 characters, with a breakdown as follows:

19 integers

2 decimals

1 decimal point

1(-) sign

23 total

Example: 20432.89

Examples: 5000.00, 1234.56, -123.45

Supplier ID

Detail

Supplier ID is used on transactions to identify a grant/contract managed by the agency.

Supplier Name

Detail

The name of the grantor is derived from the Supplier record.

Version History

Date

Revision Description

03/12/2024

Original Version

Design Document(s)


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.