Supported Languages
- English
- German (New Spelling)
Extracted Fields
Consignee
| Field | Description |
|---|---|
| Consignee ID | The unique identifier of the consignee. This field is extracted only when a consignee data catalog is used. |
| Name | The name of the consignee. |
| Address | The address of the consignee. |
| Tax ID | The international tax ID of the consignee. |
| Postal Code | The postal code of the consignee. This field is extracted only when a consignee data catalog is used. |
| Street | The Street component of the consignee address. This field is extracted only when a consignee data catalog is used. |
| City | The City component of the consignee address. This field is extracted only when a consignee data catalog is used. |
| State or Province | The State or Province component of the consignee address. This field is extracted only when a consignee data catalog is used. |
| Country | The Country component of the consignee address. This field is extracted only when a consignee data catalog is used. |
Vendor
| Field | Description |
|---|---|
| Vendor ID | The unique identifier of the sender of the goods. This field is extracted only when a vendor data catalog is used. |
| Name | The name of the sender of the goods. |
| Address | The address of the sender of the goods. |
| Tax ID | The international tax ID of the sender of the goods. |
| National Tax ID | The national tax ID of the sender of the goods. This field is extracted only when a vendor data catalog is used. |
| IBAN | The IBAN number of the sender of the goods. This field is extracted only when a vendor data catalog is used. |
| Bank Code | The bank code of the sender of the goods. This field is extracted only when a vendor data catalog is used. |
| Bank Account | The bank account of the sender of the goods. This field is extracted only when a vendor data catalog is used. |
| Postal Code | The postal code of the sender of the goods. This field is extracted only when a vendor data catalog is used. |
| Street | The Street component of the sender of the goods address. This field is extracted only when a vendor data catalog is used. |
| City | The City component of the sender of the goods address. This field is extracted only when a vendor data catalog is used. |
| State or Province | The State or Province component of the sender of the goods address. This field is extracted only when a vendor data catalog is used. |
| Country | The Country component of the sender of the goods address. This field is extracted only when a vendor data catalog is used. |
Ship to
| Field | Description |
|---|---|
| Name | The name of the recipient of the goods. |
| Address | The address of the recipient of the goods. |
Bill to
| Field | Description |
|---|---|
| Name | The name of the recipient of the invoice for the goods specified in the document. |
| Address | The address of the recipient of the invoice for the goods specified in the document. |
Invoice Information
| Field | Description |
|---|---|
| Invoice Number | The number of the invoice. |
| Invoice Date | The date on which the invoice was issued. |
| Due Date | The date by which the invoice should be paid. |
| Country of Origin | The country where the goods were manufactured. |
| Country of Export | The country from which the goods are being exported. |
| Country of Destination | The country into which the goods are being imported. |
| INCO Term | The terms of shipment. Possible values: EXW: EX Works FCA: Free Carrier FAS: Free Alongside Ship FOB: Free On Board CFR: Cost And Freight (variant: CNF) CIF: Cost Insurance Freight DAP: Delivered At Place (variant: DTU) DPU: Delivered at Place Unloaded CPT: Carriage Paid To CIP: Carriage Insurance Paid DDP: Delivered Duty Paid DDU: Delivered Duty Unpaid DAT: Delivered at Terminal. |
| Weight | The total weight of the goods. |
| Weight UoM | The unit of measurement used for the weight of the goods (such as kilos or pounds). |
| Total Pallets | The total number of pallets containing the goods. |
| Total | The total price of the goods. |
| Currency | The currency of the price. |
Additional Costs (repeating group)
| Field | Description |
|---|---|
| Type | The type, amount, and currency of any additional costs, such as insurance, freight, or packing. |
| Amount | The type, amount, and currency of any additional costs, such as insurance, freight, or packing. |
| Currency | The type, amount, and currency of any additional costs, such as insurance, freight, or packing. |
Line Items (repeating group)
| Field | Description |
|---|---|
| Position | The number of the line item. |
| Country of Origin | The country where the line item was manufactured. |
| HS Code | The Harmonized System code of the goods. |
| Description | A description of the line item. |
| Quantity | The number of units purchased. |
| UoM | The unit of measurement used for the line item. |
| Unit Price | The price of one unit of the goods. |
| Total Price | The total price of the line item, including additional charges and discounts. |
| Currency | The currency of the line item. |
| Net Weight | The net weight of the line item (that is, without the packaging). |
| Net Weight UoM | The unit of measurement used for the net weight (such as kilos or pounds). |
| Gross Weight | The gross weight of the line item (that is, with the packaging). |
| Gross Weight UoM | The unit of measurement used for the gross weight (such as kilos or pounds). |
Key Fields
- Consignee/Name
- Vendor/Name
- Invoice Number
- Invoice Date
- Total
- Currency
Validation Rules
| Rule | Description |
|---|---|
| Sum of Line Items amount should be equal to Total | Verifies that the sum of all line item amounts and Additional Costs is equal to the total invoiced amount. |
| Separate currency from amount in money fields | Splits 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 Items | Splits the amount and the currency in Line Items fields, and copies the currency into the Currency fields if they are empty. |
| Check item amount | Multiplies 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 fields | If 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., "", “CA”, “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 fields | Checks 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 list | If 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 lookup | Checks 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 lookup | Checks 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. |
Parameters
The Commercial Invoice skill has default parameters that refer to data catalogs used for Vendor and Consignee lookup. You can change the values of these parameters in Vantage or Advanced Designer to modify field extraction.| Parameter | Description |
|---|---|
| CommercialInvoiceVendors | The predefined data catalog used for Vendor lookup. The default value of this parameter is CommercialInvoiceVendors. You can change this value by choosing another available data catalog of the same type (Document Issuer Companies). |
| Consignees | The predefined data catalog used for Consignee lookup. The default value of this parameter is Consignees. You can change this value by choosing another available data catalog of the same type (Document Receiver Companies). |