Search | Directories | Reference Tools
UW Home > Admin Systems > Systems on Keynes 
FASTRANS Create Format Name Transfer Submit

 

TC30, Cash Transmittal (CSH)
Fixed Format File Layout

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 Required field
State/Local Code 22 No b State/Local Funds Code. FAS will determine the value. Leave blank.
Account Code * 23-28 No* nnnnnn or spaces Either a Revenue Code, an Expense Code or a G/L Code

* Most commonly a Revenue Code. However, depending on the Budget Number, the account code may be blank, zeroes, a revenue code, an expenditure code or a general ledger code.

If blank or zeros, FAS will supply the Revenue Code from the Revenue Code associated with the budget number on the budget number index.
Task 29-31 No aaa Part of Cost Accounting data. Self explanatory No edits applied as part of the submission process
Option 32-34 No aaa Part of Cost Accounting data. Self explanatory No edits applied as part of the submission process
Project 35-40 No aaaaaa Part of Cost Accounting data. Self explanatory No edits applied as part of the submission process
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 Fastrans Area Code assigned for this account.
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. No edits applied as part of the submission process
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. Right justify. Only the right most 9 char.s are carried forward in FAS.
Dollar Amount Sign 116 Yes a Self explanatory Must be '+' or '-'
Additional Description 117-146 No 30 a's Additional information at the departments discretion None
Filler 147-177 No 31 b's Reserved. Must be spaces.
Legacy 180 Format - Prior Year Flag (deprecated) 178 No a The location of this field continues to exist to support what is now an obsolete 180 character format record, but should not be used for newly developed applications. A file should not contain a mix of accrual month and non-accrual month transactions. Fastrans transactions are posted to the correct accounting period based upon a file naming convention that includes the accounting month in the name. Fastrans will apply the correct prior year flag value. 0 = Normal Month, 1 = Month 12A, 2 = Month 25
Legacy 180 Format - Originating Area Code (deprecated) 179-180 Yes aa The location of this field continues to exist to support what is now an obsolete 180 character format record, but should not be used for newly developed applications. Use the Originating Area field in the 239-240 position. Field used to identify the source of transactions. Access table validation completed at Submission time.
Filler 181-237 No 57 b's Reserved. Must be spaces.
Prior Year Flag (deprecated) 238 No a A file should not contain a mix of accrual month and non-accrual month transactions. Fastrans transactions are posted to the correct accounting period based upon a file naming convention that includes the accounting month in the name. Fastrans will apply the correct prior year flag value. 0 = Normal Month, 1= Month 12A, 2 = Month 25
Originating Area Code 239-240 Yes aa Field used to identify the source of transactions. Access table validation completed at Submission time.

FASTRANS Create Format Name Transfer Submit