​
Extracted Fields

Field NameDescription
Invoice NumberThe number of the invoice.
Invoice DateThe date when the invoice was issued.
TotalThe total cost of goods or services.
CurrencyThe currency of the invoice.
VendorInformation about the vendor.
  NameThe vendor’s name.
  Tax IDThe official company ID of the vendor.
  AddressThe vendor’s address. The address will be extracted into this field, if no Vendors data catalog is used or if the vendor has not been found in a data catalog.
  StateThe vendor’s state.
  CityThe vendor’s city.
  StreetThe vendor’s street address.
  Postal CodeThe vendor’s postal code.
  CountryThe vendor’s country.
  IDThe vendor’s unique identifier in the catalog used by the customer. This field can only be obtained from the Vendors data catalog.
Bank InformationInformation about the vendor’s bank account.
  Account NumberThe vendor’s account number.
  Account TypeThe vendor’s account type.
  Bank NameThe name of the bank used by the vendor.
  Branch NameThe name of the bank branch used by the vendor.
Delivery DateThe date the goods were delivered or services performed.
Due DateThe date by which the invoice should be paid.
TaxesInformation about taxes.
  Total Net AmountThe total cost of goods and services without tax.
  Total TaxesThe total tax amount.
  Non Taxable AmountThe amount on which no tax is payable.
  Tax Rates (repeating group)For each tax group:
    Net AmountCost of goods or services without tax.
    Tax AmountTax charged.
    Tax RateTax rate.
Invoice TypeInformation about the type of invoice.
  InvoiceSpecifies the Invoice type of the invoice.
  Credit NoteSpecifies the Credit Note type of the invoice.
Purchase OrderInformation about the purchase order.
  Order NumberThe number of the purchase order.
  Order CheckedSpecifies whether the order number is verified. The value of the field can be True or False.
  TotalThe cost of the goods or services listed in the purchase order.
Note: This field can only be obtained from the PurchaseOrders data catalog.
Line Items (repeating group)Information about individual line items.
  Order NumberThe number of the purchase order.
  Is ValidSpecifies whether the order number in the Line Item group matches any checked order number in the Purchase Order group. The value of the field can be True or False.
  Order DateThe date when the purchase order was created.
  PositionThe number of the line item in the list.
  Article Number VendorThe article number or code in the vendors’s database.
  Article Number BUThe article number or code in the business unit’s database.
  DescriptionA description of the line item.
  QuantityThe number of units purchased.
  Unit of MeasurementThe unit of measurement used for the goods.
  Unit PriceThe price of one item of goods.
  Discount PercentageThe discount percentage on the initial line item price.
  DiscountDiscount applicable to the line item.
  Net PriceThe price of the line item without tax.
  Tax RateThe tax rate for the line item.
  Tax AmountThe amount of tax payable on the line item.
  Tax CodeThe code of the tax.
  Total PriceThe price of the line item including tax.
  CurrencyThe currency of the line item.
  Order Item IDThe unique line item identifier.
Note: This field can only be obtained from the PurchaseOrderItems data catalog.

​
Validation Rules

RuleDescription
Sum of Line Items amount should be equal to TotalVerifies that the sum of all line item amounts and Additional Costs is equal to the total invoiced amount.
Separate currency from amount in money fieldsSplits the amount and the currency in the Total and Additional Costs fields and copies the currency into the Currency field if it is empty.
Separate currency from amount in Line ItemsSplits the amount and the currency in Line Items fields, and copies the currency into the Currency fields if they are empty.
Check item amountMultiplies the number of units in the line item by the price of one unit and checks that the result is equal to the total price of the line item.
Complete currency in amounts fieldsIf the Currency field next to the Total field is empty, the rule will populate that field with the currency indicated in the Currency field in the Line Items group. If multiple currencies are specified in the Line Items group, the Currency field will be left empty. Likewise, the rule will populate the Currency field in the Line Items group with the currency from the main Currency field. This rule also applies to the Currency field in the Additional Costs group. Only ISO-standard alphabetic currency values are copied. If the currency is specified using a symbol (e.g., "","US", "US", “CA","AU", "AU”, “NZ$”, or ”£”), the value is still copied, but is then formatted to be the standard alphabetic value for that currency type.
Check currency in amounts fieldsChecks that the currency in the Currency field matches the currency code in the invoice and in the line items. Offers a list of suggestions if the field is empty or if the value doesn’t match the currency code.
Add INCOTerm value from the listIf the INCO Term has been detected on the document and is filled in, adds a standardized INCOTerm value and its expansion for that delivery type. Example: DDP: Delivered Duty Paid.
Vendor DB lookupChecks information about the vendor against the corresponding catalog. If the catalog contains information about that vendor, but the values are either different or incomplete, fills in the appropriate fields using data from the catalog. The ID, Name, Street, CountryCode, and Consignee ID fields should be filled in in the vendor catalog.
Consignee DB lookupChecks information about the consignee against the corresponding catalog. If the catalog contains information about the consignee, but the values are either different or incomplete, fills in the appropriate fields using data from the catalog. The ID, Name, Street, and CountryCode fields should be filled in in the consignee catalog.

​
Supported Languages

CountriesLanguages
GlobalEnglish

Was this page helpful?