ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

PurchaseRequisitionslines

Displays item-level details (part, quantity, pricing) for each line in the requisition, forming the basis for purchasing decisions.

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

The unique identifier for the requisition header associated with this requisition line. This field links the line to the overall requisition. Example: 1001 for requisition ID 1001.

PurchaseRequisitionsUniqId [KEY] String True

A unique identifier for the requisition. It is used for insert, update, and delete operations in place of the RequisitionHeaderId. Example: 'REQ1001' could be a unique ID.

RequisitionHeaderId Long True

The identifier for the requisition header associated with this requisition line. This value connects the requisition line to the requisition it belongs to. Example: 12345.

RequisitionLineId [KEY] Long True

A unique identifier for the individual requisition line. This is used to track a specific item or service requested in the requisition. Example: 001 for line 1 in the requisition.

RequisitionLineUniqId [KEY] String True

A unique identifier for the requisition line. Used instead of RequisitionLineId for insert, update, and delete operations. Example: 'LINE1001'.

LineNumber Decimal False

The sequential number assigned to the requisition line. It helps in ordering and referencing the requisition lines. Example: 1 for the first line, 2 for the second.

SmartFormId Long False

The identifier for the SmartForm associated with the requisition line. A SmartForm can help streamline data entry or automate processes. Example: 456 for a custom SmartForm.

SmartFormName String False

The name of the SmartForm associated with this requisition line, used for identifying and organizing forms. Example: 'Basic Requisition Form'.

ParentRequisitionLineId Long True

The identifier for the parent requisition line, used when there are dependent or related lines within the same requisition. Example: 1001 for the main item in the requisition.

LineTypeId Long False

The identifier for the line type of the requisition. This could categorize the line as a product, service, or another category. Example: 2 for a service line.

LineTypeCode String False

The code representing the requisition line type, helping to classify the line (for example, 'PROD' for products or 'SRVC' for services). Example: 'SRVC'.

LineType String True

A human-readable description of the requisition line type. This helps distinguish between different types of requisition lines. Example: 'Service' or 'Product'.

RequisitionLineSource String False

The source from which the requisition line originated. It could be manually created or sourced from an agreement or catalog. Example: 'Manual' or 'Catalog'.

CategoryId Long False

The unique identifier for the category to which the requisition line belongs. Categories help in grouping items or services in the requisition. Example: 1001 for 'Office Supplies'.

CategoryName String False

The name of the category for the requisition line. This is used for easier classification and reporting. Example: 'Electronics'.

ItemDescription String False

A description of the item or service being requested. This provides more details on what is being requisitioned. Example: 'Laptop computer with 15-inch screen'.

ItemId Long False

The unique identifier for the item in the item catalog. This links the requisition line to the item being requested. Example: 1234 for a specific product in the catalog.

Item String False

The name or code of the item requested. This can be a short, recognizable description. Example: 'Laptop' or 'Office Chair'.

ItemRevision String False

The revision number for the item, indicating if it has been updated or changed. Example: 'Rev A' or 'Rev B'.

Quantity Decimal False

The quantity of the item or service requested. This determines how many units are needed. Example: 10 for ten laptops.

SecondaryQuantity Decimal False

An optional field to capture a secondary quantity in a different unit of measure. For example, if you order 10 boxes, this field could capture the quantity in individual items (for example, 100 items per box). Example: 100 for 10 boxes containing 100 units each.

UnitPrice Decimal False

The price per unit of the item or service being requested. This field reflects the negotiated or catalog price per unit. Example: 500 for $500 per laptop.

CurrencyCode String False

The currency code used for pricing in this requisition line, such as USD for US Dollars or EUR for Euros. Example: 'USD'.

Currency String False

The full name of the currency used in the requisition line. Example: 'US Dollar' or 'Euro'.

UOMCode String False

The unit of measure code that represents how the quantity is measured (for example, 'EA' for each, 'BOX' for box). Example: 'EA' for each.

UOM String False

The unit of measure that describes the quantity measurement. It could be 'Each', 'Box', or other units depending on the item. Example: 'Each'.

SecondaryUOMCode String True

The unit of measure code for the secondary quantity if applicable. This might be used for alternate units like weight or volume. Example: 'KG' for kilograms.

SecondaryUOM String True

The unit of measure for the secondary quantity. For example, you could specify weight in kilograms for an item that is ordered by each. Example: 'KG' for kilograms.

ConversionRateType String False

The type of conversion rate applied to convert between different currencies or units of measure. Example: 'Spot Rate' for current exchange rates.

UserConversionRateType String True

The conversion rate type manually selected by the user, allowing for overrides. Example: 'User-Defined'.

ConversionRateDate Date False

The date the conversion rate is based on. This ensures the rate applies to the correct time period. Example: '2023-12-01'.

ConversionRate Decimal False

The rate at which quantities or currencies are converted. Example: 1.25 for converting USD to EUR.

Price Decimal False

The price at which the item is being requisitioned. This could reflect the standard price or a negotiated price. Example: 200 for $200 per item.

LineStatus String True

The current status of the requisition line, such as 'Open', 'Approved', or 'Closed'. Example: 'Open'.

LineStatusDisplayValue String True

A user-friendly value for displaying the line status in the system. This may provide more readable options than the status code. Example: 'Pending Approval'.

Amount Decimal True

The total amount for the requisition line, calculated as Quantity x UnitPrice. Example: 5000 for 10 units at $500 each.

CurrencyAmount Decimal False

The amount for the requisition line expressed in the specified currency. Example: 5000 for 10 units at $500 each in USD.

UrgentFlag Bool False

Indicates whether the requisition line is marked as urgent, requiring expedited processing. Example: True for urgent items, False for regular items.

NegotiatedByPreparerFlag Bool False

Indicates whether the requisition line price has been negotiated by the preparer. Example: True for negotiated prices.

NegotiationRequiredFlag Bool False

Indicates whether the requisition line requires negotiation before approval. Example: True for items requiring special pricing or terms.

ProcurementCardFlag Bool False

Indicates whether the requisition line will be paid using a procurement card. Example: True if using a corporate procurement card.

SourceAgreementTypeCode String False

The code representing the type of source agreement for the requisition line. This helps identify whether the line is sourced from a blanket agreement, contract, or other sources. Example: 'BPA' for Blanket Purchase Agreement.

SourceAgreementType String True

A human-readable description of the source agreement type for the requisition line. Example: 'Contract' or 'Blanket Purchase Agreement'.

SourceAgreementHeaderId Long False

The unique identifier for the source agreement header related to the requisition line. This links the requisition line to the original source agreement. Example: 1234 for the blanket agreement.

SourceAgreement String False

The name or description of the source agreement, which is the origin of the requisition line. Example: 'Office Supplies Contract'.

SourceAgreementLineId Long False

The unique identifier for the line within the source agreement associated with the requisition line. Example: 001 for the first line item in the source agreement.

SourceAgreementLineNumber Decimal False

The line number within the source agreement related to the requisition line. This helps track which specific line of the source agreement is being referenced. Example: 1 for the first line.

UNNumberId Long False

The unique identifier for the UN number associated with the requisition line. This is used for hazardous materials and safety classification. Example: 789 for a specific hazardous material.

UNNumber String True

The UN number associated with the requisition line, identifying dangerous goods for compliance purposes. Example: 'UN1234' for a specific hazardous material.

HazardClassId Long False

The identifier for the hazard class of the requisition line item, used for safety and regulatory purposes. Example: 10 for flammable liquids.

HazardClass String True

The name or classification of the hazard associated with the requisition line, for example, 'Flammable' or 'Corrosive'.

HazardClassCode String True

The code representing the hazard class of the requisition line. This is used in regulatory reporting and classification. Example: 'FL' for flammable materials.

UNSPSCCode String False

The UNSPSC (United Nations Standard Products and Services Code) for the requisition line, used for categorizing goods and services. Example: '43211504' for computers.

ManufacturerName String False

The name of the manufacturer of the item in the requisition line. This helps identify the supplier of the item. Example: 'HP' for Hewlett Packard.

ManufacturerPartNumber String False

The manufacturer's part number for the item, used for tracking specific products. Example: 'HP1234' for a laptop part number.

BPAPriceUserOverrideFlag Bool True

Indicates whether the user has overridden the price from the Blanket Purchase Agreement (BPA) for the requisition line. Example: True if the price was adjusted.

NewSupplierFlag Bool False

Indicates whether the supplier for this requisition line is new. This can help track new supplier relationships. Example: True if the supplier is newly onboarded.

SupplierId Long False

The unique identifier for the supplier associated with the requisition line. This links the requisition to the supplier’s details. Example: 1001 for 'ABC Supplies'.

Supplier String False

The name of the supplier for the requisition line. Example: 'XYZ Electronics' or 'Global Supplies'.

SupplierSiteId Long False

The unique identifier for the supplier site associated with the requisition line, used to track where goods or services are provided. Example: 001 for 'XYZ Electronics - NY'.

SupplierSite String False

The name or code of the supplier site, which refers to the specific location of the supplier. Example: 'XYZ Electronics - LA'.

SupplierContactId Long False

The unique identifier for the supplier contact associated with the requisition line, used for communication. Example: 5678 for the main contact person.

SupplierContact String False

The name of the supplier contact for the requisition line, used to communicate about the order. Example: 'John Doe' or 'Sarah Smith'.

SupplierContactEmail String True

The email address of the supplier contact for the requisition line, used for official correspondence. Example: '[email protected]'.

SupplierContactPhone String True

The phone number of the supplier contact for the requisition line, used for communication. Example: '(555) 123-4567'.

SupplierContactFax String True

The fax number of the supplier contact for the requisition line, if applicable. Example: '(555) 987-6543'.

AdditionalContactEmail String False

An additional email address for contacting the supplier, used for backups or secondary communication. Example: '[email protected]'.

SuggestedSupplier String False

The name of the suggested supplier for the requisition line, often used when the original supplier is unavailable. Example: 'ABC Corp' as an alternative to 'XYZ Electronics'.

SuggestedSupplierSite String False

The name of the suggested supplier site for the requisition line, used when recommending a different location for fulfillment. Example: 'ABC Corp - NY'.

SuggestedSupplierContact String False

The name of the suggested supplier contact for the requisition line, used for managing supplier relationships. Example: 'Jane Doe' for an alternative supplier contact.

SuggestedSupplierContactPhone String False

The phone number of the suggested supplier contact, used to manage communication. Example: '(555) 444-5678'.

SuggestedSupplierContactFax String False

The fax number of the suggested supplier contact, if applicable. Example: '(555) 444-5679'.

SuggestedSupplierContactEmail String False

The email address of the suggested supplier contact, used for backup communication. Example: '[email protected]'.

SupplierItemNumber String False

The item number assigned by the supplier for the requisition line, used for item identification. Example: 'ABC123' for a specific part number.

RequesterId Long False

The unique identifier for the requester who initiated the requisition line. This links the requisition line to the individual who made the request. Example: 2345 for 'John Doe'.

Requester String True

The name of the requester who created the requisition line. Example: 'Jane Smith'.

RequesterDisplayName String True

The display name of the requester, which may be formatted differently for easier display. Example: 'Jane S.'

RequesterEmail String False

The email address of the requester, used for notifications and correspondence. Example: '[email protected]'.

SuggestedBuyerId Long False

The unique identifier for the suggested buyer for the requisition line. Example: 3456 for 'Mike Johnson'.

SuggestedBuyer String True

The name of the suggested buyer for the requisition line, often used when a buyer needs to be assigned. Example: 'Mike Johnson'.

SuggestedBuyerEmail String False

The email address of the suggested buyer for the requisition line. Example: '[email protected]'.

ModifiedByBuyerId Long True

The unique identifier for the buyer who modified the requisition line. Example: 4567 for 'Sarah Lee'.

ModifiedByBuyer String True

The name of the buyer who last modified the requisition line. Example: 'Sarah Lee'.

AssignedBuyerId Long True

The unique identifier for the buyer assigned to the requisition line for further action. Example: 5678 for 'Alex Patel'.

AssignedBuyer String True

The name of the buyer assigned to manage the requisition line. Example: 'Alex Patel'.

AssignedBuyerDisplayName String True

The display name of the buyer assigned to the requisition line. Example: 'Alex P.'

AssignedBuyerEmail String True

The email address of the assigned buyer for the requisition line. Example: '[email protected]'.

RequestedDeliveryDate Date False

The requested date for delivering the item or service in the requisition line. Example: '2023-06-15'.

DestinationTypeCode String False

The code representing the destination type for the requisition line (for example, 'WARE' for warehouse, 'STOR' for store). Example: 'WARE'.

DestinationType String False

A description of the destination type for the requisition line. Example: 'Warehouse' or 'Store'.

DestinationOrganizationId Long False

The unique identifier for the organization where the requisition line’s items are to be delivered. Example: 123 for 'XYZ Corp'.

DestinationOrganizationCode String False

The code representing the destination organization. Example: 'XYZ'.

DestinationOrganization String True

The name or description of the destination organization for the requisition line. Example: 'XYZ Corp'.

DestinationSubinventory String False

The subinventory location within the destination organization where the requisition line’s items will be delivered. Example: 'Main Warehouse'.

OneTimeLocationFlag Bool True

Indicates whether the requisition line uses a one-time delivery location, typically for special or temporary addresses. Example: True if the delivery address is a one-time use address.

DeliverToLocationId Long False

The unique identifier for the location to which the requisition line’s items are to be delivered. Example: 789 for 'Main Office'.

DeliverToLocationCode String False

The code used to reference the specific delivery location for the requisition line. Example: 'NYC' for the New York office.

DeliverToAddress String True

The full address where the requisition line’s items will be delivered. Example: '123 Main St, New York, NY 10001'.

FormattedDeliverToAddress String True

A version of the delivery address formatted for display or printing. This is typically used for shipping or logistics. Example: '123 Main St, Suite 200, New York, NY 10001'.

NoteToBuyer String False

A note for the buyer associated with the requisition line, often containing special instructions or clarifications about the purchase. Example: 'Please prioritize this order for immediate shipment.'

NoteToReceiver String False

A note for the receiver of the requisition line’s items, typically containing handling or inspection instructions. Example: 'Inspect for damage before signing for receipt.'

NoteToSupplier String False

A note for the supplier providing the requisition line’s items, often containing additional order specifications. Example: 'Please ensure packaging is eco-friendly.'

RequisitionLineInPool String True

Indicates whether the requisition line is in a pool, awaiting further processing or approval. Example: 'Yes' if the line is in the approval pool.

POAutomationFailedReasonCode String True

The code representing the reason for failure in the purchase order automation process. This helps in troubleshooting automation issues. Example: 'PRICE_ERR' for pricing errors.

POAutomationFailedReason String True

A detailed description of why the purchase order automation failed for the requisition line. Example: 'Price mismatch with the supplier catalog'.

POHeaderId Long True

The unique identifier for the purchase order header created from the requisition line, used to track the PO associated with the requisition. Example: 10234 for 'PO10234'.

POLineId Long True

The unique identifier for the purchase order line associated with the requisition line, helping to link the requisition to the created purchase order. Example: 1 for the first line in the PO.

PurchaseOrder String True

The purchase order number generated for the requisition line. This number is used for tracking the order. Example: 'PO12345'.

POBuyerId Long True

The unique identifier for the buyer assigned to the purchase order for the requisition line. Example: 4001 for 'Alice Green'.

BuyerOnPurchaseOrder String True

The name of the buyer responsible for the purchase order generated from the requisition line. Example: 'Alice Green'.

SupplierOnPurchaseOrder String True

The name of the supplier listed on the purchase order associated with the requisition line. Example: 'ABC Electronics'.

ProcurementBUId Long True

The unique identifier for the procurement business unit handling the requisition line. Example: 5001 for 'Procurement Department'.

ProcurementBU String True

The name of the procurement business unit managing the requisition line. Example: 'Global Procurement'.

SourceTypeCode String False

The code representing the source type for the requisition line, such as 'Manual' for manually created requisitions or 'Catalog' for items selected from a catalog. Example: 'Manual'.

SourceType String False

The description of the source type for the requisition line, such as 'Manual' or 'Catalog'. Example: 'Catalog' for sourced items.

SourceOrganizationId Long False

The unique identifier for the source organization where the requisition line originated. Example: 2001 for 'North America Sales'.

SourceOrganizationCode String False

The code representing the source organization where the requisition line originated. Example: 'NAM' for North America.

SourceOrganization String True

The name or description of the organization from which the requisition line originated. Example: 'North America Sales'.

SourceSubinventory String False

The subinventory where the requisition line originates, used for inventory tracking. Example: 'Main Warehouse'.

TransferOrderHeaderId Long True

The unique identifier for the transfer order header associated with the requisition line, typically used for internal transfers. Example: 301 for 'Transfer Order 301'.

TransferOrder String True

The transfer order number associated with the requisition line, used to track internal inventory transfers. Example: 'TO123'.

TransferOrderLineId Long True

The unique identifier for the transfer order line related to the requisition line. Example: 1 for the first line in the transfer order.

NegotiationHeaderId Long True

The unique identifier for the negotiation header associated with the requisition line, indicating that the line was part of a negotiation process. Example: 400 for 'Neg-400'.

Negotiation String True

The description or name of the negotiation associated with the requisition line. Example: 'Supplier Negotiation for 2023 Electronics'.

NegotiationLineNumber Decimal True

The line number in the negotiation related to the requisition line. Example: 1 for the first line in the negotiation.

ResponseNumber Decimal True

The response number associated with the requisition line in a negotiation process, helping track different offers. Example: 1 for the first response.

ResponseLineNumber Decimal True

The line number of the response in the negotiation process. Example: 1 for the first line in the response.

OnNegotiationFlag Bool True

Indicates whether the requisition line is currently under negotiation. Example: True if the item is under negotiation for better terms.

WorkOrderId Long True

The unique identifier for the work order associated with the requisition line, used to track internal production or service orders. Example: 6001 for 'WO6001'.

WorkOrder String True

The work order number associated with the requisition line. Example: 'WO12345'.

WorkOrderOperationId Long True

The unique identifier for the operation in the work order associated with the requisition line. Example: 101 for 'Operation 1'.

WorkOrderOperationSequence Decimal True

The sequence number for the operation in the work order, used for tracking work order progress. Example: 1 for the first operation.

WorkOrderProduct String True

The product or service associated with the work order operation for the requisition line. Example: 'Custom Widget'.

WorkOrderSubType String True

The subtype of the work order related to the requisition line, used for additional classification of work order types. Example: 'Assembly'.

BackToBackFlag Bool True

Indicates whether the requisition line is linked to a back-to-back process, often used in supply chain to automatically create purchase orders from requisitions. Example: True if the line is back-to-back.

ConfiguredItemFlag Bool True

Indicates whether the requisition line is for a configured item that requires customization. Example: True for customized laptop configurations.

DeliverToCustomerId Long True

The unique identifier for the customer receiving the requisition line’s goods. Example: 7890 for 'Acme Corp'.

DeliverToCustomer String True

The name of the customer receiving the requisition line’s goods. Example: 'Acme Corp'.

DeliverToCustomerLocationId Long False

The location ID where the requisition line’s items are to be delivered, typically used for multiple customer locations. Example: 101 for 'Main Office'.

RequestedShipDate Date True

The requested date for shipping the requisition line’s items. Example: '2023-05-15'.

SalesOrderLineNumber String True

The sales order line number associated with the requisition line, helping to track sales orders and their requisitions. Example: 'SO1234-1'.

SalesOrder String True

The sales order number associated with the requisition line, linking the requisition to a customer order. Example: 'SO1234'.

SalesOrderScheduleNumber String True

The schedule number for the sales order associated with the requisition line. Example: 'SO1234-S1'.

ShipToCustomerId Long True

The unique identifier for the customer to whom the goods in the requisition line are shipped. Example: 12345 for 'XYZ Corp'.

ShipToCustomer String True

The name of the customer receiving the goods in the requisition line. Example: 'XYZ Corp'.

ServiceLevelCode String True

The code representing the service level agreement for the requisition line, indicating the level of service expected. Example: 'EXP' for expedited shipping.

ServiceLevel String True

The description of the service level associated with the requisition line. This could indicate the urgency or type of service provided. Example: 'Expedited' or 'Standard'.

ModeOfTransportCode String True

The code representing the mode of transport for the requisition line, used to track how the goods are delivered. Example: 'AIR' for air transport.

ModeOfTransport String True

The description of the transport mode for the requisition line. This provides details about how the goods are being delivered. Example: 'Air Freight' or 'Ground Shipping'.

CarrierId Long True

The unique identifier for the carrier responsible for transporting the requisition line’s goods. Example: 2001 for 'FedEx'.

Carrier String True

The name of the carrier responsible for shipping the requisition line’s goods. Example: 'FedEx' or 'UPS'.

CreatedBy String True

The username or identifier of the user who created the requisition line. Example: 'JohnDoe' or 'JaneSmith'.

CreationDate Datetime True

The date and time when the requisition line was created. This timestamp is important for tracking the requisition’s creation. Example: '2023-01-15 09:00:00'.

LastUpdatedBy String True

The username or identifier of the user who last updated the requisition line. Example: 'MikeBrown'.

LastUpdateDate Datetime True

The date and time when the requisition line was last modified. This helps track changes over time. Example: '2023-01-20 12:30:00'.

LastSubmittedDate Datetime True

The date and time when the requisition line was last submitted for approval. Example: '2023-01-18 10:00:00'.

LastApprovalDate Datetime True

The date and time when the requisition line was last approved. Example: '2023-01-19 14:30:00'.

OriginalSubmittedDate Datetime True

The original date and time when the requisition line was first submitted for approval. Example: '2023-01-15 09:00:00'.

OriginalApprovalDate Datetime True

The original date and time when the requisition line was first approved. Example: '2023-01-16 11:00:00'.

CancelDate Date True

The date when the requisition line was canceled, indicating the end of its process. Example: '2023-01-20'.

CancelReason String True

The reason for canceling the requisition line, providing context for the cancellation. Example: 'Budget Constraints'.

RequisitionLinePOInstanceId Long True

The unique identifier for the purchase order instance created from the requisition line. This helps link requisition lines to generated POs. Example: 12345.

BuyerProcessingFlag Bool True

Indicates whether the requisition line is being actively processed by the buyer. Example: True if the buyer is handling the line.

RequisitionLineGroup String True

A grouping identifier for requisition lines, often used to categorize lines with similar characteristics or processes. Example: 'Tech Equipment'.

ProductType String False

The type of product requested in the requisition line, helping to classify the type of goods or services. Example: 'Hardware' or 'Software'.

ProductTypeCode String False

The code used to represent the product type in the requisition line. Example: 'HW' for hardware or 'SW' for software.

LineImageURL String True

The URL linking to an image of the product associated with the requisition line. Example: 'http://example.com/product123.jpg'.

SupplierItemAuxiliaryId String False

An auxiliary identifier for the item assigned by the supplier, used for tracking products that may have additional identifiers. Example: 'AUX12345'.

DisableAutosourceFlag Bool False

Indicates whether autosourcing is disabled for the requisition line, preventing the system from automatically sourcing items. Example: True if autosourcing is turned off.

DeliverToOneTimeAddress String True

The address used for one-time deliveries. This is often used for special or temporary addresses. Example: '456 Temporary St, New York, NY'.

LineTypeOrderTypeLookupCode String True

The lookup code representing the order type for the requisition line, indicating the type of purchase or service. Example: 'PURCHASE' for a standard purchase order.

ReturnedByBuyerId Long True

The unique identifier for the buyer who returned the requisition line, usually due to issues with the order. Example: 7890 for 'Alice Green'.

ReturnedByBuyerDisplayName String True

The display name of the buyer who returned the requisition line. Example: 'Alice Green'.

ReturnReason String True

The reason provided for returning the requisition line, indicating why it was rejected or returned. Example: 'Incorrect Product'.

LifecycleStatusCode String True

The code representing the lifecycle status of the requisition line, which shows the current stage of processing. Example: 'OPEN', 'APPROVED'.

LifecycleStatus String True

The display name of the requisition line’s lifecycle status, giving more context to the processing stage. Example: 'Approved' or 'In Review'.

ActionRequiredCode String True

The code representing the action required for the requisition line, such as 'Approve' or 'Review'. Example: 'APPROVE'.

ActionRequired String True

The description of the action required for the requisition line, helping users understand what is needed. Example: 'Approval Needed' or 'Price Review'.

POCancelReason String True

The reason for canceling the associated purchase order, if applicable. Example: 'Vendor Delayed Shipment'.

POHoldReason String True

The reason the purchase order for the requisition line is placed on hold. Example: 'Payment Issue'.

PublicShoppingListHeaderId Long False

The unique identifier for the public shopping list header associated with the requisition line, used for shared requisition lists. Example: 3210 for 'Public Shopping List'.

InformationTemplateTouchedFlag Bool False

Indicates whether the information template has been modified for the requisition line. Example: True if the template was edited.

FundsStatusCode String True

The code representing the funds status for the requisition line, indicating whether funds are available. Example: 'AVAILABLE' or 'INSUFFICIENT'.

FundsStatus String True

The description of the funds status, helping to understand the availability of funds. Example: 'Available' or 'Not Approved'.

LifecycleSecondaryStatus String True

An additional status indicating the secondary stage of the requisition line’s lifecycle. Example: 'Under Review' or 'Awaiting Approval'.

ItemUserOverrideFlag Bool False

Indicates whether the item was manually overridden by the user. Example: True if the user changed the item details.

BPADescriptionUserOverrideFlag Bool True

Indicates whether the description for the BPA (Blanket Purchase Agreement) was overridden by the user. Example: True if the description was customized.

EPPLineId Long False

The unique identifier for the EPP (Enhanced Purchase Process) line associated with the requisition. Example: 45678 for the specific EPP line.

MarketplaceItemId String False

The unique identifier for the item in an external marketplace associated with the requisition line. Example: 'MARKET1234' for an item listed on a marketplace.

ConcatTransactionBusinessCategoryCode String False

The concatenated code representing the transaction business category for the requisition line, used for classification and grouping purposes. Example: 'OFFICE-TECH' for office technology items.

TransactionBusinessCategory String False

The business category associated with the requisition line, providing an easy classification of the item or service being requisitioned. Example: 'Office Equipment' or 'Software'.

TransactionBusinessCategoryCode String False

The code representing the business category of the requisition line for internal classification. Example: 'TECH' for technology items.

TaxationCountryCode String True

The code representing the taxation country for the requisition line, helping to determine tax rates and rules. Example: 'US' for the United States.

ConcatDocumentFiscalClassificationCode String True

The concatenated code combining the document’s fiscal classification with the requisition line’s data, used for tax reporting. Example: 'TAX-USA' for items taxed in the U.S.

ProductFiscalClassificationCode String False

The code representing the fiscal classification of the product in the requisition line, used for tax reporting and compliance. Example: 'EXEMPT' for tax-exempt products.

ProductFiscalClassificationId Long False

The unique identifier for the fiscal classification of the product in the requisition line, helping with tax reporting and categorization. Example: 101 for 'Exempt Product'.

ConcatProductCategoryCode String False

The concatenated code representing the product category associated with the requisition line, used for classification. Example: 'COMPUTER-HARDWARE'.

IntendedUseCode String False

The code that defines the intended use for the requisitioned item, helping to categorize it for specific purposes. Example: 'OFFICE' for office use.

IntendedUseId Long False

The unique identifier for the intended use of the requisition line’s item, linking the item to its specific use. Example: 5001 for 'Office Equipment'.

UserDefinedFiscalClassificationCode String False

The user-defined fiscal classification code for the requisition line, allowing for customization in tax or accounting processes. Example: 'REGULAR' for standard tax rate items.

TaxClassificationCode String False

The tax classification code associated with the requisition line, used to apply the appropriate tax rules. Example: 'TAXABLE' for taxable goods.

AssessableValue Decimal False

The assessable value for tax purposes, used to calculate the amount that will be taxed. Example: 200 for an item with a taxable value of $200.

FirstPartyTaxRegId Long False

The tax registration ID for the first party involved in the transaction, used for tax reporting. Example: 12345 for 'ABC Corp'.

ThirdPartyTaxRegId Long False

The tax registration ID for the third party involved in the transaction, if applicable. Example: 67890 for a third-party supplier.

LocationOfFinalDischargeId Long False

The identifier for the location where the goods will be finally discharged or delivered, relevant for customs or taxation. Example: 1001 for 'Port of Los Angeles'.

LocationOfFinalDischargeCode String True

The code representing the location of final discharge for the requisition line, typically used in shipping and logistics. Example: 'LA' for the 'Port of Los Angeles'.

FirstPartyTaxRegNumber String True

The tax registration number for the first party involved in the transaction, typically used for tax compliance. Example: '123-456-7890'.

CostCenter String True

The cost center associated with the requisition line, used for budgeting and accounting purposes. Example: 'Sales Office'.

IntendedUse String False

The intended use of the item requested in the requisition line, often used to justify the purchase. Example: 'Office Supplies' or 'Manufacturing Equipment'.

ProductFiscalClassification String False

The fiscal classification of the product in the requisition line, which helps determine tax rates and rules. Example: 'Taxable' or 'Exempt'.

ThirdPartyTaxRegNumber String False

The tax registration number for a third party involved in the requisition line, used for compliance and tax reporting. Example: '987-654-3210'.

UserDefinedFiscalClassification String False

The user-defined classification for the requisition line, allowing for customized tax reporting or accounting. Example: 'Import Tax' or 'Local Tax'.

DocumentFiscalClassificationCode String True

The fiscal classification code for the document associated with the requisition line, affecting tax treatment. Example: 'VAT'.

DocumentFiscalClassification String True

The description of the document’s fiscal classification, indicating how it should be treated for tax purposes. Example: 'Exempt' or 'Standard Rate'.

TaxationCountry String True

The country associated with the taxation of the requisition line, used to determine tax rates and apply country-specific rules. Example: 'USA' or 'Germany'.

ProductCategory String False

The category to which the product belongs, used for classification and reporting purposes. Example: 'Electronics' or 'Furniture'.

ProductCategoryCode String False

The code representing the category of the product in the requisition line, helping to classify it for accounting and procurement purposes. Example: 'EL' for Electronics.

TaxClassification String False

The classification that determines how the requisition line is taxed, used to ensure compliance with tax laws. Example: 'Sales Tax' or 'Exempt'.

TaxAttrsUserOverrideLineFlag Bool True

Indicates whether the user has overridden the tax attributes for the requisition line. Example: True if the user modified the tax classification.

SuggestedPrcBUId Long False

The unique identifier for the suggested procurement business unit for the requisition line, guiding where the procurement will occur. Example: 4001 for 'Central Procurement'.

informationTemplates String False

This field is for insert operations only. For updates or deletions, use operations on the child table. This field is typically used to reference a template for item or requisition details.

DFF String False

This field is for insert operations only. For updates or deletions, use operations on the child table. This is a reference to a descriptive flexfield for capturing custom data.

specialHandlingDFF String False

This field is for insert operations only. For updates or deletions, use operations on the child table. This field tracks special handling requirements for the requisition line.

distributions String False

This field is for insert operations only. For updates or deletions, use operations on the child table. It links the requisition line to any distribution-related data or financial postings.

BindPreparerId Long True

The unique identifier for the preparer, used to link the requisition line to the user who created it. Example: 5001 for 'John Doe'.

BindRequisitionHeaderId Long True

The unique identifier for the requisition header, helping to link the requisition line to its parent header record. Example: 2001 for 'Requisition 2001'.

Finder String True

A reference field used for searching requisition lines within the system, allowing users to filter and locate specific requisitions. Example: 'Search by Item'.

CUReferenceNumber Int False

The reference number linking child aggregates with their parent tables, ensuring data integrity between the requisition lines and parent records. Example: 1001 for 'Requisition Line 1'.

EffectiveDate Date True

The date from which the requisition line is considered effective. This is typically used to filter records by date range or to apply business logic. Example: '2023-01-01'.

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