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

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

Last updated