Type = API Reference,; Topic = Multienterprise Information Network Tower (MINT), Transforms,;Persona = TraceLink Administrator, User,; Orchestration = Commerce, Transportation,; Function = Supply Chain, IT, Procurement,
Sales Order Inbound APIs
A sales order functions as the seller’s official confirmation of the customer’s purchase. A sales order is an agreement outlining the goods or services to be delivered to the customer, confirming the terms of the sale.
MS Dynamics Business Central ERP
The following are the MS Dynamics Business Central ERP attributes that are mapped with the Canonical attributes and their output path.
- Transform Name:
- STD_MSDynamics_Business_Central_SalesOrder_IB
Guidelines
| MS Dynamics Field Input Element | Mapped Canonical Path | Target Output Element | Mapping Rules | |
|---|---|---|---|---|
| @odata.context | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| number | data/messageBody/canonicalPurchaseOrderItemDetails/transactionReferenceIdentifierList
|
b2btransactionIdentifierValue | where b2bTransactionIdentifierType = PURCHASEORDER | |
| externalDocumentNumber | data/messageBody/canonicalPurchaseOrderItemDetails/transactionReferenceIdentifierList
|
b2btransactionIdentifierValue | where b2bTransactionIdentifierType = PURCHASEORDER | |
| orderDate | data/messageBody/canonicalPurchaseOrderHeader/transactionReferenceIdentifierList
|
transactionDate | where b2bTransactionIdentifierType = PURCHASEORDER | |
| postingDate | – | – | – | |
| customerId | – | – | Not mapped | |
| customerNumber | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | where companyIdentifierType = COMPANYID | |
| customerName | – | – | – | |
| billToName | Required. data.messageBody/canonicalPurchaseOrderHeader/billToLocationInformation/companyLocationContactInformation
|
businessName | – | |
| billToCustomerId | – | – | Not mapped | |
| billToCustomerNumber | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | where companyIdentifierType = COMPANYID | |
| shipToName | Required.data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation
|
businessName | – | |
| shipToContact | data.messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/companyLocationContactInformation/contactName
|
– | ||
| sellToAddressLine1 | – | – | – | |
| sellToAddressLine2 | – | – | – | |
| sellToCity | – | – | – | |
| sellToCountry | – | – | – | |
| sellToState | – | – | – | |
| sellToPostCode | – | – | – | |
| billToAddressLine1 | Required.data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
billToAddressLine1 | – | |
| billToAddressLine2 | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
billToAddressLine2 | – | |
| billToCity | Required.data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
billToCity | – | |
| billToCountry | Required.data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
billToCountry | – | |
| billToState | Required.data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
billToState | – | |
| billToPostCode | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
billToPostCode | – | |
| shipToAddressLine1 | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
shipToAddressLine1 | – | |
| shipToAddressLine2 | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
shipToAddressLine2 | – | |
| shipToCity | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
shipToCity | – | |
| shipToCountry | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
shipToCountry | – | |
| shipToState | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
shipToState | – | |
| shipToPostCode | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
shipToPostCode | – | |
| shortcutDimension1Code | – | – | – | |
| shortcutDimension2Code | – | – | – | |
| currencyID | – | – | – | |
| currencyCode | data/messageBody/canonicalPurchaseOrderHeader/mpcCurrency
|
currencycode | – | |
| pricesIncludeTax | – | – | – | |
| paymentTermsId | – | – | – | |
| shipmentMethodId | – | – | – | |
| salesperson | – | – | – | |
| partialShipping | – | – | – | |
| requestedDeliveryDate | data/messageBody/canonicalPurchaseOrderHeader/mpcDates
data/messageBody/canonicalPurchaseOrderItemDetails/deliverySchedule
|
dateValue scheduleDateTime |
Where dateType = DELIVERYREQUSETED | |
| discountAmount | data/messageBody/canonicalPurchaseOrderHeader/creditsAndCharges |
creditChargeAmount | creditChargeType= DISCOUNT | |
| discountAppliedBeforeTax | – | – | – | |
| totalAmountExcludingTax | – | – | – | |
| totalTaxAmount | – | – | – | |
| totalAmountIncludingTax | – | – | – | |
| fullyShipped | – | – | – | |
| status | – | – | – | |
| lastModifiedDateTime | – | – | – | |
| phoneNumber | – | – | – | |
| – | – | – | ||
| customer | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| number | – | – | – | |
| displayName | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address
|
businessName | – | |
| type | – | – | – | |
| addressLine1 | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address
|
address1 | – | |
| addressLine2 | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address
|
address2 | – | |
| city | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address
|
city | – | |
| state | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address
|
state | – | |
| country | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address
|
country | – | |
| postalCode | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/address
|
postalCode | – | |
| phoneNumber | data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/companyLocationContactInformation
|
contactPhone | – | |
data/messageBody/canonicalPurchaseOrderHeader/customerBusinessInformation/companyLocationContactInformation
|
contactEmail | – | ||
| website | – | – | – | |
| salespersonCode | – | – | – | |
| balanceDue | – | – | – | |
| creditLimit | – | – | – | |
| taxLiable | – | – | – | |
| taxAreaId | – | – | – | |
| taxAreaDisplayName | – | – | – | |
| taxRegistrationNumber | – | – | – | |
| currencyId | – | – | – | |
| currencyCode | – | – | – | |
| paymentTermsId | – | – | – | |
| shipmentMethodId | – | – | – | |
| paymentMethodId | – | – | – | |
| blocked | – | – | – | |
| lastModifiedDateTime | – | – | – | |
| dimensionValue | – | – | – | |
| currency | – | – | – | |
| paymentTerm | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| code | data/messageBody/canonicalPurchaseOrderHeader/termsOfPayment
|
description | – | |
| displayName | – | – | – | |
| dueDateCalculation | – | – | – | |
| discountDateCalculation | – | – | – | |
| discountPercent | data/messageBody/canonicalPurchaseOrderHeader/termsOfPayment
|
termsOfPaymentPercent | – | |
| calculateDiscountOnCreditMemos | – | – | ||
| lastModifiedDateTime | – | – | – | |
| shipmentMethod | – | – | – | |
| dimensionSetLines | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| code | – | – | – | |
| consolidationCode | – | – | – | |
| parentId | – | – | – | |
| parentType | – | – | – | |
| displayName | – | – | – | |
| valueId | – | – | – | |
| valueCode | – | – | – | |
| valueConsolidationCode | – | – | – | |
| valueDisplayName | – | – | – | |
| salesOrderLines | – | – | – | |
| @odata.etag | – | – | – | |
| id | – | – | – | |
| documentId | – | – | – | |
| sequence | data/messageBody/canonicalPurchaseOrderItemDetails
|
lineItemNumber | – | |
| itemId | – | – | – | |
| accountId | – | – | – | |
| lineType | – | Item | Hard Code to Item | |
| lineObjectNumber | data/messageBody/canonicalPurchaseOrderItemDetails/productCodesIdentifiers
|
productCodeValue | where productCodeType=CUSTOMER | |
| description | data/messageBody/canonicalPurchaseOrderItemDetails/productItemInformation
|
productName | – | |
| description2 | – | – | – | |
| unitOfMeasureId | – | – | – | |
| unitOfMeasureCode | data/messageBody/canonicalPurchaseOrderItemDetails/itemQuantity
|
unitOfMeasure | Only Each and Case are allowed | |
| quantity | data/messageBody/canonicalPurchaseOrderItemDetails/itemQuantity
data/messageBody/canonicalPurchaseOrderItemDetails/deliverySchedule
|
quantityValue scheduledQuantity |
where quantity Type = ITEM | |
| unitPrice | data/messageBody/canonicalPurchaseOrderItemDetails/orderPricing |
pricingAmount | where pricingType=NET | |
| discountAmount | data/messageBody/canonicalPurchaseOrderItemDetails/creditsAndCharges
|
creditChargeAmount | creditChargeType= DISCOUNT | |
| discountPercent | data/messageBody/canonicalPurchaseOrderItemDetails/creditsAndCharges
|
creditChargePercentRate | creditChargeType= DISCOUNT | |
| discountAppliedBeforeTax | – | – | – | |
| amountExcludingTax | – | – | – | |
| taxCode | – | – | – | |
| taxPercent | – | – | – | |
| totalTaxAmount | – | – | – | |
| amountIncludingTax | – | – | – | |
| invoiceDiscountAllocation | – | – | – | |
| netAmount | data/messageBody/canonicalPurchaseOrderItemDetails/orderPricing
|
pricingAmount | where pricingType=NET | |
| netTaxAmount | – | – | – | |
| netAmountIncludingTax | – | – | – | |
| shipmentDate | – | – | – | |
| shippedQuantity | – | – | – | |
| invoicedQuantity | – | – | – | |
| invoiceQuantity | – | – | – | |
| shipQuantity | – | – | – | |
| itemVariantId | – | – | – | |
| locationId | – | – | – | |
| vendor | – | – | – | |
| @odata.context | – | – | – | |
| id | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/mpcCompanyIdentiferList
|
companyIdentiferValue | where companyIdentifierType = COMPANYID | |
| systemVersion | – | – | – | |
| timestamp | – | – | – | |
| name | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation
|
businessName | – | |
| displayName | – | – | – | |
| businessProfileId | – | – | – | |
| systemCreatedAt | – | – | – | |
| systemCreatedBy | – | – | – | |
| systemModifiedAt | – | – | – | |
| systemModifiedBy | – | – | – | |
Tag end
Type = API Reference,; Topic = Multienterprise Information Network Tower (MINT), Transforms,;Persona = TraceLink Administrator, User,; Orchestration = Commerce, Transportation,; Function = Supply Chain, IT, Procurement,
Netsuite ERP
The following are the Netsuite ERP attributes that are mapped with the Canonical attributes and their output path.
- Transform Name:
- STD_Netsuite_SalesOrder_IB
Guidelines
| Netsuite Field Input Element | Output Path | Target Field | Mapping Rules | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | – | – | – | |||||||||
| otherRefNum | data/messageBody/canonicalPurchaseOrderHeader/transactionReferenceIdentifierList
|
b2bTransactionIdentifierValue | where b2bTransactionIdentifierType= PURCHASEORDER | |||||||||
| billAddress | – | – | ||||||||||
| billingAddress | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
address1 | – | |||||||||
| addr1 | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
address2 | – | |||||||||
| addr2 | – | – | – | |||||||||
| addressee | – | – | – | |||||||||
| addrPhone | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
telephone | – | |||||||||
| addrText | – | – | – | |||||||||
| attention | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation
|
businessName | – | |||||||||
| city | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
city | – | |||||||||
| country | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
country | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| override | – | – | – | |||||||||
| state | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
state | – | |||||||||
| zip | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/address
|
postalCode | – | |||||||||
| billingAddress_text | – | – | – | |||||||||
| department | – | – | – | |||||||||
| id | data/messageBody/canonicalPurchaseOrderHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList
|
compnayIdentiferValue | Where companyidentiferType= COMPANYID | |||||||||
| createdDate | data/messageBody/canonicalPurchaseOrderHeader/transactionReferenceIdentifierList
|
transactionDate | where b2bTransactionIdentifierType = PURCHASEORDER b2bTransactionIdentifierValue = id | |||||||||
| currency | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| entity | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| addressBook | – | – | – | |||||||||
| items | – | – | Please choose 0 th record | |||||||||
| addressBookAddress | – | – | – | |||||||||
| addr1 | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
address1 | – | |||||||||
| addr2 | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
address2 | – | |||||||||
| addressee | – | – | – | |||||||||
| addrPhone | – | – | – | |||||||||
| addrText | – | – | – | |||||||||
| attention | – | – | – | |||||||||
| city | – | – | – | |||||||||
| country | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
city | – | |||||||||
| id | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
country | – | |||||||||
| refName | – | – | – | |||||||||
| override | – | – | – | |||||||||
| state | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
state | – | |||||||||
| zip | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/address
|
postalCode | – | |||||||||
| addressBookAddress_text | – | – | – | |||||||||
| addressId | – | – | – | |||||||||
| defaultBilling | – | – | – | |||||||||
| defaultShipping | – | – | – | |||||||||
| id | – | – | – | |||||||||
| internalId | – | – | – | |||||||||
| isResidential | – | – | – | |||||||||
| label | – | – | – | |||||||||
| addressBookAddress | – | – | – | |||||||||
| addr1 | – | – | – | |||||||||
| addressee | – | – | – | |||||||||
| addrPhone | – | – | – | |||||||||
| addrText | – | – | – | |||||||||
| attention | – | – | – | |||||||||
| city | – | – | – | |||||||||
| country | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| override | – | – | – | |||||||||
| state | – | – | – | |||||||||
| zip | – | – | – | |||||||||
| addressBookAddress_text | – | – | – | |||||||||
| addressId | – | – | – | |||||||||
| defaultBilling | – | – | – | |||||||||
| defaultShipping | – | – | – | |||||||||
| id | – | – | – | |||||||||
| internalId | – | – | – | |||||||||
| isResidential | – | – | – | |||||||||
| label | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| balance | – | – | – | |||||||||
| companyName | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation
|
businessName | – | |||||||||
| contact | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| company | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| dateCreated | – | – | – | |||||||||
| – | – | – | ||||||||||
| entityId | – | – | – | |||||||||
| firstName | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| isPrivate | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| lastName | – | – | – | |||||||||
| owner | – | – | – | |||||||||
| salutation | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| title | – | – | – | |||||||||
| contactRoles | – | – | – | |||||||||
| items | – | – | – | |||||||||
| contact | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| category | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| name | – | – | – | |||||||||
| private | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| comments | – | – | – | |||||||||
| company | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| addressBook | – | – | – | |||||||||
| items | – | – | – | |||||||||
| addressBookAddress | – | – | – | |||||||||
| addr1 | – | – | – | |||||||||
| addr2 | – | – | – | |||||||||
| addressee | – | – | – | |||||||||
| addrPhone | – | – | – | |||||||||
| addrText | – | – | – | |||||||||
| city | – | – | – | |||||||||
| country | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| override | – | – | – | |||||||||
| state | – | – | – | |||||||||
| zip | – | – | – | |||||||||
| addressBookAddress_text | – | – | – | |||||||||
| addressId | – | – | – | |||||||||
| defaultBilling | – | – | – | |||||||||
| defaultShipping | – | – | – | |||||||||
| id | – | – | – | |||||||||
| internalId | – | – | – | |||||||||
| label | – | – | – | |||||||||
| addressBookAddress | – | – | – | |||||||||
| addr1 | – | – | – | |||||||||
| addr2 | – | – | – | |||||||||
| addressee | – | – | – | |||||||||
| addrText | – | – | – | |||||||||
| city | – | – | – | |||||||||
| country | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| override | – | – | – | |||||||||
| state | – | – | – | |||||||||
| zip | – | – | – | |||||||||
| addressBookAddress_text | – | – | – | |||||||||
| addressId | – | – | – | |||||||||
| defaultBilling | – | – | – | |||||||||
| defaultShipping | – | – | – | |||||||||
| id | – | – | – | |||||||||
| internalId | – | – | – | |||||||||
| label | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| autoName | – | – | – | |||||||||
| balance | – | – | – | |||||||||
| balancePrimary | – | – | – | |||||||||
| category | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| isTaxAgency | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| longitemtype | – | – | – | |||||||||
| name | – | – | – | |||||||||
| tname | – | – | – | |||||||||
| companyName | – | – | – | |||||||||
| contact | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| contactList | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| currency | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| dateCreated | – | – | – | |||||||||
| defaultAddress | – | – | – | |||||||||
| entityId | – | – | – | |||||||||
| externalId | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList
|
compnayIdentiferValue | Where companyidentiferType= COMPANYID | |||||||||
| fax | – | – | – | |||||||||
| faxTransactions | – | – | – | |||||||||
| giveAccess | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| isJobResourceVend | – | – | – | |||||||||
| isPerson | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| legalName | – | – | – | |||||||||
| printTransactions | – | – | – | |||||||||
| requirePwdChange | – | – | – | |||||||||
| roles | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| sendEmail | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| subsidiaryEdition | – | – | – | |||||||||
| unbilledOrders | – | – | – | |||||||||
| unbilledOrdersPrimary | – | – | – | |||||||||
| contactSource | – | – | – | |||||||||
| links | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| customForm | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| dateCreated | – | – | – | |||||||||
| – | – | – | ||||||||||
| entityId | – | – | – | |||||||||
| firstName | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| isPrivate | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| lastName | – | – | – | |||||||||
| mobilePhone | – | – | – | |||||||||
| owner | – | – | – | |||||||||
| salutation | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| contactName | – | – | – | |||||||||
| – | – | – | ||||||||||
| giveAccess | – | – | – | |||||||||
| role | – | – | – | |||||||||
| links | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| contact | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| category | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| company | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| customForm | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| dateCreated | – | – | – | |||||||||
| – | – | – | ||||||||||
| entityId | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| isPrivate | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| owner | – | – | – | |||||||||
| phone | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| title | – | – | – | |||||||||
| contactName | – | – | – | |||||||||
| – | – | – | ||||||||||
| giveAccess | – | – | – | |||||||||
| role | – | – | – | |||||||||
| links | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| contact | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| contactName | – | – | – | |||||||||
| – | – | – | ||||||||||
| giveAccess | – | – | – | |||||||||
| role | – | – | – | |||||||||
| links | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| currency | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| dateCreated | – | – | – | |||||||||
| defaultAddress | – | – | – | |||||||||
| depositBalance | – | – | – | |||||||||
| – | – | – | ||||||||||
| externalId | data/messageBody/canonicalPurchaseOrderHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList
|
compnayIdentiferValue | Where companyidentiferType= COMPANYID | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| overdueBalance | – | – | – | |||||||||
| partner | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| addressBook | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| category | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| class | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| classTranslation | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| includeChildren | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| name | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| companyName | – | – | – | |||||||||
| contactList | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| customForm | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| dateCreated | – | – | – | |||||||||
| department | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| classTranslation | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| includeChildren | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| name | – | – | – | |||||||||
| parent | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| classTranslation | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| includeChildren | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| name | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| – | – | – | ||||||||||
| emailPreference | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| entityId | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| isPerson | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| location | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| classTranslation | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| inventoryBalance | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| mainAddress | – | – | – | |||||||||
| addressee | – | – | – | |||||||||
| addrText | – | – | – | |||||||||
| country | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| override | – | – | – | |||||||||
| makeInventoryAvailable | – | – | – | |||||||||
| name | – | – | – | |||||||||
| returnAddress | – | – | – | |||||||||
| addrText | – | – | – | |||||||||
| country | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| override | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| timeZone | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| partnerCode | – | – | – | |||||||||
| phone | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| printTransactions | – | – | – | |||||||||
| receivablesAccount | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| sendEmail | – | – | – | |||||||||
| shipComplete | – | – | – | |||||||||
| shippingCarrier | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| startDate | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| terms | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| dateDriven | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| daysUntilExpiry | – | – | – | |||||||||
| daysUntilNetDue | – | – | – | |||||||||
| discountPercent | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| longitemtype | – | – | – | |||||||||
| name | – | – | – | |||||||||
| preferred | – | – | – | |||||||||
| tname | – | – | – | |||||||||
| unbilledOrders | – | – | – | |||||||||
| item | – | – | – | |||||||||
| items | – | – | – | |||||||||
| amount | data/messageBody/canonicalPurchaseOrderItemDetails/orderPricing
|
pricingAmount | where pricingType =NET | |||||||||
| commitInventory | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| item | – | – | – | |||||||||
| id | data/messageBody/canonicalPurchaseOrderItemDetails/productCodesIdentifiers
|
productItemCodeValue | where productCodeType=SUPPLIER | |||||||||
| refName | – | – | – | |||||||||
| assetAccount | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| accountContextSearch | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| acctName | – | – | – | |||||||||
| acctType | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| cashFlowRate | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| eliminate | – | – | – | |||||||||
| generalRate | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| includeChildren | – | – | – | |||||||||
| inventory | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| isSummary | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| localizations | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| restrictToAccountingBook | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| revalue | – | – | – | |||||||||
| sSpecAcct | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| atpMethod | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| baseUnit | – | – | – | |||||||||
| directRevenuePosting | – | – | – | |||||||||
| displayName | data/messageBody/canonicalPurchaseOrderItemDetails/productItemInformation
|
productName | – | |||||||||
| enforceminqtyinternally | – | – | – | |||||||||
| excludeFromSiteMap | – | – | – | |||||||||
| froogleProductFeed | – | – | – | |||||||||
| includeChildren | – | – | – | |||||||||
| incomeAccount | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| accountContextSearch | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| acctName | – | – | – | |||||||||
| acctNumber | – | – | – | |||||||||
| acctType | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| cashFlowRate | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| eliminate | – | – | – | |||||||||
| generalRate | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| includeChildren | – | – | – | |||||||||
| inventory | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| isSummary | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| localizations | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| restrictToAccountingBook | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| revalue | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| internalId | – | – | – | |||||||||
| isGCoCompliant | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| isOnline | – | – | – | |||||||||
| itemId | – | – | – | |||||||||
| itemType | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| itemVendor | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| locations | – | – | – | |||||||||
| items | – | – | – | |||||||||
| location | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| location_display | – | – | – | |||||||||
| locationId | – | – | – | |||||||||
| quantityAvailable | – | – | – | |||||||||
| quantityAvailableBase | – | – | – | |||||||||
| location | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| location_display | – | – | – | |||||||||
| locationId | – | – | – | |||||||||
| averageCostMli | – | – | – | |||||||||
| costAccountingStatus | – | – | – | |||||||||
| location | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| location_display | – | – | – | |||||||||
| locationId | – | – | – | |||||||||
| onHandValueMli | – | – | – | |||||||||
| quantityAvailable | – | – | – | |||||||||
| quantityAvailableBase | – | – | – | |||||||||
| quantityBackOrdered | – | – | – | |||||||||
| quantityCommitted | – | – | – | |||||||||
| quantityOnHand | – | – | – | |||||||||
| quantityOnHandBase | – | – | – | |||||||||
| location | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| location_display | – | – | – | |||||||||
| locationId | – | – | – | |||||||||
| quantityAvailable | – | – | – | |||||||||
| quantityAvailableBase | – | – | – | |||||||||
| averageCostMli | – | – | – | |||||||||
| costAccountingStatus | – | – | – | |||||||||
| lastPurchasePriceMli | – | – | – | |||||||||
| location | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| location_display | – | – | – | |||||||||
| locationId | – | – | – | |||||||||
| onHandValueMli | – | – | – | |||||||||
| quantityAvailable | – | – | – | |||||||||
| quantityAvailableBase | – | – | – | |||||||||
| quantityCommitted | – | – | – | |||||||||
| quantityOnHand | – | – | – | |||||||||
| quantityOnHandBase | – | – | – | |||||||||
| quantityOnOrder | – | – | – | |||||||||
| averageCostMli | – | – | – | |||||||||
| costAccountingStatus | – | – | – | |||||||||
| location | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| location_display | – | – | – | |||||||||
| locationId | – | – | – | |||||||||
| onHandValueMli | – | – | – | |||||||||
| quantityAvailable | – | – | – | |||||||||
| quantityAvailableBase | – | – | – | |||||||||
| quantityCommitted | – | – | – | |||||||||
| quantityOnHand | – | – | – | |||||||||
| quantityOnHandBase | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| manufacturer | – | – | – | |||||||||
| matchBillToReceipt | – | – | – | |||||||||
| nexTagProductFeed | – | – | – | |||||||||
| offerSupport | – | – | – | |||||||||
| purchaseUnit | – | – | – | |||||||||
| saleUnit | – | – | – | |||||||||
| shipIndividually | – | – | – | |||||||||
| shoppingProductFeed | – | – | – | |||||||||
| shopzillaProductFeed | – | – | – | |||||||||
| stockUnit | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| count | – | – | – | |||||||||
| hasMore | – | – | – | |||||||||
| items | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| offset | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| supplyReplenishmentMethod | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| transferPriceUnits | – | – | – | |||||||||
| translations | – | – | – | |||||||||
| items | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| unitsType | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| name | data/messageBody/canonicalPurchaseOrderItemDetails/itemQuantity
|
UnitOfMeasure | – | |||||||||
| uom | – | – | – | |||||||||
| items | – | – | – | |||||||||
| abbreviation | – | – | – | |||||||||
| baseUnit | – | – | – | |||||||||
| conversionRate | – | – | – | |||||||||
| internalId | – | – | – | |||||||||
| inUse | – | – | – | |||||||||
| pluralAbbreviation | – | – | – | |||||||||
| pluralName | – | – | – | |||||||||
| unitName | – | – | – | |||||||||
| totalResults | – | – | – | |||||||||
| updateExistingTranAccounts | – | – | – | |||||||||
| useMarginalRates | – | – | – | |||||||||
| VSOEDelivered | – | – | – | |||||||||
| VSOESopGroup | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| weight | – | – | – | |||||||||
| weightUnit | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| weightUnits | – | – | – | |||||||||
| yahooProductFeed | – | – | – | |||||||||
| itemType | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| line | data/messageBody/canonicalPurchaseOrderItemDetails
|
lineItemNumber | – | |||||||||
| linked | – | – | – | |||||||||
| marginal | – | – | – | |||||||||
| price | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| isInactive | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| longitemtype | – | – | – | |||||||||
| name | – | – | – | |||||||||
| tname | – | – | – | |||||||||
| updateExistingPrices | – | – | – | |||||||||
| printItems | – | – | – | |||||||||
| quantity | data/messageBody/canonicalPurchaseOrderItemDetails/itemQuantity
|
quantityValue | where quantityType = ITEM | |||||||||
| quantityAvailable | – | – | – | |||||||||
| quantityBackOrdered | – | – | – | |||||||||
| quantityBilled | – | – | – | |||||||||
| quantityCommitted | – | – | – | |||||||||
| quantityFulfilled | – | – | – | |||||||||
| rate | data/messageBody/canonicalPurchaseOrderItemDetails/orderPricing
|
pricingAmount | where pricingType=UNIT | |||||||||
| totalResults | – | – | – | |||||||||
| orderStatus | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| prevDate | – | – | – | |||||||||
| shipAddress | – | – | – | |||||||||
| shipDate | – | – | – | |||||||||
| shipIsResidential | – | – | – | |||||||||
| shipOverride | – | – | – | |||||||||
| shippingAddress | – | – | – | |||||||||
| addr1 | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
address1 | – | |||||||||
| addr2 | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
address2 | – | |||||||||
| addressee | – | – | – | |||||||||
| addrPhone | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
telephone | – | |||||||||
| addrText | – | – | – | |||||||||
| attention | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation
|
businessName | – | |||||||||
| city | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
city | – | |||||||||
| country | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
country | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| override | – | – | – | |||||||||
| state | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
state | – | |||||||||
| zip | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/address
|
postalCode | – | |||||||||
| shippingAddress_text | – | – | – | |||||||||
| status | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| subsidiary | – | – | – | |||||||||
| id | data/messageBody/canonicalPurchaseOrderHeader/shipToLocationInformation/mpcCompanyLocationIdentifierList
|
companyIdentifierValue | Where companyIdentifierType= COMPNAYID | |||||||||
| refName | – | – | – | |||||||||
| shipAddressList | – | – | – | |||||||||
| links | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| terms | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| dateDriven | – | – | – | |||||||||
| id | – | – | – | |||||||||
| refName | – | – | – | |||||||||
| dayDiscountExpires | – | – | – | |||||||||
| dayOfMonthNetDue | – | – | – | |||||||||
| discountPercentDateDriven | data/messageBody/canonicalPurchaseOrderHeader/termsOfPayment
|
termsOfPaymentPercent | – | |||||||||
| dueNextMonthIfWithinDays | data/messageBody/canonicalPurchaseOrderHeader/termsOfPayment
|
numberOfDays | – | |||||||||
| isInactive | – | – | – | |||||||||
| lastModifiedDate | – | – | – | |||||||||
| longitemtype | – | – | – | |||||||||
| name | data/messageBody/canonicalPurchaseOrderHeader/termsOfPayment
|
termsOfPaymentKey | – | |||||||||
| preferred | – | – | – | |||||||||
| tname | – | – | – | |||||||||
Tag end
