Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

ReceivablesInvoicesreceivablesInvoiceInstallments

The receivables invoice installments resource is used to edit and get the installments of an invoice. Note: You can update only the InstallmentDueDate and OriginalAmount attributes.

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId [KEY] Long ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentId [KEY] Long InstallmentId of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentSequenceNumber Long InstallmentSequenceNumber of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentDueDate Date InstallmentDueDate of ReceivablesInvoicesreceivablesInvoiceInstallments
OriginalAmount Decimal OriginalAmount of ReceivablesInvoicesreceivablesInvoiceInstallments
PaymentDaysLate Int PaymentDaysLate of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentBalanceDue Decimal InstallmentBalanceDue of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentStatus String InstallmentStatus of ReceivablesInvoicesreceivablesInvoiceInstallments
DisputeAmount Decimal DisputeAmount of ReceivablesInvoicesreceivablesInvoiceInstallments
DisputeDate Date DisputeDate of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentClosedDate Date InstallmentClosedDate of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentGLClosedDate Date InstallmentGLClosedDate of ReceivablesInvoicesreceivablesInvoiceInstallments
AccountedBalanceDue Decimal AccountedBalanceDue of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentAmountAdjusted Decimal InstallmentAmountAdjusted of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentAmountCredited Decimal InstallmentAmountCredited of ReceivablesInvoicesreceivablesInvoiceInstallments
AmountPaid Decimal AmountPaid of ReceivablesInvoicesreceivablesInvoiceInstallments
PendingAdjustmentAmount Decimal PendingAdjustmentAmount of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentLineAmountOriginal Decimal InstallmentLineAmountOriginal of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentLineAmountDue Decimal InstallmentLineAmountDue of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentFreightAmountOriginal Decimal InstallmentFreightAmountOriginal of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentFreightAmountDue Decimal InstallmentFreightAmountDue of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentTaxAmountOriginal Decimal InstallmentTaxAmountOriginal of ReceivablesInvoicesreceivablesInvoiceInstallments
InstallmentTaxAmountDue Decimal InstallmentTaxAmountDue of ReceivablesInvoicesreceivablesInvoiceInstallments
CreationDate Datetime CreationDate of ReceivablesInvoicesreceivablesInvoiceInstallments
CreatedBy String CreatedBy of ReceivablesInvoicesreceivablesInvoiceInstallments
LastUpdateDate Datetime LastUpdateDate of ReceivablesInvoicesreceivablesInvoiceInstallments
LastUpdatedBy String LastUpdatedBy of ReceivablesInvoicesreceivablesInvoiceInstallments
ExcludeFromCollections String ExcludeFromCollections of ReceivablesInvoicesreceivablesInvoiceInstallments
AccountingDate Date AccountingDate of ReceivablesInvoicesreceivablesInvoiceInstallments
AllowCompletion String AllowCompletion of ReceivablesInvoicesreceivablesInvoiceInstallments
BillingDate Date BillingDate of ReceivablesInvoicesreceivablesInvoiceInstallments
BillToCustomerName String BillToCustomerName of ReceivablesInvoicesreceivablesInvoiceInstallments
BillToCustomerNumber String BillToCustomerNumber of ReceivablesInvoicesreceivablesInvoiceInstallments
BillToSite String BillToSite of ReceivablesInvoicesreceivablesInvoiceInstallments
BusinessUnit String BusinessUnit of ReceivablesInvoicesreceivablesInvoiceInstallments
CrossReference String CrossReference of ReceivablesInvoicesreceivablesInvoiceInstallments
CustomerTransactionId Long CustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceInstallments
DocumentNumber Long DocumentNumber of ReceivablesInvoicesreceivablesInvoiceInstallments
DueDate Date DueDate of ReceivablesInvoicesreceivablesInvoiceInstallments
Finder String Finder of ReceivablesInvoicesreceivablesInvoiceInstallments
FirstPartyTaxRegistration String FirstPartyTaxRegistration of ReceivablesInvoicesreceivablesInvoiceInstallments
InvoiceCurrencyCode String InvoiceCurrencyCode of ReceivablesInvoicesreceivablesInvoiceInstallments
InvoiceStatus String InvoiceStatus of ReceivablesInvoicesreceivablesInvoiceInstallments
LegalEntityIdentifier String LegalEntityIdentifier of ReceivablesInvoicesreceivablesInvoiceInstallments
PaymentTerms String PaymentTerms of ReceivablesInvoicesreceivablesInvoiceInstallments
PurchaseOrder String PurchaseOrder of ReceivablesInvoicesreceivablesInvoiceInstallments
ShipToCustomerName String ShipToCustomerName of ReceivablesInvoicesreceivablesInvoiceInstallments
ShipToSite String ShipToSite of ReceivablesInvoicesreceivablesInvoiceInstallments
ThirdPartyTaxRegistration String ThirdPartyTaxRegistration of ReceivablesInvoicesreceivablesInvoiceInstallments
TransactionDate Date TransactionDate of ReceivablesInvoicesreceivablesInvoiceInstallments
TransactionNumber String TransactionNumber of ReceivablesInvoicesreceivablesInvoiceInstallments
TransactionSource String TransactionSource of ReceivablesInvoicesreceivablesInvoiceInstallments
TransactionType String TransactionType of ReceivablesInvoicesreceivablesInvoiceInstallments

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