Mapping XRechnung in DocBits

In DocBits, XRechnung invoices are mapped to specific fields using a predefined configuration that ensures the data can be seamlessly exported to various formats, including integration with other systems like Infor. The export configuration leverages templates and rules to ensure that each element of the XRechnung is captured and mapped appropriately.

Key Components

  1.  Document Types: XRechnung documents are mapped to specific Document Types in DocBits. Each document type (e.g., invoice, credit note, debit note) has its own structure and fields.

  2.  Field Mapping: Fields in the XRechnung are mapped to corresponding fields in DocBits using a export configuration file. This file defines how each XRechnung field is handled and where it should be exported.

  3.  Rules for Export: Certain rules are defined to handle specific cases where values may differ, including tolerance checks, approval requirements, or line-level charges. These rules ensure that XRechnung data is processed and exported correctly, based on specific business logic

CII-XRechnung Mapping:

DocBits Field XRechnung Description

supplier_id

<ram:SellerTradeParty><ram:ID>

Supplier's identification number.

supplier_name

<ram:SellerTradeParty><ram:Name>

Supplier's name.

supplier_address

<ram:SellerTradeParty><ram:PostalTradeAddress><ram:LineOne>

Supplier's address line one.

supplier_tax_id

<ram:SellerTradeParty><ram:SpecifiedTaxRegistration><ram:ID>

Supplier's tax identification number.

company_id

<ram:InvoiceeTradeParty><ram:ID>

Company's identification number.

company_name

<ram:InvoiceeTradeParty><ram:Name>

Company's name.

company_street

<ram:InvoiceeTradeParty><ram:PostalTradeAddress><ram:LineOne>

Company's address line one.

company_plz

<ram:InvoiceeTradeParty><ram:PostalTradeAddress><ram:PostcodeCode>

Company's postal code.

company_vat

<ram:InvoiceeTradeParty><ram:SpecifiedTaxRegistration><ram:ID>

Company's VAT number.

invoice_id

<rsm:ExchangedDocument><ram:ID>

Invoice identification number.

invoice_date

<ram:IssueDateTime><ram:DateTimeString>

Date when the invoice was issued.

delivery_date

<ram:ApplicableHeaderTradeDelivery><ram:ActualDeliverySupplyChainEvent><ram:OccurrenceDateTime><ram:DateTimeString>

Date of actual delivery.

supplier_iban

<ram:PayeePartyCreditorFinancialAccount><ram:IBANID>

Supplier's IBAN number.

payment_terms

<ram:SpecifiedTradePaymentTerms><ram:Description>

Payment terms description.

purchase_order

<ram:BuyerOrderReferencedDocument><ram:IssuerAssignedID>

Reference to the purchase order.

currency

<ram:InvoiceCurrencyCode>

Currency used in the invoice.

net_amount

<ram:ApplicableTradeTax><ram:BasisAmount>

Net amount before tax.

tax_amount

<ram:ApplicableTradeTax><ram:CalculatedAmount>

Amount of tax.

tax_rate

<ram:ApplicableTradeTax><ram:RateApplicablePercent>

VAT rate applied.

net_amount_2

<ram:ApplicableTradeTax><ram:BasisAmount>

Net amount before tax.

tax_amount_2

<ram:ApplicableTradeTax><ram:CalculatedAmount>

Amount of tax.

tax_rate_2

<ram:ApplicableTradeTax><ram:RateApplicablePercent>

VAT rate applied.

total_net_amount

<ram:SpecifiedTradeSettlementHeaderMonetarySummation><ram:TaxBasisTotalAmount>

Total net amount before tax.

total_tax_amount

<ram:SpecifiedTradeSettlementHeaderMonetarySummation><ram:TaxTotalAmount>

Total tax amount.

total_amount

<ram:SpecifiedTradeSettlementHeaderMonetarySummation><ram:GrandTotalAmount>

Total invoice amount.

POSITION

<ram:AssociatedDocumentLineDocument><ram:LineID>

Line position number in the invoice.

PURCHASE_ORDER

<ram:BuyerOrderReferencedDocument><ram:IssuerAssignedID>

Purchase order reference.

ITEM_NUMBER

<ram:SpecifiedTradeProduct><ram:SellerAssignedID>

Item number assigned by the seller.

SUPPLIER_ITEM_NUMBER

<ram:SpecifiedTradeProduct><ram:GlobalID>

Global item number assigned by the supplier.

DESCRIPTION

<ram:SpecifiedTradeProduct><ram:Name>

Description of the item.

QUANTITY

<ram:SpecifiedLineTradeDelivery><ram:BilledQuantity>

Quantity of items billed.

UNIT

<ram:BilledQuantity>unitCode

Unit of measure for the quantity.

UNIT_PRICE

<ram:SpecifiedLineTradeAgreement><ram:NetPriceProductTradePrice><ram:ChargeAmount>

Unit price of the item.

VAT

<ram:SpecifiedLineTradeSettlement><ram:ApplicableTradeTax><ram:RateApplicablePercent>

VAT rate applied to the line item.

TOTAL_AMOUNT

<ram:SpecifiedLineTradeSettlement><ram:SpecifiedTradeSettlementLineMonetarySummation><ram:LineTotalAmount>

Total amount for the line item.

order_date

not mapped yet

Date of the order.

invoice_sub_type

not mapped yet

Sub-type of the invoice.

invoice_type

not mapped yet

Type of the invoice.

due_date

not mapped yet

Due date for payment.

negative_amount

not mapped yet

Amount with a negative value.

charges

not mapped yet

Additional charges.

accounting_date

not mapped yet

Date for accounting purposes.

supplier_country_code

not mapped yet

Country code of the supplier.

tax_country_1

not mapped yet

Country code for tax purposes.

correlation_id

not mapped yet

Identifier for correlation.

sqr_field_esr_reference

not mapped yet

Reference for SQR field ESR.

additional_amount

not mapped yet

Additional amount in the invoice.

authorised_user

not mapped yet

User authorized for the transaction.

payment_method

not mapped yet

Method of payment used.

bank_id

not mapped yet

Identification of the bank.

geo_code

not mapped yet

Geographical code.

discount_term

not mapped yet

Terms for any discount applied.

total_net_amount_us

not mapped yet

Total net amount in USD.

purchase_order_supplier_id

not mapped yet

Supplier's ID in the purchase order.

purchase_order_supplier_name

not mapped yet

Supplier's name in the purchase order.

purchase_order_warehouse_id

not mapped yet

Warehouse ID for the purchase order.

purchase_order_location_id

not mapped yet

Location ID for the purchase order.

ship_to_party_id

not mapped yet

ID of the party receiving the shipment.

ship_to_party_name

not mapped yet

Name of the party receiving the shipment.

buyer_id

<ram:BuyerTradeParty><ram:ID>

Buyer's identification number.

buyer_name

<ram:BuyerTradeParty><ram:Name>

Buyer's name.

tax_code

not mapped yet

Code for tax purposes.

tax_code_2

not mapped yet

Secondary tax code.

net_amount_3

not mapped yet

Net amount with a third tax rate.

tax_amount_3

not mapped yet

Tax amount with a third tax rate.

tax_rate_3

not mapped yet

Third tax rate applied.

tax_code_3

not mapped yet

Tertiary tax code.

additional_amount_2

not mapped yet

Additional amount 2.

additional_amount_3

not mapped yet

Additional amount 3.

negative_amount_2

not mapped yet

Second negative amount.

negative_amount_3

not mapped yet

Third negative amount.

shipping_charges

not mapped yet

Charges for shipping.

sales_tax

not mapped yet

Sales tax amount.

sub_tax

not mapped yet

Sub-tax amount.

wi_tax

not mapped yet

Withholding tax amount.

county_tax

not mapped yet

County tax amount.

city_tax

not mapped yet

City tax amount.

custom_field_1

not mapped yet

Custom field 1.

custom_field_2

not mapped yet

Custom field 2.

custom_field_3

not mapped yet

Custom field 3.

custom_field_4

not mapped yet

Custom field 4.

custom_field_5

not mapped yet

Custom field 5.

custom_field_6

not mapped yet

Custom field 6.

custom_field_7

not mapped yet

Custom field 7.

custom_field_8

not mapped yet

Custom field 8.

custom_field_9

not mapped yet

Custom field 9.

custom_field_10

not mapped yet

Custom field 10.

firma

not mapped yet

Company name.

name

not mapped yet

Name of the company or individual.

strasse

not mapped yet

Street address.

postleitzahl

not mapped yet

Postal code.

id_nummer

not mapped yet

Identification number.

UBL-XRechnung Mapping

DocBits FieldXRechnung Description

supplier_id

not mapped yet

Supplier's identification number.

supplier_name

not mapped yet

Supplier's name.

supplier_address

not mapped yet

Supplier's address line one.

supplier_tax_id

not mapped yet

Supplier's tax identification number.

company_id

not mapped yet

Company's identification number.

company_name

not mapped yet

Company's name.

company_street

not mapped yet

Company's address line one.

company_plz

not mapped yet

Company's postal code.

company_vat

not mapped yet

Company's VAT number.

invoice_id

not mapped yet

Invoice identification number.

invoice_date

not mapped yet

Date when the invoice was issued.

delivery_date

not mapped yet

Date of actual delivery.

supplier_iban

not mapped yet

Supplier's IBAN number.

payment_terms

not mapped yet

Payment terms description.

purchase_order

not mapped yet

Reference to the purchase order.

currency

not mapped yet

Currency used in the invoice.

net_amount

not mapped yet

Net amount before tax.

tax_amount

not mapped yet

Amount of tax.

tax_rate

not mapped yet

VAT rate applied.

net_amount_2

not mapped yet

Net amount before tax.

tax_amount_2

not mapped yet

Amount of tax.

tax_rate_2

not mapped yet

VAT rate applied.

total_net_amount

not mapped yet

Total net amount before tax.

total_tax_amount

not mapped yet

Total tax amount.

total_amount

not mapped yet

Total invoice amount.

POSITION

not mapped yet

Line position number in the invoice.

PURCHASE_ORDER

not mapped yet

Purchase order reference.

ITEM_NUMBER

not mapped yet

Item number assigned by the seller.

SUPPLIER_ITEM_NUMBER

not mapped yet

Global item number assigned by the supplier.

DESCRIPTION

not mapped yet

Description of the item.

QUANTITY

not mapped yet

Quantity of items billed.

UNIT

not mapped yet

Unit of measure for the quantity.

UNIT_PRICE

not mapped yet

Unit price of the item.

VAT

not mapped yet

VAT rate applied to the line item.

TOTAL_AMOUNT

not mapped yet

Total amount for the line item.

order_date

not mapped yet

Date of the order.

invoice_sub_type

not mapped yet

Sub-type of the invoice.

invoice_type

not mapped yet

Type of the invoice.

due_date

not mapped yet

Due date for payment.

negative_amount

not mapped yet

Amount with a negative value.

charges

not mapped yet

Additional charges.

accounting_date

not mapped yet

Date for accounting purposes.

supplier_country_code

not mapped yet

Country code of the supplier.

tax_country_1

not mapped yet

Country code for tax purposes.

correlation_id

not mapped yet

Identifier for correlation.

sqr_field_esr_reference

not mapped yet

Reference for SQR field ESR.

additional_amount

not mapped yet

Additional amount in the invoice.

authorised_user

not mapped yet

User authorized for the transaction.

payment_method

not mapped yet

Method of payment used.

bank_id

not mapped yet

Identification of the bank.

geo_code

not mapped yet

Geographical code.

discount_term

not mapped yet

Terms for any discount applied.

total_net_amount_us

not mapped yet

Total net amount in USD.

purchase_order_supplier_id

not mapped yet

Supplier's ID in the purchase order.

purchase_order_supplier_name

not mapped yet

Supplier's name in the purchase order.

purchase_order_warehouse_id

not mapped yet

Warehouse ID for the purchase order.

purchase_order_location_id

not mapped yet

Location ID for the purchase order.

ship_to_party_id

not mapped yet

ID of the party receiving the shipment.

ship_to_party_name

not mapped yet

Name of the party receiving the shipment.

buyer_id

not mapped yet

Buyer's identification number.

buyer_name

not mapped yet

Buyer's name.

tax_code

not mapped yet

Code for tax purposes.

tax_code_2

not mapped yet

Secondary tax code.

net_amount_3

not mapped yet

Net amount with a third tax rate.

tax_amount_3

not mapped yet

Tax amount with a third tax rate.

tax_rate_3

not mapped yet

Third tax rate applied.

tax_code_3

not mapped yet

Tertiary tax code.

additional_amount_2

not mapped yet

Additional amount 2.

additional_amount_3

not mapped yet

Additional amount 3.

negative_amount_2

not mapped yet

Second negative amount.

negative_amount_3

not mapped yet

Third negative amount.

shipping_charges

not mapped yet

Charges for shipping.

sales_tax

not mapped yet

Sales tax amount.

sub_tax

not mapped yet

Sub-tax amount.

wi_tax

not mapped yet

Withholding tax amount.

county_tax

not mapped yet

County tax amount.

city_tax

not mapped yet

City tax amount.

custom_field_1

not mapped yet

Custom field 1.

custom_field_2

not mapped yet

Custom field 2.

custom_field_3

not mapped yet

Custom field 3.

custom_field_4

not mapped yet

Custom field 4.

custom_field_5

not mapped yet

Custom field 5.

custom_field_6

not mapped yet

Custom field 6.

custom_field_7

not mapped yet

Custom field 7.

custom_field_8

not mapped yet

Custom field 8.

custom_field_9

not mapped yet

Custom field 9.

custom_field_10

not mapped yet

Custom field 10.

firma

not mapped yet

Company name.

name

not mapped yet

Name of the company or individual.

strasse

not mapped yet

Street address.

postleitzahl

not mapped yet

Postal code.

id_nummer

not mapped yet

Identification number.

Last updated