Get Totals by Commodity Code - Intergraph Smart Materials - Version 2017 R2 (2.2) - Help - Hexagon

Intergraph Smart Materials Web API Help 2017 R2 (2.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web API
Search by Category
Help
Version Smart Materials Web API
2017 R2 (2.2)

This API retrieves the total quantities of all the idents that belong to the given commodity code within the individual modules, in a project of Smart Materials.

Required Privilege: API_ITEM_DETAILS

Headers

Header Name

Description

Required

Values

Authorization

Access token

Required

Bearer <access_token>

Content-Type

Request type format

Required

application/JSON

Body

HTTP Method: POST

URL Format:

https://{host}/Smat/V1/Projects(':project')/Disciplines(':discipline')/Nls(':language')/Commodities({key})/CommodityTotals

Specify values for the project, discipline, language, and key parameter in the URL. The project, discipline, and language, together define the project environment. The key parameter defines the commodity ID.

Sample Code

POST https://localhost:59387/smat/v1/Projects('RS')/Disciplines('PIPING')/Nls('English')/Commodities(10000243189)/CommodityTotals

{

  "ItemDetailsInput":

        {

           "InterestedTotals": ["BOM", "Req", "Inquiry","Order","Traffic","MLDIssue","ProvisionalReserved","OnHand"]

                                                }

        }

  • In the request body, you can specify the module names to "InterestedTotals" which you are looking for. Only these interested total quantities are retrieved and others are displayed as null. Valid inputs for InterestedTotals are BOM, Req, Inquiry, Order, Shipped, Traffic, Received, StockReceipt, BOMIssue, DirectIssue, MLDIssue, Reserved, ProvisionalReserved, OpenOSDs, and OnHand.

  • If you don't select any InterestedTotal, then the API retrieves all the total quantities.

  • If there is no quantity associated with a total , then the value is displayed as 0.

Success Response

Status:200OK

{

  "@odata.context": "https://localhost:59387/SMAT/V1/$metadata#Collection(Com.Ingr.Smat.Core.V1.ItemTotalsInfo)",

  "value": [

    {

      "Ident": 10000504671,

      "UnitId": 500127,

      "BOMTotal": 300,

      "ReqTotal": 100,

      "InquiryTotal": 10,

      "OrderTotal": 60,

      "ShippedTotal": null,

      "TrafficActivityTotal": 10,

      "ReceivedTotal": null,

      "StockReceiptTotal": null,

      "BOMIssueTotal": null,

      "DirectIssueTotal": null,

      "MLDIssueTotal": 0,

      "ReservedTotal": null,

      "ProvisionalReservedTotal": 19,

      "NumberOfOpenOSDs": null,

      "OnHandTotal": 10

    }

  ]

}

Element

Description

Type

Ident

Unique ID of the ident

Integer

BOMTotal

Total sum of quantity of this ident on BOM

Integer

ReqTotal

Total sum of quantities of this ident on all the requisition line items
that are released to procurement.

Requisitions that are used for purchase (Purchase indicator is checked)
are taken into account.

Integer

InquiryTotal

Total sum of quantity of this ident on inquiries.
The value is calculated from M_PCK_REQ_CUSTOM.SUM_INQUIRY,
using the 1st output parameter P_SUM_FIELD.

Integer

OrderTotal

Total sum of quantity of this ident on approved Purchase Orders
and Notices of Commitment (NOC).
However, only those NOCs that are not closed are considered.

Integer

ShippedTotal

Total sum of quantity of this ident on item shipments

Integer

TrafficActivityTotal

Total sum of quantity of this ident on Traffic
i.e. on material receipts (traffic type MR), bills of lading (BOL),
and containers (CNT).

Integer

ReceivedTotal

Total sum of received quantities of this ident.

  • However, if the selected ident is a master tag and
    all its detail tags are received completely,
    only then the received quantity of this master tag is set to 1.

  • Also, this quantity depends on the project default ZC_QTYMTAG.

  • If ZC_QTYMTAG is set to N, a master tag is marked as received,
    if all its detail tags are fully received,
    regardless of whether the master tag is closed or not.
    If it is set to Y, a master tag is marked as received,
    only if it is closed and all its detail tags are fully received.

Integer

StockReceiptTotal

Total sum of stock receipt for this ident.

Integer

BOMIssueTotal

Total sum of BOM issue for this ident.

  • However, if the selected ident is a master tag and
    all its detail tags are issued completely,
    only then the issued quantity of this master tag is set to 1.

  • Also, this quantity depends on the project default ZC_QTYMTAG.

  • If ZC_QTYMTAG is set to N, a master tag is marked as issued,
    if all its detail tags are fully issued regardless of whether the master tag is closed or not.
    If it is set to Y, a master tag is marked as issued, only if it is closed and all its detail tags are fully issued.

Integer

DirectIssueTotal

Total sum of direct issue for this ident.

  • However, if the selected ident is a master tag and
    all its detail tags are issued completely,
    only then the issued quantity of this
    master tag is set accordingly.

  • Also, this quantity depends on the project default ZC_QTYMTAG.

  • If ZC_QTYMTAG is set to N, a master tag is marked as issued,
    if all its detail tags are fully issued regardless of whether the master tag is closed or not.
    If it is set to Y, a master tag is marked as issued,
    only if it is closed and all its detail tags are fully issued.

Integer

MLDIssueTotal

Total sum of quantity of this ident issued with a
MIR with issue type Miss, Lost, or Damaged

Integer

ReservedTotal

Total sum of quantity of this ident already reserved on the BOM.

  • However, if the selected ident is a master tag and
    all its detail tags are reserved completely,
    only then the reserved quantity of this master tag is set to 1.

  • Also, this quantity depends on the project default ZC_QTYMTAG.

  • If ZC_QTYMTAG is set to N, a master tag is marked as reserved,
    if all its detail tags are fully reserved regardless of whether the master tag is closed or not.
    If it is set to Y, a master tag is marked as reserved, only if it is closed and all its detail tags are fully reserved.

Integer

ProvisionalReservedTotal

Total sum of the provisional reserved quantity for this ident.

It cover all the reservations done manually.

It includes the quantities that are entered in any MIR screen (apart from C.20.21 MIR by Reservation)
and the quantities that surmount the quantity
determined by a reservation run.

For example, if the reservation run has reserved a quantity of 10
and you enter an issue quantity of 15 in screen C.20.21 the delta quantity of 5
is part of this provisional reserved quantity.

Integer

NumberOfOpenOSDs

Represents the number of over, short, and damaged reports (OS&Ds) for the selected ident

Integer

OnhandTotal

Inventory On Hand Quantity (Recv Qty - Resv Qty - Issue Qty)

Integer

UnitId

Refers to the quantity unit ID.
This unit is determined by calling CIP procedure m_pck_req_custom.qty_unit.

The quantities will be converted to this unit shown based on the conversion factor defined in A.10.13 Unit to Unit.

Integer