ebInterface is an XML invoice standard that is used in Austria.
If you receive XML invoices from one or more companies from there, the invoices may come in this format.
This topic lists the INVOICES field types that are normally mapped to elements in these documents and indicates where in the XML code the elements are normally found. The INVOICES field types that are not normally mapped to XML elements are not listed here.
For more information on how the logic in COLLECTOR's intelligent XML functionality works with this standard, please see ReadSoft COLLECTOR Integration Specification.pdf. You can obtain this document from your ReadSoft representative.
|
INVOICES field |
Location of element mapped in the XML code |
|---|---|
|
Buyer fields |
|
| Name |
Invoice/InvoiceRecipient/Address/Name |
| Buyer VAT Regno | Invoice/InvoiceRecipient/VATIdentificationNumber |
| Country Code | Invoice/InvoiceRecipient/Address/Country@CountryCode |
|
Country |
Invoice/InvoiceRecipient/Address/Country |
|
Postal Code |
Invoice/InvoiceRecipient/Address/ZIP |
| Street | Invoice/InvoiceRecipient/Address/Street |
| POBox | Invoice/InvoiceRecipient/Address |
| City | Invoice/InvoiceRecipient/Address/Town |
| Telephone Number | Invoice/InvoiceRecipient/Address/Phone |
|
Invoice/InvoiceRecipient/Address/Email |
|
| Fax Number | |
| Buyer number | |
| Supplier fields | |
|
Name |
Invoice/Biller/Address/Name |
| Supplier no | invoice/Biller/invoiceRecipientBillerID |
| PO Box | invoice/Biller/Address/POBox |
|
Street |
invoice/Biller/Address/Street |
| Postal Code |
invoice/Biller/Address/ZIP |
| City | invoice/Biller/Address/Town |
| Country Code | invoice/Biller/Address/Country/@CountryCode |
| Country | invoice/Biller/Address/Country |
| Telephone Number | invoice/Biller/Address/Phone |
| Supplier Tax reg no | invoice/Biller/VATIdentificationNumber |
| invoice/Biller/Address/Email | |
| FaxNumber | |
| INVOICES Standard Field Types |
Location of element mapped in the XML code |
| Invoice Credit |
If (DocumentType = Invoice OR DocumentType = InvoiceForAdvancePayment OR DocumentType= InvoiceForPartialDelivery OR DocumentType=FinalSettlement OR DocumentType=SubsequentDebit ) { if( PayableAmount >= 0) Its an invoice if( PayableAmount < 0) Its a credit note } If (DocumentType = CreditMemo OR DocumentType = SelfBilling OR DocumentType= SubsequentCredit OR ) { if( PayableAmount >= 0) Its a Credit note if( PayableAmount < 0) Its an Invoice } |
| Invoice number | Invoice/InvoiceNumber |
| Invoice date | Invoice/InvoiceDate |
| GrossAmount | invoice/TotalGrossAmount |
| invoice currency | invoice/invoiceCurrency |
| Invoice order number |
Invoice/invoiceRecipient/OrderReference/OrderID Add advanced rule. Use line item value if missing on header level: |
| Buyer VAT reg no | invoice/invoiceRecipient/VATIdentificationNumber |
| Supplier VAT reg no | Invoice/Biller/VATIdentificationNumber |
| Invoice baseline date | Invoice/InvoiceDate |
| Invoice due date | invoice/PaymentConditions/DueDate |
| Tax rate percent | Invoice/Tax/VAT/item/TaxRate |
| Tax |
Sum of all Invoice/Tax/VAT/Item/TaxedAmount There is no field in the standard. XSL code: <xsl:template match="/"> <xsl:variable name='VATItems' select="/eb:Invoice/eb:Tax/eb:VAT/eb:Item" /> <xsl:variable name='SumOfVATAmount' select="sum($VATItems/eb:Amount)" /> <xsl:value-of select="$SumOfVATAmount"/> </xsl:template |
| Subtotal (netto) |
Sum of all line item amounts: Invoice/Details/ItemList/ListLineItem/LineItemAmount XSL code: <xsl:template match="/"> <xsl:for-each select="/*[local-name()='Invoice']/*[local-name()='Tax']/*[local-name()='VAT']"> <xsl:if test="."> <xsl:variable name='TaxAmount' select="sum(*[local-name()='Item']/*[local-name()='Amount'])" /> <xsl:value-of select="format-number($TaxAmount,'0.00')"/> </xsl:if> </xsl:for-each> </xsl:template> |
| Delivery date | Invoice/Delivery/Date |
| Supplier account number 1, 2, 3 | |
| Payment type | |
| Payment terms | |
| Payment terms interest | |
| payment reference number | |
| Delivery terms | |
| Delivery note | Invoice/Delivery/Description |
| Invoice tax amount 1-3 | |
| Buyer tax number 1-2 | |
| Invoice note | |
| Invoice period end | |
| Invoice period start | |
| Postal code (Supplier) | |
| Buyer contact person name | |
| Line Item Fields |
Location of element mapped in the XML code |
|
LIT_ArticleName |
Description |
|
LIT_ArticleNumber |
ArticleNumber |
|
LIT_DeliveredQuantity |
Quantity |
|
LIT_DeliveredQuantityUnitCode |
Quantity/@Unit |
|
LIT_DiscountAmount |
|
|
LIT_OrderNumber |
Map to: Invoice/Details/ItemList/ListLineItem/InvoiceRecipientOrderReference/OrderID. Use advanced rule. If missing, use: Invoice/Details/ItemList/ListLineItem/BillerOrderReference/OrderID |
|
LIT_RowIdentifier |
Invoice/Details/itemList/ListLineItem/PositionNumber |
|
LIT_UnitPriceAmount |
UnitPrice |
|
LIT_VatAmount |
|
|
LIT_VatExcludedAmount |
|
|
LITVatIncludedAmount |
|
|
LIT_VatRate |
TaxRate |
|
Attachment fields |
Location of element mapped in the XML code |
|
ID |
|
| FileName | |
| EmbeddedValue | |
| DataURI | |
|
SchemeURI |
|
|
DataType |
|
|
LinkType |
|
|
AdditionalInfo |
|
|
Invoice note field |
Location of element mapped in the XML code |
Supported XML invoice standard formats
Processing XML invoices using COLLECTOR: Overview
Optimizing XML invoice definitions
Creating rules to map values for fields in XML invoices