Requisition Header
The Requisition Header view object manages the purchase requisitions. A purchase requisition is an internal demand for purchasing an item or service, typically from a supplier who resides outside your organization.
Data Store Key : FscmTopModelAM.PrcExtractAM.PorBiccExtractAM.RequisitionHeaderExtractPVO
Primary Keys : RequisitionHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ActiveRequisitionFlag | Contains one of the following values: true or false. If true, then the requisition should be shown to users when they log into SSP. If false, then the requisition should not be shown to users when they log into SSP. |
| ApprovalInstanceId | Value that uniquely identifies an instance of the approval process. |
| ApprovedDate | Date and time when the requisition was last approved. |
| Attribute1 | Segment for the Requisition Header descriptive flexfield. |
| Attribute10 | Segment for the Requisition Header descriptive flexfield. |
| Attribute11 | Segment for the Requisition Header descriptive flexfield. |
| Attribute12 | Segment for the Requisition Header descriptive flexfield. |
| Attribute13 | Segment for the Requisition Header descriptive flexfield. |
| Attribute14 | Segment for the Requisition Header descriptive flexfield. |
| Attribute15 | Segment for the Requisition Header descriptive flexfield. |
| Attribute16 | Segment for the Requisition Header descriptive flexfield. |
| Attribute17 | Segment for the Requisition Header descriptive flexfield. |
| Attribute18 | Segment for the Requisition Header descriptive flexfield. |
| Attribute19 | Segment for the Requisition Header descriptive flexfield. |
| Attribute2 | Segment for the Requisition Header descriptive flexfield. |
| Attribute20 | Segment for the Requisition Header descriptive flexfield. |
| Attribute3 | Segment for the Requisition Header descriptive flexfield. |
| Attribute4 | Segment for the Requisition Header descriptive flexfield. |
| Attribute5 | Segment for the Requisition Header descriptive flexfield. |
| Attribute6 | Segment for the Requisition Header descriptive flexfield. |
| Attribute7 | Segment for the Requisition Header descriptive flexfield. |
| Attribute8 | Segment for the Requisition Header descriptive flexfield. |
| Attribute9 | Segment for the Requisition Header descriptive flexfield. |
| AttributeCategory | Context name for the Requisition Header descriptive flexfield which appear conditionally. |
| AttributeDate1 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeDate10 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeDate2 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeDate3 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeDate4 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeDate5 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeDate6 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeDate7 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeDate8 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeDate9 | Date segment for the Requisition Header descriptive flexfield. |
| AttributeNumber1 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeNumber10 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeNumber2 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeNumber3 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeNumber4 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeNumber5 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeNumber6 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeNumber7 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeNumber8 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeNumber9 | Number segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp10 | Date and time segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp6 | Date and time segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp7 | Date and time segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp8 | Date and time segment for the Requisition Header descriptive flexfield. |
| AttributeTimestamp9 | Date and time segment for the Requisition Header descriptive flexfield. |
| BudgetControlEnabledFlag | Contains one of the following values: true or false. If true, then the requisition has budgetary control enabled. If false, then the requisition doesn't have budgetary control enabled. The default value is False. |
| ChangePendingFlag | Contains one of the following values: true or false. If true, then the requisition is in Change Order process. If true, then the requisition isn't in Change Order process. This attribute doesn't have any default value. |
| CreatedBy | User who created the requisition. |
| CreationDate | Date and time when the requisition was created. |
| DefaultTaxationCountry | Default country used for taxation purposes. |
| Description | Description of the requisition. |
| DocumentStatus | Status of the requisition. |
| DocumentSubType | Document subtype of the requisition. |
| EmergencyPoNumber | Number that identifies the purchase order reserved in advance for an emergency requisition. |
| EmergencyReqFlag | Contains one of the following values: true or false. If true, then the requisition is an emergency requisition. If false, then the requisition isn't an emergency requisition. This attribute doesn't have any default value. |
| ExternallyManagedFlag | Contains one of the following values: true or false. If true, then requisition is externally managed. If false, then requisition isn't externally managed. This attribute doesn't have a default value. |
| FundsChkFailWarnFlag | Contains one of the following values: true, false, or Null. If true, then funds check failed. If false, then funds check didn't fail. If Null, then the value hasn't been set. The default value is Null. |
| FundsOverrideApproverId | Value that uniquely identifies the user who has the insufficient funds override authority for a requisition. |
| FundsStatus | Status of the funds reservation request. |
| HasActionRequiredLinesFlag | Value that indicates if at least one line on the requisition requires an action from the user to remove an invoice hold. |
| HasCanceledLines | Value that indicates that at least one line on the requisition is canceled. |
| HasIncompleteLines | Value that indicates that at least one line on the requisition is considered incomplete or still in draft mode. |
| HasPendingApprLines | Value that indicates that at least one line on the requisition is pending approval. |
| HasRejectedLines | Value that indicates that at least one line on the requisition is rejected. |
| HasReturnedLines | Value that indicate that at least one line on the requisition was returned by the buyer. |
| HasWithdrawnLines | Value that indicates that at least one line on the requisition was withdrawn by the requisition preparer. |
| InsufficientFundsFlag | Indicates whether the implicit funds check upon submission returns failures, and an override is requested. |
| InterfaceSourceCode | Code that identifies the source of the requisition from a requisition import process. |
| InterfaceSourceLineId | Value that uniquely identifies the source requisition line from a requisition import process. |
| InternalTransferReqFlag | Contains one of the following values: true or false. If true, then all lines of the requisition are for internal material transfer. If false, then all the lines of the requisition aren't for internal material transfer. |
| JobDefinitionName | Name of the job that created or last updated the row. This is used in Enterprise Service Scheduler. |
| JobDefinitionPackage | Package name of the job that created or last updated the row. This is used in Enterprise Service Scheduler. |
| Justification | Reason for creating the requisition. |
| LastUpdateDate | Date and time when the requisition was last updated. |
| LastUpdateLogin | Session login associated with the user who last updated the row. |
| LastUpdatedBy | Name of the user who last updated the requisition. |
| LifecycleStatus | Value that identifies the rolled-up lifecycle status code of the requisition. |
| LineGroup | Group filter to which a requisition line belongs. |
| LockedByBuyerFlag | Contains one of the following values: true or false. If true, then the buyer is currently working on one of the requisition lines and this prevents the requisition preparer from amending any of the other lines. If false, then the buyer is currently not working on any of the requisition lines and the requisition preparer can amend any of the lines. |
| ModifyingApproverId | Value that uniquely identifies the user who's currently modifying the requisition during the approval process. |
| ObjectVersionNumber | Indicates the version number of the requisition row. |
| OverridingApproverId | Value that uniquely identifies the user specified on the requisition as the overriding approver for approval routing. |
| PcardId | Value that uniquely identifies the procurement card used for the order. |
| PrcBuId | Value that uniquely identifies the Procurement Business Unit. |
| PreparerId | Value that uniquely identifies the user who created the requisition. |
| ProcessStatus | Stage of importing requisitions or running purchase request web service. Default value is NULL. PROCESS_STATUS is POST_PLSQL once the PL or SQL procedure is finished and is COMPLETED once the requisition import or web service is completed. |
| RejectReason | Reason for rejecting the requisition. |
| RejectedByApproverId | Value that uniquely identifies the person who rejected the requisition. |
| ReqBuId | Value that uniquely identifies the Requisitioning Business Unit. |
| ReqImportApproverId | Value that uniquely identifies the approver specified in the requisition import process. |
| RequestId | Value that uniquely identifies the request ID of the job that created or last updated the row. This is used in Enterprise Service Scheduler. |
| RequisitionHeaderId | Value that uniquely identifies the requisition. |
| RequisitionNumber | Number that identifies the requisition. It's used to identify the requisition by end users. |
| SoldtoLeId | Value that uniquely identifies the sold to legal entity. |
| SubmissionDate | Date and time when the requisition was submitted for approval. |
| TaxUserOverrideHdrFlag | Indicates whether the user overrode the tax returned by the tax engine. |