ASCII File Layout

Use this format to create the file used to import data into the AMSI DOS G/L system.

The system creates the .GLS output file, which includes the User ID and date/time stamp of the process (useridyyyymmddhhmmss.GLS). However, the file name is prefixed with information about the specific process that created the file, as follows:

P_PropertyID_useridyyyymmddhhmmss.GLS

If the file is created as a result of the Transfer to GL process, the file name indicates the first Property ID among the selected properties.

BB_BankBookID_Batch#_useridyyyymmddhhmmss.GLS

If the file is created as a result of an individual Cash batch approval, the file name includes the bank book ID and the first batch in the list.

BB_AdjBankbookID_Batch#_useridyyyymmddhhmmss.GLS

If the file is created as a result of an individual Adjustment batch approval, the file name includes the Adjustment bank book ID and the first batch in the list.

01MEACR050701AUTO07Cash Receipts-Rent:02-201 1200000 -1020.00RPM0Meadow7 05070507

Field	Position	Length	Value
PropertyId	1-5	5	Entity ID*
Deposit/Credit/Journal Entry	6-7	2	DP (Deposit), CR (Cash Receipt) or JE (Journal Entry)
Transaction date	8-13	6	Date of record* as YYMMDD
RefCheckNo	14-19	6	Check or reference number*
GlDesc	20-49	30	Description/income code*
GlAcctNo	50-59	10	GL Account Number (AMSI format)*
AmtToGl	60-71	12	Amount of Transaction
Reference	72-86	15	GL Transaction Reference*
AR Period*	87-90	4	YYMM
GL Period*	91-94	4	YYMM
Reversal Flag	95	1	R or blank