TC30, Cash Transmittal (CSH) Space Delimited File Format (SDF)

File name must begin with the letter F.
The file extension (the three characters beyond the . in the file name) for Cash Transmittal transaction files must be CSH.

Each field must be separated by one or more spaces; the exact number not important. Data fields where nothing is to be input must contain a single (*) character.

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)
-	Dash required in specified position
SDF	(Space Delimited File * Option) column indicates where asterisk character may be used to represent no data being sent for that field. Use of the * place holder is restricted to SDF files only.

Value Required column entry of Yes indicates some non blank characters MUST be input.

TC30 Cash Transmittal (CSH), Space Delimited File Format -- Detail Record
Field Name	SDF Position	Value Req'd	Format	-----Description-----	Edit
Transaction Code	1	Yes	nn	Field that identifies the type of FAS detail transaction. Only one type of transaction may be in a batch.	30 for CSHs.
Transaction Date	2	Yes	See Edits	Date tied to Cash Transmittal	mmddyy (050797) or mm-dd-yy (07-31-95) or mm/dd/yy (07/31/95) or mmddccyy (05071997) or mm-dd-ccyy (07-31-1995) or mm/dd/ccyy (07/31/1995)
Document Number	3	Yes	aaaaaa	Cash Transmittal Document Number, generated by user	(none)
Bank Code	4	Yes	a	Code Assigned to the Bank receiving the deposit	As assigned by General Accounting
Deposit Number	5	Yes	a(9)	Identifying number assigned to the deposit	(none)
Budget Number	6	Yes	nn-nnnn	University Budget Number	2 numbers, a dash, 4 numbers
Amount	7	Yes	nnnnnnnnnn.nn (See Edits)	Amount charged. Negative amounts are indicated by leading or trailing -, or by entering the amount in a matching set of parentheses, e.g., (100.00) or (100).	A maximum of 9 digits, a decimal point and two cents positions may be entered. The decimal point and two decimal positions (cents) are optional. Valid entries: 123.45 +1,234.56 $987,123 -23.45 (56) (789.01) ($135.79)
Revenue Code or GL Code	8	No	nnnn-nn 00-nnnn nn-nn-nn nnnnnn	University Accounting System Revenue Class Code, a Source Code or General Ledger Code	Zeros are acceptable SDF - User may use a "*" to indicate no data being supplied for this field.
Task	9	No	aaa	self explanatory	SDF - May use the character '*' to indicate no data for field
Option	10	No	aaa	self explanatory	SDF - May use the character '*' to indicate no data for field
Project	11	No	aaaaaa	self explanatory	SDF - May use the character '*' to indicate no data for field
Invoice Number	12	No	a(10)	Local Identifying number of the Invoice Used to Bill for Cash Receipt	SDF - May use an "*" to indicate no data being supplied for this field.
Payee Name	13	Yes	a(22)	The name of the person, event, agency, et cetera, responsible for the cash receipt.	None. Embedded spaces legal in this field (e.g., 'IS EXPENSES FOR A PROJ')

Examples of TC30, CSH Space Delimited File Format Detail Records:

30 050797 A12B W 872354 16-9870 +500.00 9402-90 1 022 12-3456 * HEC ED RENT

30 01/15/1997 A12B W 872354 16-9201 +120123.67 * * * * * A123BC987 WSU GAME SHARE 
   (Exmple with optional invoice number and long date format) 

30 07-31-95 B9873 F A12345678 16-9203      -1.50 * * * * * LOCKER FEE REFUND
   (Example showing extra spaces OK and using different date format)

FASTRANS Create Format Name Transfer Submit