JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

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

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