Name
|
Type
|
Description
|
RoutingId
|
Edm.String(50)
|
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_APL_WKZ"."ItemCode"
|
|
LineNumber
|
Edm.Int32
|
Link to internal position number from routing position (BEAS_APL.POS_ID)
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_APL_WKZ"."POS_ID"
|
|
LineNumber2
|
Edm.Int32
|
Position number for this resource position
Must be unique for all resource types (toosl, alternativ, parallel)
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_APL_WKZ"."WKZPOS_ID"
|
|
Position
|
Edm.Int32
|
Integration hub: Importable
Mandatory field
Database: "BEAS_APL_WKZ"."POS2_ID"
|
|
ParallelType
|
Edm.String(20)
|
Database: case "BEAS_APL_WKZ"."RESOURCENTYP" when 'A' then 'Parallel' when 'R' then 'Alternative' else 'Tool' end
|
|
Quantity
|
Edm.Decimal
|
Only for tools:
Needed quantity in warehouse unit of the tool
Integration hub: Importable
Database: "BEAS_APL_WKZ"."MENGE"
|
|
Description
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."ZUSATZINFO"
|
|
Active
|
Edm.Boolean
|
Default Value: 1
Constraints:
yes=1
no=0
Integration hub: Importable
Database: coalesce("BEAS_APL_WKZ"."AKTIV",1)
|
|
Alternativ
|
Edm.Boolean
|
Constraints:
yes=1
no=0
Integration hub: Importable
Database: coalesce("BEAS_APL_WKZ"."ALTERNATIV",0)
|
|
ResourceId
|
Edm.String(20)
|
Database: rtrim("BEAS_APL_WKZ"."WKZ_ID")
|
|
SetupTime
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."TR"
|
|
MachineLaborTime
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."TE"
|
|
TimesPer
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."MENGE_JE"
|
|
TimesUnit
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."MENGE_ZEITJE"
|
|
ScrapPercent
|
Edm.Decimal
|
Database: "BEAS_APL_WKZ"."MENGENAUSSCHUSS"
|
|
UseFactor
|
Edm.Decimal
|
Default Value: 1
Integration hub: Importable
Database: "BEAS_APL_WKZ"."NUTZEN"
|
|
WorkSteps
|
Edm.Decimal
|
Anzahlfaktor
Default Value: 1
Integration hub: Importable
Database: "BEAS_APL_WKZ"."ANZAHL"
|
|
IdleTime
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."LIEGEZEIT"
|
|
IdleTimeType
|
Edm.Int32
|
Mandatory field
Database: "BEAS_APL_WKZ"."LIEGEZEIT_TYP"
|
|
ResourceOptimisation
|
Edm.Int32
|
only for alternative resources:
If active, at the calculation the lead time will be checked, whether with this resource a faster processing is possible and if yes, the resource will be replaced automatically
Default Value: 0
Constraints:
yes=1
No=0
Integration hub: Importable
Database: "BEAS_APL_WKZ"."OPTIMIZED_ID"
|
|
AllowManualChanges
|
Edm.Boolean
|
only alternative resource:
This alternative resource can only be selected manually, if this option has been enabled. The event will be canceled and receipted with the error message "(aktivaplatz440)Resource cannot be selected when flag "allow manual change" is off" if this option has been disabled and an attempt has been made to select the resource.
Note: A change is only possible if a change has been allowed according to the production position (Production position - Allow change has to be allowed).
Default Value: 1
Constraints:
Yes=1
No=0
Integration hub: Importable
Database: "BEAS_APL_WKZ"."ALLOW_MANUAL_CHANGE"
|
|
IgnoreOwnResourcePrice
|
Edm.Boolean
|
Constraints:
yes=1
no=0
Integration hub: Importable
Database: "BEAS_APL_WKZ"."IgnoreOwnResourcePrice"
|
|
UDF1
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF1"
|
|
UDF2
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF2"
|
|
UDF3
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF3"
|
|
UDF4
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF4"
|
|
UDF5
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF5"
|
|
UDF6
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF6"
|
|
UDF7
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF7"
|
|
UDF8
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF8"
|
|
UDF9
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF9"
|
|
UDF10
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF10"
|
|
UDF11
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF11"
|
|
UDF12
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF12"
|
|
UDF13
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF13"
|
|
UDF14
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF14"
|
|
UDF15
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL_WKZ"."UDF15"
|
|
