Skip to main content
Skip table of contents

Routty XML formats

This document contains the description of all xml formats used by Routty to exchange any kind of information. By default, the data can be transmitted directly to the REST API of Routty or to an SFTP location to be picked up.

Lexicon

Lexicon

Abbreviation

Explanation

AP

Accounts Payable

AR

Accounts Receivable

PO

Purchase Order

GR

Goods Receipt

VAT

Value Added Tax

CGID

Corporate Group ID, this field can be used to group entities in a corporate group. All companies in a group share the same settings and suppliers. When these are used, the ID should match between buyer and supplier.

Encoding

Routty supports Unicode encodings, in particular utf-8, utf-16 and utf-32.
The preferred and default encoding is utf-8

Import in Routty

Analytical coding data

Description

Analytical master data can be uploaded to allow the user to use this data to form booking proposals. These values are used for validation and enable the user to select these values in Routty.

Example

XML 
<?xml version="1.0" encoding="utf-8"?>
<AccountingMasterDataList>
  <AccountingMasterData type="string">
    <Value>string</Value>
    <Description>string</Description>
    <CorporateGroupID>string</CorporateGroupID>
    <Field1>string</Field1>
    <Field2>string</Field2>
    <Field3>string</Field3>
    <Field4>string</Field4>
    <Field5>string</Field5>
    <Field6>string</Field6>
    <Field7>string</Field7>
    <Field8>string</Field8>
    <Field9>string</Field9>
    <Field10>string</Field10>
  </AccountingMasterData>
</AccountingMasterDataList>

Fields

Field

Description

Datatype

Required

Possible value

type

Type of master data delivered to Routty

string

Yes

GlAccount

CostCenter

VatCode

VatSystem

Dimension1

Dimension2

Dimension3

Dimension4

Dimension5

Dimension6

Dimension7

Dimension8

Currency

PaymentTerms

CommodityCode

UnitOfMeasurement

Country

CodingTemplate

Value

Value of the data

string(50)

No

Alphabetic values and/or Numerical characters

Description

Description of the data

string(255)

No

Alphabetic values and/or Numerical characters

CorporateGroupID

Corporate group identifier

string(100)

No

Alphabetic values and/or Numerical characters

Field[1-10]

Free form text field

string(50)

No

Alphabetic values and/or Numerical characters

Purchase order data

Description

Purchase order data is persisted in Routty to be used in the AP business flows. These orders can for example be used to be paired and matched with an invoice.

Example

XML 
<?xml version="1.0" encoding="utf-8"?>
<PurchaseOrderMasterDataList>
  <PurchaseOrderMasterData>
    <PurchaseOrderHeader>
      <DocumentReference>string</DocumentReference>
      <ExtraReference>string</ExtraReference>
      <DocumentDate>2019-12-31T22:22:22</DocumentDate>
      <DocumentType>string</DocumentType>
      <DocumentSubType>string</DocumentSubType>
      <Currency>string</Currency>
      <TotalNetAmount>3.4</TotalNetAmount>
      <TotalVatAmount>3.4</TotalVatAmount>
      <TotalGrossAmount>3.4</TotalGrossAmount>
      <TotalDiscountAmount>3.4</TotalDiscountAmount>
      <OrderReference>string</OrderReference>
      <HeaderText1>string</HeaderText1>
      <HeaderText2>string</HeaderText2>
      <StartDate>2019-12-31T22:22:22</StartDate>
      <EndDate>2019-12-31T22:22:22</EndDate>
      <DocumentRawId>1000</DocumentRawId>
      <DocumentStatus>string</DocumentStatus>
      <RequesterId>1000</RequesterId>
      <SupplierName>string</SupplierName>
      <SupplierNumber>string</SupplierNumber>
      <SupplierRegistrationNumber>string</SupplierRegistrationNumber>
      <SupplierIban>string</SupplierIban>      
      <SupplierSiteCode>string</SupplierSiteCode>
      <BuyerNumber>string</BuyerNumber>
      <BuyerName>string</BuyerName>
      <BuyerSiteCode>string</BuyerSiteCode>
    </PurchaseOrderHeader>
    <PurchaseOrderLines>
      <PurchaseOrderLine>
        <LineId>string</LineId>
        <ExtraReference>string</ExtraReference>
        <ArticleNumberSupplier>string</ArticleNumberSupplier>
        <ArticleNumberBuyer>string</ArticleNumberBuyer>
        <ArticleDescription>string</ArticleDescription>
        <StandardArticleNumber>string</StandardArticleNumber>
        <Quantity>3.4</Quantity>
        <UnitCode>string</UnitCode>
        <Price>3.4</Price>
        <GrossUnitPrice>3.4</GrossUnitPrice>
        <StartDate>2019-12-31T22:22:22</StartDate>
        <EndDate>2019-12-31T22:22:22</EndDate>
        <DiscountAmount>3.4</DiscountAmount>
        <DiscountRate>string</DiscountRate>
        <LineAmount>3.4</LineAmount>
        <Status>string</Status>
        <GlAccount>string</GlAccount>
        <CostCenter>string</CostCenter>
        <VatCode>string</VatCode>
        <Dimension1>string</Dimension1>
        <Dimension2>string</Dimension2>
        <Dimension3>string</Dimension3>
        <Dimension4>string</Dimension4>
        <Dimension5>string</Dimension5>
        <Dimension6>string</Dimension6>
        <Dimension7>string</Dimension7>
        <Dimension8>string</Dimension8>
        <InvoicedQuantity>3.4</InvoicedQuantity>
        <InvoicedAmount>3.4</InvoicedAmount>
        <MatchType>0</MatchType>
        <MatchQuantity>0</MatchQuantity>
      </PurchaseOrderLine>
    </PurchaseOrderLines>
  </PurchaseOrderMasterData>
</PurchaseOrderMasterDataList>

Fields

Header

Field

Description

Datatype

Required

Possible value

DocumentReference

Reference of the order, often referred to as PO number

string(50)

Yes

PO123

ExtraReference

Additional (document) reference

string(50)

No

1232424

DocumentDate

Date on which the order was issued

date

Yes

2018-06-01

DocumentType

Document type

string(64)

Yes

Order

DocumentSubType

Document subtype

string(64)

No

Alphabetic values and/or Numerical characters

Currency

Currency for the order

string(64)

No

EUR

TotalNetAmount

Total net amount of the order

decimal(18,2)

Yes

123.45

TotalVatAmount

Expected VAT amount

decimal(18,2)

Yes

123.45

TotalGrossAmount

Total value including VAT

decimal(18,2)

Yes

123.45

TotalDiscountAmount

Total discount amount of the order

decimal(18,2)

Yes

123.45

SupplierNumber

Seller party identifier

string(50)

Yes

7300010000001

SupplierName

Name of the seller

string(255)

No

ACME

SupplierRegistrationNumber

Registered VAT identifier of the seller

string(50)

No

Alphabetic values and/or Numerical characters

SupplierIban

Seller IBAN

string(50)

No

Alphabetic values and/or Numerical characters

SupplierSiteCode

Site code for the supplier, used to identify multiple locations for the same supplier

string(50)

No

Alphabetic values and/or Numerical characters

BuyerNumber

Buyer party identifier

string(50)

Yes

7300010000001

BuyerName

Name of the buyer

string(255)

No

ACME

BuyerSiteCode

Site code for the buyer, used to identify multiple locations for the same buyer

string(50)

No

Alphabetic values and/or Numerical characters

HeaderText1

Header free form text field

string(255)

No

Alphabetic values and/or numerical characters

HeaderText2

Header free form text field

string(255)

No

Alphabetic values and/or numerical characters

StartDate

Order start date

date

No

2018-06-01

EndDate

Order end date

date

No

2018-06-01

DocumentStatus

Status of the order (open, closed…)

string(64)

No

Invoiced

RequesterId

Person ordering identifier

string(255)

No

Alphabetic values and/or numerical characters

Lines

Field

Description

Datatype

Required

Possible value

LineID

Identifier of the line item assigned by the buyer. Must be unique within the order.

string(64)

Yes

1

ExtraReference

Additional (document) reference

string(128)

Yes

Alphabetic values and/or numerical characters

ArticleNumberBuyer

Identifier, assigned by the buyer, for the item

string(128)

No

Alphabetic values and/or numerical characters

ArticleNumberSupplier

Identifier, assigned by the seller, for the item

string(128)

No

Alphabetic values and/or numerical characters

ArticleDescription

Description of the item

string(512)

No

Alphabetic values and/or Numerical characters

StandardArticleNumber

Item identifier based on a standard system

string(128)

No

Alphabetic values and/or numerical characters

Quantity

Amount of items

decimal(18,6)

No

123.456789

UnitCode

Unit of measure that applies to the ordered quantity

string(64)

No

Alphabetic values and/or numerical characters

GrossUnitPrice

The gross price of the item before subtracting discounts, e.g. list price

decimal(18,6)

No

123.456789

Price

Net item price, excluding VAT

decimal(18,6)

No

123.456789

DiscountAmount

Total discount amount of the line item

decimal(18,6)

No

123.456789

DiscountRate

Discount percentage

decimal(6,4)

No

20.0000

LineAmount

Total amount for the line item, excluding VAT

decimal(18,6)

No

123.45

Status

Status of the line item (open, closed…)

string(64)

No

Invoiced

GLAccount

General Ledger account applied to the line item

string(50)

No

Numerical characters

CostCenter

Cost center applied to the line item

string(50)

No

Alphabetic values and/or Numerical characters

VatCode

Accounting VAT category identifier that applies for the line item

string(50)

No

Alphabetic values and/or Numerical characters

Dimension[1-8]

To be specified

string(255)

No

Alphabetic values and/or Numerical characters

StartDate

Order item start date

date

No

2018-06-01

EndDate

Order item end date

date

No

2018-06-01

InvoicedAmount

Total invoiced amount for the line item, excluding VAT

decimal(18,6)

No

123.45

InvoicedQuantity

Total invoiced quantity for the line item

decimal(18,6)

No

123.456789

MatchType

Matching type

integer

No

0 (Exempt)
1 (Order)
2 (Receipt)
3 (ThreeWay)
4 (Quality)
7 (FourWay)

MatchQuantity

Item quantity that is matched

integer

No

1 (Quantity/unit price)
2 (Amount)
3 (Both)

Goods receipt data

Description

Goods receipt data is persisted in Routty to be used in the AP business flows. These receipts can for example be used to be paired and matched with an invoice.

Example

XML 
<?xml version="1.0" encoding="utf-8"?>
<GoodsReceiptMasterDataList>
  <GoodsReceiptMasterData>
    <GoodsReceiptHeader>
      <DocumentReference>string</DocumentReference>
      <ExtraReference>string</ExtraReference>
      <DocumentDate>2019-12-31T22:22:22</DocumentDate>
      <DocumentType>string</DocumentType>
      <DocumentSubType>string</DocumentSubType>
      <Currency>string</Currency>
      <OrderReference>string</OrderReference>
      <HeaderText1>string</HeaderText1>
      <HeaderText2>string</HeaderText2>
      <DocumentStatus>string</DocumentStatus>
      <SupplierNumber>string</SupplierNumber>
      <SupplierName>string</SupplierName>
      <SupplierRegistrationNumber>string</SupplierRegistrationNumber>
      <SupplierIban>string</SupplierIban>
      <SupplierSiteCode>string</SupplierSiteCode>
      <BuyerNumber>string</BuyerNumber>
      <BuyerName>string</BuyerName>
      <BuyerSiteCode>string</BuyerSiteCode>
    </GoodsReceiptHeader>
    <GoodsReceiptLines>
      <GoodsReceiptLine>
        <LineId>string</LineId>
        <OrderReference>string</OrderReference>
        <OrderLineId>string</OrderLineId>
        <ExtraReference>string</ExtraReference>
        <ArticleNumberSupplier>string</ArticleNumberSupplier>
        <ArticleNumberBuyer>string</ArticleNumberBuyer>
        <ArticleDescription>string</ArticleDescription>
        <StandardArticleNumber>string</StandardArticleNumber>
        <Quantity>3,4</Quantity>
        <UnitCode>string</UnitCode>
        <Price>3,4</Price>
        <GrossUnitPrice>3,4</GrossUnitPrice>
        <DiscountAmount>3,4</DiscountAmount>
        <DiscountRate>3,4</DiscountRate>
        <LineAmount>3,4</LineAmount>
        <Status>string</Status>
        <InvoicedAmount>3,4</InvoicedAmount>
        <InvoicedQuantity>3,4</InvoicedQuantity>
        <AcceptedAmount>3,4</AcceptedAmount>
        <AcceptedQuantity>3,4</AcceptedQuantity>
        <MatchType>0</MatchType>
        <MatchQuantity>0</MatchQuantity>
      </GoodsReceiptLine>
    </GoodsReceiptLines>
  </GoodsReceiptMasterData>
</GoodsReceiptMasterDataList>

Fields

Header

Field

Description

Datatype

Required

Possible value

DocumentReference

Reference of the (goods) receipt, also referred to as GR number

string(50)

Yes

0-123

ExtraReference

Additional (document) reference

string(50)

No

1232424

DocumentDate

Date on which the receipt advice was issued

date

Yes

2018-06-01

DocumentType

Document type

string(64)

No

Receipt

DocumentSubType

Document subtype

string(64)

No

Alphabetic values and/or numerical characters

Currency

Currency for the receipt

string(64)

No

EUR

OrderReference

Reference of the order, often referred to as PO number

string(128)

No

PO123

SupplierNumber

Seller party identifier

string(50)

Yes

7300010000001

SupplierName

Name of the seller

string(255)

No

ACME

SupplierRegistrationNumber

Registered VAT identifier of the seller

string(50)

No

Alphabetic values and/or Numerical characters

SupplierIban

Seller IBAN

string(50)

No

Alphabetic values and/or Numerical characters

SupplierSiteCode

Site code for the supplier, used to identify multiple locations for the same supplier

string(50)

No

Alphabetic values and/or Numerical characters

BuyerNumber

Buyer party identifier

string(50)

Yes

7300010000001

BuyerName

Name of the buyer

string(255)

No

ACME

BuyerSiteCode

Site code for the buyer, used to identify multiple locations for the same buyer

string(50)

No

Alphabetic values and/or Numerical characters

HeaderText1

Header free form text field

string(255)

No

Alphabetic values and/or Numerical characters

HeaderText2

Header free form text field

string(255)

No

Alphabetic values and/or Numerical characters

DocumentStatus

Status of the receipt advice (open, closed…)

string(64)

No

Invoiced

Lines

Field

Description

Datatype

Required

Possible value

LineID

Identifier of the line item assigned by the buyer. Must be unique within the receipt.

string(64)

Yes

1

OrderReference

Reference of the order, often referred to as PO number

string(50)

No

PO123

OrderLineId

Identifier of the order line item assigned by the buyer

string(64)

No

1

ExtraReference

Additional (document) reference

string(128)

No

Alphabetic values and/or numerical characters

ArticleNumberBuyer

Identifier, assigned by the buyer, for the item

string(128)

No

Alphabetic values and/or numerical characters

ArticleNumberSupplier

Identifier, assigned by the seller, for the item

string(128)

No

Alphabetic values and/or numerical characters

ArticleDescription

Description of the item

string(512)

No

Alphabetic values and/or numerical characters

StandardArticleNumber

Item identifier based on a standard system

string(128)

No

Alphabetic values and/or numerical characters

Quantity

Amount of items

decimal(18,6)

No

123.456789

UnitCode

Unit of measure that applies to the ordered quantity

string(64)

No

Alphabetic values and/or numerical characters

GrossUnitPrice

The gross price of the item before subtracting discounts, e.g. list price

decimal(18,6)

No

123.456789

Price

Net item price, excluding VAT

decimal(18,6)

No

123.456789

DiscountAmount

Total discount amount of the line item

decimal(18,6)

No

123.456789

DiscountRate

Discount percentage

decimal(6,4)

No

20.0000

LineAmount

Total amount for the line item, excluding VAT

decimal(18,6)

No

123.45

Status

Status of the line item (open, closed…)

string(64)

No

Invoiced

InvoicedAmount

Total invoiced amount for the line item, excluding VAT

decimal(18,6)

No

123.45

InvoicedQuantity

Total invoiced quantity for the line item

decimal(18,6)

No

123.456789

AcceptedAmount

Total accepted amount for the line item, excluding VAT (QA)

decimal(18,6)

No

123.45

AcceptedQuantity

Total accepted quantity for the line item (QA)

decimal(18,6)

No

123.456789

MatchType

Matching type

integer

No

0 (Exempt)
1 (Order)
2 (Receipt)
3 (ThreeWay)
4 (Quality)
7 (FourWay)

MatchQuantity

Item quantity that is matched

integer

No

1 (Quantity/unit price)
2 (Amount)
3 (Both)

Articles

Description

Articles can be imported and used in business flows that deal with material items.

Example

XML 
<?xml version="1.0" encoding="UTF-8"?>
<ArticleList>
    <Article>
        <CorporateGroupID>string</Art_CorporateGroupID>
        <Number>string</Art_Number>
        <Description>string</Description>
        <Type>string</Type>
        <GTIN>string</GTIN>
        <UnitOfMeasurement>string</ UnitOfMeasurement>
        <UnitPrice>decimal</UnitPrice>
    </Article>
    <Article>
        <CorporateGroupID>string</ CorporateGroupID>
        <Number>string</Number>
        <Description>string</Description>
        <Type>string</Type>
        <GTIN>string</GTIN>
        <UnitOfMeasurement>string</UnitOfMeasurement>
        <UnitPrice>decimal</UnitPrice>
    </Article>
</ArticleList>

Fields

Field

Description

Datatype

Required

Possible value

CorporateGroupID

Corporate group identifier

string(100)

No

Numerical characters

Number

Identifier for the item

string(32)

Yes

123455

Description

Description for the item

string(255)

No

Alphabetic values and/or numerical characters

Type

Item type

string(255)

No

Alphabetic values and/or numerical characters

GTIN

Global Trade Item Number

string(14)

No

Alphabetic values and/or numerical characters

UnitOfMeasurement

Unit of measure that applies to the stock item

string(50)

No

Alphabetic values and/or numerical characters

UnitPrice

Net (stock) item price, excluding VAT

decimal(18,4)

No

123.4567

Parties

Description

The parties xml is used to import and export any kind of party to Routty. This includes both legal entities of your own company and suppliers you might deal with.

Example

XML 
<?xml version="1.0" encoding="utf-8"?>
<PartyList>
  <Party>
    <Metadata>
      <Number>string</Number>
      <SiteCode>string</SiteCode>
      <CorporateGroupID>string</CorporateGroupID>
      <Name1>string</Name1>
      <Name2>string</Name2>
      <Address1>string</Address1>
      <Address2>string</Address2>
      <PoBox>string</PoBox>
      <PostalCode>string</PostalCode>
      <City>string</City>
      <State>string</State>
      <Location>string</Location>
      <CountryCode>string</CountryCode>
      <Telephone>string</Telephone>
      <EmailAddress>string</EmailAddress>
      <PaymentTerms>string</PaymentTerms>
      <PaymentMethod>string</PaymentMethod>
      <Dimension1>string</Dimension1>
      <Dimension2>string</Dimension2>
      <Dimension3>string</Dimension3>
      <Dimension4>string</Dimension4>
      <Dimension5>string</Dimension5>
      <Dimension6>string</Dimension6>
      <Dimension7>string</Dimension7>
      <Dimension8>string</Dimension8>
      <PartyRegistrationNumbers>
        <PartyRegistrationNumber>
          <Number>string</Number>
          <Scheme>string</Scheme>
        </PartyRegistrationNumber>
      </PartyRegistrationNumbers>
      <PartyBankAccounts>
        <PartyBankAccount>
          <BankNumber>string</BankNumber>
          <AccountNumber>string</AccountNumber>
          <IBAN>string</IBAN>
          <BIC>string</BIC>
          <Currency>string</Currency>
          <Dimension1>string</Dimension1>
          <Dimension2>string</Dimension2>
          <Dimension3>string</Dimension3>
          <Dimension4>string</Dimension4>
        </PartyBankAccount>
      </PartyBankAccounts>
    </Metadata>
    <Type>
      <Name>string</Name>
    </Type>
    <Active>false</Active>
  </Party>
</PartyList>

Fields

Note that the combination of party Number, CorporateGroupID, and SiteCode must be unique!

At least one party must be present in the list.

Field

Description

Datatype

Required

Possible value

Active

True if the party can be used in business processes, False if it should block.

boolean

No

True or False

Metadata (required)

Field

Description

Datatype

Required

Possible value

Number

Party identifier

string(100)

Yes

7300010000001

SiteCode

Identifier for a site, establishment, or outlet of the party

string(100)

No

Alphabetic values and/or numerical characters

CorporateGroupID

Corporate group identifier

string(100)

No

Alphabetic values and/or numerical characters

Name1

(Business) name of the party

string(400)

Yes

ACME

Name2

Additional name of the party

string(400)

No

Alphabetic values and/or numerical characters

Address1

Main address line of the party site

string(400)

Yes*

Main Street 1

Address2

Additional address line of the party

string(400)

No

Alphabetic values and/or numerical characters

POBox

Optional PO box

string(50)

No

351

PostalCode

Post/ZIP code

string(12)

Yes*

W1G 8LZ

City

Common name of the city, town or village where the party site is located

string(100)

Yes*

London

State

State/province

string(100)

No

State A

Location

Subdivision of a country, region, city, ... such as a county

string(100)

No

Region A

CountryCode

Country code

string(3)

Yes*

GB

Restriction:
https://www.iso.org/iso-3166-country-codes.html

Telephone

Phone number for the contact point

string(31)

No

887 654 321

EmailAddress

E-mail address for the contact point

string(100)

No

info@example.com

PaymentTerms

Identifier for the default payment terms associated with this party

string(100)

No

30E

PaymentMethod

Identifier for the expected means of payment

string(100)

No

30

Dimension[1-8]

To be specified

string(400)

No

Alphabetic values and/or numerical characters

* This is especially important when combined with a scanning solution, such as Routty Capture. If not, these fields can be optional.

Type (required)

Field

Description

Datatype

Required

Possible value

Name

Party type identifier

string

Yes

Company
Partner

PartyRegistrationNumber

Note that the combination of party registration Number, and Scheme must be unique!

Only one instance per Scheme (per party) is allowed.

Field

Description

Datatype

Required

Possible value

Number

Party identifier, party legal registration identifier, party VAT identifier, etc.

string(100)

Yes

5060012349998

Restriction (if and only if Scheme = VAT):
[A-Z]{2}[0-9A-Z\-]{5,}

Scheme

Identification scheme identifier of the party identifier

string(50)

Yes

VAT

PartyBankAccount

Note that the combination of party registration AccountNumber, and/or IBAN must be unique!

Field

Description

Datatype

Required

Possible value

BankNumber

Identifier for the payment service provider where a payment account is located

string(50)

No

Alphabetic values and/or numerical characters

AccountNumber

Unique identifier of the financial payment account, at a payment service provider

string(50)

Yes

Alphabetic values and/or numerical characters

IBAN

IBAN

string(34)

Yes

NO99991122222

Restriction:
[A-Z]{2}[0-9]{2}[0-9A-Z]{3,30}

BIC

BIC

string(11)

No

9999

Currency

Native currency of the account

string(3)

No

EUR

Restriction:
https://www.iso.org/iso-4217-currency-codes.html

Dimension[1-4]

To be specified

string(400)

No

Alphabetic values and/or numerical characters

Export from Routty

Purchase invoice data

Description

The following chapter gives insight in the standard output fields that are used in the export from Routty.

Example

XML 
<?xml version="1.0" encoding="utf-8"?>
<RouttyExportDocument>
  <MetaData>
    <DocumentSetId>1000</DocumentSetId>
    <DocumentRawId>1000</DocumentRawId>
    <Guid>00000000-0000-0000-0000-000000000000</Guid>
    <DocumentType>1000</DocumentType>
  </MetaData>
  <PurchaseInvoice>
    <PurchaseInvoiceHeader>
      <Buyer>
        <Name>string</Name>
        <Number>string</Number>
        <Address>string</Address>
        <PostalCode>string</PostalCode>
        <City>string</City>
        <CountryCode>string</CountryCode>
        <SiteCode>string</SiteCode>
        <CorporateGroupID>string</CorporateGroupID>
        <RegistrationNumbers>
          <RegistrationNumber>
            <Number>string</Number>
            <Scheme>string</Scheme>
          </RegistrationNumber>
        </RegistrationNumbers>
      </Buyer>
      <Supplier>
        <Name>string</Name>
        <Number>string</Number>
        <Address>string</Address>
        <PostalCode>string</PostalCode>
        <City>string</City>
        <CountryCode>string</CountryCode>
        <SiteCode>string</SiteCode>
        <CorporateGroupID>string</CorporateGroupID>
        <RegistrationNumbers>
          <RegistrationNumber>
            <Number>string</Number>
            <Scheme>string</Scheme>
          </RegistrationNumber>
        </RegistrationNumbers>
        <BankAccounts>
          <BankAccount>
            <BankNumber>string</BankNumber>
            <AccountNumber>string</AccountNumber>
            <IBAN>string</IBAN>
            <BIC>string</BIC>
            <Currency>string</Currency>
          </BankAccount>
        </BankAccounts>
      </Supplier>
      <Id>1000</Id>
      <DocumentReference>string</DocumentReference>
      <DocumentDate>string</DocumentDate>
      <OrderReference>string</OrderReference>
      <ReceiptReference>string</ReceiptReference>
      <ExtraReference>string</ExtraReference>
      <DueDate>string</DueDate>
      <PaymentReference>string</PaymentReference>
      <PaymentTerms>string</PaymentTerms>
      <PaymentTermsCode>string</PaymentTermsCode>
      <DocumentSubType>string</DocumentSubType>
      <Currency>string</Currency>
      <CurrencyRate>string</CurrencyRate>
      <TotalNetAmount>string</TotalNetAmount>
      <TotalVatAmount>string</TotalVatAmount>
      <TotalGrossAmount>string</TotalGrossAmount>
      <TotalDiscountAmount>string</TotalDiscountAmount>
      <PaymentIBAN>string</PaymentIBAN>
      <ReceivedBuyerNumber>string</ReceivedBuyerNumber>
      <ReceivedBuyerName>string</ReceivedBuyerName>
      <ReceivedBuyerRegistrationNumber>string</ReceivedBuyerRegistrationNumber>
      <ReceivedSupplierNumber>string</ReceivedSupplierNumber>
      <ReceivedSupplierName>string</ReceivedSupplierName>
      <ReceivedSupplierRegistrationNumber>string</ReceivedSupplierRegistrationNumber>
      <NetAmount1>string</NetAmount1>
      <NetAmount2>string</NetAmount2>
      <NetAmount3>string</NetAmount3>
      <NetAmount4>string</NetAmount4>
      <NetAmount5>string</NetAmount5>
      <VatAmount1>string</VatAmount1>
      <VatAmount2>string</VatAmount2>
      <VatAmount3>string</VatAmount3>
      <VatAmount4>string</VatAmount4>
      <VatAmount5>string</VatAmount5>
      <VatRate1>string</VatRate1>
      <VatRate2>string</VatRate2>
      <VatRate3>string</VatRate3>
      <VatRate4>string</VatRate4>
      <VatRate5>string</VatRate5>
      <HeaderCost1>string</HeaderCost1>
      <HeaderCost2>string</HeaderCost2>
      <HeaderCost3>string</HeaderCost3>
      <HeaderCost4>string</HeaderCost4>
      <HeaderCost5>string</HeaderCost5>
      <HeaderDiscount1>string</HeaderDiscount1>
      <HeaderDiscount2>string</HeaderDiscount2>
      <HeaderDiscount3>string</HeaderDiscount3>
      <HeaderDiscount4>string</HeaderDiscount4>
      <HeaderDiscount5>string</HeaderDiscount5>
      <HeaderText1>string</HeaderText1>
      <HeaderText2>string</HeaderText2>
      <ReceptionDate>string</ReceptionDate>
      <BookingNumber>string</BookingNumber>
      <BookingDate>string</BookingDate>
      <BookingYear>string</BookingYear>
      <BookingMonth>string</BookingMonth>
      <DocumentStatus>string</DocumentStatus>
      <Journal>string</Journal>
      <TotalVatRate>string</TotalVatRate>
      <Dimension1>string</Dimension1>
      <Dimension2>string</Dimension2>
      <Dimension3>string</Dimension3>
      <Dimension4>string</Dimension4>
      <Dimension5>string</Dimension5>
      <Dimension6>string</Dimension6>
      <Dimension7>string</Dimension7>
      <Dimension8>string</Dimension8>
      <ExternalReference1>string</ExternalReference1>
      <ExternalReference2>string</ExternalReference2>
      <ExternalReference3>string</ExternalReference3>
      <ExternalReference4>string</ExternalReference4>
      <ExternalReference5>string</ExternalReference5>
      <ExternalReference6>string</ExternalReference6>
      <ExternalReference7>string</ExternalReference7>
      <ExternalReference8>string</ExternalReference8>
      <RequesterId>string</RequesterId>
      <VatSystem>string</VatSystem>
    </PurchaseInvoiceHeader>
    <PurchaseInvoiceLines>
      <PurchaseInvoiceLine>
        <Id>string</Id>
        <LineId>string</LineId>
        <ExtraReference>string</ExtraReference>
        <ArticleNumberSupplier>string</ArticleNumberSupplier>
        <ArticleNumberBuyer>string</ArticleNumberBuyer>
        <ArticleDescription>string</ArticleDescription>
        <StandardArticleNumber>string</StandardArticleNumber>
        <Quantity>string</Quantity>
        <UnitCode>string</UnitCode>
        <Price>string</Price>
        <DiscountAmount>string</DiscountAmount>
        <DiscountRate>string</DiscountRate>
        <LineAmount>string</LineAmount>
        <Status>string</Status>
        <OrderReference>string</OrderReference>
        <OrderLineId>string</OrderLineId>
        <ReceiptReference>string</ReceiptReference>
        <ReceiptLineId>string</ReceiptLineId>
        <GrossUnitPrice>string</GrossUnitPrice>
        <StartDate>string</StartDate>
        <EndDate>string</EndDate>
        <Dimension1>string</Dimension1>
        <Dimension2>string</Dimension2>
        <Dimension3>string</Dimension3>
        <Dimension4>string</Dimension4>
        <Dimension5>string</Dimension5>
        <Dimension6>string</Dimension6>
        <Dimension7>string</Dimension7>
        <Dimension8>string</Dimension8>
        <VatAmount>string</VatAmount>
        <VatRate>string</VatRate>
        <GrossAmount>string</GrossAmount>
        <PurchaseOrderLinesId>1000</PurchaseOrderLinesId>
        <GoodsReceiptLinesId>1000</GoodsReceiptLinesId>
      </PurchaseInvoiceLine>
    </PurchaseInvoiceLines>
    <PurchaseInvoiceCodingLines>
      <PurchaseInvoiceCodingLine>
        <LineId>string</LineId>
        <GlAccount>string</GlAccount>
        <Journal>string</Journal>
        <CostCenter>string</CostCenter>
        <DebitAmount>string</DebitAmount>
        <CreditAmount>string</CreditAmount>
        <VatAmount>string</VatAmount>
        <VatRate>string</VatRate>
        <VatCode>string</VatCode>
        <VatSystem>string</VatSystem>
        <Dimension1>string</Dimension1>
        <Dimension2>string</Dimension2>
        <Dimension3>string</Dimension3>
        <Dimension4>string</Dimension4>
        <Dimension5>string</Dimension5>
        <Dimension6>string</Dimension6>
        <Dimension7>string</Dimension7>
        <Dimension8>string</Dimension8>
        <Status>string</Status>
        <PurchaseInvoiceLinesId>string</PurchaseInvoiceLinesId>
      </PurchaseInvoiceCodingLine>
    </PurchaseInvoiceCodingLines>
    <PurchaseInvoiceIntrastatLines>
      <PurchaseInvoiceIntrastatLine>
        <LineId>string</LineId>
        <PartnerCountry>string</PartnerCountry>
        <TransactionCode>1</TransactionCode>
        <Region>1</Region>
        <CommodityCode>3.4</CommodityCode>
        <NetMass>3.4</NetMass>
        <Units>3.4</Units>
        <Value>3.4</Value>
        <PC>1</PC>
        <DeliveryTerms>string</DeliveryTerms>
      </PurchaseInvoiceIntrastatLine>
    </PurchaseInvoiceIntrastatLines>
    <PurchaseInvoicePaymentScheduleLines>
      <PurchaseInvoicePaymentScheduleLine>
        <LineId>string</LineId>
        <LineAmount>string</LineAmount>
        <DueDate>string</DueDate>
        <HoldPayment>false</HoldPayment>
        <BankAccount>
          <BankNumber>string</BankNumber>
          <AccountNumber>string</AccountNumber>
          <IBAN>string</IBAN>
          <BIC>string</BIC>
          <Currency>string</Currency>
        </BankAccount>
      </PurchaseInvoicePaymentScheduleLine>
    </PurchaseInvoicePaymentScheduleLines>
    <MatchingExceptions>
      <MatchingException>
        <ExceptionCode>string</ExceptionCode>
        <ExceptionDescription>string</ExceptionDescription>
        <LineId>1000</LineId>
      </MatchingException>
    </MatchingExceptions>
    <MatchedPurchaseOrders>
      <PurchaseOrder>
        <PurchaseOrderHeader>
          <DocumentReference>string</DocumentReference>
          <ExtraReference>string</ExtraReference>
          <DocumentDate>string</DocumentDate>
          <DocumentType>string</DocumentType>
          <DocumentSubType>string</DocumentSubType>
          <Currency>string</Currency>
          <TotalNetAmount>string</TotalNetAmount>
          <TotalVatAmount>string</TotalVatAmount>
          <TotalGrossAmount>string</TotalGrossAmount>
          <TotalDiscountAmount>string</TotalDiscountAmount>
          <OrderReference>string</OrderReference>
          <HeaderText1>string</HeaderText1>
          <HeaderText2>string</HeaderText2>
          <StartDate>string</StartDate>
          <EndDate>string</EndDate>
          <DocumentStatus>string</DocumentStatus>
          <RequesterId>string</RequesterId>
        </PurchaseOrderHeader>
        <PurchaseOrderLines>
          <PurchaseOrderLine>
            <Id>1000</Id>
            <LineId>string</LineId>
            <ExtraReference>string</ExtraReference>
            <ArticleNumberSupplier>string</ArticleNumberSupplier>
            <ArticleNumberBuyer>string</ArticleNumberBuyer>
            <ArticleDescription>string</ArticleDescription>
            <StandardArticleNumber>string</StandardArticleNumber>
            <Quantity>string</Quantity>
            <UnitCode>string</UnitCode>
            <Price>string</Price>
            <DiscountAmount>string</DiscountAmount>
            <DiscountRate>string</DiscountRate>
            <LineAmount>string</LineAmount>
            <Status>string</Status>
            <GlAccount>string</GlAccount>
            <CostCenter>string</CostCenter>
            <VatCode>string</VatCode>
            <Dimension1>string</Dimension1>
            <Dimension2>string</Dimension2>
            <Dimension3>string</Dimension3>
            <Dimension4>string</Dimension4>
            <Dimension5>string</Dimension5>
            <Dimension6>string</Dimension6>
            <Dimension7>string</Dimension7>
            <Dimension8>string</Dimension8>
            <GrossUnitPrice>string</GrossUnitPrice>
            <StartDate>2019-12-31T22:22:22</StartDate>
            <EndDate>2019-12-31T22:22:22</EndDate>
            <InvoicedQuantity>string</InvoicedQuantity>
            <InvoicedAmount>string</InvoicedAmount>
          </PurchaseOrderLine>
        </PurchaseOrderLines>
      </PurchaseOrder>
    </MatchedPurchaseOrders>
    <MatchedGoodsReceipts>
      <GoodsReceipt>
        <GoodsReceiptHeader>
          <DocumentReference>string</DocumentReference>
          <ExtraReference>string</ExtraReference>
          <DocumentDate>string</DocumentDate>
          <DocumentType>string</DocumentType>
          <DocumentSubType>string</DocumentSubType>
          <OrderReference>string</OrderReference>
          <HeaderText1>string</HeaderText1>
          <HeaderText2>string</HeaderText2>
          <DocumentStatus>string</DocumentStatus>
        </GoodsReceiptHeader>
        <GoodsReceiptLines>
          <GoodsReceiptLine>
            <Id>1000</Id>
            <LineId>string</LineId>
            <OrderReference>string</OrderReference>
            <OrderLineId>string</OrderLineId>
            <ExtraReference>string</ExtraReference>
            <ArticleNumberSupplier>string</ArticleNumberSupplier>
            <ArticleNumberBuyer>string</ArticleNumberBuyer>
            <ArticleDescription>string</ArticleDescription>
            <StandardArticleNumber>string</StandardArticleNumber>
            <Quantity>string</Quantity>
            <UnitCode>string</UnitCode>
            <GrossUnitPrice>string</GrossUnitPrice>
            <DiscountAmount>string</DiscountAmount>
            <DiscountRate>string</DiscountRate>
            <Price>string</Price>
            <LineAmount>string</LineAmount>
            <Status>string</Status>
            <InvoicedQuantity>string</InvoicedQuantity>
            <InvoicedAmount>string</InvoicedAmount>
            <AcceptedQuantity>string</AcceptedQuantity>
            <AcceptedAmount>string</AcceptedAmount>
          </GoodsReceiptLine>
        </GoodsReceiptLines>
      </GoodsReceipt>
    </MatchedGoodsReceipts>
  </PurchaseInvoice>
  <Attachments>
    <Attachment>
      <Filename>string</Filename>
      <MimeType>string</MimeType>
      <Type>string</Type>
      <ArchiveLink>string</ArchiveLink>
    </Attachment>
  </Attachments>
</RouttyExportDocument>

Fields

Metadata

Field

Description

Datatype

Possible value

DocumentSetId

A unique identification of the document in Routty (see also: feedback)

integer

1

DocumentRawId

Identifier of the document linked to the accounting channel, used for setting up technical integrations

integer

1

Guid

Globally unique identifier assigned to the document (see also: feedback)

GUID

19a63881-b860-472b-b0c9-7f734cbd9116

DocumentType

Document type identifier, based on the UNCL1001 standard list

integer

380

PurchaseInvoice
Buyer

Field

Description

Datatype

Possible value

Name

(Business) name of the buyer

string

ACME

Number

Buyer identifier

string

7300010000001

Address

Main address line of the buyer

string

Main Street 1

PostalCode

Post/ZIP code

string

W1G 8LZ

City

Common name of the city, town or village where the buyer site is located

string

London

CountryCode

Country code

string

GB

SiteCode

Identifier for a site, establishment, or outlet of the buyer

string

Alphabetic values and/or numerical characters

CorporateGroupID

Corporate group identifier

string

Alphabetic values and/or numerical characters

RegistrationNumbers

Additional buyer identifiers

RegistrationNumber[0..n]

See RegistrationNumber

Supplier

Field

Description

Datatype

Possible value

Name

(Business) name of the supplier

string

ACME

Number

Supplier identifier

string

7300010000001

Address

Main address line of the supplier

string

Main Street 1

PostalCode

Post/ZIP code

string

W1G 8LZ

City

Common name of the city, town or village where the supplier site is located

string

London

CountryCode

Country code

string

GB

SiteCode

Identifier for a site, establishment, or outlet of the supplier

string

Alphabetic values and/or numerical characters

CorporateGroupID

Corporate group identifier

string

Alphabetic values and/or numerical characters

RegistrationNumbers

Additional supplier identifiers

RegistrationNumber[0..n]

See RegistrationNumber

BankAccounts

Payment accounts

BankAccount[0..n]

See BankAccount

Header

Field

Description

Datatype

Possible value

Id

Internal identifier in Routty

integer

1

DocumentReference

Reference of the invoice

string

33445566

DocumentDate

Date on which the invoice was issued

date

2018-06-01

OrderReference

Reference of the order

string

PO123

ReceiptReference

Reference of the (goods) receipt

string

0-123

ExtraReference

Additional (document) reference

string

1232424

DueDate

Date when the payment is due

date

2018-06-01

PaymentReference

Reference number specific to the invoice which will be used to identify the payment request

string

432948234234234

PaymentTerms

Textual description of the payment terms that apply to the amount due for payment

string

Net within 30 days

PaymentTermsCode

Identifier for the payment terms that apply to the amount due for payment

string

30E

DocumentSubType

Document subtype

string

GE for general expenses, PO for purchase orders

Currency

Currency for the invoice

string

EUR

CurrencyRate

Currency exchange rate, w.r.t. domain currency

decimal

1.00000000

TotalNetAmount

Total amount of the invoice without VAT, i.e. inclusive of line level allowances and charges as well as other relevant taxes

decimal

123.45

TotalVatAmount

Total VAT amount for the invoice

decimal

123.45

TotalVatRate

Subject to change. See VatAmount[1-5].

string

25

TotalGrossAmount

Total amount of the invoice with VAT

decimal

123.45

TotalDiscountAmount

Total (cash) discount amount of the invoice

decimal

123.45

PaymentIBAN

Unique identifier of the financial payment account to which payment should be made (such as IBAN)

string

NO99991122222

ReceivedBuyerNumber

Original buyer party identifier

string

7300010000001

ReceivedBuyerName

Original name of the buyer

string

ACME

ReceivedBuyerRegistrationNumber

Original registered VAT identifier of the buyer

string

Alphabetic values and/or Numerical characters

ReceivedSupplierNumber

Original seller party identifier

string

7300010000001

ReceivedSupplierName

Original name of the seller

string

ACME

ReceivedSupplierRegistrationNumber

Original registered VAT identifier of the seller

string

Alphabetic values and/or Numerical characters

NetAmount[1-5]

Sum of all taxable amounts subject to a specific VAT category

decimal

123.45

VatAmount[1-5]

Total VAT amount for a specific VAT category

decimal

123.45

VatRate[1-5]

VAT rate that applies for the relevant VAT category, as a percentage. 25% is 25, not 0.25.

string

25

HeaderCost[1-5]

Amount of a document level charge, without VAT

decimal

123.45

HeaderDiscount[1-5]

Amount of a document level discount charge, without VAT

decimal

123.45

HeaderText[1-2]

Header free form text field

string

Alphabetic values and/or numerical characters

ReceptionDate

Date of receipt of the invoice

date

2018-06-01

BookingNumber

Accounting journal entry number

string

1

BookingDate

Accounting journal entry date

date

2018-06-01

BookingYear

Reserved for fiscal year

string

2018

BookingMonth

Reserved for accounting period

string

06

DocumentStatus

Status of the invoice (paid, disputed…)

string

Alphabetic values and/or numerical characters

Journal

Accounting journal identifier

string

Alphabetic values and/or numerical characters

Dimension[1-8]

To be specified

string

Alphabetic values and/or Numerical characters

ExternalReference[1-8]

Supporting document reference

string

AB23456

RequesterId

Optional person identifier

string

Alphabetic values and/or numerical characters

VatSystem

Accounting VAT system/regime, i.e. a coded statement of the reason for why the taxable amount is exempted from VAT

string

Alphabetic values and/or numerical characters

Lines

Field

Description

Datatype

Possible value

Id

Internal identifier in Routty, used to link invoice lines to matched order and receipt lines

integer

1

LineId

Unique identifier for the individual line within the invoice

string

1

ExtraReference

Additional (document) reference

string

Alphabetic values and/or numerical characters

ArticleNumberSupplier

Identifier, assigned by the seller, for the item

string

Alphabetic values and/or numerical characters

ArticleNumberBuyer

Identifier, assigned by the buyer, for the item

string

Alphabetic values and/or numerical characters

ArticleDescription

Description of the item

string

Alphabetic values and/or Numerical characters

StandardArticleNumber

Item identifier based on a standard system

string

Alphabetic values and/or numerical characters

Quantity

Quantity of items (goods or services) that is charged

decimal

123.456789

UnitCode

Unit of measure that applies to the invoiced quantity

string

Alphabetic values and/or numerical characters

Price

Net item price, excluding VAT

decimal

123.456789

DiscountAmount

Total discount amount of the line item

decimal

123.456789

DiscountRate

Discount percentage

decimal

20.0000

LineAmount

Total amount of the invoice line without VAT, i.e. inclusive of line level allowances and charges as well as other relevant taxes

decimal

123.45

VatAmount

Total VAT amount for the invoice line

decimal

123.45

VatRate

VAT rate that applies for the invoice line, as a percentage. 25% is 25, not 0.25.

decimal

25.0000

GrossAmount

Total amount of the invoice line with VAT

decimal

123.45

Status

Reserved (internal) field to indicate the line item status

string

OrderReference

Reference of the order

string

PO123

OrderLineId

Referenced purchase order line reference, issued by the buyer

string

3

ReceiptReference

Reference of the (goods) receipt

string

0-123

ReceiptLineId

Referenced (goods) receipt line reference, issued by the buyer

string

3

GrossUnitPrice

The gross price of the item before subtracting discounts, e.g. list price

decimal

123.456789

StartDate

Invoice line start date

date

2018-06-01

EndDate

Invoice line end date

date

2018-06-01

Dimension[1-8]

To be specified

string

Alphabetic values and/or Numerical characters

PurchaseOrderLinesId

Internal identifier of the purchase order line, paired to this invoice line

integer

1

GoodsReceiptLinesId

Internal identifier of the (goods) receipt line, paired to this invoice line

integer

1

Coding lines

Field

Description

Datatype

Possible value

LineId

Optional identifier for the individual line within the journal

string

1

GlAccount

General Ledger account applied to the coding line

string

Numerical characters

CostCenter

Cost center applied to the coding line

string

Alphabetic values and/or Numerical characters

DebitAmount

Debit amount

decimal

123.45

CreditAmount

Credit amount

decimal

123.45

VatAmount

VAT amount

decimal

123.45

VatRate

VAT rate that applies for the coding line, as a percentage. 25% is 25, not 0.25.

string

25

VatCode

Accounting VAT category identifier that applies for the coding line

string

Alphabetic values and/or Numerical characters

VatSystem

Accounting VAT system/regime that applies for the coding line, i.e. a coded statement of the reason for why the taxable amount is exempted from VAT

string

Alphabetic values and/or Numerical characters

Dimension[1-8]

To be specified

string

Alphabetic values and/or Numerical characters

Status

Reserved (internal) field to indicate the line item status

string

PurchaseInvoiceLinesId

Internal identifier of the invoice line, linked to this coding line

integer

1

Intrastat lines

Field

Description

Datatype

Possible value

LineId

Unique identifier for the individual line within the declaration

string

1

PartnerCountry

(EU) partner country code

string

GB

TransactionCode

Type of transaction

integer

[1-9]

Region

Region of source or destination, depending on context

integer

1

CommodityCode

Goods commodity code

integer

99450000

NetMass

Net mass of goods (in kg)

decimal

123.4567

Units

Optional additional units (in sqm, cm, l… depending on commodity code)

decimal

123.4567

Value

Goods value (in EUR)

decimal

123.4567

PC

Means of transport code

integer

[1-9]

DeliveryTerms

Applicable delivery terms

string

EXW

Payment schedule lines

Field

Description

Datatype

Possible value

LineId

Unique identifier for the individual line

string

1

LineAmount

The monetary amount for this payment

decimal

123.4567

DueDate

Date when the payment is due

date

2018-06-01

HoldPayment

True if a hold should be placed on the payment, False otherwise.

boolean

True or False

BankAccount

Financial payment account to which payment should be made

BankAccount

See BankAccount

Matching exceptions

Field

Description

Datatype

Possible value

ExceptionCode

Coded identification of the exception

string

XYZ

ExceptionDescription

Description of the exception

string

Alphabetic values and/or Numerical characters

LineId

Internal identifier of the invoice line, linked to this exception

integer

1

Matched purchase orders

Field

Description

Datatype

Possible value

PurchaseOrderHeader

The header information of a purchase order matched to this invoice

PurchaseOrderHeader

See PurchaseOrderHeader

PurchaseOrderLines

The purchase order lines matched to this invoice

PurchaseOrderLine[0..n]

See PurchaseOrderLine

Purchase order header

See Purchase order header.

Purchase order line

Field

Description

Datatype

Possible value

Id

Internal identifier in Routty, used to link invoice lines to matched order and receipt lines

integer

1

See Purchase order lines.

Matched goods receipts

Field

Description

Datatype

Possible value

GoodsReceiptHeader

The header information of a (goods) receipt matched to this invoice

GoodsReceiptHeader

See GoodsReceiptHeader

GoodsReceiptLine

The (goods) receipt lines matched to this invoice

GoodsReceiptLine[0..n]

See GoodsReceiptLine

Goods receipt header

See Goods receipt header.

Goods receipt line

Field

Description

Datatype

Possible value

Id

Internal identifier in Routty, used to link invoice lines to matched order and receipt lines

integer

1

See Goods receipt lines.

Attachments

Field

Description

Datatype

Possible value

Filename

Filename of the attachment

string

MyDocument.pdf

MimeType

The MIME type of the attachment

string

application/pdf

Type

Document type

string

Attachment

ArchiveLink

The link to the attachment in the Routty Archive. This can either be the file’s unique archive identifier, or Routty’s base URL suffixed by this hash.

string

FsK+pzW9e08r223IbFvK9g==

Common field types
Registration number

See Parties.

Bank account

See Parties.

Feedback

Accounting Feedback

Description

Feedback from the ERP system before or after posting an invoice can be relayed via an accounting feedback document. The feedback document can be used to update the status of an invoice that is posted in an external ERP system.

To be able to link back to the document in Routty, either the document GUID or Set Identifier should be provided. There are 3 options to do so:

  • Feedback the GUID as (a prefix of) the filename. Routty will (by default) name the accounting document as the GUID. The ERP system could use the same naming convention to link back to the document, e.g. “EEBF3406-095B-4717-B659-BD2601542135.xml”, “EEBF3406-095B-4717-B659-BD2601542135_20191016othertext.xml”. Note that everything following the underscore (“_”) in the last example is ignored by Routty.

  • Provide the GUID in the DocumentGuid tag in the feedback document

  • Provide the Set Identifier in the DocumentSetId tag

Example

XML 
<?xml version="1.0" encoding="utf-8"?>
<RouttyFeedbackDocuments>
  <RouttyFeedbackDocument>
    <Status>string</Status>
    <DocumentGuid>string</DocumentGuid>
    <DocumentSetId>1000</DocumentSetId>
    <ProcessDate>string</ProcessDate>
    <Messages>
      <Message>string</Message>
    </Messages>
    <FeedbackAccounting>
      <BookingNumber>string</BookingNumber>
      <BookingDate>2019-12-31T22:22:22</BookingDate>
      <BookingYear>string</BookingYear>
      <BookingMonth>string</BookingMonth>
      <Journal>string</Journal>
      <DocumentSubType>string</DocumentSubType>
      <TotalGrossAmount>6050.12</TotalGrossAmount>
      <TotalNetAmount>5000.10</TotalNetAmount>
      <PaymentTerms>string</PaymentTerms>
      <OrderReference>string</OrderReference>
      <DocumentStatus>string</DocumentStatus>
    </FeedbackAccounting>
    <Dimensions>
      <Dimension1>string</Dimension1>
      <Dimension2>string</Dimension2>
      <Dimension3>string</Dimension3>
      <Dimension4>string</Dimension4>
      <Dimension5>string</Dimension5>
      <Dimension6>string</Dimension6>
      <Dimension7>string</Dimension7>
      <Dimension8>string</Dimension8>
    </Dimensions>
  </RouttyFeedbackDocument>
</RouttyFeedbackDocuments>

Fields

Field

Description

Datatype

Required

Possible value

Status

Status of posting in ERP system

string

Yes

Success, Error, Hold or Rejected

DocumentGuid

Globally unique identifier assigned to the document

GUID

Yes
(One of DocumentGuid or DocumentSetId required)

19a63881-b860-472b-b0c9-7f734cbd9116

DocumentSetId

A unique identification of the document in Routty

integer

Yes
(One of DocumentGuid or DocumentSetId required)

1

Message[0..n]

Human-readable status message

string

No

Alphabetic values and/or numerical characters

BookingDate

Accounting journal entry date

date

No

2018-06-01

BookingNumber

Accounting journal entry number

string(64)

No

1

BookingYear

Fiscal year

string(64)

No

2018

BookingMonth

Accounting period

string(64)

No

06

Journal

Accounting journal identifier

string(50)

No

Alphabetic values and/or numerical characters

DocumentSubType

Document subtype

string(64)

No

Alphabetic values and/or numerical characters

TotalGrossAmount

Total amount of the invoice with VAT

decimal(18, 2)

No

123.45

TotalNetAmount

Total amount of the invoice without VAT, i.e. inclusive of line level allowances and charges as well as other relevant taxes

decimal(18, 2)

No

123.45

PaymentTerms

Textual description of the payment terms that apply to the amount due for payment

string(256)

No

Net within 30 days

OrderReference

Reference of the order

string(128)

No

PO123

DocumentStatus

Status of the invoice (paid, disputed…)

string(64)

No

Alphabetic values and/or numerical characters

Dimension[1-8]

To be specified

string(128)

No

Alphabetic values and/or numerical characters

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close