Use this format to create a .txt file. This format is the same as the XML Format except that it is comma delimited with a carriage return/line feed between records.
|
Field |
Max Length |
Value |
|
UserId |
|
eSite user who created the file. |
|
PropertyId |
|
Property ID. Normally ignored. |
|
ReportDate |
|
System date when file created. |
|
Entity |
|
Entity ID. The G/L entity to post to. |
|
PostPeriod |
|
YYYYMM. Fiscal Period. |
|
TransType |
|
Transaction Type* |
|
IncCode |
|
Income Code* |
|
VariableKeyForPost |
|
GL Account/Transaction Description/Income Code* Normally ignored. |
|
DrCrFlag |
|
D for Debit or C for Credit. Normally ignored. Use the sign of the amount instead. |
|
VariableKeyForPrint |
|
Internal information. Normally ignored. |
|
SiteId |
|
Blank |
|
TransferId |
|
Sequential identifier. Normally ignored. |
|
BbNo |
|
Bank Book Number* |
|
JournalNo |
|
Batch Number* |
|
GlAcctNo GL |
|
Account Number* |
|
AcctProfitCenFlag |
|
Y for Yes, N for No, U for Unit, or R for resident. This field is usually ignored. |
|
AcctProfitCen |
|
Profit Center, if profit center flag is not N. |
|
AcctXferToGl |
|
Summarization Method* |
|
DateOfRecord |
|
MM/DD/YYYY. This field is usually ignored and posting period used instead. |
|
AmtToGl |
|
Amount of Transaction |
|
GlDesc |
|
Description/Income Code* |
|
TransEntryType |
|
JE for Journal entry, DP for Deposit, CR for Cash Receipt |
|
RefCheckNo |
|
AUTOMM |
|
PostFlag |
|
Y for Yes or N for No. This field is usually ignored. |
|
CurrAcctPrd YYYYMM. |
|
Current period of the property. This field is usually ignored. |
Example:
"supervisor","01MEA","07/31/2005","01MEA","0507","1","Rent","401707/01/20050220167","C","","","0","","8","4017","Y","000","S","07/01/2005",-1020,"Lease Charge-Rent:02-201","JE","AUTO07","Y","200507"
"supervisor","01MEA","07/31/2005","01MEA","0507","1","Rent","120007/01/20050220167","D","","","0","","8","1200","Y","000","S","07/01/2005",1020,"Lease Charge-Rent:02-201","JE","AUTO07","Y","200507"
"supervisor","01MEA","07/31/2005","01MEA","0507","3","Rent","120007/01/20050220180","C","","","0","Meadow","7","1200","Y","000","S","07/01/2005",-1020,"Cash Receipts-Rent:02-201","CR","AUTO07","Y","200507"
"supervisor","01MEA","07/31/2005","01MEA","0507","3","Rent","1010Cash Receipts-Rent","D","","","0","Meadow","7","1010","N","","S","07/01/2005",1020,"Cash Receipts-Rent","DP","AUTO07","Y","200507"
See Also
AME, Interface Tab
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.