> For the complete documentation index, see [llms.txt](https://docs.docbits.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.docbits.com/chinese/infor-ji-cheng-yu-pei-zhi/exporting-to-infor/export-to-m3-mapping-api.md). # 导出到 M3 的映射（API） ### 章节 M3 导出映射文件分为 5 个章节，每个章节又分为 2 个小节： * 表头 * 表头静态字段 * 表头字段 * 税额行 * 税额行静态字段 * 税额行字段 * 收货行 * 收货行静态字段 * 收货行字段 * 订单费用行（附加金额） * 订单费用静态字段 * 订单费用字段 * 成本行 * 成本行静态字段 * 成本行字段 ### 添加和移除字段 添加新字段： * 首先，需要将 **M3 API 字段名称**添加到相关章节的字段列表属性中（例如 StaticFields、HeaderFields、InvoiceTaxFields）。 * 使用适用于该章节的前缀，为 API 字段定义静态值或文档字段名称。 * 示例 1：要为 M3 API 字段 **DIVI** 定义静态值 **AAA**，首先将 DIVI 添加到 **StaticFields** 属性中，然后添加一行 **SF\_DIVI = AAA**，因为 SF\_ 是静态字段的前缀。 * 示例 2：要将表头字段 \*\*IVDT（发票日期）\*\*映射到 DocBits 的 invoice\_date 字段，首先将 IVDT 添加到 **HeaderFields** 属性中，然后添加一行 HF\_IVDT = invoice\_date，因为 HF\_ 是表头字段的前缀。 移除字段： * 只需从章节的字段列表属性中移除该字段，并删除定义该字段值的行。 #### **可用的 M3 API 字段：** * 打开 M3 中相应的界面，即可查看可用的 M3 字段。
* 同样，也可以获取行项目的字段名称。 ### 表头：
字段列表属性：StaticFields 章节字段前缀：SF\_ 可用字段：可以将任意 M3 API 字段映射到任意静态值。 #### **表头字段** 字段列表属性：HeaderFields 章节字段前缀：HF\_ 可用字段：可以将任意 DocBits 字段映射到任意 M3 API 字段。 ### 税额行： #### 税额行静态字段： 字段列表属性：InvoiceTaxStaticFields 章节字段前缀：IT\_SF\_ 可用的 M3 字段：请查看 M3 API 或界面。 可用的 DocBits 字段：这些是静态字段，可以填写任意值。 #### 税额行字段： 字段列表属性：InvoiceTaxFields M3 字段前缀：ITF\_ DocBits 表格字段前缀：TF\_ 可用的 M3 字段：请查看 M3 API 或界面。 可用的 DocBits 字段：line\_number、tax\_amount、tax\_rate、net\_amount、gross\_amount、tax\_code\_full、tax\_code、tax\_country ### 收货行： #### 收货行静态字段： 字段列表属性：InvoiceReceiptStaticFields 章节字段前缀：IR\_SF\_ 可用的 M3 字段：请查看 M3 API 或界面。 可用的 DocBits 字段：这些是静态字段，可以填写任意值。 #### 收货行字段： 字段列表属性：InvoiceReceiptFields M3 字段前缀：IRF\_ DocBits 表格字段前缀：TF\_ 可用的 M3 字段：请查看 M3 API 或界面。 可用的 DocBits 字段：packing\_slip、purchase\_order、line\_number、line\_sequence、delivery\_number、delivery\_line、amount、quantity、total\_net\_amount ### 订单费用行： #### 订单费用静态字段： 字段列表属性：OrderChargeStaticFields 章节字段前缀：OC\_SF\_ 可用的 M3 字段：请查看 M3 API 或界面。 可用的 DocBits 字段：这些是静态字段，可以填写任意值。 #### 订单费用字段： 字段列表属性：OrderChargeFields M3 字段前缀：OCF\_ DocBits 表格字段前缀：TF\_ 可用的 M3 字段：请查看 M3 API 或界面。 可用的 DocBits 字段：ledger\_account、dimension\_2-7、amount、quantity、quantity2、position ### 成本行： #### 成本行静态字段： 字段列表属性：InvoiceCostStaticFields 章节字段前缀：IC\_SF\_ 可用的 M3 字段：请查看 M3 API 或界面。 可用的 DocBits 字段：这些是静态字段，可以填写任意值。 #### 成本行字段： 字段列表属性：InvoiceCostFields M3 字段前缀：ICF\_ DocBits 表格字段前缀：TF\_ 可用的 M3 字段：请查看 M3 API 或界面。 可用的 DocBits 字段：ledger\_account、dimension\_1-12、amount、quantity、quantity2、position 新更新 ``` ########################### # Header ########################### ## Header Static Fields StaticFields=DIVI,IBTP,BSCD,IMCD,TEPY,PYME,APCD,CRTP,GEOC,CONO,BKID SF_DIVI=AAA SF_IBTP=20 SF_CONO=780 #SF_BSCD=DE SF_IMCD=0 SF_TEPY=N00 SF_PYME=SCT SF_APCD=FABCEO SF_CRTP=1 SF_GEOC=60290522 ## Header Fields HeaderFields=SUNO,IVDT,SINO,SPYN,CUCD,CUAM,VTAM,ACDT,SERS,FTCO,BSCD,PUNO,TXAP,CORI,PAIN,BKID HF_SUNO=supplier_id HF_IVDT=invoice_date HF_SINO=invoice_id HF_SPYN=supplier_id HF_CUCD=currency HF_CUAM=total_net_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_BKID = custom_field_1 ########################### # Tax Line ########################### # ## Tax Line Static Fields # InvoiceTaxStaticFields=RDTP,DIVI,VTCD,CONO # IT_SF_RDTP=3 # IT_SF_DIVI=AAA # IT_SF_CONO=780 # ## Tax Line Fields # InvoiceTaxFields=VTCD,VTA1,VTP1,CLAM # ITF_VTCD=TF_tax_code # ITF_VTA1=TF_tax_amount # ITF_VTP1=TF_tax_rate # ITF_CLAM=TF_gross_amount ########################### # Receipt Line ########################### InvoiceReceipt=invoice_table ## Receipt Line Static Fields InvoiceReceiptStaticFields=RDTP,DIVI,SERS,RELP,VTCD,CONO IR_SF_RDTP=1 IR_SF_DIVI=AAA IR_SF_SERS=0 IR_SF_RELP=1 #IR_SF_VTCD=52 IR_SF_CONO=780 ## Receipt Line Fields InvoiceReceiptFields=IVQA,PUUN,PUNO,PNLI,ITNO,POPN,SUDO,NEPR,GRPR,PPUN,NLAM,GLAM 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 #IRF_NLAM = TF_net_amount IRF_GLAM = TF_total_amount ########################### # Order Charge Line ########################### OrderCharge=order_charges ## Order Charge Static Fields OrderChargeStaticFields=RDTP,DIVI,CONO OC_SF_RDTP=2 OC_SF_DIVI=AAA OC_SF_CONO=780 ## Order Charge Fields OrderChargeFields=NLAM,CHGT,CEID OCF_NLAM=TF_amount OCF_CHGT=TF_voucher_text OCF_CEID=TF_ledger_account ########################### # Cost Line ########################### InvoiceCost=cost_lines ## Cost Line Static Fields InvoiceCostStaticFields=RDTP,DIVI,CONO IC_SF_RDTP=8 IC_SF_DIVI=AAA IC_SF_CONO=780 ## 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 ``` ### 对于美国客户，我们将此映射更新为 V3 ```` ``` # Changes from Version 2 to Version 3:# -StaticFields=DIVI,IBTP,BSCD,IMCD,TEPY,PYME,APCD,CRTP,GEOC,BKID # -SF_DIVI=PJA # +StaticFields=DIVI,IBTP,BSCD,IMCD,TEPY,PYME,APCD,CRTP,CONO,GEOC # +SF_DIVI=RFP # +SF_CONO=001 # -SF_TEPY=J30 # -SF_PYME=PTR # +#SF_TEPY=N00 # +#SF_PYME=CSH # +#SF_APCD=MHIDALGO # -SF_BKID=001 # +SF_GEOC=999999999 # +#SF_BKID=DJ1 # -HeaderFields=SUNO,IVDT,SINO,SPYN,CUCD,CUAM,VTAM,ACDT,SERS,FTCO,BSCD,PUNO,TXAP,CORI,PAIN # +HeaderFields=SUNO,IVDT,SINO,SPYN,CUCD,CUAM,VTAM,ACDT,SERS,FTCO,BSCD,PUNO,TXAP,CORI,PAIN,TCHG,CDC1,APCD,TEPY,PYME,BKID # -HF_CUAM=total_net_amount # +HF_CUAM=total_net_amount_us # -HF_ACDT=invoice_date # +#HF_ACDT=invoice_date # -HF_CORI = correlation_id # -HF_PAIN = sqr_field_esr_reference # - # +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=supplier_geoc # -## Tax Line Static Fields # -InvoiceTaxStaticFields=RDTP,DIVI,VTCD # -IT_SF_RDTP=3 # -IT_SF_DIVI=PJA # +# ## Tax Line Static Fields # +# InvoiceTaxStaticFields=RDTP,DIVI,VTCD,CONO # +# IT_SF_RDTP=3 # +# IT_SF_DIVI=AAA # +# IT_SF_CONO=780 # -## Tax Line Fields # -InvoiceTaxFields=VTCD,VTA1,VTP1,CLAM # -ITF_VTCD=TF_tax_code # -ITF_VTA1=TF_tax_amount # -ITF_VTP1=TF_tax_rate # -ITF_CLAM=TF_gross_amount # +# ## Tax Line Fields # +# InvoiceTaxFields=VTCD,VTA1,VTP1,CLAM # +# ITF_VTCD=TF_tax_code # +# ITF_VTA1=TF_tax_amount # +# ITF_VTP1=TF_tax_rate # +# ITF_CLAM=TF_gross_amount # -InvoiceReceiptStaticFields=RDTP,DIVI,SERS,RELP,VTCD # +InvoiceReceiptStaticFields=RDTP,DIVI,SERS,RELP,VTCD,CONO # -IR_SF_DIVI=PJA # -IR_SF_SERS=0 # +IR_SF_DIVI=RFP # -IR_SF_VTCD=52 # +#IR_SF_VTCD=52 # +IR_SF_CONO=001 # -InvoiceReceiptFields=IVQA,PUUN,PUNO,PNLI,ITNO,POPN,SUDO,NEPR,GRPR,PPUN,NLAM,GLAM # +InvoiceReceiptFields=IVQA,PUUN,PUNO,PNLI,ITNO,POPN,SUDO,NEPR,GRPR,PPUN,NLAM,GLAM,TCHG,CDC1 # -#IRF_PUNO = TF_purchase_order # -#IRF_PNLI = TF_line_number # +IRF_PUNO = TF_purchase_order # +IRF_PNLI = TF_line_number # -#IRF_NEPR = TF_net_unit_price # +IRF_NEPR = TF_net_unit_price # -IRF_PPUN = TF_unit # -#IRF_NLAM = TF_net_amount # +IRF_PPUN = TF_unit_code_price # +IRF_NLAM = TF_net_amount # +IRF_TCHG = TF_charges # +IRF_CDC1 = TF_discount # -OrderChargeStaticFields=RDTP,DIVI # +OrderChargeStaticFields=RDTP,DIVI,CONO # -OC_SF_DIVI=PJA # +OC_SF_DIVI=RFP # +OC_SF_CONO=001 # -InvoiceCostStaticFields=RDTP,DIVI # +InvoiceCostStaticFields=RDTP,DIVI,CONO # -IC_SF_DIVI=PJA # +IC_SF_DIVI=RFP # +IC_SF_CONO=001 ########################### # Header ########################### ## Header Static Fields StaticFields=DIVI,IBTP,BSCD,IMCD,TEPY,PYME,APCD,CRTP,CONO,GEOC SF_DIVI=RFP SF_IBTP=20 SF_CONO=001 #SF_BSCD=DE SF_IMCD=0 #SF_TEPY=N00 #SF_PYME=CSH #SF_APCD=MHIDALGO SF_CRTP=1 SF_GEOC=999999999 #SF_BKID=DJ1 ## Header Fields HeaderFields=SUNO,IVDT,SINO,SPYN,CUCD,CUAM,VTAM,ACDT,SERS,FTCO,BSCD,PUNO,TXAP,CORI,PAIN,TCHG,CDC1,APCD,TEPY,PYME,BKID HF_SUNO=supplier_id HF_IVDT=invoice_date HF_SINO=invoice_id HF_SPYN=supplier_id HF_CUCD=currency HF_CUAM=total_net_amount_us #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=supplier_geoc ########################### # Tax Line ########################### # ## Tax Line Static Fields # InvoiceTaxStaticFields=RDTP,DIVI,VTCD,CONO # IT_SF_RDTP=3 # IT_SF_DIVI=AAA # IT_SF_CONO=780 # ## Tax Line Fields # InvoiceTaxFields=VTCD,VTA1,VTP1,CLAM # ITF_VTCD=TF_tax_code # ITF_VTA1=TF_tax_amount # ITF_VTP1=TF_tax_rate # ITF_CLAM=TF_gross_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 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_total_amount IRF_TCHG = TF_charges IRF_CDC1 = TF_discount ########################### # 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 OCF_NLAM=TF_amount OCF_CHGT=TF_voucher_text OCF_CEID=TF_ledger_account ########################### # 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 ``` ```` --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.docbits.com/chinese/infor-ji-cheng-yu-pei-zhi/exporting-to-infor/export-to-m3-mapping-api.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.