The following format is an XML file format used for invoice export.
 Invoice.XML Export File Format_Header
Invoice.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 | 
 Invoice.XML Export File Format_Invoice Detail
Invoice.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 | 
<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
Copyright © 2018 Infor. All rights reserved. www.infor.com.