InvoicesinvoiceLines
InvoicesinvoiceLines
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 | Double | 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 | Double | 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 | Double | 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 | Double | 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 | Double | 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 | BudgetDate of InvoicesinvoiceLines |
| 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 | Double | The user-enterable value to ensure that the calculated tax will be the same as on the physical document. |
| AssessableValue | Double | 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 | Double | The purchase order line number that is matched to the invoice line. |
| PurchaseOrderScheduleLineNumber | Double | 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 | Double | 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 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| InvoiceId | Long | InvoiceId |
| Finder | String | finder |