Bank Account Opening Balances
In ScopeTechnical: BankAccountTransOpen | ID: D365FO-TRX-BANKACCOUNTTRANSOPEN-BANK_ACCOUNT_OPENING_BALANCES
See how this object fits into Open Transactions History
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 4 - Opening Balances
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- BankAccountTransOpen
Field Definitions(5)
Rules & Considerations(15)
validation
constraint
Sample Load Data(3)
| _scenario | AccountIdRPK | CutoverDateR | CurrencyCodeRPK | OpeningBalanceR | Company | Voucher | AmountMST | Description | IsReconciled | BankStatementGroup | BankTransactionType | DimensionDisplayValue |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | US-BKBANK | 2023-12-31 | USD | 150000.75 | USMF | BANKOB-0001 | 135000.68 | Opening Balance as of 2023-12-31 | No | OBAL | Opening | 500100-023-007 |
| Variation 1 - type-safe variation anchored to example values | USBKBANK02 | 20240206 | VSD | 150000702 | VSMF | BANKOB000102 | 135000602 | OPENINGBALANCEASOF2023123102 | OO | PBAL | PPENING | 50010002300702 |
| Variation 2 - additional in-range variation with row-level constraint alignment | USBKBANK03 | 20240314 | UUD | 150000703 | UUMF | BANKOB000103 | 135000603 | OPENINGBALANCEASOF2023123103 | NQ | ODAL | ORENING | 50010002300703 |
Example values from field definitions
- AccountIdRPK
- US-BKBANK
- CutoverDateR
- 2023-12-31
- CurrencyCodeRPK
- USD
- OpeningBalanceR
- 150000.75
- Company
- USMF
- Voucher
- BANKOB-0001
- AmountMST
- 135000.68
- Description
- Opening Balance as of 2023-12-31
- IsReconciled
- No
- BankStatementGroup
- OBAL
- BankTransactionType
- Opening
- DimensionDisplayValue
- 500100-023-007
Variation 1 - type-safe variation anchored to example values
- AccountIdRPK
- USBKBANK02
- CutoverDateR
- 20240206
- CurrencyCodeRPK
- VSD
- OpeningBalanceR
- 150000702
- Company
- VSMF
- Voucher
- BANKOB000102
- AmountMST
- 135000602
- Description
- OPENINGBALANCEASOF2023123102
- IsReconciled
- OO
- BankStatementGroup
- PBAL
- BankTransactionType
- PPENING
- DimensionDisplayValue
- 50010002300702
Variation 2 - additional in-range variation with row-level constraint alignment
- AccountIdRPK
- USBKBANK03
- CutoverDateR
- 20240314
- CurrencyCodeRPK
- UUD
- OpeningBalanceR
- 150000703
- Company
- UUMF
- Voucher
- BANKOB000103
- AmountMST
- 135000603
- Description
- OPENINGBALANCEASOF2023123103
- IsReconciled
- NQ
- BankStatementGroup
- ODAL
- BankTransactionType
- ORENING
- DimensionDisplayValue
- 50010002300703
Rule Validation Summary
- Source Rule Count
- 15
- Governed Rule Count
- 15