| FIELD NAME | FORMAT | REQ | COL | DESCRIPTION |
| Transaction Code | A3 | * | 1–3 | Value: $$# |
| Batch Reference | A6 | * | 4–9 | Six-character batch reference approved by FAMIS for this feed. The format may be AAANNN or AAAANN. Certain combinations are reserved for FAMIS and may not be used in a data feed. |
| Batch Date | N8 | 10–17 | Current date in YYYYMMDD format. Must be in the current processing month. | |
| Batch Description | A35 | * | 18–52 | Description of batch. |
| List Option | A1 | * | 53 | Y: program will list transaction N: program will not list transactions **N is the typical value, but Y will provide more detail on the printed report. |
| User Code | A2 | * | 54–55 | Value: FA |
| Transaction Count | N5 | 56–60 | Number of transactions in batch (optional) | |
| Transaction Amount | N9.2 | 61–71 | Total amount of transactions in batch. Right justify, zero fill, decimal is implied as the last two digits (e.g., X $456.22 should be coded as 00000045622). (This field is optional on the Header Record) | |
| Blank | A12 | 72–83 | Blank | |
| Bank | A5 | * | 84–88 | Any valid bank |
| Hold Flag | A1 | * | 89 | Value: N |
| Accounting Feed Flag | A1 | * | 90 | Value: Y |
| Voucher Feed Flag | A1 | * | 91 | Value Y* |
| Accept Balance Flag | A1 | * | 92 | Value: Y |
| Override Budget Flag | A1 | * | 93 | Value: Y or N (default is Y if blank) |
Transaction Record
| FIELD NAME | FORMAT | REQ | COL | DESCRIPTION |
| Transaction Code | A3 | * | 1–3 | Value: 02X, where X is: 0 – Original budget 1–6 – Regular budget 2 – Budget transfer 7 – Begin year bud forward |
| Account | A10 | * | 4–13 | Six-digit account four-digit subcode |
| Ref | A7 | 14–20 | Reference number | |
| Date | N8 | * | 21–28 | Format YYYYMMDD (will default to current date if not filled in) |
| Desc | A35 | * | 29–63 | Transaction description |
| Amount | N9.2 | * | 64–74 | Amount of transaction; right justify, zero fill, decimal is implied as last two digits. (e.g., $456.22 should be coded as 00000045622) |
| D-C-Indic | A1 | * | 75 | Required for 020, 021, 026 TC only D – Debit; C – Credit Defaults: C for revenue budget, D for expense budget |
| Ref-2 | A7 | 76–82 | Optional reference number. | |
| Credit Acct | A10 | 83–92 | Credit account | |
| User ID | A11 | 93–103 | Optional | |
| Ref-3 | A7 | 104–110 | Optional reference number. | |
| Ref-4 | A7 | 111–117 | Optional departmental reference. | |
| Debit Support Account | A5 | * | 118–122 | 00000 if not using support accounts |
| Credit Support Account | A5 | * | 123–127 | 00000 if not using support accounts |
| Cash Transfer Flag | A1 | 128 | Required for 022 Transfer Blank “Y” JE is done if cross GLs “N” no JE done | |
| Filler | A22 | 129–150 | Blank |
This sample Excel file matches the header and transaction layouts detailed on this page. Download the file to begin building your budget feed. (Coming Soon)
FAMIS_INTERFACE_Feed-Budgets