Skip Maine state header navigation

Agencies | Online Services | Help

Skip First Level Navigation | Skip All Navigation

Home MEDMSl Financial System > MEDMS-FS Upload File Format

MEDMS-FS Upload File Format

File and Folder Names:

  1. c:\MEDMSFinancials\BudgetRevenue.txt

  2. c:\MEDMSFinancials\BudgetExpenditure.txt

  3. c:\MEDMSFinancials\BudgetBalanceSheet.txt

  4. c:\MEDMSFinancials\ActualRevenue.txt

  5. c:\MEDMSFinancials\ActualExpenditure.txt

  6. c:\MEDMSFinancials\ActualBalanceSheet.txt

File formats:  Tab Separated Value. In Excel select Save as:

Text (Tab delimited) (*.txt)

Header - First line in each file should have:

SAU    ReportName            RecordCount               DateTime

1000   BudgetRevenue        967                 04/15/2006 12:00:00 AM

File Name

Format

BudgetRevenue.txt
SAUCode     FiscalYear     Quarter     FundCode     RevenueCode     Title     Amount

BudgetExpenditure.txt
SAUCode     FiscalYear     Quarter     FundCode     ProgramCode     FunctionCode     ObjectCode     CostCenter     Title     Amount

BudgetBalanceSheet.txt
SAUCode     FiscalYear     Quarter     FundCode     BalanceSheetCode     Title     Amount

ActualRevenue.txt
SAUCode     FiscalYear     Quarter     FundCode     RevenueCode     Description     Amount

ActualExpenditure.txt
SAUCode     FiscalYear     Quarter     FundCode     ProgramCode     FunctionCode     ObjectCode     CostCenter     Title     Amount

ActualBalanceSheet.txt 
SAUCode     FiscalYear     Quarter     FundCode     BalanceSheetCode     Title     Amount

Data types are as follows:

Amount = up to 10000000000.00    10 Billion with two decimal places and no comma separators,

BalanceSheetCode = 4 Digit Numeric 

CostCenter = 2 Digit Numeric (01, 02, 03, 04, 99)

Title = 200 Char Text without tabs in them (Support expenditures purchased services students)

FiscalYear = 4 Digit Numeric (07/08 would be 2008)

FunctionCode = 4 Digit Numeric

FundCode = 3 Digit Numeric

ObjectCode = 4 Digit Numeric

ProgramCode = 4 Digit Numeric

Quarter = 2 Digits Numeric (01, 02, 03, 04)

Revenue Code = 4 Digit Numeric

SAUCode = 4 Digit Numeric 1000-9999