Open Sales Orders

In Scope

Technical: SalesTable | ID: D365FO-SLS-SALESTABLE-OPEN_SALES_ORDERS

See how this object fits into Sales

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: High
Sequencing: Stage 3 - Open Transactions
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: SalesTable

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(56)

validation

constraint

Sample Load Data(4)

_scenario	SALESIDRPK	ORDERDATER	CUSTACCOUNTR	CURRENCYCODER	DUE_DATE	SalesName	SalesType	DataAreaId	SALESGROUP	SALESTAKER	SalesUnitId	DELIVERYDATE	CUSTSALESUNIT	DELIVERYTERMS	INVOICEACCOUNT	SalesOrderDate	CREATEDDATETIME	ContactPersonId	CustomerGroupId	DeliveryTermsId	CashDiscountCode	DeliveryModeCode	PaymentTermsName	SalesOrderNumber	SalesOrderPoolId	SalesOrderStatus	FixedExchangeRate	PaymentMethodName	RequestedShipDate	SalesTaxGroupCode	DeliveryAddressCity	DeliveryAddressName	HeaderChargeGroupId	IntercompanySalesId	TotalDiscountAmount	DeliveryAddressState	SalesOrderOriginCode	DefaultShippingSiteId	DeliveryAddressStreet	RequestedDeliveryDate	ShippingDateConfirmed	DeliveryAddressZipCode	DEFAULTINVENTLOCATIONID	TotalDiscountPercentage	FormattedDeliveryAddress	CustomerRequisitionNumber	DeliveryAddressLocationId	DefaultShippingWarehouseId	DeliveryAddressStreetNumber	DefaultDimensionDisplayValue	InvoiceCustomerAccountNumber	SalesResponsibleSalesGroupId	OrderingCustomerAccountNumber	DeliveryAddressCountryRegionId	SalesOrderTakerPersonnelNumber	OrderAttachedToOpenPurchaseOrder
Example values from field definitions	SO-10000054	2024-03-15	C0012345	USD	2024-04-01	Annual Supply Contract Q4	Sales order	USMF	EAST	JSMITH	EA	2024-04-02	EA	FOB	C0012345	2023-10-26	2024-03-15T10:30:00Z	JOHN.DOE	LARGE	FOB	2PCT10	TRUCK	NET30	SO-001234	WEB	Open order	1.150000	ELEC	2023-11-05	US_SALES	New York	Customer US-001 Warehouse 2	FREIGHT	IC-0050	50.00	NY	WEB	USWH	Main Street	2023-11-10	2023-11-07	10001	WH01	5.00	123 Main Street New York, NY 10001 USA	PO123456	CUST-001-DLV	001	123	BusinessUnit-001\|Department-022\|CostCenter-100	US-002	EAST	US-001	USA	000123	No
Variation 1 - type-safe variation anchored to example values	SO1000005402	20240421	C0012341	VSD	20240508	ANNUALSUPPLYCONTRACTQ402	SALESORDE02	VSMF	FAST	KSMITH	FA	20240509	FA	GOB	C0012341	20231202	20240315T103000Z02	JOHNDOE02	MARGE	GOB	2PCT11	URUCK	NET31	SO00123402	XEB	OPENORDE02	11500002	FLEC	20231212	USSALES02	NEWYORK02	CUSTOMERUS001WAREHOUSE202	GREIGHT	IC005002	50002	OY	XEB	VSWH	MAINSTREET02	20231217	20231214	10001	WH01	5002	123MAINSTREETNEWYORKNY10001USA02	PO123451	CUST001DLV02	001	121	BUSINESSUNIT001DEPARTMENT022COSTCENTER10002	US00202	FAST	US00102	VSA	000121	OO
Variation 2 - additional in-range variation with row-level constraint alignment	SO1000005403	20240528	C0012342	UUD	20240614	ANNUALSUPPLYCONTRACTQ403	SALESORDE03	UUMF	ECST	JUMITH	EC	20240615	EC	FQB	C0012342	20240108	20240315T103000Z03	JOHNDOE03	LCRGE	FQB	2PCT12	TTUCK	NET32	SO00123403	WGB	OPENORDE03	11500003	ENEC	20240118	USSALES03	NEWYORK03	CUSTOMERUS001WAREHOUSE203	FTEIGHT	IC005003	50003	NA	WGB	UUWH	MAINSTREET03	20240123	20240120	10002	WH02	5003	123MAINSTREETNEWYORKNY10001USA03	PO123452	CUST001DLV03	002	122	BUSINESSUNIT001DEPARTMENT022COSTCENTER10003	US00203	ECST	US00103	UUA	000122	NQ

Example values from field definitions

SALESIDRPK: SO-10000054
ORDERDATER: 2024-03-15
CUSTACCOUNTR: C0012345
CURRENCYCODER: USD
DUE_DATE: 2024-04-01
SalesName: Annual Supply Contract Q4
SalesType: Sales order
DataAreaId: USMF
SALESGROUP: EAST
SALESTAKER: JSMITH
SalesUnitId: EA
DELIVERYDATE: 2024-04-02
CUSTSALESUNIT: EA
DELIVERYTERMS: FOB
INVOICEACCOUNT: C0012345
SalesOrderDate: 2023-10-26
CREATEDDATETIME: 2024-03-15T10:30:00Z
ContactPersonId: JOHN.DOE
CustomerGroupId: LARGE
DeliveryTermsId: FOB
CashDiscountCode: 2PCT10
DeliveryModeCode: TRUCK
PaymentTermsName: NET30
SalesOrderNumber: SO-001234
SalesOrderPoolId: WEB
SalesOrderStatus: Open order
FixedExchangeRate: 1.150000
PaymentMethodName: ELEC
RequestedShipDate: 2023-11-05
SalesTaxGroupCode: US_SALES
DeliveryAddressCity: New York
DeliveryAddressName: Customer US-001 Warehouse 2
HeaderChargeGroupId: FREIGHT
IntercompanySalesId: IC-0050
TotalDiscountAmount: 50.00
DeliveryAddressState: NY
SalesOrderOriginCode: WEB
DefaultShippingSiteId: USWH
DeliveryAddressStreet: Main Street
RequestedDeliveryDate: 2023-11-10
ShippingDateConfirmed: 2023-11-07
DeliveryAddressZipCode: 10001
DEFAULTINVENTLOCATIONID: WH01
TotalDiscountPercentage: 5.00
FormattedDeliveryAddress: 123 Main Street New York, NY 10001 USA
CustomerRequisitionNumber: PO123456
DeliveryAddressLocationId: CUST-001-DLV
DefaultShippingWarehouseId: 001
DeliveryAddressStreetNumber: 123
DefaultDimensionDisplayValue: BusinessUnit-001|Department-022|CostCenter-100
InvoiceCustomerAccountNumber: US-002
SalesResponsibleSalesGroupId: EAST
OrderingCustomerAccountNumber: US-001
DeliveryAddressCountryRegionId: USA
SalesOrderTakerPersonnelNumber: 000123
OrderAttachedToOpenPurchaseOrder: No

Variation 1 - type-safe variation anchored to example values

SALESIDRPK: SO1000005402
ORDERDATER: 20240421
CUSTACCOUNTR: C0012341
CURRENCYCODER: VSD
DUE_DATE: 20240508
SalesName: ANNUALSUPPLYCONTRACTQ402
SalesType: SALESORDE02
DataAreaId: VSMF
SALESGROUP: FAST
SALESTAKER: KSMITH
SalesUnitId: FA
DELIVERYDATE: 20240509
CUSTSALESUNIT: FA
DELIVERYTERMS: GOB
INVOICEACCOUNT: C0012341
SalesOrderDate: 20231202
CREATEDDATETIME: 20240315T103000Z02
ContactPersonId: JOHNDOE02
CustomerGroupId: MARGE
DeliveryTermsId: GOB
CashDiscountCode: 2PCT11
DeliveryModeCode: URUCK
PaymentTermsName: NET31
SalesOrderNumber: SO00123402
SalesOrderPoolId: XEB
SalesOrderStatus: OPENORDE02
FixedExchangeRate: 11500002
PaymentMethodName: FLEC
RequestedShipDate: 20231212
SalesTaxGroupCode: USSALES02
DeliveryAddressCity: NEWYORK02
DeliveryAddressName: CUSTOMERUS001WAREHOUSE202
HeaderChargeGroupId: GREIGHT
IntercompanySalesId: IC005002
TotalDiscountAmount: 50002
DeliveryAddressState: OY
SalesOrderOriginCode: XEB
DefaultShippingSiteId: VSWH
DeliveryAddressStreet: MAINSTREET02
RequestedDeliveryDate: 20231217
ShippingDateConfirmed: 20231214
DeliveryAddressZipCode: 10001
DEFAULTINVENTLOCATIONID: WH01
TotalDiscountPercentage: 5002
FormattedDeliveryAddress: 123MAINSTREETNEWYORKNY10001USA02
CustomerRequisitionNumber: PO123451
DeliveryAddressLocationId: CUST001DLV02
DefaultShippingWarehouseId: 001
DeliveryAddressStreetNumber: 121
DefaultDimensionDisplayValue: BUSINESSUNIT001DEPARTMENT022COSTCENTER10002
InvoiceCustomerAccountNumber: US00202
SalesResponsibleSalesGroupId: FAST
OrderingCustomerAccountNumber: US00102
DeliveryAddressCountryRegionId: VSA
SalesOrderTakerPersonnelNumber: 000121
OrderAttachedToOpenPurchaseOrder: OO

Variation 2 - additional in-range variation with row-level constraint alignment

SALESIDRPK: SO1000005403
ORDERDATER: 20240528
CUSTACCOUNTR: C0012342
CURRENCYCODER: UUD
DUE_DATE: 20240614
SalesName: ANNUALSUPPLYCONTRACTQ403
SalesType: SALESORDE03
DataAreaId: UUMF
SALESGROUP: ECST
SALESTAKER: JUMITH
SalesUnitId: EC
DELIVERYDATE: 20240615
CUSTSALESUNIT: EC
DELIVERYTERMS: FQB
INVOICEACCOUNT: C0012342
SalesOrderDate: 20240108
CREATEDDATETIME: 20240315T103000Z03
ContactPersonId: JOHNDOE03
CustomerGroupId: LCRGE
DeliveryTermsId: FQB
CashDiscountCode: 2PCT12
DeliveryModeCode: TTUCK
PaymentTermsName: NET32
SalesOrderNumber: SO00123403
SalesOrderPoolId: WGB
SalesOrderStatus: OPENORDE03
FixedExchangeRate: 11500003
PaymentMethodName: ENEC
RequestedShipDate: 20240118
SalesTaxGroupCode: USSALES03
DeliveryAddressCity: NEWYORK03
DeliveryAddressName: CUSTOMERUS001WAREHOUSE203
HeaderChargeGroupId: FTEIGHT
IntercompanySalesId: IC005003
TotalDiscountAmount: 50003
DeliveryAddressState: NA
SalesOrderOriginCode: WGB
DefaultShippingSiteId: UUWH
DeliveryAddressStreet: MAINSTREET03
RequestedDeliveryDate: 20240123
ShippingDateConfirmed: 20240120
DeliveryAddressZipCode: 10002
DEFAULTINVENTLOCATIONID: WH02
TotalDiscountPercentage: 5003
FormattedDeliveryAddress: 123MAINSTREETNEWYORKNY10001USA03
CustomerRequisitionNumber: PO123452
DeliveryAddressLocationId: CUST001DLV03
DefaultShippingWarehouseId: 002
DeliveryAddressStreetNumber: 122
DefaultDimensionDisplayValue: BUSINESSUNIT001DEPARTMENT022COSTCENTER10003
InvoiceCustomerAccountNumber: US00203
SalesResponsibleSalesGroupId: ECST
OrderingCustomerAccountNumber: US00103
DeliveryAddressCountryRegionId: UUA
SalesOrderTakerPersonnelNumber: 000122
OrderAttachedToOpenPurchaseOrder: NQ

Rule Validation Summary

Source Rule Count: 56
Governed Rule Count: 56

All objects