RequisitionLine
The Requisition Lines view object stores information about requisition lines. It manages the items to be purchased, its quantity, unit of measure, price, and deliver-to location information.
Label, Plural Label
Requisition Line, Requisition Lines
Qualified Label, Qualified Plural Label
Purchase Requisition Line, Purchase Requisition Lines
Module
oraProcurementCorePurchaseRequisitions
Keys
-
$primary: requisitionLineId (default)
-
altKey: lineNumber, requisitionHeaderId
Fields
* Field can't be null- actionRequiredCode (enumeration: ActionRequired)
Value that identifies the action required of the user to remove the invoice hold on the line's corresponding invoice.
Label
Action Required Code
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: ActionRequired
Valid Values
- ORA_CREATE_PO_CHANGE_ORDER
- ORA_CREATE_RECEIPT
-
- altSupplierContactEmails (string)
Email addresses of additional supplier contacts. These email addresses are used to send purchase orders to supplier contacts involved in the procurement process.
Label
Alternate Supplier Contact Emails
- amount (big-decimal)
Total amount of the requested items in the currency of the buying company.
Label
Amount
- assessableValue (big-decimal)
Value that's assessable.
Label
Assessable Value
- atSourcingFlag (boolean)
Contains one of the following values: Y, N, or NULL. If Y, then the requisition line is part of an active negotiation in Oracle Sourcing. If N or NULL, then the requisition line isn't part of an active negotiation in Oracle Sourcing.
Label
On a Negotiation
- backToBackFlag (boolean)
Contains one of the following values: true or false. If true, then the purchase requisition line is intended to fulfill a specific customer sales order upon receipt. If false, then the purchase requisition line doesn't have a backing sales order. This attribute doesn't have a default value.
Label
Back-to-Back Order
- baseModelPrice (big-decimal)
Unit price of the base model only.
Label
Base Model Price
- bpaDescriptionUserOverrideFlag (boolean)
Indicates whether the item description from the blanket purchase requisition line has been updated by the user.
Label
Blanket Purchase Agreement Description User Override Flag
- bpaPriceUserOverrideFlag (boolean)
Indicates whether the blanket purchase agreement price attribute has been updated by user.
Label
Blanket Purchase Agreement Price User Override Flag
- buyerProcessingFlag (boolean)
Indicates whether the buyer is currently working on the requisition line or not.
Label
Buyer Processing Flag
- cancelDate (date)
Date when the requested items were canceled.
Label
Cancellation Date
- cancelFlag (boolean)
Indicates whether the requisition line is canceled or not.
Label
Cancel Flag
- cancelReason (string)
Reason for canceling the requested items.
Label
Cancellation Reason
- configuredItemFlag (boolean)
Contains one of the following values: true or false. If true, then the requisition line is for a configured item and configuration details might exist. If false, then the requisition line isn't for a configured item. This attribute doesn't have a default value.
Label
Configured Item Flag
- createdBy (string)*
The user who created the record.
Label
Created By
Properties
- not nullable
- currencyAmount (big-decimal)
Amount of the requested service in the transactional currency.
Label
Amount
- currencyConversionDate (date)
Date of the currency conversion rate.
Label
Conversion Date
- currencyConversionRate (big-decimal)
Rate of the currency conversion.
Label
Conversion Rate
- currencyUnitPrice (big-decimal)
Price of the requested item in the transactional currency.
Label
Price
- daysEarlyReceiptAllowed (big-decimal)
Maximum acceptable number of days allowed for early receipts.
Label
Days Early Receipt Allowed
- daysLateReceiptAllowed (big-decimal)
Maximum acceptable number of days allowed for late receipts.
Label
Days Late Receipt Allowed
- destinationTypeCode (enumeration: DestinationType)
Code that identifies whether the item is for inventory, expense, drop ship, or manufacturing. Valid values include INVENTORY, EXPENSE, DROP SHIP, and MANUFACTURING.
Label
Destination Type
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: DestinationType
Properties
- searchable
Valid Values
- DROP_SHIP
- EXPENSE
- INVENTORY
- MANUFACTURING
-
- disableAutosourcingFlag (boolean)
Indicates whether a source should be automatically determined for a requisition line.
Label
Disable Automatic Sourcing Flag
- externalCategory (string)
Category retrieved from punchout cart in case of a punchout line.
Label
External Category
- externalUOM (string)
UOM retrieved from punchout cart in case of a punchout line.
Label
External UOM
- externalUOMQuantity (string)
UOM associated quantity retrieved from punchout cart in case of a punchout line.
Label
Purchase Agreement Line
- firmFlag (boolean)
Indicates whether planning can reschedule or cancel the purchase order schedule.
Label
Firm Flag
- fundsStatus (enumeration: RequisitionFundStatus)
Status of the funds reservation request.
Label
Funds Status
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: RequisitionFundStatus
Valid Values
- LIQUIDATED
- NOT_APPLICABLE
- NOT_RESERVED
- NOT_RESERVED_FAILED
- NOT_RESERVED_PASSED
- NOT_RESERVED_WARNING
- PARTIALLY_LIQUIDATED
- RESERVED
- RESERVED_PARTIAL
-
- infoTemplateTouchedFlag (boolean)
Indicates whether the user has opened an information template or not.
Label
Information Template Viewed by User Flag
- interfaceLineKey (string)
Value that identifies the row in the requisition lines interface table.
Label
Interface Line Key
- itemDescription (string)*
Description of the goods or services being purchased.
Label
Line Description
Properties
- not nullable
- itemRevision (string)
Number that identifies the revision of the item.
Label
Item Revision
- itemSource (string)
Source of the item. It indicates whether item comes from catalog, noncatalog, quick create, punchout, requisition import or service.
Label
Item Source
- itemUserOverrideFlag (boolean)
Indicates whether item attributes have been updated by the user.
Label
Item User Override Flag
- lastApprovalDate (date-time)
Date when the requisition lines was last approved.
Label
Last Approval Date
- lastSubmittedDate (date-time)
Date when the requisition line was last submitted for approval.
Label
Last Submitted Date
- lifeCycleSecondaryStatus (string)
Code that indicates the secondary status of a requisition line, providing additional information about its lifecycle.
Label
Lifecycle Secondary Status
- lifeCycleStatus (enumeration: LifeCycleStatus)
Value that identifies the lifecycle status code of the requisition line.
Label
Lifecycle Status
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: LifeCycleStatus
Valid Values
- BILLED
- BILLED_ORDER_ON_HOLD
- DELIVERED
- DELIVERED_ORDER_ON_HOLD
- IN_RECEIVING
- IN_RECEIVING_ORDER_ON_HOLD
- ORDERED
- ORDER_CANCELED
- ORDER_CANCELED_REINSTATED
- ORDER_ON_HOLD
For a complete list of valid values, see the LifeCycleStatus enumeration type.
-
- lineGroup (enumeration: LineGroup)
Group that indicates which group filter a requisition line belongs to.
Label
Line Group
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: LineGroup
Valid Values
- LINES_AWAITING_PROCESSING
- LINES_BEING_PROCESSED
- LINES_PENDING_APPROVAL
- LINES_REQUIRING_ATTENTION
- NEGOTIATION
- OTHER_REQUISITION_LINES
- PO
- TRANSFER_ORDER
-
- lineNumber (int64)*
Number that uniquely identifies the requisition line.
Label
Requisition Line
Properties
- not nullable
- lineStatus (enumeration: LineStatus)
Status of the requisition line.
Label
Status
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: LineStatus
Valid Values
- APPROVED
- CANCELED
- INCOMPLETE
- ON_HOLD
- PENDING APPROVAL
- REJECTED
- REPLACED
- RETURNED
- SPLIT
- WITHDRAWN
-
- manufacturer (string)
Name of the company that manufactures the item being purchased.
Label
Manufacturer
- manufacturerPartNumber (string)
Number that uniquely identifies the item as provided by the manufacturer.
Label
Manufacturer Part Number
- matchingBasis (enumeration: MatchingBasis)*
Basis of matching of the line type.
Label
Line Type Matching Basis
Type
-
Module: oraProcurementCorePurchasingSetup
-
Enumeration Type: MatchingBasis
Properties
- not nullable
Valid Values
- AMOUNT
- QUANTITY
-
- modeOfTransportCode (enumeration: ModeOfTransportCode)
Mode of transportation used to ship the product such as truck, air, or boat.
Label
Mode of Transport
Type
-
Module: oraScmCoreCarrier
-
Enumeration Type: ModeOfTransportCode
Valid Values
- AIR
- LTL
- OCEAN
- PARCEL
- RAIL
- TRUCK
-
- modifiedByBuyerFlag (boolean)
Indicates whether the line has been modified by the buyer.
Label
Modified by Buyer Flag
- needByDate (date)
Date when the buyer requests that the supplier deliver the item.
Label
Requested Date
- negotiatedByPreparerFlag (boolean)
Contains one of the following values: true or false. If true, then the price on the purchase requisition line is agreed on in advance between the buying company and the supplier. If false, then the price isn't agreed on in advance. This attribute doesn't have a default value.
Label
Negotiated
- negotiationRequiredFlag (boolean)
Contains one of the following values: true or false. If true, then an request for quotation is required prior to placing the requisition line on a purchase order. If false, then an request for quotation isn't required. This attribute doesn't have a default value.
Label
Negotiation Required
- newSupplierFlag (boolean)
Contains one of the following values: true or false. If true, then the supplier entered on the line is a new supplier. If false, then the supplier entered on the line is an existing supplier. This attribute doesn't have a default value.
Label
New supplier
- noteToBuyer (string)
Note to the buyer on the purchase requisition.
Label
Note to Buyer
- noteToReceiver (string)
Note to the receiver on the purchase requisition.
Label
Note to Receiver
- noteToSupplier (string)
Note to the supplier on the purchase requisition.
Label
Note to Supplier
- onRFQFlag (boolean)
Indicates whether the requisition line was placed on an RFQ.
Label
On an RFQ Flag
- oneTimeLocationFlag (boolean)
Contains one of the following values: true or false. If true, then the location on final delivery of goods is a one time delivery address. If false, then the location of delivery is an existing address in Oracle Global Human Resources Cloud. The default value is false.
Label
Deliver-to Location Type
- optionsPrice (big-decimal)
Price that indicates the sum of the extended price of all options chosen per unit of the purchased configuration.
Label
Total Options Price
- orchestrationCode (string)
Code for integrating applications to determine the transactions within Procurement that they need to track. For example, SCO and DOO.
Label
Orchestration Code
- originalApprovalDate (date-time)
Date when the requisition line was first approved.
Label
Original Approval Date
- originalSubmittedDate (date-time)
Date when the requisition line was first submitted for approval.
Label
Original Submitted Date
- priceVarianceExceededAmount (big-decimal)
Price variance amount of the requisition line if the punchout item exceeds the price variance check.
Label
Price Variance Exceeded Amount
- priceVarianceExceededFlag (boolean)*
Indicate whether the punchout requisition line exceeded the price variance check as per the tolerance on the punchout catalog.
Label
Price Variance Exceeded Amount
Properties
- not nullable
- procurementCardFlag (boolean)
Indicate whether the line was ordered using a procurement card.
Label
Procurement Card Flag
- purchaseBasis (enumeration: PurchaseBasis)*
Purchase basis of the line type.
Label
Line Type Value Basis
Type
-
Module: oraProcurementCorePurchasingSetup
-
Enumeration Type: PurchaseBasis
Properties
- not nullable
Valid Values
- GOODS
- SERVICES
-
- quantity (big-decimal)
Quantity of the goods being purchased.
Label
Quantity
- quantityCancelled (big-decimal)
Quantity that was canceled.
Label
Canceled Quantity
- quantityDelivered (big-decimal)
Quantity delivered against the purchase order schedule.
Label
Delivered Quantity
- quantityReceived (big-decimal)
Quantity received against the purchase order schedule.
Label
Received Quantity
- quantityReceivedTolerance (big-decimal)
Percentage of the quantity that can be received in excess of the designated order quantity.
Label
Quantity Received Tolerance
- quantityUnderRecieveTolerance (big-decimal)
Value that indicates the percentage that the application uses to determine whether to automatically close a purchase order schedule when the receiver receives only part of the item.
Label
Under Receipt Quantity Tolerance
- repriceFlag (boolean)
Indicate whether the transfer supply request can be repriced by calling Supply Chain Financial Orchestration.
Label
Reprice Flag
- requestedShipDate (date)
Date when the buying company requested the ordered item to be shipped.
Label
Requested Ship Date
- requisitionDistributions (object-collection)*
The Requisition Distributions view object stores information about the accounting and project data for each distribution associated with each requisition line.
Label
Requisition Distributions
Cardinality Target Object One to many - Module: oraProcurementCorePurchaseRequisitions
- Business Object: RequisitionDistribution
Additional Mapping Details
Mapped by relationship: requisitionLine
Field in Current Object Field in Target Object requisitionLineId requisitionLineId - requisitionHeaderId (int64)*
Value that uniquely identifies the requisition.
Label
Requisition Header ID
Properties
- searchable
- not nullable
- requisitionLineId (int64)*
Value that uniquely identifies the requisition line.
Label
Requisition Line ID
Properties
- searchable
- sortable
- not nullable
- returnReason (string)
Reason for returning one or more requested items.
Label
Return Reason
- salesOrderLineNumber (string)
Number that uniquely identifies the sales order line for a given customer sales order.
Label
Sales Order Line Number
- salesOrderNumber (string)
Number that uniquely identifies the backing sales order
Label
Customer Sales Order
- salesOrderScheduleNumber (string)
Number that uniquely identifies the sales order schedule for a given customer sales order line.
Label
Sales Order Schedule Number
- secondaryQuantity (big-decimal)
Quantity in terms of the secondary unit of measure for a dual unit of measure controlled item.
Label
Secondary Quantity
- secondaryQuantityCancelled (big-decimal)
Canceled quantity in the secondary unit of measure.
Label
Secondary Quantity Canceled
- secondaryQuantityReceived (big-decimal)
Total quantity of an ordered item, in the secondary unit of measure, that has been received so far.
Label
Secondary Quantity Received
- serviceLevelCode (enumeration: ServiceLevelCode)
Transportation priority that determines how quickly to transport goods.
Label
Service Level
Type
-
Module: oraScmCoreCarrier
-
Enumeration Type: ServiceLevelCode
Valid Values
- 1DA
- 1DM
- 1DP
- 2DA
- 2DAY
- 2DM
- 2FX
- 3DAY
- 3DS
- AIR
For a complete list of valid values, see the ServiceLevelCode enumeration type.
-
- sourceDocumentTypeCode (enumeration: AgreementType)
Type of the suggested source document.
Label
Agreement Type
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: AgreementType
Properties
- searchable
Valid Values
- BLANKET
- CONTRACT
-
- sourceTypeCode (enumeration: SourceType)*
Code that identifies the type of supply source for the requisition line. Values include the following values: Internal or External. If Internal, it means the line is sourced from an inventory organization. If External, it means the line is sourced for supplier.
Label
Source Type
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: SourceType
Properties
- not nullable
Valid Values
- EXTERNAL
- INTERNAL
-
- suggestedSupplier (string)
Name of the suggested supplier.
Label
Suggested Supplier
- suggestedSupplierContact (string)
Name of the suggested supplier contact.
Label
Supplier Contact
- suggestedSupplierContactEmail (email)
Email of the suggested supplier contact.
Label
Email
- suggestedSupplierContactFax (string)
Fax number of the suggested supplier contact.
Label
Fax
- suggestedSupplierContactPhone (string)
Phone number of the suggested supplier contact.
Label
Phone
- suggestedSupplierItemNumber (string)
Number of the suggested supplier product.
Label
Supplier Item
- suggestedSupplierSite (string)
Site of the suggested supplier.
Label
Supplier Site
- supplierDUNS (string)
Data Universal Numbering System code of the suggested supplier.
Label
Supplier D-U-N-S
- supplierReferenceNumber (string)
Reference Number for the Supplier.
Label
Supplier Configuration ID
- taxAttributeUserOverrideFlag (boolean)
Indicates whether the tax attributes were overridden by the user.
Label
Tax Attribute User Override Flag
- timeCreated (date-time)*
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeUpdated (date-time)*
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- unitPrice (big-decimal)
Price of the requested item in the currency of the buying company.
Label
Price
- unspscCode (string)
Code that identifies the United Nations Standard Products and Services Code for taxonomy of products and services.
Label
UNSPSC
- updatedBy (string)*
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- urgentFlag (boolean)
Contains one of the following values: true or false. If true, then the requisition line requires urgent processing. If false, then the line doesn't require urgent processing. This attribute doesn't have a default value.
Label
Urgent
- workOrderNumber (string)
Number of the contract manufacturing work order.
Label
Work Order
- workOrderOperationSequence (big-decimal)
Value that indicates the execution sequence of the work order operation.
Label
Operation Sequence
- workOrderProduct (string)
Value that identifies the finished goods of the contract manufacturing work order.
Label
Product
- workOrderSubType (string)
Display name that identifies the subtype of the manufacturing work order.
Label
Work Order Subtype
Reference Objects
- agreementHeader (object)
Purchase agreement associated with the requisition line.
Label
Purchase Agreement Header
Cardinality Target Object One to One - Module: oraProcurementCorePurchaseAgreements
- Business Object: Agreement
Additional Mapping Details
Field in Current Object Field in Target Object sourceDocumentHeaderId agreementHeaderId - agreementLine (object)
Agreement line associated with the requisition line.
Label
Purchase Agreement Line
Cardinality Target Object One to One - Module: oraProcurementCorePurchaseAgreements
- Business Object: AgreementLine
Additional Mapping Details
Field in Current Object Field in Target Object sourceDocumentLineId agreementLineId - assignedBuyer (object)
Buyer assigned to process the requisition line.
Label
Assigned Buyer
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object assignedBuyerId id - baseItem (object)
Base or ATO Model on which the unique configuration is built.
Label
Base Item
Cardinality Target Object One to One - Module: oraScmCoreProductMgmtItems
- Business Object: Item
Additional Mapping Details
Field in Current Object Field in Target Object baseModelId itemId destinationOrganizationId organizationId - carrier (object)
Carrier through which ordered goods are shipped.
Label
Carrier
Cardinality Target Object One to One - Module: oraCxSalesCommonParty
- Business Object: Party
Additional Mapping Details
Field in Current Object Field in Target Object carrierId id - category (object)
Object reference to the product category .
Label
Category
Cardinality Target Object One to One - Module: oraScmCoreProductMgmtCatalogs
- Business Object: Category
Additional Mapping Details
Field in Current Object Field in Target Object categoryId id - contentProcurementBU (object)
Business unit of the content.
Label
Content Procurement BU
Cardinality Target Object One to One - Module: oraErpCoreStructure
- Business Object: BusinessUnit
Additional Mapping Details
Field in Current Object Field in Target Object contentProcurementBUId id - currency (object)
Currency in which an amount or conversion rate is denominated.
Label
Currency
Cardinality Target Object One to One - Module: oraErpCoreCurrencySetup
- Business Object: Currency
Additional Mapping Details
Field in Current Object Field in Target Object currencyCode currencyCode - currencyConversionRateType (object)
Type of conversion rate used to convert from the transaction currency on the line to the functional currency of the requisitioning business unit.
Label
Currency Conversion Rate Type
Cardinality Target Object One to One - Module: oraErpCoreCurrencySetup
- Business Object: CurrencyConversionRateType
Additional Mapping Details
Field in Current Object Field in Target Object rateType conversionRateType - deliverToCustomer (object)
Object reference to the deliver-to customer on the requisition line.
Label
Deliver-to Customer
Cardinality Target Object One to One - Module: oraCxSalesCommonParty
- Business Object: Party
Additional Mapping Details
Field in Current Object Field in Target Object deliverToCustomerId id - deliverToCustomerContact (object)
Contact person at the final location where goods, previously received from a supplier, will be delivered.
Label
Deliver-to Customer Contact
Cardinality Target Object One to One - Module: oraCxSalesCommonParty
- Business Object: Party
Additional Mapping Details
Field in Current Object Field in Target Object deliverToCustomerContactId id - deliverToCustomerLocation (object)
Final location where goods, previously received from a supplier, will be delivered. For internal locations, this will be a TCA location. For Structured One-Time Addresses, this represents the delivery location.
Label
Deliver-to Customer Location
Cardinality Target Object One to One - Module: oraCxSalesCommonParty
- Business Object: Location
Additional Mapping Details
Field in Current Object Field in Target Object deliverToCustomerLocationId id - deliverToLocation (object)
Object reference to the deliver-to location on the requisition line.
Label
Deliver-to Location
Cardinality Target Object One to One - Module: oraHcmHrCoreWorkStructures
- Business Object: Location
Additional Mapping Details
Field in Current Object Field in Target Object deliverToLocationId id - destinationOrganization (object)
Inventory organization where the supplier should deliver the ordered item.
Label
Destination Organization
Cardinality Target Object One to One - Module: oraScmCoreOrganization
- Business Object: OrganizationConfiguration
Additional Mapping Details
Field in Current Object Field in Target Object destinationOrganizationId id - destinationSubinventory (object)
Subinventory that identifies where to deliver the requested item.
Label
Destination Subinventory
Cardinality Target Object One to One - Module: oraScmCoreInventorySetup
- Business Object: Subinventory
Additional Mapping Details
Field in Current Object Field in Target Object destinationOrganizationId organizationId destinationSubinventoryName name - documentFiscalClassification (object)
Document fiscal classification of the requisition line.
Label
Document Fiscal Classification
Cardinality Target Object One to One - Module: oraErpCoreTaxSetup
- Business Object: FiscalClassificationCodeHierarchy
Additional Mapping Details
Field in Current Object Field in Target Object documentSubType concatenatedClassificationCode - finalDischargeLocation (object)
Object reference to the final discharge location on the requisition line.
Label
Final Discharge Location
Cardinality Target One to One - Module: oraErpCoreTaxSetup
- Extraction View: LocationOfFinalDischargeList
Additional Mapping Details
Field in Current Object Field in Target finalDischargeLocationId locationId - firstPartyTaxRegistration (object)
First-party tax registration on the requisition line.
Label
First-Party Tax Registration
Cardinality Target Object One to One - Module: oraErpCoreTaxSetup
- Business Object: TaxRegistration
Additional Mapping Details
Field in Current Object Field in Target Object firstPartyRegistrationId id - hazardClass (object)
Hazard class on the line.
Label
Hazard Class
Cardinality Target Object One to One - Module: oraProcurementCorePurchasingSetup
- Business Object: HazardClass
Additional Mapping Details
Field in Current Object Field in Target Object hazardClassId hazardClassId - item (object)
Item associated with the requisition line.
Label
Item
Cardinality Target Object One to One - Module: oraScmCoreProductMgmtItems
- Business Object: Item
Additional Mapping Details
Field in Current Object Field in Target Object destinationOrganizationId organizationId itemId itemId - level10RequesterSupervisor (object)
Level 10 supervisor of the requester, with level 1 is the highest management level of the organization.
Label
Requester's Level 10 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level10RequesterSupervisorId id - level1RequesterSupervisor (object)
Level 1 supervisor of the requester, with level 1 being the highest management level in the organization.
Label
Requester's Level 1 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level1RequesterSupervisorId id - level2RequesterSupervisor (object)
Level 2 supervisor of the requester, with level 1 is the highest management level of the organization.
Label
Requester's Level 2 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level2RequesterSupervisorId id - level3RequesterSupervisor (object)
Level 3 supervisor of the requester, with level 1 is the highest management level of the organization.
Label
Requester's Level 3 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level3RequesterSupervisorId id - level4RequesterSupervisor (object)
Level 4 supervisor of the requester, with level 1 is the highest management level of the organization.
Label
Requester's Level 4 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level4RequesterSupervisorId id - level5RequesterSupervisor (object)
Level 5 supervisor of the requester, with level 1 is the highest management level of the organization.
Label
Requester's Level 5 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level5RequesterSupervisorId id - level6RequesterSupervisor (object)
Level 6 supervisor of the requester, with level 1 is the highest management level of the organization.
Label
Requester's Level 6 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level6RequesterSupervisorId id - level7RequesterSupervisor (object)
Level 7 supervisor of the requester, with level 1 is the highest management level of the organization.
Label
Requester's Level 7 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level7RequesterSupervisorId id - level8RequesterSupervisor (object)
Level 8 supervisor of the requester, with level 1 is the highest management level of the organization.
Label
Requester's Level 8 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level8RequesterSupervisorId id - level9RequesterSupervisor (object)
Level 9 supervisor of the requester, with level 1 is the highest management level of the organization.
Label
Requester's Level 9 Supervisor
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object level9RequesterSupervisorId id - lineIntendedUse (object)
Object reference to the intended use on the requisition line.
Label
Intended Use
Cardinality Target One to One - Module: oraErpCoreTaxSetup
- Extraction View: IntendedUseList
Additional Mapping Details
Field in Current Object Field in Target lineIntendedUseId categoryid - lineType (object)
Line type on the requisition line.
Label
Requisition Line Type
Cardinality Target Object One to One - Module: oraProcurementCorePurchasingSetup
- Business Object: DocumentLineType
Additional Mapping Details
Field in Current Object Field in Target Object lineTypeId typeId - modifiedByBuyer (object)
Requisition line that was modified by the buyer.
Label
Modified by Buyer
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object modifiedByBuyerId id - parentRequisitionLine (object)
Object reference to the requisition line that was modified by the buyer.
Label
Parent Requisition Line
Cardinality Target Object One to One - Module: oraProcurementCorePurchaseRequisitions
- Business Object: RequisitionLine
Additional Mapping Details
Field in Current Object Field in Target Object parentRequisitionLineId requisitionLineId - poHeader (object)
Purchase order associated with the requisition line.
Label
Purchase Order Header
Cardinality Target Object One to One - Module: oraProcurementCorePurchaseOrders
- Business Object: Order
Additional Mapping Details
Field in Current Object Field in Target Object poHeaderId orderHeaderId - poLine (object)
Purchase order line associated with the requisition line.
Label
Purchase Order Line
Cardinality Target Object One to One - Module: oraProcurementCorePurchaseOrders
- Business Object: OrderLine
Additional Mapping Details
Field in Current Object Field in Target Object poLineId orderLineId - poLineLocation (object)
Purchase order schedule associated with the requisition line.
Label
Purchase Order Schedule
Cardinality Target Object One to One - Module: oraProcurementCorePurchaseOrders
- Business Object: OrderSchedule
Additional Mapping Details
Field in Current Object Field in Target Object lineLocationId scheduleId - procurementBU (object)
Value that uniquely identifies the Procurement Business Unit.
Label
Default Procurement BU
Cardinality Target Object One to One - Module: oraErpCoreStructure
- Business Object: BusinessUnit
Additional Mapping Details
Field in Current Object Field in Target Object procurementBUId id - productCategory (object)
Object reference to the product category .
Label
Product Category
Cardinality Target Object One to One - Module: oraErpCoreTaxSetup
- Business Object: FiscalClassificationCodeHierarchy
Additional Mapping Details
Field in Current Object Field in Target Object productCategoryCode concatenatedClassificationCode - productFiscalClassification (object)
Object reference to the product fiscal classification on the requisition line.
Label
Product Fiscal Classification
Cardinality Target Object One to One - Module: oraScmCoreProductMgmtCatalogs
- Business Object: Category
Additional Mapping Details
Field in Current Object Field in Target Object productFiscalClassificationId id - productType (object)
Object reference to the product type on the requisition line.
Label
Product Type
Cardinality Target Object One to One - Module: oraErpCoreTaxSetup
- Business Object: TaxLookup
Additional Mapping Details
Field in Current Object Field in Target Object productTypeCode lookupCode - reinstatePOLineLocation (object)
Purchase order schedule from which the requisition line is reinstated.
Label
Reinstate Purchase Order Schedule
Cardinality Target Object One to One - Module: oraProcurementCorePurchaseOrders
- Business Object: OrderSchedule
Additional Mapping Details
Field in Current Object Field in Target Object reinstateLineLocationId scheduleId - requester (object)
Person for whom the requisition line was created.
Label
Requester
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object requesterId id - requisitionHeader (object)
The Requisition Header view object manages the purchase requisitions. A purchase requisition is an internal demand for purchasing an item or service, typically from a supplier who resides outside your organization.
Label
Requisition Header
Cardinality Target Object One to One - Module: oraProcurementCorePurchaseRequisitions
- Business Object: RequisitionHeader
Additional Mapping Details
Field in Current Object Field in Target Object requisitionHeaderId requisitionHeaderId - requisitioningBU (object)
Value that uniquely identifies the Requisitioning Business Unit.
Label
Requisitioning BU
Cardinality Target Object One to One - Module: oraErpCoreStructure
- Business Object: BusinessUnit
Additional Mapping Details
Field in Current Object Field in Target Object requisitioningBUId id - returnedByBuyer (object)
Value that uniquely identifies the buyer who returned or requested items from the person who ordered them.
Label
Returned by Buyer
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object returnedByBuyerId id - secondaryUOM (object)
Secondary unit of measure on the requisition line.
Label
Secondary UOM
Cardinality Target Object One to One - Module: oraScmCoreUnitOfMeasure
- Business Object: UnitOfMeasure
Additional Mapping Details
Field in Current Object Field in Target Object secondaryUOMCode code - shipToCustomer (object)
Customer to whom the ordered goods are being sent.
Label
Ship-to Customer
Cardinality Target Object One to One - Module: oraCxSalesCommonParty
- Business Object: Party
Additional Mapping Details
Field in Current Object Field in Target Object shipToCustomerId id - shipToCustomerContact (object)
Contact at the company where the ordered goods are being shipped.
Label
Ship-to Customer Contact
Cardinality Target Object One to One - Module: oraCxSalesCommonParty
- Business Object: Party
Additional Mapping Details
Field in Current Object Field in Target Object shipToCustomerContactId id - shipToCustomerLocation (object)
Location where the supplier should ship the ordered goods.
Label
Ship-to Customer Location
Cardinality Target Object One to One - Module: oraCxSalesCommonParty
- Business Object: Location
Additional Mapping Details
Field in Current Object Field in Target Object shipToCustomerLocationId id - sourceOrganization (object)
Inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
Label
Source Organization
Cardinality Target Object One to One - Module: oraScmCoreOrganization
- Business Object: OrganizationConfiguration
Additional Mapping Details
Field in Current Object Field in Target Object sourceOrganizationId id - sourceSubinventory (object)
Subinventory within the source inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
Label
Source Subinventory
Cardinality Target Object One to One - Module: oraScmCoreInventorySetup
- Business Object: Subinventory
Additional Mapping Details
Field in Current Object Field in Target Object sourceOrganizationId organizationId sourceSubinventoryName name - suggestedBuyer (object)
Suggested buyer for the ordered item.
Label
Suggested Buyer
Cardinality Target Object One to One - Module: oraHcmHrCoreEmployment
- Business Object: Worker
Additional Mapping Details
Field in Current Object Field in Target Object suggestedBuyerId id - supplier (object)
Supplier of the ordered item.
Label
Supplier
Cardinality Target Object One to One - Module: oraProcurementCoreSuppliers
- Business Object: Supplier
Additional Mapping Details
Field in Current Object Field in Target Object supplierId supplierId - supplierSite (object)
Entity that models how the buying organization engages with the supplier.
Label
Supplier Site
Cardinality Target Object One to One - Module: oraProcurementCoreSuppliers
- Business Object: SupplierSite
Additional Mapping Details
Field in Current Object Field in Target Object supplierSiteId id - taxClassification (object)
Object reference to the tax classification on the requisition line.
Label
Tax Classification
Cardinality Target One to One - Module: oraErpCoreTaxSetup
- Extraction View: TaxClassificationCodeList
Additional Mapping Details
Field in Current Object Field in Target taxClassificationCode taxClassificationCode - taxationCountry (object)
Default country used for taxation purposes.
Label
Taxation Country
Cardinality Target Object One to One - Module: oraCommonAppsInfraObjects
- Business Object: Territory
Additional Mapping Details
Field in Current Object Field in Target Object defaultTaxationCountry territoryCode - thirdPartyTaxRegistration (object)
Third-party tax registration on the requisition line.
Label
Third-Party Tax Registration
Cardinality Target One to One - Module: oraErpCoreTaxSetup
- Extraction View: ThirdPartyTaxRegistrationNumberList
Additional Mapping Details
Field in Current Object Field in Target thirdPartyRegistrationId id - transactionBusinessCategory (object)
Object reference to the transaction business category on the requisition line.
Label
Transaction Business Category
Cardinality Target One to One - Module: oraErpCoreTaxSetup
- Extraction View: TransactionBusinessCategoryList
Additional Mapping Details
Field in Current Object Field in Target transactionBusinessCategoryCode concatenatedClassificationCode - transferOrderHeader (object)
Transfer order which is associated with the requisition line.
Label
Transfer Order Header
Cardinality Target Object One to One - Module: oraScmCoreTransferOrder
- Business Object: TransferOrderHeader
Additional Mapping Details
Field in Current Object Field in Target Object transferOrderHeaderId id - transferOrderLine (object)
Line on the transfer order which is associated with the requisition line.
Label
Transfer Order Line
Cardinality Target Object One to One - Module: oraScmCoreTransferOrder
- Business Object: TransferOrderLine
Additional Mapping Details
Field in Current Object Field in Target Object transferOrderLineId lineId - unNumber (object)
United Nations number of the ordered item.
Label
United Nations Number
Cardinality Target Object One to One - Module: oraProcurementCorePurchasingSetup
- Business Object: UNNumber
Additional Mapping Details
Field in Current Object Field in Target Object unNumberId unNumberId - uom (object)
UOM which is a division of quantity defined as a standard for measurement or exchange.
Label
Unit of Measure
Cardinality Target Object One to One - Module: oraScmCoreUnitOfMeasure
- Business Object: UnitOfMeasure
Additional Mapping Details
Field in Current Object Field in Target Object uomCode code - userDefinedFiscalClassification (object)
Object reference to the user-defined fiscal classification on the requisition line.
Label
User-Defined Fiscal Classification
Cardinality Target Object One to One - Module: oraErpCoreTaxSetup
- Business Object: FiscalClassificationCodeHierarchy
Additional Mapping Details
Field in Current Object Field in Target Object userDefinedFiscClass concatenatedClassificationCode - workOrder (object)
Work Order number of the selected requisition line.
Label
Work Order
Cardinality Target Object One to One - Module: oraScmCoreManufacturingWorkOrder
- Business Object: WorkOrder
Additional Mapping Details
Field in Current Object Field in Target Object workOrderId id - workOrderOperation (object)
Work Order operation of the selected requisition line.
Label
Work Order Operation
Cardinality Target Object One to One - Module: oraScmCoreManufacturingWorkOrder
- Business Object: WorkOrderOperation
Additional Mapping Details
Field in Current Object Field in Target Object workOrderOperationId id
Business Views
** Available for extracting data- default
Data Source
RDBMS
Fields
- lineNumber (int64)
Number that uniquely identifies the requisition line.
Label
Requisition Line
Properties
- not nullable
- requisitionHeaderId (int64)
Value that uniquely identifies the requisition.
Label
Requisition Header ID
Properties
- searchable
- not nullable
- requisitionLineId (int64)
Value that uniquely identifies the requisition line.
Label
Requisition Line ID
Properties
- searchable
- sortable
- not nullable
Reference Object
- requisitionHeader (RequisitionHeader)
The Requisition Header view object manages the purchase requisitions. A purchase requisition is an internal demand for purchasing an item or service, typically from a supplier who resides outside your organization.
Business Object
RequisitionHeaderFields
- requisition (string)
Number that identifies the requisition. It's used to identify the requisition by end users.
Label
Requisition
Properties
- not nullable
- requisitionHeaderId (int64)
Value that uniquely identifies the requisition.
Label
Requisition Header ID
Properties
- searchable
- sortable
- not nullable
- requisition (string)
- lineNumber (int64)
- requisitionLinesExtract**
Label
Requisition Lines
Data Source
Read-optimized data store
Fields
- actionRequiredCode (enumeration: ActionRequired)
Value that identifies the action required of the user to remove the invoice hold on the line's corresponding invoice.
Label
Action Required Code
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: ActionRequired
Valid Values
- ORA_CREATE_PO_CHANGE_ORDER
- ORA_CREATE_RECEIPT
-
- altSupplierContactEmails (string)
Email addresses of additional supplier contacts. These email addresses are used to send purchase orders to supplier contacts involved in the procurement process.
Label
Alternate Supplier Contact Emails
- amount (big-decimal)
Total amount of the requested items in the currency of the buying company.
Label
Amount
- assessableValue (big-decimal)
Value that's assessable.
Label
Assessable Value
- atSourcingFlag (boolean)
Contains one of the following values: Y, N, or NULL. If Y, then the requisition line is part of an active negotiation in Oracle Sourcing. If N or NULL, then the requisition line isn't part of an active negotiation in Oracle Sourcing.
Label
On a Negotiation
- backToBackFlag (boolean)
Contains one of the following values: true or false. If true, then the purchase requisition line is intended to fulfill a specific customer sales order upon receipt. If false, then the purchase requisition line doesn't have a backing sales order. This attribute doesn't have a default value.
Label
Back-to-Back Order
- baseModelPrice (big-decimal)
Unit price of the base model only.
Label
Base Model Price
- bpaDescriptionUserOverrideFlag (boolean)
Indicates whether the item description from the blanket purchase requisition line has been updated by the user.
Label
Blanket Purchase Agreement Description User Override Flag
- bpaPriceUserOverrideFlag (boolean)
Indicates whether the blanket purchase agreement price attribute has been updated by user.
Label
Blanket Purchase Agreement Price User Override Flag
- buyerProcessingFlag (boolean)
Indicates whether the buyer is currently working on the requisition line or not.
Label
Buyer Processing Flag
- cancelDate (date)
Date when the requested items were canceled.
Label
Cancellation Date
- cancelFlag (boolean)
Indicates whether the requisition line is canceled or not.
Label
Cancel Flag
- cancelReason (string)
Reason for canceling the requested items.
Label
Cancellation Reason
- configuredItemFlag (boolean)
Contains one of the following values: true or false. If true, then the requisition line is for a configured item and configuration details might exist. If false, then the requisition line isn't for a configured item. This attribute doesn't have a default value.
Label
Configured Item Flag
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- currencyAmount (big-decimal)
Amount of the requested service in the transactional currency.
Label
Amount
- currencyConversionDate (date)
Date of the currency conversion rate.
Label
Conversion Date
- currencyConversionRate (big-decimal)
Rate of the currency conversion.
Label
Conversion Rate
- currencyUnitPrice (big-decimal)
Price of the requested item in the transactional currency.
Label
Price
- daysEarlyReceiptAllowed (big-decimal)
Maximum acceptable number of days allowed for early receipts.
Label
Days Early Receipt Allowed
- daysLateReceiptAllowed (big-decimal)
Maximum acceptable number of days allowed for late receipts.
Label
Days Late Receipt Allowed
- destinationTypeCode (enumeration: DestinationType)
Code that identifies whether the item is for inventory, expense, drop ship, or manufacturing. Valid values include INVENTORY, EXPENSE, DROP SHIP, and MANUFACTURING.
Label
Destination Type
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: DestinationType
Properties
- searchable
Valid Values
- DROP_SHIP
- EXPENSE
- INVENTORY
- MANUFACTURING
-
- disableAutosourcingFlag (boolean)
Indicates whether a source should be automatically determined for a requisition line.
Label
Disable Automatic Sourcing Flag
- externalCategory (string)
Category retrieved from punchout cart in case of a punchout line.
Label
External Category
- externalUOM (string)
UOM retrieved from punchout cart in case of a punchout line.
Label
External UOM
- externalUOMQuantity (string)
UOM associated quantity retrieved from punchout cart in case of a punchout line.
Label
Purchase Agreement Line
- firmFlag (boolean)
Indicates whether planning can reschedule or cancel the purchase order schedule.
Label
Firm Flag
- fundsStatus (enumeration: RequisitionFundStatus)
Status of the funds reservation request.
Label
Funds Status
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: RequisitionFundStatus
Valid Values
- LIQUIDATED
- NOT_APPLICABLE
- NOT_RESERVED
- NOT_RESERVED_FAILED
- NOT_RESERVED_PASSED
- NOT_RESERVED_WARNING
- PARTIALLY_LIQUIDATED
- RESERVED
- RESERVED_PARTIAL
-
- infoTemplateTouchedFlag (boolean)
Indicates whether the user has opened an information template or not.
Label
Information Template Viewed by User Flag
- interfaceLineKey (string)
Value that identifies the row in the requisition lines interface table.
Label
Interface Line Key
- itemDescription (string)
Description of the goods or services being purchased.
Label
Line Description
Properties
- not nullable
- itemRevision (string)
Number that identifies the revision of the item.
Label
Item Revision
- itemSource (string)
Source of the item. It indicates whether item comes from catalog, noncatalog, quick create, punchout, requisition import or service.
Label
Item Source
- itemUserOverrideFlag (boolean)
Indicates whether item attributes have been updated by the user.
Label
Item User Override Flag
- lastApprovalDate (date-time)
Date when the requisition lines was last approved.
Label
Last Approval Date
- lastSubmittedDate (date-time)
Date when the requisition line was last submitted for approval.
Label
Last Submitted Date
- lifeCycleSecondaryStatus (string)
Code that indicates the secondary status of a requisition line, providing additional information about its lifecycle.
Label
Lifecycle Secondary Status
- lifeCycleStatus (enumeration: LifeCycleStatus)
Value that identifies the lifecycle status code of the requisition line.
Label
Lifecycle Status
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: LifeCycleStatus
Valid Values
- BILLED
- BILLED_ORDER_ON_HOLD
- DELIVERED
- DELIVERED_ORDER_ON_HOLD
- IN_RECEIVING
- IN_RECEIVING_ORDER_ON_HOLD
- ORDERED
- ORDER_CANCELED
- ORDER_CANCELED_REINSTATED
- ORDER_ON_HOLD
For a complete list of valid values, see the LifeCycleStatus enumeration type.
-
- lineGroup (enumeration: LineGroup)
Group that indicates which group filter a requisition line belongs to.
Label
Line Group
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: LineGroup
Valid Values
- LINES_AWAITING_PROCESSING
- LINES_BEING_PROCESSED
- LINES_PENDING_APPROVAL
- LINES_REQUIRING_ATTENTION
- NEGOTIATION
- OTHER_REQUISITION_LINES
- PO
- TRANSFER_ORDER
-
- lineNumber (int64)
Number that uniquely identifies the requisition line.
Label
Requisition Line
Properties
- not nullable
- lineStatus (enumeration: LineStatus)
Status of the requisition line.
Label
Status
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: LineStatus
Valid Values
- APPROVED
- CANCELED
- INCOMPLETE
- ON_HOLD
- PENDING APPROVAL
- REJECTED
- REPLACED
- RETURNED
- SPLIT
- WITHDRAWN
-
- manufacturer (string)
Name of the company that manufactures the item being purchased.
Label
Manufacturer
- manufacturerPartNumber (string)
Number that uniquely identifies the item as provided by the manufacturer.
Label
Manufacturer Part Number
- matchingBasis (enumeration: MatchingBasis)
Basis of matching of the line type.
Label
Line Type Matching Basis
Type
-
Module: oraProcurementCorePurchasingSetup
-
Enumeration Type: MatchingBasis
Properties
- not nullable
Valid Values
- AMOUNT
- QUANTITY
-
- modeOfTransportCode (enumeration: ModeOfTransportCode)
Mode of transportation used to ship the product such as truck, air, or boat.
Label
Mode of Transport
Type
-
Module: oraScmCoreCarrier
-
Enumeration Type: ModeOfTransportCode
Valid Values
- AIR
- LTL
- OCEAN
- PARCEL
- RAIL
- TRUCK
-
- modifiedByBuyerFlag (boolean)
Indicates whether the line has been modified by the buyer.
Label
Modified by Buyer Flag
- needByDate (date)
Date when the buyer requests that the supplier deliver the item.
Label
Requested Date
- negotiatedByPreparerFlag (boolean)
Contains one of the following values: true or false. If true, then the price on the purchase requisition line is agreed on in advance between the buying company and the supplier. If false, then the price isn't agreed on in advance. This attribute doesn't have a default value.
Label
Negotiated
- negotiationRequiredFlag (boolean)
Contains one of the following values: true or false. If true, then an request for quotation is required prior to placing the requisition line on a purchase order. If false, then an request for quotation isn't required. This attribute doesn't have a default value.
Label
Negotiation Required
- newSupplierFlag (boolean)
Contains one of the following values: true or false. If true, then the supplier entered on the line is a new supplier. If false, then the supplier entered on the line is an existing supplier. This attribute doesn't have a default value.
Label
New supplier
- noteToBuyer (string)
Note to the buyer on the purchase requisition.
Label
Note to Buyer
- noteToReceiver (string)
Note to the receiver on the purchase requisition.
Label
Note to Receiver
- noteToSupplier (string)
Note to the supplier on the purchase requisition.
Label
Note to Supplier
- onRFQFlag (boolean)
Indicates whether the requisition line was placed on an RFQ.
Label
On an RFQ Flag
- oneTimeLocationFlag (boolean)
Contains one of the following values: true or false. If true, then the location on final delivery of goods is a one time delivery address. If false, then the location of delivery is an existing address in Oracle Global Human Resources Cloud. The default value is false.
Label
Deliver-to Location Type
- optionsPrice (big-decimal)
Price that indicates the sum of the extended price of all options chosen per unit of the purchased configuration.
Label
Total Options Price
- orchestrationCode (string)
Code for integrating applications to determine the transactions within Procurement that they need to track. For example, SCO and DOO.
Label
Orchestration Code
- originalApprovalDate (date-time)
Date when the requisition line was first approved.
Label
Original Approval Date
- originalSubmittedDate (date-time)
Date when the requisition line was first submitted for approval.
Label
Original Submitted Date
- priceVarianceExceededAmount (big-decimal)
Price variance amount of the requisition line if the punchout item exceeds the price variance check.
Label
Price Variance Exceeded Amount
- priceVarianceExceededFlag (boolean)
Indicate whether the punchout requisition line exceeded the price variance check as per the tolerance on the punchout catalog.
Label
Price Variance Exceeded Amount
Properties
- not nullable
- procurementCardFlag (boolean)
Indicate whether the line was ordered using a procurement card.
Label
Procurement Card Flag
- purchaseBasis (enumeration: PurchaseBasis)
Purchase basis of the line type.
Label
Line Type Value Basis
Type
-
Module: oraProcurementCorePurchasingSetup
-
Enumeration Type: PurchaseBasis
Properties
- not nullable
Valid Values
- GOODS
- SERVICES
-
- quantity (big-decimal)
Quantity of the goods being purchased.
Label
Quantity
- quantityCancelled (big-decimal)
Quantity that was canceled.
Label
Canceled Quantity
- quantityDelivered (big-decimal)
Quantity delivered against the purchase order schedule.
Label
Delivered Quantity
- quantityReceived (big-decimal)
Quantity received against the purchase order schedule.
Label
Received Quantity
- quantityReceivedTolerance (big-decimal)
Percentage of the quantity that can be received in excess of the designated order quantity.
Label
Quantity Received Tolerance
- quantityUnderRecieveTolerance (big-decimal)
Value that indicates the percentage that the application uses to determine whether to automatically close a purchase order schedule when the receiver receives only part of the item.
Label
Under Receipt Quantity Tolerance
- repriceFlag (boolean)
Indicate whether the transfer supply request can be repriced by calling Supply Chain Financial Orchestration.
Label
Reprice Flag
- requestedShipDate (date)
Date when the buying company requested the ordered item to be shipped.
Label
Requested Ship Date
- requisitionHeaderId (int64)
Value that uniquely identifies the requisition.
Label
Requisition Header ID
Properties
- searchable
- not nullable
- requisitionLineId (int64)
Value that uniquely identifies the requisition line.
Label
Requisition Line ID
Properties
- searchable
- sortable
- not nullable
- returnReason (string)
Reason for returning one or more requested items.
Label
Return Reason
- salesOrderLineNumber (string)
Number that uniquely identifies the sales order line for a given customer sales order.
Label
Sales Order Line Number
- salesOrderNumber (string)
Number that uniquely identifies the backing sales order
Label
Customer Sales Order
- salesOrderScheduleNumber (string)
Number that uniquely identifies the sales order schedule for a given customer sales order line.
Label
Sales Order Schedule Number
- secondaryQuantity (big-decimal)
Quantity in terms of the secondary unit of measure for a dual unit of measure controlled item.
Label
Secondary Quantity
- secondaryQuantityCancelled (big-decimal)
Canceled quantity in the secondary unit of measure.
Label
Secondary Quantity Canceled
- secondaryQuantityReceived (big-decimal)
Total quantity of an ordered item, in the secondary unit of measure, that has been received so far.
Label
Secondary Quantity Received
- serviceLevelCode (enumeration: ServiceLevelCode)
Transportation priority that determines how quickly to transport goods.
Label
Service Level
Type
-
Module: oraScmCoreCarrier
-
Enumeration Type: ServiceLevelCode
Valid Values
- 1DA
- 1DM
- 1DP
- 2DA
- 2DAY
- 2DM
- 2FX
- 3DAY
- 3DS
- AIR
For a complete list of valid values, see the ServiceLevelCode enumeration type.
-
- sourceDocumentTypeCode (enumeration: AgreementType)
Type of the suggested source document.
Label
Agreement Type
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: AgreementType
Properties
- searchable
Valid Values
- BLANKET
- CONTRACT
-
- sourceTypeCode (enumeration: SourceType)
Code that identifies the type of supply source for the requisition line. Values include the following values: Internal or External. If Internal, it means the line is sourced from an inventory organization. If External, it means the line is sourced for supplier.
Label
Source Type
Type
-
Module: oraProcurementCorePurchaseRequisitions
-
Enumeration Type: SourceType
Properties
- not nullable
Valid Values
- EXTERNAL
- INTERNAL
-
- suggestedSupplier (string)
Name of the suggested supplier.
Label
Suggested Supplier
- suggestedSupplierContact (string)
Name of the suggested supplier contact.
Label
Supplier Contact
- suggestedSupplierContactEmail (email)
Email of the suggested supplier contact.
Label
Email
- suggestedSupplierContactFax (string)
Fax number of the suggested supplier contact.
Label
Fax
- suggestedSupplierContactPhone (string)
Phone number of the suggested supplier contact.
Label
Phone
- suggestedSupplierItemNumber (string)
Number of the suggested supplier product.
Label
Supplier Item
- suggestedSupplierSite (string)
Site of the suggested supplier.
Label
Supplier Site
- supplierDUNS (string)
Data Universal Numbering System code of the suggested supplier.
Label
Supplier D-U-N-S
- supplierReferenceNumber (string)
Reference Number for the Supplier.
Label
Supplier Configuration ID
- taxAttributeUserOverrideFlag (boolean)
Indicates whether the tax attributes were overridden by the user.
Label
Tax Attribute User Override Flag
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- unitPrice (big-decimal)
Price of the requested item in the currency of the buying company.
Label
Price
- unspscCode (string)
Code that identifies the United Nations Standard Products and Services Code for taxonomy of products and services.
Label
UNSPSC
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- urgentFlag (boolean)
Contains one of the following values: true or false. If true, then the requisition line requires urgent processing. If false, then the line doesn't require urgent processing. This attribute doesn't have a default value.
Label
Urgent
- workOrderNumber (string)
Number of the contract manufacturing work order.
Label
Work Order
- workOrderOperationSequence (big-decimal)
Value that indicates the execution sequence of the work order operation.
Label
Operation Sequence
- workOrderProduct (string)
Value that identifies the finished goods of the contract manufacturing work order.
Label
Product
- workOrderSubType (string)
Display name that identifies the subtype of the manufacturing work order.
Label
Work Order Subtype
Reference Object
- agreementHeader (Agreement)
Purchase agreement associated with the requisition line.
Business Object
AgreementFields
- agreementHeaderId (int64)
Value that uniquely identifies the purchase agreement.
Label
Header ID
Properties
- searchable
- sortable
- not nullable
- agreementHeaderId (int64)
- agreementLine (AgreementLine)
Agreement line associated with the requisition line.
Business Object
AgreementLineFields
- agreementLineId (int64)
Value that indicates the status of the line.
Label
Line ID
Properties
- searchable
- sortable
- not nullable
- agreementLineId (int64)
- assignedBuyer (Worker)
Buyer assigned to process the requisition line.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- baseItem (Item)
Base or ATO Model on which the unique configuration is built.
Business Object
ItemFields
- itemId (int64)
Value that uniquely identifies the part, material, product, or service that's unique as compared with other items by the nature of its attributes.
Label
Item
Properties
- searchable
- sortable
- not nullable
- organizationId (int64)
Value that uniquely identifies the organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.
Label
Organization
Properties
- searchable
- sortable
- not nullable
- itemId (int64)
- carrier (Party)
Carrier through which ordered goods are shipped.
Business Object
PartyFields
- id (int64)
The unique identifier of the party.
Label
Party ID
Properties
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- category (Category)
Object reference to the product category .
Business Object
CategoryFields
- id (int64)
Value that uniquely identifies the item category. This value should not be used in service calls to create categories in catalogs.
Label
Item Category
Properties
- searchable
- sortable
- not nullable
- id (int64)
- contentProcurementBU (BusinessUnit)
Business unit of the content.
Business Object
BusinessUnitFields
- id (int64)
The unique identifier of the business unit.
Label
Business Unit ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- currency (Currency)
Currency in which an amount or conversion rate is denominated.
Business Object
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- currencyConversionRateType (CurrencyConversionRateType)
Type of conversion rate used to convert from the transaction currency on the line to the functional currency of the requisitioning business unit.
Business Object
CurrencyConversionRateTypeFields
- conversionRateType (string)
The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.
Label
Conversion Rate Type
Properties
- searchable
- sortable
- not nullable
- conversionRateType (string)
- deliverToCustomer (Party)
Object reference to the deliver-to customer on the requisition line.
Business Object
PartyFields
- id (int64)
The unique identifier of the party.
Label
Party ID
Properties
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- deliverToCustomerContact (Party)
Contact person at the final location where goods, previously received from a supplier, will be delivered.
Business Object
PartyFields
- id (int64)
The unique identifier of the party.
Label
Party ID
Properties
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- deliverToCustomerLocation (Location)
Final location where goods, previously received from a supplier, will be delivered. For internal locations, this will be a TCA location. For Structured One-Time Addresses, this represents the delivery location.
Business Object
LocationFields
- id (int64)
Foreign key to the FA_LOCATIONS table.
Label
Location ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- deliverToLocation (Location)
Object reference to the deliver-to location on the requisition line.
Business Object
LocationFields
- id (int64)
Surrogate identifier for the location.
Label
Location Identifier
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- destinationOrganization (OrganizationConfiguration)
Inventory organization where the supplier should deliver the ordered item.
Business Object
OrganizationConfigurationFields
- id (int64)
Value that uniquely identifies the item or inventory organization. It's a primary key that the application generates when it creates an item or inventory organization.
Label
ID
Properties
- searchable
- not nullable
- id (int64)
- destinationSubinventory (Subinventory)
Subinventory that identifies where to deliver the requested item.
Business Object
SubinventoryFields
- name (string)
Value that identifies the subinventory name.
Label
Name
Properties
- searchable
- sortable
- not nullable
- organizationId (int64)
Value that uniquely identifies the organization.
Label
Organization ID
Properties
- searchable
- sortable
- not nullable
- name (string)
- documentFiscalClassification (FiscalClassificationCodeHierarchy)
Document fiscal classification of the requisition line.
Business Object
FiscalClassificationCodeHierarchyFields
- concatenatedClassificationCode (string)
The hierarchy of parent records where a specific fiscal classification code was defined in a hierarchical fiscal classification.
Label
Code Path
Properties
- searchable
- sortable
- not nullable
- concatenatedClassificationCode (string)
- firstPartyTaxRegistration (TaxRegistration)
First-party tax registration on the requisition line.
Business Object
TaxRegistrationFields
- id (int64)
The unique identifier of the tax registration.
Label
Registration ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- hazardClass (HazardClass)
Hazard class on the line.
Business Object
HazardClassFields
- hazardClassId (int64)
Value that uniquely identifies the purchasing style of the document.
Label
Hazard Class ID
Properties
- searchable
- sortable
- not nullable
- hazardClassId (int64)
- item (Item)
Item associated with the requisition line.
Business Object
ItemFields
- itemId (int64)
Value that uniquely identifies the part, material, product, or service that's unique as compared with other items by the nature of its attributes.
Label
Item
Properties
- searchable
- sortable
- not nullable
- organizationId (int64)
Value that uniquely identifies the organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.
Label
Organization
Properties
- searchable
- sortable
- not nullable
- itemId (int64)
- level10RequesterSupervisor (Worker)
Level 10 supervisor of the requester, with level 1 is the highest management level of the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- level1RequesterSupervisor (Worker)
Level 1 supervisor of the requester, with level 1 being the highest management level in the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- level2RequesterSupervisor (Worker)
Level 2 supervisor of the requester, with level 1 is the highest management level of the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- level3RequesterSupervisor (Worker)
Level 3 supervisor of the requester, with level 1 is the highest management level of the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- level4RequesterSupervisor (Worker)
Level 4 supervisor of the requester, with level 1 is the highest management level of the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- level5RequesterSupervisor (Worker)
Level 5 supervisor of the requester, with level 1 is the highest management level of the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- level6RequesterSupervisor (Worker)
Level 6 supervisor of the requester, with level 1 is the highest management level of the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- level7RequesterSupervisor (Worker)
Level 7 supervisor of the requester, with level 1 is the highest management level of the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- level8RequesterSupervisor (Worker)
Level 8 supervisor of the requester, with level 1 is the highest management level of the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- level9RequesterSupervisor (Worker)
Level 9 supervisor of the requester, with level 1 is the highest management level of the organization.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- lineType (DocumentLineType)
Line type on the requisition line.
Business Object
DocumentLineTypeFields
- typeId (int64)
Value that uniquely identifies the line type you use on your documents.
Label
Type ID
Properties
- searchable
- sortable
- not nullable
- typeId (int64)
- modifiedByBuyer (Worker)
Requisition line that was modified by the buyer.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- parentRequisitionLine (RequisitionLine)
Object reference to the requisition line that was modified by the buyer.
Business Object
RequisitionLineFields
- requisitionLineId (int64)
Value that uniquely identifies the requisition line.
Label
Requisition Line ID
Properties
- searchable
- sortable
- not nullable
- requisitionLineId (int64)
- poHeader (Order)
Purchase order associated with the requisition line.
Business Object
OrderFields
- orderHeaderId (int64)
Value that uniquely identifies the purchase order header.
Label
Header ID
Properties
- searchable
- sortable
- not nullable
- orderHeaderId (int64)
- poLine (OrderLine)
Purchase order line associated with the requisition line.
Business Object
OrderLineFields
- orderLineId (int64)
Value that uniquely identifies the purchase order or agreement line.
Label
Line ID
Properties
- searchable
- sortable
- not nullable
- orderLineId (int64)
- poLineLocation (OrderSchedule)
Purchase order schedule associated with the requisition line.
Business Object
OrderScheduleFields
- scheduleId (int64)
Value that uniquely identifies the document shipment schedule.
Label
Schedule ID
Properties
- searchable
- sortable
- not nullable
- scheduleId (int64)
- procurementBU (BusinessUnit)
Value that uniquely identifies the Procurement Business Unit.
Business Object
BusinessUnitFields
- id (int64)
The unique identifier of the business unit.
Label
Business Unit ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- productCategory (FiscalClassificationCodeHierarchy)
Object reference to the product category .
Business Object
FiscalClassificationCodeHierarchyFields
- concatenatedClassificationCode (string)
The hierarchy of parent records where a specific fiscal classification code was defined in a hierarchical fiscal classification.
Label
Code Path
Properties
- searchable
- sortable
- not nullable
- concatenatedClassificationCode (string)
- productFiscalClassification (Category)
Object reference to the product fiscal classification on the requisition line.
Business Object
CategoryFields
- code (string)
Abbreviation that identifies the item category in user interface.
Label
Category Code
Properties
- searchable
- sortable
- id (int64)
Value that uniquely identifies the item category. This value should not be used in service calls to create categories in catalogs.
Label
Item Category
Properties
- searchable
- sortable
- not nullable
- code (string)
- productType (TaxLookup)
Object reference to the product type on the requisition line.
Business Object
TaxLookupFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- reinstatePOLineLocation (OrderSchedule)
Purchase order schedule from which the requisition line is reinstated.
Business Object
OrderScheduleFields
- scheduleId (int64)
Value that uniquely identifies the document shipment schedule.
Label
Schedule ID
Properties
- searchable
- sortable
- not nullable
- scheduleId (int64)
- requester (Worker)
Person for whom the requisition line was created.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- requisitionHeader (RequisitionHeader)
The Requisition Header view object manages the purchase requisitions. A purchase requisition is an internal demand for purchasing an item or service, typically from a supplier who resides outside your organization.
Business Object
RequisitionHeaderFields
- requisitionHeaderId (int64)
Value that uniquely identifies the requisition.
Label
Requisition Header ID
Properties
- searchable
- sortable
- not nullable
- requisitionHeaderId (int64)
- requisitioningBU (BusinessUnit)
Value that uniquely identifies the Requisitioning Business Unit.
Business Object
BusinessUnitFields
- id (int64)
The unique identifier of the business unit.
Label
Business Unit ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- returnedByBuyer (Worker)
Value that uniquely identifies the buyer who returned or requested items from the person who ordered them.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- secondaryUOM (UnitOfMeasure)
Secondary unit of measure on the requisition line.
Business Object
UnitOfMeasureFields
- code (string)
User-supplied short code that identifies the unit of measure. This attribute is required.
Label
Code
Properties
- creatable
- searchable
- sortable
- not nullable
- code (string)
- shipToCustomer (Party)
Customer to whom the ordered goods are being sent.
Business Object
PartyFields
- id (int64)
The unique identifier of the party.
Label
Party ID
Properties
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- shipToCustomerContact (Party)
Contact at the company where the ordered goods are being shipped.
Business Object
PartyFields
- id (int64)
The unique identifier of the party.
Label
Party ID
Properties
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- shipToCustomerLocation (Location)
Location where the supplier should ship the ordered goods.
Business Object
LocationFields
- id (int64)
Foreign key to the FA_LOCATIONS table.
Label
Location ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- sourceOrganization (OrganizationConfiguration)
Inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
Business Object
OrganizationConfigurationFields
- id (int64)
Value that uniquely identifies the item or inventory organization. It's a primary key that the application generates when it creates an item or inventory organization.
Label
ID
Properties
- searchable
- not nullable
- id (int64)
- sourceSubinventory (Subinventory)
Subinventory within the source inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
Business Object
SubinventoryFields
- name (string)
Value that identifies the subinventory name.
Label
Name
Properties
- searchable
- sortable
- not nullable
- organizationId (int64)
Value that uniquely identifies the organization.
Label
Organization ID
Properties
- searchable
- sortable
- not nullable
- name (string)
- suggestedBuyer (Worker)
Suggested buyer for the ordered item.
Business Object
WorkerFields
- id (int64)
Unique identifier of person business object.
Label
Id
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- supplier (Supplier)
Supplier of the ordered item.
Business Object
SupplierFields
- supplierId (int64)
Value that uniquely identifies the supplier.
Label
Supplier ID
Properties
- searchable
- sortable
- not nullable
- supplierId (int64)
- supplierSite (SupplierSite)
Entity that models how the buying organization engages with the supplier.
Business Object
SupplierSiteFields
- id (int64)
Value that uniquely identifies the supplier site.
Label
Supplier Site ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- taxationCountry (Territory)
Default country used for taxation purposes.
Business Object
TerritoryFields
- territoryCode (string)
The unique code of the territory.
Label
Territory Code
Properties
- searchable
- sortable
- not nullable
- territoryCode (string)
- transferOrderHeader (TransferOrderHeader)
Transfer order which is associated with the requisition line.
Business Object
TransferOrderHeaderFields
- id (int64)
Value that uniquely identifies the transfer order header.
Label
ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- transferOrderLine (TransferOrderLine)
Line on the transfer order which is associated with the requisition line.
Business Object
TransferOrderLineFields
- lineId (int64)
Value that uniquely identifies the transfer order line.
Label
Line ID
Properties
- searchable
- sortable
- not nullable
- lineId (int64)
- unNumber (UNNumber)
United Nations number of the ordered item.
Business Object
UNNumberFields
- unNumberId (int64)
Value that uniquely identifies the number that the United Nations uses to identify hazardous material.
Label
UN Number ID
Properties
- searchable
- sortable
- not nullable
- unNumberId (int64)
- uom (UnitOfMeasure)
UOM which is a division of quantity defined as a standard for measurement or exchange.
Business Object
UnitOfMeasureFields
- code (string)
User-supplied short code that identifies the unit of measure. This attribute is required.
Label
Code
Properties
- creatable
- searchable
- sortable
- not nullable
- code (string)
- userDefinedFiscalClassification (FiscalClassificationCodeHierarchy)
Object reference to the user-defined fiscal classification on the requisition line.
Business Object
FiscalClassificationCodeHierarchyFields
- concatenatedClassificationCode (string)
The hierarchy of parent records where a specific fiscal classification code was defined in a hierarchical fiscal classification.
Label
Code Path
Properties
- searchable
- sortable
- not nullable
- concatenatedClassificationCode (string)
- workOrder (WorkOrder)
Work Order number of the selected requisition line.
Business Object
WorkOrderFields
- id (int64)
Value that uniquely identifies the work order. This is the primary key of the Work Order view object.
Label
ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- workOrderOperation (WorkOrderOperation)
Work Order operation of the selected requisition line.
Business Object
WorkOrderOperationFields
- id (int64)
Value that uniquely identifies the work order operation. This is the primary key of the Work Order Operation view object.
Label
Work Order Operation Identifier
Properties
- searchable
- sortable
- not nullable
- id (int64)
- actionRequiredCode (enumeration: ActionRequired)
Other Properties
| Property | Value |
|---|---|
| Application Package Name | ora_procurement_core_purchaseRequisitions |
| Extensible | Yes |