EDI 850 (Purchase Order) Mapping
DocBits Field | EDI Field | Description |
---|---|---|
supplier_id | N104 | Unique identifier for the supplier. |
supplier_name | N102 | Name of the supplier. |
supplier_address | N101 | Address of the supplier. |
supplier_tax_id | not mapped yet | Tax identification number of the supplier. |
delivery_date | DTM02 | Date the goods or services were delivered. |
supplier_iban | not mapped yet | IBAN number of the supplier. |
payment_terms | ITD12 | Terms of payment specified for the invoice. |
purchase_order | not mapped yet | Purchase order number associated with the invoice. |
currency | CUR02 | Currency used in the invoice. |
net_amount | not mapped yet | Net amount before taxes. |
tax_amount | not mapped yet | Total tax amount applied. |
tax_rate | not mapped yet | Tax rate applied to the net amount. |
net_amount_2 | not mapped yet | Secondary net amount (if applicable). |
tax_amount_2 | not mapped yet | Secondary tax amount (if applicable). |
tax_rate_2 | not mapped yet | Secondary tax rate (if applicable). |
total_net_amount | not mapped yet | Total net amount of the invoice. |
total_tax_amount | not mapped yet | Total tax amount of the invoice. |
total_amount | not mapped yet | Total amount of the invoice, including taxes. |
POSITION | PO101 | Position within the invoice (related to line items). |
PURCHASE_ORDER | not mapped yet | Purchase order number. |
ITEM_NUMBER | PO1 | Item number associated with the invoice line item. |
SUPPLIER_ITEM_NUMBER | REF02 | Supplier's item number. |
DESCRIPTION | PID05 | Description of the item or service. |
QUANTITY | PO102 | Quantity of items or services. |
UNIT | PO103 | Unit of measure for the items or services. |
UNIT_PRICE | PO104 | Price per unit of the item or service. |
VAT | not mapped yet | VAT amount for the item or service. |
TOTAL_AMOUNT | PO102 * PO104 | Total amount for the line item, including VAT. |
AGREEMENT_NUMBER | REF02 | Agreement number related to the invoice (if applicable). |
TAX | (PO105)/100 | General tax amount applied to the invoice. |
order_date | BEG05 | Date when the order was placed. |
negative_amount | not mapped yet | Amount that is negative, possibly due to returns or adjustments. |
charges | not mapped yet | Additional charges applied to the invoice. |
order_number | BEG03 | Number assigned to the order. |
created_by | BEG02 | Identifier or name of the person who created the invoice. |
delivery_terms | BEG07 | Terms related to the delivery of goods or services. |
delivery_method | BEG05 | Method of delivery used for the goods or services. |
allowance | sum(SAC05)/100 | Allowance amount provided, if any. |
tax | sum(SAC05)/100 | Tax amount applied to the invoice (similar to TAX above). |
delivery_name | not mapped yet | Name of the recipient or entity receiving the delivery. |
delivery_address_line_1 | not mapped yet | First line of the delivery address. |
delivery_address_line_2 | not mapped yet | Second line of the delivery address (if applicable). |
pickup_address | not mapped yet | Address where the goods can be picked up (if applicable). |
Last updated