InvoicesinvoiceLines

The payables invoice lines resource is used to manage details about goods and services, which includes freight, and miscellaneous charges that can be allocated to item lines. It also captures details necessary for integration with applications, such as Oracle Fusion Assets.

Table Specific Information

Select

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

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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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 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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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	InvoicesInvoiceId of InvoicesinvoiceLines
InvoicesUniqId [KEY]	String	True	Use this column's value for insert, update and delete operations, wherever applicable, instead of invoicesInvoiceId.
LineNumber [KEY]	Int	False	The unique number for the invoice line. The value must be provided while creating an invoice line. It cannot be updated once the invoice line is created.
LineNumberUniqId [KEY]	String	True	Use this column's value in insert, update and delete operations, wherever applicable, instead of LineNumber
LineAmount	Decimal	False	The line amount in invoice currency. The value must be provided while creating an invoice line.
AccountingDate	Date	False	The accounting date for invoice line. It is used to populate by default to invoice distributions. The value can either be provided while creating an invoice installment or populated by default from the invoice header.
UOM	String	False	The unit of measure for the quantity invoiced.
TaxRateName	String	True	TaxRateName of InvoicesinvoiceLines
LineType	String	False	The type of invoice line. The value must be provided while creating an invoice line. The valid values are Item, Freight and Miscellaneous. A list of accepted values is defined in the lookup type INVOICE LINE TYPE and can be reviewed using the Setup and Maintenance work area, and the Manage Payables Lookups task.
AssetBook	String	False	The asset book associated with the row. The value is populated by default to the distributions candidate for transfer to Oracle Fusion Assets.
TrackAsAssetFlag	Bool	False	Indicates if the item should be transferred to Oracle Fusion Assets. The value can either be provided while creating an invoice line or populated by default to true if an asset account is provided in the distribution combination. If the value if true, then it indicates the item should be transferred to Oracle Fusion Assets.
BaseAmount	Decimal	True	BaseAmount of InvoicesinvoiceLines
Description	String	False	The description of the invoice line. The value can either be provided while creating an invoice line or populated by default from the invoice header.
IncomeTaxRegion	String	False	The reporting region for the invoice line for the 1099 supplier. The value can either be provided while creating an invoice line or populated by default to the State code from the address associated with supplier site.
Item	String	False	The inventory item name.
ItemDescription	String	True	ItemDescription of InvoicesinvoiceLines
LineSource	String	True	LineSource of InvoicesinvoiceLines
Quantity	Decimal	False	The quantity of items invoiced include matched invoice lines, price corrections, quantity corrections, and unmatched invoice lines.
DistributionCombination	String	False	The accounting flexfield to be used for automatic generation of a single distribution. The value can be provided while creating an invoice line. In case of Prepayment invoice or charge lines the value is populated by default from the Supplier Site Assignment or from Manage Common Options for Payables and Procurement options for the invoicing business unit.
AssetCategory	String	False	The asset category under which this asset line will be grouped. The value is populated by default to the invoice distributions for transferring to Oracle Fusion Assets.
UnitPrice	Decimal	False	The price charged per unit of a good or service.
ProrateAcrossAllItemsFlag	Bool	False	Indicates that the Freight or Miscellaneous type line should be prorated across all existing Item type lines. The default value is false. If the value if true, then it indicates the charge line should be prorated across all item type lines.
LandedCostEnabled	String	False	Indicates if the invoice line is enabled for landed cost.
DiscardedFlag	Bool	True	DiscardedFlag of InvoicesinvoiceLines
CanceledFlag	Bool	True	CanceledFlag of InvoicesinvoiceLines
IncomeTaxType	String	False	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 line or populated by default from the Federal Income Tax Type from the Income Tax tab from Supplier Profile.
TaxRateCode	String	True	TaxRateCode of InvoicesinvoiceLines
TaxRate	Decimal	True	TaxRate of InvoicesinvoiceLines
TaxClassification	String	False	The tax classification code used for tax calculation. The value can either be provided while creating an invoice line or populated by default from the Tax Classification Code from the Transaction Tax tab in the Supplier Profile or Address or as per the Tax setups.
GenerateDistributions	String	True	GenerateDistributions of InvoicesinvoiceLines
BudgetDate	Date	False	Budgetary Calendar Period Date applicable for funds check.
FundsStatus	String	True	FundsStatus of InvoicesinvoiceLines
ApprovalStatus	String	True	ApprovalStatus of InvoicesinvoiceLines
DistributionSet	String	False	The distribution set name used in the generation of distributions for a line. The value can either be provided while creating an invoice line or populated by default from the Distribution Set from the Site Assignments in the Supplier Site.
Withholding	String	False	The withholding tax group name. The value can either be provided while creating an invoice line or populated by default from the Withholding from Site Assignments in the Supplier Site or Address or Profile level.
ShipToLocationCode	String	False	The user-entered ship to location code that helps to uniquely identify a ship to location.
ShipToLocation	String	False	The location where the goods and services have been shipped to by the supplier.
ShipToCustomerLocation	String	True	ShipToCustomerLocation of InvoicesinvoiceLines
TaxControlAmount	Decimal	False	The user-enterable value to ensure that the calculated tax will be the same as on the physical document.
AssessableValue	Decimal	False	The deemed price at which a product is valued, by a tax authority, for tax calculation purposes.
ProductType	String	False	The type of product that defaults from the inventory item attributes. Possible values are Goods or Services. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup.
ProductCategory	String	False	Identifies the taxable nature of a non-Inventory based item to determine tax or tax reporting purposes. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup.
ProductCategoryCodePath	String	False	The user-entered product category code path that helps to uniquely identify a product category.
UserDefinedFiscalClassification	String	False	A classification for any tax requirement that you cannot define using the existing fiscal classification types. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup.
UserDefinedFiscalClassificationCode	String	False	The user-entered user defined fiscal classification code that helps to uniquely identify an user defined fiscal classification.
IntendedUse	String	False	A tax driver used to determine and calculate the applicable taxes for the line. 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	False	The user-entered intended use code that helps to uniquely identify an intended use. When passing the attribute value in the payload, ensure that you are passing a value for intended use attribute as well.
ProductFiscalClassification	String	False	A tax classification used by a tax authority to categorize a product. 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 values for product fiscal classification code, product fiscal classification type attributes as well.
ProductFiscalClassificationCode	String	False	The user-entered product fiscal classification code that helps to uniquely identify a product fiscal classification. When passing the attribute value in the payload, ensure that you are passing values for product fiscal classification, product fiscal classification type attributes as well.
ProductFiscalClassificationType	String	False	The user-entered product fiscal classification type that helps to uniquely identify a product fiscal classification. When passing the attribute value in the payload, ensure that you are passing values for product fiscal classification, product fiscal classification code attributes as well.
TransactionBusinessCategory	String	False	The transaction category assigned to the invoice line. Used to identify and classify business transactions for the purpose of tax calculation. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup.
TransactionBusinessCategoryCodePath	String	False	The user-entered transaction business category code path that helps to uniquely identify a transaction business category.
Requester	String	False	The name of the person who requested the goods or services. The requester is used by the Invoice Approval Workflow process to generate the list of approvers.
PurchasingCategory	String	True	PurchasingCategory of InvoicesinvoiceLines
MatchType	String	True	MatchType of InvoicesinvoiceLines
MatchOption	String	True	MatchOption of InvoicesinvoiceLines
MatchBasis	String	True	MatchBasis of InvoicesinvoiceLines
PurchaseOrderNumber	String	False	The purchase order document number that is matched to the invoice line.
PurchaseOrderLineNumber	Decimal	False	The purchase order line number that is matched to the invoice line.
PurchaseOrderScheduleLineNumber	Decimal	False	The purchase order schedule line number that is matched to the invoice line.
ReceiptNumber	String	False	The number of the receipt of material associated with the invoice line.
ReceiptLineNumber	Long	False	The line number of the receipt number associated with the invoice line.
ConsumptionAdviceNumber	String	False	The number of the consignment advice associated with the invoice line.
ConsumptionAdviceLineNumber	Decimal	False	The line number of the consignment advice associated with the invoice line.
FinalMatchFlag	Bool	False	Indicates if an invoice is the last one being matched to a purchase order, making the purchase order schedule no longer available for matching to other invoices. A value of Y indicates the purchase order schedule is finally closed and can no longer match invoices to it.
MultiperiodAccountingStartDate	Date	False	The multiperiod accounting start date on the invoice line.
MultiperiodAccountingEndDate	Date	False	The multiperiod accounting end date on the invoice line.
MultiperiodAccountingAccrualAccount	String	False	The accrual account used in multiperiod accounting to accrue deferred expenses.
CreatedBy	String	True	CreatedBy of InvoicesinvoiceLines
CreationDate	Datetime	True	CreationDate of InvoicesinvoiceLines
LastUpdateDate	Datetime	True	LastUpdateDate of InvoicesinvoiceLines
LastUpdatedBy	String	True	LastUpdatedBy of InvoicesinvoiceLines
LastUpdateLogin	String	True	LastUpdateLogin of InvoicesinvoiceLines
RequesterId	Long	False	The unique requester identifier.
PrepaymentNumber	String	True	PrepaymentNumber of InvoicesinvoiceLines
PrepaymentLineNumber	Int	True	PrepaymentLineNumber of InvoicesinvoiceLines
PrepaymentIncludedonInvoiceFlag	Bool	True	PrepaymentIncludedonInvoiceFlag of InvoicesinvoiceLines
ReferenceKeyTwo	String	True	ReferenceKeyTwo of InvoicesinvoiceLines
ProductTable	String	True	ProductTable of InvoicesinvoiceLines
invoiceLineGdf	String	False	This column can only be used for Insert. For update and delete, use child table's operations, if applicable.
invoiceLineProjectDff	String	False	This column can only be used for Insert. For update and delete, use child table's operations, if applicable.
invoiceDistributions	String	False	This column can only be used for Insert. For update and delete, use child table's operations, if applicable.
invoiceLineDff	String	False	This column can only be used for Insert. For update and delete, use child table's operations, if applicable.
Finder	String	True	finder
InvoiceId	Long	True	invoiceid
CUReferenceNumber	Int	False	Maps the child aggregates with Parent tables.
EffectiveDate	Date	True	This query parameter is used to fetch resources which are effective dated as of the specified start date.

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

Build 24.0.9111