Login
Contents x
CMS Wave Interfaces
  • 02 Oct 2024
  • 4 Minutes to read
  • Print
  • Dark
    Light
  • PDF
Contents

CMS Wave Interfaces

  • Updated on 02 Oct 2024
  • 4 Minutes to read
  • Print
  • Dark
    Light
  • PDF
Article summary

During CMS Wave, agencies will continue to operate within the Central, Payroll, and Departmental FLAIR systems, while having access to Florida PALM to execute actions that were previously performed within the CMS system. The following CMS Wave Interfaces will either be updated, retired (e.g., interface connections to FLAIR), or have no change at Financials Go-Live. 

  • If the "Audience" column for the interface shows All Agencies, then a link to the layouts is included under the "Interface File Layout" column.
  • Details about the Financials Wave file layout can be found on the interface’s article page by clicking on the hyperlink within the "Interface Name" column.

Below are the interfaces available during the CMS Wave implementation of Florida PALM.


Accounts Payable CMS Interfaces

IDInterface NameInterface DescriptionAudienceFinancials Wave Impact
CMS Wave Interface File Layout Available for Agencies
Inbound Interfaces
API107Inbound Central FLAIR Issued Warrants and Cancellations
(CMS Wave only)		Inbound file to load issued and cancelled Central FLAIR payments.DFS - Enterprise SystemRetiringN/A
Outbound Interfaces
API108Outbound Central FLAIR Reconciled Payments
(CMS Wave only)
Send payment reconciliation status from Florida PALM to Central FLAIR.DFS - Enterprise SystemRetiringN/A


Accounts Receivable CMS Interfaces

IDInterface NameInterface DescriptionAudienceFinancials Wave ImpactCMS Wave Interface File Layout Available for Agencies
Inbound Interfaces
ARI033Inbound ACH NOC and Return Deposit DataInbound interface from NIC that provides ACH returned and ACH details related to customer drafts that require changes to the banking information.NICWill be ChangingN/A
ARI007Inbound Deposit DataInbound interface that provides direct journal and customer deposit information from agency business systems.DORWill be Changing
ARI007-Sample Data_CMS.txt
ARI010Inbound Direct Journal Deposit Spreadsheet UploadInbound interface file that provides direct journal and customer deposit information via a spreadsheet (Excel) upload.DFS, DORWill be Changing
ARI010-Spreadsheet Upload_CMS.zip
ARI022Inbound Returned Item Check DataInbound interface file that provides returned item check data including images.Wells FargoWill be ChangingN/A
ARI014Inbound Verified Deposit Data
(CMS Wave only)
Inbound interface to Florida PALM containing Departmental FLAIR verified deposit data to record deposits in Florida PALM.DFS - Enterprise SystemRetiringN/A
Outbound Interfaces
ARI012Outbound ACH NOC Deposit DataOutbound interface file that provides detailed ACH Notification of Change information transmitted to agencies.All AgenciesNo Changes
ARI012-Layout_CMS.xlsx
ARI012-Sample Data_CMS.txt
ARI027Outbound Deposits, TR Receipts, ADJ, and Returns Data
(CMS Wave only)
Outbound interface file that includes deposit data from Florida PALM to Central FLAIR (DOR Deposits, Bank Adjustments, Returned Items, and Treasury Receipts).DFS - Enterprise SystemRetiringN/A
ARI020Outbound Returned Items DataOutbound interface file that provides returned item data including images to agencies.All AgenciesWill be Changing
ARI020-Layout_CMS.xlsx
ARI020-Sample Data_CMS.txt


Cash Management CMS Interfaces

IDInterface NameInterface DescriptionAudienceFinancials Wave ImpactCMS Wave Interface File Layout Available for Agencies
Inbound Interfaces
CMI005Inbound External TransactionsDetailed data for banking transactions created from external systems.DFSWill be ChangingN/A
CMI017Inbound Previous Day Bank Statement Addenda File (NIC)Inbound interface containing addenda information for bank statements from banking partners for previous day statements.NICNo ChangesN/A
CMI015Inbound Previous Day Bank Statement Addenda File (Wells Fargo)Inbound interface containing addenda information for bank statements from Wells Fargo for previous day statements.Wells FargoNo ChangesN/A
CMI003Inbound Previous Day Bank Statement FileBAI2 information for bank statements from banking partners for previous day statements.Wells Fargo; JP Morgan ChaseNo ChangesN/A
Outbound Interfaces
CMI013Outbound BAI Bank StatementsOutbound interface containing BAI2 formatted previous day bank statement from Florida PALM to agencies.All AgenciesNo Changes
CMI013-Layout_CMS.xlsx
CMI013-Sample Data_CMS.txt
CMI009Outbound Bank Deposit Data
(CMS Wave only)
Outbound interface to Departmental FLAIR containing Bank Deposit data for deposit verification.DFS - Enterprise SystemRetiringN/A
CMI004Outbound Bank Deposit TransactionsDetailed bank deposit transactions by bank account distributed to agencies.All AgenciesNo Changes
CMI004-Layout_CMS.xlsx
CMI004-Sample Data_CMS.txt


General Ledger CMS Interfaces

IDInterface NameInterface DescriptionAudienceFinancials Wave ImpactCMS Wave Interface File Layout Available for Agencies
Inbound Interfaces
GLI039Inbound ChartField Mass Spreadsheet UploadInbound mass upload of ChartField values via Excel spreadsheet.DFS
(This interface will be available to All Agencies in Financials/Payroll Wave)
Will be Changing
GLI039-Mass-Upload_CMS.zip
GLI083Inbound COA Crosswalk Mass Spreadsheet Upload
(CMS Wave only)

Inbound mass upload of Chart of Accounts Crosswalk Rules mass spreadsheet upload using "Write to file" method.DFS - Enterprise SystemRetiringN/A
GLI065Inbound FLAIR Journals
(CMS Wave only)
Posted JT Transactions (Transfers) from Central FLAIR.DFS - Enterprise SystemRetiringN/A
GLI037Inbound Investment ActivityInbound interface containing participant transactions imported from external applications to record daily balances.DFSNo ChangesN/A
GLI011Inbound Journal Spreadsheet UploadInbound interface containing journal entries loaded into the system en masse via the spreadsheet (Excel) upload functionality for select agencies.All AgenciesWill be Changing
GLI011-Spreadsheet Upload_CMS.zip
Outbound Interfaces
GLI016Outbound COA Crosswalk Extract
(CMS Wave only)
Outbound interface to FFMIS partners and agencies containing the 29-digit FLAIR account code cross-walked from the Florida PALM Chart of Accounts. Produce an extract of the Florida PALM COA Crosswalk table.All AgenciesRetiring
GLI016-Layout_CMS.xlsx
GLI016-Sample Data (FULL)_CMS.txt
GLI016-Sample Data_CMS.txt
GLI046Outbound Daily Investment Information - IW
(CMS Wave only)
Outbound Daily Investment Information to Information Warehouse.All AgenciesRetiring
GLI046-IW-Layout_CMS.xlsx
GLI066Outbound Disinvestment and Apportionment Journals
(CMS Wave only)
Load of Journal Transactions to Central Accounting Transaction File (CTRF01) for manual audit or automatic posting (Post Trust Fund Disinvestment Journal Transfer).DFS - Enterprise SystemRetiringN/A
GLI010Outbound Interest ApportionmentOutbound interface containing interest apportionment amounts are interfaced to external applications.All AgenciesNo Changes
GLI010-Layout_CMS.xlsx
GLI010-Sample Data_CMS.txt
GLI047Outbound Monthly Investment & Interest - IW
(CMS Wave only)
Outbound Monthly Investment & Interest to Information Warehouse.All AgenciesRetiring
GLI047-IW-Layout_CMS.xlsx
GLI068Outbound Treasury Balances
(CMS Wave only)
Provides the cash balances as of the end of the period to Central FLAIR.DFS - Enterprise SystemRetiringN/A
GLI067Outbound Treasury Investment Balances
(CMS Wave only)
Provides GR and Trust Fund beginning balance and summary transactional data to Central FLAIR annually to assist in producing budget and trust fund annual reporting.DFS - Enterprise SystemRetiringN/A




Was this article helpful?
What's Next
The Florida PALM Knowledge Center serves as the central hub of information that helps agencies quickly and effectively adopt Florida PALM at Financials and Payroll Wave by providing quick access to the design of the system.
Change password!
Changing your password will log you out immediately. Use the new password to log back in.
Change profile
Success!
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.
Logout