Sales Agreement Lines

In Scope

Technical: SalesAgreementLine | ID: D365FO-SLS-SALESAGREEMENTLINE-SALES_AGREEMENT_LINES

See how this object fits into Sales

Review the broader sequencing and dependencies for this domain

Migration Details

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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: SalesAgreementLine

Field Definitions(5)

Sample Load Data(4)

_scenario	QTYR	ITEMIDR	LINENUMRPK	SALESAGREEMENTIDRPK	NAME	UNITID	PriceUnit	SALESUNIT	UNITPRICE	FixedPrice	LINEAMOUNT	VALIDTODATE	CURRENCYCODE	InventSiteId	SalesTaxGroup	VALIDFROMDATE	CommitmentType	InventLocationId	ItemSalesTaxGroup	DefaultDimensionDisplayValue
Example values from field definitions	100.0	P0001	1	SA-000001	Laptop Model X	EA	1.0	EA	1200.0	Yes	120000.0	2023-12-31	USD	USMF	DOMESTIC	2023-01-01	QuantityCommitment	WH1	TAXABLE	BU001-DEP002
Value Commitment, Different Product and Currency	0	P0002	1	SA-000002	Monitor 27-inch	EA	1	EA	0	No	50000	2024-03-14	EUR	FRMF	EU_INTRA	2023-03-15	ValueCommitment	WH2	ZERO	BU002-DEP003-CC001
Open Quantity Commitment, No End Date, Minimal Dimensions	1	P0003	1	SA-000003	Service Contract - Annual	SVC	1	SVC	500	Yes	500	—	GBP	UKMF	UK_VAT	2023-06-01	OpenQuantity	WH3	SRV	—

Example values from field definitions

QTYR: 100.0
ITEMIDR: P0001
LINENUMRPK: 1
SALESAGREEMENTIDRPK: SA-000001
NAME: Laptop Model X
UNITID: EA
PriceUnit: 1.0
SALESUNIT: EA
UNITPRICE: 1200.0
FixedPrice: Yes
LINEAMOUNT: 120000.0
VALIDTODATE: 2023-12-31
CURRENCYCODE: USD
InventSiteId: USMF
SalesTaxGroup: DOMESTIC
VALIDFROMDATE: 2023-01-01
CommitmentType: QuantityCommitment
InventLocationId: WH1
ItemSalesTaxGroup: TAXABLE
DefaultDimensionDisplayValue: BU001-DEP002

Value Commitment, Different Product and Currency

QTYR: 0
ITEMIDR: P0002
LINENUMRPK: 1
SALESAGREEMENTIDRPK: SA-000002
NAME: Monitor 27-inch
UNITID: EA
PriceUnit: 1
SALESUNIT: EA
UNITPRICE: 0
FixedPrice: No
LINEAMOUNT: 50000
VALIDTODATE: 2024-03-14
CURRENCYCODE: EUR
InventSiteId: FRMF
SalesTaxGroup: EU_INTRA
VALIDFROMDATE: 2023-03-15
CommitmentType: ValueCommitment
InventLocationId: WH2
ItemSalesTaxGroup: ZERO
DefaultDimensionDisplayValue: BU002-DEP003-CC001

Open Quantity Commitment, No End Date, Minimal Dimensions

QTYR: 1
ITEMIDR: P0003
LINENUMRPK: 1
SALESAGREEMENTIDRPK: SA-000003
NAME: Service Contract - Annual
UNITID: SVC
PriceUnit: 1
SALESUNIT: SVC
UNITPRICE: 500
FixedPrice: Yes
LINEAMOUNT: 500
VALIDTODATE: —
CURRENCYCODE: GBP
InventSiteId: UKMF
SalesTaxGroup: UK_VAT
VALIDFROMDATE: 2023-06-01
CommitmentType: OpenQuantity
InventLocationId: WH3
ItemSalesTaxGroup: SRV
DefaultDimensionDisplayValue: —

Rule Validation Summary

Source Rule Count: 23
Governed Rule Count: 23