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
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
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
OrderExtraChargeFields
NLAM
NLAM
OECF_NLAM
TF_amount
Amount
Receipt Line Fields
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
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
OCF_NLAM
TF_amount
Amount
OCF_CEID
TF_costing_element
Costing element
OCF_CDSE
TF_charge_sequence
Charge sequence
Cost Line Fields
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
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
DebitNoteInvoiceCostFields
NLAM,AIT5
NLAM,AIT5
DNCF_NLAM
TF_amount
Amount
DNCF_AIT5
purchase_order
Purchase Order
Debit Note Receipt Line Fields
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
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
CreditNoteInvoiceCostFields
NLAM,AIT5
NLAM, AIT5
CNCF_NLAM
TF_amount
Amount
CNCF_AIT5
purchase_order
Purchase order
Credit Note Receipt Line Fields
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
Was this helpful?