Name
|
Type
|
Description
|
RoutingId
|
Edm.String(50)
|
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_APL"."ItemCode"
|
|
LineNumber
|
Edm.Int32
|
Integration hub: Importable
Mandatory field
Database: "BEAS_APL"."POS_ID"
|
|
SortId
|
Edm.Int32
|
Integration hub: Importable
Database: coalesce("BEAS_APL"."SortId","BEAS_APL"."POS_ID")
|
|
Position
|
Edm.String(20)
|
Integration hub: Importable
Mandatory field
Database: "BEAS_APL"."POS_TEXT"
|
|
Description
|
Edm.String(255)
|
Description about the work
Integration hub: Importable
Database: "BEAS_APL"."BEZ"
|
|
Instructions
|
Edm.String(16000)
|
Integration hub: Importable
Database: "BEAS_APL"."ANWEISUNGEN"
|
|
CatalogId
|
Edm.String(20)
|
Database: rtrim("BEAS_APL"."AG_ID")
|
|
CostCenter
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_APL"."KSTST_ID"
|
|
ResourceId
|
Edm.String(20)
|
Database: rtrim("BEAS_APL"."APLATZ_ID")
|
|
OperationTypeId
|
Edm.String(20)
|
Entity Relation: OperationType -> OperationTypeId
Integration hub: Importable
Mandatory field
Database: "BEAS_APL"."AGTYP"
|
|
RoutingColor
|
Edm.Int32
|
Integration hub: Importable
Database: "BEAS_APL"."COLORID"
|
|
RoutingBitmap
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL"."BITMAPNAME"
|
|
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_APL"."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_APL"."GUELTIG_BIS"
|
|
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_APL"."SHORTVARIANTDEF"
|
|
VersionFrom
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_APL"."VersionFrom"
|
|
VersionTo
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_APL"."VersionTo"
|
|
VersionFilter
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_APL"."VersionArea"
|
|
ClockMandatory
|
Edm.Boolean
|
Default Value: J
Constraints:
Yes=J
No=N
Integration hub: Importable
Database: case when coalesce("BEAS_APL"."BDE",'J')='J' then 1 else 0 end
|
|
RUoMFactor
|
Edm.Decimal
|
Integration hub: Importable
Database: coalesce("BEAS_APL"."RM_FAKTOR",1)
|
|
RUoM
|
Edm.String(20)
|
Database: case when rtrim(coalesce("BEAS_APL"."RM_ME_ID",''))='' then o."U_me_verbr" else "BEAS_APL"."RM_ME_ID" end
|
|
SetupForCalculator
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: "BEAS_APL"."TRAPLATZ"
|
|
SetupForSchedule
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: "BEAS_APL"."TR2APLATZ"
|
|
MachineLaborTime
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: "BEAS_APL"."TEAPLATZ"
|
|
LaborTime
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: "BEAS_APL"."TNAPLATZ"
|
|
MachineTime
|
Edm.Decimal
|
Default Value: 0
Integration hub: Importable
Database: "BEAS_APL"."THAPLATZ"
|
|
TimesPer
|
Edm.Decimal
|
Default Value: 1
Integration hub: Importable
Database: "BEAS_APL"."MENGE_JE"
|
|
TimesUnit
|
Edm.Decimal
|
Default Value: 1
Constraints:
Stunde=60
Minute=1
-=-
Integration hub: Importable
Database: "BEAS_APL"."MENGE_ZEITJE"
|
|
UseFactor
|
Edm.Decimal
|
Default Value: 1
Integration hub: Importable
Database: "BEAS_APL"."NUTZEN"
|
|
WorkSteps
|
Edm.Decimal
|
Default Value: 1
Integration hub: Importable
Database: "BEAS_APL"."ANZAHL"
|
|
IdleTime
|
Edm.Decimal
|
Integration hub: Importable
Database: "BEAS_APL"."TL"
|
|
OverlappLimit
|
Edm.Decimal
|
Overlap limit to next routing position
Integration hub: Importable
Database: "BEAS_APL"."UEBLGRZ"
|
|
InspectionPlanId
|
Edm.String(20)
|
Linked table: BEAS_QSARTIKELHAUPT
Linked column: ItemCode
Integration hub: Importable
Database: "BEAS_APL"."QS_ID"
|
|
ResourceAllocation
|
Edm.String(1)
|
Ressource allocation possible? Here you can define the type of quantity defintion
Constraints:
Single=N
Percent=P
Quantity=J
Integration hub: Importable
Database: coalesce("BEAS_APL"."MEHRMASCHINENBELEGUNG",'N')
|
|
ResourceAllocationQty
|
Edm.String(1)
|
Define max. quantity of Resources which you can use for the respurce
In field "Resource allocation Type" you define, if this number is percent or quantity
Integration hub: Importable
Database: coalesce("BEAS_APL"."MEHRMASCHINENBELEGUNG_ANZ",1)
|
|
WageGroup
|
Edm.String(2)
|
Database: "BEAS_APL"."LOHNGRUPPE"
|
|
CostElementSetup
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_APL"."TRTIMETYPE_ID"
|
|
CostElementMachineLabor
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_APL"."TIMETYPE_ID"
|
|
CostElementLabor
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_APL"."TNTIMETYPE_ID"
|
|
CostElementMachine
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_APL"."THTIMETYPE_ID"
|
|
CostElementPersonell
|
Edm.String(20)
|
Linked table: BEAS_TIMETYPE
Linked column: TIMETYPE_ID
Integration hub: Importable
Database: "BEAS_APL"."PTIMETYPE_ID"
|
|
MasterLineNumber
|
Edm.Int32
|
Integration hub: Importable
Database: "BEAS_APL"."MASTER_POS_ID"
|
|
Picture1
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL"."BILD1"
|
|
Picture2
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL"."BILD2"
|
|
Picture3
|
Edm.String(50)
|
Integration hub: Importable
Database: "BEAS_APL"."BILD3"
|
|
NonSynch
|
Edm.Int32
|
At import or inserting a routing position, the routing is always deleted completely and re-imported.
Use the settings to manipulate the behavior on routing position level
yes: Position will be deleted before the import
do not delete: Position will not be deleted, but can be overwritten
no: Position will not be deleted and cannot be changed
Default Value: 0
Constraints:
Yes=0
Don not delete=1
No=2
Integration hub: Importable
Database: "BEAS_APL"."nonSynch"
|
|
UDF1
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF1"
|
|
UDF2
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF2"
|
|
UDF3
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF3"
|
|
UDF4
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF4"
|
|
UDF5
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF5"
|
|
UDF6
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF6"
|
|
UDF7
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF7"
|
|
UDF8
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF8"
|
|
UDF9
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF9"
|
|
UDF10
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF10"
|
|
UDF11
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF11"
|
|
UDF12
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF12"
|
|
UDF13
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF13"
|
|
UDF14
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF14"
|
|
UDF15
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_APL"."UDF15"
|
|
