...
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 | 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 | 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 | 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 | 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 (Document) or R (ReversalReference) |
Sample Transactions
| Code Block |
|---|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 19 ----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----|----| 2010BL2336320-----5105---ACES04INVW013187 00006Writeoff for 3100. +00000000000000010.00D2009-10-09 ---------- 2010BL1023200-----4100---EXEX04PO 013022 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011008 R 2010BL1023200-----9892---EXFB04PO 013022 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011008 2010BL1023200-----4100---EXEX04PO 013046 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011010 R 2010BL1023200-----9892---EXFB04PO 013046 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011010 2010BL1023200-----4100---EXEX04PO 013058 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011011 R 2010BL1023200-----9892---EXFB04PO 013058 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011011 2010BL1023200-----4100---EXEX04PO 013066 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011012 R 2010BL1023200-----9892---EXFB04PO 013066 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011012 2010BL1023200-----4100---EXEX04PO 013077 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011013 R 2010BL1023200-----9892---EXFB04PO 013077 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011013 2010BL1023200-----4100---EXEX04PO 013087 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011014 R 2010BL1023200-----9892---EXFB04PO 013087 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011014 2010BL1023200-----4100---EXEX04PO 013096 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011015 R 2010BL1023200-----9892---EXFB04PO 013096 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011015 2010BL1023200-----4100---EXEX04PO 013102 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011016 R 2010BL1023200-----9892---EXFB04PO 013102 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011016 2010BL1023200-----4100---EXEX04PO 013110 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011017 R 2010BL1023200-----9892---EXFB04PO 013110 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011017 2010BL1023200-----4100---EXEX04PO 013119 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011018 R 2010BL1023200-----9892---EXFB04PO 013119 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011018 2010BL1023200-----4100---EXEX04PO 013129 00001MK CORPORATION ACTIVE +00000000000000604.00D2009-10-09 ---------- PO 011019 R 2010BL1023200-----9892---EXFB04PO 013129 00002TP Generated Offset +00000000000000604.00C2009-10-09 ---------- PO 011019 |
...