JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

PurchasingLineTypesLOV

Lists purchasing line types with which purchasing documents can be created. Line type is an important part of purchasing documents as it enables differentiating orders for goods from those of services.

Columns

Name Type Description
LineTypeId [KEY] Long Value that uniquely identifies whether the line type line references an item or a service.
LineTypeCode String Abbreviation that identifies the purchasing line type.
LineType String Type that indicates whether the line type references an item or a service.
Description String Description of the purchasing line type.
CreditFlag Bool Contains one of the following values: true or false. If true, then the credit line type is enabled for this document style. If false, then the credit line type isn't enabled for this document style. This attribute doesn't have a default value.
ProductTypeCode String Abbreviation that identifies the product type associated with the line type.
ProductType String Product type associated with the purchasing line type.
PurchaseBasisCode String Abbreviation that identifies the purchase basis type associated with the line type.
PurchaseBasis String Purchase basis of the line type.
EndDate Date Date after which the line type is no longer valid.
DefaultMatchApprovalLevelCode String Abbreviation that identifies the default match approval level associated with the purchasing line type.
DefaultMatchApprovalLevel String Default match approval level associated with the purchasing line type.
DefaultInvoiceMatchOptionCode String Abbreviation that identifies the default invoice match option associated with the purchasing line type.
DefaultInvoiceMatchOption String Default invoice match option associated with the purchasing line type.
DefaultReceiptCloseTolerancePercent Decimal Default receipt close tolerance percentage associated with the purchasing line type.
DefaultCategoryId Long Value that uniquely identifies the default purchasing category associated with the purchasing line type.
DefaultCategoryCode String Abbreviation for the default purchasing category associated with the purchasing line type.
DefaultCategory String Default purchasing category associated with the purchasing line type.
DefaultUOMCode String Abbreviation that identifies that default unit of measure associated with the purchasing line type.
DefaultUOM String Default unit of measure associated with the purchasing line type.
DocumentType String A finder used to filter data using Finder column. Finds purchasing line types according to the document type.
Finder String Finder criteria used to filter purchasing line types list of values based on specific search parameters and conditions.
StyleId Long A finder used to filter data using Finder column. Finds purchasing line types according to the document style identifier.

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