Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name

Position

Description

FormatMax Size
FISCAL_YEARAFiscal YearYYYY4
REC_IDBIndicates the type of transaction.  For Fund transactions this is "AF"XX2
FUNDEFund CodeXXX3
SCCFSpecial Cost CenterXXXX4
ACCT_DESCGDescription of the AccountAlphanumeric50
BUDGETEDHFlag denotes whether or not the account is budgeted (Y/N)X1
FUND_TYPEI

Code indicating the type of fund:

"AFCF" = Agency Custodial Fund

"CP" = Capital Projects

"DS" = Debt Service

"EF" = Enterprise Fund

"GF" = General Fund

"IT" = Investment Trust Fund

"P" = Permanent

"PE" = Private Purpose Trust

"PS" = Pension

"SR" = Special Revenue

"IS" = Internal Service Fund

XX2

...

Field NamePositionDescriptionFormatMax Size
FISCAL_YEARAFiscal YearYYYY4
REC_IDBIndicates the type of transaction

For cash transactions this is "CT"

XX2
TRAN_IND3JTransaction Indicator, denotes type of entry

1 = Cash Balance and Prior Year Encumbrance

2 = Expense

3 = Receipt

X1
FUNDEFund CodeXXX3
FUNCKFunction code when TI = 2

Revenue code when TI = 3

XXXX4
OBJLObject code when TI = 2XXX3
SCCFSpecial Cost CenterXXXX4
DEPT_CODECDepartment Code, when TI = 2XXXXX5
BEGIN_BALMCash Balance entry if TI = 1, else enter zero.Dollar Amount#
ORIG_BUDGETNOriginal BudgetDollar Amount#
REVISED_BUDGETORevised Budgeted AmountDollar Amount#
ACTUALPActual AmountDollar Amount#
PRIOR_ENCUMBQPrior Fiscal Year EncumbrancesDollar Amount#
CURRENT_ENCUMBRCurrent EncumbrancesDollar Amount#
EXP_AGNST_ENCUMBSExpenditures Against Prior Year EncumbrancesDollar Amount#

...

The field names as listed above must be included at the top of the upload file. Here is a sample Cash Export Header file.