JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

ReceivablesCustomerAccountActivitiestransactionPaymentSchedules

ReceivablesCustomerAccountActivitiestransactionPaymentSchedules

Columns

Name Type Description
ReceivablesCustomerAccountActivitiesAccountId String The unique identifier of a customer account for a REST service.
InstallmentId String The identifier of the payment schedule installment for a REST service.
InstallmentNumber String The number of the payment schedule installment for a REST service.
TotalOriginalAmount String The original balance amount on the payment schedule installment for a REST service.
TotalBalanceAmount String The open balance amount on the payment schedule installment for a REST service.
PaymentDaysLate Long The number of days the payment schedule installment is past due for a REST service.
InstallmentStatus String The status of the payment schedule installment for a REST service.
TransactionNumber String The transaction number of the payment schedule installment for a REST service.
TransactionId String The transaction identifier of the payment schedule installment for a REST service.
TransactionDate Date The transaction date of the payment schedule installment for a REST service.
TransactionClass String The transaction class of the payment schedule installment for a REST service.
PaymentScheduleDueDate Date The payment terms due date of the payment schedule installment for a REST service.
AccountingDate Date The payment schedule installment accounting date for a REST service.
PurchaseOrder String The purchase order number assigned to the payment schedule installment for a REST service.
TransactionType String The transaction type of the payment schedule installment for a REST service.
ReceiptMethod String The receipt method used for the receipt applied against the payment schedule installment for a REST service.
EnteredCurrency String The currency code of the payment schedule installment for a REST service.
TransactionSourceName String The name of the transaction source assigned to the payment schedule transaction for a REST service.
StructuredPaymentReference String The name of the structured payment reference assigned to the payment schedule transaction for a REST service.
CreatedBy String The name of the user who created the payment schedule installment for a REST service.
CreationDate Datetime The creation date of the payment schedule installment for a REST service.
LastUpdateDate Datetime The date the payment schedule installment was last updated for a REST service.
LastUpdatedBy String The name of the user who last updated the payment schedule installment for a REST service.
BillToSiteNumber String The name of the customer bill-to site of the transaction payment schedule.

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