Purchase Line
In ScopeTechnical: purchase_line | ID: D365BC-OPEN-PURCHASE_LINE
D365 BC migration object for Purchase Line.
See how this object fits into Open Transactions Cutover
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- High
- Sequencing
- Open Transactions
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- Purchase Line
This object has high complexity or dependency level
Review sequencing requirements before loading
Field Definitions(5)
Rules & Considerations(21)
constraint
validation
Sample Load Data(5)
| _scenario | Document No.RPK | Document TypeRPK | No. | Line No. | Quantity | CUTOVER_WAVE | DEPENDENCY_LEVEL | Direct Unit Cost | EFFECTIVE_TO_DATE | SOURCE_ROW_NUMBER | LINE_REFERENCE_KEY | PURCHASE_LINE_NAME | EFFECTIVE_FROM_DATE | LOAD_SEQUENCE_STAGE | PURCHASE_REFERENCE_KEY | PURCHASE_LINE_SOURCE_ID | PURCHASE_LINE_CHANGE_HASH | PURCHASE_LINE_DESCRIPTION | PURCHASE_LINE_STATUS_CODE | PURCHASE_LINE_ATTRIBUTE_01 | PURCHASE_LINE_ATTRIBUTE_02 | PURCHASE_LINE_BUSINESS_KEY | PURCHASE LINE_REFERENCE_KEY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | Document No. | Document Type | No. | 1 | 100.00 | Purchase Line-006 | Purchase Line-007 | 100.00 | 2026-01-13 | 14 | STD-PURCHASE_L-001 | Purchase Line Primary | 2026-01-12 | Open Transactions | STD-PURCHASE_L-001 | SRC-PURCHASE_L-001 | Purchase Line-015 | Purchase Line: Baseline migration row | ACTIVE | Purchase Line-016 | Purchase Line-017 | BK-PURCHASE_LIN-001 | STD-PURCHASE_L-001 |
| default | — | — | — | — | — | Purchase Line-006 | MEDIUM-ALT | — | 2026-01-14 | 15 | ALT-PURCHASE_L-002 | Purchase Line Secondary | 2026-01-13 | Open Transactions | ALT-PURCHASE_L-002 | LEG-PURCHASE_L-002 | Purchase Line-015-ALT | Purchase Line: Alternate source profile | PENDING | Purchase Line-016-ALT | Purchase Line-017-ALT | ALT-PURCHASE_LIN-002 | ALT-PURCHASE_L-002 |
| default | — | — | — | — | — | Purchase Line-006 | Purchase Line-007 | — | 2026-01-15 | 16 | — | Purchase Line Legacy | 2026-01-14 | Open Transactions | — | EXT-PURCHASE_L-003 | Purchase Line-015-EDGE | — | HOLD | — | — | EDGE-PURCHASE_LIN-003 | — |
Example values from field definitions
- Document No.RPK
- Document No.
- Document TypeRPK
- Document Type
- No.
- No.
- Line No.
- 1
- Quantity
- 100.00
- CUTOVER_WAVE
- Purchase Line-006
- DEPENDENCY_LEVEL
- Purchase Line-007
- Direct Unit Cost
- 100.00
- EFFECTIVE_TO_DATE
- 2026-01-13
- SOURCE_ROW_NUMBER
- 14
- LINE_REFERENCE_KEY
- STD-PURCHASE_L-001
- PURCHASE_LINE_NAME
- Purchase Line Primary
- EFFECTIVE_FROM_DATE
- 2026-01-12
- LOAD_SEQUENCE_STAGE
- Open Transactions
- PURCHASE_REFERENCE_KEY
- STD-PURCHASE_L-001
- PURCHASE_LINE_SOURCE_ID
- SRC-PURCHASE_L-001
- PURCHASE_LINE_CHANGE_HASH
- Purchase Line-015
- PURCHASE_LINE_DESCRIPTION
- Purchase Line: Baseline migration row
- PURCHASE_LINE_STATUS_CODE
- ACTIVE
- PURCHASE_LINE_ATTRIBUTE_01
- Purchase Line-016
- PURCHASE_LINE_ATTRIBUTE_02
- Purchase Line-017
- PURCHASE_LINE_BUSINESS_KEY
- BK-PURCHASE_LIN-001
- PURCHASE LINE_REFERENCE_KEY
- STD-PURCHASE_L-001
default
- Document No.RPK
- —
- Document TypeRPK
- —
- No.
- —
- Line No.
- —
- Quantity
- —
- CUTOVER_WAVE
- Purchase Line-006
- DEPENDENCY_LEVEL
- MEDIUM-ALT
- Direct Unit Cost
- —
- EFFECTIVE_TO_DATE
- 2026-01-14
- SOURCE_ROW_NUMBER
- 15
- LINE_REFERENCE_KEY
- ALT-PURCHASE_L-002
- PURCHASE_LINE_NAME
- Purchase Line Secondary
- EFFECTIVE_FROM_DATE
- 2026-01-13
- LOAD_SEQUENCE_STAGE
- Open Transactions
- PURCHASE_REFERENCE_KEY
- ALT-PURCHASE_L-002
- PURCHASE_LINE_SOURCE_ID
- LEG-PURCHASE_L-002
- PURCHASE_LINE_CHANGE_HASH
- Purchase Line-015-ALT
- PURCHASE_LINE_DESCRIPTION
- Purchase Line: Alternate source profile
- PURCHASE_LINE_STATUS_CODE
- PENDING
- PURCHASE_LINE_ATTRIBUTE_01
- Purchase Line-016-ALT
- PURCHASE_LINE_ATTRIBUTE_02
- Purchase Line-017-ALT
- PURCHASE_LINE_BUSINESS_KEY
- ALT-PURCHASE_LIN-002
- PURCHASE LINE_REFERENCE_KEY
- ALT-PURCHASE_L-002
default
- Document No.RPK
- —
- Document TypeRPK
- —
- No.
- —
- Line No.
- —
- Quantity
- —
- CUTOVER_WAVE
- Purchase Line-006
- DEPENDENCY_LEVEL
- Purchase Line-007
- Direct Unit Cost
- —
- EFFECTIVE_TO_DATE
- 2026-01-15
- SOURCE_ROW_NUMBER
- 16
- LINE_REFERENCE_KEY
- —
- PURCHASE_LINE_NAME
- Purchase Line Legacy
- EFFECTIVE_FROM_DATE
- 2026-01-14
- LOAD_SEQUENCE_STAGE
- Open Transactions
- PURCHASE_REFERENCE_KEY
- —
- PURCHASE_LINE_SOURCE_ID
- EXT-PURCHASE_L-003
- PURCHASE_LINE_CHANGE_HASH
- Purchase Line-015-EDGE
- PURCHASE_LINE_DESCRIPTION
- —
- PURCHASE_LINE_STATUS_CODE
- HOLD
- PURCHASE_LINE_ATTRIBUTE_01
- —
- PURCHASE_LINE_ATTRIBUTE_02
- —
- PURCHASE_LINE_BUSINESS_KEY
- EDGE-PURCHASE_LIN-003
- PURCHASE LINE_REFERENCE_KEY
- —
Rule Validation Summary
- Source Rule Count
- 21
- Governed Rule Count
- 6