JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

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.

Columns

Name Type Description
InvoicesInvoiceId [KEY] Long InvoicesInvoiceId of InvoicesinvoiceLines
LineNumber [KEY] Int 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.
LineAmount Decimal The line amount in invoice currency. The value must be provided while creating an invoice line.
AccountingDate Date 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 The unit of measure for the quantity invoiced.
TaxRateName String TaxRateName of InvoicesinvoiceLines
LineType String 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 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 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 BaseAmount of InvoicesinvoiceLines
Description String 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 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 The inventory item name.
ItemDescription String ItemDescription of InvoicesinvoiceLines
LineSource String LineSource of InvoicesinvoiceLines
Quantity Decimal The quantity of items invoiced include matched invoice lines, price corrections, quantity corrections, and unmatched invoice lines.
DistributionCombination String 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 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 The price charged per unit of a good or service.
ProrateAcrossAllItemsFlag Bool 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 Indicates if the invoice line is enabled for landed cost.
DiscardedFlag Bool DiscardedFlag of InvoicesinvoiceLines
CanceledFlag Bool CanceledFlag of InvoicesinvoiceLines
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 line or populated by default from the Federal Income Tax Type from the Income Tax tab from Supplier Profile.
TaxRateCode String TaxRateCode of InvoicesinvoiceLines
TaxRate Decimal TaxRate of InvoicesinvoiceLines
TaxClassification String 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 GenerateDistributions of InvoicesinvoiceLines
BudgetDate Date Budgetary Calendar Period Date applicable for funds check.
FundsStatus String FundsStatus of InvoicesinvoiceLines
ApprovalStatus String ApprovalStatus of InvoicesinvoiceLines
DistributionSet String 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 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 The user-entered ship to location code that helps to uniquely identify a ship to location.
ShipToLocation String The location where the goods and services have been shipped to by the supplier.
ShipToCustomerLocation String ShipToCustomerLocation of InvoicesinvoiceLines
TaxControlAmount Decimal The user-enterable value to ensure that the calculated tax will be the same as on the physical document.
AssessableValue Decimal The deemed price at which a product is valued, by a tax authority, for tax calculation purposes.
ProductType String 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 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 The user-entered product category code path that helps to uniquely identify a product category.
UserDefinedFiscalClassification String 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 The user-entered user defined fiscal classification code that helps to uniquely identify an user defined fiscal classification.
IntendedUse String 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 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 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 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 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 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 The user-entered transaction business category code path that helps to uniquely identify a transaction business category.
Requester String 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 PurchasingCategory of InvoicesinvoiceLines
MatchType String MatchType of InvoicesinvoiceLines
MatchOption String MatchOption of InvoicesinvoiceLines
MatchBasis String MatchBasis of InvoicesinvoiceLines
PurchaseOrderNumber String The purchase order document number that is matched to the invoice line.
PurchaseOrderLineNumber Decimal The purchase order line number that is matched to the invoice line.
PurchaseOrderScheduleLineNumber Decimal The purchase order schedule line number that is matched to the invoice line.
ReceiptNumber String The number of the receipt of material associated with the invoice line.
ReceiptLineNumber Long The line number of the receipt number associated with the invoice line.
ConsumptionAdviceNumber String The number of the consignment advice associated with the invoice line.
ConsumptionAdviceLineNumber Decimal The line number of the consignment advice associated with the invoice line.
FinalMatchFlag Bool 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 The multiperiod accounting start date on the invoice line.
MultiperiodAccountingEndDate Date The multiperiod accounting end date on the invoice line.
MultiperiodAccountingAccrualAccount String The accrual account used in multiperiod accounting to accrue deferred expenses.
CreatedBy String CreatedBy of InvoicesinvoiceLines
CreationDate Datetime CreationDate of InvoicesinvoiceLines
LastUpdateDate Datetime LastUpdateDate of InvoicesinvoiceLines
LastUpdatedBy String LastUpdatedBy of InvoicesinvoiceLines
LastUpdateLogin String LastUpdateLogin of InvoicesinvoiceLines
RequesterId Long The unique requester identifier.
PrepaymentNumber String PrepaymentNumber of InvoicesinvoiceLines
PrepaymentLineNumber Int PrepaymentLineNumber of InvoicesinvoiceLines
PrepaymentIncludedonInvoiceFlag Bool PrepaymentIncludedonInvoiceFlag of InvoicesinvoiceLines
ReferenceKeyTwo String ReferenceKeyTwo of InvoicesinvoiceLines
ProductTable String ProductTable of InvoicesinvoiceLines
Finder String Finder of InvoicesinvoiceLines
InvoiceId Long InvoiceId of InvoicesinvoiceLines

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