Type = API Reference,; Topic = Multienterprise Information Network Tower (MINT), Transforms,;Persona = TraceLink Administrator, User,; Orchestration = Commerce, Transportation,; Function = Supply Chain, IT, Procurement,
Posted Sales Invoice Outbound APIs
The Posted Sales Invoice in MS Dynamics Business Central ERP records the details of a completed sales transaction. Posted sales invoice serves as a formal billing document issued by the seller to the customer, confirming the sale of goods or services and requesting payment.
- Transform Name:
- STD_MSDynamics_Business_PostedSalesInvoice_OB
The following are the MS Dynamics Business Central ERP attributes that are mapped with the Canonical attributes and their output path.
| Input Element | MS Dynamics Output Path | MS Dynamics Output Element | Mapping Rules | ||||
|---|---|---|---|---|---|---|---|
| messageBody | – | – | – | ||||
| canonicalInvoiceHeader | – | – | – | ||||
| invoiceTermsOfPaymentKey | – | – | – | ||||
| vatRegistrationNumber | – | – | – | ||||
| alternateVATRegistrationNumber | – | – | – | ||||
| invoiceDocumentType | – | – | – | ||||
| invoiceListType | – | – | – | ||||
| billingCategory | – | – | – | ||||
| additionalPONumber | – | – | – | ||||
| shippingConditions | – | – | – | ||||
| shippingConditionsDescription | – | – | – | ||||
| recipientIdentifier | – | – | – | ||||
| isDropShip | – | – | – | ||||
| transactionReferenceIdentifierList(1) | – | – | – | ||||
| b2bTransactionIdentifierType | – | – | – | ||||
| b2bTransactionIdentifierValue | – | number | Where b2bTransactionIdentifierType= INVOICE | ||||
| lineItemNumber | – | – | – | ||||
| transactionDate | – | invoiceDate | where b2bTransactionIdentifierType = INVOICE | ||||
| epochTransactionDate | – | – | – | ||||
| transactionReferenceIdentifierList(2) | – | – | – | ||||
| b2bTransactionIdentifierType | – | – | – | ||||
| b2bTransactionIdentifierValue | – | orderNumber | Hard code "ORDERNUMBER" to target instance of transactionReferenceIdentifierList | ||||
| lineItemNumber | – | – | – | ||||
| transactionDate | – | – | – | ||||
| epochTransactionDate | – | – | – | ||||
| transactionReferenceIdentifierList(3) | – | – | – | ||||
| b2bTransactionIdentifierType | – | – | – | ||||
| b2bTransactionIdentifierValue | – | – | – | ||||
| lineItemNumber | – | – | – | ||||
| transactionDate | – | – | – | ||||
| epochTransactionDate | – | – | – | ||||
| invoiceDates(1) | – | – | – | ||||
| dateType | – | – | – | ||||
| dateValue | – | – | – | ||||
| epochDateValue | – | – | – | ||||
| timeZone | – | – | – | ||||
| invoiceDates(2) | – | – | – | ||||
| dateType | – | – | – | ||||
| dateValue | – | – | – | ||||
| epochDateValue | – | – | – | ||||
| timeZone | – | – | – | ||||
| invoiceDates(3) | – | – | – | ||||
| dateType | – | – | – | ||||
| dateValue | – | – | – | ||||
| epochDateValue | – | – | – | ||||
| timeZone | – | – | – | ||||
| invoiceCurrency | – | – | – | ||||
| exchangeRateCurrencyCode | – | – | – | ||||
| exchangeRate | – | – | – | ||||
| validityDate | – | – | – | ||||
| epochValidityDate | – | – | – | ||||
| currencyCode | – | currencyCode | – | ||||
| remitToBusinessInformation | – | – | – | ||||
| CONSTANT [RI] | – | – | – | ||||
| businessName | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactTitle | – | – | – | ||||
| CONSTANT [EM] | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactName | – | – | – | ||||
| CONSTANT [TE] | – | – | – | ||||
| contactPhone | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| district | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| customerBusinessInformation | – | – | – | ||||
| CONSTANT [BY] | – | – | – | ||||
| businessName | – | customerName | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | customerNumber | where companyIdentifierType = COMPANYID | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| CONSTANT [EM] | – | – | – | ||||
| contactEmail | – | – | – | ||||
| CONSTANT [TE] | – | – | – | ||||
| contactPhone | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| district | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| billToBusinessInformation | – | – | – | ||||
| CONSTANT[BT] | – | – | – | ||||
| businessName | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | billToCustomerNumber | where companyIdentifierType = COMPANYID | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| district | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| billToShipToBusinessInformation | – | – | – | ||||
| CONSTANT[BS] | – | – | – | ||||
| businessName | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| district | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| invoicePayerBusinessInformation | – | – | – | ||||
| CONSTANT [PR] | – | – | – | ||||
| businessName | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| CONSTANT [EM] | – | – | – | ||||
| contactEmail | – | – | – | ||||
| CONSTANT [TE] | – | – | – | ||||
| contactPhone | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| district | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| companyCodeBusinessInformation | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| district | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| shipToLocationInformation | – | – | – | ||||
| CONSTANT [ST] | – | – | – | ||||
| businessName | – | shipToName | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | shipToAddressLine1 | – | ||||
| address2 | – | shipToAddressLine2 | – | ||||
| city | – | shipToCity | – | ||||
| district | – | – | – | ||||
| state | – | shipToState | – | ||||
| postalCode | – | shipToPostCode | – | ||||
| country | – | shipToCountry | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactName | – | – | – | ||||
| contactPhone | – | – | – | ||||
| supplierBusinessInformation | – | – | – | ||||
| CONSTANT [SU] | – | – | – | ||||
| businessName | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| district | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| CONSTANT [EM] | – | – | – | ||||
| contactEmail | – | – | – | ||||
| CONSTANT [TE] | – | – | – | ||||
| contactPhone | – | – | – | ||||
| invoiceOrganization | – | – | – | ||||
| organizationType | – | – | – | ||||
| organizationValue | – | – | – | ||||
| termsOfPayment | – | – | – | ||||
| termsOfPaymentKey | – | – | – | ||||
| termsOfPaymentTypeCode | – | – | – | ||||
| termsOfPaymentDateBasis | – | – | – | ||||
| numberOfDays | – | – | – | ||||
| termsOfPaymentPercent | – | – | – | ||||
| discountDueNumberOfDays | – | – | – | ||||
| invoicePayablePercent | – | – | – | ||||
| discountDueDate | – | – | – | ||||
| epochDiscountDueDate | – | – | – | ||||
| paymentDeferredToDate | – | – | – | ||||
| epochPaymentDeferredToDate | – | – | – | ||||
| paymentDueDate | – | – | – | ||||
| epochPaymentDueDate | – | – | – | ||||
| paymentDeferredDueAmount | – | – | – | ||||
| description | – | – | – | ||||
| dayOfMonth | – | – | – | ||||
| taxes | – | – | – | ||||
| country | – | – | – | ||||
| taxRate | – | – | – | ||||
| vatIndicator | – | – | – | ||||
| taxExemptCode | – | – | – | ||||
| taxCurrencyCode | – | – | – | ||||
| taxPercent | – | – | – | ||||
| taxRegistrationCode | – | – | – | ||||
| taxAmount | – | – | – | ||||
| taxType | – | – | – | ||||
| taxJurisdictionCode | – | – | – | ||||
| bankInfo | – | – | – | ||||
| country | – | – | – | ||||
| city | – | – | – | ||||
| bankIdentifier | – | – | – | ||||
| bankName | – | – | – | ||||
| accountNumber | – | – | – | ||||
| accountHolderName | – | – | – | ||||
| internationalBankAccountNumber | – | – | – | ||||
| creditsAndCharges | – | – | – | ||||
| creditChargeKeyType | – | – | – | ||||
| creditChargeType | – | – | – | ||||
| creditChargeAmount | – | discountAmount | Where creditChargeType= DISCOUNT | ||||
| qualifyingAmount | – | – | – | ||||
| creditChargePercentRate | – | – | – | ||||
| percentRateBasisTypeCode | – | – | – | ||||
| creditChargeCurrencyCode | – | – | – | ||||
| creditChargeHandlingCode | – | – | – | ||||
| description | – | – | – | ||||
| deliveryTerms | – | – | – | ||||
| deliveryTermCode | – | – | – | ||||
| description | – | – | – | ||||
| deliveryChargePaymentMethodType | – | – | – | ||||
| fobTransferLocation | – | – | – | ||||
| invoiceWeight(1) | – | – | – | ||||
| weightType | – | – | – | ||||
| weightValue | – | – | – | ||||
| unitOfMeasure | – | – | – | ||||
| invoiceWeight(2) | – | – | – | ||||
| weightType | – | – | – | ||||
| weightValue | – | – | – | ||||
| unitOfMeasure | – | – | – | ||||
| foreignTradeHeaderInformation | – | – | – | ||||
| foreignTradeIdentifier | – | – | – | ||||
| exportDepartureCountryCode | – | – | – | ||||
| exportAlternateDepartureCountryCode | – | – | – | ||||
| exportDepartureCountryDescription | – | – | – | ||||
| foreignTradeTransportMode | – | – | – | ||||
| foreignTradeTransportModeDescription | – | – | – | ||||
| foreignTradeCustomsEntryExitOfficeCode | – | – | – | ||||
| foreignTradeCustomsEntryExitOfficeDescription | – | – | – | ||||
| foreignTradeCurrency | – | – | – | ||||
| importingCountryCode | – | – | – | ||||
| importingCountryName | – | – | – | ||||
| importingAlternateCountryCode | – | – | – | ||||
| soldtoPartyAlternateCountryCode | – | – | – | ||||
| freeTradeAreaCode | – | – | – | ||||
| freeTradeAreaDescription | – | – | – | ||||
| countryCodeForJapanCustomsDeclaration | – | – | – | ||||
| countryDirectoryCurrencyCode | – | – | – | ||||
| domesticModeOfTransport | – | – | – | ||||
| domesticModeOfTransportDescription | – | – | – | ||||
| exportCustomsOfficeCode | – | – | – | ||||
| exportCustomsOfficeDescription | – | – | – | ||||
| associationForForeignTradeIndicator | – | – | – | ||||
| freeTextNote | – | – | – | ||||
| textReferenceCode | – | – | – | ||||
| textFunctionCode | – | – | – | ||||
| language | – | – | – | ||||
| textFormatCode | – | – | – | ||||
| freeFormText | – | – | – | ||||
| canonicalInvoiceItemDetails | – | – | – | ||||
| lineItemNumber | – | – | – | ||||
| itemCategory | – | – | – | ||||
| productCodesIdentifiers | – | – | – | ||||
| productCodeType | – | – | – | ||||
| productCodeValue | salesInvoiceLines | lineObjectNumber | productCodeType=VENDOR | ||||
| mpcItemCodeType | – | – | – | ||||
| CONSTANT [LT] | – | – | – | ||||
| lotNumber | – | – | – | ||||
| productItemInformation | – | – | – | ||||
| productLanguageCode | – | – | – | ||||
| productName | salesInvoiceLines | description | – | ||||
| productDescription | – | – | – | ||||
| genericName | – | – | – | ||||
| CONSTANT [F] | – | – | – | ||||
| expirationDate | – | – | – | ||||
| CONSTANT [208] | – | – | – | ||||
| epochExpirationDate | – | – | – | ||||
| additionalItemInformation | – | – | – | ||||
| numberOfUnitsShipped | – | – | – | ||||
| unitOfMeasure | salesInvoiceLines | unitOfMeasureCode | – | ||||
| statusCodeForShipmentOrOrder | – | – | – | ||||
| quantityDifference | – | – | – | ||||
| itemQuantity | – | – | – | ||||
| quantityType | – | – | – | ||||
| unitOfMeasure | – | – | – | ||||
| quantityValue | salesInvoiceLines | quantity | Select first one. | ||||
| invoicePricing | – | – | – | ||||
| pricingType | – | – | – | ||||
| pricingAmount | salesInvoiceLines | pricingAmount | " where pricingType=NET" | ||||
| creditsAndCharges | – | – | – | ||||
| creditChargeKeyType | – | – | – | ||||
| creditChargeType | – | – | – | ||||
| creditChargeAmount | – | discountAmount | where creditChargeType= DISCOUNT | ||||
| qualifyingAmount | – | – | – | ||||
| creditChargePercentRate | – | discountPercent | where creditChargeType= DISCOUNT | ||||
| percentRateBasisTypeCode | – | – | – | ||||
| creditChargeCurrencyCode | – | – | – | ||||
| creditChargeHandlingCode | – | – | – | ||||
| description | – | – | – | ||||
| taxes | – | – | – | ||||
| country | – | – | – | ||||
| taxRate | – | – | – | ||||
| vatIndicator | – | – | – | ||||
| taxExemptCode | – | – | – | ||||
| taxCurrencyCode | – | – | – | ||||
| taxPercent | – | – | – | ||||
| taxRegistrationCode | – | – | – | ||||
| taxAmount | – | – | – | ||||
| taxType | – | – | – | ||||
| taxJurisdictionCode | – | – | – | ||||
| itemWeight(1) | – | – | – | ||||
| weightType | – | – | – | ||||
| weightValue | – | – | – | ||||
| unitOfMeasure | – | – | – | ||||
| itemWeight(2) | – | – | – | ||||
| weightType | – | – | – | ||||
| weightValue | – | – | – | ||||
| unitOfMeasure | – | – | – | ||||
| transactionReferenceIdentifierList | – | – | – | ||||
| b2bTransactionIdentifierType | – | – | – | ||||
| b2bTransactionIdentifierValue | – | – | – | ||||
| lineItemNumber | – | – | – | ||||
| transactionDate(1) | – | – | – | ||||
| transactionDate(2) | – | – | – | ||||
| epochTransactionDate | – | – | – | ||||
| invoiceDates | – | – | – | ||||
| dateType | – | – | – | ||||
| dateValue | – | – | – | ||||
| epochDateValue | – | – | – | ||||
| timeZone | – | – | – | ||||
| accountAssignmentForInvoice | – | – | – | ||||
| accountAssignmentType | – | – | – | ||||
| accountIdentifier | – | – | – | ||||
| foreignTradeItemDetailsInformation | – | – | – | ||||
| foreignTradeIdentifier | – | – | – | ||||
| foreignTradeLineItemNumber | – | – | – | ||||
| exportImportProcedureCode | – | – | – | ||||
| exportImportAlternateProcedureCode | – | – | – | ||||
| exportImportProcedureDescription | – | – | – | ||||
| foreignTradeBusinessTransactionType | – | – | – | ||||
| foreignTradeBusinessTransactionDescription | – | – | – | ||||
| productCountryOfOrigin | – | – | – | ||||
| productRegionOfOrigin | – | – | – | ||||
| productAlternateCountryOfOrigin | – | – | – | ||||
| productCountryOfOriginDescription | – | – | – | ||||
| productGrossWeight | – | – | – | ||||
| productNetWeight | – | – | – | ||||
| unitOfMeasure | – | – | – | ||||
| regionOfProductManufacture | – | – | – | ||||
| countryOfDispatchForTrade | – | – | – | ||||
| countryOfDispatchDescription | – | – | – | ||||
| exemptionCertificateForTrade | – | – | – | ||||
| exemptionCertificateForLegalControl | – | – | – | ||||
| exemptionCertificateIssueDate | – | – | – | ||||
| epochExemptionCertificateIssueDate | – | – | – | ||||
| regionForPlant | – | – | – | ||||
| shipToLocationInformation | – | – | – | ||||
| CONSTANT[WE] | – | – | – | ||||
| businessName | – | – | – | ||||
| companyLocationContactInformation | – | – | – | ||||
| contactName | – | – | – | ||||
| contactTitle | – | – | – | ||||
| contactEmail | – | – | – | ||||
| contactPhone | – | – | – | ||||
| mpcCompanyLocationIdentifierList | – | – | – | ||||
| isIdentifierPresentInEvent | – | – | – | ||||
| companyIdentifierType | – | – | – | ||||
| companyIdentifierValue | – | – | – | ||||
| alternateCompanyLocationIdentifierValue | – | – | – | ||||
| address | – | – | – | ||||
| address1 | – | – | – | ||||
| address2 | – | – | – | ||||
| city | – | – | – | ||||
| district | – | – | – | ||||
| state | – | – | – | ||||
| postalCode | – | – | – | ||||
| country | – | – | – | ||||
| telephone | – | – | – | ||||
| fax | – | – | – | ||||
| freeTextNote | – | – | – | ||||
| textReferenceCode | – | – | – | ||||
| CONSTANT [AAI] | – | – | – | ||||
| textFunctionCode | – | – | – | ||||
| language | – | – | – | ||||
| textFormatCode | – | – | – | ||||
| freeFormText | – | – | – | ||||
| canonicalInvoiceSummary(1) | – | – | – | ||||
| summaryType | – | – | – | ||||
| summaryValue | – | – | – | ||||
| summaryValueUnit | – | – | – | ||||
| canonicalInvoiceSummary(2) | – | – | – | ||||
| summaryType | – | – | – | ||||
| summaryValue | – | – | – | ||||
| summaryValueUnit | – | – | – | ||||
Tag end
