Vendor Bank Accounts
In ScopeTechnical: VendBankAccount | ID: D365FO-PRC-VENDBANKACCOUNT-VENDOR_BANK_ACCOUNTS
See how this object fits into Vendors Procurement
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
- VendBankAccount
Field Definitions(5)
Rules & Considerations(70)
Sample Load Data(3)
| _scenario | VENDACCOUNTR | BANKACCOUNTIDR | IBAN | PARTY | RECID | BANKNAME | CrossRate | SWIFTCODE | ACCOUNTNUM | ACTIVEDATE | DATAAREAID | DUNSNUMBER | ADDRESSCITY | BANKGROUPID | BANKMESSAGE | CONTACTNAME | ADDRESSSTATE | BANKBRANCHID | CONTACTPAGER | CURRENCYCODE | ADDRESSCOUNTY | ADDRESSSTREET | ROUTINGNUMBER | ADDRESSCOUNTRY | ADDRESSPOSTBOX | ADDRESSVALIDTO | ADDRESSZIPCODE | EXPIRATIONDATE | ADDRESSLATITUDE | ADDRESSTIMEZONE | ADDRESSLONGITUDE | ADDRESSVALIDFROM | CONTACTFAXNUMBER | FORMATTEDADDRESS | ADDRESSLOCATIONID | BANKACCOUNTNUMBER | DUNS4NUMBERSUFFIX | RECIPIENTTEXTCODE | ROUTINGNUMBERTYPE | ADDRESSDESCRIPTION | CONTACTPHONENUMBER | CONTACTTELEXNUMBER | ADDRESSDISTRICTNAME | ADDRESSSTREETNUMBER | BANKCOUNTRYREGIONID | CONTACTEMAILADDRESS | CURRENTCURRENCYCODE | EINVOICEBANKACCOUNT | VENDORACCOUNTNUMBER | VENDORBANKACCOUNTID | ISDEFAULTBANKACCOUNT | ADDRESSCOUNTRYISOCODE | CONTROLINTERNALNUMBER | CONTACTINTERNETADDRESS | RATEOFEXCHANGEREFERENCE | CONTACTMOBILEPHONENUMBER | ADDRESSBUILDINGCOMPLIMENT | CONTACTPHONENUMBEREXTENSION | CONTACTEMAILADDRESSFORSENDINGSMS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | US-001 | CHK001 | DE89370400440532013000 | 5637144576 | 5637144576 | JPMorgan Chase Bank | 1.15 | CHASUS33 | 1234567890 | 2023-01-01T00:00:00 | USMF | 123456789 | New York | GROUPA | Contact person John Doe for payment inquiries. | Jane Smith | NY | 011000015 | 555-1234 | USD | Kings | 100 Broadway | 021000021 | United States | P.O. Box 1234 | 2154-12-31T00:00:00 | 10001 | 2025-12-31T00:00:00 | 40.7128 | 60 | -74.0060 | 2023-01-01T00:00:00 | +1-212-555-0199 | 100 Broadway, North Tower, New York, NY 10001, USA | L0001BANK | 12345678901234567890 | 0001 | BANKPYMT | 0 | Main Branch Office | +1-212-555-0100 | 12345678 | Midtown | 100 | US | payments@jpbank.com | GBP | 1 | VEND-0001 | BANKUSD | 1 | US | Y | www.jpbank.com | Fixed | +1-917-555-0188 | North Tower | x123 | 1234567890@txt.att.net |
| Closed historical vendor bank account for terminated vendor relationship | VEND-205 | CHK001 | DE44500105170987654321 | 5637146789 | 5637144502 | First National Bank of Europe | — | CHASUS31 | — | 2018-03-15T00:00:00 | DEMF | 987654321 | Munich | — | Account closed — no longer accepts payments. | Hans Weber | BY | — | — | EUR | — | Maximilianstraße 10 | 021000021 | Germany | — | — | 80331 | 2022-12-31T00:00:00 | — | — | — | — | — | — | — | 98765432109876543210 | — | CANKPYMT | 3 | — | +49-89-123456 | — | — | — | DE | hweber@fnbe.de | — | — | CLOS_HIST_VEND | CANKUSD | 0 | DE | N | — | — | — | — | — | — |
| New minimal vendor bank account setup for onboarding with required fields only | VEND-901 | CHK002 | — | 5637150001 | 5637144503 | Wells Fargo Bank | — | CHASUS32 | 1234567892 | 2024-06-01T00:00:00 | USMF | 123456703 | — | GTOUPA | — | NEW_MINI_VEND | — | 011000012 | — | UUD | — | — | 121000248 | — | — | 21541231T00000003 | 10002 | — | — | — | — | 20230101T00000003 | 1212555019903 | — | L0001BAN2 | 12345678901234567892 | 0003 | BCNKPYMT | 1 | — | 1212555010003 | 12345672 | MKDTOWN | 102 | US | — | GDP | — | VEND-901 | BCNKUSD | 1 | UU | A | — | — | 1917555018803 | — | X122 | — |
Example values from field definitions
- VENDACCOUNTR
- US-001
- BANKACCOUNTIDR
- CHK001
- IBAN
- DE89370400440532013000
- PARTY
- 5637144576
- RECID
- 5637144576
- BANKNAME
- JPMorgan Chase Bank
- CrossRate
- 1.15
- SWIFTCODE
- CHASUS33
- ACCOUNTNUM
- 1234567890
- ACTIVEDATE
- 2023-01-01T00:00:00
- DATAAREAID
- USMF
- DUNSNUMBER
- 123456789
- ADDRESSCITY
- New York
- BANKGROUPID
- GROUPA
- BANKMESSAGE
- Contact person John Doe for payment inquiries.
- CONTACTNAME
- Jane Smith
- ADDRESSSTATE
- NY
- BANKBRANCHID
- 011000015
- CONTACTPAGER
- 555-1234
- CURRENCYCODE
- USD
- ADDRESSCOUNTY
- Kings
- ADDRESSSTREET
- 100 Broadway
- ROUTINGNUMBER
- 021000021
- ADDRESSCOUNTRY
- United States
- ADDRESSPOSTBOX
- P.O. Box 1234
- ADDRESSVALIDTO
- 2154-12-31T00:00:00
- ADDRESSZIPCODE
- 10001
- EXPIRATIONDATE
- 2025-12-31T00:00:00
- ADDRESSLATITUDE
- 40.7128
- ADDRESSTIMEZONE
- 60
- ADDRESSLONGITUDE
- -74.0060
- ADDRESSVALIDFROM
- 2023-01-01T00:00:00
- CONTACTFAXNUMBER
- +1-212-555-0199
- FORMATTEDADDRESS
- 100 Broadway, North Tower, New York, NY 10001, USA
- ADDRESSLOCATIONID
- L0001BANK
- BANKACCOUNTNUMBER
- 12345678901234567890
- DUNS4NUMBERSUFFIX
- 0001
- RECIPIENTTEXTCODE
- BANKPYMT
- ROUTINGNUMBERTYPE
- 0
- ADDRESSDESCRIPTION
- Main Branch Office
- CONTACTPHONENUMBER
- +1-212-555-0100
- CONTACTTELEXNUMBER
- 12345678
- ADDRESSDISTRICTNAME
- Midtown
- ADDRESSSTREETNUMBER
- 100
- BANKCOUNTRYREGIONID
- US
- CONTACTEMAILADDRESS
- payments@jpbank.com
- CURRENTCURRENCYCODE
- GBP
- EINVOICEBANKACCOUNT
- 1
- VENDORACCOUNTNUMBER
- VEND-0001
- VENDORBANKACCOUNTID
- BANKUSD
- ISDEFAULTBANKACCOUNT
- 1
- ADDRESSCOUNTRYISOCODE
- US
- CONTROLINTERNALNUMBER
- Y
- CONTACTINTERNETADDRESS
- www.jpbank.com
- RATEOFEXCHANGEREFERENCE
- Fixed
- CONTACTMOBILEPHONENUMBER
- +1-917-555-0188
- ADDRESSBUILDINGCOMPLIMENT
- North Tower
- CONTACTPHONENUMBEREXTENSION
- x123
- CONTACTEMAILADDRESSFORSENDINGSMS
- 1234567890@txt.att.net
Closed historical vendor bank account for terminated vendor relationship
- VENDACCOUNTR
- VEND-205
- BANKACCOUNTIDR
- CHK001
- IBAN
- DE44500105170987654321
- PARTY
- 5637146789
- RECID
- 5637144502
- BANKNAME
- First National Bank of Europe
- CrossRate
- —
- SWIFTCODE
- CHASUS31
- ACCOUNTNUM
- —
- ACTIVEDATE
- 2018-03-15T00:00:00
- DATAAREAID
- DEMF
- DUNSNUMBER
- 987654321
- ADDRESSCITY
- Munich
- BANKGROUPID
- —
- BANKMESSAGE
- Account closed — no longer accepts payments.
- CONTACTNAME
- Hans Weber
- ADDRESSSTATE
- BY
- BANKBRANCHID
- —
- CONTACTPAGER
- —
- CURRENCYCODE
- EUR
- ADDRESSCOUNTY
- —
- ADDRESSSTREET
- Maximilianstraße 10
- ROUTINGNUMBER
- 021000021
- ADDRESSCOUNTRY
- Germany
- ADDRESSPOSTBOX
- —
- ADDRESSVALIDTO
- —
- ADDRESSZIPCODE
- 80331
- EXPIRATIONDATE
- 2022-12-31T00:00:00
- ADDRESSLATITUDE
- —
- ADDRESSTIMEZONE
- —
- ADDRESSLONGITUDE
- —
- ADDRESSVALIDFROM
- —
- CONTACTFAXNUMBER
- —
- FORMATTEDADDRESS
- —
- ADDRESSLOCATIONID
- —
- BANKACCOUNTNUMBER
- 98765432109876543210
- DUNS4NUMBERSUFFIX
- —
- RECIPIENTTEXTCODE
- CANKPYMT
- ROUTINGNUMBERTYPE
- 3
- ADDRESSDESCRIPTION
- —
- CONTACTPHONENUMBER
- +49-89-123456
- CONTACTTELEXNUMBER
- —
- ADDRESSDISTRICTNAME
- —
- ADDRESSSTREETNUMBER
- —
- BANKCOUNTRYREGIONID
- DE
- CONTACTEMAILADDRESS
- hweber@fnbe.de
- CURRENTCURRENCYCODE
- —
- EINVOICEBANKACCOUNT
- —
- VENDORACCOUNTNUMBER
- CLOS_HIST_VEND
- VENDORBANKACCOUNTID
- CANKUSD
- ISDEFAULTBANKACCOUNT
- 0
- ADDRESSCOUNTRYISOCODE
- DE
- CONTROLINTERNALNUMBER
- N
- CONTACTINTERNETADDRESS
- —
- RATEOFEXCHANGEREFERENCE
- —
- CONTACTMOBILEPHONENUMBER
- —
- ADDRESSBUILDINGCOMPLIMENT
- —
- CONTACTPHONENUMBEREXTENSION
- —
- CONTACTEMAILADDRESSFORSENDINGSMS
- —
New minimal vendor bank account setup for onboarding with required fields only
- VENDACCOUNTR
- VEND-901
- BANKACCOUNTIDR
- CHK002
- IBAN
- —
- PARTY
- 5637150001
- RECID
- 5637144503
- BANKNAME
- Wells Fargo Bank
- CrossRate
- —
- SWIFTCODE
- CHASUS32
- ACCOUNTNUM
- 1234567892
- ACTIVEDATE
- 2024-06-01T00:00:00
- DATAAREAID
- USMF
- DUNSNUMBER
- 123456703
- ADDRESSCITY
- —
- BANKGROUPID
- GTOUPA
- BANKMESSAGE
- —
- CONTACTNAME
- NEW_MINI_VEND
- ADDRESSSTATE
- —
- BANKBRANCHID
- 011000012
- CONTACTPAGER
- —
- CURRENCYCODE
- UUD
- ADDRESSCOUNTY
- —
- ADDRESSSTREET
- —
- ROUTINGNUMBER
- 121000248
- ADDRESSCOUNTRY
- —
- ADDRESSPOSTBOX
- —
- ADDRESSVALIDTO
- 21541231T00000003
- ADDRESSZIPCODE
- 10002
- EXPIRATIONDATE
- —
- ADDRESSLATITUDE
- —
- ADDRESSTIMEZONE
- —
- ADDRESSLONGITUDE
- —
- ADDRESSVALIDFROM
- 20230101T00000003
- CONTACTFAXNUMBER
- 1212555019903
- FORMATTEDADDRESS
- —
- ADDRESSLOCATIONID
- L0001BAN2
- BANKACCOUNTNUMBER
- 12345678901234567892
- DUNS4NUMBERSUFFIX
- 0003
- RECIPIENTTEXTCODE
- BCNKPYMT
- ROUTINGNUMBERTYPE
- 1
- ADDRESSDESCRIPTION
- —
- CONTACTPHONENUMBER
- 1212555010003
- CONTACTTELEXNUMBER
- 12345672
- ADDRESSDISTRICTNAME
- MKDTOWN
- ADDRESSSTREETNUMBER
- 102
- BANKCOUNTRYREGIONID
- US
- CONTACTEMAILADDRESS
- —
- CURRENTCURRENCYCODE
- GDP
- EINVOICEBANKACCOUNT
- —
- VENDORACCOUNTNUMBER
- VEND-901
- VENDORBANKACCOUNTID
- BCNKUSD
- ISDEFAULTBANKACCOUNT
- 1
- ADDRESSCOUNTRYISOCODE
- UU
- CONTROLINTERNALNUMBER
- A
- CONTACTINTERNETADDRESS
- —
- RATEOFEXCHANGEREFERENCE
- —
- CONTACTMOBILEPHONENUMBER
- 1917555018803
- ADDRESSBUILDINGCOMPLIMENT
- —
- CONTACTPHONENUMBEREXTENSION
- X122
- CONTACTEMAILADDRESSFORSENDINGSMS
- —
Rule Validation Summary
- Source Rule Count
- 70
- Governed Rule Count
- 70