JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

RecentRequisitions

Lists the most recently created or submitted requisitions for a given user, speeding up reorders or reference checks.

Columns

Name Type Description
RequisitionHeaderId [KEY] Long The unique identifier for the requisition header, linking the requisition details to a specific requisition record. Example: 1001 for Requisition Header ID 1001.
Description String A brief description or title of the requisition, providing context or summary of the requisition's purpose. Example: 'Office Supplies for Q3'.
RequisitionNumber String The unique identifier or number assigned to the requisition, typically used for tracking and referencing. Example: 'REQ-2023-001' for Requisition Number REQ-2023-001.
DocumentStatus String The current status of the requisition document, indicating its approval or submission stage. Example: 'APPROVED' for an approved requisition.
PreparerId Long The unique identifier for the preparer of the requisition, linking the requisition to the person who created it. Example: 2001 for Preparer ID 2001.
LineCount Int The number of lines or items listed in the requisition, indicating the total number of distinct entries. Example: 10 for a requisition with 10 items.
RequisitionAmount Decimal The total monetary value of the requisition, representing the overall cost of the requested items. Example: 1500.00 for a requisition worth $1500.
ThumbnailImage String A link or reference to the thumbnail image associated with the requisition, typically used for visual representation. Example: 'thumbnail_12345.png' for the thumbnail image file.
CurrencyCode String The code for the currency used in the requisition, helping to identify the currency format. Example: 'USD' for US Dollars.
CurrencySymbol String The symbol of the currency used in the requisition, displayed alongside monetary values. Example: '$' for US Dollars.
RequisitioningBUId Long The unique identifier for the requisitioning business unit (BU) associated with the requisition, linking it to the specific department or unit. Example: 3001 for Procurement Unit A.
FormattedRequisitionAmount String The formatted string representation of the requisition amount, often including currency symbols and thousand separators. Example: '$1,500.00' for a properly formatted amount.
BindPreparerId Long The identifier for the preparer used to bind and link the requisition to the preparer's user account. Example: 4001 for Preparer ID bound to this requisition.
Finder String A reference or placeholder used for searching and locating specific requisition records in the system. Example: 'Search by Requisition Number' or 'Search by Preparer'.

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