...
Column Name | Length | Start | End | RequiredRequirement | 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) |
...