Accelerator Anypoint Partner Manager EDI Mappings - Source

(0 reviews)

Mappings

X12 Purchase Order Mapping

CIM EDI Description of source field
id default to null The Unique Mdm Id
name v850.Name ++ (v850."010_PO1"."PO109") The purchase order name
description v850.Name ++ (v850."010_PO1"."PO109") The purchase order name
orderNumber v850.Heading."020_BEG".BEG03 The Purchase Order Number
requestedStartDate v850.Heading."020_BEG".BEG05 The Sales Order start Date format : "YYYY-MM-dd"
salesOrderType Hardcoded to INITIAL The Purchase Order Type
salesOrderStatus v850.Heading."020_BEG".BEG01 The Sales order status
orderCurrency Hardcoded to USD The Currency Code
id Hardcoded to null The Order Customer Id
partyRoleType Hardcoded to Customer The Party role Type
id Hardcoded to null The Party Id
partyType Hardcoded to Individual The Party Type
personName v850.Heading."060_PER".PER02 The Customer Name
id Hardcoded to null The contact point Id
contactPointType ContactPointEmail The contactPoints Email
emailAddress v850.Heading."060_PER".PER04 The party emailAddress
activeFromDate Todays Date The date format "YYYY-MM-DD"
customerStatus ACTIVE The Customer Status
soldToCustomer Hardcoded to 1001092 The unique customer Id
PurchaseOrderByCustomer Hardcoded to PO Number The Purchase made by customer
id Hardcoded to null The orderLine items Id
description v010PO1Loop."050_PID_Loop"."050_PID".PID05 The Product description
orderedQuantity v010PO1Loop."010_PO1".PO102 The Order quantity
unitPriceAmount v010PO1Loop."010_PO1".PO104 The Product List Price
totalPriceAmount v010PO1Loop."010_PO1".PO104 * v010PO1Loop."010_PO1".PO102 The Total totalPriceAmount
quantityOrderedUOM Hardcoded to UNIT The Quantity Measure Type
orderProductNumber v010PO1Loop."010_PO1".PO109 The Product Id

CIM	EDI	Description of source field
id	default to null	The Unique Mdm Id
name	v850.Name ++ (v850."010_PO1"."PO109")	The purchase order name
description	v850.Name ++ (v850."010_PO1"."PO109")	The purchase order name
orderNumber	v850.Heading."020_BEG".BEG03	The Purchase Order Number
requestedStartDate	v850.Heading."020_BEG".BEG05	The Sales Order start Date format : "YYYY-MM-dd"
salesOrderType	Hardcoded to INITIAL	The Purchase Order Type
salesOrderStatus	v850.Heading."020_BEG".BEG01	The Sales order status
orderCurrency	Hardcoded to USD	The Currency Code
id	Hardcoded to null	The Order Customer Id
partyRoleType	Hardcoded to Customer	The Party role Type
id	Hardcoded to null	The Party Id
partyType	Hardcoded to Individual	The Party Type
personName	v850.Heading."060_PER".PER02	The Customer Name
id	Hardcoded to null	The contact point Id
contactPointType	ContactPointEmail	The contactPoints Email
emailAddress	v850.Heading."060_PER".PER04	The party emailAddress
activeFromDate	Todays Date	The date format "YYYY-MM-DD"
customerStatus	ACTIVE	The Customer Status
soldToCustomer	Hardcoded to 1001092	The unique customer Id
PurchaseOrderByCustomer	Hardcoded to PO Number	The Purchase made by customer
id	Hardcoded to null	The orderLine items Id
description	v010PO1Loop."050_PID_Loop"."050_PID".PID05	The Product description
orderedQuantity	v010PO1Loop."010_PO1".PO102	The Order quantity
unitPriceAmount	v010PO1Loop."010_PO1".PO104	The Product List Price
totalPriceAmount	v010PO1Loop."010_PO1".PO104 * v010PO1Loop."010_PO1".PO102	The Total totalPriceAmount
quantityOrderedUOM	Hardcoded to UNIT	The Quantity Measure Type
orderProductNumber	v010PO1Loop."010_PO1".PO109	The Product Id

EDIFACT Purchase Orders Mapping

CIM EDI Description of source field
id default to null The Unique Mdm Id
name Heading."0020_BGM".BGM03 ++ '-' ++ Heading."0020_BGM".BGM0201 The purchase order name
description Heading."0020_BGM".BGM03 The purchase order name
orderNumber Heading."0020_BGM".BGM0201 The Purchase Order Number
requestedStartDate Heading."0030_DTM".DTM0102 The Sales Order start Date format : "YYYY-MM-dd"
salesOrderType Hardcoded to INITIAL The Purchase Order Type
salesOrderStatus Hardcoded to CREATED The Sales order status
orderCurrency Hardcoded to USD The Currency Code
id Hardcoded to null The Order Customer Id
partyRoleType Hardcoded to Customer The Party role Type
id Hardcoded to null The Party Id
partyType Hardcoded to Individual The Party Type
personName Heading."0110_Segment_group_2"."0210_Segment_group_5"[0]."0220_CTA".CTA0202[0] The Customer Name
id Hardcoded to null The contact point Id
contactPointType ContactPointEmail The contactPoints Email
emailAddress Heading."0110_Segment_group_2"."0210_Segment_group_5"[0]."0230_COM"[0].COM0101[1] The party emailAddress
activeFromDate Todays Date The date format "YYYY-MM-DD"
customerStatus ACTIVE The Customer Status
soldToCustomer Hardcoded to 1001252 The unique customer Id (SAP)
PurchaseOrderByCustomer Hardcoded to PO Number The Purchase made by customer
id PO Number ++ PONumberLineItemID The orderLine items Id
description Detail."1040_IMD".IMD0304[0] The Product description
orderedQuantity Detail."1060_QTY".QTY0102[0] The Order quantity
unitPriceAmount Detail."1280_Segment_group_32"."1290_PRI".PRI0102[0] The Product List Price
totalPriceAmount v010PO1Loop."010_PO1".PO104 * v010PO1Loop."010_PO1".PO102 The Total totalPriceAmount
quantityOrderedUOM Hardcoded to UNIT The Quantity Measure Type
orderProductNumber Detail."1020_LIN".LIN0301 The Product Id

CIM	EDI	Description of source field
id	default to null	The Unique Mdm Id
name	Heading."0020_BGM".BGM03 ++ '-' ++ Heading."0020_BGM".BGM0201	The purchase order name
description	Heading."0020_BGM".BGM03	The purchase order name
orderNumber	Heading."0020_BGM".BGM0201	The Purchase Order Number
requestedStartDate	Heading."0030_DTM".DTM0102	The Sales Order start Date format : "YYYY-MM-dd"
salesOrderType	Hardcoded to INITIAL	The Purchase Order Type
salesOrderStatus	Hardcoded to CREATED	The Sales order status
orderCurrency	Hardcoded to USD	The Currency Code
id	Hardcoded to null	The Order Customer Id
partyRoleType	Hardcoded to Customer	The Party role Type
id	Hardcoded to null	The Party Id
partyType	Hardcoded to Individual	The Party Type
personName	Heading."0110_Segment_group_2"."0210_Segment_group_5"[0]."0220_CTA".CTA0202[0]	The Customer Name
id	Hardcoded to null	The contact point Id
contactPointType	ContactPointEmail	The contactPoints Email
emailAddress	Heading."0110_Segment_group_2"."0210_Segment_group_5"[0]."0230_COM"[0].COM0101[1]	The party emailAddress
activeFromDate	Todays Date	The date format "YYYY-MM-DD"
customerStatus	ACTIVE	The Customer Status
soldToCustomer	Hardcoded to 1001252	The unique customer Id (SAP)
PurchaseOrderByCustomer	Hardcoded to PO Number	The Purchase made by customer
id	PO Number ++ PONumberLineItemID	The orderLine items Id
description	Detail."1040_IMD".IMD0304[0]	The Product description
orderedQuantity	Detail."1060_QTY".QTY0102[0]	The Order quantity
unitPriceAmount	Detail."1280_Segment_group_32"."1290_PRI".PRI0102[0]	The Product List Price
totalPriceAmount	v010PO1Loop."010_PO1".PO104 * v010PO1Loop."010_PO1".PO102	The Total totalPriceAmount
quantityOrderedUOM	Hardcoded to UNIT	The Quantity Measure Type
orderProductNumber	Detail."1020_LIN".LIN0301	The Product Id

X12 PO ACK Mapping

EDISegments-fields SAP Description of source field
TransactionSets-BAK01 Hardcoded to 00 The Invoice Document date format: "YYYY-MM-dd"
TransactionSets-BAK02 Hardcoded to AT The Supplier Invoice Id
TransactionSets-BAK03 ROOT.ORDER_CONFIRMATION.PURCHASE_ORDER_ID The Purchase Order Id
TransactionSets-BAK04 Todays Date date format : "YYYY-MM-dd"
TransactionSets-DTM01 Hardcoded to 003 The date time qualifier
TransactionSets-DTM02 ROOT.ROOT.ORDER_CONFIRMATION.REQUESTED_DELIVERY_DATE The order requested date
TransactionSets-DTM03 Hardcoded to 000000 date format : "YYYY-MM-dd"
Detail-PO101 PURCHASE_ORDER_ITEM_ID Assigned Identification
Detail-PO102 REQUESTED_QUANTITY.CONTENT Quantity Ordered
Detail-PO103 REQUESTED_QUANTITY.UNIT_CODE Unit of Measure
Detail-PO106 Hardcoded to BP The Code indicating the format of a description
Detail-PO107 SALES_ORDER_ITEM_ID The Code indicating the format of a description
Detail-REF01 Hardcoded to PO The Code qualifying the Reference Identification
Detail-REF02 ORDER_CONFIRMATION.PURCHASE_ORDER_ID The Code qualifying the Reference Identification
Detail-N101 PARTY_TYPE Entity Identification Code
Detail-N103 Hardcoded to 92 Identification Code Qualifier
Detail-N301 ADDRESS.ADDRESS_NAME The Address name
Detail-N401 ADDRESS.CITY_NAME The Street address name
Detail-N402 ADDRESS.REGION The Region name
Detail-N403 ADDRESS.POSTAL_CODE The Postal code
Summary-CTT01 ROOT.ORDER_CONFIRMATION.ITEM.EDI_SALES_ORDER_CONF_ITEM The list of Items in Invoice

EDISegments-fields	SAP	Description of source field
TransactionSets-BAK01	Hardcoded to 00	The Invoice Document date format: "YYYY-MM-dd"
TransactionSets-BAK02	Hardcoded to AT	The Supplier Invoice Id
TransactionSets-BAK03	ROOT.ORDER_CONFIRMATION.PURCHASE_ORDER_ID	The Purchase Order Id
TransactionSets-BAK04	Todays Date	date format : "YYYY-MM-dd"
TransactionSets-DTM01	Hardcoded to 003	The date time qualifier
TransactionSets-DTM02	ROOT.ROOT.ORDER_CONFIRMATION.REQUESTED_DELIVERY_DATE	The order requested date
TransactionSets-DTM03	Hardcoded to 000000	date format : "YYYY-MM-dd"
Detail-PO101	PURCHASE_ORDER_ITEM_ID	Assigned Identification
Detail-PO102	REQUESTED_QUANTITY.CONTENT	Quantity Ordered
Detail-PO103	REQUESTED_QUANTITY.UNIT_CODE	Unit of Measure
Detail-PO106	Hardcoded to BP	The Code indicating the format of a description
Detail-PO107	SALES_ORDER_ITEM_ID	The Code indicating the format of a description
Detail-REF01	Hardcoded to PO	The Code qualifying the Reference Identification
Detail-REF02	ORDER_CONFIRMATION.PURCHASE_ORDER_ID	The Code qualifying the Reference Identification
Detail-N101	PARTY_TYPE	Entity Identification Code
Detail-N103	Hardcoded to 92	Identification Code Qualifier
Detail-N301	ADDRESS.ADDRESS_NAME	The Address name
Detail-N401	ADDRESS.CITY_NAME	The Street address name
Detail-N402	ADDRESS.REGION	The Region name
Detail-N403	ADDRESS.POSTAL_CODE	The Postal code
Summary-CTT01	ROOT.ORDER_CONFIRMATION.ITEM.EDI_SALES_ORDER_CONF_ITEM	The list of Items in Invoice

EDIFACT PO ACK Mapping

EDISegments-fields SAP Description of source field
Interchange-UNB HardCoded to Default Values Interchange EDIFACT Header
Heading-0020-BGM.BGM0201 ROOT.ORDER_CONFIRMATION.PURCHASE_ORDER_ID The Purchase Order Id
Heading-0030-DTM.DTM102 Todays Date Date Format "yyyyMMdd"
Heading-0080_Segment_group_1.0100_DTM Todays Date Date Format "yyyyMMdd"
Heading-0140_Segment_group_3.NAD0201 Hard Coded to MYTHICAL Supplier Ref ID
Heading-0310_Segment_group_8.CUX02 Hard Coded to USD Currency
Detail-0960_Segment_group_26.0970_LIN.LIN0301 ORDER_CONFIRMATION.ITEM.EDI_SALES_ORDER_CONF_ITEM.PRODUCT.SUPPLIER_PRODUCT_ID Supplier Product ID
Detail-0960_Segment_group_26.0970_LIN.LIN0302 ORDER_CONFIRMATION.ITEM.EDI_SALES_ORDER_CONF_ITEM.SALES_ORDER_ITEM_CATEGORY Sales Order Item Category
Detail-0960_Segment_group_26.1300_Segment_group_31.1310_RFF ROOT.ORDER_CONFIRMATION.PURCHASE_ORDER_ID Order PO ID

EDISegments-fields	SAP	Description of source field
Interchange-UNB	HardCoded to Default Values	Interchange EDIFACT Header
Heading-0020-BGM.BGM0201	ROOT.ORDER_CONFIRMATION.PURCHASE_ORDER_ID	The Purchase Order Id
Heading-0030-DTM.DTM102	Todays Date	Date Format "yyyyMMdd"
Heading-0080_Segment_group_1.0100_DTM	Todays Date	Date Format "yyyyMMdd"
Heading-0140_Segment_group_3.NAD0201	Hard Coded to MYTHICAL	Supplier Ref ID
Heading-0310_Segment_group_8.CUX02	Hard Coded to USD	Currency
Detail-0960_Segment_group_26.0970_LIN.LIN0301	ORDER_CONFIRMATION.ITEM.EDI_SALES_ORDER_CONF_ITEM.PRODUCT.SUPPLIER_PRODUCT_ID	Supplier Product ID
Detail-0960_Segment_group_26.0970_LIN.LIN0302	ORDER_CONFIRMATION.ITEM.EDI_SALES_ORDER_CONF_ITEM.SALES_ORDER_ITEM_CATEGORY	Sales Order Item Category
Detail-0960_Segment_group_26.1300_Segment_group_31.1310_RFF	ROOT.ORDER_CONFIRMATION.PURCHASE_ORDER_ID	Order PO ID

X12 Shipping Notice Mapping

EDISegments-fields SAP Description of source field
TransactionSets-BSN01 Hardcoded to 00 Code indicating purpose of transaction set
TransactionSets-BSN02 Delivery.DeliveryDocument Unique number to identify specific shipment
TransactionSets-BSN03 CreationDateTime Transaction set created date
TransactionSets-BSN04 CreationDateTime Transaction set created time
TransactionSets-DTM01 Hardcoded to 011 Code indicating type of date or time or both
TransactionSets-DTM02 CreationDateTime Code indicating Date
TransactionSets-DTM03 CreationDateTime Code indicating Time
Detail-HL01 DeliveryItem.DeliveryDocumentItem Unique number to identify data segment
Detail-HL03 Hardcoded to S Code indicating Hierarchical Level
Detail-LIN02 EN Code identifying product ID
Detail-LIN03 DeliveryItem.Material.SupplierProductID Identifying number for a product
Detail-SN102 DeliveryItem.ActualDeliveryQuantity.Content Number of units shipped
Detail-SN103 DeliveryItem.ActualDeliveryQuantity.UnitCode Code specifying the measurement for units
Detail-PRF01 DeliveryItem.ReferenceSDDocument Purchase Order number
Detail-PRF04 CreationDateTime Code indicating Date
Detail-PID01 Hardcoded to F Code indicating the format of Product Description
Detail-TD101 Hardcoded to BOX Code indicating the type of packaging
Detail-TD102 DeliveryItem.ActualDeliveryQuantity.Content Code specifying the number of units
Detail-TD501 Hardcoded to B Code specifying the relationship of carrier to shipment movement
Detail-TD502 Hardcoded to 2 Identification code qualifier
Detail-TD503 DeliveryItem.Material.SupplierProductID Code identifying a party or other code
Detail-TD504 Hardcoded to A Code indicating Transportation method
Detail-REF01 Hardcoded to BM Code for reference indication
Detail-REF02 DeliveryItem.ReferenceSDDocument Code for reference indication
Detail-MAN01 Party.PartyType Code indicating party type
Detail-MAN02 DeliveryItem.Material.SupplierProductID Code indicating supplier Product ID
Detail-FOB01 Hardcoded to BP Code indicating shipment method of payment
Detail-N101 Party.PartyType Code identifying an entity or physical location
Detail-N102 Address.AddressName Free form name
Detail-N103 Hardcoded to 1 Identification code qualifier
Detail-N104 Party.SupplierPartyID Code identifying a party or other code
Summary-CTT01 Delivery.DeliveryItem Sum of delivery items in the delivery

EDISegments-fields	SAP	Description of source field
TransactionSets-BSN01	Hardcoded to 00	Code indicating purpose of transaction set
TransactionSets-BSN02	Delivery.DeliveryDocument	Unique number to identify specific shipment
TransactionSets-BSN03	CreationDateTime	Transaction set created date
TransactionSets-BSN04	CreationDateTime	Transaction set created time
TransactionSets-DTM01	Hardcoded to 011	Code indicating type of date or time or both
TransactionSets-DTM02	CreationDateTime	Code indicating Date
TransactionSets-DTM03	CreationDateTime	Code indicating Time
Detail-HL01	DeliveryItem.DeliveryDocumentItem	Unique number to identify data segment
Detail-HL03	Hardcoded to S	Code indicating Hierarchical Level
Detail-LIN02	EN	Code identifying product ID
Detail-LIN03	DeliveryItem.Material.SupplierProductID	Identifying number for a product
Detail-SN102	DeliveryItem.ActualDeliveryQuantity.Content	Number of units shipped
Detail-SN103	DeliveryItem.ActualDeliveryQuantity.UnitCode	Code specifying the measurement for units
Detail-PRF01	DeliveryItem.ReferenceSDDocument	Purchase Order number
Detail-PRF04	CreationDateTime	Code indicating Date
Detail-PID01	Hardcoded to F	Code indicating the format of Product Description
Detail-TD101	Hardcoded to BOX	Code indicating the type of packaging
Detail-TD102	DeliveryItem.ActualDeliveryQuantity.Content	Code specifying the number of units
Detail-TD501	Hardcoded to B	Code specifying the relationship of carrier to shipment movement
Detail-TD502	Hardcoded to 2	Identification code qualifier
Detail-TD503	DeliveryItem.Material.SupplierProductID	Code identifying a party or other code
Detail-TD504	Hardcoded to A	Code indicating Transportation method
Detail-REF01	Hardcoded to BM	Code for reference indication
Detail-REF02	DeliveryItem.ReferenceSDDocument	Code for reference indication
Detail-MAN01	Party.PartyType	Code indicating party type
Detail-MAN02	DeliveryItem.Material.SupplierProductID	Code indicating supplier Product ID
Detail-FOB01	Hardcoded to BP	Code indicating shipment method of payment
Detail-N101	Party.PartyType	Code identifying an entity or physical location
Detail-N102	Address.AddressName	Free form name
Detail-N103	Hardcoded to 1	Identification code qualifier
Detail-N104	Party.SupplierPartyID	Code identifying a party or other code
Summary-CTT01	Delivery.DeliveryItem	Sum of delivery items in the delivery

EDIFACT Shipping Notice Mapping

EDISegments-fields SAP Description of source field
Heading-0020_BGM.BGM0201 Root.Delivery.DeliveryDocument Delivery Document Number
Heading-0100_Segment_group_2.0110_NAD.NA01 Hard Coded to ST Address Type Code
Heading-0100_Segment_group_2.0110_NAD.NA0301 Root.Delivery.Party.Address.AddressName Delivery Address Name
Heading-0100_Segment_group_2.0110_NAD.NA0401 Root.Delivery.Party.Address.AddressName Delivery Address Name
Heading-0100_Segment_group_2.0110_NAD.NA0501 Root.Delivery.Party.Address.StreetName Address Street Name
Heading-0100_Segment_group_2.0110_NAD.NA0502 Root.Delivery.Party.Address.StreetAddressName Address Street Address Name
Heading-0100_Segment_group_2.0110_NAD.NA06 Root.Delivery.Party.Address.CityName Address City Name
Heading-0100_Segment_group_2.0110_NAD.NA07 Root.Delivery.Party.Address.Country Address City Country
Heading-0100_Segment_group_2.0110_NAD.NA08 Root.Delivery.Party.Address.PostalCode Address Postal Code upto 5 Digits
Heading-0100_Segment_group_2.0110_NAD.NA0305 Root.Delivery.Party.Address.PhoneNumber Address Recipient Phone Number

EDISegments-fields	SAP	Description of source field
Heading-0020_BGM.BGM0201	Root.Delivery.DeliveryDocument	Delivery Document Number
Heading-0100_Segment_group_2.0110_NAD.NA01	Hard Coded to ST	Address Type Code
Heading-0100_Segment_group_2.0110_NAD.NA0301	Root.Delivery.Party.Address.AddressName	Delivery Address Name
Heading-0100_Segment_group_2.0110_NAD.NA0401	Root.Delivery.Party.Address.AddressName	Delivery Address Name
Heading-0100_Segment_group_2.0110_NAD.NA0501	Root.Delivery.Party.Address.StreetName	Address Street Name
Heading-0100_Segment_group_2.0110_NAD.NA0502	Root.Delivery.Party.Address.StreetAddressName	Address Street Address Name
Heading-0100_Segment_group_2.0110_NAD.NA06	Root.Delivery.Party.Address.CityName	Address City Name
Heading-0100_Segment_group_2.0110_NAD.NA07	Root.Delivery.Party.Address.Country	Address City Country
Heading-0100_Segment_group_2.0110_NAD.NA08	Root.Delivery.Party.Address.PostalCode	Address Postal Code upto 5 Digits
Heading-0100_Segment_group_2.0110_NAD.NA0305	Root.Delivery.Party.Address.PhoneNumber	Address Recipient Phone Number

X12 Invoice Mapping

EDISegments-fields SAP Description of source field
TransactionSets-BIG01 INVOICE.DOCUMENT_DATE The Invoice Document date format: "YYYY-MM-dd"
TransactionSets-BIG02 INVOICE.SUPPLIER_INVOICE_ID The Supplier Invoice Id
TransactionSets-BIG03 INVOICE.DOCUMENT_DATE The Invoice Document date format: "YYYY-MM-dd"
TransactionSets-BIG04 INVOICE.SUPPLIER_INVOICE_ID The Supplier Invoice Id
Detail-FOB01 Hardcoded to PB Code identifying payment terms for transportation charges
Detail-CUR01 Hardcoded to US Location Code
Detail-CUR02 Hardcoded to USD The Currency Code
Detail-TXI01 Hardcoded to ST The Tax Information
Detail-PID01 Hardcoded to F The Code indicating the format of a description
Detail-REF01 Hardcoded to PO The Code qualifying the Reference Identification
Detail-REF01 Hardcoded to PO The Code qualifying the Reference Identification
Detail-DTM01 Hardcoded to 002 The time
Detail-DTM02 Todays Date Todays date format: "YYYY-MM-dd"
Detail-SAC01 Hardcoded to C Code indicates an for the service specified
Detail-N101 PARTY_TYPE The type of party type
Detail-N201 ADDRESS.ADDRESS_NAME The Address name
Detail-N301 ADDRESS.ADDRESS_NAME The Address name
Detail-N401 ADDRESS.CITY_NAME The Address City name
Detail-N402 ADDRESS.REGION The Region name
Detail-N403 ADDRESS.POSTAL_CODE The Postal code
Detail-N404 ADDRESS.COUNTRY The Country code
Detail-PER01 ADDRESS.COUNTRY Identifying the major duty
Summary-TDS01 GROSS_AMOUNT.CONTENT The GROSS_AMOUNT
Summary-TXI01 Hardcoded to ST The Tax Information
Summary-SAC01 Hardcoded to C Code indicates type of service specified
Summary-CTT01 INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM The list of Items in Invoice

EDISegments-fields	SAP	Description of source field
TransactionSets-BIG01	INVOICE.DOCUMENT_DATE	The Invoice Document date format: "YYYY-MM-dd"
TransactionSets-BIG02	INVOICE.SUPPLIER_INVOICE_ID	The Supplier Invoice Id
TransactionSets-BIG03	INVOICE.DOCUMENT_DATE	The Invoice Document date format: "YYYY-MM-dd"
TransactionSets-BIG04	INVOICE.SUPPLIER_INVOICE_ID	The Supplier Invoice Id
Detail-FOB01	Hardcoded to PB	Code identifying payment terms for transportation charges
Detail-CUR01	Hardcoded to US	Location Code
Detail-CUR02	Hardcoded to USD	The Currency Code
Detail-TXI01	Hardcoded to ST	The Tax Information
Detail-PID01	Hardcoded to F	The Code indicating the format of a description
Detail-REF01	Hardcoded to PO	The Code qualifying the Reference Identification
Detail-REF01	Hardcoded to PO	The Code qualifying the Reference Identification
Detail-DTM01	Hardcoded to 002	The time
Detail-DTM02	Todays Date	Todays date format: "YYYY-MM-dd"
Detail-SAC01	Hardcoded to C	Code indicates an for the service specified
Detail-N101	PARTY_TYPE	The type of party type
Detail-N201	ADDRESS.ADDRESS_NAME	The Address name
Detail-N301	ADDRESS.ADDRESS_NAME	The Address name
Detail-N401	ADDRESS.CITY_NAME	The Address City name
Detail-N402	ADDRESS.REGION	The Region name
Detail-N403	ADDRESS.POSTAL_CODE	The Postal code
Detail-N404	ADDRESS.COUNTRY	The Country code
Detail-PER01	ADDRESS.COUNTRY	Identifying the major duty
Summary-TDS01	GROSS_AMOUNT.CONTENT	The GROSS_AMOUNT
Summary-TXI01	Hardcoded to ST	The Tax Information
Summary-SAC01	Hardcoded to C	Code indicates type of service specified
Summary-CTT01	INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM	The list of Items in Invoice

EDIFACT Invoice Mapping

EDISegments-fields SAP Description of source field
Interchange-UNB0401 INVOICE.DOCUMENT_DATE The Invoice Document date format: "YYYY-MM-dd"
Heading-0020_BGM.BGM0201 INVOICE.SUPPLIER_INVOICE_ID Supplier Invoice ID
Detail-1030_Segment_group_26.1040_LIN.LIN01 ROOT.INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM.SUPPLIER_INVOICE_ITEM_ID Supplier Invoice Item ID
Detail-1030_Segment_group_26.1080_QTY.QTY0102 ROOT.INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM.INVOICED_QUANTITY Invoiced Quantity
Detail-1180_Segment_group_26.1190_MOA.MOA0102 ROOT.INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM.GROSS_AMOUNT.CONTENT Invoice Item's Gross Amount
Summary-2100_CNT.2100_CNT.CNT0102 ROOT.INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM Number of Invoice Items
Summary-2100_CNT.2120_MOA.MOA0102 ROOT.INVOICE.GROSS_AMOUNT.CONTENT Invoice Total Gross Amount

EDISegments-fields	SAP	Description of source field
Interchange-UNB0401	INVOICE.DOCUMENT_DATE	The Invoice Document date format: "YYYY-MM-dd"
Heading-0020_BGM.BGM0201	INVOICE.SUPPLIER_INVOICE_ID	Supplier Invoice ID
Detail-1030_Segment_group_26.1040_LIN.LIN01	ROOT.INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM.SUPPLIER_INVOICE_ITEM_ID	Supplier Invoice Item ID
Detail-1030_Segment_group_26.1080_QTY.QTY0102	ROOT.INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM.INVOICED_QUANTITY	Invoiced Quantity
Detail-1180_Segment_group_26.1190_MOA.MOA0102	ROOT.INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM.GROSS_AMOUNT.CONTENT	Invoice Item's Gross Amount
Summary-2100_CNT.2100_CNT.CNT0102	ROOT.INVOICE.ITEM.EDI_CUSTOMER_INVOICE_ITEM	Number of Invoice Items
Summary-2100_CNT.2120_MOA.MOA0102	ROOT.INVOICE.GROSS_AMOUNT.CONTENT	Invoice Total Gross Amount

X12 Payment / Remittance Mapping

CIM EDI Description of source field
paymentStatus Name The Payment Status
postingDate Interchange.ISA09 The Invoice posting date
paymentType Heading."020_BPR".BPR03 The Payment Type
authorizationProcessingMode Interchange.ISA03 Security Information Qualifier
paymentAmount "150_RMR".RMR04 The Payment Amount
netAppliedAmount Hardcoded to 0 The Net Applied value
balanceAmount Hardcoded to 0 The balance amount
totalAmount Hardcoded to 0 The total Amount
paymentEffectiveDate Interchange.ISA09 Date Format : "YYYY-MM-dd"
latestGatewayDate Interchange.ISA09 Date Format : "YYYY-MM-dd"
name Name Remittance Advice Accounts Receivable Open Item Reference
id "150_RMR".RMR02l The Invoice reference Document Id
account Hardcoded to SAP Customer ID Suppier Partner Customer ID

CIM	EDI	Description of source field
paymentStatus	Name	The Payment Status
postingDate	Interchange.ISA09	The Invoice posting date
paymentType	Heading."020_BPR".BPR03	The Payment Type
authorizationProcessingMode	Interchange.ISA03	Security Information Qualifier
paymentAmount	"150_RMR".RMR04	The Payment Amount
netAppliedAmount	Hardcoded to 0	The Net Applied value
balanceAmount	Hardcoded to 0	The balance amount
totalAmount	Hardcoded to 0	The total Amount
paymentEffectiveDate	Interchange.ISA09	Date Format : "YYYY-MM-dd"
latestGatewayDate	Interchange.ISA09	Date Format : "YYYY-MM-dd"
name	Name	Remittance Advice Accounts Receivable Open Item Reference
id	"150_RMR".RMR02l	The Invoice reference Document Id
account	Hardcoded to SAP Customer ID	Suppier Partner Customer ID

EDIFACT Payment / Remittance Mapping

CIM EDI Description of source field
paymentStatus Heading."0020_BGM".BGM0201[0] The Payment Status
postingDate Heading."0030_DTM"[0].DTM0102[0] The Invoice posting date
paymentType Hard Coded to Empty String The Payment Type
authorizationProcessingMode Hard Coded to Empty String Security Information Qualifier
paymentAmount Details."0190_MOA"[0].MOA0102 The Payment Amount
netAppliedAmount Hardcoded to 0 The Net Applied value
balanceAmount Hardcoded to 0 The balance amount
totalAmount Summary."0480_MOA"[0].MOA0102[0] The total Amount
paymentEffectiveDate Details."0200_DTM".DTM0102[0] Date Format : "YYYY-MM-dd"
latestGatewayDate Details."0200_DTM".DTM0102[0] Date Format : "YYYY-MM-dd"
name Details."0180_DOC".DOC0201 Remittance Advice Accounts Receivable Open Item Reference
id Heading."0020_BGM".BGM0201[0] The Invoice reference Document Id
account Hardcoded to SAP Customer ID Suppier Partner Customer ID

Type	Custom
Organization	MuleSoft
Published by	MuleSoft Solutions
Published on	Jul 11, 2022

Accelerator Anypoint Partner Manager EDI Mappings - Source

Mappings

X12 Purchase Order Mapping

EDIFACT Purchase Orders Mapping

X12 PO ACK Mapping

EDIFACT PO ACK Mapping

X12 Shipping Notice Mapping

EDIFACT Shipping Notice Mapping

X12 Invoice Mapping

EDIFACT Invoice Mapping

X12 Payment / Remittance Mapping

EDIFACT Payment / Remittance Mapping

Reviews

Asset versions for 1.2.x

CIM	EDI	Description of source field
paymentStatus	Heading."0020_BGM".BGM0201[0]	The Payment Status
postingDate	Heading."0030_DTM"[0].DTM0102[0]	The Invoice posting date
paymentType	Hard Coded to Empty String	The Payment Type
authorizationProcessingMode	Hard Coded to Empty String	Security Information Qualifier
paymentAmount	Details."0190_MOA"[0].MOA0102	The Payment Amount
netAppliedAmount	Hardcoded to 0	The Net Applied value
balanceAmount	Hardcoded to 0	The balance amount
totalAmount	Summary."0480_MOA"[0].MOA0102[0]	The total Amount
paymentEffectiveDate	Details."0200_DTM".DTM0102[0]	Date Format : "YYYY-MM-dd"
latestGatewayDate	Details."0200_DTM".DTM0102[0]	Date Format : "YYYY-MM-dd"
name	Details."0180_DOC".DOC0201	Remittance Advice Accounts Receivable Open Item Reference
id	Heading."0020_BGM".BGM0201[0]	The Invoice reference Document Id
account	Hardcoded to SAP Customer ID	Suppier Partner Customer ID