Item Version Number
Property
Description
Table
OITM Alias ,ItemVersionDefault,
Primary key
ItemCode/c,IVersionId/c
$transaction
yes
$branch
no
$mask
For dropdown you can use follow mask definition:
Fields
Name
Type
Description
ItemCode
Edm.String(50)
Entity Relation: Item -> ItemCode
Integration hub: Importable
Mandatory field
Primary key
Database: "OITM"."ItemCode"
IVersionId
Edm.String(20)
If no version exists and the primary key is not defined, beas returns version 1.
Example:
ItemVersion?$filter=ItemCode eq "Sofa0002_000"
Returns all version numbers.
If no entry exists for this item, beas returns version 1.
Integration hub: Importable
Mandatory field
Primary key
Database: coalesce("BEAS_ITEM_VERSION"."Version",'')
Revision
Edm.String(20)
Integration hub: Importable
Database: coalesce("BEAS_ITEM_VERSION"."RevisionLevel",'')
Description
Edm.String(100)
If no description is available, BSL returns the description from the item.
Integration hub: Importable
Database: case when coalesce("BEAS_ITEM_VERSION"."DESCRIPTION",'')='' then "OITM"."ItemName" else "BEAS_ITEM_VERSION"."DESCRIPTION" end
DrawingNumber
Edm.String(50)
If the drawing number is null or empty, BSL returns the drawing number from the item.
Integration hub: Importable
Database: case when coalesce("BEAS_ITEM_VERSION"."ZNR",'')='' then "OITM"."U_znr" else "BEAS_ITEM_VERSION"."ZNR" end
StatusId
Edm.String(20)
Entity Relation: ItemVersionStatus -> StatusId
Status of this Version. This field is mandatory
Linked table: BEAS_ITEM_VERSION_STATUS
Linked column: Status
Integration hub: Importable
Mandatory field
Database: "BEAS_ITEM_VERSION"."Status"
IVersionColor
Edm.Int32
Integration hub: Importable
Database: coalesce("BEAS_ITEM_VERSION"."COLORID",0)
IVersionBitmap
Edm.String(50)
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."BITMAPNAME"
BillOfMaterialId
Edm.String(50)
Database: rtrim("BEAS_ITEM_VERSION"."StlItemCode")
RoutingId
Edm.String(50)
Database: "BEAS_ITEM_VERSION"."RoutingId"
ValidFrom
Edm.DateTimeOffset
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."DateFrom"
ValidTo
Edm.DateTimeOffset
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."DateTo"
Release
Edm.Boolean
Default Value: 1
Constraints:
Yes=1
No=0
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."Release"
ReleaseDate
Edm.DateTimeOffset
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."ReleaseDate"
Block
Edm.Boolean
Constraints:
Yes=1
No=0
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."Block"
BlockReason
Edm.String
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."BlockReason"
BlockDate
Edm.DateTimeOffset
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."BlockDate"
UDF1
Edm.String(50)
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."UDF1"
UDF2
Edm.String(50)
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."UDF2"
UDF3
Edm.String(50)
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."UDF3"
UDF4
Edm.String(50)
Integration hub: Importable
Database: "BEAS_ITEM_VERSION"."UDF4"
Relations
Join to Entiy Object
Relation
Item
ItemCode
ItemVersionStatus
StatusId
Example
See Item Version Details for one item and one Version
/odata4/ItemVersion("FP_B_S_V","0001")
{
"value" : {
"ItemCode" : "FP_B_S_V" ,
"IVersionId" : "0001" ,
"Revision" : "" ,
"Description" : "Finished Product / Batch / Make To Stock / Version - release" ,
"DrawingNumber" : null ,
"StatusId" : "release" ,
"IVersionColor" : 0 ,
"IVersionBitmap" : null ,
"BillOfMaterialId" : null ,
"RoutingId" : null ,
"ValidFrom" : "" ,
"ValidTo" : "" ,
"Release" : true ,
"ReleaseDate" : "2019-01-10T15:31Z" ,
"Block" : false ,
"BlockReason" : null ,
"BlockDate" : "" ,
"UDF1" : null ,
"UDF2" : null ,
"UDF3" : null ,
"UDF4" : null
}
}
Display all Item Versions for one Item which i can use for Issue Document
odata4/ItemVersion ? $transaction= issue & $filter=ItemCode eq "FP_B_S_V" &select=StatusId
{
"value" : [
{ "StatusId" : "release" },{ "StatusId" : "construction" },{ "StatusId" : "inspection" },{ "StatusId" : "run-out" },{ "StatusId" : "locked" }
]
}
Display Item Version with Status Details
odata4/ItemVersion("FP_B_S_V","0001")?$select=StatusId,Description,ItemVersionStatus&$expand=ItemVersionStatus
{
"value" : {
"StatusId" : "release" ,
"Description" : "Finished Product / Batch / Make To Stock / Version - release" ,
"ItemVersionStatus" : [
{
"StatusId" : "release" ,
"StatusDescription" : "release" ,
"StatusRelease" : true ,
....
"CanGRPO" : true ,
"CanPurchaseInvoice" : true ,
"CanCapacityPlanning" : true ,
}
]}}
