This format is similar to that of the AMSI DOS G/L format but with some fields expanded. It does not support auto-reversing prepaids. It is a fixed length format with a carriage return/line feed between records.
|
Field |
Position |
Length |
Value |
|
PropertyId |
1-5 |
5 |
Entity ID* |
|
Deposit/Credit/Journal Entry |
6-7 |
2 |
DP/CR/JE* |
|
Transaction date |
8-13 |
6 |
Date of Record* as YYMMDD |
|
RefCheckNo |
14-19 |
6 |
GL 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-91 |
20 |
|
|
AR Period |
92-95 |
4 |
YYMM* |
|
GL Period |
96-99 |
4 |
YYMM* |
|
Unused |
100 |
1 |
Always blank |
Example:
01MEAJE050701AUTO07Lease Charge-Rent:02-201 4017000 -1020.00PM08 705070507
01MEAJE050701AUTO07Lease Charge-Rent:02-201 1200000 1020.00RPM08 705070507
01MEACR050701AUTO07Cash Receipts-Rent:02-201 1200000 -1020.00RPM0Meadow 705070507
01MEADP050701AUTO07Cash Receipts-Rent 1010 1020.00RPM0Meadow 705070507
See Also
Transaction Descriptions for Transfer to GL Files
Online Payments Interface for Transfer to G/L
Transfer to G/L for Online Payments
Copyright © 2018 Infor. All rights reserved. www.infor.com.