Attachment I Anticipated Development Efforts.xlsx

XLSX spreadsheet 4 MB Posted

Attached to
SAP S/4HANA Implementation and Upgrade ServicesServices
Solicitation number
S000000321
Issued by
Arkansas

About this file

This document is related to a state and local contract opportunity for SAP S/4HANA Implementation and Upgrade Services for the state of Arkansas and the jurisdictions of Pulaski County and Little Rock City. The services requested include the conversion and migration of public sector master data, balances, and open items, as well as the implementation of end-to-end workflows across multiple functional areas such as Offer to Cash, Procure to Pay, Hire to Retire, and Plan to Report. The project overview details the anticipated development efforts, including custom conversions, standard migrations, open item conversions, and workflow considerations. No specific quantities, response dates, or award dates are provided.

The document does not contain details on pricing terms, set asides, incumbents, or funding sources. However, it does outline the current environment and the need to address chart of account changes, integrate with various systems such as Budget Preparation and HR/Payroll, and implement numerous custom reports and interfaces to support the state and local agencies.

View the file

Other files

File Type Posted
Attachment G Chart of Accounts and Financial Master Data Redesign Summary Presentation.pdf PDF
Attachment J Anticipated HR Payroll, Budget, and Travel Integration Scope~1.pdf PDF
S000000321 Contract and Grant Disclosure.pdf PDF
S000000321 Technical Proposal Packet REVISED.docx DOCX document
Attachment A Product and Software Version Information.pdf PDF
Attachment D Pain Points.pdf PDF
Attachment F Business Process Scope mapped to Roles, Modules and Re-Engineering Candidates.xlsx XLSX spreadsheet
Attachment L Requirements Traceability Matrix ? Software Requirements.xlsx XLSX spreadsheet
Attachment N DFA Information Systems AUCA.pdf PDF
S000000321 Technical Proposal Packet.docx DOCX document
S000000321 QandA .pdf PDF
Attachment B Technical Environment.pdf PDF
Attachment H Chart of Accounts and Financial Master Data Redesign Documentation.pdf PDF
S000000321 Official Solicitation Price Sheet.xlsx XLSX spreadsheet
S000000321 S4 HANA Upgrade and Implementation Services.pdf PDF
S000000321 Sample Services Contract.pdf PDF
S000000321 Official Solicitation Price Sheet REVISED 3.0.xlsx XLSX spreadsheet
S000000321 S4HANA Upgrade & Implementation Services REVISED RFP 3.0.pdf PDF
Attachment K Deployment Approach Options.pdf PDF
Attachment L Requirements Traceability Matrix Software Requirements.xlsx XLSX spreadsheet
Attachment C Landscape Systems.pdf PDF
Attachment E Transition Strategy for Migrating from As-Is Financial Model to To-Be Financial Model Documentation.pdf PDF
Attachment M Confidentiality Statement.pdf PDF
Attachment O Security_Policy_and_Controls.pdf PDF
Attachment P PE-03 Policy.pdf PDF
Attachment Q PE-17 Policy.pdf PDF
Show all 26

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Conversion Scope

TypeSub-TypeDescription of What's RequiredNeeded ForOther Needs Description
ConversionCustom Conversion of Public Sector Master DataFundsOtherRequired for Cutover
ConversionCustom Conversion of Public Sector Master DataFunds CentersOtherRequired for Cutover
ConversionCustom Conversion of Public Sector Master DataCommitment Items (high-level budget control objects)OtherRequired for Cutover
ConversionCustom Conversion of Public Sector Master DataFunded Programs (high-level)OtherRequired for Cutover
ConversionCustom Conversion of Public Sector Master DataFunctional AreasOtherRequired for Cutover
ConversionCustom Conversion of Public Sector Master DataGrantsOtherRequired for Cutover
ConversionCustom Conversion of Public Sector Master DataSponsored ProgramsOtherRequired for Cutover
ConversionCustom Conversion of Public Sector Master DataSponsored ClassesOtherRequired for Cutover
ConversionCustom Conversion of Public Sector Master DataALN Codes (formerly CFDA Codes)OtherRequired for Cutover
ConversionCustom Conversion of Public Sector BalancesFM BudgetOtherRequired for Cutover
ConversionCustom Conversion of Public Sector BalancesGM BudgetOtherRequired for Cutover
ConversionCustom Conversion of Public Sector Open ItemsEarmarked FundsOtherRequired for Cutover
ConversionCustom Conversion of Master Data without Standard Migration ObjectBuyersOtherRequired for Cutover
ConversionCustom Conversion of Master Data without Standard Migration ObjectDelivery AddressesOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness Partner (Vendor Role)OtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness Partner (Customer Role)OtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness Partner (State Agency Role)OtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness Partner (Sponsor Role)OtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness Partner (Grantee Role)OtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness Partner (Bank Role)OtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness Partner (Employee Role)OtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness Partner (Lessor Role)OtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness Partner (Lessee Role)OtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataProfit CentersOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBank DirectoryOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataCost CentersOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataGeneral Ledger AccountsOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataProjectsOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataWBS ElementsOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataInternal OrdersOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataPlant Maintenance OrdersOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataStatistical Key FiguresOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataUNSPSC Commodity CodesOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataService MastersOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataSales MaterialsOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataFixed AssetsOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataFunctional LocationsOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataEquipmentOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBills of MaterialsOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBusiness EntityOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataLandOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataBuildingOtherRequired for Cutover
ConversionStandard Migration of non Public Sector Master DataRental ObjectsOtherRequired for Cutover
ConversionLong Term DebtBondsOtherRequired for Cutover
ConversionLoansLoans GivenOtherRequired for Cutover
ConversionLoansLoans TakenOtherRequired for Cutover
ConversionFinancial BalancesPetty CashOtherRequired for Cutover
ConversionFinancial BalancesGeneral Ledger BalancesOtherRequired for Cutover
ConversionFinancial BalancesHouse Bank BalancesOtherRequired for Cutover
ConversionFinancial BalancesInvestments (multiple accounts)OtherRequired for Cutover
ConversionFinancial BalancesLoans/NotesOtherRequired for Cutover
ConversionFinancial BalancesBondsOtherRequired for Cutover
ConversionFinancial BalancesSales/Use Tax AccrualsOtherRequired for Cutover
ConversionFinancial BalancesInception to Date Balances for Active Projects (not Grants)OtherRequired for Cutover
ConversionFinancial BalancesGrant Award BudgetsOtherRequired for Cutover
ConversionFinancial BalancesInception to Date Balances for Active GrantsOtherRequired for Cutover
ConversionFinancial BalancesInception to Date Balances for Plant Maintenance OrdersOtherRequired for Cutover
ConversionFinancial BalancesAccumulated 1099 reportable paymentsOtherRequired for Cutover
ConversionFinancial BalancesInventory BalancesOtherRequired for Cutover
ConversionFinancial BalancesNew Year BudgetOtherRequired for Cutover
ConversionFinancial BalancesBudgets Carried ForwardOtherRequired for Cutover
ConversionOpen Item ConversionsContracts - Leases InOtherRequired for Cutover
ConversionOpen Item ConversionsVendor Credit Memos (MIRO)OtherRequired for Cutover
ConversionOpen Item ConversionsWork OrdersOtherRequired for Cutover
ConversionOpen Item ConversionsOutline AgreementsOtherRequired for Cutover
ConversionOpen Item ConversionsPurchase RequisitionsOtherRequired for Cutover
ConversionOpen Item ConversionsPurchase OrdersOtherRequired for Cutover
ConversionOpen Item ConversionsGoods ReceiptsOtherRequired for Cutover
ConversionOpen Item ConversionsInvoice ReceiptsOtherRequired for Cutover
ConversionOpen Item ConversionsDirect Vendor InvoicesOtherRequired for Cutover
ConversionOpen Item ConversionsVendor Credit Memos (FI)OtherRequired for Cutover
ConversionOpen Item ConversionsCustomer Open ItemsOtherRequired for Cutover
ConversionOpen Item ConversionsOutstanding WarrantsOtherRequired for Cutover
ConversionOpen Item ConversionsOutstanding ChecksOtherRequired for Cutover
ConversionOpen Item ConversionsDeposits in TransitOtherRequired for Cutover
ConversionOpen Item ConversionsTransfers in TransitOtherRequired for Cutover
ConversionOpen Item ConversionsOpen CommitmentsOtherRequired for Cutover
ConversionOpen Item ConversionsAccrual Objects (Accrual Engine)OtherRequired for Cutover

Workflow Scope

End-to-End ProcessModuleTypeObjectWorkflow ConsiderationsFilters
Offer to CashGLTransactionalCash JournalFlow from Cash Journal Poster through internal review.
Plan to ReportGLMaster DataGeneral Ledger Account Maintenance RequestRequest for Master Data Maintenance should flow from Agency to DFA Office of Accounting
Plan to ReportGLTransactionalGL JournalFrom Agency Approver to DFAFor any document that credits an appropriation
Plan to ReportGLTransactionalGL JournalFrom Initiator to Reviewer within an agency (multiple levels of review depending on contents of transaction (for example, dollar threshold exceeded and Information Technology related)For any document that does not credit an appropriation
Plan to ReportGLTransactionalInteragency JournalsWill flow from Sending Agency to Receiving Agency to DFA
Procure to PayPO_APMaster DataRequest to Change Business PartnersInitial entry to OSP
Procure to PayPO_APTransactionalContractsIntra-Agency: Multi-level as specified by agency requirements and OSP Procurement Rules

Inter-Agency: As specified by State Procurement Law and OSP Procurement Rules

Procure to PayPO_APTransactionalDirect Credit MemosFrom AP Specialist to AP Supervisor and possibly others depending on transaction contents.
Procure to PayPO_APTransactionalDirect InvoiceFrom AP Specialist to AP Supervisor and possibly others depending on transaction contents.
Procure to PayPO_APTransactionalGoods ReceiptFrom Goods Receipt Specialist to Fixed Asset AccountantFor Asset Related Receipts
Procure to PayPO_APTransactionalGoods ReceiptFrom Goods Receipt Specialist to Inventory AccountantFor Inventory Related Receipts
Procure to PayPO_APTransactionalGoods ReceiptFrom Goods Receipt Specialist (and/or Fixed Asset Accountant) to Grant AccountantFor Grant Funded Procurements Receipts
Procure to PayPO_APTransactionalGoods Return /CancellationFrom Goods Receipt Specialist to Fixed Asset Accountant
Procure to PayPO_APTransactionalGoods Return /CancellationFrom Goods Receipt Specialist to Inventory Accountant
Procure to PayPO_APTransactionalGoods Return /CancellationFrom Goods Receipt Specialist (or Fixed Asset Accountant) to Grant Accountant
Procure to PayPO_APTransactionalLIV Credit MemoFrom AP Specialist to AP Supervisor and possibly others depending on transaction contents.
Procure to PayPO_APTransactionalLogistics InvoiceFrom AP Specialist to AP Supervisor and possibly others depending on transaction contents.
Procure to PayPO_APMaster DataNew VendorsInitial input by OSP, routed to DFA for review of financial and control impactsFor vendors extended for purchasing.
Procure to PayPO_APTransactionalPurchase OrdersFrom Buyer to Procurement Manager
Procure to PayPO_APTransactionalPurchase OrdersFrom Procurement Manage to Statewide ApproversAs specified by State Procurement Law and OSP Procurement Rules
Procure to Pay
Procure to PayPO_APTransactionalRequisitionsFrom Requisitioner to multiple approvers
Procure to PayPO_APTransactionalRFx
Procure to PayPO_APMaster DataUNSPSC Code Maintenance RequestRequest for Master Data Maintenance should flow from Agency to OSP Master Data Maintainers
Hire to Retire - TravelTravelTransactionalTravel AuthorizationFrom requestor to Supervisor for review and approval
Hire to Retire - TravelTravelTransactionalTravel AuthorizationFrom Supervisor to Grant Accountant if grant funded
Hire to Retire - TravelTravelTransactionalTravel Reimbursement RequestsRoute to Supervisor and/or Fiscal for review
Offer to CashGrantee ManagementMaster DataDiscretionary Grant ApplicationsRoute for Legislative ReviewNeed to determine how to recognize a discretionary grant
Offer to CashGrantee ManagementTransactionalGrant Budget TransactionsFrom Grant Accountant to FM Budget Manager
Offer to CashGrantee ManagementMaster DataGrant Master Data UpdatesRoute to Grants Business Process Owner for review and downstream activities (GMDERIVE)
Offer to CashGrantee ManagementMaster DataNew GrantsRoute to Grants Business Process Owner for review and downstream activities (GMDERIVE)Grants in Earliest Status (unless it's better to wait for the award to trigger workflow)
Offer to CashGrantee ManagementMaster DataSponsor Business Partner Maintenance RequestFrom Requestor to Maintainer
Offer to CashGrantee ManagementMaster DataSponsored ClassesFrom Requestor to Maintainer
Offer to CashGrantee ManagementMaster DataSponsored ProgramsFrom Requestor to Maintainer
Offer to CashSD_ARTransactionalContractsRoute to Internal ApproverShould these flow for Legislative Review?
Offer to CashSD_ARTransactionalDirect Bill - CustomersFrom Accounts Receivable Specialist to Accounts Receivable Management
Offer to CashSD_ARMaster DataRequests for Existing Customer MaintenanceFrom Requestor to Maintainer
Offer to CashSD_ARMaster DataRequests for New CustomersFrom Requestor to Maintainer
Offer to CashSD_ARMaster DataRequests for Sales MaterialFrom requestor to Sales Material Maintainer for review and approval
Offer to CashSD_ARTransactionalSales OrderRoute to Internal ApproverSales Order will serve as approval step for subsequent Billing Document.
Plan to ReportFMTransactionalEarmarked Funds DocumentRoute to Internal Approver
Plan to ReportFMTransactionalFM Budget Maintenance DocumentsFor Appropriation Changes: From Agency Budget Manager to Office of Accounting
Plan to ReportFMTransactionalFM Budget Maintenance DocumentsFor Agency Budget Changes: from Agency Budget Analyst to Agency Budget Manager.
Acquire to RetireFixed AssetsTransactionalAcquisition Documents (other than PO)Route from Agency to ACFR Fixed Asset Analysts
Acquire to RetireFixed AssetsTransactionalAsset ImpairmentsRoute from initiating agency to ACFR for review and approval.
Acquire to RetireFixed AssetsTransactionalAsset Transfers across AgenciesRoute from Sending to Receiving to ACFR for final review.
Acquire to RetireFixed AssetsMaster DataFixed Asset ShellsRoute to Internal ApproverFor particular asset classes, such as CLM Right to Use Assets.
Acquire to RetirePlant Maintenance - FleetMaster DataEquipmentRoute to Internal Approver
Acquire to RetirePlant Maintenance - FleetTransactionalMaintenance RequestsFrom Requester to Plant Maintenance Supervisor
Acquire to RetirePlant Maintenance - Buildings and GroundsMaster DataEquipmentRoute to Internal Approver
Acquire to RetirePlant Maintenance - Buildings and GroundsTransactionalMaintenance RequestsFrom Requester to Plant Maintenance Supervisor
Acquire to RetireCLMMaster DataBusiness EntityFrom Requester to Approvers (Division of Building Authority or other Real Estate Management Entity)
Acquire to RetireCLMMaster DataLandFrom Requester to Approvers (Division of Building Authority or other Real Estate Management Entity)
Acquire to RetireCLMMaster DataRental SpaceFrom Requester to Approvers (Division of Building Authority or other Real Estate Management Entity)
Acquire to RetireCLMMaster DataRequest for Business Partner MaintenanceFrom Requester to Approvers (Division of Building Authority or other Real Estate Management Entity)
Plan to ReportGLTransactionalCustom workflow for line item repostingsCurrently not work-flow enabled.

• Agency review and approval prior to posting - Manager approval only when the document does not cross appropriations

• Agency and DFA approval for expenditure error corrections that cross appropriations, funds and/or agencies

• Agency and DFA approval for all revenue corrections

• User Notifications if the posting will result in due to/due from postings which would require follow-on settlements (e.g., Treasury Transfers (Cash in Transit In / Out)

• Possible workflow or notifications for reversals of reposting

Procure to PayGrantor ManagementTransactionalApplications
Procure to PayGrantor ManagementTransactionalAwards
Procure to PayGrantor ManagementTransactionalClaims
Procure to PayGrantor ManagementTransactionalAutomatic notices to requestorse.g., Communications, Notices, Reminders

Potential Intfc Scope

Anticipated Interface Scope Object
Inbound Bank Master Data API
Inbound Financial Transaction API
Inbound ISO Code Maintenance
Inbound Payment Card Merchant Interface for Transparency
Inbound Payment Card Interface to BW for Transparency
Inbound TBD - Vendor Self-Service
Inbound Vendor Maintenance API
Outbound Asset Balances
Outbound Asset Master Data Extract
Outbound Auditor of State Beginning Appropriation Balances
Outbound Depreciation Extract
Outbound Financial Transaction Interface
Outbound fund transfers Interface
Outbound Funds Management Budget Transaction Interface
Outbound Marketing and Redistribution Asset Interface
Outbound Payment Transaction Interface
Outbound TBD - Vendor Self-Service
Outbound Treasury Positive Pay Interface
Outbound Vendor Bank Account Interface
Outbound Vendor Master Data API

Potential Intfc Analysis

SourceJob NameFrequencyAgency NameBA NameIn or OutScopeS4HANA API Integration Available - Y/NS4HANA Functionality S4HANA API Integration via standard Fiori App = Y/nDispositionAnticipated Interface Scope Object
FIAA-AMZS_FIAA_DIS WEEKLY DEPRECIATIONWeekly470DEPT OF INFORMATION SYSTEMSOutboundFile of depreciation documents (Modified and Full) posted the previous week. DIS uses this to feed their quasi-dashboard management reporting tool.YNERROR:#REF!Outbound Depreciation Extract
FIAA-AMZS_FIAA_DIS_ACTIVE_ASSETS*Daily, Mon-Sun470DEPT OF INFORMATION SYSTEMSOutboundFile of all DIS active assets. DIS uses this list in their internal system to determine if an asset is active in SAP.NNSince no APIs exist, if this legacy system continues, then we will need to rebuild.Outbound Asset Master Data Extract
FIAA-AMZS_FIAM_ASSET_EXTRACT*Daily, Mon-Sun900DEPT OF PARKS AND TOURISMOutboundDPHT, at least Parks & Tourism, maintains an asset database for inventory control.NNSince no APIs exist, if this legacy system continues, then we will need to rebuild.Outbound Asset Master Data Extract
FIAA-AMZS_FIAM_DRP_ASSET_LISTEvery 2 weeks470DEPT OF INFORMATION SYSTEMSOutboundExtract for DIS of assets covered by their Disaster Recovery Planning effort. DIS supports all state agencies on Disaster Recovery plans/efforts related to IT.NNSince no APIs exist, if this legacy system continues, then we will need to rebuild.Outbound Asset Master Data Extract
FIAA-AMZS_FIAM_FALIST_FLATFILE*Daily, Mon-Sun470DEPT OF INFORMATION SYSTEMSOutboundExtract of custom report ZFI_FALIST, which provides more detailed information than the standard Asset History Sheet. DIS uses this in their quasi-workbench.NNSince no APIs exist, if this legacy system continues, then we will need to rebuild.Outbound Asset Balances
FIAA-AMZS_FIAM_FALIST_FLATFILE*Daily, Mon-Sun470DEPT OF INFORMATION SYSTEMSOutboundExtract of custom report ZFI_FALIST, which provides more detailed information than the standard Asset History Sheet. Not sure what Game & Fish does with this.NNSince no APIs exist, if this legacy system continues, then we will need to rebuild.Outbound Asset Balances
FIAA-AMZS_FIAM_ASSET_EXT ASSETWKS*Daily914STATEWIDE SHARED SERVICESOutboundM&R AssetWorks daily extractNNSince no APIs exist, if this legacy system continues, then we will need to rebuild.Outbound Marketing and Redistribution Asset Interface
FIAPZS_FIAP_AGY_SALARY_EXTRACT 1ST QYearly610DEPT OF FINANCE AND ADMINOutboundFeeds the custom table that supports the Actual Cost by Position report.YYTBD, dependent on HR/Payroll and Budget Preparation solutions.None
FIAPZS_FIAP_AGY_SALARY_EXTRACT 2ND QYearly610DEPT OF FINANCE AND ADMINOutboundFeeds the custom table that supports the Actual Cost by Position report.YYTBD, dependent on HR and PBAS solutions.None
FIAPZS_FIAP_AGY_SALARY_EXTRACT 3RD QYearly610DEPT OF FINANCE AND ADMINOutboundFeeds the custom table that supports the Actual Cost by Position report.YYTBD, dependent on HR and PBAS solutions.None
FIAPZS_FIAP_AGY_SALARY_EXTRACT 4TH QYearly610DEPT OF FINANCE AND ADMINOutboundFeeds the custom table that supports the Actual Cost by Position report.YYTBD, dependent on HR and PBAS solutions.None
FIAPZS_FIAP_BANK_EXTRACT*Daily, Mon-Sun69TREASURER OF STATEOutboundVendor Bank Information in Support of ACH payment validations.YNLeverage standard "Bank " Odata v4 APIs to read / manage bank dataOutbound Vendor Bank Account Interface
FIAPZS_FIAP_BSEG INBOUND*Daily, Mon-FriPotentially, any agency can submit an interfaceInboundInbound files of A/P documents, A/R documents and journal entries submitted by agencies, departments, colleges and universities. These files are processed ahead of the nightly statewide payment run. Does not include inbound bseg files received from AIRS (Tax and DSMV files from the Arkansas Integrated Revenue System). Those files are processed at a different time to support their business process.YNEvaluate options for integration during Fit to Standard effort.Inbound Financial Transaction API
FIAPZS_FIAP_BSEG INBOUND Y630*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVInboundInbound files Treasury Deposit documens submitted from the Arkansas Integrated Revenue System (AIRS) (DSMV Unit)YNEvaluate options for integration during Fit to Standard effort.Inbound Financial Transaction API
FIAPZS_FIAP_BSEG INBOUND Y630*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVInboundInbound files of A/P documents documens submitted from AIRS (DSMV Unit)YNEvaluate options for integration during Fit to Standard effort.Inbound Financial Transaction API
FIAPZS_FIAP_BSEG INBOUND Y630*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVInboundInbound files Treasury Deposit documens submitted from AIRS (Tax Unit)YNEvaluate options for integration during Fit to Standard effort.Inbound Financial Transaction API
FIAPZS_FIAP_BSEG INBOUND Y630*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVInboundInbound files of A/P documents documens submitted from AIRS (Tax Unit)YNEvaluate options for integration during Fit to Standard effort.Inbound Financial Transaction API
FIAPZS_FIAP_BSEG OUT 0710 MONTHLYMonthly710AR DEPT OF HUMAN SERVICESOutboundMonthly Extract of DHS Transactions for reconciliation with Legacy SystemsNNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundFile of Check/EFT Reversals for previous AIRS deposits (DSMV Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundFile of Reversals of previous EFTs receipted by AIRS (DSMV Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundFile of NFS checks previously receipted by AIRS (DSMV Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundAASIS document information for the last Deposit submitted from AIRS (DSMV Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundAASIS document information for the last "true-up" file submitted from AIRS (DSMV Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundAASIS document information for the last A/P file submitted from AIRS (DSMV Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundFile of Check/EFT Reversals for previous AIRS deposits (Tax Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundFile of Reversals of previous EFTs receipted by AIRS (Tax Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundFile of NFS checks previously receipted by AIRS (Tax Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundAASIS document information for the last Deposit submitted from AIRS (Tax Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundAASIS document information for the last "true-up" file submitted from AIRS (Tax Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND AIRS*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVOutboundAASIS document information for the last A/P file submitted from AIRS (Tax Unit)NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND*Daily, Mon-FriAll othersOutboundOutbound Financial Transaction information with AASIS document Number returned from Inbound Interfaces.NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND*Daily, Mon-Fri710AR DEPT OF HUMAN SERVICESOutboundOutbound Financial Transaction information with AASIS document Number returned from Inbound Interfaces.NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND*Daily, Mon-Fri710AR DEPT OF HUMAN SERVICESOutboundOutbound Financial Transaction information with AASIS document Number returned from Inbound Interfaces.NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND*Daily, Mon-Fri645AR DEPARTMENT OF HEALTHOutboundOutbound Financial Transaction information with AASIS document Number returned from Inbound Interfaces.NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND*Daily, Mon-Fri9OutboundOutbound Financial Transaction information with AASIS document Number returned from Inbound Interfaces.NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND*Daily, Mon-FriMultipleOutboundOutbound Financial Transaction information with AASIS document Number returned from Inbound Interfaces.NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG OUTBOUND MTHLY 0645Monthly, 21st645AR DEPARTMENT OF HEALTHOutboundOutbound Financial Transaction information with AASIS document Number returned from Inbound Interfaces.NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_BSEG_OUT_DWS_FULL MNTHLYMonthly810DEPT OF WORKFORCE SERVICESOutboundExtract for DWS to feed their cost allocation system (S4HANA Public Cloud).NNInclude in Known Development EffortsOutbound Financial Transaction Interface
FIAPZS_FIAP_CHRIS_VENDOR 0710*Daily, Mon-Fri710AR DEPT OF HUMAN SERVICESInboundDHS submits a file of new vendors from their CRIS (Foster Care) system to create them as AASIS vendors in the CRIS vendor group. OSP has nothing to do with these vendors. They are maintained entirely by DHS, normally through a file but a few people have manual vendor maintenance authorizations for this group.YNERROR:#REF!Inbound Vendor Maintenance API
FIAPZS_FIAP_CHRIS_VENDOR 0710*Daily, Mon-Fri710AR DEPT OF HUMAN SERVICESOutboundReturn file with the AASIS vendor number for the CRIS vendors submitted on the file above. DHS uses this in one of their legacy systems.YNERROR:#REF!Outbound Vendor Master Data API
FIAPZS_FIAP_DAILY CLAIMS EXTRACT*Daily, Mon-Sun610DEPT OF FINANCE AND ADMINOutboundWorker's Comp Claims Extract feeds into the DFA Unemployment and Workders Comp Claims system that produces quarterly billing for Workers Comp and UnemploymentYNERROR:#REF!Outbound Financial Transaction Interface
FIAPZS_FIAP_EMPLOYEE VENDOR EXTR*Daily, Mon-Sat710AR DEPT OF HUMAN SERVICESOutboundDHS receives a file of their current employee vendor master numbers that they feed into their legacy TR-1 system. That system produces an inbound bseg file of vendor payments to employee vendors for travel reimbursements.YNERROR:#REF!Outbound Vendor Master Data API
FIAPZS_FIAP_EMPLOYEE VENDOR EXTR*Daily, Mon-Sat645AR DEPARTMENT OF HEALTHOutboundADH receives a file of their current employees employee vendor master numbersYNERROR:#REF!Outbound Vendor Master Data API
FIAPZS_FIAP_EMPLOYEE VENDOR EXTR*Daily, Mon-Sat9908DEPT OF HUMAN SERVICESOutboundDHS receives a file of their current employee vendor master numbers that they feed into their legacy TR-1 system. That system produces an inbound bseg file of vendor payments to employee vendors for travel reimbursements. The only employee currently assigned to 9908 is the Secretary.YNERROR:#REF!Outbound Vendor Master Data API
FIAPZS_FIAP_FED_REFUNDS_REIMB*Daily, Mon-Sun620DFA - DISBURSING OFFICEROutboundExtract from AASIS to feed DFMS, a very limited grant expenditure tracking software used for CARES, ARPA-SLFRF and ARPA-CPF; this might be finished before we go live with S/4.YNThis might be finished before we go live with S/4.None
FIAPZS_FIAP_FUND_TRANSFERS*Daily, Mon-Sun620DFA - DISBURSING OFFICEROutboundExtract from AASIS to feed DFMS, a very limited grant expenditure tracking software used for CARES, ARPA-SLFRF and ARPA-CPF; this might be finished before we go live with S/4.NNThis might be finished before we go live with S/4.None
FIAPZS_FIAP__MINORITY_UNV_EXTWeekly135U OF A FAYETTEVILLEOutboundMaster Data for Minority Indicator informationYNERROR:#REF!Outbound Vendor Master Data API
FIAPZS_FIAP_OIT_VENDOR INFOEvery 2 weeks470 FiscalOutboundVendor ExtractYNERROR:#REF!Outbound Vendor Master Data API
FIAPZS_FIAP_PARKDOC*Daily, Mon-Sat470DEPT OF INFORMATION SYSTEMSOutboundExtract of parked A/P documents; DIS uses this to feed a quasi-workbench for their internal management reporting or for other integration required by their legacy systems.NNEvaluate Fit-to-Standard firstNone
FIAPZS_FIAP_PARKDOC*Sun710AR DEPT OF HUMAN SERVICESOutboundExtract of parked A/P documents; DHS uses this to feed their Optum Medicaid system workbench.NNEvaluate Fit-to-Standard firstNone
FIAPZS_FIAP_TANF_VENDOR 0810*Daily, Mon-Fri810DEPT OF WORKFORCE SERVICESInboundIncoming file of TANF VendorsNNTo use Odata v2 APIs, There's standard API business partner "Supplier".Inbound Vendor Maintenance API
FIAPZS_FIAP_TANF_VENDOR 0810*Daily, Mon-Fri810DEPT OF WORKFORCE SERVICESOutboundReturn file with the AASIS vendor number..YResearch RequiredTo use Odata v2 APIs, There's standard API business partner "Supplier".Outbound Vendor Master Data API
FIAPZS_FIAP_VEND_ADE*Daily, Mon-Fri500DEPARTMENT OF EDUCATIONOutboundVendor extract of specific vendor groups of interest to Dept of Education (Public School vendors and some others). They load this in their legacy system to produce spreadsheets that they upload into AASIS to park A/P invoices.NNTo use Odata v2 APIs, There's standard API business partner "Supplier".Outbound Vendor Master Data API
FIAPZS_FIAP_VEND_MAST 0810*Daily, Mon-Sun810DEPT OF WORKFORCE SERVICESOutboundVendor Master DataYNTo use Odata v2 APIs, There's standard API business partner "Supplier".Outbound Vendor Master Data API
FIAPZS_FIAP_VENDOR LIST 0710*Daily, Mon-SatMultipleAR DEPT OF HUMAN SERVICESOutboundVendor Master DataYNTo use Odata v2 APIs, There's standard API business partner "Supplier".Outbound Vendor Master Data API
FIAPZS_FIAP_VOIDS*Daily, Mon-Sun59OutboundFile to the Auditor of State of all warrants/ACH's voided by DFA the previous dayResearch RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_VOIDS*Daily, Mon-Sun69TREASURER OF STATEOutboundFile to the Treasurer of State of all warrants/ACH's voided by DFA the previous dayResearch RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT LIST 0630*Daily, Mon-Sat630DFA - REVENUE SERVICES DIVOutboundMultiple Extracts for AIRS Tax information (both Tax Unit and DSMV Unit)Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT LIST*Daily, Mon-FriAll othersOutboundThis program is intended to be able to create a list showing the warrants (checks) produced as the result of AP requests sent through the BSEG inbound interface.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT LIST*Daily, Mon-Fri135U OF A FAYETTEVILLEOutboundThis program is intended to be able to create a list showing the warrants (checks) produced as the result of AP requests sent through the BSEG inbound interface.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT LIST*Daily, Mon-Fri710AR DEPT OF HUMAN SERVICESOutboundThis program is intended to be able to create a list showing the warrants (checks) produced as the result of AP requests sent through the BSEG inbound interface.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT LIST*Daily, Mon-Fri810DEPT OF WORKFORCE SERVICESOutboundThis program is intended to be able to create a list showing the warrants (checks) produced as the result of AP requests sent through the BSEG inbound interface.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT LIST*Daily, Mon-Fri810DEPT OF WORKFORCE SERVICESOutboundTrade Adjustment Assistance PaymentsResearch RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT LIST*Daily, Mon-Fri520ADWS - REHABILITATION SERVICESOutboundPayment Information for Arkansas Rehabilitation Services InFormed systemResearch RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_NEW_EXT*Daily, Mon-Sat710AR DEPT OF HUMAN SERVICESOutboundExtract of all items added to ZWARR_DETAIL the previous day for DHS. I think this is feeding their dashboard.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_NEW_EXT*Daily, Mon-Sat520ADWS - REHABILITATION SERVICESOutboundExtract of all items added to ZWARR_DETAIL the previous day for Department of Workforce Services Division of Services for the Blind.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_NEW_EXT*Daily, Mon-Sat470DEPT OF INFORMATION SYSTEMSOutboundExtract of all items added to ZWARR_DETAIL the previous day for DIS. This feeds their internal quasi-workbench used by management.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_NEW_EXT*Daily, Mon-Sat370AR PUBLIC EMPLOYEES RETIREMENTOutboundExtract of all items added to ZWARR_DETAIL the previous day for APERS. This might be feeding Compass to track payments to retirees.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_NEW_EXT*Daily, Mon-Sat610DEPT OF FINANCE AND ADMINOutboundExtract of all items added to ZWARR_DETAIL the previous day for Intergovernmental Services feeding legacy system that tracks grant expenditures for Intergovernmental Services.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_NEW_EXT*Daily, Mon-Sat710AR DEPT OF HUMAN SERVICESOutboundExtract of all items added to ZWARR_DETAIL the previous day for DHS that feeds their Medicaid system. AASIS tracks Medicaid expenditures in summary, this is more for administrative costs and funding from their Treasury funds.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_NEW_EXT*Daily, Mon-Sat9908DEPT OF HUMAN SERVICESOutboundExtract of all items added to ZWARR_DETAIL the previous day for DHS. I think this is feeding their dashboard. They had to have a separate file for 9908 because their developers hard-coded everything to 0710 (their only BA before Transformation) and apparently it would be too invasive to change that.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_DFMS_EXT*Daily, Mon-Sun620DFA - DISBURSING OFFICEROutboundExtract from AASIS to feed DFMS, a very limited grant expenditure tracking software used for CARES, ARPA-SLFRF and ARPA-CPF; this might be finished before we go live with S/4.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_DFMS_EXT*Daily, Mon-Sun620DFA - DISBURSING OFFICEROutboundExtract from AASIS to feed DFMS, a very limited grant expenditure tracking software used for CARES, ARPA-SLFRF and ARPA-CPF; this might be finished before we go live with S/4.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_WARRANT_DET_DFMS_MNTHLYMonthly620DFA - DISBURSING OFFICEROutboundExtract from AASIS to feed DFMS, a very limited grant expenditure tracking software used for CARES, ARPA-SLFRF and ARPA-CPF; this might be finished before we go live with S/4.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Payment Transaction Interface
FIAPZS_FIAP_ZPOEXTRACT*Daily, Mon-Sat470DEPT OF INFORMATION SYSTEMSOutboundExtract of open POs (based on partial clone of a standard ME?N transaction). This feeds DIS's quasi-workbench of management data.YNEvaluate Fit-to-Standard firstNone
FIAPZS_FIAP_ZWARRANT_DETAIL 0645*Daily, Mon-Sat645AR DEPARTMENT OF HEALTHOutboundExtract of Zwarrant DetaiilResearch RequiredResearch RequiredEvaluate Fit-to-Standard firstNone
FIAPZS_FIAP_ZWARRANT_DETAIL_0710_MTHMonthly710AR DEPT OF HUMAN SERVICESOutboundExtract of all items added to ZWARR_DETAIL the previous day for DHS. I think this is feeding their dashboard.Research RequiredResearch RequiredEvaluate Fit-to-Standard firstNone
FIAPZS_FIAP_ZWARRANT_DETAIL_0710_MTHMonthly9908DEPT OF HUMAN SERVICESOutboundExtract of all items added to ZWARR_DETAIL the previous day for DHS. I think this is feeding their dashboard. They had to have a separate file for 9908 because their developers hard-coded everything to 0710 (their only BA before Transformation) and apparently it would be too invasive to change that.Research RequiredResearch RequiredEvaluate Fit-to-Standard firstNone
FIARZS_FIAR_DIS_AGING REPORT*Daily, Mon-Fri470DEPT OF INFORMATION SYSTEMSOutboundExtract of aging on open customer documents. DIS uses this to feed their quasi-dashboard for management and to support their custom (manual?) dunning.Research RequiredResearch RequiredEvaluate Fit-to-Standard firstNone
FICMZS_FICM_BANKS_MAINTMonthly0InboundUpdates AASIS bank master data based on Federal Reserve file, though I think now maybe we get it from Bank of America. Must ask Shaun about this part.YNERROR:#REF!Inbound Bank Master Data API
FICMZS_FICM_TREASURY_BAIFILE_IMP*Daily, Mon-Fri69TREASURER OF STATEInboundElectronic Bank Statement file (BAI format) received from Treasury Monday-Friday. TREGEN is non-payroll (House Bank TREAS/Account TREA1). TREPAY is payroll (House Bank TREAP/Account TREA2).Research RequiredResearch RequiredEvaluate Fit-to-Standard firstNone
FICOZS_FICO_ACTUAL_COST_CENTER*Daily, Mon-Fri470DEPT OF INFORMATION SYSTEMSOutboundFile of activity for currently valid cost centers for DIS created that day.YNEvaluate Fit-to-Standard firstNone
FICOZS_FICO_ACTUAL_COST_CENTER*Daily, Mon-Fri470DEPT OF INFORMATION SYSTEMSOutboundFile of activity for currently valid cost centers for DIS. The "Monday" variant covers the weekend. We don't generally create cost centers on weekends now, but in the Wild West early days we occasionally did.YNEvaluate Fit-to-Standard firstNone
FIFMZS_FIFM_0645_OPEN_COMMIT_EXT*Daily, Mon-Sat645AR DEPARTMENT OF HEALTHOutboundExtract from ZCMT report (open commitments).NNEvaluate Fit-to-Standard firstNone
FIFMZS_FIFM_0645_OPEN_COMMIT_EXT*Daily, Mon-Sat470DEPT OF INFORMATION SYSTEMSOutboundExtract from ZCMT report (open commitments). DIS uses it to feed their quasi-dashboard.NNEvaluate Fit-to-Standard firstNone
FIFMZS_FIFM_0645_OPEN_COMMIT_EXT*Sun710AR DEPT OF HUMAN SERVICESOutboundExtract from ZCMT report (open commitments). DHS uses it to feed their dashboard and/or other legacy systems.NNEvaluate Fit-to-Standard firstNone
FIFMZS_FIFM_AUDITOR*Monthly59OutboundOriginally a monthly file of all FI documents that affect appropriation (not budget transfers). The Auditor uses it to verify they've received everything via the daily files. It's now sent daily, but the Auditor doesn't have a set schedule for picking it up. Basically used for on-demand reconciliation with DFA-OA(S).NNAdjust to S/4 Master Data Structures.Outbound Financial Transaction Interface
FIFMZS_FIFM_AUDITOR SEMI MONTHLYMonthly59OutboundSame as job above, also now run daily (yes, that means two identical files). The Auditor uses it to verify they've received everything via the daily files. It's now sent daily, but the Auditor doesn't have a set schedule for picking it up. Basically used for on-demand reconciliation with DFA-OA(S).NNAdjust to S/4 Master Data Structures.Outbound Financial Transaction Interface
FIFMZS_FIFM_FM DOCS TO AUDITOR*Daily, Mon-Sat59OutboundDaily file of budget transfers, blocks and other documents to the Auditor of State.Research RequiredResearch RequiredAdjust to S/4 Master Data Structures.Outbound Funds Management Budget Transaction Interface
FIFMZS_FIFM_FMFO_SPOOL_FTP*Daily, Mon-SatAASISOutboundCreates a file of the FMF0 error log for ASC use.Research RequiredResearch RequiredNo Longer RequiredNone
FIGLZS_FIGL_AIRS DSMV ACTIVITY*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVInboundFile of "true-up" adjusting entries from AIRS (DSMV Unit)NNThere is a standard SOAP API (Asynchronous) JournalEntryBulkCreationRequest_In to manage Journal entries.Inbound Financial Transaction API
FIGLZS_FIGL_AIRS R630 TAX ACT*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVInboundFile of EFT/Check reversals (ZA and ZB doc types) from AIRS (DSMV Unit)NNthere is a standard SOAP API (Asynchronous) JournalEntryBulkCreationRequest_In to manage Journal entries.Inbound Financial Transaction API
FIGLZS_FIGL_AIRS TAX ACTIVITY*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVInboundFile of "true-up" adjusting entries from AIRS (Tax Unit)NNthere is a standard SOAP API (Asynchronous) JournalEntryBulkCreationRequest_In to manage Journal entries.Inbound Financial Transaction API
FIGLZS_FIGL_AIRS X630 TAX ACT*Daily, Mon-Fri630DFA - REVENUE SERVICES DIVInboundFile of EFT/Check reversals (ZA and ZB doc types) from AIRS (Tax Unit)NNthere is a standard SOAP API (Asynchronous) JournalEntryBulkCreationRequest_In to manage Journal entries.Inbound Financial Transaction API
FIGLZS_FIGL_ASA RECON REPORTMonthly610DEPT OF FINANCE AND ADMINOutboundOne of the files feeding ZRASCAL. This captures Special Revenue cash activityResearch RequiredResearch RequiredNo Longer NeededNone
FIGLZS_FIGL_AUDITOR EEC RTE*Daily, Mon-Sun59OutboundCreates file of Expense Error Corrections that affect appropriation balances for Auditor of State.NNAdjust to S/4 Master Data StructuresOutbound Financial Transaction Interface
FIGLZS_FIGL_DIS ZFINLEDA WEEKLYWeekly470DEPT OF INFORMATION SYSTEMSOutboundFile of all activity in the SPL for DIS. They use this to feed their quasi-dashboard for management review.Research RequiredResearch RequiredEvaluate Fit-to-Standard firstNone
FIGLZS_FIGL_DOC_HEADERLINES ZGLD*Daily, Mon-Sat470DEPT OF INFORMATION SYSTEMSOutboundFile of all activity in the SPL for DIS. This report provides more information than is availalble in SPL (clearing information, text fields, etc.) They use this to feed their quasi-dashboard for management review.NNEvaluate Fit-to-Standard firstNone
FIGLZS_FIGL_DOC_HEADERLINES ZGLD*Sun710AR DEPT OF HUMAN SERVICESOutboundFile of all activity in the Special Purpose Ledger for Department of Human Services. This report provides more information than is availalble in SPL (clearing information, text fields, etc.) They use this to feed their quasi-dashboard for management review.NNEvaluate Fit-to-Standard firstNone
FIGLZS_FIGL_DOC_HEADERLINES ZGLD*Sun645AR DEPARTMENT OF HEALTHOutboundFile of all activity in the SPL. This report provides more information than is availalble in SPL (clearing information, text fields, etc.). Health Dept uses this to support their cost allocations and other internal reporting.NNEvaluate Fit-to-Standard firstNone
FIGLZS_FIGL_DOC_HEADERLINES ZGLD*Sun710AR DEPT OF HUMAN SERVICESOutboundFile of all activity in the SPL. This report provides more information than is availalble in SPL (clearing information, text fields, etc.). DHS uses this to support their cost allocations and other internal reporting and dashboards.NNEvaluate Fit-to-Standard firstNone
FIGLZS_FIGL_DOC_HEADERLINES ZGLD*Sun810DEPT OF WORKFORCE SERVICESOutboundFile of all activity in the SPL. This report provides more information than is availalble in SPL (clearing information, text fields, etc.). DWS uses this in their cost allocation system (S/4HANA Public Cloud).NNEvaluate Fit-to-Standard firstNone
FIGLZS_FIGL_FUND TRANSFERS*Daily, Mon-Sat59OutboundCreate outbound file to Auditor of State of all Treasury fund (cash) transfers posted previous day. Might be able to eliminate if there is no legislation that says if we send data to the Treasurer, we have to send it to the Auditor and vice versa. It was determined at the time that this file met the requirements to go to both.NNAdjust to S/4 Master DataOutbound fund transfers Interface
FIGLZS_FIGL_FUND TRANSFERS*Daily, Mon-Sat69TREASURER OF STATEOutboundCreate outbound file to Treasurer of State of all Treasury non-payroll fund (cash) transfers posted previous day.YNAdjust to S/4 Master DataOutbound fund transfers Interface
FIGLZS_FIGL_FUND TRANSFERS*Daily, Mon-Sat69TREASURER OF STATEOutboundCreate outbound file to Treasurer of State of all Treasury non-payroll fund (cash) transfers posted previous day.YNAdjust to S/4 Master DataOutbound fund transfers Interface
FIGLZS_FIGL_TREAS_RRC_INT*Daily69TREASURER OF STATEOutboundCreates file of Treasury fund Revenue Receipt Corrections for Treasurer of State.Z_EXTRACT_RM06EK00NAdjust to S/4 Master DataOutbound Financial Transaction Interface
FIGLZS_FIGL_TREAS_RRC_INT*Daily59OutboundCreates file of Treasury fund Revenue Receipt Corrections for Auditor of State. **The Auditor doesn't actually need or want this information, but there is (or was; need to check) legislation that says if we send data to the Treasurer, we have to send it to the Auditor and vice versa. It was determined at the time that this file met the requirements to go to both.YNAdjust to S/4 Master DataOutbound Financial Transaction Interface
FIGLZS_FIGL_ZB DOCUMENTS TO TREA*Daily, Mon-Fri69TREASURER OF STATEOutboundSends file of returned checks processed in AIRS (Tax and DSMV Units) to Treasurer of State.NNAdjust to S/4 Master DataOutbound Financial Transaction Interface
FIGLZS_FIGL_ZX DOCUMENTS TO TREA*Daily, Mon-Fri69TREASURER OF STATEOutboundSends file of "true-ups" process in AIRS (Tax and DSMV Units) to Treasurer of State.NNAdjust to S/4 Master DataOutbound Financial Transaction Interface
FIGLZS_FIGL_ZE DOCUMENTS TO TREAS*Daily, Mon-Sun69TREASURER OF STATEOutboundCreates file of Expense Error Corrections that include cash transfers for Treasurer of State.NNAdjust to S/4 Master DataOutbound Financial Transaction Interface
FIGLZS_FIGL_ZDEPOSIT_SLIP_EXTEvery 15 minutes69TREASURER OF STATEOutboundCreates file of deposits posted in AASIS from the ZDEPOSIT_SLIP table. Treasury updates their internal system and treats it similar to a positive pay file. They know what they should be expecting for deposits and contact ASC if an agency submits a deposit slip that doesn't match what's on the file.NNAdjust to S/4 Master DataOutbound Treasury Positive Pay Interface
FIMMZS_FIMM_MATERIAL_GROUPS_TO_INAEvery 2 weeks610DEPT OF FINANCE AND ADMINOutboundVendor Assignments to Material Groups from On-Line Registration Process. Used to select vendors to which RFxs are sent.Research RequiredResearch RequiredTBD - Need to determine Vendor Self-Service solutionOutbound TBD - Vendor Self-Service
FIMMZS_FIMM_OSP_VENDOR_IN PM*Daily, Mon-Sat610DEPT OF FINANCE AND ADMINInboundInbound Vendor Master Data from the On-Line Registration Process.YNTBD - Need to determine Vendor Self-Service solutionInbound TBD - Vendor Self-Service
FIMMZS_FIMM_OSP_VENDOR_IN*Daily, Mon-Sat610DEPT OF FINANCE AND ADMINInboundInbound Vendor Master Data from the On-Line Registration Process.YNTBD - Need to determine Vendor Self-Service solutionInbound TBD - Vendor Self-Service

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .