Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

PurchaseRequisitionslines

The Lines resource manages items to be requisitioned, their quantity, unit of measure, price, and deliver-to-location information.

Table Specific Information

Select

The 本製品 uses the Oracle Fusion Cloud Financials API to process some of the filters having queryable=true in metadata. The 本製品 processes other filters within the 本製品.

For example, the following query is processed server side:

SELECT * FROM [Cdata].[Procurement].[PurchaseRequisitionsLines] WHERE RequisitionLineId=300000294334273

Insert

Create an PurchaseRequisitionsLine. PurchaseRequisitionsUniqId is used to uniquely identify the PurchaseRequisition.

You need to provide PurchaseRequisitionsUniqId, instead of PurchaseRequisitionsRequisitionHeaderId , to insert the record.

INSERT into PurchaseRequisitionsLines(PurchaseRequisitionsUniqId,LineNumber,LineTypeId,ItemDescription,Quantity,UOMCode,UOM,Price,CurrencyCode,DestinationOrganizationId,DeliverToLocationId,DestinationTypeCode,RequesterId,CategoryName,RequestedDeliveryDate) values (300000294334268,2,1,'TestSS Item from POST',10,'zzu','Ea',10,'USD',300000047274444,300000047013200,'EXPENSE',300000047340498,'Toilet Paper','2025-02-26')

Update

The Oracle Fusion Cloud Financials API uses PurchaseRequisitionsUniqId instead of PurchaseRequisitionsRequisitionHeaderId and RequisitionLineUniqId instead of RequisitionLineId as a path parameter in the URL to update the record.

If you want to update a record directly using the id (without any other filter), you can update the record in the following way:

Update [Cdata].[Procurement].[PurchaseRequisitionsLines] set Quantity=45 where RequisitionLineUniqId=454545454 and PurchaseRequisitionsUniqID=545;

Note: This does not require any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please use RequisitionLineId instead of RequisitionLineUniqId and PurchaseRequisitionsRequisitionHeaderId instead of PurchaseRequisitionsUniqId. You can update the record in the following way:

Update [Cdata].[Procurement].[PurchaseRequisitionsLines] set Quantity=45 where PurchaseRequisitionsRequisitionHeaderId=545 and Quantity=4

Note : Update on aggregates are not allowed by API, use the child tables to add/update/delete aggregates.

Delete

The Oracle Fusion Cloud Financials API uses PurchaseRequisitionsUniqId instead of PurchaseRequisitionsRequisitionHeaderId and RequisitionLineUniqId instead of RequisitionLineId as a path parameter in the URL to delete the record.

If you want to delete a record directly using the id (without any other filter), you can delete the record in the following way:

Delete from [Cdata].[Procurement].[PurchaseRequisitionsLines] where RequisitionLineUniqId=454545454 and PurchaseRequisitionsUniqID=545;

Note: This does not require any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please use RequisitionLineId instead of RequisitionLineUniqId and PurchaseRequisitionsRequisitionHeaderId instead of PurchaseRequisitionsUniqId. You can delete the record in the following way:

Delete from [Cdata].[Procurement].[PurchaseRequisitionsLines] where PurchaseRequisitionsRequisitionHeaderId=545 and Quantity=4

Columns

Name Type ReadOnly Description
PurchaseRequisitionsRequisitionHeaderId [KEY] Long True

PurchaseRequisitionsRequisitionHeaderId of PurchaseRequisitionslines

PurchaseRequisitionsUniqId [KEY] String True

Use this column's value for insert, update and delete operations, wherever applicable, instead of purchaseRequisitionsRequisitionHeaderId.

RequisitionHeaderId Long True

RequisitionHeaderId of PurchaseRequisitionslines

RequisitionLineId [KEY] Long True

RequisitionLineId of PurchaseRequisitionslines

RequisitionLineUniqId [KEY] String True

Use this column's value in insert, update and delete operations, wherever applicable, instead of RequisitionLineId

LineNumber Decimal False

LineNumber of PurchaseRequisitionslines

SmartFormId Long False

SmartFormId of PurchaseRequisitionslines

SmartFormName String False

SmartFormName of PurchaseRequisitionslines

ParentRequisitionLineId Long True

ParentRequisitionLineId of PurchaseRequisitionslines

LineTypeId Long False

LineTypeId of PurchaseRequisitionslines

LineTypeCode String False

LineTypeCode of PurchaseRequisitionslines

LineType String True

LineType of PurchaseRequisitionslines

RequisitionLineSource String False

RequisitionLineSource of PurchaseRequisitionslines

CategoryId Long False

CategoryId of PurchaseRequisitionslines

CategoryName String False

CategoryName of PurchaseRequisitionslines

ItemDescription String False

ItemDescription of PurchaseRequisitionslines

ItemId Long False

ItemId of PurchaseRequisitionslines

Item String False

Item of PurchaseRequisitionslines

ItemRevision String False

ItemRevision of PurchaseRequisitionslines

Quantity Decimal False

Quantity of PurchaseRequisitionslines

SecondaryQuantity Decimal False

SecondaryQuantity of PurchaseRequisitionslines

UnitPrice Decimal False

UnitPrice of PurchaseRequisitionslines

CurrencyCode String False

CurrencyCode of PurchaseRequisitionslines

Currency String False

Currency of PurchaseRequisitionslines

UOMCode String False

UOMCode of PurchaseRequisitionslines

UOM String False

UOM of PurchaseRequisitionslines

SecondaryUOMCode String True

SecondaryUOMCode of PurchaseRequisitionslines

SecondaryUOM String True

SecondaryUOM of PurchaseRequisitionslines

ConversionRateType String False

ConversionRateType of PurchaseRequisitionslines

UserConversionRateType String True

UserConversionRateType of PurchaseRequisitionslines

ConversionRateDate Date False

ConversionRateDate of PurchaseRequisitionslines

ConversionRate Decimal False

ConversionRate of PurchaseRequisitionslines

Price Decimal False

Price of PurchaseRequisitionslines

LineStatus String True

LineStatus of PurchaseRequisitionslines

LineStatusDisplayValue String True

LineStatusDisplayValue of PurchaseRequisitionslines

Amount Decimal True

Amount of PurchaseRequisitionslines

CurrencyAmount Decimal False

CurrencyAmount of PurchaseRequisitionslines

UrgentFlag Bool False

UrgentFlag of PurchaseRequisitionslines

NegotiatedByPreparerFlag Bool False

NegotiatedByPreparerFlag of PurchaseRequisitionslines

NegotiationRequiredFlag Bool False

NegotiationRequiredFlag of PurchaseRequisitionslines

ProcurementCardFlag Bool False

ProcurementCardFlag of PurchaseRequisitionslines

SourceAgreementTypeCode String False

SourceAgreementTypeCode of PurchaseRequisitionslines

SourceAgreementType String True

SourceAgreementType of PurchaseRequisitionslines

SourceAgreementHeaderId Long False

SourceAgreementHeaderId of PurchaseRequisitionslines

SourceAgreement String False

SourceAgreement of PurchaseRequisitionslines

SourceAgreementLineId Long False

SourceAgreementLineId of PurchaseRequisitionslines

SourceAgreementLineNumber Decimal False

SourceAgreementLineNumber of PurchaseRequisitionslines

UNNumberId Long False

UNNumberId of PurchaseRequisitionslines

UNNumber String True

UNNumber of PurchaseRequisitionslines

HazardClassId Long False

HazardClassId of PurchaseRequisitionslines

HazardClass String True

HazardClass of PurchaseRequisitionslines

HazardClassCode String True

HazardClassCode of PurchaseRequisitionslines

UNSPSCCode String False

UNSPSCCode of PurchaseRequisitionslines

ManufacturerName String False

ManufacturerName of PurchaseRequisitionslines

ManufacturerPartNumber String False

ManufacturerPartNumber of PurchaseRequisitionslines

BPAPriceUserOverrideFlag Bool True

BPAPriceUserOverrideFlag of PurchaseRequisitionslines

NewSupplierFlag Bool False

NewSupplierFlag of PurchaseRequisitionslines

SupplierId Long False

SupplierId of PurchaseRequisitionslines

Supplier String False

Supplier of PurchaseRequisitionslines

SupplierSiteId Long False

SupplierSiteId of PurchaseRequisitionslines

SupplierSite String False

SupplierSite of PurchaseRequisitionslines

SupplierContactId Long False

SupplierContactId of PurchaseRequisitionslines

SupplierContact String False

SupplierContact of PurchaseRequisitionslines

SupplierContactEmail String True

SupplierContactEmail of PurchaseRequisitionslines

SupplierContactPhone String True

SupplierContactPhone of PurchaseRequisitionslines

SupplierContactFax String True

SupplierContactFax of PurchaseRequisitionslines

AdditionalContactEmail String False

AdditionalContactEmail of PurchaseRequisitionslines

SuggestedSupplier String False

SuggestedSupplier of PurchaseRequisitionslines

SuggestedSupplierSite String False

SuggestedSupplierSite of PurchaseRequisitionslines

SuggestedSupplierContact String False

SuggestedSupplierContact of PurchaseRequisitionslines

SuggestedSupplierContactPhone String False

SuggestedSupplierContactPhone of PurchaseRequisitionslines

SuggestedSupplierContactFax String False

SuggestedSupplierContactFax of PurchaseRequisitionslines

SuggestedSupplierContactEmail String False

SuggestedSupplierContactEmail of PurchaseRequisitionslines

SupplierItemNumber String False

SupplierItemNumber of PurchaseRequisitionslines

RequesterId Long False

RequesterId of PurchaseRequisitionslines

Requester String True

Requester of PurchaseRequisitionslines

RequesterDisplayName String True

RequesterDisplayName of PurchaseRequisitionslines

RequesterEmail String False

RequesterEmail of PurchaseRequisitionslines

SuggestedBuyerId Long False

SuggestedBuyerId of PurchaseRequisitionslines

SuggestedBuyer String True

SuggestedBuyer of PurchaseRequisitionslines

SuggestedBuyerEmail String False

SuggestedBuyerEmail of PurchaseRequisitionslines

ModifiedByBuyerId Long True

ModifiedByBuyerId of PurchaseRequisitionslines

ModifiedByBuyer String True

ModifiedByBuyer of PurchaseRequisitionslines

AssignedBuyerId Long True

AssignedBuyerId of PurchaseRequisitionslines

AssignedBuyer String True

AssignedBuyer of PurchaseRequisitionslines

AssignedBuyerDisplayName String True

AssignedBuyerDisplayName of PurchaseRequisitionslines

AssignedBuyerEmail String True

AssignedBuyerEmail of PurchaseRequisitionslines

RequestedDeliveryDate Date False

RequestedDeliveryDate of PurchaseRequisitionslines

DestinationTypeCode String False

DestinationTypeCode of PurchaseRequisitionslines

DestinationType String False

DestinationType of PurchaseRequisitionslines

DestinationOrganizationId Long False

DestinationOrganizationId of PurchaseRequisitionslines

DestinationOrganizationCode String False

DestinationOrganizationCode of PurchaseRequisitionslines

DestinationOrganization String True

DestinationOrganization of PurchaseRequisitionslines

DestinationSubinventory String False

DestinationSubinventory of PurchaseRequisitionslines

OneTimeLocationFlag Bool True

OneTimeLocationFlag of PurchaseRequisitionslines

DeliverToLocationId Long False

DeliverToLocationId of PurchaseRequisitionslines

DeliverToLocationCode String False

DeliverToLocationCode of PurchaseRequisitionslines

DeliverToAddress String True

DeliverToAddress of PurchaseRequisitionslines

FormattedDeliverToAddress String True

FormattedDeliverToAddress of PurchaseRequisitionslines

NoteToBuyer String False

NoteToBuyer of PurchaseRequisitionslines

NoteToReceiver String False

NoteToReceiver of PurchaseRequisitionslines

NoteToSupplier String False

NoteToSupplier of PurchaseRequisitionslines

RequisitionLineInPool String True

RequisitionLineInPool of PurchaseRequisitionslines

POAutomationFailedReasonCode String True

POAutomationFailedReasonCode of PurchaseRequisitionslines

POAutomationFailedReason String True

POAutomationFailedReason of PurchaseRequisitionslines

POHeaderId Long True

POHeaderId of PurchaseRequisitionslines

POLineId Long True

POLineId of PurchaseRequisitionslines

PurchaseOrder String True

PurchaseOrder of PurchaseRequisitionslines

POBuyerId Long True

POBuyerId of PurchaseRequisitionslines

BuyerOnPurchaseOrder String True

BuyerOnPurchaseOrder of PurchaseRequisitionslines

SupplierOnPurchaseOrder String True

SupplierOnPurchaseOrder of PurchaseRequisitionslines

ProcurementBUId Long True

ProcurementBUId of PurchaseRequisitionslines

ProcurementBU String True

ProcurementBU of PurchaseRequisitionslines

SourceTypeCode String False

SourceTypeCode of PurchaseRequisitionslines

SourceType String False

SourceType of PurchaseRequisitionslines

SourceOrganizationId Long False

SourceOrganizationId of PurchaseRequisitionslines

SourceOrganizationCode String False

SourceOrganizationCode of PurchaseRequisitionslines

SourceOrganization String True

SourceOrganization of PurchaseRequisitionslines

SourceSubinventory String False

SourceSubinventory of PurchaseRequisitionslines

TransferOrderHeaderId Long True

TransferOrderHeaderId of PurchaseRequisitionslines

TransferOrder String True

TransferOrder of PurchaseRequisitionslines

TransferOrderLineId Long True

TransferOrderLineId of PurchaseRequisitionslines

NegotiationHeaderId Long True

NegotiationHeaderId of PurchaseRequisitionslines

Negotiation String True

Negotiation of PurchaseRequisitionslines

NegotiationLineNumber Decimal True

NegotiationLineNumber of PurchaseRequisitionslines

ResponseNumber Decimal True

ResponseNumber of PurchaseRequisitionslines

ResponseLineNumber Decimal True

ResponseLineNumber of PurchaseRequisitionslines

OnNegotiationFlag Bool True

OnNegotiationFlag of PurchaseRequisitionslines

WorkOrderId Long True

WorkOrderId of PurchaseRequisitionslines

WorkOrder String True

WorkOrder of PurchaseRequisitionslines

WorkOrderOperationId Long True

WorkOrderOperationId of PurchaseRequisitionslines

WorkOrderOperationSequence Decimal True

WorkOrderOperationSequence of PurchaseRequisitionslines

WorkOrderProduct String True

WorkOrderProduct of PurchaseRequisitionslines

WorkOrderSubType String True

WorkOrderSubType of PurchaseRequisitionslines

BackToBackFlag Bool True

BackToBackFlag of PurchaseRequisitionslines

ConfiguredItemFlag Bool True

ConfiguredItemFlag of PurchaseRequisitionslines

DeliverToCustomerId Long True

DeliverToCustomerId of PurchaseRequisitionslines

DeliverToCustomer String True

DeliverToCustomer of PurchaseRequisitionslines

DeliverToCustomerLocationId Long False

DeliverToCustomerLocationId of PurchaseRequisitionslines

RequestedShipDate Date True

RequestedShipDate of PurchaseRequisitionslines

SalesOrderLineNumber String True

SalesOrderLineNumber of PurchaseRequisitionslines

SalesOrder String True

SalesOrder of PurchaseRequisitionslines

SalesOrderScheduleNumber String True

SalesOrderScheduleNumber of PurchaseRequisitionslines

ShipToCustomerId Long True

ShipToCustomerId of PurchaseRequisitionslines

ShipToCustomer String True

ShipToCustomer of PurchaseRequisitionslines

ServiceLevelCode String True

ServiceLevelCode of PurchaseRequisitionslines

ServiceLevel String True

ServiceLevel of PurchaseRequisitionslines

ModeOfTransportCode String True

ModeOfTransportCode of PurchaseRequisitionslines

ModeOfTransport String True

ModeOfTransport of PurchaseRequisitionslines

CarrierId Long True

CarrierId of PurchaseRequisitionslines

Carrier String True

Carrier of PurchaseRequisitionslines

CreatedBy String True

CreatedBy of PurchaseRequisitionslines

CreationDate Datetime True

CreationDate of PurchaseRequisitionslines

LastUpdatedBy String True

LastUpdatedBy of PurchaseRequisitionslines

LastUpdateDate Datetime True

LastUpdateDate of PurchaseRequisitionslines

LastSubmittedDate Datetime True

LastSubmittedDate of PurchaseRequisitionslines

LastApprovalDate Datetime True

LastApprovalDate of PurchaseRequisitionslines

OriginalSubmittedDate Datetime True

OriginalSubmittedDate of PurchaseRequisitionslines

OriginalApprovalDate Datetime True

OriginalApprovalDate of PurchaseRequisitionslines

CancelDate Date True

CancelDate of PurchaseRequisitionslines

CancelReason String True

CancelReason of PurchaseRequisitionslines

RequisitionLinePOInstanceId Long True

RequisitionLinePOInstanceId of PurchaseRequisitionslines

BuyerProcessingFlag Bool True

BuyerProcessingFlag of PurchaseRequisitionslines

RequisitionLineGroup String True

RequisitionLineGroup of PurchaseRequisitionslines

ProductType String False

ProductType of PurchaseRequisitionslines

ProductTypeCode String False

ProductTypeCode of PurchaseRequisitionslines

LineImageURL String True

LineImageURL of PurchaseRequisitionslines

SupplierItemAuxiliaryId String False

SupplierItemAuxiliaryId of PurchaseRequisitionslines

DisableAutosourceFlag Bool False

DisableAutosourceFlag of PurchaseRequisitionslines

DeliverToOneTimeAddress String True

DeliverToOneTimeAddress of PurchaseRequisitionslines

LineTypeOrderTypeLookupCode String True

LineTypeOrderTypeLookupCode of PurchaseRequisitionslines

ReturnedByBuyerId Long True

ReturnedByBuyerId of PurchaseRequisitionslines

ReturnedByBuyerDisplayName String True

ReturnedByBuyerDisplayName of PurchaseRequisitionslines

ReturnReason String True

ReturnReason of PurchaseRequisitionslines

LifecycleStatusCode String True

LifecycleStatusCode of PurchaseRequisitionslines

LifecycleStatus String True

LifecycleStatus of PurchaseRequisitionslines

ActionRequiredCode String True

ActionRequiredCode of PurchaseRequisitionslines

ActionRequired String True

ActionRequired of PurchaseRequisitionslines

POCancelReason String True

POCancelReason of PurchaseRequisitionslines

POHoldReason String True

POHoldReason of PurchaseRequisitionslines

PublicShoppingListHeaderId Long False

PublicShoppingListHeaderId of PurchaseRequisitionslines

InformationTemplateTouchedFlag Bool False

InformationTemplateTouchedFlag of PurchaseRequisitionslines

FundsStatusCode String True

FundsStatusCode of PurchaseRequisitionslines

FundsStatus String True

FundsStatus of PurchaseRequisitionslines

LifecycleSecondaryStatus String True

LifecycleSecondaryStatus of PurchaseRequisitionslines

ItemUserOverrideFlag Bool False

ItemUserOverrideFlag of PurchaseRequisitionslines

BPADescriptionUserOverrideFlag Bool True

BPADescriptionUserOverrideFlag of PurchaseRequisitionslines

EPPLineId Long False

EPPLineId of PurchaseRequisitionslines

MarketplaceItemId String False

MarketplaceItemId of PurchaseRequisitionslines

ConcatTransactionBusinessCategoryCode String False

ConcatTransactionBusinessCategoryCode of PurchaseRequisitionslines

TransactionBusinessCategory String False

TransactionBusinessCategory of PurchaseRequisitionslines

TransactionBusinessCategoryCode String False

TransactionBusinessCategoryCode of PurchaseRequisitionslines

TaxationCountryCode String True

TaxationCountryCode of PurchaseRequisitionslines

ConcatDocumentFiscalClassificationCode String True

ConcatDocumentFiscalClassificationCode of PurchaseRequisitionslines

ProductFiscalClassificationCode String False

ProductFiscalClassificationCode of PurchaseRequisitionslines

ProductFiscalClassificationId Long False

ProductFiscalClassificationId of PurchaseRequisitionslines

ConcatProductCategoryCode String False

ConcatProductCategoryCode of PurchaseRequisitionslines

IntendedUseCode String False

IntendedUseCode of PurchaseRequisitionslines

IntendedUseId Long False

IntendedUseId of PurchaseRequisitionslines

UserDefinedFiscalClassificationCode String False

UserDefinedFiscalClassificationCode of PurchaseRequisitionslines

TaxClassificationCode String False

TaxClassificationCode of PurchaseRequisitionslines

AssessableValue Decimal False

AssessableValue of PurchaseRequisitionslines

FirstPartyTaxRegId Long False

FirstPartyTaxRegId of PurchaseRequisitionslines

ThirdPartyTaxRegId Long False

ThirdPartyTaxRegId of PurchaseRequisitionslines

LocationOfFinalDischargeId Long False

LocationOfFinalDischargeId of PurchaseRequisitionslines

LocationOfFinalDischargeCode String True

LocationOfFinalDischargeCode of PurchaseRequisitionslines

FirstPartyTaxRegNumber String True

FirstPartyTaxRegNumber of PurchaseRequisitionslines

CostCenter String True

CostCenter of PurchaseRequisitionslines

IntendedUse String False

IntendedUse of PurchaseRequisitionslines

ProductFiscalClassification String False

ProductFiscalClassification of PurchaseRequisitionslines

ThirdPartyTaxRegNumber String False

ThirdPartyTaxRegNumber of PurchaseRequisitionslines

UserDefinedFiscalClassification String False

UserDefinedFiscalClassification of PurchaseRequisitionslines

DocumentFiscalClassificationCode String True

DocumentFiscalClassificationCode of PurchaseRequisitionslines

DocumentFiscalClassification String True

DocumentFiscalClassification of PurchaseRequisitionslines

TaxationCountry String True

TaxationCountry of PurchaseRequisitionslines

ProductCategory String False

ProductCategory of PurchaseRequisitionslines

ProductCategoryCode String False

ProductCategoryCode of PurchaseRequisitionslines

TaxClassification String False

TaxClassification of PurchaseRequisitionslines

TaxAttrsUserOverrideLineFlag Bool True

TaxAttrsUserOverrideLineFlag of PurchaseRequisitionslines

SuggestedPrcBUId Long False

SuggestedPrcBUId of PurchaseRequisitionslines

informationTemplates String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

DFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

specialHandlingDFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

distributions String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

BindPreparerId Long True

bindpreparerid

BindRequisitionHeaderId Long True

bindrequisitionheaderid

Finder String True

finder

CUReferenceNumber Int False

Maps the child aggregates with Parent tables.

EffectiveDate Date True

This query parameter is used to fetch resources which are effective dated as of the specified start date.

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