Power BI Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

ReceivablesInvoicesreceivablesInvoiceDistributions

The receivables invoice distributions resource is used to create and get the invoice distributions associated to an invoice.

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId [KEY] Long ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceDistributions
DistributionId [KEY] Long The unique identifier of the invoice distribution.
InvoiceLineNumber Long The number of the invoice line associated with the distribution.
DetailedTaxLineNumber Long The number of the tax line of an invoice line associated with the distribution.
AccountClass String The account class of the distribution. Valid values are Revenue, Receivable, Freight, and Tax.
AccountCombination String The account code combination for the distribution.
Amount Decimal The amount of the distribution in the invoice currency.
AccountedAmount Decimal The amount of the distribution in the ledger currency.
Percent Decimal The percentage of the line amount mapped to this distribution.
Comments String The user-defined comments about the distribution.
CreatedBy String CreatedBy of ReceivablesInvoicesreceivablesInvoiceDistributions
CreationDate Datetime CreationDate of ReceivablesInvoicesreceivablesInvoiceDistributions
LastUpdateDate Datetime LastUpdateDate of ReceivablesInvoicesreceivablesInvoiceDistributions
LastUpdatedBy String LastUpdatedBy of ReceivablesInvoicesreceivablesInvoiceDistributions
AccountingDate Date AccountingDate of ReceivablesInvoicesreceivablesInvoiceDistributions
AllowCompletion String AllowCompletion of ReceivablesInvoicesreceivablesInvoiceDistributions
BillingDate Date BillingDate of ReceivablesInvoicesreceivablesInvoiceDistributions
BillToCustomerName String BillToCustomerName of ReceivablesInvoicesreceivablesInvoiceDistributions
BillToCustomerNumber String BillToCustomerNumber of ReceivablesInvoicesreceivablesInvoiceDistributions
BillToSite String BillToSite of ReceivablesInvoicesreceivablesInvoiceDistributions
BusinessUnit String BusinessUnit of ReceivablesInvoicesreceivablesInvoiceDistributions
CrossReference String CrossReference of ReceivablesInvoicesreceivablesInvoiceDistributions
CustomerTransactionId Long CustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceDistributions
DocumentNumber Long DocumentNumber of ReceivablesInvoicesreceivablesInvoiceDistributions
DueDate Date DueDate of ReceivablesInvoicesreceivablesInvoiceDistributions
Finder String Finder of ReceivablesInvoicesreceivablesInvoiceDistributions
FirstPartyTaxRegistration String FirstPartyTaxRegistration of ReceivablesInvoicesreceivablesInvoiceDistributions
InvoiceCurrencyCode String InvoiceCurrencyCode of ReceivablesInvoicesreceivablesInvoiceDistributions
InvoiceStatus String InvoiceStatus of ReceivablesInvoicesreceivablesInvoiceDistributions
LegalEntityIdentifier String LegalEntityIdentifier of ReceivablesInvoicesreceivablesInvoiceDistributions
PaymentTerms String PaymentTerms of ReceivablesInvoicesreceivablesInvoiceDistributions
PurchaseOrder String PurchaseOrder of ReceivablesInvoicesreceivablesInvoiceDistributions
ShipToCustomerName String ShipToCustomerName of ReceivablesInvoicesreceivablesInvoiceDistributions
ShipToSite String ShipToSite of ReceivablesInvoicesreceivablesInvoiceDistributions
ThirdPartyTaxRegistration String ThirdPartyTaxRegistration of ReceivablesInvoicesreceivablesInvoiceDistributions
TransactionDate Date TransactionDate of ReceivablesInvoicesreceivablesInvoiceDistributions
TransactionNumber String TransactionNumber of ReceivablesInvoicesreceivablesInvoiceDistributions
TransactionSource String TransactionSource of ReceivablesInvoicesreceivablesInvoiceDistributions
TransactionType String TransactionType of ReceivablesInvoicesreceivablesInvoiceDistributions

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