CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

DebitAuthorizationsdebitAuthorizationVersions

Tracks version history of debit authorizations, ensuring an audit trail of any modifications made to authorization terms.

Columns

Name Type Description
DebitAuthorizationsDebitAuthorizationId [KEY] Long The unique identifier for each debit authorization within the Debit Authorizations table, used to track specific authorization records across versions.
DebitAuthorizationsEffectiveEndDate [KEY] Date The end date for the effective period of a debit authorization record, indicating when the authorization is no longer valid.
DebitAuthorizationsEffectiveStartDate [KEY] Date The start date for the effective period of a debit authorization record, signifying when the authorization becomes valid.
DebitAuthorizationId [KEY] Long The identifier for a debit authorization, linking to the corresponding entry in the Debit Authorizations table, used to track authorization details.
EffectiveStartDate Date The start date marking the beginning of the debit authorization's effective period, helping to define its active status.
EffectiveEndDate Date The end date marking the conclusion of the debit authorization's effective period, after which the authorization is no longer applicable.
DebitAuthorizationReferenceNumber String A unique reference number associated with a debit authorization, typically used to cross-reference with external systems or documentation.
VersionNumber [KEY] Int The version number of the debit authorization record, allowing tracking of amendments and revisions to the original authorization.
CreditorIdentificationNumber String The identification number assigned to the creditor involved in the debit authorization, used to verify the creditor's identity within the system.
LegalEntityName String The name of the legal entity associated with the debit authorization, important for legal and compliance tracking.
CustomerBankAccountNumber String The bank account number of the customer for which the debit authorization is created, used for processing payments or withdrawals.
IBAN String The International Bank Account Number (IBAN) associated with the customer’s bank account, used for international transactions.
CutomerBankAccountIdentifier Long A unique identifier for the customer’s bank account, linking it to the debit authorization record for specific processing.
ReasonForAmendment String The reason for any amendments made to the debit authorization, providing context for changes to the authorization records.
DirectDebitCount Long The number of direct debit transactions associated with a given debit authorization, providing insight into its usage.
CustomerBankAccountIdentifier Long An identifier for the customer’s bank account, used for referencing customer accounts in relation to debit authorizations.
CustomerPartyIdentifier Long A unique identifier for the customer party, linking the debit authorization to a specific customer or entity within the system.
CustomerPartyName String The name of the customer party associated with the debit authorization, important for identifying the relevant customer.
CustomerPartyNumber String The number assigned to the customer party, often used in external systems for identifying the customer or organization.
Finder String A search or reference term used for locating specific records related to a debit authorization or customer party within the system.
LegalEntityIdentifier Long A unique identifier for the legal entity, linking the debit authorization to a specific entity within the legal structure.
SysEffectiveDate String The system's effective date, indicating when the record or transaction becomes valid according to the internal system rules.
EffectiveDate Date The effective date parameter used to fetch records that are valid as of a specific start date, ensuring that only relevant records are returned.

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