CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

PayablesOptions

Centralizes configuration for Payables, such as defaulting rules and processing parameters, shaping invoice and payment workflows.

Columns

Name Type Description
SettlementDays Int The number of days allowed for settling payments in the payables system.
BusinessUnitId [KEY] Long The unique identifier for the business unit associated with the payables options.
AllowFinalMatchingFlag Bool Indicates whether final matching of invoices to purchase orders is allowed.
AllowMatchingDistributionOverrideFlag Bool Indicates whether the distribution of matched invoices can be overridden.
AllowForceApprovalFlag Bool Indicates whether invoices can be forcefully approved, bypassing approval workflows.
AllowAdjustmentsToPaidInvoicesFlag Bool Indicates whether adjustments to already paid invoices are allowed.
AllowRemitToSupplierOverrideForThirdPartyPaymentsFlag Bool Indicates whether the 'Remit to Supplier' option can be overridden for third-party payments.
AllowPayeeOverrideForThirdPartyPaymentsFlag Bool Indicates whether the 'Payee' field can be overridden for third-party payments.
AllowOverrideOfSupplierSiteBankAccountFlag Bool Indicates whether the bank account information associated with the supplier site can be overridden.
AlwaysTakeDiscFlag Bool Indicates whether discounts should always be taken, even if not specified.
RequireAccountingBeforeApproval String Indicates whether accounting entries must be created before invoice approval.
EnableInvoiceApprovalFlag Bool Indicates whether invoice approval workflows are enabled.
CreateInterestInvoicesFlag Bool Indicates whether interest invoices should be automatically created.
BankChargeDeductionType String Specifies the method for deducting bank charges from payments.
BudgetDateBasis String Defines the basis for budget date determination for payables transactions.
UseDistributionFromPurchaseOrderFlag Bool Indicates whether distribution information should be pulled from the purchase order.
DiscountAllocationMethod String Specifies how discounts should be allocated to invoice lines.
ExcludeTaxFromDiscountCalculationFlag Bool Indicates whether tax should be excluded from discount calculations.
PaymentRequestPaymentPriority Int Defines the priority for processing payment requests.
PaymentRequestPayGroup String Specifies the pay group associated with the payment request.
ExcludeFreightFromDiscountCalculationFlag Bool Indicates whether freight costs should be excluded from discount calculations.
GlDateFromReceiptFlag Bool Indicates whether the GL date should be derived from the receipt date.
MinimumInterestAmount Decimal Specifies the minimum amount for which interest is calculated.
InvoiceCurrency String The currency used for the invoice, which may be different from the payment currency.
AllowInvoiceDocumentCategoryOverrideFlag Bool Indicates whether the document category for an invoice can be overridden.
LastUpdateDate Datetime The date when the payables options were last updated.
RequireConversionRateEntryForPaymentsFlag Bool Indicates whether a conversion rate is required for payments in foreign currencies.
PaymentCurrency String The currency in which payments is made.
PayDateBasis String Defines the basis for determining the payment date for payables transactions.
AllowPaymentDocumentCategoryOverrideFlag Bool Indicates whether the document category for a payment can be overridden.
PaymentPriority Int The priority level for payments, determining their order of processing.
AllowPaymentDateBeforeTheSystemDateFlag Bool Indicates whether payments can be scheduled before the system's current date.
ShowAvailablePrepaymentsDuringInvoiceEntryFlag Bool Indicates whether available prepayments should be shown during invoice entry.
InterestAllocationMethodFlag Bool Indicates whether the interest allocation method is enabled.
RecalculateInvoiceInstallmentsFlag Bool Indicates whether the system should recalculate invoice installments after changes.
ReceiptAcceptanceDays Long The number of days allowed for receipt acceptance after an invoice is issued.
EnableInvoiceAccountCodingWorkflowFlag Bool Indicates whether the workflow for coding invoices to accounts is enabled.
AllowInvoiceBackdatingForSelfServiceInvoicesFlag Bool Indicates whether backdating of invoices is allowed for self-service invoices.
LimitInvoiceToSinglePurchaseOrderForSelfServiceInvoicesFlag Bool Indicates whether invoices should be limited to a single purchase order for self-service invoices.
AllowUnitPriceChangeForQuantityBasedMatchesForSelfServiceInvoices String Specifies whether unit prices can be changed for quantity-based matches for self-service invoices.
TermsDateBasis String Defines the basis for calculating terms dates on invoices.
TransferPOdistributionAdditionalInformationFlag Bool Indicates whether additional distribution information from the purchase order should be transferred.
RequireValidationBeforeApprovalFlag Bool Indicates whether invoices must be validated before approval.
PayGroup String Specifies the pay group associated with the payables transactions.
AccountForPayment String The account from which payments should be made in the payables system.
LastUpdateLogin String The login of the user who last updated the payables options.
LastUpdatedBy String The name of the user who last updated the payables options.
CreatedBy String The name of the user who created the payables options.
CreationDate Datetime The date and time when the payables options were created.
BusinessUnitName String The name of the business unit associated with the payables options.
PaymentRequestPaymentTerms String Defines the payment terms for payment requests in the payables system.
InterestExpenseDistribution String Defines how interest expenses should be distributed in payables.
PrepaymentPaymentTerms String Defines the payment terms applicable to prepayment invoices.
AmountTolerances String Defines the tolerances allowed for amounts in the payables system.
PaymentTerms String Specifies the payment terms for invoices.
QuantityTolerances String Defines the tolerances allowed for quantities in the payables system.
LedgerId Long The unique identifier for the ledger associated with the payables options.
LedgerCurrency String The currency associated with the ledger in the payables options.
FederalIdentificationNumber String The federal identification number associated with the payables options.
LocationId Long The location ID associated with the payables options.
AllowAddressChange String Indicates whether address changes are allowed in the payables system.
IncomeTaxCombinedFilingProgram String Specifies the income tax combined filing program in the payables options.
IncomeTaxRegion String The region for income tax purposes in the payables options.
SupplierTaxRegion String The tax region for the supplier in the payables options.
USSGLTransactionCode String The USSGL transaction code for payables transactions.
USSGLTrxDescriptiveFlexfieldContext String The context for USSGL transaction descriptive flexfields in payables.
IncludeWitholdingDistInIncometaxreports String Indicates whether withholding distribution should be included in income tax reports.
RequireInvoiceGroup String Indicates whether invoices should be grouped for payment processing.
AttachmentMandatoryForSelfServiceInvoicesFlag Bool Indicates whether attachments are mandatory for self-service invoices.
DisallowAttachmentDeleteFlag Bool Indicates whether the deletion of attachments is disallowed in the payables system.
AccountingDateBasis String Defines the basis for accounting dates in the payables system.
Finder String Search term or keyword used for finding the payables options.

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