JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9060

ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules

The resource that provides details of payment schedules for transactions belonging to customer account sites, which is part of the receivablesCustomerAccountSiteActivities root resource. Transactions include invoices, debit memos, and chargebacks.

Columns

Name Type Description
ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId [KEY] Long ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
InstallmentId [KEY] Long InstallmentId of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
InstallmentNumber Long InstallmentNumber of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TotalOriginalAmount Decimal TotalOriginalAmount of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TotalBalanceAmount Decimal TotalBalanceAmount of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
PaymentDaysLate Int PaymentDaysLate of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
InstallmentStatus String InstallmentStatus of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TransactionNumber String TransactionNumber of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TransactionId Long TransactionId of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TransactionDate Date TransactionDate of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TransactionClass String TransactionClass of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
PaymentScheduleDueDate Date PaymentScheduleDueDate of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
AccountingDate Date AccountingDate of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
PurchaseOrder String PurchaseOrder of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TransactionType String TransactionType of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
ReceiptMethod String ReceiptMethod of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
EnteredCurrency String EnteredCurrency of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TransactionSourceName String TransactionSourceName of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
StructuredPaymentReference String StructuredPaymentReference of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
CreatedBy String CreatedBy of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
CreationDate Datetime CreationDate of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
LastUpdateDate Datetime LastUpdateDate of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
LastUpdatedBy String LastUpdatedBy of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
BillToSiteNumber String BillToSiteNumber of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
AccountNumber String AccountNumber of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
BillToSiteUseId Long BillToSiteUseId of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
CustomerName String CustomerName of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
Finder String Finder of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TaxpayerIdentificationNumber String TaxpayerIdentificationNumber of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TaxRegistrationNumber String TaxRegistrationNumber of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TransactionLimitByDays Int TransactionLimitByDays of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
TransactionStatus String TransactionStatus of ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules

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