Bank Account Information

When you select to extract bank account information, the system writes data from these tables to the extracted file:

• A/P Payment Processing - Summary (F04572)

  The system uses the Payment Group Control Number and Check Control Number fields to determine the G/L Bank Account (data item GLBA).

• Bank Transit Master (F0030)

  • Account ID (data item AID)

  • Transit Number - Bank (data item TNST)

  • Bank Account Number - Customer (data item CBNK)

  • Bank Account - Control Digit (data item CHKD)

  • SWIFT Code (data item SWFT)

  • International Bank Account Number (data item IBAN)

  • Address Number - Bank (data item AN8BK)

• Address by Date (F0116)

  The system uses the bank's address number and the effective date to determine the address information:

  • Address (data items ADD1–ADD3)

  • Address

  • Postal code

  • City

  • State

  • Country