Name
|
Type
|
Description
|
BillOfMaterialId
|
Edm.String(50)
|
Id of bill of material
Linked to header of bom (BEAS_STL_HEADER)
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_STL"."ItemCode"
|
|
LineNumber
|
Edm.Int32
|
internal position number id (not visible)
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_STL"."POS_ID"
|
|
SortId
|
Edm.Int32
|
Define the sorting in the bom list self
Integration hub: Importable
Database: coalesce("BEAS_STL"."SortId","BEAS_STL"."POS_ID")
|
|
Position
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_STL"."POS_TEXT"
|
|
ItemCode
|
Edm.String(50)
|
If you change this property by BSL or DIH, the system overwrite Length,Width,Height, Input Unit = Production Unit), RoundTye and RoundDecimal from Unit of Measurement
If you want to define own Size, define this after changing the itemcode
Material number of item
linked to OITM.ItemCode
Import: If you insert a unknown itemcode, beas move this imtecode in field "userfield" and insert the "unknown itemcode" which you can set in the configuration wizzard
Integration hub: Importable
Database: "BEAS_STL"."ART1_ID"
|
|
UseOwnDescription
|
Edm.Boolean
|
if activ, beas use description and drawing number from this position (Field DESCRIPTION and ZNR)
if not activ, beas use the description and drawing number from the item or choosed Version number
Constraints:
yes=1
no=0
Integration hub: Importable
Database: coalesce("BEAS_STL"."UseOwnDescription",0)
|
|
Description
|
Edm.String(100)
|
Database: case when "BEAS_STL"."UseOwnDescription"=1 then "BEAS_STL"."DESCRIPTION" else o."ItemName" end
|
|
IVersionId
|
Edm.String(20)
|
Integration hub: Importable
Database: coalesce("BEAS_STL"."Version",'')
|
|
DrawingNumber
|
Edm.String(100)
|
Database: case when "BEAS_STL"."UseOwnDescription"=1 then "BEAS_STL"."ZNR" else o."U_znr" end
|
|
Info
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL"."INFO"
|
|
UserText
|
Edm.String(255)
|
Integration hub: Importable
Database: "BEAS_STL"."UserText"
|
|
InputQuantity
|
Edm.Decimal
|
Determines the requirement in entry units per assembly in Input UoM.
Usually, the entry unit is the consumption unit of the selected item,
Default Value: 1
Integration hub: Importable
Mandatory field
Database: coalesce("BEAS_STL"."INPUT_QTY","BEAS_STL"."MENGE_VERBRAUCH")
|
|
InputUnit
|
Edm.String(20)
|
Database: rtrim(coalesce("BEAS_STL"."INPUT_UNIT",o."U_me_verbr"))
|
|
InputFactor
|
Edm.Decimal
|
Default Value: 1
Database: coalesce("BEAS_STL"."INPUT_FACTOR",1)
|
|
QuantityPer
|
Edm.Decimal
|
Default Value: 1
Integration hub: Importable
Database: coalesce("BEAS_STL"."MENGE_JE",1)
|
|
ScrapQuantity
|
Edm.Decimal
|
Scrap for bom
Integration hub: Importable
Database: "BEAS_STL"."AUSSCHUSS"
|
|
ScrapPercent
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_STL"."ScrapPercent"
|
|
RoundingType
|
Edm.Decimal
|
type of rounding
Constraints:
no rounding=-1
commercial=0
round up=1
round down=2
multiple of=3
Integration hub: Importable
Database: coalesce("BEAS_STL"."ROUND_TYPE",1)
|
|
RoundingDecimal
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: coalesce("BEAS_STL"."ROUND_DEC",1)
|
|
BomColor
|
Edm.Int32
|
Integration hub: Importable
Database: "BEAS_STL"."COLORID"
|
|
BomBitmap
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_STL"."BITMAPNAME"
|
|
RoutingPosition
|
Edm.Decimal
|
Bom linked to this operation
Operation is linked with
item without separat bom: same id as the bom
item with separat bom: id of routing is in BEAS_STL_HEADER.ROUTINGID
Attention: Import don't check the link information.
Integration hub: Importable
Database: case when coalesce("BEAS_STL"."APLANPOS_ID",0)=0 then (select min(fa1."POS_ID") from "BEAS_APL" as fa1 where fa1."ItemCode"="BEAS_STL"."ItemCode" and fa1."SortId" = (select min(fa2."SortId") from "BEAS_APL" as fa2 where fa2."ItemCode"="BEAS_STL"."ItemCo
|
|
Length
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_STL"."ABM1"
|
|
Width
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_STL"."ABM2"
|
|
Height
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_STL"."ABM3"
|
|
WarehouseId
|
Edm.String(20)
|
Linked table: OWHS
Linked column: WhsCode
Integration hub: Importable
Database: "BEAS_STL"."WhsCode"
|
|
BinCode
|
Edm.String(203)
|
The bin location must be a valid location for the warehouse selected
Integration hub: Importable
Database: "BEAS_STL"."BINCODE"
|
|
Active
|
Edm.Boolean
|
Default Value: J
Constraints:
activ=J
not activ=N
Integration hub: Importable
Database: "BEAS_STL"."AKTIV"
|
|
OnlyReservation
|
Edm.Decimal
|
Default Value: 0
Constraints:
yes=1
no=0
Integration hub: Importable
Database: "BEAS_STL"."OnlyReservation"
|
|
DontBookScrap
|
Edm.Decimal
|
if activ, the backflushig process don't book the scrap quantity
Default Value: 0
Constraints:
yes=1
no=0
Integration hub: Importable
Database: "BEAS_STL"."DontBookScrap"
|
|
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_STL"."GUELTIG_VON"
|
|
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_STL"."GUELTIG_BIS"
|
|
ShortVariant
|
Edm.String(1)
|
Define, with which variant the subassembly have to breakdown
if empty, then use Variant from parent
Value can be empty or A-Z
Constraints:
A=A
B=B
C=C
D=D
E=E
F=F
G=G
H=H
I=I
J=J
K=K
L=L
M=M
N=N
O=O
P=P
Q=Q
R=R
S=S
T=T
X=X
Y=Y
Z=Z
Integration hub: Importable
Database: "BEAS_STL"."SHORTVARIANT"
|
|
ShortVariantFilter
|
Edm.String(1)
|
Variant Definition
A-Z, String with JNJNNNNNNNNNNNNNNNNNNNNNNNN
J=Activ, N=not Activ
First Position=Version A
Second Position=Version B
and so on
Example
JNJNNNNNNNNNNNNNNNNNNNNNNNN = A:Activ, B:not activ, C:Activ
Attention: The string need 26 letters. If you insert less then 26 letters, it's not working
Integration hub: Importable
Database: "BEAS_STL"."SHORTVARIANTDEF"
|
|
VersionFrom
|
Edm.String(20)
|
Only activ for Version from ...
attention: beas check this alphanumberic
Example Versions 1-12
1,10,11,12,2,3,4,5,6,7,8,9
Integration hub: Importable
Database: "BEAS_STL"."VersionFrom"
|
|
VersionTo
|
Edm.String(20)
|
Only activ for Version up to ...
attention: beas check this alphanumberic
Example Versions 1-12
1,10,11,12,2,3,4,5,6,7,8,9
Integration hub: Importable
Database: "BEAS_STL"."VersionTo"
|
|
VersionFilter
|
Edm.String(20)
|
Activ for Versions, CSV-Format
Example: Activ for Version 3,5 and 7
"3","5","7"
Attention:
if you insert the value in wrong format, beas generate SQL errors.
Integration hub: Importable
Database: "BEAS_STL"."VersionArea"
|
|
NonSynch
|
Edm.Int32
|
Define the synchronisation option
Constraints:
synchronisation on (import: delete and import new)=0
synchronisation on, but don�t delete this line=1
don�t synchronisate this position=2
Integration hub: Importable
Database: "BEAS_STL"."nonSynch"
|
|
UDF1
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF1"
|
|
UDF2
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF2"
|
|
UDF3
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF3"
|
|
UDF4
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF4"
|
|
UDF5
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF5"
|
|
UDF6
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF6"
|
|
UDF7
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF7"
|
|
UDF8
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF8"
|
|
UDF9
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF9"
|
|
UDF10
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF10"
|
|
UDF11
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF11"
|
|
UDF12
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF12"
|
|
UDF13
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF13"
|
|
UDF14
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF14"
|
|
UDF15
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_STL"."UDF15"
|
|
