The XML format consists of a root tag of <GLTRANSACTIONS> with each transaction having a tag of <GLTRANSACTION>. Refer to the following list for attributes.
File Name
XML schema: GLTransactionsImportSchema.xsd
GL Transactions Import File Format — XML
Field |
Field Name |
Description |
---|---|---|
1 |
UserId |
The login of user who ran transfer to general ledger. Typically not used. |
2 |
PropertyCompanyId |
The PropertyCompany ID of source PropertyCompany. Typically not used. |
3 |
ReportDate |
The sign on date when transfer run. Typically not used. |
4 |
EntityCompany |
The EntityCompany to which the entry is to post. |
5 |
PostPeriod |
The period to which the entry is to post. |
6 |
TransType |
The transaction type (only meaningful for some transfer types). Typically not used. |
7 |
IncCode |
The income code (only meaningful for some transfer types). Typically not used. |
8 |
VariableKeyForPost |
Data in this field would not be processed by receiving system. |
9 |
DrCrFlag |
Data in this field is not meaningful. Use sign of amount instead. |
10 |
VariableKeyForPrint |
Data in this field would not be processed by receiving system. |
11 |
SiteId |
A database identifier. Typically not processed. |
12 |
TransferId |
The sequential transfer counter. |
13 |
BbNo |
The bank book ID. |
14 |
JournalNo |
The journal ID. |
15 |
GlAcctNo |
The GL Account number. |
16 |
AcctProfitCenFlag |
This flag indicates if a profit center is specified. |
17 |
AcctProfitCen |
The profit center. |
18 |
AcctXferToGl |
The transfer method (summary, detail, by journal, etc). |
19 |
DateOfRecord |
The date of record of the entry (generally would use either this or posting period, not both). |
20 |
AmtToGl |
The amount. Negatives are credits. |
21 |
GlDesc |
The transaction description |
22 |
TranEntryType |
The entry type (only meaningful for some transfer types). Typically not used. |
23 |
RefCheckNo |
The reference. |
24 |
PostFlag |
Data in this field would not be processed by receiving system. |
25 |
CurrAcctPrd |
The current period of PropertyCompany in eSite. Typically not used. |
26 |
ReverseFlag |
Indicates if the transaction should be auto-reversed |
See Also
Data Transfer File Formats Introduction
GL Transactions Import File Format CSV
GL Transactions Import File Format SDF
GL Intercompany Transactions Overview
Copyright © 2018 Infor. All rights reserved. www.infor.com.