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 |