Record Table - CASHFILE Cash Reciepts File

Record Table - CASHFILE Cash Receipts File

The Cash Receipts file contains the transaction data for Tax Receipt Entry and Treasurer's Receipt Entry. There are five types of records in CASHFILE:

Notes:

The NEXTDAY file used for entering transactions for the next day has the same layout as CASHFILE.
For information about interpreting Record Tables, see Understanding Record Tables.
To view other Record Tables, see the Data Dictionary Overview.
For more information about a field, click the hyperlink in the Description column.

Field Name	Description	Length	Format
RECEIPT_ID (Key)	Receipt ID	6	STRING
RECEIPT_TYPE	Receipt Type	1.0	INTEGER
RECEIPT_NUMBER	Receipt Number	6.0	DOUBLE
ACCOUNT_NUMBER	Transaction Account Number for General Ledger, Appropriations, or Revenue	8	STRING
RECEIVED_FROM	Received From Name	30	STRING
DESCRIPTION	Description	20	STRING
TRANSACTION_AMOUNT	Transaction Amount	7.2	DOUBLE
CLERK_INITIALS	Clerk Initials	3	STRING
POST_FLAG	Post Flag	1.0	INTEGER
REFERENCE	Reference	20	STRING
CHECK_NUMBER	Check Number	6.0	INTEGER

Field Name	Description	Length	Format
RECEIPT_ID (Key)	Receipt ID	6	STRING
RECEIPT_TYPE	Receipt Type	1.0	INTEGER
RECEIPT_NUMBER	Receipt Number	6.0	DOUBLE
TRANSACTION_ACCOUNT	Transaction Account Number for General Ledger, Appropriations, or Revenue	8	STRING
RECEIVED_FROM	Received From Name	20	STRING
DESCRIPTION	Description	30	STRING
TRANSACTION_TOTAL	Payment Amount	7.2	DOUBLE
CLERK_INITIALS	Clerk Initials	3	STRING
POST_FLAG	Post Flag	1.0	INTEGER
REFERENCE	Reference	20	STRING
CHECK_NUMBER	Check Number	6.0	INTEGER

Field Name	Description	Length	Format
RECEIPT_ID (Key)	Receipt ID	6	STRING
RECEIPT_TYPE	Receipt Type	1.0	INTEGER
RECEIPT_NUMBER	Receipt Number	6.0	DOUBLE
TAX_ACCOUNT_NUMBER	Tax Account Number	6	STRING
FINANCIAL_ACCOUNT	Transaction Account Number for General Ledger, Appropriations, or Revenue	8	STRING
DUE_DATE	Due Date	4.0	DOUBLE
TRANSACTION_CODE	Payment Type	2.0	DOUBLE
PREVIOUS_BALANCE	Previous Balance	7.2	DOUBLE
TRANSACTION_AMOUNT	Transaction Amount	6.2	DOUBLE
CLERK_INITIALS	Clerk Initials	3	STRING
POSTING_FLAG	Post Flag	2.0	INTEGER
INTEREST_DATE	Interest Date	DATE	INTEGER
RECEIVED_DATE	Received Date	DATE	INTEGER

Field Name	Description	Length	Format
RECEIPT_ID (Key)	Receipt ID	6	STRING
RECEIPT_TYPE	Receipt Type	1.0	INTEGER
RECEIPT_NUMBER	Receipt Number	6.0	DOUBLE
TAX_ACCOUNT_NUMBER	Tax Account Number	6	STRING
FINANCIAL_ACCOUNT	Transaction Account Number for General Ledger, Appropriations, or Revenue	8	STRING
DUE_DATE	Due Date	4.0	DOUBLE
TRANSACTION_CODE	Payment Type	2.0	DOUBLE
PREVIOUS_BALANCE	Previous Balance	7.2	DOUBLE
TRANSACTION_AMOUNT	Payment Amount	6.2	DOUBLE
CLERK_INITIALS	Clerk Initials	3	STRING
INTEREST_DATE	Interest Date	DATE	INTEGER
RECEIVED_DATE	Received Date	DATE	INTEGER
PROPERTY_ID	Property ID	12	STRING
RECEIVED_FROM	Received From Name	20	STRING
CHECK_1_NUMBER	Check 1 Number	6.0	INTEGER
CHECK_1_AMOUNT	Check 1 Amount	7.2	DOUBLE
CHECK_2_NUMBER	Check 2 Number	6.0	INTEGER
CHECK_2_AMOUNT	Check 2 Amount	7.2	DOUBLE
CREDIT_CARD_NUMBER	Credit Card Number	19	STRING
CREDIT_CARD_AMOUNT	Credit Card Amount	7.2	DOUBLE
CASH_AMOUNT	Cash Amount	7.2	DOUBLE
TENDERED_AMOUNT	Tendered Amount	7.2	DOUBLE
CHANGE_BACK	Change Back Amount	7.2	DOUBLE
POSTING_FLAG	Post Flag	1.0	INTEGER