​
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.
ShipperInformation about the sender of the goods.
  Account NumberThe shipper’s account number.
  NameThe shipper’s name.
  AddressThe shipper’s address.
  StateThe shipper’s state.
  CityThe shipper’s city.
  StreetThe shipper’s street address.
  Postal CodeThe shipper’s postal code.
  CountryThe shipper’s country.
ConsigneeInformation about the recipient of the goods.
  Account NumberThe consignee’s account number.
  NameThe consignee’s name.
  AddressThe consignee’s address.
  StateThe consignee’s state.
  CityThe consignee’s city.
  StreetThe consignee’s street address.
  Postal CodeThe consignee’s postal code.
  CountryThe consignee’s country.
Carrier’s AgentInformation about the carrier’s agent.
  NameThe carrier’s agent’s name.
  CityThe carrier’s agent’s city.
  IATA CodeThe carrier’s agent’s IATA code.
  Account NumberThe carrier’s agent’s account number.
AirlineInformation about the airline.
  NameThe airline’s name.
  PrefixThe airline’s prefix.
MAWB InformationInformation about the Master Air Waybill.
  NumberThe MAWB number.
  Issue DateThe date when the MAWB was issued.
  Issue PlaceThe place where the MAWB was issued.
HAWB InformationInformation about the House Air Waybill.
  NumberThe HAWB number.
  Issue DateThe date when the HAWB was issued.
  Issue PlaceThe place where the HAWB was issued.
Airport InformationInformation about the airports.
  DepartureThe departure airport.
  DestinationThe destination airport.
  Flight NumberThe flight number.
  Flight DateThe flight date.
ChargesInformation about the charges.
  Weight ChargeThe weight charge.
  Valuation ChargeThe valuation charge.
  TaxThe tax amount.
  Total Other Charges Due AgentThe total of other charges due to the agent.
  Total Other Charges Due CarrierThe total of other charges due to the carrier.
  TotalThe total charges.
Payment InformationInformation about the payment.
  CurrencyThe currency of the payment.
  CHGS CodeThe charges code.
  WT/VALThe weight/valuation payment type.
  OtherOther payment information.
Line ItemsInformation about the line items.
  Number of PiecesThe number of pieces.
  Gross WeightThe gross weight.
  kg/lbThe weight unit (kilograms or pounds).
  Rate ClassThe rate class.
  Commodity Item NumberThe commodity item number.
  Chargeable WeightThe chargeable weight.
  Rate/ChargeThe rate or charge.
  TotalThe total for the line item.
  Nature and Quantity of GoodsThe nature and quantity of goods.
Weight InformationInformation about the weight.
  Gross WeightThe gross weight.
  Chargeable WeightThe chargeable weight.
  Rate ClassThe rate class.
  Commodity Item NumberThe commodity item number.
  Rate/ChargeThe rate or charge.
  TotalThe total weight charge.
Airport InformationInformation about the airports.
  Account NumberThe carrier’s account number.
  IATA codeThe carrier’s identification number.
  NameThe carrier’s name.
  AddressThe carrier’s address.
  CountryThe carrier’s country.
  State or ProvinceThe carrier’s state or province.
  CityThe carrier’s city.
  Postal CodeThe carrier’s postal code.
  StreetThe carrier’s street address.
  Tax IDThe carrier’s international tax identification number.
AirlineInformation about the airline carrying the goods.
  NameThe name of the airline engaged to carry the goods.
  AddressThe airline’s address.
  CountryThe airline’s country.
  State or ProvinceThe airline’s state or province.
  CityThe airline’s city.
  Postal CodeThe airline’s postal code.
  StreetThe airline’s street address.
MAWB InformationInformation about the Master Air Waybill.
  MAWB NumberThe master air waybill number.
  DateThe date of the master air waybill.
HAWB InformationInformation about the House Air Waybill.
  HAWB NumberThe house air waybill number.
  DateThe date of the house air waybill.
Airport InformationInformation about the airports involved in the shipment.
  Airport of Departure/CodeThe airport code and name where the shipment originates.
  Airport of Destination/CodeThe airport code and name where the shipment is destined.
  Requested Flight/DateThe requested flight number and date for the shipment.
  Flight DateThe actual flight date for the shipment.
ChargesInformation about the shipping charges.
  CurrencyThe currency used for the charges.
  Weight ChargesThe charges based on the weight of the shipment.
  Valuation ChargesThe charges for declared value of the shipment.
  TaxThe tax charges.
  Other ChargesAny additional charges not included in other categories.
  TotalThe total amount of all charges.
Payment InformationInformation about payment terms and amounts.
  Total PrepaidThe total amount prepaid for the shipment.
  Total CollectThe total amount to be collected upon delivery.
Line ItemsInformation about the items being shipped.
  No. of PiecesThe number of pieces in the shipment.
  Gross WeightThe total weight of the shipment including packaging.
  Chargeable WeightThe weight used for calculating charges.
  Rate/ChargeThe rate per unit of weight.
  TotalThe total charge for the line item.
Weight InformationInformation about the shipment weights.
  Total QuantityThe total number of pieces in the shipment.
  Total WeightThe total gross weight of the shipment.
  Total Chargeable WeightThe total weight used for calculating charges.
  Total Quantity UoMThe unit of measure for the total quantity.
  Total Weight UoMThe unit of measure for the total weight.

​
Validation Rules

RuleDescription
Check quantity totalChecks if the value in the Total Quantity field equals the sum of the values in the Quantity fields in the Line Items table, and displays an error if the values do not match. If the values are not the same, or some of the fields are missing, the rule prompts the user to populate fields with the calculated value.
Check weight totalChecks if the value in the Total Weight field equals the sum of the values in the Gross Weight fields in the Line Items table, and displays an error if the values do not match. If the values are not the same, or some of the fields are missing, the rule prompts the user to populate fields with the calculated value.
Check chargeable weight totalChecks if the value in the Total Chargeable Weight field equals the sum of the values in the Chargeable Weight fields in the Line Items table, and displays an error if the values do not match. If the values are not the same, or some of the fields are missing, the rule prompts the user to populate fields with the calculated value.
Check table Total amountChecks if the value in the Total field equals the value of the Weight Charges field in the Charges group and/or the sum of the values in the Total fields in the Line Items group. If the values do not match, the rule prompts the user to populate fields with the calculated value.
Copy Quantity UoMIf the main Total Quantity UoM field is empty, copies the values from the Quantity UoM fields in the Line Items group.
Copy Weight UoMIf the main Total Weight UoM field is empty, copies the values from the Weight UoM fields in the Line Items group.
Check Other ChargesChecks if the amount of all the additional charges equals the sum of the values in the Charges fields.
Check Total Prepaid or Total CollectChecks if the total amount of all the charges and additional charges equals the value in the Total Prepaid or Total Collect field.
Disambiguate DatesNormalizes date text to date value. Ambiguous dates are assumed to be in European (date-month-year) format, as is the case on the majority of transport documents.
Process CurrencyMoves currency information from money-type fields to the Currency field, if this field is empty and currency information is located elsewhere in the document. If information is absent or ambiguous, suggests possible currency values.
Process MAWBConverts the value in the MAWB number field into a sequence of 11 digits and checks that the value is 11 characters long, with the last digit being the check digit. This rule is only applied to master air waybills.
Suggest Flight DateIf the value in the Flight Date field is not complete, suggests it using Air Waybill Date as reference in YYYY-MM-DD format.

​
Supported Languages

CountriesLanguages
GlobalEnglish

Was this page helpful?