Customer Open Balances
In ScopeTechnical: CustTransOpen | ID: D365FO-TRX-CUSTTRANSOPEN-CUSTOMER_OPEN_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
- CustTransOpen
This object has high complexity or dependency level
Review sequencing requirements before loading
Field Definitions(5)
Rules & Considerations(11)
constraint
validation
Sample Load Data(4)
| _scenario | InvoiceIdRPK | AccountNumRPK | AmountOpenR | InvoiceDateR | CurrencyCodeR |
|---|---|---|---|---|---|
| Example values from field definitions | INV-000123 | CUST001 | 1500.75 | 2023-10-01 | USD |
| Open invoice with EUR currency | INV-000124 | CUST002 | 800.5 | 2023-10-05 | EUR |
| Open invoice with JPY currency | INV-000125 | CUST003 | 100000 | 2023-09-30 | JPY |
Example values from field definitions
- InvoiceIdRPK
- INV-000123
- AccountNumRPK
- CUST001
- AmountOpenR
- 1500.75
- InvoiceDateR
- 2023-10-01
- CurrencyCodeR
- USD
Open invoice with EUR currency
- InvoiceIdRPK
- INV-000124
- AccountNumRPK
- CUST002
- AmountOpenR
- 800.5
- InvoiceDateR
- 2023-10-05
- CurrencyCodeR
- EUR
Open invoice with JPY currency
- InvoiceIdRPK
- INV-000125
- AccountNumRPK
- CUST003
- AmountOpenR
- 100000
- InvoiceDateR
- 2023-09-30
- CurrencyCodeR
- JPY
Rule Validation Summary
- Source Rule Count
- 11
- Governed Rule Count
- 11