Open Purchase Order Lines

In Scope

Technical: PurchLine | ID: D365FO-PRC-PURCHLINE-OPEN_PURCHASE_ORDER_LINES

See how this object fits into Vendors Procurement

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: PurchLine

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(32)

validation

constraint

Sample Load Data(4)

_scenario	ItemIdR	LineNumRPK	PurchIdRPK	PurchQtyR	SiteId	LineDisc	TaxGroup	ProjectId	LineAmount	PurchPrice	InventDimId	PurchUnitId	WarehouseId	CurrencyCode	DeliveryDate	OrderAccount	TaxItemGroup	MarkupTransId	LinePropertyId	LineDescription	ProjectCategoryId	ReceiptDateConfirmed	ProjectActivityNumber	ProcurementCategoryName	DefaultLedgerDimensionDisplayValue
Example values from field definitions	P0001	10000	PO-2024-001	100.00	USMF	5.00	US-DOM	PRJ-BLDG-005	1575.00	15.75	000005_001_A	EA	11	USD	2024-03-15	V-000001	STD	5637144576	ROYALTY	High-performance CPU for server upgrade, model XZ-2000	MATER_PURCH	2024-03-20	DES-PH1-T001	IT Services\Software Licensing	Department-001-CostCenter-003
Closed historical record - fully received & invoiced line retained for audit	S0009	40000	PO-2023-089	0.00	VSMF	10.00	UK-DOM		0.00	250.00	000012_002_B	FA	11	GBP	20230815	V-UK-OLD-07	TTD			Legacy office-supply toner cartridges, fully closed		20230814		Office Supplies\Consumables	Department-004-CostCenter-007
Minimal open line - service item without inventory dimensions	P0002	20000	PO-2024-112	1.00	UUMF	—	—	MINI_OPEN_LINE	1200.00	1200.00	MINI_OPEN_LINE	EC	12	EUR	20240501	V-SAN-001	—	5637144503	RQYALTY	—	MINI_OPEN_LINE	—	MINI_OPEN_LINE	Facility Services\Cleaning	—

Example values from field definitions

ItemIdR: P0001
LineNumRPK: 10000
PurchIdRPK: PO-2024-001
PurchQtyR: 100.00
SiteId: USMF
LineDisc: 5.00
TaxGroup: US-DOM
ProjectId: PRJ-BLDG-005
LineAmount: 1575.00
PurchPrice: 15.75
InventDimId: 000005_001_A
PurchUnitId: EA
WarehouseId: 11
CurrencyCode: USD
DeliveryDate: 2024-03-15
OrderAccount: V-000001
TaxItemGroup: STD
MarkupTransId: 5637144576
LinePropertyId: ROYALTY
LineDescription: High-performance CPU for server upgrade, model XZ-2000
ProjectCategoryId: MATER_PURCH
ReceiptDateConfirmed: 2024-03-20
ProjectActivityNumber: DES-PH1-T001
ProcurementCategoryName: IT Services\Software Licensing
DefaultLedgerDimensionDisplayValue: Department-001-CostCenter-003

Closed historical record - fully received & invoiced line retained for audit

ItemIdR: S0009
LineNumRPK: 40000
PurchIdRPK: PO-2023-089
PurchQtyR: 0.00
SiteId: VSMF
LineDisc: 10.00
TaxGroup: UK-DOM
ProjectId
LineAmount: 0.00
PurchPrice: 250.00
InventDimId: 000012_002_B
PurchUnitId: FA
WarehouseId: 11
CurrencyCode: GBP
DeliveryDate: 20230815
OrderAccount: V-UK-OLD-07
TaxItemGroup: TTD
MarkupTransId
LinePropertyId
LineDescription: Legacy office-supply toner cartridges, fully closed
ProjectCategoryId
ReceiptDateConfirmed: 20230814
ProjectActivityNumber
ProcurementCategoryName: Office Supplies\Consumables
DefaultLedgerDimensionDisplayValue: Department-004-CostCenter-007

Minimal open line - service item without inventory dimensions

ItemIdR: P0002
LineNumRPK: 20000
PurchIdRPK: PO-2024-112
PurchQtyR: 1.00
SiteId: UUMF
LineDisc: —
TaxGroup: —
ProjectId: MINI_OPEN_LINE
LineAmount: 1200.00
PurchPrice: 1200.00
InventDimId: MINI_OPEN_LINE
PurchUnitId: EC
WarehouseId: 12
CurrencyCode: EUR
DeliveryDate: 20240501
OrderAccount: V-SAN-001
TaxItemGroup: —
MarkupTransId: 5637144503
LinePropertyId: RQYALTY
LineDescription: —
ProjectCategoryId: MINI_OPEN_LINE
ReceiptDateConfirmed: —
ProjectActivityNumber: MINI_OPEN_LINE
ProcurementCategoryName: Facility Services\Cleaning
DefaultLedgerDimensionDisplayValue: —

Rule Validation Summary

Source Rule Count: 32
Governed Rule Count: 32