Description

Procedure returns supplier orderlines for a given supplier order.

Request Parameters

#	Name	Type	Required	Example	Description
1	SOrderRef	integer	0	123
2	LocID	string	0	A	Filter for pixi* location connected to the supplier order.
3	OpenOrderlines	boolean	0	0/1	When set to "1" only lines that have an open delivery quantity will be shown.

Request body

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dem="https://api.pixi.eu/soap/demosandbox/">
   <soapenv:Header/>
   <soapenv:Body>
      <dem:pixiGetSOrderlines>
         <dem:SOrderRef>123</dem:SOrderRef>
         <dem:LocID>A</dem:LocID>
         <dem:OpenOrderlines>0/1</dem:OpenOrderlines>
      </dem:pixiGetSOrderlines>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Supplier orderlines that fit the conditions specified by the input parameters.

#	Name	Type	Description
1	Detail	integer	Dummy field. Always returns 0.
2	Detail2	integer	Dummy field. Always returns 0.
3	ArtNr	string	Barcode of the item from corresponding supplier.
4	ArtName	string	Name of the item.
5	OrderQty	integer	Quantity of ordered items.
6	ReceiveDate	string	Current date.
7	Status	string	Supplier order status.
8	CreateDate	string	Create date of the supplier order line.
9	CreateEmp	string	User who created the supplier order.
10	UpdateDate	string	Last update date of the supplier order line.
11	UpdateEmp	string	User who last updated the supplier order line.
12	SOrderlineKey	integer	ID of supplier orderline.(key)
13	SitemRef	integer	ID of item.
14	SOrderRef	integer	ID of supplier order.
15	XMLconfirm	boolean	DF (Direct Fullfilement) XML confirm flag.
16	SOrderlineNr	integer	ID of supplier order.
17	Note	string	Supplier orderline comment.
18	EstimatedDelivery	string	Date of estimated delivery.
19	VKPrice	number	Current selling price of the item.
20	SummaryQuantity	integer	Current quantity of the item.
21	LocationQuantity	integer	Current quantity of the item on specified location.
22	QtyReceived	integer	Quantity of delivered items.
23	QtyNotDelivered	integer	Quantity of items that were not yet delivered.
24	MinOrderQty	integer	Minimum order quantity for the item.
25	MinStockQty	integer	Minimum stock quantity for the item.
26	OrderUnit	string	Specified order unit for the item.
27	ItemNrSuppl	string	Supplier item number.
28	ItemNrInt	string	Shop item number.
29	VATperc	string	VAT percent for the item.
30	EKprice	number	Supplier price for the item.
31	EKValue	number	Supplier price value of supplier orderline.
32	Hal_Cust_O	integer	Open customer orders for the item on status "HAL".
33	Open_Cust_O	integer	Open customer orders for the item on status "ANG".
34	Open_Suppl_O	integer	Item quantity of supplier open supplier orders.
35	L30	integer	Item demand in last 30 days.
36	L120	integer	Item demand in last 120 days.
37	L365	integer	Item demand in last 365 days.
38	StockQty	integer	Current stock of the item.
39	Price	number	Item price connected to an order line.
40	TotalQtyReceived	integer	Real quantity delivered.
41	FinalPrice	number	Supplier price times quantity minus discount.

Additional Notes

**Important**
*TotalQtyReceived* returns the total received item quantity of the item which is matched to a goods receipt document. In case the item of the receipt document is matched to several purchase orders, each order line of the purchase order shows the same total received item quantity value.
It is therefore recommended, to only use the column if goods receipt documents are created using purchase order(s) as a template.