General Ledger Transactions XML File Format

General Ledger Transactions CSV or XML File Format - Job Cost

This format may be in either a comma-delimited file (CSV) or an 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

Note

To import beginning balance records, use a period = 00.

All the dates must be valid dates if not blank. If invalid, the system shows an invalid date error instead of an invalid format error.

For beginning balance entries the system sets the Date of Record to the first day of that fiscal year.

GL Transactions Import File Format — CSV or 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. For beginning balances, this value will be overridden to be the first day of the fiscal year.
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.
27	Type	Journal Type for Job Cost entries: C=Cost I=Income Blank for non-Job Cost entries
28	JobNo	Job Number
29	PhaseNo	Phase Number
30	CostNo	Cost Number
31	CostType	Cost Type
32	UnitofMeasure	Unit of Measure
33	Quantity	Quantity
34	Hours	Hours
35	Rate	Rate
36	OvertimeHours	Overtime Hours
37	OvertimeAmount	Overtime Amount
38	Fringe	Fringe amount
39	Burden	Burden amount
40	CommittedSpent	Committed Spent
41	CashOut	Cash Out amount
42	BillingRate	Billing Rate

Sample (2 records)

amsi,01150,,CB122A,201502,,,,,,,,ChateauOP,Jrnl1001,1012,,,,20150225,543.21,transfer,,Ref#,,201502,,C,ONE,,,1000,doz,1,2.5,12.34,1,18.5,5,10,40,75

amsi,01150,,CB122A,201502,,,,,,,,ChateauOP,Jrnl1001,1010,,,,20150225,-543.21,transfer,,Ref#,,201502,,C,ONE,,,1000,doz,1,2.5,12.34,1,18.5,5,10,40,75