Purchase Requisition staging table

  • Release version: Zurich
  • Updated July 31, 2025
  • 2 minutes to read

    • The Purchase requisition [sn_spend_intg_purchase_requisition] staging table temporarily stores important data about purchase requests before this data is sent to the primary table.

    Table 1. Purchase Requisition stage
    Field Data type Description
    Accounting period String Financial period during which expenses related to the purchase requisition are recorded.
    Actual end String End date of a purchase requisition (PR) process.
    Actual start String Start date or initiation date of a purchase requisition (PR) process.
    Additional comments String Supplementary information or notes added to a purchase requisition (PR).
    After the fact String Actions or processes related to a purchase requisition (PR) that are handled or documented after a requisition is approved.
    Assigned to String Individual or department responsible for reviewing, approving, and processing the purchase requisition (PR).
    Assignment group String Team responsible for managing a Purchase Requisition (PR) within an organization.
    Business owner String Individual or entity that has legal ownership and control over a business.
    Cost center String Department, unit, or segment within an organization that is responsible for managing its own budget and expenses related to purchase requisitions.
    Description String Description of the purchase requisition.
    ERP Source String It is a field or attribute associated with a purchase requisition that indicates the specific ERP module, system, or process from which the requisition was generated.
    Group Id String Unique identifier assigned to a group of purchase requisitions. This identifier groups together related requisitions for easier management, tracking, and processing.
    Handling fee String Additional charge associated with the processing of a Purchase Requisition (PR).
    Legal entity String Legal entity within an organization that is responsible for the purchase requisition.
    Location String Location of the legal entity.
    Number String Unique identifier assigned to a purchase requisition document within the procurement system.
    Order type String Classification of orders based on their nature, purpose, or processing requirements.
    Payment term String Specific terms and conditions under which payment is to be made for the goods or services requested in a Purchase Requisition (PR).
    Preferred currency String Currency that is preferred or required for processing a Purchase Requisition (PR).
    Primary contact String Individual responsible for managing the Purchase Requisition (PR) process.
    Priority String Level of urgency assigned to a Purchase Requisition (PR) within an organization's procurement process.
    Purchase String Purchase order associated with the purchase requisition.
    Purchase order String Official purchase order issued to the supplier.
    Purchasing entity String Organization or department that is responsible for procurement of goods or services within a company.
    Requested delivery String Date by which the requester of a purchase requisition (PR) expects the goods or services to be delivered.
    Requisition type String Classification of a purchase requisition based on the nature or purpose of the requested goods or services.
    Short description String Brief description of the purchase order.
    State String Current state of the purchase requisition.
    Submitted by String Individual or entity that created the purchase requisition request.
    Supplier String Vendor or supplier from whom the requested goods or services are intended to be purchased.
    Total amount String Total cost or value of all items or services requested in a requisition.
    Total estimated shipping String Estimated cost associated with the shipping of goods or services.
    Total estimated tax String Estimated amount of tax applicable to the goods or services requested in a Purchase Requisition (PR).