Example Export M3

General Overview

The export to Infor M3 involves transferring invoice-related data from Docbits into Infor M3 in a structured manner. The data is organized into headers, tax lines, receipt lines, and cost lines. Each section includes static fields that remain constant across transactions and dynamic fields that vary based on the invoice or transaction details.

Field Mappings

Header Fields

Field in Infor M3
Mapped Field in Docbits
Description

HF_SUNO

supplier_id

Supplier identifier

HF_IVDT

invoice_date

Invoice date

HF_SINO

invoice_id

Invoice identifier

HF_SPYN

supplier_id

Supplier identifier

HF_CUCD

currency

Currency used in the invoice

HF_CUAM

total_amount

Total amount

HF_VTAM

total_tax_amount

Total tax amount

HF_ACDT

accounting_date

Accounting Date

HF_SERS

invoice_sub_type

Invoice sub type

HF_FTCO

supplier_country_code

Supplier country code

HF_PUNO

purchase_order

Purchase order

HF_TXAP

tax_country_1

Tax country

HF_CORI

correlation_id

Correlation identifier

HF_PAIN

sqr_field_esr_reference

Field Reference

HF_TCHG

additional_amount

Additional amount

HF_CDC1

negative_amount

Negative amount

HF_APCD

authorised_user

Authorised user

HF_TEPY

payment_terms

Payment terms

HF_PYME

payment_method

Payment method

HF_BKID

bank_id

Bank identifier

HF_GEOC

geo_code

Geo code

HF_TECD

discount_term

Discount term

HF_TXAP

tax_applicable

Tax applicable

HF_TXIN

tax_included

Tax included

Tax Line Fields

Field in Infor M3
Mapped Field in Docbits
Description

ITF_VTCD

TF_tax_code

Tax code

ITF_VTA1

TF_tax_amount

Tax amount

ITF_VTP1

TF_tax_rate

Tax rate

ITF_CLAM

TF_gross_amount

Gross amount

ITF_DIVI

company_id

Company identifier

ITF_TTXA

TF_amount

Amount

ITF_TAXC

TF_tax_code

Tax code

ITF_GEOC

TF_geo_code

Geo code

Order Header Extra Charges Fields

Field in Infor M3
Mapped Field in Docbits
Description

OrderExtraChargeFields

NLAM

NLAM

OECF_NLAM

TF_amount

Amount

Receipt Line Fields

Field in Infor M3
Mapped Field in Docbits
Description

IRF_IVQA

TF_quantity

Invoiced quantity

IRF_PUUN

TF_unit

Unit number

IRF_PUNO

TF_purchase_order

Purchase order number

IRF_PNLI

TF_line_number

Order line number

IRF_ITNO

TF_item_number

Item number

IRF_POPN

TF_item_number

Item number

IRF_SUDO

TF_packing_slip

Packing slip

IRF_NEPR

TF_net_unit_price

Net unit price

IRF_GRPR

TF_gross_unit_price

Gross unit price

IRF_PPUN

TF_unit_code_price

Unit code price

IRF_NLAM

TF_net_amount

Net amount

IRF_GLAM

TF_gross_amount

Gross amount

IRF_TCHG

TF_charges

Charges

IRF_CDC1

TF_discount

Discount

IRF_PNLS

TF_sub_line_number

Sub line number

IRF_REPN

TF_receipt_number

Receipt number

IRF_DIVI

company_id

Company identifier

IRF_IVCW

TF_catch_weight

Catch weight

IRF_PUCD

TF_unit_price_per

Unit price per

Order Line Charges Fields

Field in Infor M3
Mapped Field in Docbits
Description

OLCF_GRPR

TF_unit_price

Unit price

OLCF_CHGT

TF_voucher_text

Voucher text

OLCF_CEID

TF_costing_element

Costing element

OLCF_PUNO

TF_purchase_order

Purchase order

OLCF_PNLI

TF_line_number

Line number

OLCF_ITNO

TF_item_number

Item number

OLCF_CDSE

TF_charge_sequence

Charge sequence

OLCF_PNLS

TF_sub_line_number

Sub line number

OLCF_REPN

TF_receipt_number

Receipt number

OLCF_IVQA

TF_quantity

Quantity

OLCF_SUDO

TF_packing_slip

Packing slip

Order Charge Line Fields

Field in Infor M3
Mapped Field in Docbits
Description

OCF_NLAM

TF_amount

Amount

OCF_CEID

TF_costing_element

Costing element

OCF_CDSE

TF_charge_sequence

Charge sequence

Cost Line Fields

Field in Infor M3
Mapped Field in Docbits
Description

ICF_NLAM

TF_amount

Amount in the transaction

ICF_VTXT

TF_voucher_text

Voucher text

ICF_AIT1

TF_ledger_account

Ledger account

ICF_AIT2

TF_dimension_2

Dimension 2

ICF_AIT3

TF_dimension_3

Dimension 3

ICF_AIT4

supplier_id

Supplier identifier

ICF_AIT5

TF_dimension_5

Dimension 5

ICF_AIT6

TF_dimension_6

Dimension 6

ICF_AIT7

TF_dimension_7

Dimension 7

ICF_AO01

TF_accounting_object_1

Accounting object 1

ICF_AO02

TF_accounting_object_2

Accounting object 2

ICF_AO03

TF_accounting_object_3

Accounting object 3

ICF_AO04

TF_accounting_object_4

Accounting object 4

ICF_AO05

TF_accounting_object_5

Accounting object 5

ICF_AO06

TF_accounting_object_6

Accounting object 6

ICF_AO07

TF_accounting_object_7

Accounting object 7

Debit Note Header Fields

Field in Infor M3
Mapped Field in Docbits
Description

DN_HF_SUNO

supplier_id

Supplier identifier

DN_HF_IVDT

invoice_date

Invoice date

DN_HF_SINO

invoice_id

Invoice identifier

DN_HF_SPYN

supplier_id

Supplier identifier

DN_HF_CUCD

currency

Currency

DN_HF_CUAM

total_net_amount_us

Total net amount us

DN_HF_VTAM

total_tax_amount

Total tax amount

DN_HF_ACDT

invoice_date

Invoice_date

DN_HF_SERS

invoice_sub_type

Invoice sub type

DN_HF_FTCO

supplier_country_code

Supplier country code

DN_HF_TXAP

tax_country_1

Tax country

DN_HF_CORI

correlation_id

Correlation identifier

DN_HF_PAIN

sqr_field_esr_reference

Sqr field esr reference

DN_HF_TCHG

additional_amount

Additional amount

DN_HF_CDC1

negative_amount

Negative amount

DN_HF_APCD

buyer_id

Buyer identifier

DN_HF_TEPY

payment_terms

Payment terms

DN_HF_PYME

payment_method

Payment Method

DN_HF_BKID

bank_id

Bank identifier

DN_HF_GEOC

geo_code

Geo Code

Debit Note Cost Line Fields

Field in Infor M3
Mapped Field in Docbits
Description

DebitNoteInvoiceCostFields

NLAM,AIT5

NLAM,AIT5

DNCF_NLAM

TF_amount

Amount

DNCF_AIT5

purchase_order

Purchase Order

Debit Note Receipt Line Fields

Field in Infor M3
Mapped Field in Docbits
Description

DNRF_IVQA

TF_quantity

Quantity

DNRF_PUUN

TF_unit

Unit

DNRF_PUNO

TF_purchase_order

Purchase order

DNRF_PNLI

TF_line_number

Line number

DNRF_ITNO

TF_item_number

Item number

DNRF_POPN

TF_item_number

Item number

DNRF_SUDO

TF_packing_slip

Packing slip

DNRF_NEPR

TF_net_unit_price

Net unit price

DNRF_GRPR

TF_gross_unit_price

Gross unit price

DNRF_PPUN

TF_unit_code_price

Unit code price

DNRF_NLAM

TF_net_amount

Net amount

DNRF_GLAM

TF_gross_amount

Gross amount

DNRF_TCHG

TF_charges

Charges

DNRF_CDC1

TF_discount

Discount

Credit Note Header

Field in Infor M3
Mapped Field in Docbits
Description

CN_HF_SUNO

supplier_id

Supplier identifier

CN_HF_IVDT

invoice_date

Invoice date

CN_HF_SINO

invoice_id

Invoice identifier

CN_HF_SPYN

supplier_id

Supplier identifier

CN_HF_CUCD

currency

Currency

CN_HF_CUAM

total_net_amount_us

Total net amount us

CN_HF_VTAM

total_tax_amount

Total tax amount

CN_HF_ACDT

invoice_date

Invoice date

CN_HF_SERS

invoice_sub_type

Invoice sub type

CN_HF_FTCO

supplier_country_code

Supplier country code

CN_HF_TXAP

tax_country_1

Tax country

CN_HF_CORI

correlation_id

Correlation identifier

CN_HF_PAIN

sqr_field_esr_reference

Sqr field esr reference

CN_HF_TCHG

additional_amount

Additional amount

CN_HF_CDC1

negative_amount

Negative amount

CN_HF_APCD

buyer_id

Buyer identifier

CN_HF_TEPY

payment_terms

Payment terms

CN_HF_PYME

payment_method

Payment method

CN_HF_BKID

bank_id

Bank identifier

CN_HF_GEOC

geo_code

Geo code

Credit Note Cost Line Fields

Field in Infor M3
Mapped Field in Docbits
Description

CreditNoteInvoiceCostFields

NLAM,AIT5

NLAM, AIT5

CNCF_NLAM

TF_amount

Amount

CNCF_AIT5

purchase_order

Purchase order

Credit Note Receipt Line Fields

Field in Infor M3
Mapped Field in Docbits
Description

CNRF_IVQA

TF_quantity

Quantity

CNRF_PUUN

TF_unit

Unit

CNRF_PUNO

TF_purchase_order

Purchase order

CNRF_PNLI

TF_line_number

Line number

CNRF_ITNO

TF_item_number

Item number

CNRF_POPN

TF_item_number

Item number

CNRF_SUDO

TF_packing_slip

Packing slip

CNRF_NEPR

TF_net_unit_price

Net unit price

CNRF_GRPR

TF_gross_unit_price

Gross unit price

CNRF_PPUN

TF_unit_code_price

Unit code price

CNRF_NLAM

TF_net_amount

Net amount

CNRF_GLAM

TF_gross_amount

Gross amount

CNRF_TCHG

TF_charges

Charges

CNRF_CDC1

TF_discount

Discount

Static Fields

In addition to the dynamic mappings, there are several static fields used for each type of line, which are predefined as follows:

  • Header Static Fields:

    • StaticFields=DIVI,IBTP,BSCD,IMCD,APCD,CRTP,CONO,PVLD

    • SF_DIVI=RFP

    • SF_IBTP=20

    • SF_CONO=001

    • SF_BSCD=DE

    • SF_IMCD=0

    • SF_APCD=MHIDALGO

    • SF_CRTP=1

    • SF_PVLD=1

  • Tax Line Static Fields:

    • InvoiceTaxStaticFields=RDTP,DIVI,VTCD,CONO,TAXT

    • IT_SF_RDTP=3

    • IT_SF_DIVI=RFP

    • IT_SF_CONO=001

    • IT_SF_TAXT=2

  • Order Header Extra Charge Static Static Fields:

    • OrderExtraChargeStaticFields=RDTP,DIVI,CONO,CDSE,CEID

    • OEC_SF_RDTP=2

    • OEC_SF_DIVI=RFP

    • OEC_SF_CONO=001

    • OEC_SF_CEID=INVPD

    • OEC_SF_CDSE=99

  • Receipt Line Static Fields:

    • InvoiceReceiptStaticFields=RDTP,DIVI,SERS,RELP,VTCD,CONO

    • IR_SF_RDTP=1

    • IR_SF_DIVI=RFP

    • IR_SF_RELP=1

    • IR_SF_VTCD=52

    • IR_SF_CONO=001

  • Order Line Charge Static Fields:

    • OrderLineChargeStaticFields=RDTP,DIVI,CONO

    • OLC_SF_RDTP=5

    • OLC_SF_DIVI=RFP

    • OLC_SF_CONO=001

  • Order Charge Line Static Fields:

    • OrderChargeStaticFields=RDTP,DIVI,CONO

    • OC_SF_RDTP=2

    • OC_SF_DIVI=RFP

    • OC_SF_CONO=001

  • Cost Line Static Fields:

    • InvoiceCostStaticFields=RDTP,DIVI,CONO

    • IC_SF_RDTP=8

    • IC_SF_DIVI=RFP

    • IC_SF_CONO=001

  • Debit Note Header Static Fields:

    • DNStaticFields=DIVI,IBTP,BSCD,IMCD,TEPY,PYME,APCD,CRTP,CONO

    • DN_SF_DIVI=RFP

    • DN_SF_IBTP=20

    • DN_SF_CONO=001

    • DN_SF_BSCD=DE

    • DN_SF_IMCD=0

    • DN_SF_TEPY=N00

    • DN_SF_PYME=CSH

    • DN_SF_APCD=MHIDALGO

    • DN_SF_CRTP=1

    • DN_SF_BKID=DJ1

  • Debit Note Cost Line Static Fields:

    • DebitNoteCostStaticFields=RDTP,DIVI,CONO,AIT1,AIT2,AIT3,AIT4,AIT5,AIT6,AIT7

    • DNC_SF_RDTP=8

    • DNC_SF_DIVI=RFP

    • DNC_SF_CONO=001

    • DNC_SF_AIT1=20216

    • DNC_SF_AIT3=100

    • DNC_SF_AIT6=INVDN

    • DNC_SF_AIT7=PP20230

  • Debit Note Receipt Line Static Fields

    • DebitNoteReceiptStaticFields=RDTP,DIVI,SERS,RELP,VTCD,CONO

    • DNR_SF_RDTP=1

    • DNR_SF_DIVI=RFP

    • DNR_SF_RELP=1

    • DNR_SF_VTCD=52

    • DNR_SF_CONO=001

  • Credit Note Header Static Fields:

    • CNStaticFields=DIVI,IBTP,BSCD,IMCD,TEPY,PYME,APCD,CRTP,CONO

    • CN_SF_DIVI=RFP

    • CN_SF_IBTP=20

    • CN_SF_CONO=001

    • CN_SF_BSCD=DE

    • CN_SF_IMCD=0

    • CN_SF_TEPY=N00

    • CN_SF_PYME=CSH

    • CN_SF_APCD=MHIDALGO

    • CN_SF_CRTP=1

    • CN_SF_BKID=DJ1

  • Credit Note Cost Line Static Fields:

    • CreditNoteCostStaticFields=RDTP,DIVI,CONO,AIT1,AIT2,AIT3,AIT4,AIT5,AIT6,AIT7

    • CNC_SF_RDTP=8

    • CNC_SF_DIVI=RFP

    • CNC_SF_CONO=001

    • CNC_SF_AIT1=20216

    • CNC_SF_AIT3=100

    • CNC_SF_AIT6=INVDN

    • CNC_SF_AIT7=PP20230

  • Credit Note Receipt Line Static Fields:

    • CreditNoteReceiptStaticFields=RDTP,DIVI,SERS,RELP,VTCD,CONO

    • CNR_SF_RDTP=1

    • CNR_SF_DIVI=RFP

    • CNR_SF_RELP=1

    • CNR_SF_VTCD=52

    • CNR_SF_CONO=001

Full Example

Last updated

Was this helpful?