Accounting
Feed Extract File Format
The following describes the format of the Accounting Feed Extract file that
is produced by CLM. An Accounting Feed Extract file is comprised of a Header
Record, one or more Detail Records, and a Trailer Record.
|
Field
Name |
Columns |
Length |
Description/Format |
|
Header Record |
|
|
|
|
Fiscal Year |
001-004 |
4 |
Fiscal year value, formatted as "YYYY". |
|
Chart of accounts code from JOBS AFED administrative assignment |
005-006 |
2 |
Value retrieved from System Configuration Parameters record. |
|
Organization code from the JOBS AFED administrative assignment |
007-010 |
4 |
Value retrieved from System Configuration Parameters record. |
|
Filler |
011-015 |
5 |
Blank. |
|
Date |
016-025 |
10 |
Current date, formatted as "YYYY-MM-DD". |
|
Balance Transaction Code |
026-027 |
2 |
Value is "HD". |
|
Batch Number |
028-028 |
1 |
Value is "0", unless more than one feed extracted that day. |
|
Filler |
029-158 |
130 |
Blank. |
|
Chart of accounts code from JOBS AFED administrative assignment |
159-160 |
2 |
Value comes from the System Configuration Parameters table. |
|
Filler |
161-172 |
12 |
Blank. |
|
Detail Record |
|
|
|
|
Fiscal Year |
001-004 |
4 |
Fiscal year value, formatted as "YYYY". |
|
Chart of Accounts Code |
005-006 |
2 |
Not used; blank. |
|
Campus Account number and object code |
007-026 |
20 |
Campus's account number that is tied to this CLM ledger transaction. This comes from the GL table. |
|
Sub-campus account number |
027-031 |
5 |
Not used; blank. |
|
Object Code |
032-037 |
6 |
Campus's object code that is tied to this CLM ledger transaction. This comes from the GL table. |
|
Sub-object Code |
038-040 |
3 |
Not used; blank. |
|
Balance Transaction Code |
041-042 |
2 |
Value is "AC". |
|
Object Type Code |
043-044 |
2 |
Blank. |
|
Fiscal Period Code |
045-046 |
2 |
Blank. |
|
Document Type Code |
047-050 |
4 |
Value is "STLN". |
|
System Origination Code |
051-052 |
4 |
Value is "EU ". |
|
Loan Name |
053-057 |
5 |
Loan name truncated to 5 characters. |
|
Entry sequence number |
058-062 |
5 |
Not used; blank. |
|
Description |
063-102 |
40 |
General ledger account description. This comes from the GL table. |
|
Filler |
103-103 |
1 |
Blank. |
|
Transaction Amount |
104-118 |
15 |
Transaction Amount |
|
Debit/Credit Indicator |
119-119 |
1 |
Value is "D" or "C". |
|
Posting Date |
120-129 |
19 |
The date the user entered as the "posting date". If none was supplied, system defaults to current date. Formatted as "YYYY-MM-DD". |
|
Filler |
130-149 |
20 |
Blank. |
|
Chart of accounts code from JOBS AFED administrative assignment |
150-151 |
2 |
Value comes from the System Configuration Parameters table. |
|
Organization code from the JOBS AFED administrative assignment |
152-155 |
4 |
Value comes from the System Configuration Parameters table. |
|
Filler |
156-186 |
31 |
Blank. |
|
Trailer Record |
|
|
|
|
Filler |
001-025 |
25 |
Blank. |
|
Balance Transaction Code |
026-027 |
2 |
Value is "TL". |
|
Filler |
028-046 |
19 |
Blank. |
|
Detail Record Count |
047-051 |
5 |
Number of Detail Records written |
|
Filler |
052-092 |
41 |
Blank. |
|
Total Debit Amount |
093-107 |
15 |
Sum of all "D" transaction amounts. |
|
Filler |
108-172 |
65 |
Blank. |