JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

PurchaseRequisitions

PurchaseRequisitions

Columns

Name Type Description
RequisitionHeaderId [KEY] Long RequisitionHeaderId of PurchaseRequisitions
Requisition String Requisition of PurchaseRequisitions
RequisitioningBUId Long RequisitioningBUId of PurchaseRequisitions
RequisitioningBU String RequisitioningBU of PurchaseRequisitions
PreparerId Long PreparerId of PurchaseRequisitions
Preparer String Preparer of PurchaseRequisitions
PreparerEmail String PreparerEmail of PurchaseRequisitions
Description String Description of PurchaseRequisitions
Justification String Justification of PurchaseRequisitions
DocumentStatus String DocumentStatus of PurchaseRequisitions
DocumentStatusCode String DocumentStatusCode of PurchaseRequisitions
SubmissionDate Datetime SubmissionDate of PurchaseRequisitions
ApprovedDate Datetime ApprovedDate of PurchaseRequisitions
FunctionalCurrencyCode String FunctionalCurrencyCode of PurchaseRequisitions
SoldToLegalEntityId Long SoldToLegalEntityId of PurchaseRequisitions
SoldToLegalEntity String SoldToLegalEntity of PurchaseRequisitions
FundsStatus String FundsStatus of PurchaseRequisitions
FundsStatusCode String FundsStatusCode of PurchaseRequisitions
InterfaceSourceCode String InterfaceSourceCode of PurchaseRequisitions
InterfaceSourceLineId Long InterfaceSourceLineId of PurchaseRequisitions
EmergencyPONumber String EmergencyPONumber of PurchaseRequisitions
ModifyingApproverId Long ModifyingApproverId of PurchaseRequisitions
ModifyingApprover String ModifyingApprover of PurchaseRequisitions
ModifyingApproverEmail String ModifyingApproverEmail of PurchaseRequisitions
OverridingApproverId Long OverridingApproverId of PurchaseRequisitions
OverridingApproverPersonNumber String OverridingApproverPersonNumber of PurchaseRequisitions
OverridingApprover String OverridingApprover of PurchaseRequisitions
OverridingApproverEmail String OverridingApproverEmail of PurchaseRequisitions
FundsOverrideApproverId Long FundsOverrideApproverId of PurchaseRequisitions
FundsOverrideApprover String FundsOverrideApprover of PurchaseRequisitions
FundsOverrideApproverEmail String FundsOverrideApproverEmail of PurchaseRequisitions
ApprovedById Long ApprovedById of PurchaseRequisitions
ApprovedByEmail String ApprovedByEmail of PurchaseRequisitions
BudgetaryControlEnabledFlag Bool BudgetaryControlEnabledFlag of PurchaseRequisitions
EmergencyRequisitionFlag Bool EmergencyRequisitionFlag of PurchaseRequisitions
ExternallyManagedFlag Bool ExternallyManagedFlag of PurchaseRequisitions
InternalTransferFlag Bool InternalTransferFlag of PurchaseRequisitions
FundsChkFailWarnFlag Bool FundsChkFailWarnFlag of PurchaseRequisitions
CreationDate Datetime CreationDate of PurchaseRequisitions
LastUpdateDate Datetime LastUpdateDate of PurchaseRequisitions
CreatedBy String CreatedBy of PurchaseRequisitions
LastUpdatedBy String LastUpdatedBy of PurchaseRequisitions
ActiveRequisitionFlag Bool ActiveRequisitionFlag of PurchaseRequisitions
SourceApplicationCode String SourceApplicationCode of PurchaseRequisitions
HasPendingApprovalLinesFlag Bool HasPendingApprovalLinesFlag of PurchaseRequisitions
HasRejectedLinesFlag Bool HasRejectedLinesFlag of PurchaseRequisitions
HasReturnedLinesFlag Bool HasReturnedLinesFlag of PurchaseRequisitions
HasWithdrawnLinesFlag Bool HasWithdrawnLinesFlag of PurchaseRequisitions
LifecycleStatusCode String LifecycleStatusCode of PurchaseRequisitions
LifecycleStatus String LifecycleStatus of PurchaseRequisitions
HasActionRequiredLinesFlag Bool HasActionRequiredLinesFlag of PurchaseRequisitions
IdentificationKey String IdentificationKey of PurchaseRequisitions
LockedByBuyerFlag Bool LockedByBuyerFlag of PurchaseRequisitions
RejectedReason String RejectedReason of PurchaseRequisitions
RejectedById Long RejectedById of PurchaseRequisitions
RejectedByDisplayName String RejectedByDisplayName of PurchaseRequisitions
RequisitionLineGroup String RequisitionLineGroup of PurchaseRequisitions
InsufficientFundsFlag Bool InsufficientFundsFlag of PurchaseRequisitions
SpecialHandlingTypeCode String SpecialHandlingTypeCode of PurchaseRequisitions
SpecialHandlingType String SpecialHandlingType of PurchaseRequisitions
BindPreparerId Long BindPreparerId of PurchaseRequisitions
Finder String Finder of PurchaseRequisitions

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