Invoice Export — XML File Format

The following format is an XML file format used for invoice export.

ClosedInvoice.XML Export File Format_Header

Field

Field Name

Description

1

Voucher

Voucher number

2

Payee

Vendor ID

3

InvoiceNumber

Invoice Number

4

InvoiceDate

Invoice Date

5

Description

Invoice Description

6

Amount

Total amount

7

DueDate

Due Date (MM/DD/YYYY)

8

DiscountRate

Discount Rate

9

DiscountDueDate

Discount Due Date (MM/DD/YYYY)

10

Status

P=Paid, R=Partially Paid, N=Normal, V=Void

11

Hold

Hold code

12

Type

Type (Regular, Credit, Adjustment)

13

SeparateCheck

Separate Check (Y/N)

14

PaidAmount

Paid Amount _ how much has been paid already

15

ApprovedBy

User who approved the invoice

16

ApprovedDate

Approved Date _ when invoice was approved

ClosedInvoice.XML Export File Format_Invoice Detail

Field

Field Name

Description

1

Batch

Batch

2

TranDate

Tran Date (MM/DD/YYYY)

3

DateOfRecord

Date of record (MM/DD/YYYY)

4

Period Accounting

Period (MM/YYYY)

5

Description

Line Item Description

6

Amount

Amount

7

DueDate

Due Date (MM/DD/YYYY)

8

Discount

Discount

9

DiscountDueDate

Discount Due Date (MM/DD/YYYY)

10

DiscountTaken

Discount Taken

11

ExpenseCode

Expense Code (account number)

12

Reference

Reference

13

PO

PO

14

PropertyCompany

PropertyCompany

15

Building

Building

16

Unit

Unit

17

Resident

Resident

18

Category1099

Category 1099

19

SourceApplication

Source Application  (which app created the transaction)

20

SeparateCheck

Check (Y/N value)

21

ApprovedDate

Approved Date (MM/DD/YYYY)

22

ApprovedUser

Approved User

ClosedSample File Format

<xml>

<InvoiceHeader>

<Voucher>51078</Voucher>

<Payee>10777</Payee>

<InvoiceNumber>08/09/2011.001</InvoiceNumber>

<InvoiceDate>8/9/2011</InvoiceDate>

<Description>testing month end create recurring</Description>

<Amount>300.00</Amount>

<DueDate>8/9/2011</DueDate>

<DiscountRate>0</DiscountRate>

<DiscountDueDate>8/9/2011</DiscountDueDate>

<Status>N</Status>

<Hold></Hold>

<Type>R</Type>

<SeparateCheck>N</SeparateCheck>

<PaidAmount>0.00</PaidAmount>

<ApprovedBy>april</ApprovedBy>

<ApprovedDate>8/15/2011</ApprovedDate>

<InvoiceDetail>

<Batch>18688</Batch>

<TranDate>8/9/2011</TranDate>

<DateOfRecord>8/9/2011</DateOfRecord>

<Period>08/2011</Period>

<Description>line 1</Description>

<Amount>300.00</Amount>

<DueDate>8/9/2011</DueDate>

<Discount>0.00</Discount>

<DiscountDueDate>8/9/2011</DiscountDueDate>

<DiscountTaken></DiscountTaken>

<ExpenseCode>6030</ExpenseCode>

<Reference></Reference>

<PO></PO>

<PropertyCompany>CB122</PropertyCompany>

<Building></Building>

<Unit></Unit>

<Resident></Resident>

<Category1099>M07</Category1099>

<SourceApplication>EFN</SourceApplication>

<SeparateCheck>N</SeparateCheck>

<ApprovedDate>8/15/2011</ApprovedDate>

<ApprovedUser>lisa</ApprovedUser>

</InvoiceDetail>

</InvoiceHeader>

<InvoiceHeader>

<Voucher>51112</Voucher>

<Payee>10777</Payee>

<InvoiceNumber>cb122Invoice</InvoiceNumber>

<InvoiceDate>8/15/2011</InvoiceDate>

<Description>815.00</Description>

<Amount>815.00</Amount>

<DueDate>8/15/2011</DueDate>

<DiscountRate>0</DiscountRate>

<DiscountDueDate>8/15/2011</DiscountDueDate>

<Status>N</Status>

<Hold></Hold>

<Type>R</Type>

<SeparateCheck>N</SeparateCheck>

<PaidAmount>0.00</PaidAmount>

<ApprovedBy>carol</ApprovedBy>

<ApprovedDate>8/15/2011</ApprovedDate>

<InvoiceDetail>

<Batch>18690</Batch>

<TranDate>8/15/2011</TranDate>

<DateOfRecord>8/15/2011</DateOfRecord>

<Period>08/2011</Period>

<Description>Rent.Com</Description>

<Amount>815.00</Amount>

<DueDate>8/15/2011</DueDate>

<Discount>0.00</Discount>

<DiscountDueDate>8/15/2011</DiscountDueDate>

<DiscountTaken></DiscountTaken>

<ExpenseCode>5100 01</ExpenseCode>

<Reference></Reference>

<PO></PO>

<PropertyCompany>CB122</PropertyCompany>

<Building></Building>

<Unit></Unit>

<Resident></Resident>

<Category1099>M07</Category1099>

<SourceApplication>EFN</SourceApplication>

<SeparateCheck>N</SeparateCheck>

<ApprovedDate>8/15/2011</ApprovedDate>

<ApprovedUser>carol</ApprovedUser>

</InvoiceDetail></InvoiceHeader></xml>

See Also

Data Transfer File Formats Introduction

Invoice Export Tab

AP Transactions Import Tab

Transfer to AP Tab