This API retrieves the material status of the given Tag number or Drawing number from Smart Materials.
-
API retrieves all the Bill of Materials (BOM) Positions (LpId) of the given Drawing number or Tag number from the latest Forecast run.
-
If both Drawing number and Tag number is passed, then the status of the Tag number associated with the given Drawing number is retrieved.
-
If a Forecast run is not available for a ListPostion, then values are retrieved only for LpId, DrawingNumber, and BOMPath properties.
Required Privilege: API_GET_FORECAST_RESULTS
Headers
Header Name |
Description |
Required |
Values |
---|---|---|---|
Authorization |
Access token |
Required |
Bearer <access_token> |
Content-Type |
Request type format |
Required |
application/JSON |
Body
URL Format: POST https://localhost:53215/smat/v1/Projects(':project')/Com.Ingr.Smat.V1.MaterialStatus/
Specify value for the project in the URL. In the body, provide the TimePeriod and BOMNodes details.
Element |
Description |
Type |
Required |
Notes |
---|---|---|---|---|
TimePeriod |
Represents the time that the application considers Time is in days. |
Integer |
Optional |
Maximum allowed time Default value is 180 days. |
BOMNodes |
Collection of three parameters; DrawingNumber, TagNumber, and FahCode |
Collection |
Required |
|
DrawingNumber |
Name of the BOM node If given DrawingNumber is root node, then all the BOM |
String |
Required |
Either DrawingNumber |
TagNumber |
Tag number of the material |
String |
Required |
Either DrawingNumber |
FahCode |
Refers to Forecast/Reservation code in Smart Material |
String |
Optional |
If FahCode is passed, then the material |
Sample Code
POST https://localhost:53215/smat/v1/Projects('DEMO')/Com.Ingr.Smat.V1.MaterialStatus/
{
"filterMatStatus":
{
"TimePeriod":360,
"BOMNodes": [
{
"DrawingNumber": "PB_DEMO1"
}
]
}
}
Success Response
Status: 200 OK
{
"@odata.context": "http://localhost:53427/SMAT/V1/$metadata#Collection(Com.Ingr.Smat.V1.MaterialStatusResult)",
"value": [
{
"LpId": 22320,
"DrawingNumber": "PB_DEMO1",
"FahId": 7525,
"FahType": "Forecast Run",
"ListPosition": "1",
"ListPositionStatus": "Complete",
"StatId": 5186,
"CommodityCode": "GSWAB6DFFAA7ZZZ",
"CommodityCodeShortDesc": " Sp. Wound Gskt , ASME B16.20 , CL 150 , FF , 304-W, mica/graph-F, CS-CR, 304-IR ",
"Size1": ".5",
"Size2": "4.5",
"Size3": "0",
"Size4": "0",
"ShortCode": null,
"IdentCode": "I2544336",
"IdentDesc": ".5 x 4.5 Sp. Wound Gskt, ASME B16.20, CL 150, FF , 304-W, mica/graph-F, CS-CR, 304-IR",
"TagNumber": null,
"BOMPath": "/PB_DEMO1",
"SplitTagIndicator": "N",
"DetailTagsBOMPath": null,
"BOMQty": 100,
"OutstandingQty": 67,
"TotalIssuedQty": 33,
"ListPosResvQty": 0,
"ForecastShortQty": -33,
"TotalResvQty": 100,
"TotalManResvQty": 0,
"ActualResvQty": 100,
"SubTransStatus": null,
"IsSubst": "N",
"IsTrans": "N",
"SubResvQty": null,
"UnitId": 5297,
"UnitCode": "pc",
"TotalOnHandQty": 189,
"TotalAllocatedQty": 100,
"ForecastResults": [
{
"WhId": 5253,
"WhCode": "PB_WH2_IS",
"LocId": 5000,
"LocCode": "A1",
"RecvStatus": "ACCEPTED",
"IdentCode": "I2544336",
"CommodityCode": "GSWAB6DFFAA7ZZZ",
"IviId": 5862,
"SubstInd": "N",
"TransInd": "N",
"ReceivedQty": 200,
"TotalResvQty": 0,
"ActualResvQty": 100,
"ManResvQty": 0,
"IssuedQty": 11,
"OnHandQty": 189,
"AllocatedQty": 100,
"AllocationType": "Inventory",
"ETADate": null,
"PromOnSiteDate": null,
"ROSDate": null
}
],
"MIRDetails": [
{
"MIRNumber": "PB_MIRDEMO",
"MIRType": "MIR By BOM Commodity",
"IssuedQty": 20,
"MirId": 5760,
"IviId": 5886,
"IisId": 6261,
"RevisionId": 1,
"PostedDate": null
},
{
"MIRNumber": "PB_MIRDEMO",
"MIRType": "MIR By BOM Commodity",
"IssuedQty": 11,
"MirId": 5626,
"IviId": 5862,
"IisId": 6023,
"RevisionId": 0,
"PostedDate": "2020-12-14T14:04:05+05:30"
}
],
"ListPositionAttrs": [
{
"AttributeId": 5426,
"AttributeCode": "REQ_NO",
"AttributeValue": null
},
{
"AttributeId": 5428,
"AttributeCode": "INS_TYPE",
"AttributeValue": null
}
]
}
]
}
Element |
Description |
Type |
---|---|---|
FahId |
Unique ID of the given Forecast /Reservation header |
Integer |
LpId |
Unique ID of the list position Represents BOM positions. |
Integer |
ListPosition |
Unique position of the structure-element |
String |
CommodityCode |
Name or code of the commodity |
String |
CommodityCodeShortDesc |
Short description of the commodity code |
String |
Size (1-4) |
Commodity size Four different values are allowed. |
String |
IdentCode |
Represents BOM ident code/name or ident assigned to a list position. |
String |
BOMQty |
Quantity of the BOM position |
Integer |
BOMPath |
Path description starting from the root node till the given list node (drawing number). |
String |
TotalIssuedQty |
Total issued quantity of the BOM position |
Decimal |
UnitId |
Unique ID of the unit |
Integer |
UnitCode |
Represents quantity unit |
String |
ForecastShortQty |
Represents the difference between the outstanding quantity and the |
Decimal |
TotalAllocatedQty |
Represents the sum of actual, manual reserved, |
Decimal |
TotalOnHandQty |
Total on hand quantity for this BOM position |
Decimal |
ListPosResQty |
Represents the sum of the reserved quantity of all the Reservation Runs for this position. In Smart Materials, this refers to List Pos Resv Qty. |
Decimal |
SplitTagIndicator |
Indicates whether the tag item is splitted or not. |
String |
DetailTagsBOMPath |
BOM path of the detail tags. If SplitTagIndicator is N, then DetailTagsBOMPath will be null. |
String |
FahType |
Specifies type of Run. Run can be a Forecast Run or Reservation Run. |
String |
StatId |
Unique ID of the associated issue status |
Integer |
ShortCode |
Specifies the short code |
String |
ListPositionStatus |
Status of the list position. Available options are:
|
String |
IdentDesc |
Description of the BOM ident |
String |
OutstandingQty |
Represents the quantity that is not issued or reserved against a list position. |
Decimal |
TotalResvQty |
Represents the sum of TotalManResvQty and ActualResvQty |
Decimal |
ActualResvQty |
Represents the quantity reserved/forecasted by a Forecast/Reservation run and is calculated at BOM position level. |
Decimal |
TotalManResvQty |
Represents the total manual reserved quantity of list position. |
Decimal |
IsTrans |
Indicates transformation. |
String |
IsSubst |
Indicates substitution. If value is Y, then the substituted ident(s) are available for the BOM position in this Forecast/Reservation run |
String |
SubResvQty |
Represents quantity of substituted/transformed ident code that is to be reserved.
|
Decimal |
SubTransStatus |
Status of the completion by substitute/transformation. Available options are:
|
String |
-
Forecast Results (ForecastResults)
Element |
Description |
Type |
---|---|---|
ETADate |
Expected time of arrival of the material. |
Date time Offset |
ROSDate |
Date and time when the material is Required on Site |
Date time Offset |
OnHandQty |
On-hand quantity of this inventory item in the displayed warehouse location. |
Decimal |
AllocatedQty |
Quantity that is forecasted by this job. In Smart Materials, this refers to the sum of Actual ResvQty and Manual Resv Qty. |
Decimal |
WhId |
Unique ID of the associated warehouse |
Integer |
WhCode |
Name of the associated warehouse |
String |
LocId |
Unique ID of the location |
Integer |
LocCode |
Name of the location |
String |
AllocationType |
Defines the level where the material is allocated.
|
String |
PromOnSiteDate |
Promised on Site date |
Date Time Offset |
RecvStatus |
Status of the received material in site |
String |
IdentCode |
Unique code or name of the ident.
|
String |
CommodityCode |
Unique code or name of the commodity |
String |
IviId |
Unique ID of the inventory item |
Decimal |
SubstInd |
Indicates whether the ident is a substitute ident or not. |
String |
TransInd |
Indicates whether the ident is a transformation ident or not. |
String |
ReceivedQty |
Quantity received on site for this inventory item |
Decimal |
TotalResvQty |
Quantity reserved for the inventory or shipment item by a specific forecast or reservation run. This also includes the quantity assigned to unposted MIR if "Exclude MIR Qty's" is set to Y in forecast/reservation run. However, this excludes the substituted/transformed reserved quantity. |
Decimal |
ActualResvQty |
Represents the quantity that is either forecasted |
Decimal |
ManResvQty |
Manually reserved quantity against the inventory item related to forecast/reservation run. |
Decimal |
IssuedQty |
Issued quantity of the inventory item |
Decimal |
-
Material Issuing Report (MIR) details
MIR details is a collection and consist of all the MIRs of the corresponding BOM position.
Element |
Description |
Type |
---|---|---|
MIRNumber |
Name of the MIR |
String |
MIRType |
Type of MIR. Available options are:
|
String |
IssuedQty |
Issued quantity of the list position associated with the given MIR |
Decimal |
MirId |
Unique ID of the retrieved Material Issue Report |
Integer64 |
IviId |
Unique ID of the retrieved inventory item |
Decimal |
IisId |
Unique ID of the inventory issue |
Integer64 |
RevisionId |
Unique revision ID of the MIR. Default value is 0. |
Integer16 |
PostedDate |
Date when the MIR was posted in the inventory |
Date Time Offset |
-
List Position Attributes (ListPositionAttrs)
Element
Description
Type
AttributeId
Unique ID of the attribute
Decimal
AttributeCode
Unique code of the list position attribute
String
AttributeValue
Value of the list position attribute
String