Open Sales Order Lines
In ScopeTechnical: SalesLine | ID: D365FO-SLS-SALESLINE-OPEN_SALES_ORDER_LINES
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
- SalesLine
This object has high complexity or dependency level
Review sequencing requirements before loading
Field Definitions(5)
Rules & Considerations(13)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMIDR | LINENUMR | SALESIDR | SALESQTYR | RECID | UNITID | LINEAMOUNT | SALESPRICE | CUSTACCOUNT | INVENTDIMID | DELIVERYDATE | REMAINSALESINVENT | INTERCOMPANYORIGIN | REMAINSALESFINANCIAL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | P-1001 | 100000001 | SO-000001 | 50.0 | 5637144576 | EA | 4997.5 | 99.95 | C-00123 | WH01-DEFAULT | 2025-04-15 | 50.0 | 0 | 4997.5 |
| Variation 1 - type-safe variation anchored to example values | P100102 | 100000002 | SO00000102 | 5002 | 5637144502 | FA | 499702 | 99902 | C0012302 | WH01DEFAULT02 | 20250522 | 5002 | 1 | 499702 |
| Variation 2 - additional in-range variation with row-level constraint alignment | P100103 | 100000003 | SO00000103 | 5003 | 5637144503 | EC | 499703 | 99903 | C0012303 | WH01DEFAULT03 | 20250628 | 5003 | 0 | 499703 |
Example values from field definitions
- ITEMIDR
- P-1001
- LINENUMR
- 100000001
- SALESIDR
- SO-000001
- SALESQTYR
- 50.0
- RECID
- 5637144576
- UNITID
- EA
- LINEAMOUNT
- 4997.5
- SALESPRICE
- 99.95
- CUSTACCOUNT
- C-00123
- INVENTDIMID
- WH01-DEFAULT
- DELIVERYDATE
- 2025-04-15
- REMAINSALESINVENT
- 50.0
- INTERCOMPANYORIGIN
- 0
- REMAINSALESFINANCIAL
- 4997.5
Variation 1 - type-safe variation anchored to example values
- ITEMIDR
- P100102
- LINENUMR
- 100000002
- SALESIDR
- SO00000102
- SALESQTYR
- 5002
- RECID
- 5637144502
- UNITID
- FA
- LINEAMOUNT
- 499702
- SALESPRICE
- 99902
- CUSTACCOUNT
- C0012302
- INVENTDIMID
- WH01DEFAULT02
- DELIVERYDATE
- 20250522
- REMAINSALESINVENT
- 5002
- INTERCOMPANYORIGIN
- 1
- REMAINSALESFINANCIAL
- 499702
Variation 2 - additional in-range variation with row-level constraint alignment
- ITEMIDR
- P100103
- LINENUMR
- 100000003
- SALESIDR
- SO00000103
- SALESQTYR
- 5003
- RECID
- 5637144503
- UNITID
- EC
- LINEAMOUNT
- 499703
- SALESPRICE
- 99903
- CUSTACCOUNT
- C0012303
- INVENTDIMID
- WH01DEFAULT03
- DELIVERYDATE
- 20250628
- REMAINSALESINVENT
- 5003
- INTERCOMPANYORIGIN
- 0
- REMAINSALESFINANCIAL
- 499703
Rule Validation Summary
- Source Rule Count
- 13
- Governed Rule Count
- 13