Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9062

DebitAuthorizations

The debit authorization resource is used to view, create, and modify a debit authorization.

Columns

Name Type Description
DebitAuthorizationReferenceNumber String Unique user-specified reference number of a debit authorization.
CustomerBankAccountNumber String Bank account number of a customer. For display purposes, the masked value is returned.
BankName String BankName of DebitAuthorizations
BankBranchName String BankBranchName of DebitAuthorizations
BankAccountCountry String BankAccountCountry of DebitAuthorizations
BankAccountCurrency String BankAccountCurrency of DebitAuthorizations
IBAN String International Bank Account Number (IBAN), which is an alphanumeric sequence that conforms to the ISO standard for uniquely identifying a bank account number internationally. The standard IBAN carries all the routing information needed to get a payment from one bank to another.
BIC String BIC of DebitAuthorizations
LegalEntityName String Name of the legal entity on the debit authorization.
CreditorIdentificationNumber String Identification number of the creditor, as provided on the debit authorization document.
SigningDate Date Date when the debtor signed the debit authorization.
CancellationDate Date Date when the debtor canceled the debit authorization.
TransactionType String Type of debit authorization, one-off or recurring.
Frequency String Regularity with which direct debit instructions are created and processed.
FinalCollectionDate Date Date when the final collection of a direct debit was made, according to the debit authorization.
AuthorizationMethod String Method of delivering the debit authorization. Values include Digital Signature, Written Document, Phone, and Other.
VersionNumber Int Version number of the debit authorization. The version is set at 1 and increases with each new amendment.
ReasonForAmendment String ReasonForAmendment of DebitAuthorizations
EffectiveStartDate [KEY] Date EffectiveStartDate of DebitAuthorizations
EffectiveEndDate [KEY] Date EffectiveEndDate of DebitAuthorizations
DirectDebitCount Long DirectDebitCount of DebitAuthorizations
PrimaryIndicator String Indicates whether a debit authorization is primary.
Status String Status of DebitAuthorizations
DebitAuthorizationId [KEY] Long Identifier of a debit authorization.
CustomerPartyIdentifier Long Party identifier of the debtor.
CustomerPartyNumber String Party number of the debtor.
CustomerPartyName String Party name of the debtor.
CustomerBankAccountIdentifier Long Identifier of a customer bank account.
LegalEntityIdentifier Long Identifier of a legal entity.
Finder String Finder of DebitAuthorizations
SysEffectiveDate String SysEffectiveDate of DebitAuthorizations

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062