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 Dyanmics Output Element Mapping Rules
messageBody Not mapped Not mapped
  canonicalInvoiceHeader Not mapped Not mapped
    invoiceTermsOfPaymentKey Not mapped Not mapped
    vatRegistrationNumber Not mapped Not mapped
    alternateVATRegistrationNumber Not mapped Not mapped
    invoiceDocumentType Not mapped Not mapped
    invoiceListType Not mapped Not mapped
    billingCategory Not mapped Not mapped
    additionalPONumber Not mapped Not mapped
    shippingConditions Not mapped Not mapped
    shippingConditionsDescription Not mapped Not mapped
    recipientIdentifier Not mapped Not mapped
    isDropShip Not mapped Not mapped
    transactionReferenceIdentifierList(1) Not mapped Not mapped
      b2bTransactionIdentifierType Not mapped Not mapped
      b2bTransactionIdentifierValue Not mapped number Where b2bTransactionIdentifierType= INVOICE
      lineItemNumber Not mapped Not mapped
      transactionDate Not mapped invoiceDate where b2bTransactionIdentifierType = INVOICE
      epochTransactionDate Not mapped Not mapped
    transactionReferenceIdentifierList(2) Not mapped Not mapped
      b2bTransactionIdentifierType Not mapped Not mapped
      b2bTransactionIdentifierValue Not mapped orderNumber Hard code "ORDERNUMBER" to target instance of transactionReferenceIdentifierList
      lineItemNumber Not mapped Not mapped
      transactionDate Not mapped Not mapped
      epochTransactionDate Not mapped Not mapped
    transactionReferenceIdentifierList(3) Not mapped Not mapped
      b2bTransactionIdentifierType Not mapped Not mapped
      b2bTransactionIdentifierValue Not mapped Not mapped
      lineItemNumber Not mapped Not mapped
      transactionDate Not mapped Not mapped
      epochTransactionDate Not mapped Not mapped
    invoiceDates(1) Not mapped Not mapped
      dateType Not mapped Not mapped
      dateValue Not mapped Not mapped
      epochDateValue Not mapped Not mapped
      timeZone Not mapped Not mapped
    invoiceDates(2) Not mapped Not mapped
      dateType Not mapped Not mapped
      dateValue Not mapped Not mapped
      epochDateValue Not mapped Not mapped
      timeZone Not mapped Not mapped
    invoiceDates(3) Not mapped Not mapped
      dateType Not mapped Not mapped
      dateValue Not mapped Not mapped
      epochDateValue Not mapped Not mapped
      timeZone Not mapped Not mapped
    invoiceCurrency Not mapped Not mapped
      exchangeRateCurrencyCode Not mapped Not mapped
      exchangeRate Not mapped Not mapped
      validityDate Not mapped Not mapped
      epochValidityDate Not mapped Not mapped
      currencyCode Not mapped currencyCode
    remitToBusinessInformation Not mapped Not mapped
      CONSTANT [RI] Not mapped Not mapped
      businessName Not mapped Not mapped
      mpcCompanyLocationIdentifierList Not mapped Not mapped
        isIdentifierPresentInEvent Not mapped Not mapped
        companyIdentifierType Not mapped Not mapped
        companyIdentifierValue Not mapped Not mapped
        alternateCompanyLocationIdentifierValue Not mapped Not mapped
      companyLocationContactInformation Not mapped Not mapped
        contactTitle Not mapped Not mapped
        CONSTANT [EM] Not mapped Not mapped
        contactEmail Not mapped Not mapped
        contactName Not mapped Not mapped
        CONSTANT [TE] Not mapped Not mapped
        contactPhone Not mapped Not mapped
      address Not mapped Not mapped
        address1 Not mapped Not mapped
        address2 Not mapped Not mapped
        city Not mapped Not mapped
        district Not mapped Not mapped
        state Not mapped Not mapped
        postalCode Not mapped Not mapped
        country Not mapped Not mapped
        telephone Not mapped Not mapped
        fax Not mapped Not mapped
    customerBusinessInformation Not mapped Not mapped
      CONSTANT [BY] Not mapped Not mapped
      businessName Not mapped customerName
      mpcCompanyLocationIdentifierList Not mapped Not mapped
        isIdentifierPresentInEvent Not mapped Not mapped
        companyIdentifierType Not mapped Not mapped
        companyIdentifierValue Not mapped customerNumber where companyIdentifierType = COMPANYID
        alternateCompanyLocationIdentifierValue Not mapped Not mapped
      companyLocationContactInformation Not mapped Not mapped
        contactName Not mapped Not mapped
        contactTitle Not mapped Not mapped
        CONSTANT [EM] Not mapped Not mapped
        contactEmail Not mapped Not mapped
        CONSTANT [TE] Not mapped Not mapped
        contactPhone Not mapped Not mapped
      address Not mapped Not mapped
        address1 Not mapped Not mapped
        address2 Not mapped Not mapped
        city Not mapped Not mapped
        district Not mapped Not mapped
        state Not mapped Not mapped
        postalCode Not mapped Not mapped
        country Not mapped Not mapped
        telephone Not mapped Not mapped
        fax Not mapped Not mapped
    billToBusinessInformation Not mapped Not mapped
      CONSTANT[BT] Not mapped Not mapped
      businessName Not mapped Not mapped
      mpcCompanyLocationIdentifierList Not mapped Not mapped
        isIdentifierPresentInEvent Not mapped Not mapped
        companyIdentifierType Not mapped Not mapped
        companyIdentifierValue Not mapped billToCustomerNumber where companyIdentifierType = COMPANYID
        alternateCompanyLocationIdentifierValue Not mapped Not mapped
      companyLocationContactInformation Not mapped Not mapped
        contactName Not mapped Not mapped
        contactTitle Not mapped Not mapped
        contactEmail Not mapped Not mapped
        contactPhone Not mapped Not mapped
      address Not mapped Not mapped
        address1 Not mapped Not mapped
        address2 Not mapped Not mapped
        city Not mapped Not mapped
        district Not mapped Not mapped
        state Not mapped Not mapped
        postalCode Not mapped Not mapped
        country Not mapped Not mapped
        telephone Not mapped Not mapped
        fax Not mapped Not mapped
    billToShipToBusinessInformation Not mapped Not mapped
      CONSTANT[BS] Not mapped Not mapped
      businessName Not mapped Not mapped
      mpcCompanyLocationIdentifierList Not mapped Not mapped
        isIdentifierPresentInEvent Not mapped Not mapped
        companyIdentifierType Not mapped Not mapped
        companyIdentifierValue Not mapped Not mapped
        alternateCompanyLocationIdentifierValue Not mapped Not mapped
      companyLocationContactInformation Not mapped Not mapped
        contactName Not mapped Not mapped
        contactTitle Not mapped Not mapped
        contactEmail Not mapped Not mapped
        contactPhone Not mapped Not mapped
      address Not mapped Not mapped
        address1 Not mapped Not mapped
        address2 Not mapped Not mapped
        city Not mapped Not mapped
        district Not mapped Not mapped
        state Not mapped Not mapped
        postalCode Not mapped Not mapped
        country Not mapped Not mapped
        telephone Not mapped Not mapped
        fax Not mapped Not mapped
    invoicePayerBusinessInformation Not mapped Not mapped
      CONSTANT [PR] Not mapped Not mapped
      businessName Not mapped Not mapped
      mpcCompanyLocationIdentifierList Not mapped Not mapped
        isIdentifierPresentInEvent Not mapped Not mapped
        companyIdentifierType Not mapped Not mapped
        companyIdentifierValue Not mapped Not mapped
        alternateCompanyLocationIdentifierValue Not mapped Not mapped
      companyLocationContactInformation Not mapped Not mapped
        contactName Not mapped Not mapped
        contactTitle Not mapped Not mapped
        CONSTANT [EM] Not mapped Not mapped
        contactEmail Not mapped Not mapped
        CONSTANT [TE] Not mapped Not mapped
        contactPhone Not mapped Not mapped
      address Not mapped Not mapped
        address1 Not mapped Not mapped
        address2 Not mapped Not mapped
        city Not mapped Not mapped
        district Not mapped Not mapped
        state Not mapped Not mapped
        postalCode Not mapped Not mapped
        country Not mapped Not mapped
        telephone Not mapped Not mapped
        fax Not mapped Not mapped
    companyCodeBusinessInformation Not mapped Not mapped
      businessName Not mapped Not mapped
      companyLocationContactInformation Not mapped Not mapped
        contactName Not mapped Not mapped
        contactTitle Not mapped Not mapped
        contactEmail Not mapped Not mapped
        contactPhone Not mapped Not mapped
      mpcCompanyLocationIdentifierList Not mapped Not mapped
        isIdentifierPresentInEvent Not mapped Not mapped
        companyIdentifierType Not mapped Not mapped
        companyIdentifierValue Not mapped Not mapped
        alternateCompanyLocationIdentifierValue Not mapped Not mapped
      address Not mapped Not mapped
        address1 Not mapped Not mapped
        address2 Not mapped Not mapped
        city Not mapped Not mapped
        district Not mapped Not mapped
        state Not mapped Not mapped
        postalCode Not mapped Not mapped
        country Not mapped Not mapped
        telephone Not mapped Not mapped
        fax Not mapped Not mapped
    shipToLocationInformation Not mapped Not mapped
      CONSTANT [ST] Not mapped Not mapped
      businessName Not mapped shipToName
      mpcCompanyLocationIdentifierList Not mapped Not mapped
        companyIdentifierValue Not mapped Not mapped
        companyIdentifierType Not mapped Not mapped
        alternateCompanyLocationIdentifierValue Not mapped Not mapped
      address Not mapped Not mapped
        address1 Not mapped shipToAddressLine1
        address2 Not mapped shipToAddressLine2
        city Not mapped shipToCity
        district Not mapped Not mapped
        state Not mapped shipToState
        postalCode Not mapped shipToPostCode
        country Not mapped shipToCountry
        telephone Not mapped Not mapped
        fax Not mapped Not mapped
      companyLocationContactInformation Not mapped Not mapped
        contactTitle Not mapped Not mapped
        contactEmail Not mapped Not mapped
        contactName Not mapped shipToContact
        contactPhone Not mapped Not mapped
    supplierBusinessInformation Not mapped Not mapped
      CONSTANT [SU] Not mapped Not mapped
      businessName Not mapped Not mapped
      mpcCompanyLocationIdentifierList Not mapped Not mapped
        companyIdentifierValue Not mapped Not mapped
        companyIdentifierType Not mapped Not mapped
        alternateCompanyLocationIdentifierValue Not mapped Not mapped
      address Not mapped Not mapped
        address1 Not mapped Not mapped
        address2 Not mapped Not mapped
        city Not mapped Not mapped
        district Not mapped Not mapped
        state Not mapped Not mapped
        postalCode Not mapped Not mapped
        country Not mapped Not mapped
        telephone Not mapped Not mapped
        fax Not mapped Not mapped
      companyLocationContactInformation Not mapped Not mapped
        contactName Not mapped Not mapped
        contactTitle Not mapped Not mapped
        CONSTANT [EM] Not mapped Not mapped
        contactEmail Not mapped Not mapped
        CONSTANT [TE] Not mapped Not mapped
        contactPhone Not mapped Not mapped
    invoiceOrganization Not mapped Not mapped
      organizationType Not mapped Not mapped
      organizationValue Not mapped Not mapped
    termsOfPayment Not mapped Not mapped
      termsOfPaymentKey Not mapped Not mapped
      termsOfPaymentTypeCode Not mapped Not mapped
      termsOfPaymentDateBasis Not mapped Not mapped
      numberOfDays Not mapped Not mapped
      termsOfPaymentPercent Not mapped Not mapped
      discountDueNumberOfDays Not mapped Not mapped
      invoicePayablePercent Not mapped Not mapped
      discountDueDate Not mapped Not mapped
      epochDiscountDueDate Not mapped Not mapped
      paymentDeferredToDate Not mapped Not mapped
      epochPaymentDeferredToDate Not mapped Not mapped
      paymentDueDate Not mapped Not mapped
      epochPaymentDueDate Not mapped Not mapped
      paymentDeferredDueAmount Not mapped Not mapped
      description Not mapped Not mapped
      dayOfMonth Not mapped Not mapped
    taxes Not mapped Not mapped
      country Not mapped Not mapped
      taxRate Not mapped Not mapped
      vatIndicator Not mapped Not mapped
      taxExemptCode Not mapped Not mapped
      taxCurrencyCode Not mapped Not mapped
      taxPercent Not mapped Not mapped
      taxRegistrationCode Not mapped Not mapped
      taxAmount Not mapped Not mapped
      taxType Not mapped Not mapped
      taxJurisdictionCode Not mapped Not mapped
    bankInfo Not mapped Not mapped
      country Not mapped Not mapped
      city Not mapped Not mapped
      bankIdentifier Not mapped Not mapped
      bankName Not mapped Not mapped
      accountNumber Not mapped Not mapped
      accountHolderName Not mapped Not mapped
      internationalBankAccountNumber Not mapped Not mapped
    creditsAndCharges Not mapped Not mapped
      creditChargeKeyType Not mapped Not mapped
      creditChargeType Not mapped Not mapped
      creditChargeAmount Not mapped discountAmount Where creditChargeType= DISCOUNT
      qualifyingAmount Not mapped Not mapped
      creditChargePercentRate Not mapped Not mapped
      percentRateBasisTypeCode Not mapped Not mapped
      creditChargeCurrencyCode Not mapped Not mapped
      creditChargeHandlingCode Not mapped Not mapped
      description Not mapped Not mapped
    deliveryTerms Not mapped Not mapped
      deliveryTermCode Not mapped Not mapped
      description Not mapped Not mapped
      deliveryChargePaymentMethodType Not mapped Not mapped
      fobTransferLocation Not mapped Not mapped
    invoiceWeight(1) Not mapped Not mapped
      weightType Not mapped Not mapped
      weightValue Not mapped Not mapped
      unitOfMeasure Not mapped Not mapped
    invoiceWeight(2) Not mapped Not mapped
      weightType Not mapped Not mapped
      weightValue Not mapped Not mapped
      unitOfMeasure Not mapped Not mapped
    foreignTradeHeaderInformation Not mapped Not mapped
      foreignTradeIdentifier Not mapped Not mapped
      exportDepartureCountryCode Not mapped Not mapped
      exportAlternateDepartureCountryCode Not mapped Not mapped
      exportDepartureCountryDescription Not mapped Not mapped
      foreignTradeTransportMode Not mapped Not mapped
      foreignTradeTransportModeDescription Not mapped Not mapped
      foreignTradeCustomsEntryExitOfficeCode Not mapped Not mapped
      foreignTradeCustomsEntryExitOfficeDescription Not mapped Not mapped
      foreignTradeCurrency Not mapped Not mapped
      importingCountryCode Not mapped Not mapped
      importingCountryName Not mapped Not mapped
      importingAlternateCountryCode Not mapped Not mapped
      soldtoPartyAlternateCountryCode Not mapped Not mapped
      freeTradeAreaCode Not mapped Not mapped
      freeTradeAreaDescription Not mapped Not mapped
      countryCodeForJapanCustomsDeclaration Not mapped Not mapped
      countryDirectoryCurrencyCode Not mapped Not mapped
      domesticModeOfTransport Not mapped Not mapped
      domesticModeOfTransportDescription Not mapped Not mapped
      exportCustomsOfficeCode Not mapped Not mapped
      exportCustomsOfficeDescription Not mapped Not mapped
      associationForForeignTradeIndicator Not mapped Not mapped
    freeTextNote Not mapped Not mapped
      textReferenceCode Not mapped Not mapped
      textFunctionCode Not mapped Not mapped
      language Not mapped Not mapped
      textFormatCode Not mapped Not mapped
      freeFormText Not mapped Not mapped
  canonicalInvoiceItemDetails Not mapped Not mapped
    lineItemNumber Not mapped Not mapped
    itemCategory Not mapped Not mapped
    productCodesIdentifiers Not mapped Not mapped
      productCodeType Not mapped Not mapped
      productCodeValue salesInvoiceLines lineObjectNumber productCodeType=VENDOR
      mpcItemCodeType Not mapped Not mapped
    CONSTANT [LT] Not mapped Not mapped
    lotNumber Not mapped Not mapped
    productItemInformation Not mapped Not mapped
      productLanguageCode Not mapped Not mapped
      productName salesInvoiceLines description
      productDescription Not mapped Not mapped
      genericName Not mapped Not mapped
      CONSTANT [F] Not mapped Not mapped
    expirationDate Not mapped Not mapped
    CONSTANT [208] Not mapped Not mapped
    epochExpirationDate Not mapped Not mapped
    additionalItemInformation Not mapped Not mapped
      numberOfUnitsShipped Not mapped Not mapped
      unitOfMeasure salesInvoiceLines unitOfMeasureCode
      statusCodeForShipmentOrOrder Not mapped Not mapped
      quantityDifference Not mapped Not mapped
    itemQuantity Not mapped Not mapped
      quantityType Not mapped Not mapped
      unitOfMeasure Not mapped Not mapped
      quantityValue salesInvoiceLines quantity Select first one.
    invoicePricing Not mapped Not mapped
      pricingType Not mapped Not mapped
      pricingAmount salesInvoiceLines pricingAmount " where pricingType=NET"
    creditsAndCharges Not mapped Not mapped
      creditChargeKeyType Not mapped Not mapped
      creditChargeType Not mapped Not mapped
      creditChargeAmount Not mapped discountAmount where creditChargeType= DISCOUNT
      qualifyingAmount Not mapped Not mapped
      creditChargePercentRate Not mapped discountPercent where creditChargeType= DISCOUNT
      percentRateBasisTypeCode Not mapped Not mapped
      creditChargeCurrencyCode Not mapped Not mapped
      creditChargeHandlingCode Not mapped Not mapped
      description Not mapped Not mapped
    taxes Not mapped Not mapped
      country Not mapped Not mapped
      taxRate Not mapped Not mapped
      vatIndicator Not mapped Not mapped
      taxExemptCode Not mapped Not mapped
      taxCurrencyCode Not mapped Not mapped
      taxPercent Not mapped Not mapped
      taxRegistrationCode Not mapped Not mapped
      taxAmount Not mapped Not mapped
      taxType Not mapped Not mapped
      taxJurisdictionCode Not mapped Not mapped
    itemWeight(1) Not mapped Not mapped
      weightType Not mapped Not mapped
      weightValue Not mapped Not mapped
      unitOfMeasure Not mapped Not mapped
    itemWeight(2) Not mapped Not mapped
      weightType Not mapped Not mapped
      weightValue Not mapped Not mapped
      unitOfMeasure Not mapped Not mapped
    transactionReferenceIdentifierList Not mapped Not mapped
      b2bTransactionIdentifierType Not mapped Not mapped
      b2bTransactionIdentifierValue Not mapped Not mapped
      lineItemNumber Not mapped Not mapped
      transactionDate(1) Not mapped Not mapped
      transactionDate(2) Not mapped Not mapped
      epochTransactionDate Not mapped Not mapped
    invoiceDates Not mapped Not mapped
      dateType Not mapped Not mapped
      dateValue Not mapped Not mapped
      epochDateValue Not mapped Not mapped
      timeZone Not mapped Not mapped
    accountAssignmentForInvoice Not mapped Not mapped
      accountAssignmentType Not mapped Not mapped
      accountIdentifier Not mapped Not mapped
    foreignTradeItemDetailsInformation Not mapped Not mapped
      foreignTradeIdentifier Not mapped Not mapped
      foreignTradeLineItemNumber Not mapped Not mapped
      exportImportProcedureCode Not mapped Not mapped
      exportImportAlternateProcedureCode Not mapped Not mapped
      exportImportProcedureDescription Not mapped Not mapped
      foreignTradeBusinessTransactionType Not mapped Not mapped
      foreignTradeBusinessTransactionDescription Not mapped Not mapped
      productCountryOfOrigin Not mapped Not mapped
      productRegionOfOrigin Not mapped Not mapped
      productAlternateCountryOfOrigin Not mapped Not mapped
      productCountryOfOriginDescription Not mapped Not mapped
      productGrossWeight Not mapped Not mapped
      productNetWeight Not mapped Not mapped
      unitOfMeasure Not mapped Not mapped
      regionOfProductManufacture Not mapped Not mapped
      countryOfDispatchForTrade Not mapped Not mapped
      countryOfDispatchDescription Not mapped Not mapped
      exemptionCertificateForTrade Not mapped Not mapped
      exemptionCertificateForLegalControl Not mapped Not mapped
      exemptionCertificateIssueDate Not mapped Not mapped
      epochExemptionCertificateIssueDate Not mapped Not mapped
      regionForPlant Not mapped Not mapped
    shipToLocationInformation Not mapped Not mapped
      CONSTANT[WE] Not mapped Not mapped
      businessName Not mapped Not mapped
      companyLocationContactInformation Not mapped Not mapped
        contactName Not mapped Not mapped
        contactTitle Not mapped Not mapped
        contactEmail Not mapped Not mapped
        contactPhone Not mapped Not mapped
      mpcCompanyLocationIdentifierList Not mapped Not mapped
        isIdentifierPresentInEvent Not mapped Not mapped
        companyIdentifierType Not mapped Not mapped
        companyIdentifierValue Not mapped Not mapped
        alternateCompanyLocationIdentifierValue Not mapped Not mapped
      address Not mapped Not mapped
        address1 Not mapped Not mapped
        address2 Not mapped Not mapped
        city Not mapped Not mapped
        district Not mapped Not mapped
        state Not mapped Not mapped
        postalCode Not mapped Not mapped
        country Not mapped Not mapped
        telephone Not mapped Not mapped
        fax Not mapped Not mapped
    freeTextNote Not mapped Not mapped
      textReferenceCode Not mapped Not mapped
      CONSTANT [AAI] Not mapped Not mapped
      textFunctionCode Not mapped Not mapped
      language Not mapped Not mapped
      textFormatCode Not mapped Not mapped
      freeFormText Not mapped Not mapped
  canonicalInvoiceSummary(1) Not mapped Not mapped
    summaryType Not mapped Not mapped
    summaryValue Not mapped Not mapped
    summaryValueUnit Not mapped Not mapped
  canonicalInvoiceSummary(2) Not mapped Not mapped
    summaryType Not mapped Not mapped
    summaryValue Not mapped Not mapped
    summaryValueUnit Not mapped Not mapped