A.5 Table: m_po_line_items, Package: m_api_poli - Intergraph Smart Materials - Version 10.3 - Customization & Programming - Hexagon

A.5.1 Procedure: upd_poli

A.5.2 Procedure: ins_poli

A.5.2.1. General Information

This procedure inserts order line items. You can only insert line items on orders of type ’PO’ and ‘MP’. You can also create line items for change orders referencing a (manual) purchase order. You cannot insert line items on change orders referring to a blanket order or a notice of commitment. You cannot create line items for manual POs to which a blanket order has been assigned either. The order header of the line item must not be approved.

When inserting an order line item, the corresponding item shipment is created automatically at the same time. If you need to overwrite any value on such an item shipment, you must make use of the upd_ish procedure in the m_api_ish package. For this reason, this procedure does not only return the primary key of the newly created order line item, but also the primary key of the corresponding item shipment. In case more than one item shipment has been created, the primary key of the first item shipment is returned. This occurs, for example, when inserting a line item on a change order and multiple item shipments have been created for the corresponding order line on the order of type ‘PO’.

When you insert an order line item that references a requisition line item, ident and tag numbers are taken over from the requisition.

You can create a tag number by using the ITY_CODE and TAG_NUMBER column names. If you fill ITY_CODE with an item type the item rule of which is ‘TAB’, ‘TFM’, ‘TOM’, or ‘TWM’ and fill TAG_NUMBER, a tag number is created in the same way as on P.50.07.

In the case of a change order, the value of the POLI_QTY field is regarded as the new value for the order line item. For example, if you have ordered a quantity of 10 on the original order and now you want to cancel a quantity of 3, you must pass 7 to the procedure because 7 is the new quantity to be ordered.

For change orders (apart from PARENT_POLI), only those fields that you want to change have to be passed to the procedure if referencing a previous order line item. All other values are taken over from the referenced, previous line item.

Inserting completely new line items on a change order works in the same way as for purchase orders.

When inserting line items for (manual) purchase orders, you do not have to pass all columns to the procedure. For many fields, default values are assumed. For details see the list in following chapter.

A.5.2.2. Determination of Primary Keys

For retrieving the primary key of an order, an order line item, or a requisition line item, the poh_id, poli_id, and rli_id (and r_id) functions are provided in the m_pck_uk package.

If a negative value is returned, the order, requisition, or line item cannot be found.

Function poh_id

Function poli_id

Function r_id

Function rli_id

Procedure ins_poli

A.5.3 Procedure: ins_detail_poli

This procedure can be used for creating a detail tag for a tagged item (functionality provided in the procurement, expediting, traffic, and site screens through the ‘Split Tag’ button).

A detail tag can only be created on the order line item level if the following conditions are met:

• The item rule of the item type for the ident on this order line item is ‘TAB’, ‘TFM’, ‘TOM’, ‘TWM’, or ‘SWT’.

• The tag number is unlike ‘---‘ and unlike ‘UNTAGGED’.

• The order line item is not a detail tag.

• One requisition line item at most is associated with the order line item.

• The order has not been approved so far or the order is already approved, but a split has already occurred on the order line item level prior to the approval (in this last case, you cannot add detail tags on the item shipment level).

• No split is occurred on the item shipment level (for example, the approval of the order has been taken back but expediting has already created detail tags).

• The order is not a blanket order and not a change order of a blanket order

To create a detail tag using this procedure, you must connect to the project in which you want to create the split.

The p_poli_id parameter must be filled with the primary key of the order line item that represents the master tag.