ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

RequisitionProcessingRequests

Handles the conversion of approved requisition lines into purchase documents (for example, purchase orders), orchestrating the procurement flow.

Columns

Name Type Description
RequestHeaderId [KEY] Long The unique identifier for the request header in the requisition processing system. Example: 1001 for Request Header ID 1001.
ProcurementBUId Long The unique identifier for the business unit responsible for managing the requisition and corresponding purchase order or negotiation. Example: 2001 for Procurement Business Unit A.
ProcurementBU String The name of the business unit managing and owning the requisition and corresponding purchase order or negotiation. Example: 'Procurement' for the Procurement department.
RequisitioningBUId Long The unique identifier for the business unit that raised the requisition. Example: 3001 for the business unit that raised the requisition for office supplies.
RequisitioningBU String The name of the business unit that raised the requisition for goods or services. Example: 'Sales' for the business unit requesting the purchase.
Type String The type of document being processed, which can represent a new order, an existing order, or a negotiation. Example: 'New Order' for newly created requisitions.
SoldToLegalEntityId Long The unique identifier for the legal entity that is financially responsible for purchases on the purchase order. Example: 4001 for the legal entity responsible for the purchase.
SoldToLegalEntity String The legal entity responsible for the financial obligations of the purchase order. Example: 'ABC Corporation' for the legal entity making the purchase.
SupplierId Long The unique identifier for the supplier of the goods or services. Example: 5001 for Supplier ID 5001.
Supplier String The name of the supplier providing the goods or services. Example: 'XYZ Supplies Ltd.' for the company supplying the requested items.
SupplierSiteId Long The unique identifier for the supplier site. Example: 6001 for the supplier's location where the goods will be sent from.
SupplierSite String The location that the supplier uses for order fulfillment. Example: 'Warehouse A' for the supplier's main distribution center.
DocumentStyleId Long The unique identifier for the purchasing document style. Example: 7001 for Purchase Order Document Style ID 7001.
DocumentStyle String The name of the purchasing document style, used to control the display and parameters of the document. Example: 'Standard PO' for the default purchasing document style.
SourceAgreementId Long The unique identifier for the source agreement linked to the requisition. Example: 8001 for Source Agreement ID 8001.
SourceAgreement String The number that uniquely identifies the source agreement. Example: 'AGT-123' for the agreement under which goods are being procured.
CurrencyCode String The currency code used for the purchase order. Example: 'USD' for U.S. Dollars.
Currency String The currency of the purchase order. Example: 'USD' for a purchase order in U.S. Dollars.
ConversionRateTypeCode String The abbreviation identifying the type of conversion rate used to determine currency conversion. Example: 'Spot Rate' for the conversion rate applied on a given day.
ConversionRateType String The type of conversion rate used for currency conversion in the purchase order. Example: 'Market Rate' for using the market rate at the time of purchase.
ConversionRateDate Date The date used for the conversion rate when converting an ordered amount into another currency. Example: '2023-06-01' for the conversion rate applicable on this date.
ConversionRate Decimal The rate used to convert the purchase order amount from one currency to another. Example: 1.1 for the conversion rate from EUR to USD.
BuyerId Long The unique identifier for the buyer responsible for managing the procurement document. Example: 9001 for Buyer ID 9001.
Buyer String The person responsible for managing and overseeing the procurement process. Example: 'John Doe' for the buyer handling the requisition.
GroupRequisitionLines String Indicates whether requisition lines are grouped together on purchase order lines. Example: 'Y' if requisition lines are grouped, 'N' if they are not grouped.
OrderNumber String The unique number assigned to the purchase order. Example: 'PO-1001' for the first purchase order in the system.
POHeaderId Long The unique identifier for the purchase order header. Example: 10001 for Purchase Order Header ID 10001.
Finder String A reference or placeholder used for searching and locating specific requisition processing request records. Example: 'Search by Order Number' or 'Search by Buyer'.

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