Excel Add-In for Oracle Fusion Cloud Financials

Build 26.0.9770

PurchasingLineTypes

Returns the purchasing line types that classify how goods and services are ordered, along with their default matching, categorization, and unit of measure settings.

Columns

Name Type SupportedFinders Description
LineTypeId [KEY] Long PrimaryKey, PrimaryKeyRowFinder Value that uniquely identifies the purchasing line type.
LineType String Name that uniquely identifies the purchasing line type.
LineTypeCode String Abbreviation that identifies the purchasing line type.
LineTypeDescription String Description of the purchasing line type.
CreditLineFlag Bool Contains one of the following values: true or false. If true, the credit line type is enabled for this line type. If false, the credit line type isn't enabled for this line type.
ProductTypeCode String Abbreviation that identifies the product type.
ProductType String Name of the product type.
PurchaseBasisCode String Abbreviation that identifies the purchase basis lookup type.
PurchaseBasis String Name of the purchase basis lookup type.
EndDate Date Date after which the line type is no longer valid.
DefaultMatchApprovalLevelCode String Abbreviation that identifies the match approval level.
DefaultMatchApprovalLevel String Name of the default match approval level.
DefaultInvoiceMatchOptionCode String Abbreviation that identifies the default invoice match option.
DefaultInvoiceMatchOption String Name of the default invoice match option.
DefaultReceiptCloseTolerancePercent Decimal Default value for the permissible variance between the anticipated amount of goods or services and the actual amount delivered.
DefaultCategoryId Long Value that uniquely identifies the default category.
DefaultCategory String Name of the default category.
DefaultUOMCode String Abbreviation that identifies the default unit of measure.
DefaultUOM String Name of the default unit of measure.
CreatedBy String User who created the line type.
CreationDate Datetime Date and time when the purchasing line type was created.
LastUpdateDate Datetime Date and time when the user most recently updated the line type.
LastUpdatedBy String User who most recently updated the line type.
Finder String A named finder reference used to filter or locate specific purchasing line types when querying.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770