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.

JDBC Driver for Oracle Financials Cloud

ReceivablesCustomerAccountActivitiestransactionPaymentSchedules

Columns