SSIS Components for Oracle Fusion Cloud Financials

Build 24.0.9060

ReceivablesCustomerAccountActivitiestransactionPaymentSchedules

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
ReceivablesCustomerAccountActivitiesAccountId [KEY] Long ReceivablesCustomerAccountActivitiesAccountId of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
InstallmentId [KEY] Long InstallmentId of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
InstallmentNumber Long InstallmentNumber of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TotalOriginalAmount Decimal TotalOriginalAmount of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TotalBalanceAmount Decimal TotalBalanceAmount of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
PaymentDaysLate Int PaymentDaysLate of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
InstallmentStatus String InstallmentStatus of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TransactionNumber String TransactionNumber of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TransactionId Long TransactionId of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TransactionDate Date TransactionDate of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TransactionClass String TransactionClass of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
PaymentScheduleDueDate Date PaymentScheduleDueDate of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
AccountingDate Date AccountingDate of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
PurchaseOrder String PurchaseOrder of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TransactionType String TransactionType of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
ReceiptMethod String ReceiptMethod of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
EnteredCurrency String EnteredCurrency of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TransactionSourceName String TransactionSourceName of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
StructuredPaymentReference String StructuredPaymentReference of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
CreatedBy String CreatedBy of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
CreationDate Datetime CreationDate of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
LastUpdateDate Datetime LastUpdateDate of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
LastUpdatedBy String LastUpdatedBy of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
BillToSiteNumber String BillToSiteNumber of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
AccountId Long AccountId of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
AccountNumber String AccountNumber of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
CustomerName String CustomerName of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
Finder String Finder of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TaxpayerIdentificationNumber String TaxpayerIdentificationNumber of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TaxRegistrationNumber String TaxRegistrationNumber of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TransactionLimitByDays Int TransactionLimitByDays of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
TransactionStatus String TransactionStatus of ReceivablesCustomerAccountActivitiestransactionPaymentSchedules

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