How to Feed Enterprise Feeder Batch
...
File
The KFS Enterprise Feeder Batch File Upload allows you to upload flat file transactions from the external feeder systems. The uploaded files are processed by the enterprise feeder job, which reconciles the totals as the minimum validation. The Scrubber and Poster jobs then process the accepted files to update the GL balances. Unlike the Collector Batch Upload, the Enterprise Feeder Batch Upload process is designed for a trusted source, processing the files faster and performing the minimum validation. They are most likely used by external feeder systems such as payroll and cashiering systems. |
Overview
The Enterprise Feeder Batch process involves the following four steps:
...
Column Name | Length | Start | End | Required | Comment |
Fiscal Year | 4 | 1 | 4 | Req'd | Fiscal Year (ending year). |
Chart Code | 2 | 5 | 6 | Req'd | High level structure of the KFS Chart of Accounts. For example, IR is Irvine Campus Chart, MC is Medical Center Chart. |
Account Number | 7 | 7 | 13 | Req'd | Identifies a pool of funds assigned to a specific university organization entity for a specific purpose. In KFS, the UC Fund will be an attribute of a KFS Account Number and will not be visible on the accounting line. |
Sub-account Number | 5 | 14 | 18 | Optional | Defines an optional part of the accounting string that allows tracking of financial activity within a particular account at a finer level of detail or processing of cost share. For example departments will be able to sub-divide the account number using sub-account to track expenses. |
Object Code | 4 | 19 | 22 | Req'd | Classifies all financial activities into detailed categories of income, expense, asset, liability, and fund balance. |
Sub-object Code | 3 | 23 | 25 | Optional | Defines an optional part of accounting string that allows departments to create finer distinctions within a particular object code on an account. |
Balance Type Code | 2 | 26 | 27 | Req'd | Type of balance (Actual, Encumbrance, Budget, etc) used by the balance table |
Object Type Code | 2 | 28 | 29 | Req'd | Defines the general use of an object code such as income, asset, expense, or liability. |
Fiscal Period | 2 | 30 | 31 | Optional | A period within a fiscal year starting with 01 (July), 02 (August), etc. If left blank scrubber will assign the current fiscal month |
Document Type | 4 | 32 | 35 | Req'd | Similar to Type Entry which defines the nature of transaction. |
Origin Code | 2 | 36 | 37 | Req'd | Indicates the source system. The Origin Code must be defined in KFS. |
Document Number | 14 | 38 | 51 | Req'd | Number assigned by the source system. |
Entry Seq Number | 5 | 52 | 56 | Optional | Sequence number starting with 1. |
Description | 40 | 57 | 96 | Req'd | Transaction description. |
Sign | 1 | 97 | 97 | Req'd only for budget transaction | Sign (+ or -). Only required for budget transactions. |
Amount | 20 | 98 | 117 | Req'd | Transaction Amount |
Debit/Credit Code | 1 | 118 | 118 | Req'd | D or C |
Transaction Date | 10 | 119 | 128 | Req'd | YYYY-MM-DD |
Org Doc Number | 10 | 129 | 138 | Optional | Organization Document Number. Any text that can be assigned to the transaction for a reference purpose. |
Project Code | 10 | 139 | 148 | Optional | Defines an optional part of the accounting string that allows departments to assign an identifier which might span multiple accounts (e.g. construction projects, commencement, etc). |
Org Ref Id | 8 | 149 | 156 | Optional | Free format field for a reference purpose. |
Ref Type Code | 4 | 157 | 160 | Req'd for disencumbrance | Original Encumbrance Balance Type Code required for Enc Update Code of 'R' |
Ref Origin Code | 2 | 161 | 162 | Req'd for disencumbrance | Original Encumbrance Origin Code required for Enc Update Code of 'R' |
Ref Doc Number | 14 | 163 | 176 | Req'd for disencumbrance | Original Encumbrance Document Number required for Enc Update Code of 'R' |
Reversal Date | 10 | 177 | 186 | Optional | YYYY-MM-DD. The reversal date is used for encumbrances and accrual reversals. The system automatically reverses the transaction on the specified date. |
Enc Update Code | 1 | 187 | 187 | Req'd for encumbrance/ disencumbrance | D (Document) or R (Reference) |
...
The standard format of the reconciliation file is:
C tableid row count ;
S field1 field dollar amount ;
S field2 dollar amount ;
E checksum ;
- A 'C' 'S' or 'E' must be the first character on a line unless the line is entirely white-space or a comment. The case of these three codes is not significant.
...
The example of the recon file:
5 Entries, totaling $1000
|
Step 2: Uploading Enterprise Feeder Files
...