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. |