GL Opening Balances
In ScopeTechnical: LedgerJournalTrans | ID: D365FO-TRX-LEDGERJOURNALTRANS-GL_OPENING_BALANCES
See how this object fits into Open Transactions History
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- High
- Sequencing
- Stage 4 - Opening Balances
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- LedgerJournalTrans
This object has high complexity or dependency level
Review sequencing requirements before loading
Field Definitions(5)
Rules & Considerations(11)
validation
constraint
Sample Load Data(4)
| _scenario | TransDateR | JournalNumR | AccountTypeR | LedgerDimensionR | Txt | Recurrence | PostingType | CurrencyCode | OffsetCompany | AmountCurDebit | AmountCurCredit | OffsetLedgerDimension |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 2023-01-01 | JNL-2023-001 | 0 | 123456789 | Year-end closing adjustments | 0 | 0 | USD | US01 | 1000.0 | 500.0 | 987654321 |
| Variation 1 - type-safe variation anchored to example values | 20230207 | JNL202300102 | 2 | 123456702 | YEARENDCLOSINGADJUSTMENTS02 | 2 | 2 | VSD | US02 | 100002 | 50002 | 987654302 |
| Variation 2 - additional in-range variation with row-level constraint alignment | 20230316 | JNL202300103 | 3 | 123456703 | YEARENDCLOSINGADJUSTMENTS03 | 3 | 3 | UUD | US03 | 100003 | 50003 | 987654303 |
Example values from field definitions
- TransDateR
- 2023-01-01
- JournalNumR
- JNL-2023-001
- AccountTypeR
- 0
- LedgerDimensionR
- 123456789
- Txt
- Year-end closing adjustments
- Recurrence
- 0
- PostingType
- 0
- CurrencyCode
- USD
- OffsetCompany
- US01
- AmountCurDebit
- 1000.0
- AmountCurCredit
- 500.0
- OffsetLedgerDimension
- 987654321
Variation 1 - type-safe variation anchored to example values
- TransDateR
- 20230207
- JournalNumR
- JNL202300102
- AccountTypeR
- 2
- LedgerDimensionR
- 123456702
- Txt
- YEARENDCLOSINGADJUSTMENTS02
- Recurrence
- 2
- PostingType
- 2
- CurrencyCode
- VSD
- OffsetCompany
- US02
- AmountCurDebit
- 100002
- AmountCurCredit
- 50002
- OffsetLedgerDimension
- 987654302
Variation 2 - additional in-range variation with row-level constraint alignment
- TransDateR
- 20230316
- JournalNumR
- JNL202300103
- AccountTypeR
- 3
- LedgerDimensionR
- 123456703
- Txt
- YEARENDCLOSINGADJUSTMENTS03
- Recurrence
- 3
- PostingType
- 3
- CurrencyCode
- UUD
- OffsetCompany
- US03
- AmountCurDebit
- 100003
- AmountCurCredit
- 50003
- OffsetLedgerDimension
- 987654303
Rule Validation Summary
- Source Rule Count
- 11
- Governed Rule Count
- 11