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.