JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

InvoicesinvoiceLinesinvoiceDistributions

The payables invoice distributions resource is used to manage details that are used to create accounting entries, and includes information, such as accounting date, distribution combinations, and the details necessary for integration with applications, such as Oracle Fusion Assets.

Columns

Name Type Description
InvoicesInvoiceId [KEY] Long InvoicesInvoiceId of InvoicesinvoiceLinesinvoiceDistributions
InvoicelinesLineNumber [KEY] Int InvoicelinesLineNumber of InvoicesinvoiceLinesinvoiceDistributions
InvoiceDistributionId [KEY] Long InvoiceDistributionId of InvoicesinvoiceLinesinvoiceDistributions
DistributionLineNumber Long The line number associated with the invoice distribution. The value must be provided while creating an invoice distribution and cannot be updated once the invoice distribution is created.
DistributionLineType String The type of invoice line. The value must be provided while creating an invoice distribution. The valid values are Item, Freight and Miscellaneous. A list of accepted values is defined in the lookup type INVOICE DISTRIBUTION TYPE and can be reviewed using the Setup and Maintenance work area, and the Manage Payables Lookups task.
IncomeTaxType String The payments of type 1099 made to a supplier. A 1099 supplier may receive payments of more than one type. The value can either be provided while creating an invoice distribution or populated by default from the parent invoice line.
AccountingStatus String AccountingStatus of InvoicesinvoiceLinesinvoiceDistributions
MatchedStatus String MatchedStatus of InvoicesinvoiceLinesinvoiceDistributions
ValidationStatus String The option that indicates whether an invoice has passed validation and all invoice holds have been released. The default value is set to Not Validated.
AccountingDate Date The date when the invoice distribution is to be accounted. The value can either be provided while creating an invoice distribution or populated by default from the parent invoice line.
DistributionAmount Decimal The amount on invoice distribution. The value must be provided while creating an invoice distribution.
AssetBook String The asset book candidate for transfer to Oracle Fusion Assets.
DistributionCombination String The accounting flexfield for account associated with a distribution. The value can be provided while creating an invoice distribution or populated by default from the parent invoice line.
TrackAsAssetFlag Bool Indicates if the item should be transferred to Oracle Fusion Assets. The value can either be provided while creating an invoice distribution or populated by default from parent invoice line or populated by default to true if an asset account is provided in the distribution combination. If the value is true, then it indicates that the item should be transferred to Oracle Fusion Assets.
BaseAmount Decimal BaseAmount of InvoicesinvoiceLinesinvoiceDistributions
CanceledFlag Bool Indicates whether an invoice distribution is canceled. The default value is false. If the value if true, then it indicates the invoice distribution is canceled.
Description String The description of the invoice description. The value can be provided while creating an invoice distribution or populated by default from the parent invoice line.
IncomeTaxRegion String The reporting region for invoice line for 1099 supplier. The value can be provided while creating an invoice distribution or populated by default from the parent invoice line.
ReversedFlag Bool Indicates whether a distribution is part of a reversal pair. The default value is false. If the value if true, then it indicates the distribution is part of a reversal pair.
InvoicedQuantity Decimal InvoicedQuantity of InvoicesinvoiceLinesinvoiceDistributions
UOM String UOM of InvoicesinvoiceLinesinvoiceDistributions
UnitPrice Decimal UnitPrice of InvoicesinvoiceLinesinvoiceDistributions
PurchaseOrderDistributionLineNumber Decimal PurchaseOrderDistributionLineNumber of InvoicesinvoiceLinesinvoiceDistributions
PurchaseOrderNumber String PurchaseOrderNumber of InvoicesinvoiceLinesinvoiceDistributions
PurchaseOrderLineNumber Decimal PurchaseOrderLineNumber of InvoicesinvoiceLinesinvoiceDistributions
PurchaseOrderScheduleLineNumber Decimal PurchaseOrderScheduleLineNumber of InvoicesinvoiceLinesinvoiceDistributions
ReceiptNumber String ReceiptNumber of InvoicesinvoiceLinesinvoiceDistributions
ReceiptLineNumber Long ReceiptLineNumber of InvoicesinvoiceLinesinvoiceDistributions
ConsumptionAdviceNumber String ConsumptionAdviceNumber of InvoicesinvoiceLinesinvoiceDistributions
ConsumptionAdviceLineNumber Decimal ConsumptionAdviceLineNumber of InvoicesinvoiceLinesinvoiceDistributions
AssociatedItemDistributionLineNumber String AssociatedItemDistributionLineNumber of InvoicesinvoiceLinesinvoiceDistributions
FinalMatchFlag Bool FinalMatchFlag of InvoicesinvoiceLinesinvoiceDistributions
MultiperiodAccountingStartDate Date The multiperiod accounting start date on the invoice distribution.
MultiperiodAccountingEndDate Date The multiperiod accounting end date on the invoice distribution.
MultiperiodAccountingAccrualAccount String The accrual account used in multiperiod accounting to accrue deferred expenses.
TaxRegimeName String TaxRegimeName of InvoicesinvoiceLinesinvoiceDistributions
TaxName String TaxName of InvoicesinvoiceLinesinvoiceDistributions
TaxRecoverable String TaxRecoverable of InvoicesinvoiceLinesinvoiceDistributions
TaxRate String TaxRate of InvoicesinvoiceLinesinvoiceDistributions
TaxRateName String TaxRateName of InvoicesinvoiceLinesinvoiceDistributions
TaxType String TaxType of InvoicesinvoiceLinesinvoiceDistributions
IntendedUse String A tax driver used to determine and calculate the applicable taxes. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup. When passing the attribute value in the payload, ensure that you are passing a value for the intended use code attribute as well.
IntendedUseCode String The user-entered intended use code that helps to uniquely identify an intended use.
CreatedBy String CreatedBy of InvoicesinvoiceLinesinvoiceDistributions
CreationDate Datetime CreationDate of InvoicesinvoiceLinesinvoiceDistributions
LastUpdatedBy String LastUpdatedBy of InvoicesinvoiceLinesinvoiceDistributions
LastUpdateDate Datetime LastUpdateDate of InvoicesinvoiceLinesinvoiceDistributions
LastUpdateLogin String LastUpdateLogin of InvoicesinvoiceLinesinvoiceDistributions
PrepaymentNumber String PrepaymentNumber of InvoicesinvoiceLinesinvoiceDistributions
PrepaymentLineNumber String PrepaymentLineNumber of InvoicesinvoiceLinesinvoiceDistributions
PrepaymentDistributionLineNumber String PrepaymentDistributionLineNumber of InvoicesinvoiceLinesinvoiceDistributions
PrepaymentAvailableAmount Decimal The amount of the prepayment that can still be applied to an invoice.
ChargeApplicableToDistId Long ChargeApplicableToDistId of InvoicesinvoiceLinesinvoiceDistributions
AllocationLineNumber Int AllocationLineNumber of InvoicesinvoiceLinesinvoiceDistributions
AllocationDistributionLineNumber Long AllocationDistributionLineNumber of InvoicesinvoiceLinesinvoiceDistributions
BudgetDate Date Budgetary Calendar Period Date applicable for funds check.
FundsStatus String FundsStatus of InvoicesinvoiceLinesinvoiceDistributions
Finder String Finder of InvoicesinvoiceLinesinvoiceDistributions
InvoiceId Long InvoiceId of InvoicesinvoiceLinesinvoiceDistributions

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