Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

DebitAuthorizations

Manages debit authorizations, including creation or updates, allowing users to handle automated debit agreements.

Columns

Name Type Description
DebitAuthorizationReferenceNumber String The unique reference number associated with a debit authorization, used to identify the authorization in related transactions.
CustomerBankAccountNumber String The bank account number of the customer associated with the debit authorization, important for routing payments or charges.
BankName String The name of the bank that holds the customer’s account, used for identifying the institution involved in the debit authorization.
BankBranchName String The name of the specific branch of the bank where the customer's account is maintained, relevant for regional transaction processing.
BankAccountCountry String The country where the customer’s bank account is held, typically used for cross-border payment processing.
BankAccountCurrency String The currency in which the customer’s bank account operates, essential for ensuring correct financial transactions in multi-currency environments.
IBAN String The International Bank Account Number (IBAN) of the customer's bank account, used for international payment transfers.
BIC String The Bank Identifier Code (BIC) or SWIFT code for the customer's bank, used to route international payments to the correct bank.
LegalEntityName String The name of the legal entity associated with the debit authorization, often representing the organization responsible for the transaction.
CreditorIdentificationNumber String The unique identifier assigned to the creditor in a payment transaction, used to validate and authorize the payment request.
SigningDate Date The date on which the debit authorization was signed, marking the official start of the agreement.
CancellationDate Date The date when the debit authorization was canceled, ending the agreement and halting any further transactions.
TransactionType String The type of transaction associated with the debit authorization, such as a one-time payment, recurring payment, or cancellation.
Frequency String The frequency at which the payments or transactions are authorized, for example, monthly or annually.
FinalCollectionDate Date The final date on which payments associated with the debit authorization is collected, marking the end of the collection period.
AuthorizationMethod String The method used to authorize the debit transaction, such as manual, electronic, or through a verified process.
VersionNumber Int The version number of the debit authorization, indicating updates or changes made to the original authorization agreement.
ReasonForAmendment String The reason for any amendments or changes made to the debit authorization after its original creation, providing context for updates.
EffectiveStartDate [KEY] Date The start date from which the debit authorization is effective, determining when payments or transactions should begin.
EffectiveEndDate [KEY] Date The end date after which the debit authorization is no longer valid, signaling the cessation of the authorization's applicability.
DirectDebitCount Long The total number of direct debit transactions processed under the authorization, reflecting the volume of payments initiated.
PrimaryIndicator String Indicates whether this is the primary authorization for the customer’s direct debit, marking it as the main source for payment processing.
Status String The current status of the debit authorization, such as active, canceled, pending, or expired, providing insight into the authorization's validity.
DebitAuthorizationId [KEY] Long The unique identifier for the debit authorization, used to reference and manage the specific authorization record in the system.
CustomerPartyIdentifier Long The unique identifier for the customer party involved in the debit authorization, linking the authorization to a specific customer in the system.
CustomerPartyNumber String A unique number assigned to the customer party for identification within the financial system, used for referencing the party in transactions.
CustomerPartyName String The full name of the customer party involved in the debit authorization, providing clarity on which party is responsible for the transaction.
CustomerBankAccountIdentifier Long The unique identifier for the customer’s bank account within the system, used to link the authorization to a specific account.
LegalEntityIdentifier Long The unique identifier for the legal entity associated with the debit authorization, used for organizational and legal purposes in transactions.
Finder String A search tool or keyword used for locating specific debit authorizations within the system based on defined criteria.
SysEffectiveDate String The system effective date that denotes when the data is considered valid within the financial system, used for system processing and reporting.
EffectiveDate Date A query parameter used to fetch resources that are effective as of the specified start date, ensuring only relevant data is retrieved.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454