Inbound staging tables Sourcing Procurement › Inbound staging tables › Source-to-Pay integration framework › Integration with third-party applications › Integrations › Source-to-Pay Operations › Finance and Supply Chain

Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Purchase Line Stage inbound staging table

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.

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.