Bank Accounts

In Scope

Technical: BankAccountTable | ID: D365FO-FIN-BANKACCOUNTTABLE-BANK_ACCOUNTS

See how this object fits into Finance

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Low
Sequencing: Stage 2 - Dependent Master Data
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: BankAccountTable

Field Definitions(5)

Rules & Considerations(31)

validation

constraint

Sample Load Data(4)

_scenario	BankGroupIdR	CurrencyCodeR	BankAccountIDRPK	Blocked	BankName	SWIFTCode	DataAreaId	AccountName	AccountType	AddressCity	MainAccount	AddressState	ContactPhone	AddressStreet	ContactPerson	RoutingNumber	AddressZipCode	ChargesGroupId	NextCheckNumber	StatementFormat	BankBranchNumber	BankAccountIdRecId	AddressCountryRegionId	DefaultDimensionDisplayValue	InternationalBankAccountNumber
Example values from field definitions	CHK	USD	BKUS000001	Yes	First National Bank	CITIUS33XXX	USRT	Primary Operating Account	Savings	New York	100110	NY	+1 (212) 555-1234	100 Broadway St, Suite 200	John Smith	121000358	10001	STD_CHGS	1001	BAI2	00123	5637145892	USA	Department-020-CostCenter-007	DE44500105170445678901
Variation 1 - type-safe variation anchored to example values	DHK	VSD	BKUS000002	ZES	FIRSTNATIONALBANK02	CITIUS33X02	VSRT	PRIMARYOPERATINGACCOUNT02	TAVINGS	NEWYORK02	100111	OY	1212555123402	100BROADWAYSTSUITE20002	JOHNSMITH02	121000351	10001	STDCHGS02	1001	BAI1	00121	5637145802	VSA	DEPARTMENT020COSTCENTER00702	DE44500105170445678901
Variation 2 - additional in-range variation with row-level constraint alignment	CJK	UUD	BKUS000003	YGS	FIRSTNATIONALBANK03	CITIUS33X03	UURT	PRIMARYOPERATINGACCOUNT03	SCVINGS	NEWYORK03	100112	NA	1212555123403	100BROADWAYSTSUITE20003	JOHNSMITH03	121000352	10002	STDCHGS03	1002	BAI2	00122	5637145803	UUA	DEPARTMENT020COSTCENTER00703	DE44500105170445678902

Example values from field definitions

BankGroupIdR: CHK
CurrencyCodeR: USD
BankAccountIDRPK: BKUS000001
Blocked: Yes
BankName: First National Bank
SWIFTCode: CITIUS33XXX
DataAreaId: USRT
AccountName: Primary Operating Account
AccountType: Savings
AddressCity: New York
MainAccount: 100110
AddressState: NY
ContactPhone: +1 (212) 555-1234
AddressStreet: 100 Broadway St, Suite 200
ContactPerson: John Smith
RoutingNumber: 121000358
AddressZipCode: 10001
ChargesGroupId: STD_CHGS
NextCheckNumber: 1001
StatementFormat: BAI2
BankBranchNumber: 00123
BankAccountIdRecId: 5637145892
AddressCountryRegionId: USA
DefaultDimensionDisplayValue: Department-020-CostCenter-007
InternationalBankAccountNumber: DE44500105170445678901

Variation 1 - type-safe variation anchored to example values

BankGroupIdR: DHK
CurrencyCodeR: VSD
BankAccountIDRPK: BKUS000002
Blocked: ZES
BankName: FIRSTNATIONALBANK02
SWIFTCode: CITIUS33X02
DataAreaId: VSRT
AccountName: PRIMARYOPERATINGACCOUNT02
AccountType: TAVINGS
AddressCity: NEWYORK02
MainAccount: 100111
AddressState: OY
ContactPhone: 1212555123402
AddressStreet: 100BROADWAYSTSUITE20002
ContactPerson: JOHNSMITH02
RoutingNumber: 121000351
AddressZipCode: 10001
ChargesGroupId: STDCHGS02
NextCheckNumber: 1001
StatementFormat: BAI1
BankBranchNumber: 00121
BankAccountIdRecId: 5637145802
AddressCountryRegionId: VSA
DefaultDimensionDisplayValue: DEPARTMENT020COSTCENTER00702
InternationalBankAccountNumber: DE44500105170445678901

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

BankGroupIdR: CJK
CurrencyCodeR: UUD
BankAccountIDRPK: BKUS000003
Blocked: YGS
BankName: FIRSTNATIONALBANK03
SWIFTCode: CITIUS33X03
DataAreaId: UURT
AccountName: PRIMARYOPERATINGACCOUNT03
AccountType: SCVINGS
AddressCity: NEWYORK03
MainAccount: 100112
AddressState: NA
ContactPhone: 1212555123403
AddressStreet: 100BROADWAYSTSUITE20003
ContactPerson: JOHNSMITH03
RoutingNumber: 121000352
AddressZipCode: 10002
ChargesGroupId: STDCHGS03
NextCheckNumber: 1002
StatementFormat: BAI2
BankBranchNumber: 00122
BankAccountIdRecId: 5637145803
AddressCountryRegionId: UUA
DefaultDimensionDisplayValue: DEPARTMENT020COSTCENTER00703
InternationalBankAccountNumber: DE44500105170445678902

Rule Validation Summary

Source Rule Count: 31
Governed Rule Count: 31