General Ledger Transactions XML File Format

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 Tab

GL Transactions Import File Format CSV

GL Transactions Import File Format SDF

GL Transactions Import Errors

GL Intercompany Transactions Overview