BankAccount

The bank account provides the details of the internal bank accounts of a company that are used to receive payments and disburse funds. It contains legal entity-level bank account information. Each bank account must be affiliated with one bank branch.

Expand all

Collapse all

Business Views

** Available for extracting data

• bankAccountsExtract**

  The bank account provides the details of the internal bank accounts of a company that are used to receive payments and disburse funds. It contains legal entity-level bank account information. Each bank account must be affiliated with one bank branch.

  Label, Plural Label

  Bank Accounts, Bank Accounts

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountClassification (enumeration: AccountClassification)

    Indicates whether the bank account is internal or external. A list of accepted values is defined in the lookup type ACCOUNT_CLASSIFICATION.

    Label

    Account Classification

    Type

    • Module: oraErpCoreBankingSetup

    • Enumeration Type: AccountClassification

    Properties

    • not nullable

    Valid Values

    • INTERNAL
  • accountHolder (string)

    Name of the bank account holder.

    Label

    Account Holder

  • accountHolderIdentifier (int64)

    Unique identifier of the bank account holder.

    Label

    Account Holder Identifier

  • accountNumber (string)

    Unique number assigned to a specific bank account to route payments accurately.

    Label

    Account Number

  • accountSuffix (string)

    Account suffix for the bank account.

    Label

    Account Suffix

  • agencyLocationCode (string)

    Agency location code used by federal agencies.

    Label

    Agency Location Code

  • allowZeroPaymentsFlag (boolean)

    Indicates whether zero amount is allowed for the bank account.

    Label

    Allow zero payments

  • alternateAccountHolder (string)

    Alternate name of the bank account holder.

    Label

    Alternate Account Holder

  • alternateAccountName (string)

    Alternate name of the bank account.

    Label

    Alternate Account Name

  • bankAccountType (string)

    User-defined attribute specifying the bank account type, such as checking or savings.

    Label

    Bank Account Type

  • bankExchangeRateType (string)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.

    Label

    Bank Exchange Rate Type

  • cashAccountSegments (string)

    List of segments that represent the general ledger cash account and are used to retrieve multiple cash account combinations for journal reconciliation.

    Label

    Cash Account Segments

  • checkDigits (string)

    Digits used to validate the bank account number according to the country's banking rules.

    Label

    Check Digit

  • description (string)

    Description of the bank account.

    Label

    Description

  • eftNumber (string)

    Electronic file transfer user number for the bank account.

    Label

    EFT Number

  • electronicBankAccountNumber (string)

    Bank account number in electronic transmission format.

    Label

    Electronic Bank Account Number

  • enableMultipleCashAccountsForReconciliationFlag (boolean)

    Indicates whether multiple cash account combinations can be considered for journal reconciliation.

    Label

    Enable Multiple Cash Accounts for Reconciliation

  • endDate (date)

    The date when the bank account is no longer active.

    Label

    End Date

    Properties

    • searchable
  • iban (string)

    Alphanumeric sequence conforming to the ISO standard to uniquely identify the bank account number internationally.

    Label

    IBAN

  • id (int64)

    Unique identifier for the bank account.

    Label

    Bank Account ID

    Properties

    • searchable
    • sortable
    • not nullable
  • journalReconciliationStartDate (date)

    Date from which journal entries become available for reconciliation.

    Label

    Journal Reconciliation Start Date

  • ledgerConversionRateType (string)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.

    Label

    Ledger Conversion Rate Type

  • maskedBankAccountNumber (string)

    Masked bank account number displaying limited characters to protect sensitive financial information.

    Label

    Masked Account Number

  • maskedIban (string)

    Masked international bank account number displaying limited characters to protect sensitive financial information.

    Label

    Masked IBAN

  • maximumOutlay (big-decimal)

    Maximum payment batch allowed for the bank account.

    Label

    Maximum Outlay

  • maximumPayment (big-decimal)

    Maximum payment amount allowed for bank account in a payment batch.

    Label

    Maximum Payment

  • minimumPayment (big-decimal)

    Minimum payment amount allowed for bank account in a payment batch.

    Label

    Minimum Payment

  • multicurrencyFlag (boolean)

    Indicates whether the bank account can process multicurrency payments.

    Label

    Multicurrency account

  • name (string)

    Name of the bank account.

    Label

    Account Name

    Properties

    • searchable
    • sortable
    • not nullable
  • nettingAccountFlag (boolean)

    Indicates whether the bank account is a netting account.

    Label

    Netting account

    Properties

    • searchable
  • payablesUseAllowedFlag (boolean)

    Indicates whether the bank account is used for Payables.

    Label

    Payables Use Allowed

    Properties

    • searchable
  • payrollUseAllowedFlag (boolean)

    Indicates whether the bank account is used for Payroll.

    Label

    Payroll Use Allowed

    Properties

    • searchable
  • pooledAccountFlag (boolean)

    Indicates whether the bank account is part of a cash pool.

    Label

    Pooled account

  • receivablesUseAllowedFlag (boolean)

    Indicates whether the bank account is used for Receivables.

    Label

    Receivables Use Allowed

  • reconciliationStartDate (date)

    The date when bank statement reconciliation begins for this bank account.

    Label

    Reconciliation Start Date

  • reversalProcessingMethod (enumeration: ReversalProcessingMethod)

    Specifies the method used to process receipt reversal bank statement lines during automatic reconciliation.

    Label

    Reversal Processing Method

    Type

    • Module: oraErpCoreBankingSetup

    • Enumeration Type: ReversalProcessingMethod

    Valid Values

    • DM_REVERSE
    • REVERSE
  • secondaryAccountReference (string)

    Additional identifier for the bank account used by the bank or external systems to reference the account.

    Label

    Secondary Account Reference

  • securedBankAccountByUsersAndRolesFlag (boolean)

    Indicates whether bank account will be secured by user or role.

    Label

    Secure Bank Account by Users and Roles

  • startDate (date)

    The date when the bank account becomes active.

    Label

    Start Date

    Properties

    • searchable
  • targetBalance (big-decimal)

    The target balance set for the bank account.

    Label

    Target Balance

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • bank (Bank)

    The bank is a financial institution that allows customers to deposit, withdraw, and manage funds. A bank can have multiple operating branches. This object provides details of the bank.

    Business Object

    Bank

    Expand all

    Collapse all

    Fields

    • alternateBankName (string)

      Alternate name of the bank.

      Label

      Alternate Bank Name

    • bankCode (string)

      Unique number assigned to the bank.

      Label

      Bank Code

    • bankInstitutionType (enumeration: BankInstitutionType)

      Institution type of the bank. For example, bank and clearing house.

      Label

      Bank Institution Type

      Type

      • Module: oraErpCoreBankingSetup

      • Enumeration Type: BankInstitutionType

      Properties

      • not nullable

      Valid Values

      • ADHOC_PAYEE_BANK
      • BANK
      • CUSTOMER_BANK
      • EMPLOYEE_BANK
      • SUPPLIER_BANK
    • bankOrganizationNumber (string)

      Unique number assigned to the bank party.

      Label

      Bank Organization Number

      Properties

      • not nullable
    • endDate (date)

      Last date that the bank is active.

      Label

      End Date

    • id (int64)

      Unique identifier for the bank.

      Label

      Bank ID

      Properties

      • searchable
      • sortable
      • not nullable
    • name (string)

      The name of the bank.

      Label

      Name

      Properties

      • searchable
      • sortable
      • not nullable
    • startDate (date)

      First date that the bank is active.

      Label

      Start Date

      Properties

      • not nullable
    • taxpayerIdentifier (string)

      Bank identifier assigned by a tax authority.

      Label

      Taxpayer ID

    • timeCreated (date-time)

      The date and time when the record was created.

      Label

      Creation Date

      Properties

      • searchable
      • not nullable
    • timeUpdated (date-time)

      The date and time when the record was last updated.

      Label

      Last Updated Date

      Properties

      • searchable
      • not nullable

    Expand all

    Collapse all

    Reference Object

    • country (Territory)

      Country of the bank.

      Business Object

      Territory

      Expand all

      Collapse all

      Fields

      • territoryCode (string)

        The unique code of the territory.

        Label

        Territory Code

        Properties

        • searchable
        • sortable
        • not nullable

  • bankBranch (BankBranch)

    A bank branch represents a branch of a bank. It includes details such as the branch name, alternate branch name, branch number, and branch type.

    Business Object

    BankBranch

    Expand all

    Collapse all

    Fields

    • alternateBranchName (string)

      Alternate name of the bank branch.

      Label

      Alternate Branch Name

    • bankBranchOrganizationNumber (string)

      Unique number assigned to the bank branch party.

      Label

      Bank Branch Organization Number

      Properties

      • not nullable
    • bankCode (string)

      Unique code identifying a bank for payments.

      Label

      Bank Code

    • bicCode (string)

      Standardized code for uniquely identifying banks and financial institutions worldwide. Used mainly for international payments and SWIFT messaging.

      Label

      BIC Code

    • branchInstitutionType (enumeration: BankBranchInstitutionType)

      Institution type of the bank branch. For example, bank branch and clearing house branch.

      Label

      Branch Institution Type

      Type

      • Module: oraErpCoreBankingSetup

      • Enumeration Type: BankBranchInstitutionType

      Properties

      • not nullable

      Valid Values

      • ADHOC_PAYEE_BANK_BRANCH
      • BANK_BRANCH
      • CUSTOMER_BANK_BRANCH
      • EMPLOYEE_BANK_BRANCH
      • SUPPLIER_BANK_BRANCH
    • branchNumber (string)

      Unique number assigned by the bank to the bank branch for routing payments.

      Label

      Branch Number

    • branchType (string)

      The type of banking institution to which the branch belongs. The valid values are ABA, CHIPS, Other, SWIFT.

      Label

      Branch Type

    • ediIdentificationNumber (string)

      Number used by the bank in electronic data interchange.

      Label

      EDI ID Number

    • ediLocation (string)

      Name of the location of the electronic data interchange for the bank.

      Label

      EDI Location

    • eftNumber (string)

      Number used for identification and validation in electronic funds transfer.

      Label

      EFT Number

    • endDate (date)

      The date when the bank branch is no longer active.

      Label

      End Date

    • id (int64)

      Unique identifier for the bank branch.

      Label

      Bank Branch ID

      Properties

      • searchable
      • sortable
      • not nullable
    • name (string)

      Name of the bank branch.

      Label

      Branch Name

      Properties

      • not nullable
    • rfcIdentifierCode (string)

      Code of the Regional Finance Center (RFC). RFC is considered a bank branch of the U.S. Treasury bank and is responsible for the disbursement of public monies on behalf of some federal agencies.

      Label

      RFC Identifier

    • startDate (date)

      The date when the bank branch becomes active.

      Label

      Start Date

      Properties

      • not nullable
    • timeCreated (date-time)

      The date and time when the record was created.

      Label

      Creation Date

      Properties

      • searchable
      • not nullable
    • timeUpdated (date-time)

      The date and time when the record was last updated.

      Label

      Last Updated Date

      Properties

      • searchable
      • not nullable

  • cashAccount (GeneralLedgerAccount)

    General Ledger account combination used for the cash account.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • concatenatedSegments (string)

      The concatenated full account combination.

      Label

      Concatenated Segment Values

      Properties

      • inherited
      • creatable
      • searchable
      • sortable

  • cashClearingAccount (GeneralLedgerAccount)

    General Ledger account combination used for the cash clearing account.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • concatenatedSegments (string)

      The concatenated full account combination.

      Label

      Concatenated Segment Values

      Properties

      • inherited
      • creatable
      • searchable
      • sortable

  • currency (Currency)

    Three-letter ISO code identifying the currency for the bank account.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • legalEntity (LegalEntity)

    A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the organization profile.

      Label

      Organization ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable

  • manualReconciliationToleranceRule (BankStatementReconciliationToleranceRule)

    The bank statement reconciliation tolerance rules contain amount and date tolerances that prevent or warn users when reconciliation would be a breach of a defined tolerance. The reconciliation tolerance rules are used during automatic and manual reconciliation.

    Business Object

    BankStatementReconciliationToleranceRule

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the reconciliation tolerance rule. This is the primary key of the Bank Statement Reconciliation Tolerance Rules view object.

      Label

      Tolerance Rule Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • reconciliationDifferenceAccount (GeneralLedgerAccount)

    General Ledger account combination used for the reconciliation difference account.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • concatenatedSegments (string)

      The concatenated full account combination.

      Label

      Concatenated Segment Values

      Properties

      • inherited
      • creatable
      • searchable
      • sortable

Back to Top