Type = API Reference,; Topic = Multienterprise Information Network Tower (MINT), Transforms,;Persona = TraceLink Administrator, User,; Orchestration = Commerce, Transportation,; Function = Supply Chain, IT, Procurement,
Invoice inbound Link Action Transactions
The Link Action Invoice in an ERP system is a sales invoice that is generated and sent by a seller to a buyer (customer) after the goods have been shipped or services have been delivered. Invoice serves as a formal request for payment.
Netsuite ERP
The following are the Netsuite ERP attributes that are mapped with the Canonical attributes and their output path.
- Transform Name:
- STD_Transform_MPL_Netsuite_Invoice_IB_V1
Guidelines
| Netsuite Field Input Element | Mapped Canonical Output | Target Output Element | Mapping Rules | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| JSON | - | - | - | ||||||||
| CONSTANT[id] | - | id | Hard code "57cd4683-2287-4b9e-9b13-29068be3a9e8" to Target | ||||||||
| CONSTANT[schemaId] | - | schemaId | Hard code "multienterprise-process-connect_canonicalInvoice" to Target | ||||||||
| CONSTANT[objectType] | - | objectType | Hard code "multienterprise-process-connect_canonicalInvoice" to Target | ||||||||
| CONSTANT[schemaVersion] | - | schemaVersion | Hard code "1" to Target | ||||||||
| CONSTANT[processingFunctionTypeCode] | #data/messageBody/canonicalInvoiceHeader
|
processingFunctionTypeCode | Hard code "CREATE" to target | ||||||||
| CONSTANT[b2bTransactionTypeName] | #/data/controlFileHeader
|
b2bTransactionTypeName | Hard code "MPC_INVOICE" to target data element | ||||||||
| account | - | - | - | ||||||||
| fullName | #data/messageBody/canonicalInvoiceHeader/bankInfo
|
accountHolderName | Move source to target | ||||||||
| location | - | - | - | ||||||||
| mainAddress | - | - | - | ||||||||
| city | #data/messageBody/canonicalInvoiceHeader/bankInfo
|
city | Move source to target | ||||||||
| country | #data/messageBody/canonicalInvoiceHeader/bankInfo/country
|
country | Move source to target | ||||||||
| sBankCompanyId | #data/messageBody/canonicalInvoiceHeader/bankInfo/accountNumber
|
accountNumber | Move source to target | ||||||||
| sBankName | #data/messageBody/canonicalInvoiceHeader/bankInfo/bankName
|
bankName | Move source to target | ||||||||
| sBankRoutingNumber | #data/messageBody/canonicalInvoiceHeader/bankInfo
|
bankIdentifier | Move source to target | ||||||||
| amountPaid | - | - | - | ||||||||
| amountRemaining | - | - | - | ||||||||
| amountRemainingTotalBox | - | - | - | ||||||||
| billAddress | - | - | - | ||||||||
| billAddressList | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| billingAddress | - | - | - | ||||||||
| addr1 | #data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
address1 | Move source to target | ||||||||
| addr2 | #data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
address2 | Move source to target | ||||||||
| addressee | #data/messageBody/canonicalInvoiceHeader/billToBusinessInformation
|
businessName | Move source to target | ||||||||
| addrPhone | #data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
telephone | Move source to target | ||||||||
| addrText | - | - | - | ||||||||
| city | #data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
city | Move source to target | ||||||||
| country | - | - | - | ||||||||
| id | #data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
country | Move source to target | ||||||||
| refName | - | - | - | ||||||||
| override | - | - | - | ||||||||
| state | #data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
state | Move source to target | ||||||||
| zip | #data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
postalCode | Move source to target | ||||||||
| billingAddress_text | - | - | - | ||||||||
| canHaveStackable | - | - | - | ||||||||
| class | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| CONSTANT[CREATEDON] | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateType | Hardcode "CREATEDON" to target | ||||||||
| createdDate | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateValue | Move source to target if dateType=CREATEDON | ||||||||
| createdFrom | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| currency | - | - | - | ||||||||
| currencyPrecision | - | - | - | ||||||||
| displaySymbol | - | - | - | ||||||||
| exchangeRate | #data/messageBody/canonicalInvoiceHeader/invoiceCurrency
|
exchangeRate | Move source to target | ||||||||
| formatSample | - | - | - | ||||||||
| id | - | - | - | ||||||||
| isBaseCurrency | - | - | - | ||||||||
| isInactive | - | - | - | ||||||||
| lastModifiedDate | - | - | - | ||||||||
| locale | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| name | - | - | - | ||||||||
| overrideCurrencyFormat | - | - | - | ||||||||
| symbol | #data/messageBody/canonicalInvoiceHeader/invoiceCurrency
|
exchangeRateCurrencyCode | Move source to target | ||||||||
| symbolPlacement | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| customForm | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| department | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| discountAmount | - | - | - | ||||||||
| discountDate | - | - | - | ||||||||
| discountTotal | - | - | - | ||||||||
| CONSTANT[DUEDATE] | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateType | Hardcode "DUEDATE" to target | ||||||||
| dueDate | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateValue | Move source to target if dateType=DUEDATE | ||||||||
| CONSTANT[ENDDATE] | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateType | Hardcode "ENDDATE" to target | ||||||||
| endDate | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateValue | Move source to target if dateType=ENDDATE | ||||||||
| entity | - | - | - | ||||||||
| addressBook | - | - | - | ||||||||
| items | - | - | - | ||||||||
| addressBookAddress | - | - | - | ||||||||
| addr1 | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
address1 | Move source to target | ||||||||
| addr2 | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
address2 | Move source to target | ||||||||
| addressee | - | - | - | ||||||||
| addrPhone | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
telephone | Move source to target | ||||||||
| addrText | - | - | - | ||||||||
| city | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
city | Move source to target | ||||||||
| country | - | - | - | ||||||||
| id | id | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
country | Move source to target | |||||||
| refName | refName | - | - | - | |||||||
| override | - | - | - | ||||||||
| state | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
state | Move source to target | ||||||||
| zip | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
postalCode | Move source to target | ||||||||
| fax | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
fax | Move source to target | ||||||||
| url | - | - | - | ||||||||
| addressBookAddress_text | - | - | - | ||||||||
| addressId | - | - | - | ||||||||
| defaultBilling | - | - | - | ||||||||
| defaultShipping | - | - | - | ||||||||
| id | - | - | - | ||||||||
| internalId | - | - | - | ||||||||
| isResidential | - | - | - | ||||||||
| label | - | - | - | ||||||||
| totalResults | - | - | - | ||||||||
| aging | - | - | - | ||||||||
| aging1 | - | - | - | ||||||||
| aging2 | - | - | - | ||||||||
| aging3 | - | - | - | ||||||||
| aging4 | - | - | - | ||||||||
| alcoholRecipientType | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| balance | - | - | - | ||||||||
| companyName | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation
|
businessName | Move source to target | ||||||||
| contact | - | - | - | ||||||||
| category | - | - | - | ||||||||
| title | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/companyLocationContactInformation
|
contactTitle | Move source to target | ||||||||
| comments | - | - | Do not Map | ||||||||
| company | - | - | Do not Map | ||||||||
| id | - | - | Do not Map | ||||||||
| refName | - | - | Do not Map | ||||||||
| contactSource | - | - | Do not Map | ||||||||
| id | - | - | Do not Map | ||||||||
| refName | - | - | Do not Map | ||||||||
| customForm | - | - | Do not Map | ||||||||
| id | - | - | Do not Map | ||||||||
| refName | - | - | Do not Map | ||||||||
| dateCreated | - | - | Do not Map | ||||||||
#data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/companyLocationContactInformation
|
contactEmail | Move source to target | |||||||||
| entityId | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/companyLocationContactInformation
|
contactName | Move source to target | ||||||||
| firstName | - | - | Do not Map | ||||||||
| id | - | - | Do not Map | ||||||||
| isInactive | - | - | Do not Map | ||||||||
| isPrivate | - | - | Do not Map | ||||||||
| lastModifiedDate | - | - | Do not Map | ||||||||
| lastName | - | - | Do not Map | ||||||||
| mobilePhone | - | - | Do not Map | ||||||||
| owner | - | - | Do not Map | ||||||||
| phone | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/companyLocationContactInformation
|
contactPhone | Move source to target | ||||||||
| salutation | - | - | - | ||||||||
| subsidiary | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| contactList | - | - | - | ||||||||
| count | - | - | - | ||||||||
| hasMore | - | - | - | ||||||||
| items | - | - | - | ||||||||
| offset | - | - | - | ||||||||
| totalResults | - | - | - | ||||||||
| contactRoles | - | - | - | ||||||||
| creditHoldOverride | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| currency | - | - | - | ||||||||
| currencyPrecision | - | - | - | ||||||||
| displaySymbol | - | - | - | ||||||||
| exchangeRate | - | - | - | ||||||||
| formatSample | - | - | - | ||||||||
| id | - | - | - | ||||||||
| isBaseCurrency | - | - | - | ||||||||
| isInactive | - | - | - | ||||||||
| lastModifiedDate | - | - | - | ||||||||
| locale | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| name | - | - | - | ||||||||
| overrideCurrencyFormat | - | - | - | ||||||||
| symbol | - | - | - | ||||||||
| symbolPlacement | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| currencyList | - | - | - | ||||||||
| customForm | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| dateCreated | - | - | - | ||||||||
| daysOverdue | - | - | - | ||||||||
| defaultAddress | - | - | - | ||||||||
| depositBalance | - | - | - | ||||||||
| emailPreference | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| emailTransactions | - | - | - | ||||||||
| entityId | - | - | - | ||||||||
| entityStatus | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| externalId | #data/controlFileHeader
|
fileReceiverNumber | Move source to target | ||||||||
| CONSTANT[COMPANYID] | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierType | Hardcode "COMPANYID" | ||||||||
| externalId[2] | #data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | Move source to target where companyIdentifierType="COMPANYID" | ||||||||
| externalId[3] | #data/controlFileHeader
|
linkIdentifier |
Required value. Identifies application, sender and receiver: concatenate MPC + ".COMPANYID:" +vendor/externalId + ".COMPANYID:" + entity/externalId to linkIdentifier |
||||||||
| fax | - | - | - | ||||||||
| faxTransactions | - | - | - | ||||||||
| giveAccess | - | - | - | ||||||||
| groupPricing | - | - | - | ||||||||
| id | - | - | - | ||||||||
| isBudgetApproved | - | - | - | ||||||||
| isInactive | - | - | - | ||||||||
| isPerson | - | - | - | ||||||||
| itemPricing | - | - | - | ||||||||
| language | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| lastModifiedDate | - | - | - | ||||||||
| overdueBalance | - | - | - | ||||||||
| phone | - | - | - | ||||||||
| printTransactions | - | - | - | ||||||||
| receivablesAccount | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| sendEmail | - | - | - | ||||||||
| shipComplete | - | - | - | ||||||||
| shippingCarrier | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| subsidiary | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| terms | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| unbilledOrders | - | - | - | ||||||||
| exchangeRate | - | - | - | ||||||||
| expCost | - | - | - | ||||||||
| fob | - | - | - | ||||||||
| handlingCost | - | - | - | ||||||||
| id | - | - | - | ||||||||
| item | - | - | - | ||||||||
| items | - | - | - | ||||||||
| account | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| amount | #data/messageBody/canonicalInvoiceItemDetails/invoicePricing
|
pricingAmount | Move source to target | ||||||||
| description | #data/messageBody/canonicalInvoiceItemDetails/productItemInformation
|
productDescription | Move source to target | ||||||||
| excludeFromRateRequest | - | - | - | ||||||||
| item | - | - | - | ||||||||
| assetAccount | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| atpMethod | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| averageCost | - | - | - | ||||||||
| baseUnit | - | - | - | ||||||||
| class | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| cogsAccount | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| contingentRevenueHandling | - | - | - | ||||||||
| correlatedItems | - | - | - | ||||||||
| costingMethod | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| countryOfManufacture | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| createdDate | - | - | - | ||||||||
| createRevenuePlansOn | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| currency | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| customForm | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| deferredRevenueAccount | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| deferRevRec | - | - | - | ||||||||
| department | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| directRevenuePosting | - | - | - | ||||||||
| displayName | #data/messageBody/canonicalInvoiceItemDetails/productItemInformation
|
productName | - | ||||||||
| enforceminqtyinternally | - | - | - | ||||||||
| excludeFromSiteMap | - | - | - | ||||||||
| froogleProductFeed | - | - | - | ||||||||
| id | - | - | - | ||||||||
| includeChildren | - | - | - | ||||||||
| incomeAccount | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| internalId | - | - | - | ||||||||
| isGCoCompliant | - | - | - | ||||||||
| isInactive | - | - | - | ||||||||
| isOnline | - | - | - | ||||||||
| CONSTANT | #data/messageBody/canonicalInvoiceItemDetails/productCodesIdentifiers
|
productCodeType | Move "SUPPLIER" to target | ||||||||
| itemId | #data/messageBody/canonicalInvoiceItemDetails/productCodesIdentifiers
|
productCodeValue | - | ||||||||
| itemType | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| itemVendor | - | - | - | ||||||||
| lastModifiedDate | - | - | - | ||||||||
| lastPurchasePrice | - | - | - | ||||||||
| locations | - | - | - | ||||||||
| manufacturer | - | - | - | ||||||||
| matchBillToReceipt | - | - | - | ||||||||
| nexTagProductFeed | - | - | - | ||||||||
| presentationItem | - | - | - | ||||||||
| price | - | - | - | ||||||||
| purchaseUnit | - | - | - | ||||||||
| revenueRecognitionRule | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| revRecForecastRule | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| saleUnit | - | - | - | ||||||||
| shipIndividually | - | - | - | ||||||||
| shoppingProductFeed | - | - | - | ||||||||
| shopzillaProductFeed | - | - | - | ||||||||
| siteCategory | - | - | - | ||||||||
| stockUnit | - | - | - | ||||||||
| subsidiary | - | - | - | ||||||||
| supplyReplenishmentMethod | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| totalValue | - | - | - | ||||||||
| transferPriceUnits | - | - | - | ||||||||
| translations | - | - | - | ||||||||
| unitsType | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| useMarginalRates | - | - | - | ||||||||
| VSOEDelivered | - | - | - | ||||||||
| VSOESopGroup | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| weight | - | - | - | ||||||||
| weightUnit | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| weightUnits | - | - | - | ||||||||
| yahooProductFeed | - | - | - | ||||||||
| itemType | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| line | #data/messageBody/canonicalInvoiceItemDetails
|
lineItemNumber | Move source to target | ||||||||
| marginal | - | - | - | ||||||||
| orderDoc | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| orderLine | - | - | - | ||||||||
| price | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| printItems | - | - | - | ||||||||
| CONSTANT | #data/messageBody/canonicalInvoiceItemDetails/itemQuantity
|
quantityType | Move "INVOICE" to target | ||||||||
| quantity | #data/messageBody/canonicalInvoiceItemDetails/itemQuantity
|
quantityValue | Move source to target | ||||||||
| quantityAvailable | - | - | - | ||||||||
| rate | #data/messageBody/canonicalInvoiceItemDetails/invoicePricing
|
unitPriceBasisQuantity | Move source to target | ||||||||
| units | #data/messageBody/canonicalInvoiceItemDetails/itemQuantity
|
unitOfMeasure | Move source to target | ||||||||
| totalResults | - | - | - | ||||||||
| itemCost | - | - | - | ||||||||
| lastModifiedDate | - | - | - | ||||||||
| linkedTrackingNumbers | - | - | - | ||||||||
| location | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| memo | - | - | - | ||||||||
| otherRefNum | - | - | - | ||||||||
| partner | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| postingPeriod | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| prevDate | - | - | - | ||||||||
| salesEffectiveDate | - | - | - | ||||||||
| shipAddress | - | - | - | ||||||||
| shipAddressList | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| CONSTANT[SHIPPED] | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateType | Hardcode "SHIPPED" to target | ||||||||
| shipDate | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateValue | Move source to target if dateType="SHIPPED" | ||||||||
| shipIsResidential | - | - | - | ||||||||
| shipOverride | - | - | - | ||||||||
| shippingAddress | - | - | - | ||||||||
| addr1 | #data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address
|
address1 | Move source to target | ||||||||
| addr2 | #data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address
|
address2 | Move source to target | ||||||||
| addressee | #data/messageBody/canonicalInvoiceHeader/shipToLocationInformation
|
businessName | Move source to target | ||||||||
| addrPhone | #data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address
|
telephone | Move source to target | ||||||||
| addrText | - | - | - | ||||||||
| city | #data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address
|
city | Move source to target | ||||||||
| country | - | - | - | ||||||||
| id | #data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address
|
country | Move source to target | ||||||||
| refName | - | - | - | ||||||||
| override | - | - | - | ||||||||
| state | #data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address
|
state | Move source to target | ||||||||
| zip | #data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address
|
postalCode | Move source to target | ||||||||
| fax | - | - | - | ||||||||
| url | - | - | - | ||||||||
| shippingAddress_text | - | - | - | ||||||||
| shippingCostOverridden | - | - | - | ||||||||
| CONSTANT[STARTDATE] | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateType | Hardcode "STARTDATE" to target | ||||||||
| startDate | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateValue | Move source to target if dateType=STARTDATE | ||||||||
| status | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| subsidiary | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| subtotal | - | - | - | ||||||||
| taxDetails | - | - | - | ||||||||
| items | - | - | - | ||||||||
| taxAmount | #data/messageBody/canonicalInvoiceHeader/taxes
|
taxAmount | Move source to target | ||||||||
| taxCode | - | - | - | ||||||||
| taxType | - | - | - | ||||||||
| country | #data/messageBody/canonicalInvoiceHeader/taxes
|
country | Move source to target | ||||||||
| taxType | #data/messageBody/canonicalInvoiceHeader/taxes
|
taxType | Move source to target | ||||||||
| taxRate | #data/messageBody/canonicalInvoiceHeader/taxes
|
taxRate | Move source to target | ||||||||
| terms | - | - | - | ||||||||
| dateDriven | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| dayDiscountExpires | - | - | - | ||||||||
| dayOfMonthNetDue | - | - | - | ||||||||
| discountPercentDateDriven | #data/messageBody/canonicalInvoiceHeader/termsOfPayment
|
termsOfPaymentPercent | Move source to target | ||||||||
| dueNextMonthIfWithinDays | #data/messageBody/canonicalInvoiceHeader/termsOfPayment
|
numberOfDays | Move source to target | ||||||||
| id | - | - | Do not Map | ||||||||
| isInactive | - | - | Do not Map | ||||||||
| lastModifiedDate | - | - | Do not Map | ||||||||
| longitemtype | - | - | Do not Map | ||||||||
| name | #data/messageBody/canonicalInvoiceHeader/termsOfPayment
|
termsOfPaymentKey | Move source to target | ||||||||
| preferred | - | - | - | ||||||||
| tname | - | - | - | ||||||||
| time | - | - | - | ||||||||
| toBeEmailed | - | - | - | ||||||||
| toBeFaxed | - | - | - | ||||||||
| toBePrinted | - | - | - | ||||||||
| total | - | - | - | ||||||||
| trackingNumbers | - | - | - | ||||||||
| CONSTANT[INVOICE] | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateType | Hardcode "INVOICE" to target | ||||||||
| tranDate | #data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateValue | Move source to target if dateType=INVOICE | ||||||||
| tranId | - | - | - | ||||||||
| lastFetchTime | - | - | - | ||||||||
| vendor | - | - | - | ||||||||
| country | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| currency | - | - | - | ||||||||
| id | - | - | - | ||||||||
| refName | - | - | - | ||||||||
| - | - | - | |||||||||
| externalId[1] | #data/controlFileHeader
|
fileSenderNumber | Move source to target | ||||||||
| CONSTANT[COMPANYID] | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierType | Hardcode "COMPANYID" | ||||||||
| externalId[2] | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | Move source to target where companyIdentifierType="COMPANYID" | ||||||||
| externalId[3] | #data/controlFileHeader
|
linkIdentifier |
Required value. Identifies application, sender and receiver: concatenate MPC + ".COMPANYID:" +vendor/externalId + ".COMPANYID:" + entity/externalId to linkIdentifier |
||||||||
| id | - | - | - | ||||||||
| isElimination | - | - | - | ||||||||
| isInactive | - | - | - | ||||||||
| lastModifiedDate | - | - | - | ||||||||
| legalName | - | - | - | ||||||||
| mainAddress | - | - | - | ||||||||
| addr1 | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
address1 | Move source to target | ||||||||
| addr2 | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
address2 | Move source to target | ||||||||
| addressee | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation
|
businessName | Move source to target | ||||||||
| addrPhone | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
telephone | Move source to target | ||||||||
| addrText | - | - | - | ||||||||
| city | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
city | Move source to target | ||||||||
| country | - | - | - | ||||||||
| id | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
country | Move source to target | ||||||||
| refName | - | - | - | ||||||||
| override | - | - | - | ||||||||
| state | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
state | Move source to target | ||||||||
| zip | #data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
postalCode | Move source to target | ||||||||
| fax | - | - | - | ||||||||
| url | - | - | - | ||||||||
| name | - | - | - | ||||||||
| returnAddress | - | - | - | ||||||||
| shippingAddress | - | - | - | ||||||||
| state | - | - | - | ||||||||
Creatio ERP
The following are the Creatio ERP attributes that are mapped with the Canonical attributes and their output path.
- Transform Name:
- STD_Transform_MPL_Creatio_Invoice_IB_V1
Guidelines
| Input Element | Output Path | Output Element | Mapping Rules | ||
|---|---|---|---|---|---|
| Id | - | - | - | ||
| CreatedOn | - | - | - | ||
| CreatedById | - | - | - | ||
| ModifiedOn | - | - | - | ||
| ModifiedById | - | - | - | ||
| Number | - | - | - | ||
| Start Date | data/messageBody/canonicalInvoiceHeader/transactionReferenceIdentifierList(1)
|
transactionDate | Store literal value. b2bTransactionIdentifierType= INVOICE If inbound payload has has 0001-01-01T00:00:00Z value then do not map. | ||
data/messageBody/canonicalInvoiceHeader/transactionReferenceIdentifierList(1)
|
epochTransactionDate | Convert input to epoch format b2bTransactionIdentifierType= INVOICE If inbound payload has has 0001-01-01T00:00:00Z value then do not map. Miliseconds will be rounded off 000. | |||
data/messageBody/canonicalInvoiceHeader/invoiceDates |
dateValue | Store literal value. dateType=INVOICE | |||
data/messageBody/canonicalInvoiceHeader/invoiceDates
|
epochDateValue | Convert input to epoch format. dateType=INVOICE If inbound payload has has 0001-01-01T00:00:00Z value then do not map. Miliseconds will be rounded off 000. | |||
| UsrEDITermsBasis | - | - | - | ||
| Name | #/data/messageBody/canonicalInvoiceHeader/termsOfPayment
|
termsOfPaymentDateBasis | Convert from sourcepayload to canonical target using enum mapping worksheet if source present, else do not map. | ||
| AccountId | - | - | - | ||
| SupplierId | - | - | - | ||
| OrderId | - | - | - | ||
| Amount | #data/messageBody/canonicalInvoiceSummary
|
summaryValue | Store literal value where summaryType = TOTALAMOUNT | ||
| AmountWithoutTax | - | - | - | ||
| PrimaryAmountWithoutTax | - | - | - | ||
| DevatisTermsId | - | - | - | ||
| DevatisDueDate | - | - | - | ||
| DevatisPurchaseOrderDate | - | - | - | ||
| DevatisTrueCommerceInvoiceId | #/data/messageBody/canonicalInvoiceHeader/transactionReferenceIdentifierList(1)
|
b2bTransactionIdentifierValue | Store literal value b2bTransactionIdentifierType = "INVOICE" | ||
| DevatisIsValid | - | - | - | ||
| DevatisSupplierAddressId | - | - | - | ||
| DevatisShipperAddressId | - | - | - | ||
| UsrPurchaseOrderTypeDescription | data/messageBody/canonicalInvoiceHeader
|
invoiceType | Refer the enum list and map to canonical code | ||
| UsrEDIParentIDNumber | data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | If UsrEDIParentIDNumber is not empty move UsrEDIParentIDNumber to target else if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumber to target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target | ||
| UsrEDIParentIDType | - | - | - | ||
| Description | data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierType | if UsrEDIParentIDType.Description is not empty move UsrEDIParentIDType.Description to target else if DevatisParentAccount.DevatisIdentifcationType is not empty Move DevatisParentAccount.DevatisIdentifcationType to target | ||
| UsrEDICustomerIDNumber | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation/mpcCompanyLocationIdentiferList
|
compnayIdentiferValue | If UsrUsrEDICustomerIDNumber is not empty move UsrEDICustomerIDNumber to target else if Account.UsrNumber is not empty move Account.UsrNumber to target else if Account.DevatisIdentificationNumber is not empty move Account.DevatisIdentificationNumber to target | ||
| UsrEDICustomerIDType | |||||
| Description | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation/mpcCompanyLocationIdentiferList
|
compnayIdentiferType | if UsrEDICustomerIDType.Description is not empty move UsrEDICustomerIDType.Description to target else if Account.DevatisIdentifcationType is not empty Move Account.DevatisIdentifcationType to target | ||
| Account | - | - | - | ||
| Id | - | - | - | ||
| Name | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation
|
businessName | Store literal value | ||
| TypeId | - | - | - | ||
| Phone | - | - | - | ||
| AdditionalPhone | - | - | - | ||
| Fax | - | - | - | ||
| Web | - | - | - | ||
| AddressTypeId | - | - | - | ||
| Address | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation/address
|
address1 | Store literal value | ||
| CityId | - | - | - | ||
| RegionId | - | - | - | ||
| Zip | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation/address
|
postalCode | Store literal value | ||
| CountryId | - | - | - | ||
| CityName | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation/address
|
city | Store literal value | ||
| RegionCode | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation/address
|
state | Store literal value | ||
| CountryCode | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation/address
|
country | Store literal value | ||
| Notes | - | - | - | ||
| AlternativeName | - | - | - | ||
| GPSN | - | - | - | ||
| GPSE | - | - | - | ||
| Completeness | - | - | - | ||
| DevatisIdentificationNumber | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation/mpcCompnayLocationIdentiferList
|
compnayIdentiferValue | If UsrUsrEDICustomerIDNumber is not empty move UsrEDICustomerIDNumber to target else if Account.UsrNumber is not empty MoveAccount.UsrNumber to target else if Account.DevatisIdentificationNumber is not empty move Account.DevatisIdentificationNumber to target | ||
| DevatisIdentificationType | #/data/messageBody/canonicalInvoiceHeader/billToShipToBusinessInformation/mpcCompnayLocationIdentiferList
|
compnayIdentiferType | if UsrEDICustomerIDType.Description is not empty move UsrEDICustomerIDType.Description to target else if Account.DevatisIdentifcationType is not empty Move Account.DevatisIdentifcationType to target | ||
| UsrNumber | #/data/messageBody/canonicalInvoiceHeader/cBusinessInformation/mpcCompanyLocationIdentiferList
|
compnayIdentiferValue | If UsrUsrEDICustomerIDNumber is not empty move UsrEDICustomerIDNumber to target else if Account.UsrNumber is not empty MoveAccount.UsrNumber to target else if Account.DevatisIdentificationNumber is not empty move Account.DevatisIdentificationNumber to target | ||
| Supplier | - | - | - | ||
| Id | - | - | - | ||
| Name | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation
|
businessName | Store literal value | ||
#/data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation
|
businessName | Store literal value | |||
| OwnerId | - | - | - | ||
| CreatedOn | - | - | - | ||
| CreatedById | - | - | - | ||
| ModifiedOn | - | - | - | ||
| ModifiedById | - | - | - | ||
| Code | - | - | - | ||
| TypeId | - | - | - | ||
| Phone | - | - | - | ||
| AddressTypeId | - | - | - | ||
| Address | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address
|
address1 | Store literal value | ||
#/data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
address1 | Store literal value | |||
| CityId | - | - | - | ||
| - | - | - | |||
| RegionId | - | - | - | ||
| - | - | - | |||
| Zip | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address
|
postalCode | Store literal value | ||
#/data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
postalCode | Store literal value | |||
| CountryId | - | - | - | ||
| - | - | - | |||
| CityName | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address
|
city | Store literal value | ||
#/data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
city | Store literal value | |||
| RegionCode | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address
|
state | Store literal value | ||
#/data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
state | Store literal value | |||
| CountryCode | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address
|
country | Store literal value | ||
#/data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/address
|
country | Store literal value | |||
| DevatisIdentificationNumber | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | if Supplier.UsrNumber is not empty MoveSupplier.UsrNumber to target else if Supplier.DevatisIdentificationNumber is not empty move Supplier.DevatisIdentificationNumber to target | ||
#/data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | if Supplier.UsrNumber is not empty MoveSupplier.UsrNumber to target else if Supplier.DevatisIdentificationNumber is not empty move Supplier.DevatisIdentificationNumber to target | |||
| DevatisIdentificationTypeId | - | - | - | ||
| DevatisAddress2 | - | - | - | ||
| DevatisDiscount | - | - | - | ||
| DevatisEDIName | - | - | - | ||
| Logo@odata.mediaEditLink | - | - | - | ||
| Logo@odata.mediaReadLink | - | - | - | ||
| Logo@odata.mediaContentType | - | - | - | ||
| DevatisIdentificationType | #/data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierType | Store literal value | ||
#/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierType | Store literal value | |||
| UsrNumber | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | if Supplier.UsrNumber is not empty MoveSupplier.UsrNumber to target else if Supplier.DevatisIdentificationNumber is not empty move Supplier.DevatisIdentificationNumber to target | ||
#/data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | if Supplier.UsrNumber is not empty MoveSupplier.UsrNumber to target else if Supplier.DevatisIdentificationNumber is not empty move Supplier.DevatisIdentificationNumber to target | |||
#/data/controlFileHeader
|
fileSenderNumber | Supplier.DevatisIdentificationType +":"+ .Supplier.UsrNumber | |||
| Order | - | - | - | ||
| Id | - | - | - | ||
| CreatedOn | - | - | - | ||
| CreatedById | - | - | - | ||
| ModifiedOn | - | - | - | ||
| ModifiedById | - | - | - | ||
| Number | - | - | - | ||
| Date | #/data/messageBody/canonicalInvoiceHeader/transactionReferenceIdentifierList(2)
|
transactionDate | Store literal value b2bTransactionIdentifierType = PURCHASEORDER If inbound payload has has 0001-01-01T00:00:00Z value then do not map. | ||
#/data/messageBody/canonicalInvoiceHeader/transactionReferenceIdentifierList(2)
|
epochTransactionDate | Convert input to epoch format b2bTransactionIdentifierType = PURCHASEORDER If inbound payload has has 0001-01-01T00:00:00Z value then do not map. Miliseconds will be rounded off 000. | |||
#/data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateValue | Store literal value dateType = PURCHASEORDER If inbound payload has has 0001-01-01T00:00:00Z value then do not map. | |||
#/data/messageBody/canonicalInvoiceHeader/invoiceDates
|
epochDateValue | Convert input to epoch format. dateType = PURCHASEORDER If inbound payload has has 0001-01-01T00:00:00Z value then do not map. Miliseconds will be rounded off 000. | |||
| StatusId | - | - | - | ||
| PaymentStatusId | - | - | - | ||
| DeliveryStatusId | - | - | - | ||
| ActualDate | - | - | - | ||
| CurrencyId | - | - | - | ||
| CurrencyRate | - | - | - | ||
| Amount | - | - | - | ||
| PaymentAmount | - | - | - | ||
| PrimaryAmount | - | - | - | ||
| PrimaryPaymentAmount | - | - | - | ||
| SourceOrderId | - | - | - | ||
| DeliveryTypeId | - | - | - | ||
| PaymentTypeId | - | - | - | ||
| ReceiverName | - | - | - | ||
| Comment | - | - | - | ||
| DevatisParentAccountId | - | - | - | ||
| DevatisCustomerPurchaseOrderNumber | #/data/messageBody/canonicalInvoiceHeader/transactionReferenceIdentifierList(2)
|
b2bTransactionIdentifierValue | Store literal Value where b2bTransactionIdentifierType= PURCHASEORDER | ||
| DevatisLoadedOn | - | - | - | ||
| DevatisMemo | - | - | - | ||
| DevatisEDILocDescription | - | - | - | ||
| DevatisEDITerms | #/data/messageBody/canonicalInvoiceHeader/termsOfPayment
|
numberOfDays | 4th element in the string. Store literal Value | ||
#/data/messageBody/canonicalInvoiceHeader/termsOfPayment
|
termsOfPaymentPercent | 1st element in the string . Store literal Value | |||
#/data/messageBody/canonicalInvoiceHeader/termsOfPayment
|
discountDueNumberOfDays | 2nd element in the string.Store literal Value | |||
#/data/messageBody/canonicalInvoiceHeader/termsOfPayment
|
termsOfPaymentTypeCode | Hard Code to BASIC | |||
| UsrEDIParentIDNumber | - | - | - | ||
| UsrEDICustomerIDNumber | - | - | - | ||
| DevatisParentAccount | - | - | - | ||
| Id | - | - | - | ||
| Name | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation
|
businessName | Store literal Value | ||
data/messageBody/canonicalInvoiceHeader/billToBusinessInformation
|
businessName | Store literal Value | |||
| OwnerId | - | - | - | ||
| CreatedOn | - | - | - | ||
| CreatedById | - | - | - | ||
| ModifiedOn | - | - | - | ||
| ModifiedById | - | - | - | ||
| Code | - | - | - | ||
| Phone | - | - | - | ||
| AdditionalPhone | - | - | - | ||
| Fax | - | - | - | ||
| Web | - | - | - | ||
| AddressTypeId | - | - | - | ||
| Address | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
address1 | Store literal Value | ||
data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
address1 | Store literal Value | |||
| CityId | - | - | - | ||
| RegionId | - | - | - | ||
| Zip | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
postalCode | Store literal Value | ||
data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
postalCode | Store literal Value | |||
| CountryId | - | - | - | ||
| CityName | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
city | Store literal Value | ||
data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
city | Store literal Value | |||
| RegionCode | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address
|
state | Store literal Value | ||
data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
state | Store literal Value | |||
| CountryCode | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address/
|
country | Store literal Value | ||
data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address
|
country | Store literal Value | |||
| DevatisCustomerNumber | - | - | - | ||
| DevatisColumn3 | - | - | - | ||
| DevatisIdentificationNumber | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumberto target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target | ||
data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | If UsrEDIParentIDNumber is not empty move UsrEDIParentIDNumber to target else if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumberto target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target | |||
| DevatisIdentificationTypeId | - | - | - | ||
| DevatisAddress2 | - | - | - | ||
| DevatisDiscount | - | - | - | ||
| DevatisEDIName | - | - | - | ||
| DevatisIdentificationType | data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierType | if UsrEDIParentIDType.Description is not empty move UsrEDIParentIDType.Description to target else if DevatisParentAccount.DevatisIdentifcationType is not empty Move DevatisParentAccount.DevatisIdentifcationType to target | ||
#/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierType | if DevatisParentAccount.DevatisIdentifcationType is not empty Move DevatisParentAccount.DevatisIdentifcationType to target | |||
| UsrNumber | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumber to target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target | ||
data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | If UsrEDIParentIDNumber is not empty move UsrEDIParentIDNumber to target else if DevatisParentAccount.UsrNumber is not empty move DevatisParentAccount.UsrNumber to target else if DevatisParentAccount.DevatisIdentificationNumber is not empty move DevatisParentAccount.DevatisIdentificationNumber to target | |||
#/data/controlFileHeader
|
fileReceiverNumber | DevatisParentAccount.DevatisIdentificationType +":"+ .DevatisParentAccount.UsrNumber | |||
| InvoiceProduct | - | - | - | ||
| Id | - | - | - | ||
| CreatedOn | - | - | - | ||
| CreatedById | - | - | - | ||
| ModifiedOn | - | - | - | ||
| ModifiedById | - | - | - | ||
| Name | - | - | - | ||
| Notes | - | - | - | ||
| ProductId | - | - | - | ||
| CustomProduct | - | - | - | ||
| DeliveryDate | - | - | - | ||
| Quantity | #/data/messageBody/canonicalInvoiceItemDetails/itemQuantity
|
quantityValue | Store literal Value where quantityType = "ITEM" | ||
| UnitId | - | - | - | ||
| PrimaryPrice | - | - | - | ||
| Price | #/data/messageBody/canonicalInvoiceItemDetails/invoicePricing
|
pricingAmount | Store literal value if present. Where pricingType=NET | ||
#/data/messageBody/canonicalInvoiceItemDetails/invoicePricing
|
pricingAmount | Store literal value if present. Where pricingType=UNIT | |||
| PrimaryAmount | - | - | - | ||
| Amount | - | - | - | ||
| PrimaryDiscountAmount | - | - | - | ||
| DiscountAmount | - | - | - | ||
| DiscountPercent | - | - | - | ||
| TaxId | - | - | - | ||
| PrimaryTaxAmount | - | - | - | ||
| TaxAmount | - | - | - | ||
| PrimaryTotalAmount | - | - | - | ||
| TotalAmount | - | - | - | ||
| DiscountTax | - | - | - | ||
| InvoiceId | - | - | - | ||
| ProcessListeners | - | - | - | ||
| SupplyPaymentProductId | - | - | - | ||
| BaseQuantity | - | - | - | ||
| PriceListId | - | - | - | ||
| DevatisLot | - | - | - | ||
| DevatisExpirationDate | - | - | - | ||
| DevatisShipped | - | - | - | ||
| DevatisOrdered | - | - | - | ||
| DevatisBackOrder | - | - | - | ||
| DevatisPricebookId | - | - | - | ||
| UsrPackagingTypeId | - | - | - | ||
| Product | - | - | - | ||
| Id | - | - | - | ||
| CreatedOn | - | - | - | ||
| CreatedById | - | - | - | ||
| ModifiedOn | - | - | - | ||
| ModifiedById | - | - | - | ||
| Name | #data|messageBody|canonicalInvoiceItemDetails|productItemInformation
|
productDescription | Store literal value if present. | ||
| Code | #/data/messageBody/canonicalInvoiceItemDetails/productCodesIdentifiers
|
productCodeValue | Store the value without Hyphen where productCodeType = "US_NDC542" | ||
| UnitId | - | - | - | ||
| CurrencyId | - | - | - | ||
| Price | - | - | - | ||
| TaxId | - | - | - | ||
| URL | - | - | - | ||
| TypeId | - | - | - | ||
| Active | - | - | - | ||
| ProcessListeners | - | - | - | ||
| OwnerId | - | - | - | ||
| Description | - | - | - | ||
| ProductSourceId | - | - | - | ||
| Notes | - | - | - | ||
| PictureId | - | - | - | ||
| IsArchive | - | - | - | ||
| KeenDeveloperId | - | - | - | ||
| ShortDescription | - | - | - | ||
| Benefits | - | - | - | ||
| CategoryId | - | - | - | ||
| TradeMarkId | - | - | - | ||
| GeneralConditions | - | - | - | ||
| DevatisPackage | - | - | - | ||
| DevatisFormId | - | - | - | ||
| DevatisGTIN2 | - | - | - | ||
| DevatisGTIN1 | - | - | - | ||
| DevatisMinimumOrderQuantity | - | - | - | ||
| DevatisSAP | - | - | - | ||
| DevatisUPC | - | - | - | ||
| DevatisProductFamilyId | - | - | - | ||
| Unit | - | - | - | ||
| Id | - | - | - | ||
| CreatedOn | - | - | - | ||
| CreatedById | - | - | - | ||
| ModifiedOn | - | - | - | ||
| ModifiedById | - | - | - | ||
| Name | - | - | - | ||
| Description | - | - | - | ||
| ShortName | #/data/messageBody/canonicalInvoiceItemDetails/itemQuantity
|
unitOfMeasure | Store literal value where quantityType = ITEM | ||
| ProcessListeners | - | - | - | ||
SAP HANA ERP
The following are the SAP HANA ERP attributes that are mapped with the Canonical attributes and their output path.
- Transform Name:
- STD_LA_MPL_Sap_Hana_Invoice_IB_V1
Guidelines
| Input Element | Output Path | Output Element | Mapping Rules | ||
|---|---|---|---|---|---|
| BillingDocument | #/data/messageBody/canonicalInvoiceHeader/invoiceTransactionReferenceIdentifierList
|
b2bTransactionIdentifierValue | Store literal value … If source b2bTransactionIdentifierType = "INVOICE". | ||
| BillingDocumentCategory | #/data/messageBody/canonicalInvoiceHeader
|
billingCategory | Store literal value if present. | ||
| BillingDocumentType | #/data/messageBody/canonicalInvoiceHeader/invoiceOrganization
|
organizationValue | Store literal value if present. where organizationType= BILLINGTYPE | ||
| CreationDate | #/data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateValue | "Store literal value. where dateType=DELIVERY Concatenate source CREDAT + CRETIM into target in XML date time format YYYY-MM-DDTHH:MM:SS.nnn" | ||
| CreationTime | - | - | - | ||
| LastChangeDate | - | - | - | ||
| LastChangeDateTime | - | - | - | ||
| SalesOrganization | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | Store literal value if present. where companyIdentifierType=COMPANYID | ||
data/controlFileHeader
|
fileSenderNumber | "fileSenderNumber": "COMPANYID:" + .SalesOrganization, | |||
#/data/messageBody/canonicalInvoiceHeader/invoiceOrganization
|
organizationValue | Store literal value if present. where OrganiazationType=SALESORG (008) | |||
| DistributionChannel | #/data/messageBody/canonicalInvoiceHeader/invoiceOrganization
|
organizationValue | Store literal value if present. where OrganiazationType=DISTRIBUTIONCHANNEL (007) | ||
| Division | #/data/messageBody/canonicalInvoiceHeader/invoiceOrganization
|
organizationValue | Store literal value if present. where OrganiazationType=DIVISION (006) | ||
| BillingDocumentDate | #/data/messageBody/canonicalInvoiceHeader/invoiceDates
|
dateValue | Convert from source IDoc to canonical target value using values in enum mapping worksheet. Where dateType=DOCUMENT | ||
| TotalNetAmount: | #/data/messageBody/canonicalInvoiceItemDetails/invoicePricing
|
pricingAmount | Store literal value if present. where pricingType=NET | ||
| TransactionCurrency | #/data/messageBody/canonicalInvoiceHeader/invoiceCurrency
|
currencyCode | Store literal value if present. | ||
| CustomerPaymentTerms: | #/data/messageBody/canonicalInvoiceHeader/termsOfPayment
|
invoiceTermsOfPaymentKey | Store literal value if present. | ||
| CompanyCode: | #/data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | Store literal value if present. where companyIdentifierType=COMPANYID | ||
| FiscalYear | - | - | - | ||
| SoldToParty | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | Store literal value if present. where companyIdentifierType=COMPANYID | ||
data/controlFileHeader
|
fileReceiverNumber | "fileReceiverNumber": "COMPANYID:" + .SoldToParty | |||
| Bill to Party | #/data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | Store literal value if present. where companyIdentifierType=COMPANYID | ||
| Ship to Party | #/data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList
|
alternateCompanyLocationIdentifierValue | Store literal value if present. where companyIdentifierType=COMPANYID | ||
| Payer | #/data/messageBody/canonicalInvoiceHeader/invoicePayerBusinessInformation/mpcCompanyLocationIdentifierList
|
businessName | Store literal value if present. where companyIdentifierType=COMPANYID | ||
| Items: | #/data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | Store literal value if present. where companyIdentifierType=COMPANYID | ||
| BillingDocumentItem: | #/data/messageBody/canonicalInvoiceItemDetails
|
lineItemNumber | Store literal value. | ||
| SalesDocumentItemCategory | #/data/messageBody/canonicalInvoiceItemDetails
|
itemCategory | Store literal value. | ||
| Material | #/data/messageBody/canonicalInvoiceItemDetails/productCodesIdentifiers
|
productCodeValue | "Store ltieral value. Where productCodeType= ""VENDOR"" " | ||
| Batch | #/data/messageBody/canonicalInvoiceItemDetails/TransactionReferenceIdentifierList
|
b2bTransactionIdentifierValue | Store literal value if present. | ||
| Plant | - | - | - | ||
| StorageLocation | - | - | - | ||
| BillingQuantity | #/data/messageBody/canonicalInvoiceItemDetails/itemQuantity
|
quantityValue | Store literal value with quantityType = "ORDER" | ||
#/data/messageBody/canonicalInvoiceItemDetails/itemQuantity
|
quantityValue | Store literal value with quantityType = "ORDER" | |||
| BillingQuantityUnit | #/data/messageBody/canonicalInvoiceItemDetails/itemQuantity
|
unitOfMeasure | Convert from SAP to canonical value based on enum mapping worksheet if source present. | ||
| ItemGrossWeight: | #/data/messageBody/canonicalInvoiceItemDetails/itemWeight
|
weightValue |
"If source present and source greater than 0: If source contains leading spaces, trim leading spaces and store literal value. Else store literal value. where weightType=GROSSWEIGHT" |
||
| ItemNetWeight: | #/data/messageBody/canonicalInvoiceItemDetails/itemWeight
|
weightValue |
"If source present and source greater than 0: If source contains leading spaces, trim leading spaces and store literal value. Else store literal value. weightType=NEIGHTWEIGHT" |
||
Tag end
