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"
|
|