| FASTRANS | Create | Format | Name | Transfer | Submit |
| The following table describes the data elements, their lengths, requirements and edits. The following abbreviations are used in the Format column: | |
|---|---|
| Abbreviation | Description |
| n | Numeric Character (0-9, +, -, comma, $, matching parenthesis, decimal point) |
| a | Alphanumeric Character (A-Z, a-z, numeric characters (see n above for description), special characters OK) |
| b | Blank, a space is required in position(s) |
| x | The fixed value 'x' is required in the noted record position(s) |
| - | Dash required in specified position |
| TC30 Cash Transmittal (CSH), Fixed File Format -- Batch Header Record | |||||
|---|---|---|---|---|---|
| Field Name | Record Position(s) | Value Req'd | Format | -----Description----- | Edit |
| Transaction Code | 1-2 | Yes | xx | Field that identifies the type of FAS detail transaction. Only one type of transaction may be in a batch. | '30' for Cash Transmittals. |
| Batch Date | 3-8 | Yes | nnnnnn | yymmdd | e.g. 970623 |
| Filler | 9-12 | n/a | bbbb | Reserved | Must be spaces |
| Batch Number | 13-14 | Yes | nn | Sequence number of this batch on Batch Date noted above. | User established, |
| Detail Code | 15 | Yes | x | This field indicates that this record is a Batch Header. | Must be a 'B'. |
| Filler | 16-21 | n/a | bbbbbb | Reserved | Must be spaces. |
| Batch Transaction Count | 22-26 | Yes | nnnnn | This is the number of CT Documents in the Batch | (none) |
| Batch Amount | 27-37 | Yes | nnnnnnnnnnn | This is the total of all CT Detail Record Dollar Amounts. | Must be a number, right justified, zero filled, dollars and cents with NO decimal point. |
| Batch Amount Sign | 38 | Yes | x (+ or -) |
Self Explanatory | Must be a '+' or '-' |
| Filler | 39-240 | n/a | 202 b's | Reserved | Must be spaces. |
| TC30 Cash Transmittal (CSH), Fixed File Format -- Detail Record | |||||
|---|---|---|---|---|---|
| Field Name | Record Position(s) | Value Req'd | Format | -----Description----- | Edit |
| Transaction Code | 1-2 | Yes | xx | Field that identifies the type of FAS detail transaction. Only one type of transaction may be in a batch. | '30' for Cash Transmittals. |
| Batch Date | 3-8 | Yes | nnnnnn | Date tied to Cash Transmittal | yymmdd (970507) |
| Filler | 9-12 | n/a | bbbb | Reserved | Must be spaces |
| Batch Number | 13-14 | Yes | nn | Sequence number of this batch on Batch Date noted above. | User established, |
| Detail Code | 15 | Yes | x | This field indicates that this record is a Detail Record. | Must be a 'D'. |
| Budget Number | 16-21 | Yes | nnnnnn | Budget number affected by the transaction | None at this level |
| State/Local Code | 22 | No | b | State/Local Funds Code. | Will be filled from Budget master files. Leave blank. |
| Object | 23-24 | No | nn | Part of Revenue Code | Depending upon the originating area and Budget Number, this
portion of the account code may be blank, zeroes, a revenue code,
an expenditure code or a general ledger code.
For Departmental TC30s we should always expect to see a revenue code or spaces or zeroes. |
| Sub-Object | 25-26 | No | nn | Part of Revenue Code | Depending upon the originating area and Budget Number, this
portion of the account code may be blank, zeroes, a revenue code,
an expenditure code or a general ledger code.
For Departmental TC30s we should always expect to see a revenue code or spaces or zeroes. |
| Sub-Sub-Object | 27-28 | No | nn | Part of Revenue Code | Depending upon the originating area and Budget Number, this
portion of the account code may be blank, zeroes, a revenue code,
an expenditure code or a general ledger code.
For Departmental TC30s we should always expect to see a revenue code or spaces or zeroes. |
| Task | 29-31 | No | aaa | Part of Cost Accounting data. Self explanatory | None at this level |
| Option | 32-34 | No | aaa | Part of Cost Accounting data. Self explanatory | None at this level |
| Project | 35-40 | No | aaaaaa | Part of Cost Accounting data. Self explanatory | None at this level |
| Dollar Amount | 41-51 | Yes | nnnnnnnnnn | Dollar amount of sales or transfer. | Must be a number, right justified, zero filled, dollars and cents with no decimal point. |
| Document Nbr Prefix | 52-53 | Yes | aa | Originating Area Code | Access table validation completed at Submission time. |
| Document ID Number | 54-59 | Yes | nnnnnn | User sequential identification number | None |
| Invoice Number | 60-69 | No | 10 a's | Identification number to allow cross reference to source document (cash receipt invoice). | None |
| Received From | 70-91 | Yes | 22 a's | Name of the person or organization from who the cash was received. | None |
| Cash Flag | 92 | No | a | Flag indicating that actual cash was received. | Must be ' ' (a space) or '1' |
| Check Flag | 93 | No | a | Flag indicating that a check was received. | Must be ' ' (a space) or '1' |
| Money Order Flag | 94 | No | a | Flag indicating that a money order was received. | Must be ' ' (a space) or '1' |
| Bank Code | 95 | Yes | a | Code indicating the ID of the Bank to which the cash transmittal was completed. | None at this level |
| Collecting Orign | 96-97 | No | Unused | Obsolete Data Field | None |
| Document Date | 98-103 | Yes | nnnnnn | Billing Date | Format must be mmddyy |
| Bank Deposit Number | 104-115 | No | 12 a's | The number from the preprinted deposit slip used to complete the cash transmittal. | None |
| Dollar Amount Sign | 116 | Yes | a | Self explanatory | Must be '+' or '-' |
| Filler | 117-177 | No | 62 b's | Reserved. | Must be spaces. |
| Prior Year Flag | 178 | No | a | Field used to indicate accounting year accruals when requested by General Accounting. | 0 - Normal Condition
1 - Acceptable when designated by GA 2 - Acceptable when designated by GA |
| Originating Area Code | 179-180 | Yes | aa | Field used to identify the source of transactions. | Access table validation completed at Submission time. |
| Filler | 181-240 | No | 60 b's | Reserved. | Must be spaces. |
| FASTRANS | Create | Format | Name | Transfer | Submit |
