Open Project Balances

In Scope

Technical: ProjOnAccount | ID: D365FO-PRJ-PROJONACCOUNT-OPEN_PROJECT_BALANCES

See how this object fits into Projects

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

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(17)

validation

constraint

Sample Load Data(4)

_scenario	ProjIdRPK	TransDateRPK	MainAccountIdRPK	Reference	Description	CurrencyCode	OffsetProjId	AmountCurDebit	AmountCurCredit	LedgerDimension	OffsetLedgerDimension
Example values from field definitions	PJ0001	2023-12-31	140110	LEGACYINV-P001	Project A/R Balance Cutover 2023	USD	PJ0002	15000.00	12500.50	140110-BU001-DP001	500110-BU001-DP001
Variation 1 - type-safe variation anchored to example values	PJ0001	20240206	140111	LEGACYINVP00102	PROJECTARBALANCECUTOVER202302	VSD	PJ0001	15000002	12500502	140110BU001DP00102	500110BU001DP00102
Variation 2 - additional in-range variation with row-level constraint alignment	PJ0002	20240314	140112	LEGACYINVP00103	PROJECTARBALANCECUTOVER202303	UUD	PJ0002	15000003	12500503	140110BU001DP00103	500110BU001DP00103

Example values from field definitions

ProjIdRPK: PJ0001
TransDateRPK: 2023-12-31
MainAccountIdRPK: 140110
Reference: LEGACYINV-P001
Description: Project A/R Balance Cutover 2023
CurrencyCode: USD
OffsetProjId: PJ0002
AmountCurDebit: 15000.00
AmountCurCredit: 12500.50
LedgerDimension: 140110-BU001-DP001
OffsetLedgerDimension: 500110-BU001-DP001

Variation 1 - type-safe variation anchored to example values

ProjIdRPK: PJ0001
TransDateRPK: 20240206
MainAccountIdRPK: 140111
Reference: LEGACYINVP00102
Description: PROJECTARBALANCECUTOVER202302
CurrencyCode: VSD
OffsetProjId: PJ0001
AmountCurDebit: 15000002
AmountCurCredit: 12500502
LedgerDimension: 140110BU001DP00102
OffsetLedgerDimension: 500110BU001DP00102

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

ProjIdRPK: PJ0002
TransDateRPK: 20240314
MainAccountIdRPK: 140112
Reference: LEGACYINVP00103
Description: PROJECTARBALANCECUTOVER202303
CurrencyCode: UUD
OffsetProjId: PJ0002
AmountCurDebit: 15000003
AmountCurCredit: 12500503
LedgerDimension: 140110BU001DP00103
OffsetLedgerDimension: 500110BU001DP00103

Rule Validation Summary

Source Rule Count: 17
Governed Rule Count: 17