...
Column Name | Length | Start | End | Comment | |||||||
Fiscal Year | 4 | 1 | 4 | Fiscal Year (ending year). | |||||||
Chart Code | 2 | 5 | 6 | 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 | Sub-account Number | 5 | 14 | 18 | Object Code | 4 | 19 | 22 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 | 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 | Classifies all financial activities into detailed categories of income, expense, asset, liability, and fund balance. | |||||||
Sub-object Code | 3 | 23 | 25 | 23 | 25 | 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 | Type of balance (Actual, Encumbrance, Budget, etc) used by the balance table | |||||||
Object Type Code | 2 | 28 | 29 | Fiscal Period | 2 | 30 | 31 | 29 | Defines the general use of an object code such as income, asset, expense, or liability. | ||
Fiscal Period | 2 | 30 | 31 | A period within a fiscal year starting with 01 (July), 02 (August), etc. | |||||||
Document Type | 4 | 32 | 35 | Similar to Type Entry which defines the nature of transaction. | |||||||
Origin Code | 2 | 36 | 37 | Indicates the source system. The Origin Code must be defined in KFS. | |||||||
Document Number | 14 | 38 | 51 | Number assigned by the source system. | |||||||
Entry Seq Number | 5 | 52 | 56 | Sequence number starting with 1. | |||||||
Description | 40 | 57 | 96 | Transaction description. | |||||||
Sign | 1 | 97 | 97 | Sign (+ or -). Only required for budget transactions. | |||||||
Amount | 20 | 98 | 117 | Transaction Amount | |||||||
Debit/Credit Code | 1 | 118 | 118 | D or C | |||||||
Transaction Date | 10 | 119 | 128 | YYYY-MM-DD | |||||||
Org Doc Number | 10 | 129 | 138 | Project Code | 10 | 139 | 148 Doc Number | 10 | 129 | 138 | Organization Document Number. Any text that can be assigned to the transaction for a reference purpose. |
Project Code | 10 | 139 | 148 | 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 | Free format field for a reference purpose. | |||||||
Ref Type Code | 4 | 157 | 160 | Original Encumbrance Balance Type Code required for Enc Update Code of 'R' | |||||||
Ref Origin Code | 2 | 161 | 162 | Original Encumbrance Origin Code required for Enc Update Code of 'R' | |||||||
Ref Doc Number | 14 | 163 | 176 | Original Encumbrance Document Number required for Enc Update Code of 'R' | |||||||
Reversal Date | 10 | 177 | 186 | 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 | D or R (Reversal) |
...