Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

PurchaseRequisitionssummaryAttributes

The Summary Attributes for Purchase Requisitions resource manages the aggregated summary attributes of purchase requisitions. The summary attributes comprise aggregated information from across the lines for a requisition. This resource returns the corresponding data only when called in conjunction with an appropriate finder.

Columns

Name Type Description
PurchaseRequisitionsRequisitionHeaderId [KEY] Long PurchaseRequisitionsRequisitionHeaderId of PurchaseRequisitionssummaryAttributes
RequisitionHeaderId [KEY] Long RequisitionHeaderId of PurchaseRequisitionssummaryAttributes
ActiveLineCount Decimal ActiveLineCount of PurchaseRequisitionssummaryAttributes
PurchaseOrderCount Decimal PurchaseOrderCount of PurchaseRequisitionssummaryAttributes
TransferOrderCount Decimal TransferOrderCount of PurchaseRequisitionssummaryAttributes
BuyerCount Decimal BuyerCount of PurchaseRequisitionssummaryAttributes
PurchaseOrder String PurchaseOrder of PurchaseRequisitionssummaryAttributes
TransferOrder String TransferOrder of PurchaseRequisitionssummaryAttributes
Buyer String Buyer of PurchaseRequisitionssummaryAttributes
BuyerId Long BuyerId of PurchaseRequisitionssummaryAttributes
POHeaderId Long POHeaderId of PurchaseRequisitionssummaryAttributes
TOHeaderId Long TOHeaderId of PurchaseRequisitionssummaryAttributes
LineCount Decimal LineCount of PurchaseRequisitionssummaryAttributes
DeliverToSingleLocationFlag Bool DeliverToSingleLocationFlag of PurchaseRequisitionssummaryAttributes
DeliverToLocationCode String DeliverToLocationCode of PurchaseRequisitionssummaryAttributes
DeliverToLocationId Long DeliverToLocationId of PurchaseRequisitionssummaryAttributes
DeliverToOneTimeLocationAddress String DeliverToOneTimeLocationAddress of PurchaseRequisitionssummaryAttributes
DeliverToOneTimeLocationId Long DeliverToOneTimeLocationId of PurchaseRequisitionssummaryAttributes
SameRequestedDeliveryDateFlag Bool SameRequestedDeliveryDateFlag of PurchaseRequisitionssummaryAttributes
RequestedDeliveryDate Date RequestedDeliveryDate of PurchaseRequisitionssummaryAttributes
ChargeToSingleAccountFlag Bool ChargeToSingleAccountFlag of PurchaseRequisitionssummaryAttributes
ChargeAccount String ChargeAccount of PurchaseRequisitionssummaryAttributes
ChargeAccountId Long ChargeAccountId of PurchaseRequisitionssummaryAttributes
RequisitionTotalAmount Decimal RequisitionTotalAmount of PurchaseRequisitionssummaryAttributes
RequisitionNonRecoverableTaxAmount Decimal RequisitionNonRecoverableTaxAmount of PurchaseRequisitionssummaryAttributes
RequisitionApprovalAmount Decimal RequisitionApprovalAmount of PurchaseRequisitionssummaryAttributes
OneTimeLocationCountAcrossRequisition Long OneTimeLocationCountAcrossRequisition of PurchaseRequisitionssummaryAttributes
OneTimeLocationCountAcrossRequisitionLine Long OneTimeLocationCountAcrossRequisitionLine of PurchaseRequisitionssummaryAttributes
ProjectCostingDetailsCode String ProjectCostingDetailsCode of PurchaseRequisitionssummaryAttributes
ProjectId Decimal ProjectId of PurchaseRequisitionssummaryAttributes
ProjectNumber String ProjectNumber of PurchaseRequisitionssummaryAttributes
ProjectName String ProjectName of PurchaseRequisitionssummaryAttributes
CategoryId Long CategoryId of PurchaseRequisitionssummaryAttributes
SameCategoryIdFlag Bool SameCategoryIdFlag of PurchaseRequisitionssummaryAttributes
VendorId Long VendorId of PurchaseRequisitionssummaryAttributes
SameVendorIdFlag Bool SameVendorIdFlag of PurchaseRequisitionssummaryAttributes
RequesterId Long RequesterId of PurchaseRequisitionssummaryAttributes
Requester String Requester of PurchaseRequisitionssummaryAttributes
SameRequesterIdFlag Bool SameRequesterIdFlag of PurchaseRequisitionssummaryAttributes
DestinationTypeCode String DestinationTypeCode of PurchaseRequisitionssummaryAttributes
SameDestinationTypeCodeFlag Bool SameDestinationTypeCodeFlag of PurchaseRequisitionssummaryAttributes
AccountUserOverrideFlag Bool AccountUserOverrideFlag of PurchaseRequisitionssummaryAttributes
SameAccountUserOverrideFlag Bool SameAccountUserOverrideFlag of PurchaseRequisitionssummaryAttributes
TaskNumber String TaskNumber of PurchaseRequisitionssummaryAttributes
TaskName String TaskName of PurchaseRequisitionssummaryAttributes
ProjectsInformationAcrossLines String ProjectsInformationAcrossLines of PurchaseRequisitionssummaryAttributes
TotalIMTLinesCount Decimal TotalIMTLinesCount of PurchaseRequisitionssummaryAttributes
UnprocessedIMTLinesCount Decimal UnprocessedIMTLinesCount of PurchaseRequisitionssummaryAttributes
ContainsNoneditableLinesFlag Bool ContainsNoneditableLinesFlag of PurchaseRequisitionssummaryAttributes
SameDestinationOrganizationIdFlag Bool SameDestinationOrganizationIdFlag of PurchaseRequisitionssummaryAttributes
SameDestinationSubinventoryFlag Bool SameDestinationSubinventoryFlag of PurchaseRequisitionssummaryAttributes
HasOneTimeLocAcrossLinesFlag Bool HasOneTimeLocAcrossLinesFlag of PurchaseRequisitionssummaryAttributes
HasAllMasterItemsFlag Bool HasAllMasterItemsFlag of PurchaseRequisitionssummaryAttributes
MaximumSequenceNumber Long MaximumSequenceNumber of PurchaseRequisitionssummaryAttributes
BindPreparerId Long BindPreparerId of PurchaseRequisitionssummaryAttributes
Finder String Finder of PurchaseRequisitionssummaryAttributes

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060