CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

InvoicesinvoiceLines

Captures goods, services, freight, and miscellaneous charges at the invoice line level, forming the basis for accounting entries.

Table-Specific Information

Select

The connector uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The connector processes other filters within the connector.

For example, the following query is processed server-side: 

SELECT * FROM [Cdata].[Financials].[InvoicesinvoiceLines] WHERE LineNumber = 10003

Insert

Create an InvoicesinvoiceLine.

You need to provide InvoicesUniqId, instead of InvoicesInvoiceId, to insert the record. 

INSERT INTO [Cdata].[Financials].[invoicesinvoiceLines](InvoicesUniqId,LineNumber,DistributionCombination,LineAmount) VALUES (132432,46,'101.10.60230.462',3.25)

Update

The Oracle Fusion Cloud Financials API uses InvoicesUniqId instead of InvoicesInvoiceId and LineNumberUniqId instead of LineNumber 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].[invoicesinvoiceLines] SET Description='adsw' WHERE LineNumberUniqId='1324325,45' AND InvoicesUniqId=13243;

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use LineNumber instead of LineNumberUniqId and InvoicesInvoiceId instead of InvoicesUniqId. You can update the record in the following way: 

UPDATE [Cdata].[Financials].[invoicesinvoiceLines] SET Description='adsw' WHERE Description='asas' AND InvoicesInvoiceId=13243

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 and LineNumberUniqId instead of LineNumber 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].[invoicesinvoiceLines] WHERE InvoicesUniqId=132432 AND LineNumberUniqId='1324325,46'

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use LineNumber instead of LineNumberUniqId and InvoicesInvoiceId instead of InvoicesUniqId. You can delete the record in the following way: 

DELETE FROM [Cdata].[Financials].[invoicesinvoiceLines] WHERE Description='asas' AND InvoicesInvoiceId=13243

Columns

Name Type ReadOnly Description
InvoicesInvoiceId [KEY] Long True

Unique identifier of the invoice associated with the invoice line, linking the line to its corresponding invoice.

InvoicesUniqId [KEY] String True

Unique identifier used for insert, update, and delete operations, preferred over InvoicesInvoiceId when managing invoice lines.

LineNumber [KEY] Int False

Unique number assigned to each invoice line. It must be provided when creating the invoice line and cannot be updated once created.

LineNumberUniqId [KEY] String True

Unique identifier for managing insert, update, and delete operations related to invoice lines, preferred over LineNumber.

LineAmount Decimal False

The amount of the invoice line in the invoice currency. This value must be provided during invoice line creation.

AccountingDate Date False

The accounting date for the invoice line, which is used to default values in invoice distributions. It can be derived or manually entered.

UOM String False

Unit of measure for the quantity invoiced, such as 'kg' or 'box', indicating the quantity for the line item.

TaxRateName String True

Name of the tax rate associated with the invoice line, defining the applicable tax rate.

LineType String False

Type of invoice line, such as 'Item', 'Freight', or 'Miscellaneous'. The type defines the nature of the line item.

AssetBook String False

Asset book associated with the invoice line, relevant for transferring the item to Oracle Fusion Assets.

TrackAsAssetFlag Bool False

Indicates whether the item should be tracked as an asset in Oracle Fusion Assets. Defaulted based on distribution settings.

BaseAmount Decimal True

Base amount for the invoice line before taxes and adjustments.

Description String False

Description of the invoice line item, providing additional details about the line.

IncomeTaxRegion String False

Region for reporting income tax on the invoice line, used for tax purposes, especially in 1099 reporting.

Item String False

Inventory item identifier, corresponding to the item being invoiced.

ItemDescription String True

Description of the inventory item associated with the invoice line.

LineSource String True

Source of the invoice line, identifying how the line item is classified or categorized.

Quantity Decimal False

The quantity of items invoiced, including any price corrections, quantity corrections, or unmatched lines.

DistributionCombination String False

Accounting flexfield used for generating a distribution for the invoice line. This can be defaulted from supplier settings.

AssetCategory String False

Category under which the asset line is grouped when transferring to Oracle Fusion Assets.

UnitPrice Decimal False

Price per unit of the good or service invoiced.

ProrateAcrossAllItemsFlag Bool False

Indicates whether freight or miscellaneous charges should be prorated across all item lines. Default is false.

LandedCostEnabled String False

Indicates whether the invoice line is enabled for calculating and including landed cost.

DiscardedFlag Bool True

Flag indicating whether the invoice line has been discarded and should no longer be considered.

CanceledFlag Bool True

Flag indicating whether the invoice line has been canceled.

IncomeTaxType String False

Income tax type applicable to the supplier, such as 1099 tax classification for certain suppliers.

TaxRateCode String True

Tax rate code applied to the invoice line for tax calculation purposes.

TaxRate Decimal True

Tax rate applied to the invoice line, indicating the percentage for tax calculation.

TaxClassification String False

Tax classification code used to categorize the invoice line for tax purposes.

GenerateDistributions String True

Indicates whether distributions should be generated for the invoice line during accounting.

BudgetDate Date False

Budgetary calendar period date applicable for funds checking.

FundsStatus String True

Status of funds available for the invoice line, used in budget tracking.

ApprovalStatus String True

Current approval status of the invoice line, such as approved or pending.

DistributionSet String False

Distribution set used for generating distributions for the invoice line.

Withholding String False

Name of the withholding tax group applied to the invoice line.

ShipToLocationCode String False

Code identifying the location where goods were shipped to for the invoice line.

ShipToLocation String False

Location where the goods or services were delivered, as specified for the invoice line.

ShipToCustomerLocation String True

Customer location associated with the invoice line delivery.

TaxControlAmount Decimal False

User-entered amount ensuring the calculated tax matches the physical document.

AssessableValue Decimal False

Deemed price at which the product is valued for tax calculation purposes.

ProductType String False

Type of product, such as goods or services, determined by the inventory item attributes.

ProductCategory String False

Taxable nature of a non-inventory item, used for tax calculation and reporting purposes.

ProductCategoryCodePath String False

Code path used to uniquely identify a product category for tax reporting.

UserDefinedFiscalClassification String False

Classification used for any tax requirements not defined by standard fiscal classification types.

UserDefinedFiscalClassificationCode String False

User-entered code for a custom fiscal classification.

IntendedUse String False

Tax driver used to determine applicable taxes for the invoice line.

IntendedUseCode String False

Code identifying the intended use for tax purposes, used to help determine tax rates.

ProductFiscalClassification String False

Tax classification used by tax authorities to categorize a product.

ProductFiscalClassificationCode String False

Code used to uniquely identify the product fiscal classification.

ProductFiscalClassificationType String False

Type of product fiscal classification used for tax purposes.

TransactionBusinessCategory String False

Transaction category assigned to the invoice line for tax calculation.

TransactionBusinessCategoryCodePath String False

Code path used to uniquely identify a transaction business category.

Requester String False

Name of the person who requested the goods or services, used in the invoice approval workflow.

PurchasingCategory String True

Category used to group purchases for tax and reporting purposes.

MatchType String True

Indicates the matching type used for the invoice line, such as Purchase Order Match.

MatchOption String True

Option used to control how the invoice line is matched, such as 2-way or 3-way matching.

MatchBasis String True

Basis used to perform the match between the invoice line and purchase orders or receipts.

PurchaseOrderNumber String False

Purchase order number matched to the invoice line.

PurchaseOrderLineNumber Decimal False

Purchase order line number matched to the invoice line.

PurchaseOrderScheduleLineNumber Decimal False

Schedule line number from the purchase order matched to the invoice line.

ReceiptNumber String False

Receipt number associated with the invoice line.

ReceiptLineNumber Long False

Receipt line number associated with the invoice line.

ConsumptionAdviceNumber String False

Consignment advice number associated with the invoice line.

ConsumptionAdviceLineNumber Decimal False

Line number of the consignment advice matched to the invoice line.

FinalMatchFlag Bool False

Indicates whether this invoice line is the final match to a purchase order schedule, preventing further matching.

MultiperiodAccountingStartDate Date False

Start date for multiperiod accounting for the invoice line.

MultiperiodAccountingEndDate Date False

End date for multiperiod accounting for the invoice line.

MultiperiodAccountingAccrualAccount String False

Account used for accruals in multiperiod accounting.

CreatedBy String True

User who created the invoice line.

CreationDate Datetime True

Date when the invoice line was created.

LastUpdateDate Datetime True

Date when the invoice line was last updated.

LastUpdatedBy String True

User who last updated the invoice line.

LastUpdateLogin String True

Login session associated with the user who last updated the invoice line.

RequesterId Long False

Unique identifier for the requester of the goods or services.

PrepaymentNumber String True

Prepayment number linked to the invoice line.

PrepaymentLineNumber Int True

Prepayment line number associated with the invoice line.

PrepaymentIncludedonInvoiceFlag Bool True

Indicates whether the prepayment is included on the invoice.

ReferenceKeyTwo String True

Secondary reference key used to uniquely identify the invoice line.

ProductTable String True

Product table associated with the invoice line.

invoiceLineGdf String False

Global descriptive flexfield for additional attributes related to the invoice line.

invoiceLineProjectDff String False

Project descriptive flexfield used for managing project-specific invoice line data.

invoiceDistributions String False

Used for managing distribution details of the invoice line.

invoiceLineDff String False

Descriptive flexfield for user-defined attributes related to the invoice line.

Finder String True

Search term or identifier used to locate and retrieve specific invoice line records.

InvoiceId Long True

Unique identifier for the invoice related to the line item.

CUReferenceNumber Int False

Reference number linking the child aggregates to parent tables.

EffectiveDate Date True

Date parameter used to fetch resources that are effective as of the specified start date.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454