Sales Order Mappings


Red = Can be Imported

* = Required

Sales Orders

Name

Description

Type

Values

ExternalId*

  String Sales Order ID

Name*

Unique, changeable, text identifier. String Sales Order Name

CancelAtExpirationDate

  Boolean  

Cancelled

  Boolean  

Customer

  String  

Description

Text for describing the object. String  

Estimate

If true then this is a quote, not a firm order. Boolean  

ExpirationDate

  DateTime  

Notes

Comments or special considerations pertaining to this object. String  

Planner

The User responsible for planning this demand if planning by demand rather than by product or location. String  

Project

Can be used for tracking multiple demands tied to one project. String  

SalesAmount

  Decimal  

SalesOffice

Specifies the sales office or other physical location that created the demand. This has no effect on the Warehouse that satisfies the order. It is for reference only. String  

SalesPerson

The employee in sales who is responsible for this demand. String  

UserFields

Optional list of user-defined fields. Null if not initialized. String  

Sales Order Lines

ItemExternalId*

  String  

LineNumber*

  String  

SalesOrderExternalId*

  String  

Description

  String  

UnitPrice

  Decimal  

Sales Order Lines Distributions

SalesOrderExternalId*

  String  

LineNumber*

  String  

MustSupplyFromWarehouseExternalId*

  String  

QtyOpenToShip*

  Double  

RequiredAvailableDate*

  DateTime  

QtyOrdered

  Double  

ShipToZone

  String  

SalesRegion

  String  

Closed

  Boolean  

Hold

  Boolean  

HoldReason

  String  

Priority

  Int32  

MaximumLatenessDays

  Double  

AllowPartialAllocations

  Boolean  

MinAllocationQty

  Double  

StockShortageRule

  String