InvoicesinvoiceLinesinvoiceDistributions
Creates distribution records per invoice line, detailing account numbers, distribution dates, and expense allocations.
Table-Specific Information
Select
The driver uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The driver processes other filters within the driver.
For example, the following query is processed server-side:
SELECT * FROM [Cdata].[Financials].[InvoicesinvoiceLinesinvoiceDistributions] WHERE InvoiceDistributionId = 10003
Insert
Create an InvoicesinvoiceLinesinvoiceDistribution.
You need to provide InvoicesUniqId instead of InvoicesInvoiceId, and InvoicelinesUniqId instead of InvoicelinesLineNumber, to insert the record.
INSERT INTO [Cdata].[Financials].[invoicesinvoiceLinesinvoiceDistributions](InvoicesUniqId,InvoicelinesUniqId,DistributionLineNumber,DistributionCombination,DistributionAmount,DistributionLineType) VALUES (132432,'132432,10',46,'101.10.60230.462',3.25,'Item')
Update
The Oracle Fusion Cloud Financials API uses InvoicesUniqId instead of InvoicesInvoiceId, InvoicelinesUniqId instead of InvoicelinesLineNumber, and InvoiceDistributionUniqId instead of InvoiceDistributionId as a path parameter in the URL to update the record.
If you want to update a record directly using the Id (without any other filter), you can update the record in the following way:
UPDATE [Cdata].[Financials].[invoicesinvoiceLinesinvoiceDistributions] SET Description='adsw' WHERE InvoicelinesUniqId='1324325,45' AND InvoicesUniqId=13243 AND InvoiceDistributionUniqId=300000294882
Note: This does not require an extra GET request to retrieve the UniqId.
Alternatively, if you want to apply any other filter, use InvoicelinesLineNumber instead of InvoicelinesUniqId, InvoiceDistributionId instead of InvoiceDistributionUniqId, and InvoicesInvoiceId instead of InvoicesUniqId. You can update the record in the following way:
UPDATE [Cdata].[Financials].[invoicesinvoiceLinesinvoiceDistributions] SET Description='adsw' WHERE InvoicesInvocieId=1324325 AND Description='asw'
Note: Update on aggregates are not allowed by the API. Use the child tables to add/update/delete aggregates.
Delete
The Oracle Fusion Cloud Financials API uses InvoicesUniqId instead of InvoicesInvoiceId, InvoicelinesUniqId instead of InvoicelinesLineNumber, and InvoiceDistributionUniqId instead of InvoiceDistributionId as a path parameter in the URL to delete the record.
If you want to delete a record directly using the Id (without any other filter), you can delete the record in the following way:
DELETE FROM [Cdata].[Financials].[invoicesinvoiceLinesinvoiceDistributions] WHERE InvoicesUniqId=132432 AND InvoicelinesUniqId='1324325,46' AND InvoiceDistributionUniqId=300000294882
Note: This does not require an extra GET request to retrieve the UniqId.
Alternatively, if you want to apply any other filter, use InvoicelinesLineNumber instead of InvoicelinesUniqId, InvoiceDistributionId instead of InvoiceDistributionUniqId, and InvoicesInvoiceId instead of InvoicesUniqId. You can delete the record in the following way:
DELETE FROM [Cdata].[Financials].[invoicesinvoiceLinesinvoiceDistributions] WHERE InvoicelinesLineNumber=46 AND Description='asdw'
Columns
| Name | Type | ReadOnly | Description |
| InvoicesInvoiceId [KEY] | Long | True |
Unique identifier of the invoice associated with the invoice distribution, linking the distribution to the main invoice. |
| InvoicesUniqId [KEY] | String | True |
Unique identifier used for insert, update, and delete operations, preferred over InvoicesInvoiceId when managing invoice distributions. |
| InvoicelinesLineNumber [KEY] | Int | True |
Unique line number for the invoice, representing the invoice line to which the distribution is associated. |
| InvoicelinesUniqId [KEY] | String | True |
Unique identifier for managing insert, update, and delete operations related to invoice lines, preferred over InvoicelinesLineNumber. |
| InvoiceDistributionId [KEY] | Long | True |
Unique identifier for the invoice distribution record. It links the distribution to its associated invoice line. |
| InvoiceDistributionUniqId [KEY] | String | True |
Unique identifier for managing insert, update, and delete operations related to invoice distributions, preferred over InvoiceDistributionId. |
| DistributionLineNumber | Long | False |
Line number associated with the invoice distribution, identifying its sequence and relationship to the invoice. |
| DistributionLineType | String | False |
Type of the distribution line, such as 'Item', 'Freight', or 'Miscellaneous', used to categorize the distribution. |
| IncomeTaxType | String | False |
Tax type associated with the supplier's 1099 classification. It can be used to determine the applicable tax type for the invoice distribution. |
| AccountingStatus | String | True |
Current accounting status of the invoice distribution, indicating whether it has been processed for accounting. |
| MatchedStatus | String | True |
Indicates the matching status of the invoice distribution, showing whether the distribution has been matched with related documents such as purchase orders. |
| ValidationStatus | String | False |
Indicates whether the invoice distribution has passed validation and if all invoice holds have been released. The default value is 'Not Validated'. |
| AccountingDate | Date | False |
Date when the invoice distribution is recorded in accounting. It can be provided during creation or populated from the invoice header. |
| DistributionAmount | Decimal | False |
The total amount of the invoice distribution, which must be provided during creation and represents the allocated value for that distribution. |
| AssetBook | String | False |
Asset book associated with the invoice distribution, used for asset tracking in Oracle Fusion Assets. |
| DistributionCombination | String | False |
The accounting flexfield used for the distribution's account. This can be provided manually or defaulted from the invoice line. |
| TrackAsAssetFlag | Bool | False |
Indicates whether the invoice distribution is associated with an asset and should be tracked in Oracle Fusion Assets. |
| BaseAmount | Decimal | True |
Base amount before tax and other adjustments for the invoice distribution. |
| CanceledFlag | Bool | False |
Indicates whether the invoice distribution has been canceled. Default is false; set to true if the distribution has been canceled. |
| Description | String | False |
Description of the invoice distribution, providing details about the allocation or item represented by the distribution. |
| IncomeTaxRegion | String | False |
Tax reporting region for the invoice distribution, used for 1099 suppliers to determine the income tax region. |
| ReversedFlag | Bool | False |
Indicates whether the invoice distribution is part of a reversal. Default is false; set to true for reversal entries. |
| InvoicedQuantity | Decimal | True |
Quantity of items invoiced for the distribution, matching the quantity invoiced for the related line. |
| UOM | String | True |
Unit of measure for the invoiced quantity, such as 'kg' or 'box'. |
| UnitPrice | Decimal | True |
Price per unit of the invoiced items in the distribution. |
| PurchaseOrderDistributionLineNumber | Decimal | True |
Purchase order distribution line number matched to the invoice distribution. |
| PurchaseOrderNumber | String | True |
Purchase order number associated with the invoice distribution. |
| PurchaseOrderLineNumber | Decimal | True |
Purchase order line number matched to the invoice distribution. |
| PurchaseOrderScheduleLineNumber | Decimal | True |
Purchase order schedule line number matched to the invoice distribution. |
| ReceiptNumber | String | True |
Receipt number associated with the invoice distribution, representing goods receipt for the invoice line. |
| ReceiptLineNumber | Long | True |
Receipt line number associated with the invoice distribution. |
| ConsumptionAdviceNumber | String | True |
Consignment advice number linked to the invoice distribution. |
| ConsumptionAdviceLineNumber | Decimal | True |
Line number of the consignment advice linked to the invoice distribution. |
| AssociatedItemDistributionLineNumber | String | True |
Line number associated with the item distribution, helping to link the distribution to specific items. |
| FinalMatchFlag | Bool | True |
Indicates whether this invoice distribution is the final match for a purchase order, preventing further matches for that purchase order. |
| MultiperiodAccountingStartDate | Date | False |
Start date for multiperiod accounting applied to the invoice distribution. |
| MultiperiodAccountingEndDate | Date | False |
End date for multiperiod accounting applied to the invoice distribution. |
| MultiperiodAccountingAccrualAccount | String | False |
Account used for accruals in multiperiod accounting, representing deferred expenses for the distribution. |
| TaxRegimeName | String | True |
Name of the tax regime applied to the invoice distribution, helping to classify the distribution for tax purposes. |
| TaxName | String | True |
Name of the tax applied to the invoice distribution, such as 'VAT' or 'Sales Tax'. |
| TaxRecoverable | String | True |
Indicates whether the tax paid on the invoice distribution is recoverable, used for tax reporting and management. |
| TaxRate | String | True |
The tax rate applied to the invoice distribution for the calculation of tax amount. |
| TaxRateName | String | True |
Name of the tax rate applied to the invoice distribution. |
| TaxType | String | True |
Type of tax applied to the invoice distribution, such as 'Sales Tax' or 'Excise Tax'. |
| IntendedUse | String | False |
A tax driver used to determine applicable taxes for the distribution. Can be populated from the source document or entity setup. |
| IntendedUseCode | String | False |
Code that uniquely identifies the intended use for tax purposes in the invoice distribution. |
| CreatedBy | String | True |
User who created the invoice distribution. |
| CreationDate | Datetime | True |
Date when the invoice distribution was created. |
| LastUpdatedBy | String | True |
User who last updated the invoice distribution. |
| LastUpdateDate | Datetime | True |
Date when the invoice distribution was last updated. |
| LastUpdateLogin | String | True |
Login session associated with the user who last updated the invoice distribution. |
| PrepaymentNumber | String | True |
Prepayment number linked to the invoice distribution. |
| PrepaymentLineNumber | String | True |
Prepayment line number linked to the invoice distribution. |
| PrepaymentDistributionLineNumber | String | True |
Prepayment distribution line number linked to the invoice distribution. |
| PrepaymentAvailableAmount | Decimal | False |
Amount of the prepayment available to apply to the invoice distribution. |
| ChargeApplicableToDistId | Long | True |
Charge identifier for the distribution line, used for managing charges applicable to the distribution. |
| AllocationLineNumber | Int | True |
Line number used for the allocation of the invoice distribution. |
| AllocationDistributionLineNumber | Long | True |
Line number for the allocation of the distribution in the system. |
| BudgetDate | Date | False |
Budgetary date for funds check related to the invoice distribution. |
| FundsStatus | String | True |
Funds status for the invoice distribution, indicating whether funds are available for the distribution. |
| Finder | String | True |
Search term or identifier used for locating invoice distribution records. |
| InvoiceId | Long | True |
Unique identifier for the invoice associated with the distribution. |
| CUReferenceNumber | Int | False |
Reference number linking child aggregates to parent tables. |
| EffectiveDate | Date | True |
Date parameter used to fetch resources effective as of the specified start date. |