EDI 850 (Purchase Order) Mapping

DocBits Field EDI FieldDescription

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