JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

DraftPurchaseOrderssummaryAttributes

Summarizes high-level attributes of a draft purchase order, compiling data from all lines for review or analysis.

Columns

Name Type Description
DraftPurchaseOrdersPOHeaderId [KEY] Long The unique identifier for a draft purchase order header, linking the purchase order to its summary attributes.
POHeaderId [KEY] Long The identifier for the purchase order header, linking the summary attributes to the specific purchase order.
DeliverToLocationCode String The code for the delivery location where the items or services in the purchase order will be shipped or provided.
DeliverToLocationId Long The unique identifier for the location where the purchased goods or services are to be delivered.
DeliverToSingleLocationFlag Bool A flag indicating whether the purchase order is to be delivered to a single location (true) or multiple locations (false).
DeliverToCustomerLocationId Long The unique identifier for the location at the customer's site where the items or services are to be delivered.
ProjectCostingDetailsCode String A code that links the purchase order to specific project costing details, aiding in financial tracking and resource allocation.
ProjectId Decimal The unique identifier for the project associated with the purchase order, allowing linkage to specific project resources or tasks.
ProjectNumber String The project number associated with the purchase order, providing an easy reference to the project's financial tracking.
ProjectName String The name of the project tied to the purchase order, offering a descriptive label for the project's scope.
RequesterId String The unique identifier for the person or department who made the request for the purchase, helping with internal tracking and approval.
SameRequesterIdFlag Bool A flag indicating whether the same requester ID is used across all lines in the purchase order (true) or if different requesters are involved (false).
Requester String The name of the person or department requesting the purchase order, useful for approval workflows and accountability.
RequestedDeliveryDate Date The date requested by the requester for the delivery of items or services associated with the purchase order.
SameRequestedDeliveryDateFlag Bool A flag indicating whether the same requested delivery date applies to all lines in the purchase order (true) or if there are multiple dates (false).
TaskNumber String The number assigned to the task associated with the purchase order, helping to link the order to specific activities or objectives.
TaskName String The name or description of the task associated with the purchase order, providing context for the purpose of the purchase.
ProjectsInformationAcrossLines String Information relevant to the project across all lines in the purchase order, used for project-wide tracking and reporting.
POChargeAccountId Long The unique identifier for the account that will be charged for the purchase order, relevant for cost allocation and financial tracking.
ChargeToSingleAccountFlag Bool A flag indicating whether all charges for the purchase order should be applied to a single account (true) or distributed across multiple accounts (false).
POChargeAccount String The account to be charged for the purchase, typically associated with the requisitioning business unit and project.
Ordered Decimal The total ordered quantity or value for the purchase order, representing the amount requested for the goods or services.
TotalTax Decimal The total tax amount applied to the purchase order, calculated based on applicable tax rates for the items or services ordered.
Total Decimal The total value of the purchase order, including both the cost of the goods/services and any applicable taxes or fees.
TaskId Decimal The unique identifier for the task associated with the purchase order, linking the purchase to a specific activity or milestone in the project.
DeliverToCustomerLocationAddress String The address for the customer location where the purchased items or services are to be delivered.
ChartOfAccountId Decimal The unique identifier for the chart of accounts that corresponds to the purchase order, used for financial reporting and classification.
Finder String A search identifier used to locate specific purchase order records within the system.
Intent String Describes the intended action or purpose for the purchase order, such as creating, updating, or reviewing.
SysEffectiveDate String The system’s effective date, marking when the purchase order record was created or last updated in the system.
CUReferenceNumber Int An identifier used to link child aggregate records with their corresponding parent tables, ensuring data consistency in hierarchical structures.
EffectiveDate Date The date on which the purchase order becomes effective, indicating when the order and its attributes are valid.

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