Purchase Line Stage inbound staging table

  • Release version: Australia
  • Updated March 12, 2026
  • 6 minutes to read

    • The Purchase Entity Stage inbound [sn_spend_intg_purchase_line] staging table temporarily stores important data about purchase entities before this data is sent to the primary table.

    Purchase Line Stage inbound staging table

    The following table lists both the mandatory and optional fields for the Purchase Line Stage inbound [sn_spend_intg_purchase_line] staging table.

    Table 1. Purchase Line Stage inbound staging table
    Field Data type Description
    Account assignment category String Account assignment category of the purchase line.
    Acknowledgement type String Acknowledgment type of the purchase line. Applicable only if product type is Service or Handling fee. The values are:
    • Milestones
    • Service acknowledgement
    • Two way match
    Active String Indicates if the purchase line is active or not.
    Additional comments String Additional notes about the purchase line, if any.
    Address String Address of the purchase line.
    After the fact String Indicates if the purchase requisition is after the fact or not.
    Asset category String Asset category of the purchase line.
    Awarded String Indicates who is the awarded supplier for the purchase line.
    Awarded in third party String Indicates who is the third-party awarded supplier for the purchase line.
    Business owner String An individual or group who owns the purchase line.
    Capex account String Ledger account to post the capital expenses of this product after the purchase completion.
    Cart line id String Shopping cart line ID of the purchase line.
    City String City of the purchase line.
    Contract price String Contract price of the purchase line.
    Cost center String Cost center that incurs the cost of the purchase line.
    Cost plan String Cost plan for the purchase line.
    Country String Name of the country of the purchase line.
    Country code String Country code of the purchase line.
    Estimated shipping String Shipping cost estimate for the product based on the delivery location.
    Estimated tax String Tax estimate for the product based on the price and delivery location.
    Expense account String Expense account associated with the purchase line.
    General ledger account String General Ledger (GL) account associated with the purchase line.
    Goods receipt required String Indicates if a receipt is required in addition to the invoice.
    Individual unit cost String Cost of the individual unit.
    Internal order number String Internal order number of the purchase line.
    Legal entity String Internal legal entity that incurs the cost of this purchase line.
    Line source String Line source associated with the purchase line.
    Manual handling fee String Manual charges added for a specific supplier when a rule is triggered as a result of certain configurable conditions for a purchase requisition being met.
    Maximum budget String Maximum budget that the shopper provides for this purchase.
    Milestone payout type String Indicates the type of milestone payout. The options available are Amount and Percentage.
    Negotiated by String Indicates who is responsible for negotiation.
    Negotiated savings String Total savings through negotiation. This is calculated as: (Starting unit cost - Negotiated unit cost) x Supplier's quantity.
    Negotiated unit cost String Cost per unit of the product after negotiation.
    Negotiation String Negotiation associated with this purchase line.
    Net amount String Amount included as a cost allocation on the purchase order. This doesn’t include any estimates.
    Non catalog purchase? String Indicates if the purchase is non catalog or not.
    Number String System-generated unique identifier of the purchase line.
    Parent line String Parent line of the purchase line.
    Part requirement String Part requirement associated with the purchase line.
    Payment allocations String Payment allocations of the purchase line.
    Payment method String Indicates the payment method to the supplier.
    Payment schedule String Indicates the schedule of payments to the supplier.
    Preferred currency String Payment method preferred by the supplier legal entity.
    Pre-paid account String General ledger account where purchases of this product are posted when they are prepaid.
    Pre-payments required String Option to mark if pre-payments is required for this product.
    Pricing obtained on String Date on which the pricing is obtained for the purchase line.
    Product category String Product category that is sourced through this purchase line.
    Product example String Reference URL that the shopper provides.
    Product name String Name of the supplier product.
    Product type String Type of the product associated with the purchase line.
    Project String Project associated with the purchase line.
    Purchase String Parent purchase associated with this purchase line.
    Purchase order String Purchase order associated with the purchase line.
    Purchase order line String Purchase order line associated with the purchase line.
    Purchase reason String Reason for purchasing the product.
    Purchase requisition String Purchase requisition associated with this purchase line.
    Purchased quantity String Quantity that has been purchased by the shopper.
    Recipient String Recipient of the purchase line.
    Requested delivery date String Requested delivery date of the purchased product.
    Requested end date String Requested end date of the purchase line order.
    Requested start date String Requested start date of the purchase line order.
    Shipping method String Details of the carrier, the applicable suppliers, and the valid delivery location countries for those suppliers.
    Shopper's original choice String Original or first choice of the shopper.
    Short description String Brief description about the purchase line.
    Sourcing request String Sourcing request associated with this purchase line.
    Specific requirements String Requirements that the shopper specifies.
    Spend categorization String Indicates whether negotiation with the supplier is addressable or not.
    Starting unit cost String Cost per unit of the product prior to negotiation.
    State String State of the purchase line.
    State or province String State or province of the purchase line.
    Street String Street address of the purchase line.
    Supplier String Supplier for which the shopper places the order.
    Supplier case String Indicates if a supplier case is created for the supplier or not.
    Supplier contact String Name of the supplier contact of the purchase line.
    Supplier contact email String Registered email ID for this supplier contact.
    Supplier contact first name String First name of the supplier contact.
    Supplier contact job title String Job title of the supplier contact.
    Supplier contact last name String Last name of the supplier contact.
    Supplier contacted? String Indicates if the supplier has been contacted or not.
    Supplier notes String Additional notes about the supplier, if any.
    Supplier part auxiliary ID String Auxiliary ID associated with the supplier part.
    Supplier product String Supplier product for which the purchase line is created.
    Supplier's lead time (days) String Number of days that the supplier takes to deliver the goods or provide the service. Based on this, the delivery date for goods and the start and end dates for services vary.
    Supplier's quantity String Quantity that the supplier can provide.
    Tags String Tag names for the purchase line.
    Term length String Duration of the term.
    Term value String Type of the term. The options are Days, Weeks, Months, and Years.
    Third party Category String Third-party category of the purchase line.
    Total bid amount String Supplier's quantity multiplied by negotiated unit cost. It reflects the total bid amount from that particular supplier for that purchase line.
    Total individual units String Number of fixed assets that are created depends on this value.
    Total line amount String Total price of the purchased goods and services, including estimated tax and shipping.
    Type String Type of the purchase line.
    Unit String Unit of rate at which the customer purchases the product.
    Upcoming date String Upcoming date for the purchase line.
    WBS element String WBS element associated with the purchase line.
    Zip or postal code String Zip code of the purchase line.