ScrapReason
Property
|
Description
|
Table
|
BEAS_REASONFORSCRAP
|
Primary key
|
ScrapId/c
|
$transaction
|
no
|
$branch
|
no
|
$mask
|
no
|
Fields
Name
|
Type
|
Description
|
ScrapId
|
Edm.String(30)
|
ID of the scrap reason
Mandatory field
Primary key
Database: "BEAS_REASONFORSCRAP"."SCRAP_ID"
|
|
ScrapDescription
|
Edm.String(255)
|
Description of this Scrap. The Sytem copy this in the Scrap Table from Time receipt. User can change this,
if Discription Changeable not disabled.
Database: "BEAS_REASONFORSCRAP"."SCRAPDESCRIPTION"
|
|
Active
|
Edm.Boolean
|
Default Value: 1
Constraints:
Yes=1
No=0
Database: "BEAS_REASONFORSCRAP"."AKTIV"
|
|
DescriptionNoEdit
|
Edm.Boolean
|
In Time receipt - Scrap reason you can see the description and you can change this description
if this flag is active, the user can't change the description
Default Value: 0
Constraints:
Changes allowed=0
Changes not allowed=1
Database: coalesce("BEAS_REASONFORSCRAP"."LockDescription",0)
|
|
CheckQuantity
|
Edm.Boolean
|
In Time receipt you can insert the quantity for every scrap
If the flag "CheckQuantity" is disabled, the system ignore the Quantity
You can use this, if you need the possibility to define different scraps for one unit...
Default Value: 1
Database: "BEAS_REASONFORSCRAP"."CheckQuantity"
|
|
FilterProductionTypeId
|
Edm.String(255)
|
You can define the filter by work order type. The user can choose the Scrap reason only,
if work order type part of this list, which you can define here
Database: "BEAS_REASONFORSCRAP"."FilterFtTyp"
|
|
FilterResourceId
|
Edm.String(255)
|
You can define filter by resource. The user can choose the Scrap reason only,
if Resource part of this list, which you can define here
Database: "BEAS_REASONFORSCRAP"."FilterAplatz_id"
|
|
FilterPersonnelId
|
Edm.String(255)
|
You can define filter by Employee. The user can choose the Scrap reason only,
if Employee (BEAS_PERS.PERS_ID) part of this list, which you can define here
Database: "BEAS_REASONFORSCRAP"."FilterPers_id"
|
|
ScrapColor
|
Edm.Int32
|
Database: "BEAS_REASONFORSCRAP"."Color"
|
|
ScrapBitmap
|
Edm.String(50)
|
Database: "BEAS_REASONFORSCRAP"."BITMAPNAME"
|
|
UDF1
|
Edm.String(50)
|
Database: "BEAS_REASONFORSCRAP"."UDF1"
|
|
UDF2
|
Edm.String(50)
|
Database: "BEAS_REASONFORSCRAP"."UDF2"
|
|
UDF3
|
Edm.String(50)
|
Database: "BEAS_REASONFORSCRAP"."UDF3"
|
|
UDF4
|
Edm.String(50)
|
Database: "BEAS_REASONFORSCRAP"."UDF4"
|
|
ForPersonnelId
|
Edm.String(20)
|
You can define filter by Employee. The user can choose the Scrap reason only,
if Employee (BEAS_PERS.PERS_ID) part of this list, which you can define here
Database: case when coalesce("BEAS_REASONFORSCRAP"."FilterPers_id" ,'')='' or "BEAS_REASONFORSCRAP"."FilterPers_id" like '%'++'%' then else '' end
|
|
ForResourceId
|
Edm.String(20)
|
Return only Scrap Reasons for this Resource
ScrapReason?$filter=ForResourceId eq 'YourResourceId'
You can define filter by resource. The user can choose the Scrap reason only,
if Resource part of this list, which you can define here
Database: case when coalesce("BEAS_REASONFORSCRAP"."FilterAplatz_id" ,'')='' or "BEAS_REASONFORSCRAP"."FilterAplatz_id" like '%'++'%' then else '' end
|
|
ForProductionTypeId
|
Edm.String(20)
|
Only for Filter
Return only Scrap Reasons for this Production Type
ScrapReason?$filter=ForProductionTypeId eq 'YourProductionType'
You can define the filter by work order type. The user can choose the Scrap reason only,
if work order type part of this list, which you can define here
Database: case when coalesce("BEAS_REASONFORSCRAP"."FilterFtTyp" ,'')='' or "BEAS_REASONFORSCRAP"."FilterFtTyp" like '%'++'%' then else '' end
|
|
Display all information for Scrap reason "ToolBroken"
odata4/ScrapReason("ToolBroken")
{
"value": {
"ScrapId": "ToolBroken",
"ScrapDescription": "Tool is broken",
"Active": false,
"DescriptionNoEdit": false,
"CheckQuantity": true,
"FilterProductionTypeId": null,
"FilterResourceId": null,
"FilterPersonnelId": null,
"ScrapColor": 5701632,
"ScrapBitmap": "bmp\\montage.png",
"UDF1": null,
"UDF2": null,
"UDF3": null,
"UDF4": null,
"ForPersonnelId": "",
"ForResourceId": "",
"ForProductionTypeId": ""
}
}