PurchaseRequisitionslines
PurchaseRequisitionslines
Columns
| Name | Type | Description |
| PurchaseRequisitionsRequisitionHeaderId [KEY] | Long | PurchaseRequisitionsRequisitionHeaderId of PurchaseRequisitionslines |
| RequisitionHeaderId | Long | RequisitionHeaderId of PurchaseRequisitionslines |
| RequisitionLineId [KEY] | Long | RequisitionLineId of PurchaseRequisitionslines |
| LineNumber | Decimal | LineNumber of PurchaseRequisitionslines |
| SmartFormId | Long | SmartFormId of PurchaseRequisitionslines |
| SmartFormName | String | SmartFormName of PurchaseRequisitionslines |
| LineTypeId | Long | LineTypeId of PurchaseRequisitionslines |
| LineTypeCode | String | LineTypeCode of PurchaseRequisitionslines |
| RequisitionLineSource | String | RequisitionLineSource of PurchaseRequisitionslines |
| CategoryId | Long | CategoryId of PurchaseRequisitionslines |
| CategoryName | String | CategoryName of PurchaseRequisitionslines |
| ItemDescription | String | ItemDescription of PurchaseRequisitionslines |
| ItemId | Long | ItemId of PurchaseRequisitionslines |
| Item | String | Item of PurchaseRequisitionslines |
| ItemRevision | String | ItemRevision of PurchaseRequisitionslines |
| Quantity | Decimal | Quantity of PurchaseRequisitionslines |
| SecondaryQuantity | Decimal | SecondaryQuantity of PurchaseRequisitionslines |
| UnitPrice | Decimal | UnitPrice of PurchaseRequisitionslines |
| CurrencyCode | String | CurrencyCode of PurchaseRequisitionslines |
| Currency | String | Currency of PurchaseRequisitionslines |
| UOMCode | String | UOMCode of PurchaseRequisitionslines |
| UOM | String | UOM of PurchaseRequisitionslines |
| SecondaryUOMCode | String | SecondaryUOMCode of PurchaseRequisitionslines |
| SecondaryUOM | String | SecondaryUOM of PurchaseRequisitionslines |
| ConversionRateType | String | ConversionRateType of PurchaseRequisitionslines |
| ConversionRateDate | Date | ConversionRateDate of PurchaseRequisitionslines |
| ConversionRate | Decimal | ConversionRate of PurchaseRequisitionslines |
| Price | Decimal | Price of PurchaseRequisitionslines |
| LineStatus | String | LineStatus of PurchaseRequisitionslines |
| LineStatusDisplayValue | String | LineStatusDisplayValue of PurchaseRequisitionslines |
| Amount | Decimal | Amount of PurchaseRequisitionslines |
| CurrencyAmount | Decimal | CurrencyAmount of PurchaseRequisitionslines |
| UrgentFlag | Bool | UrgentFlag of PurchaseRequisitionslines |
| NegotiatedByPreparerFlag | Bool | NegotiatedByPreparerFlag of PurchaseRequisitionslines |
| NegotiationRequiredFlag | Bool | NegotiationRequiredFlag of PurchaseRequisitionslines |
| SourceAgreementTypeCode | String | SourceAgreementTypeCode of PurchaseRequisitionslines |
| SourceAgreementType | String | SourceAgreementType of PurchaseRequisitionslines |
| SourceAgreementHeaderId | Long | SourceAgreementHeaderId of PurchaseRequisitionslines |
| SourceAgreement | String | SourceAgreement of PurchaseRequisitionslines |
| SourceAgreementLineId | Long | SourceAgreementLineId of PurchaseRequisitionslines |
| SourceAgreementLineNumber | Decimal | SourceAgreementLineNumber of PurchaseRequisitionslines |
| UNNumberId | Long | UNNumberId of PurchaseRequisitionslines |
| UNNumber | String | UNNumber of PurchaseRequisitionslines |
| HazardClassId | Long | HazardClassId of PurchaseRequisitionslines |
| HazardClass | String | HazardClass of PurchaseRequisitionslines |
| HazardClassCode | String | HazardClassCode of PurchaseRequisitionslines |
| UNSPSCCode | String | UNSPSCCode of PurchaseRequisitionslines |
| ManufacturerName | String | ManufacturerName of PurchaseRequisitionslines |
| ManufacturerPartNumber | String | ManufacturerPartNumber of PurchaseRequisitionslines |
| BPAPriceUserOverrideFlag | Bool | BPAPriceUserOverrideFlag of PurchaseRequisitionslines |
| NewSupplierFlag | Bool | NewSupplierFlag of PurchaseRequisitionslines |
| SupplierId | Long | SupplierId of PurchaseRequisitionslines |
| Supplier | String | Supplier of PurchaseRequisitionslines |
| SupplierSiteId | Long | SupplierSiteId of PurchaseRequisitionslines |
| SupplierSite | String | SupplierSite of PurchaseRequisitionslines |
| SupplierContactId | Long | SupplierContactId of PurchaseRequisitionslines |
| SupplierContact | String | SupplierContact of PurchaseRequisitionslines |
| SupplierContactEmail | String | SupplierContactEmail of PurchaseRequisitionslines |
| SupplierContactPhone | String | SupplierContactPhone of PurchaseRequisitionslines |
| SupplierContactFax | String | SupplierContactFax of PurchaseRequisitionslines |
| AdditionalContactEmail | String | AdditionalContactEmail of PurchaseRequisitionslines |
| SuggestedSupplier | String | SuggestedSupplier of PurchaseRequisitionslines |
| SuggestedSupplierSite | String | SuggestedSupplierSite of PurchaseRequisitionslines |
| SuggestedSupplierContact | String | SuggestedSupplierContact of PurchaseRequisitionslines |
| SuggestedSupplierContactPhone | String | SuggestedSupplierContactPhone of PurchaseRequisitionslines |
| SuggestedSupplierContactFax | String | SuggestedSupplierContactFax of PurchaseRequisitionslines |
| SuggestedSupplierContactEmail | String | SuggestedSupplierContactEmail of PurchaseRequisitionslines |
| SupplierItemNumber | String | SupplierItemNumber of PurchaseRequisitionslines |
| RequesterId | Long | RequesterId of PurchaseRequisitionslines |
| Requester | String | Requester of PurchaseRequisitionslines |
| RequesterDisplayName | String | RequesterDisplayName of PurchaseRequisitionslines |
| RequesterEmail | String | RequesterEmail of PurchaseRequisitionslines |
| SuggestedBuyerId | Long | SuggestedBuyerId of PurchaseRequisitionslines |
| SuggestedBuyer | String | SuggestedBuyer of PurchaseRequisitionslines |
| SuggestedBuyerEmail | String | SuggestedBuyerEmail of PurchaseRequisitionslines |
| ModifiedByBuyerId | Long | ModifiedByBuyerId of PurchaseRequisitionslines |
| ModifiedByBuyer | String | ModifiedByBuyer of PurchaseRequisitionslines |
| AssignedBuyerId | Long | AssignedBuyerId of PurchaseRequisitionslines |
| AssignedBuyer | String | AssignedBuyer of PurchaseRequisitionslines |
| AssignedBuyerDisplayName | String | AssignedBuyerDisplayName of PurchaseRequisitionslines |
| AssignedBuyerEmail | String | AssignedBuyerEmail of PurchaseRequisitionslines |
| RequestedDeliveryDate | Date | RequestedDeliveryDate of PurchaseRequisitionslines |
| DestinationTypeCode | String | DestinationTypeCode of PurchaseRequisitionslines |
| DestinationType | String | DestinationType of PurchaseRequisitionslines |
| DestinationOrganizationId | Long | DestinationOrganizationId of PurchaseRequisitionslines |
| DestinationOrganizationCode | String | DestinationOrganizationCode of PurchaseRequisitionslines |
| DestinationOrganization | String | DestinationOrganization of PurchaseRequisitionslines |
| DestinationSubinventory | String | DestinationSubinventory of PurchaseRequisitionslines |
| OneTimeLocationFlag | Bool | OneTimeLocationFlag of PurchaseRequisitionslines |
| DeliverToLocationId | Long | DeliverToLocationId of PurchaseRequisitionslines |
| DeliverToLocationCode | String | DeliverToLocationCode of PurchaseRequisitionslines |
| DeliverToAddress | String | DeliverToAddress of PurchaseRequisitionslines |
| FormattedDeliverToAddress | String | FormattedDeliverToAddress of PurchaseRequisitionslines |
| NoteToBuyer | String | NoteToBuyer of PurchaseRequisitionslines |
| NoteToReceiver | String | NoteToReceiver of PurchaseRequisitionslines |
| NoteToSupplier | String | NoteToSupplier of PurchaseRequisitionslines |
| RequisitionLineInPool | String | RequisitionLineInPool of PurchaseRequisitionslines |
| POAutomationFailedReasonCode | String | POAutomationFailedReasonCode of PurchaseRequisitionslines |
| POAutomationFailedReason | String | POAutomationFailedReason of PurchaseRequisitionslines |
| POHeaderId | Long | POHeaderId of PurchaseRequisitionslines |
| POLineId | Long | POLineId of PurchaseRequisitionslines |
| PurchaseOrder | String | PurchaseOrder of PurchaseRequisitionslines |
| POBuyerId | Long | POBuyerId of PurchaseRequisitionslines |
| BuyerOnPurchaseOrder | String | BuyerOnPurchaseOrder of PurchaseRequisitionslines |
| SupplierOnPurchaseOrder | String | SupplierOnPurchaseOrder of PurchaseRequisitionslines |
| ProcurementBUId | Long | ProcurementBUId of PurchaseRequisitionslines |
| ProcurementBU | String | ProcurementBU of PurchaseRequisitionslines |
| SourceTypeCode | String | SourceTypeCode of PurchaseRequisitionslines |
| SourceType | String | SourceType of PurchaseRequisitionslines |
| SourceOrganizationId | Long | SourceOrganizationId of PurchaseRequisitionslines |
| SourceOrganizationCode | String | SourceOrganizationCode of PurchaseRequisitionslines |
| SourceOrganization | String | SourceOrganization of PurchaseRequisitionslines |
| SourceSubinventory | String | SourceSubinventory of PurchaseRequisitionslines |
| TransferOrderHeaderId | Long | TransferOrderHeaderId of PurchaseRequisitionslines |
| TransferOrder | String | TransferOrder of PurchaseRequisitionslines |
| TransferOrderLineId | Long | TransferOrderLineId of PurchaseRequisitionslines |
| NegotiationHeaderId | Long | NegotiationHeaderId of PurchaseRequisitionslines |
| Negotiation | String | Negotiation of PurchaseRequisitionslines |
| NegotiationLineNumber | Decimal | NegotiationLineNumber of PurchaseRequisitionslines |
| ResponseNumber | Decimal | ResponseNumber of PurchaseRequisitionslines |
| ResponseLineNumber | Decimal | ResponseLineNumber of PurchaseRequisitionslines |
| OnNegotiationFlag | Bool | OnNegotiationFlag of PurchaseRequisitionslines |
| WorkOrderId | Long | WorkOrderId of PurchaseRequisitionslines |
| WorkOrder | String | WorkOrder of PurchaseRequisitionslines |
| WorkOrderOperationId | Long | WorkOrderOperationId of PurchaseRequisitionslines |
| WorkOrderOperationSequence | Decimal | WorkOrderOperationSequence of PurchaseRequisitionslines |
| WorkOrderProduct | String | WorkOrderProduct of PurchaseRequisitionslines |
| WorkOrderSubType | String | WorkOrderSubType of PurchaseRequisitionslines |
| BackToBackFlag | Bool | BackToBackFlag of PurchaseRequisitionslines |
| ConfiguredItemFlag | Bool | ConfiguredItemFlag of PurchaseRequisitionslines |
| DeliverToCustomerId | Long | DeliverToCustomerId of PurchaseRequisitionslines |
| DeliverToCustomer | String | DeliverToCustomer of PurchaseRequisitionslines |
| DeliverToCustomerLocationId | Long | DeliverToCustomerLocationId of PurchaseRequisitionslines |
| RequestedShipDate | Date | RequestedShipDate of PurchaseRequisitionslines |
| SalesOrderLineNumber | String | SalesOrderLineNumber of PurchaseRequisitionslines |
| SalesOrder | String | SalesOrder of PurchaseRequisitionslines |
| SalesOrderScheduleNumber | String | SalesOrderScheduleNumber of PurchaseRequisitionslines |
| ShipToCustomerId | Long | ShipToCustomerId of PurchaseRequisitionslines |
| ShipToCustomer | String | ShipToCustomer of PurchaseRequisitionslines |
| ServiceLevelCode | String | ServiceLevelCode of PurchaseRequisitionslines |
| ServiceLevel | String | ServiceLevel of PurchaseRequisitionslines |
| ModeOfTransportCode | String | ModeOfTransportCode of PurchaseRequisitionslines |
| ModeOfTransport | String | ModeOfTransport of PurchaseRequisitionslines |
| CarrierId | Long | CarrierId of PurchaseRequisitionslines |
| Carrier | String | Carrier of PurchaseRequisitionslines |
| CreatedBy | String | CreatedBy of PurchaseRequisitionslines |
| CreationDate | Datetime | CreationDate of PurchaseRequisitionslines |
| LastUpdatedBy | String | LastUpdatedBy of PurchaseRequisitionslines |
| LastUpdateDate | Datetime | LastUpdateDate of PurchaseRequisitionslines |
| LastSubmittedDate | Datetime | LastSubmittedDate of PurchaseRequisitionslines |
| LastApprovalDate | Datetime | LastApprovalDate of PurchaseRequisitionslines |
| OriginalSubmittedDate | Datetime | OriginalSubmittedDate of PurchaseRequisitionslines |
| OriginalApprovalDate | Datetime | OriginalApprovalDate of PurchaseRequisitionslines |
| CancelDate | Date | CancelDate of PurchaseRequisitionslines |
| CancelReason | String | CancelReason of PurchaseRequisitionslines |
| RequisitionLinePOInstanceId | Long | RequisitionLinePOInstanceId of PurchaseRequisitionslines |
| BuyerProcessingFlag | Bool | BuyerProcessingFlag of PurchaseRequisitionslines |
| RequisitionLineGroup | String | RequisitionLineGroup of PurchaseRequisitionslines |
| LineImageURL | String | LineImageURL of PurchaseRequisitionslines |
| SupplierItemAuxiliaryId | String | SupplierItemAuxiliaryId of PurchaseRequisitionslines |
| DisableAutosourceFlag | Bool | DisableAutosourceFlag of PurchaseRequisitionslines |
| DeliverToOneTimeAddress | String | DeliverToOneTimeAddress of PurchaseRequisitionslines |
| LineTypeOrderTypeLookupCode | String | LineTypeOrderTypeLookupCode of PurchaseRequisitionslines |
| ReturnedByBuyerId | Long | ReturnedByBuyerId of PurchaseRequisitionslines |
| ReturnedByBuyerDisplayName | String | ReturnedByBuyerDisplayName of PurchaseRequisitionslines |
| ReturnReason | String | ReturnReason of PurchaseRequisitionslines |
| LifecycleStatusCode | String | LifecycleStatusCode of PurchaseRequisitionslines |
| LifecycleStatus | String | LifecycleStatus of PurchaseRequisitionslines |
| ActionRequiredCode | String | ActionRequiredCode of PurchaseRequisitionslines |
| ActionRequired | String | ActionRequired of PurchaseRequisitionslines |
| POCancelReason | String | POCancelReason of PurchaseRequisitionslines |
| POHoldReason | String | POHoldReason of PurchaseRequisitionslines |
| PublicShoppingListHeaderId | Long | PublicShoppingListHeaderId of PurchaseRequisitionslines |
| InformationTemplateTouchedFlag | Bool | InformationTemplateTouchedFlag of PurchaseRequisitionslines |
| FundsStatusCode | String | FundsStatusCode of PurchaseRequisitionslines |
| FundsStatus | String | FundsStatus of PurchaseRequisitionslines |
| LifecycleSecondaryStatus | String | LifecycleSecondaryStatus of PurchaseRequisitionslines |
| ItemUserOverrideFlag | Bool | ItemUserOverrideFlag of PurchaseRequisitionslines |
| BPADescriptionUserOverrideFlag | Bool | BPADescriptionUserOverrideFlag of PurchaseRequisitionslines |
| BindPreparerId | Long | BindPreparerId of PurchaseRequisitionslines |
| Finder | String | Finder of PurchaseRequisitionslines |