Outbound Order Line staging table

The Outbound Order Line [sn_spend_intg_outbound_purchase_order_line] staging table stores important data about the purchase order lines created so that an ERP integrator can export this data to a third-party ERP system.

The following table lists the key fields for the Outbound Order Line [sn_spend_intg_outbound_purchase_order_line] staging table.

Note:

There are no mandatory fields for this table.

Table 1. Outbound Order Line staging table

Field	Data type	Description
Account assignment category	String	Account assignment category of the purchase order line.
Asset category	String	Asset category of the purchase order line.
City	String	City of the purchase order line.
Contract number	String	Contract number of the purchase order line.
Cost center	String	Cost center that incurs the cost of the purchase order line.
Country	String	Name of the country of the purchase order line.
Enroll in ABM	String	Option to enroll the purchase order line for an Apple Business Manager (ABM) account.
ERP line number	String	Purchase order line number from the ERP system.
Expected delivery date	String	Expected delivery date of the purchased product.
GL account	String	General Ledger (GL) account associated with the purchase order line.
Integration status	String	Current status of the purchase order line integration.
Location name	String	Location of the purchase order line.
Manufacturer part number (MPN)	String	Manufacturer or publisher’s unique identifier for the product, which the customer desires to purchase.
Model number	String	Unique model number of the product.
Organization ID	String	Organization ID of the purchase order line.
Processing message	String	A message that describes the current processing status of the purchase order line.
Product category	String	Product category that the purchase order line belongs to.
Product name	String	Name of the product associated with the purchase order line.
Product type	String	Type of the product associated with the purchase order line.
Purchase order	String	Purchase order associated with the purchase order line.
Purchase order line number	String	Line number of the purchase order line.
Purchase order line status	String	Current status of the purchase order line.
Purchased quantity	String	Quantity purchased as part of the purchase order line.
Recipient	String	Recipient of the purchase order line.
Service end date	String	Date on which service is expected to end. This is applicable only if the Product type is Service.
Service start date	String	Date on which service is expected to be rendered. This is applicable only if the Product type is Service.
Ship to	String	Shipping location of the purchase order line.
Short text	String	Brief description about the purchase order line.
State	String	State or province of the purchase order line.
Street	String	Street address of the purchase order line.
Supplier part number	String	The supplier’s unique identifier for the product, which the customer desires to purchase.
Unit	String	Unit of rate at which the customer purchases the product.
Unit price	String	The price of each individual unit is purchased.
Unit price currency	String	The currency in which the order is placed.
Zip code	String	Zip code of the purchase order line.