---
sourceDocument: Yokohama Finance and Supply Chain
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/source-to-pay-operations

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Employee


---

# Purchase Line Stage inbound staging table

# Purchase Line Stage inbound staging table {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 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 {#spo-purch-line-stage-inbound-table__section_enw_nrt_ncc}

The following table lists both the mandatory and optional fields for the Purchase Line Stage inbound \[sn_spend_intg_purchase_line\] staging table.  
{#spo-purch-line-stage-inbound-table__table_mq2_qrt_ncc__entry__3}

| 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 {#spo-purch-line-stage-inbound-table__ul_l1g_srg_4cc} |
| 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. |
[Table 1. Purchase Line Stage inbound staging table]

{#spo-purch-line-stage-inbound-table__table_mq2_qrt_ncc}
**Related reference**   

* [CMDB Model Category Stage inbound staging table](https://servicenow-prod.fluidtopics.net/sySbvm6AV2ErxTJ0DbR_AA "The CMDB Model Category Stage inbound [sn_fcms_intg_cmdb_model_category_stage] staging table temporarily stores important data about product model categories before this data is sent to the primary table.")
* [CMDB Service Model Stage inbound staging table](https://servicenow-prod.fluidtopics.net/rn7Ajh_qFwhRRs~~LMqAxA "The CMDB Service Model Stage inbound [sn_fcms_intg_cmdb_service_model_stage] staging table temporarily stores important data about service models before this data is sent to the primary table.")
* [CMN Location Stage inbound staging table](https://servicenow-prod.fluidtopics.net/r2pzhCfLKxS1EZQaYlMObg "The CMN Location Stage inbound [sn_fcms_intg_cmn_location_stage] staging table temporarily stores important data about locations before this data is sent to the primary table.")
* [Catalog Import staging table](https://servicenow-prod.fluidtopics.net/WsNDHhGDMcDjfMcT5vZr6w "The Catalog Import [sn_spend_intg_imp_catalog] staging table temporarily stores important data about catalog imports before this data is sent to the primary table.")
* [Catalog Error staging table](https://servicenow-prod.fluidtopics.net/r3f57F5cDunK3OFuyD5Isg "The Catalog Error [sn_spend_intg_catalog_error] staging table temporarily stores important data about any catalog errors before this data is sent to the primary table.")
* [Cost Center Stage inbound staging table](https://servicenow-prod.fluidtopics.net/_W~jZX99UIajd0C1gfW2fA "The Cost Center Stage inbound [sn_fcms_intg_imp_cost_center] staging table temporarily stores important data about cost centers before this data is sent to the primary table. You can use this table to lookup all the cost center details.")
* [Department Stage inbound staging table](https://servicenow-prod.fluidtopics.net/VmNQ6G1dRncgyiLZFMGg0g "The Department Stage inbound [sn_fcms_intg_department_stage] staging table temporarily stores important data about departments before this data is sent to the primary table.")
* [ERP Plant Address Mapping Stage inbound staging table](https://servicenow-prod.fluidtopics.net/eRcJUwd9kCNNw9GUBalIvg "The ERP Plant Address Mapping Stage inbound [sn_fcms_intg_erp_plant_address_mapping_stage] staging table temporarily stores important data about ERP plant address before this data is sent to the primary table.")
* [FX Currency Stage inbound staging table](https://servicenow-prod.fluidtopics.net/zPxpalWIo1UiMuerILCBaA "The FX Currency Stage inbound [sn_fcms_intg_fx_currency_stage] staging table temporarily stores important data about FX currencies before this data is sent to the primary table.")
* [FX Rate Stage inbound staging table](https://servicenow-prod.fluidtopics.net/j6~T~lUp81K0Z3hVjwSb3A "The FX Rate Stage inbound [sn_fcms_intg_fx_rate_stage] staging table temporarily stores important data about FX rates before this data is sent to the primary table.")
* [Fixed asset details stage inbound table](https://servicenow-prod.fluidtopics.net/9XoedvQEkrlFEgJnDXhF9A "The Fixed asset details inbound [sn_fcms_intg_imp_fixed_asset_details] staging table temporarily stores important data about imported invoice line before this data is sent to the primary table.")
* [GL Account Stage inbound staging table](https://servicenow-prod.fluidtopics.net/eFPhaRummAMFFYEmwtUnwQ "The GL Account Stage inbound [sn_fcms_intg_gl_account_stage] staging table temporarily stores important data about General Ledger (GL) accounts before this data is sent to the primary table.")
* [Import Availability Updates inbound staging table](https://servicenow-prod.fluidtopics.net/nAsziEy0ALyIyTMP_iuZJQ "The Import Availability Updates inbound [sn_spend_intg_imp_availability] staging table temporarily stores important data about cost allocations before this data is sent to the primary table.")
* [Availability Error staging table](https://servicenow-prod.fluidtopics.net/dnKFW18I~5qUaKkooJCF0Q "The Availability Error [sn_spend_intg_availability_error] staging table stores important data about availability error so that an ERP integrator can export this data to a third-party ERP system.")
* [Inbound Cost Allocation staging table](https://servicenow-prod.fluidtopics.net/fP~HEk~1~KqxwQMZ5GHZLA "The Inbound Cost Allocation [sn_spend_intg_imp_cost_allocation] staging table temporarily stores important data about cost allocations before this data is sent to the primary table.")
* [Inbound Invoice staging table](https://servicenow-prod.fluidtopics.net/ViXPGk2jwdm7NIl8WE_VKg "The Inbound Invoice [sn_shop_invoice] staging table temporarily stores important data about shopping invoices before this data is sent to the primary table.")
* [Inbound Purchase Order staging table](https://servicenow-prod.fluidtopics.net/vuRpDZDwdZ629GsI0uWhXw "The Inbound Purchase Order [sn_fcms_intg_imp_order] staging table temporarily stores important data about purchase orders before this data is sent to the primary table.")
* [Inbound Purchase Order Line staging table](https://servicenow-prod.fluidtopics.net/_6yP35znLoXNMnW7SPpKDw "The Inbound Purchase Order Line [sn_fcms_intg_imp_order_line] staging table temporarily stores important data about purchase order lines before this data is sent to the primary table.")
* [Inbound Receipt staging table](https://servicenow-prod.fluidtopics.net/0BaPlsrcfHoOC4XGQlVBoQ "The Inbound Receipt [sn_fcms_intg_imp_receipt] staging table temporarily stores important data about receipts before this data is sent to the primary table.")
* [Legal Entity Stage inbound staging table](https://servicenow-prod.fluidtopics.net/YhUPIstj0WPfg11nTjNCsA "The Legal entity stage inbound [sn_fcms_intg_legal_entity_stage] staging table temporarily stores important data about legal entities before this data is sent to the primary table.")
* [Office Location Stage inbound staging table](https://servicenow-prod.fluidtopics.net/YmQNEc61Bl_Pgac9Y1NnUw "The Office Location Stage inbound [sn_fcms_intg_office_location_stage] staging table temporarily stores important data about office locations before this data is sent to the primary table.")
* [Order Acknowledgement staging table](https://servicenow-prod.fluidtopics.net/_nP4mGJsZWO2U8VWckzK~Q "The Order Acknowledgment [sn_spend_intg_imp_purchase_order_ack] staging table temporarily stores important data about order acknowledgements before this data is sent to the primary table.")
* [Order Acknowledgement Error staging table](https://servicenow-prod.fluidtopics.net/QHWV10EnxZVQeSMJA7Fpzg "The Order Acknowledgement Error [sn_spend_intg_order_ack_error] staging table temporarily stores important data about any errors in the order price imports before this data is sent to the primary table.")
* [Payment Terms Stage inbound staging table](https://servicenow-prod.fluidtopics.net/L4Cer3sid4HG5rL8NGxaGA "The Payment Terms Stage inbound [sn_fcms_intg_payment_term_stage] staging table temporarily stores important data about payment terms before this data is sent to the primary table.")
* [Price Import staging table](https://servicenow-prod.fluidtopics.net/cApy2xx3SLzpds2ppziaOw "The Price Import [sn_spend_intg_imp_price] staging table temporarily stores important data about price imports before this data is sent to the primary table.")
* [Price Error outbound staging table](https://servicenow-prod.fluidtopics.net/Z0EpqDTYVZV15r_Y3AJqAQ "The Price Error [sn_spend_intg_price_error] staging table stores important data about pricing error so that an ERP integrator can export this data to a third-party ERP system.")
* [Product Model Stage inbound staging table](https://servicenow-prod.fluidtopics.net/pUXpMnRL6~XzM0N3seGe7g "The Product Model Stage inbound [sn_fcms_intg_cmdb_model_stage] staging table temporarily stores important data about product models before this data is sent to the primary table.")
* [Purchase Entity Stage inbound staging table](https://servicenow-prod.fluidtopics.net/TmPZ7nJLHcMQWWCsf9nQ2Q "The Purchase Entity Stage inbound [sn_fcms_intg_imp_purchase_entity] staging table temporarily stores important data about purchase entities before this data is sent to the primary table.")
* [Purchase Requisition staging table](https://servicenow-prod.fluidtopics.net/Kg9FwVWRqUe2IznNIYrFqw "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.")
* [Spend Shipment Import inbound staging table](https://servicenow-prod.fluidtopics.net/nhhSzhHFhEGqNKRQIOSkVw "The Spend Shipment Import inbound [sn_spend_intg_imp_shipment] staging table temporarily stores important data about spend shipment imports before this data is sent to the primary table.")
* [Shipment Error staging table](https://servicenow-prod.fluidtopics.net/nK4bkSF_Y5ySUdlTmiUQuA "The Shipment Error [sn_spend_intg_shipment_error] staging table temporarily stores important data on any shipment errors before this data is sent to the primary table.")
* [Supplier Product Stage inbound staging table](https://servicenow-prod.fluidtopics.net/_kr5kXjLTe7aqMHo3uypkA "The Supplier Product Stage inbound [sn_spend_intg_supplier_product_stage] staging table temporarily stores important data about supplier products before this data is sent to the primary table.")
* [Third Party Sourcing Registration staging table](https://servicenow-prod.fluidtopics.net/sPD_Xa5iAovMD8tf0EGVDg "The Third Party Sourcing Registration [sn_spend_intg_sourcing_vendor] table temporarily stores important data on third party sourcing registrations before this data is sent to the primary table.")
* [Third Party Unit Mapping staging table](https://servicenow-prod.fluidtopics.net/zh~zfFbx4hsPl8qOJsPjYw "The Third Party Unit Mapping [sn_spend_intg_third_party_uom_map] staging table temporarily stores important data on third party mapping before this data is sent to the primary table.")
* [Third Party Unit staging table](https://servicenow-prod.fluidtopics.net/7OJ1Fu2Qk3P6EFFwaL2S_w "The Third Party Unit [sn_spend_intg_third_party_uom] staging table temporarily stores important data on third party units before this data is sent to the primary table.")
* [Unit of Measure inbound staging table](https://servicenow-prod.fluidtopics.net/TcnjWHdSl2z8iFHfZB4x7w "The Third Party Unit [sn_fcms_intg_imp_uom] staging table temporarily stores important data on third party units before this data is sent to the primary table.")