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

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

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

Field in Infor M3

Mapped Field in Docbits

Description

OrderExtraChargeFields

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

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

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

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

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

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

Field in Infor M3

Mapped Field in Docbits

Description

DebitNoteInvoiceCostFields

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

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

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

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

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

###########################
# Header
###########################

## 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
# Partial validation
#SF_PVLD=1

## Header Fields
HeaderFields=SUNO,IVDT,SINO,SPYN,CUCD,CUAM,VTAM,ACDT,SERS,FTCO,BSCD,PUNO,CORI,PAIN,TCHG,CDC1,APCD,TEPY,PYME,BKID,GEOC,TECD,TXAP,TXIN
HF_SUNO=supplier_id
HF_IVDT=invoice_date
HF_SINO=invoice_id
HF_SPYN=supplier_id
HF_CUCD=currency
HF_CUAM=total_amount
#HF_VTAM=total_tax_amount
#HF_ACDT=invoice_date
#HF_SERS=invoice_sub_type
HF_FTCO=supplier_country_code
HF_PUNO=purchase_order
#HF_TXAP=tax_country_1
HF_CORI=correlation_id
HF_PAIN=sqr_field_esr_reference
HF_TCHG=additional_amount
HF_CDC1=negative_amount
HF_APCD=buyer_id
HF_TEPY=payment_terms
HF_PYME=payment_method
HF_BKID=bank_id
HF_GEOC=geo_code
HF_TECD=discount_term
# Tax applicable
HF_TXAP=tax_applicable
# Tax included
HF_TXIN=tax_included

###########################
# Tax Line
###########################

# ## Tax Line Static Fields
InvoiceTaxStaticFields=RDTP,DIVI,VTCD,CONO,TAXT
IT_SF_RDTP=3
IT_SF_DIVI=RFP
IT_SF_CONO=001
# Tax Type
IT_SF_TAXT=2

# ## Tax Line Fields
# InvoiceTaxFields=VTCD,VTA1,VTP1,CLAM
InvoiceTaxFields=TTXA,TAXC,GEOC
# ITF_VTCD=TF_tax_code
# ITF_VTA1=TF_tax_amount
# ITF_VTP1=TF_tax_rate
# ITF_CLAM=TF_gross_amount

ITF_TTXA = TF_amount
ITF_TAXC = TF_tax_code
ITF_GEOC = TF_geo_code


###########################
# Order Header Extra Charges
###########################

OrderHeaderExtraCharges=order_xtra_header_charges

## Order Header Extra Charge 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

## Order Header Extra Charge Fields
OrderExtraChargeFields=NLAM
OECF_NLAM=TF_amount


###########################
# Receipt Line
###########################

InvoiceReceipt=invoice_table

## 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

## Receipt Line Fields
InvoiceReceiptFields=IVQA,PUUN,PUNO,PNLI,ITNO,POPN,SUDO,NEPR,GRPR,PPUN,NLAM,GLAM,TCHG,CDC1,REPN,PNLS
IRF_IVQA = TF_quantity
IRF_PUUN = TF_unit
IRF_PUNO = TF_purchase_order
IRF_PNLI = TF_line_number
IRF_ITNO = TF_item_number
IRF_POPN = TF_item_number
IRF_SUDO = TF_packing_slip
#IRF_NEPR = TF_net_unit_price
IRF_GRPR = TF_gross_unit_price
IRF_PPUN = TF_unit_code_price
#IRF_NLAM = TF_net_amount
#IRF_GLAM = TF_gross_amount
IRF_TCHG = TF_charges
IRF_CDC1 = TF_discount
IRF_PNLS = TF_sub_line_number
IRF_REPN = TF_receipt_number


###########################
# Order Line Charges
###########################

OrderLineCharge=order_charges
## Order Charge Static Fields
OrderLineChargeStaticFields=RDTP,DIVI,CONO
OLC_SF_RDTP=5
OLC_SF_DIVI=RFP
OLC_SF_CONO=001

## Order Charge Fields
OrderLineChargeFields=NLAM,CHGT,CEID,PUNO,PNLI,GRPR,ITNO,IVQA,SUDO,CDSE,REPN,PNLS
OLCF_GRPR=TF_unit_price
OLCF_CHGT=TF_voucher_text
OLCF_CEID=TF_costing_element
OLCF_PUNO=TF_purchase_order
OLCF_PNLI=TF_line_number
OLCF_ITNO=TF_item_number
OLCF_CDSE=TF_charge_sequence
OLCF_PNLS = TF_sub_line_number
OLCF_REPN = TF_receipt_number
OLCF_IVQA=TF_quantity
OLCF_SUDO=TF_packing_slip


###########################
# Order Charge Line
###########################

OrderCharge=order_charges

## Order Charge Static Fields
OrderChargeStaticFields=RDTP,DIVI,CONO
OC_SF_RDTP=2
OC_SF_DIVI=RFP
OC_SF_CONO=001

## Order Charge Fields
OrderChargeFields=NLAM,CHGT,CEID,CDSE
OCF_NLAM=TF_amount
OCF_CEID=TF_costing_element
OCF_CDSE=TF_charge_sequence


###########################
# Cost Line
###########################

InvoiceCost=cost_lines

## Cost Line Static Fields
InvoiceCostStaticFields=RDTP,DIVI,CONO
IC_SF_RDTP=8
IC_SF_DIVI=RFP
IC_SF_CONO=001

## Cost Line Fields
InvoiceCostFields=NLAM,VTXT,AO01,AO02,AO03,AO04,AO05,AO06,AO07,VTCD,AIT1,AIT2,AIT3,AIT4,AIT5,AIT6,AIT7,VTP1,VTP2
ICF_NLAM=TF_amount
ICF_VTXT=TF_voucher_text
ICF_AIT1=TF_ledger_account
ICF_AIT2=TF_dimension_2
ICF_AIT3=TF_dimension_3
ICF_AIT4=TF_dimension_4
ICF_AIT5=TF_dimension_5
ICF_AIT6=TF_dimension_6
ICF_AIT7=TF_dimension_7
ICF_AO01=TF_accounting_object_1
ICF_AO02=TF_accounting_object_2
ICF_AO03=TF_accounting_object_3
ICF_AO04=TF_accounting_object_4
ICF_AO05=TF_accounting_object_5
ICF_AO06=TF_accounting_object_6
ICF_AO07=TF_accounting_object_7


###########################
# Debit Note Header
###########################

## 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

## Header Fields
DNHeaderFields=SUNO,IVDT,SINO,SPYN,CUCD,CUAM,VTAM,ACDT,SERS,FTCO,BSCD,TXAP,CORI,PAIN,TCHG,CDC1,APCD,TEPY,PYME,BKID,GEOC
DN_HF_SUNO=supplier_id
DN_HF_IVDT=invoice_date
DN_HF_SINO=invoice_id
DN_HF_SPYN=supplier_id
DN_HF_CUCD=currency
DN_HF_CUAM=total_net_amount_us
#DN_HF_VTAM=total_tax_amount
#DN_HF_ACDT=invoice_date
#DN_HF_SERS=invoice_sub_type
DN_HF_FTCO=supplier_country_code
DN_HF_TXAP=tax_country_1
DN_HF_CORI=correlation_id
DN_HF_PAIN=sqr_field_esr_reference
DN_HF_TCHG=additional_amount
DN_HF_CDC1=negative_amount
DN_HF_APCD=buyer_id
DN_HF_TEPY=payment_terms
DN_HF_PYME=payment_method
DN_HF_BKID=bank_id
DN_HF_GEOC=geo_code


###########################
# Debit Note Cost Line
###########################

DebiteNoteInvoiceCost=debite_note_cost_lines

## 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

## Cost Line Fields
DebitNoteInvoiceCostFields=NLAM,AIT5
DNCF_NLAM=TF_amount
DNCF_AIT5=purchase_order

###########################
# Debit Note Receipt Line
###########################

DebitNoteReceipt=invoice_table

## 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

## Debit Note Receipt Line Fields
DebitNoteReceiptFields=IVQA,PUUN,PUNO,PNLI,ITNO,POPN,SUDO,NEPR,GRPR,PPUN,NLAM,GLAM,TCHG,CDC1
DNRF_IVQA = TF_quantity
DNRF_PUUN = TF_unit
DNRF_PUNO = TF_purchase_order
DNRF_PNLI = TF_line_number
DNRF_ITNO = TF_item_number
DNRF_POPN = TF_item_number
DNRF_SUDO = TF_packing_slip
#DNRF_NEPR = TF_net_unit_price
DNRF_GRPR = TF_gross_unit_price
DNRF_PPUN = TF_unit_code_price
#DNRF_NLAM = TF_net_amount
#DNRF_GLAM = TF_gross_amount
DNRF_TCHG = TF_charges
DNRF_CDC1 = TF_discount


###########################
# Credit Note Header
###########################

## 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

## Header Fields
CNHeaderFields=SUNO,IVDT,SINO,SPYN,CUCD,CUAM,VTAM,ACDT,SERS,FTCO,BSCD,TXAP,CORI,PAIN,TCHG,CDC1,APCD,TEPY,PYME,BKID,GEOC
CN_HF_SUNO=supplier_id
CN_HF_IVDT=invoice_date
CN_HF_SINO=invoice_id
CN_HF_SPYN=supplier_id
CN_HF_CUCD=currency
CN_HF_CUAM=total_net_amount_us
#CN_HF_VTAM=total_tax_amount
#CN_HF_ACDT=invoice_date
#CN_HF_SERS=invoice_sub_type
CN_HF_FTCO=supplier_country_code
CN_HF_TXAP=tax_country_1
CN_HF_CORI=correlation_id
CN_HF_PAIN=sqr_field_esr_reference
CN_HF_TCHG=additional_amount
CN_HF_CDC1=negative_amount
CN_HF_APCD=buyer_id
CN_HF_TEPY=payment_terms
CN_HF_PYME=payment_method
CN_HF_BKID=bank_id
CN_HF_GEOC=geo_code


###########################
# Credit Note Cost Line
###########################

CreditNoteInvoiceCost=credit_note_cost_lines

## 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

## Cost Line Fields
CreditNoteInvoiceCostFields=NLAM,AIT5
CNCF_NLAM=TF_amount
CNCF_AIT5=purchase_order

###########################
# Credit Note Receipt Line
###########################

CreditNoteReceipt=invoice_table

## 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

## Credit Note Receipt Line Fields
CeeditNoteReceiptFields=IVQA,PUUN,PUNO,PNLI,ITNO,POPN,SUDO,NEPR,GRPR,PPUN,NLAM,GLAM,TCHG,CDC1
CNRF_IVQA = TF_quantity
CNRF_PUUN = TF_unit
CNRF_PUNO = TF_purchase_order
CNRF_PNLI = TF_line_number
CNRF_ITNO = TF_item_number
CNRF_POPN = TF_item_number
CNRF_SUDO = TF_packing_slip
#CNRF_NEPR = TF_net_unit_price
CNRF_GRPR = TF_gross_unit_price
CNRF_PPUN = TF_unit_code_price
#CNRF_NLAM = TF_net_amount
#CNRF_GLAM = TF_gross_amount
CNRF_TCHG = TF_charges
CNRF_CDC1 = TF_discount

PreviousExample Export LN NextDocument Export Mapping

Last updated 1 month ago