JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

PayablesOptions

PayablesOptions

Columns

Name Type Description
SettlementDays Long SettlementDays
BusinessUnitId [KEY] String BusinessUnitId
AllowFinalMatchingFlag Bool AllowFinalMatchingFlag
AllowMatchingDistributionOverrideFlag Bool AllowMatchingDistributionOverrideFlag
AllowForceApprovalFlag Bool AllowForceApprovalFlag
AllowAdjustmentsToPaidInvoicesFlag Bool AllowAdjustmentsToPaidInvoicesFlag
AllowRemitToSupplierOverrideForThirdPartyPaymentsFlag Bool AllowRemitToSupplierOverrideForThirdPartyPaymentsFlag
AllowPayeeOverrideForThirdPartyPaymentsFlag Bool AllowPayeeOverrideForThirdPartyPaymentsFlag
AllowOverrideOfSupplierSiteBankAccountFlag Bool AllowOverrideOfSupplierSiteBankAccountFlag
AlwaysTakeDiscFlag Bool AlwaysTakeDiscFlag
RequireAccountingBeforeApproval String RequireAccountingBeforeApproval
EnableInvoiceApprovalFlag Bool EnableInvoiceApprovalFlag
CreateInterestInvoicesFlag Bool CreateInterestInvoicesFlag
BankChargeDeductionType String BankChargeDeductionType
BudgetDateBasis String BudgetDateBasis
UseDistributionFromPurchaseOrderFlag Bool UseDistributionFromPurchaseOrderFlag
DiscountAllocationMethod String DiscountAllocationMethod
ExcludeTaxFromDiscountCalculationFlag Bool ExcludeTaxFromDiscountCalculationFlag
PaymentRequestPaymentPriority Long PaymentRequestPaymentPriority
PaymentRequestPayGroup String PaymentRequestPayGroup
ExcludeFreightFromDiscountCalculationFlag Bool ExcludeFreightFromDiscountCalculationFlag
GlDateFromReceiptFlag Bool GlDateFromReceiptFlag
MinimumInterestAmount String MinimumInterestAmount
InvoiceCurrency String InvoiceCurrency
AllowInvoiceDocumentCategoryOverrideFlag Bool AllowInvoiceDocumentCategoryOverrideFlag
LastUpdateDate Datetime LastUpdateDate
RequireConversionRateEntryForPaymentsFlag Bool RequireConversionRateEntryForPaymentsFlag
PaymentCurrency String PaymentCurrency
PayDateBasis String PayDateBasis
AllowPaymentDocumentCategoryOverrideFlag Bool AllowPaymentDocumentCategoryOverrideFlag
PaymentPriority Long PaymentPriority
AllowPaymentDateBeforeTheSystemDateFlag Bool AllowPaymentDateBeforeTheSystemDateFlag
ShowAvailablePrepaymentsDuringInvoiceEntryFlag Bool ShowAvailablePrepaymentsDuringInvoiceEntryFlag
InterestAllocationMethodFlag Bool InterestAllocationMethodFlag
RecalculateInvoiceInstallmentsFlag Bool RecalculateInvoiceInstallmentsFlag
ReceiptAcceptanceDays String ReceiptAcceptanceDays
EnableInvoiceAccountCodingWorkflowFlag Bool EnableInvoiceAccountCodingWorkflowFlag
AllowInvoiceBackdatingForSelfServiceInvoicesFlag Bool AllowInvoiceBackdatingForSelfServiceInvoicesFlag
LimitInvoiceToSinglePurchaseOrderForSelfServiceInvoicesFlag Bool LimitInvoiceToSinglePurchaseOrderForSelfServiceInvoicesFlag
AllowUnitPriceChangeForQuantityBasedMatchesForSelfServiceInvoices String AllowUnitPriceChangeForQuantityBasedMatchesForSelfServiceInvoices
TermsDateBasis String TermsDateBasis
TransferPOdistributionAdditionalInformationFlag Bool TransferPOdistributionAdditionalInformationFlag
RequireValidationBeforeApprovalFlag Bool RequireValidationBeforeApprovalFlag
PayGroup String PayGroup
AccountForPayment String AccountForPayment
LastUpdateLogin String LastUpdateLogin
LastUpdatedBy String LastUpdatedBy
CreatedBy String CreatedBy
CreationDate Datetime CreationDate
BusinessUnitName String BusinessUnitName
PaymentRequestPaymentTerms String PaymentRequestPaymentTerms
InterestExpenseDistribution String InterestExpenseDistribution
PrepaymentPaymentTerms String PrepaymentPaymentTerms
AmountTolerances String AmountTolerances
PaymentTerms String PaymentTerms
QuantityTolerances String QuantityTolerances
LedgerId String LedgerId
LedgerCurrency String LedgerCurrency
FederalIdentificationNumber String FederalIdentificationNumber
LocationId String LocationId
AllowAddressChange String AllowAddressChange
IncomeTaxCombinedFilingProgram String IncomeTaxCombinedFilingProgram
IncomeTaxRegion String IncomeTaxRegion
SupplierTaxRegion String SupplierTaxRegion
USSGLTransactionCode String USSGLTransactionCode
USSGLTrxDescriptiveFlexfieldContext String USSGLTrxDescriptiveFlexfieldContext
IncludeWitholdingDistInIncometaxreports String IncludeWitholdingDistInIncometaxreports
RequireInvoiceGroup String RequireInvoiceGroup
AttachmentMandatoryForSelfServiceInvoicesFlag Bool AttachmentMandatoryForSelfServiceInvoicesFlag
DisallowAttachmentDeleteFlag Bool DisallowAttachmentDeleteFlag
AccountingDateBasis String AccountingDateBasis

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462