The following format is an XML file format used for invoice export.
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
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.