This XML file layout is used for the Import Expense Tables data transfer, which is required for each set of expense tables before rebilling can be done (for a Commercial property).
|
Name |
Format |
Length |
Value |
|
AcctType |
VarChar |
1 |
H - Header, D - Detail, or T - Total |
|
Entity |
VarChar |
10 |
The entity ID. |
|
BegGLAccountNo |
VarChar |
15 |
The first GL account number in the selected account range for the transfer (for example, 5123). |
|
EndGLAccountNo |
VarChar |
15 |
The last GL account number in the selected account range for the transfer (for example, 5123). |
|
AccountDescp |
VarChar |
50 |
The text description for the account (for example, Plumbing). |
|
Year |
YYYY |
4 |
The year of the period (for example, 2004). |
|
Month |
MM |
2 |
The month of the period (for example, 02). |
|
Actual |
|
|
The actual amount (for example, 4100). |
|
Budget |
|
|
The budgeted amount (for example, 4101). |
|
Forecast |
|
|
The forecasted amount (for example, 4111). |
Example
<ExpenseTable>
<Accounts>
<AcctType>'D'</AcctType>
<Entity>'01003'</Entity>
<BegGLAccountNo>'5123'</BegGLAccountNo>
<EndGLAccountNo>'5123'</EndGLAccountNo>
<AccountDescp>'Plumbing'</AccountDescp>
<Detail>
<Year>'2004'</Year>
<Month>'01'</Month>
<Actual>'4100'</Actual>
<Budget>'4101'</Budget>
<Forecast>'4111'</Forecast>
</Detail>
<Detail>
<Year>'2004'</Year>
<Month>'02'</Month>
<Actual>'4200'</Actual>
<Budget>'4202'</Budget>
<Forecast>'4222'</Forecast>
</Detail>
</Accounts>
</ExpenseTable>
See Also
Copyright © 2018 Infor. All rights reserved. www.infor.com.