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:
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
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