Field
|
Name
|
M
|
Type
|
Description
|
ItemCode
|
Item
|
X
|
nvarchar(50)
|
|
AGTYP
|
Operation Type
|
X
|
nvarchar(20)
|
|
AG_ID
|
Operation catalog number
|
X
|
nchar(20)
|
Reference to operation catalog number
|
POS_TEXT
|
Routing Position
|
X
|
nvarchar(20)
|
|
POS_ID
|
internal Position
|
X
|
int(4)
|
|
SortId
|
Sorting
|
|
int(4)
|
|
APLATZ_ID
|
Resource
|
X
|
nchar(20)
|
|
BDE
|
Labour Postings Mandatory
|
|
nchar(1)
|
Valid values: Yes=J
No=N
|
BEZ
|
Description
|
|
ntext(8)
|
Description about the work
|
TRAPLATZ
|
Setup time Calculation
|
|
numeric(4)
|
|
TR2APLATZ
|
Setup time Capacity
|
|
numeric(4)
|
|
TEAPLATZ
|
Mach+Labor Time duration /unit
|
|
numeric(4)
|
|
THAPLATZ
|
Machine Time duration / unit
|
|
numeric(4)
|
|
TNAPLATZ
|
Labor Time duration / unit
|
|
numeric(4)
|
|
TRTIMETYPE_ID
|
Cost Element setting up
|
|
nvarchar(20)
|
|
TIMETYPE_ID
|
Time Type Duration
|
|
nvarchar(20)
|
|
THTIMETYPE_ID
|
Cost Element Machine Time / unit
|
|
nvarchar(20)
|
|
TNTIMETYPE_ID
|
Cost Element Secondary time
|
|
nvarchar(20)
|
|
PTIMETYPE_ID
|
labor costs Time Type
|
|
nvarchar(20)
|
|
MENGE_JE
|
Times in per Quantity
|
|
decimal(9)
|
|
MENGE_ZEITJE
|
Times per Hr. or. Minute
|
|
int(4)
|
Valid values: Stunde=60
Minute=1
-=-
|
MEHRMASCHINENBELEGUNG
|
Resource Allocation Type
|
|
nchar(1)
|
Ressource allocation possible? Here you can define the type of quantity defintion
Valid values: Single=N
Percent=P
Quantity=J
|
MEHRMASCHINENBELEGUNG_ANZ
|
Resource Allocation Quantity
|
|
decimal(9)
|
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
|
NUTZEN
|
Use factor
|
|
decimal(9)
|
|
ANZAHL
|
Work Steps
|
|
decimal(9)
|
|
TL
|
Idle Time in Hours
|
|
numeric(4)
|
|
UEBLGRZ
|
Overlap Limit
|
|
numeric(4)
|
Overlap limit to next routing position
|
AUSSCHUSSFAKTOR
|
Scrap Factor
|
|
numeric(4)
|
|
QS_ID
|
Inspection Plan (QC)
|
|
nvarchar(50)
|
|
ANZLS
|
Number of Pay Slips
|
|
numeric(4)
|
|
GUELTIG_VON
|
Valid from
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
GUELTIG_BIS
|
Valid to
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
VersionFrom
|
Valid From Version
|
|
nvarchar(20)
|
|
VersionTo
|
Valid To Version
|
|
nvarchar(20)
|
|
VersionArea
|
Valid for Version
|
|
nvarchar(255)
|
|
RM_ME_ID
|
Goods Receipt in Unit
|
|
nvarchar(20)
|
|
RM_FAKTOR
|
Factor per unit of warehouse
|
|
numeric(4)
|
|
MASTER_POS_ID
|
linked with Routing position
|
|
int(4)
|
|
BITMAPNAME
|
Picture
|
|
nvarchar(50)
|
|
COLORID
|
Color
|
|
int(4)
|
|
nonSynch
|
Synchronization
|
|
int(4)
|
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
Valid values: Yes=0
Don not delete=1
No=2
|
MILESTONE
|
Milestone
|
|
nvarchar(20)
|
|
KSTST_ID
|
Cost Center
|
|
nchar(20)
|
|
BILD1
|
Picture 1
|
|
nvarchar(100)
|
|
BILD2
|
Picture 2
|
|
nvarchar(100)
|
|
BILD3
|
Picture 3
|
|
nvarchar(100)
|
|
MENGENAUSSCHUSS
|
Scrap Factor Bill of Materials
|
|
numeric(4)
|
|
ANWEISUNGEN
|
instructions
|
|
ntext(8)
|
|
SHORTVARIANTDEF
|
Variantendefinition A-Z
|
|
nvarchar(26)
|
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
|
CardCode
|
Supplier
|
|
nvarchar(30)
|
|
FAG
|
External operation
|
|
nchar(1)
|
Valid values: external=J
internal=N
|
FAG_ITEMCODE
|
External operation Item
|
|
nvarchar(50)
|
linked to an "non stock item"
you need this, if this an external operation
|
FAG_PRICE
|
External operation Price
|
|
decimal(9)
|
|
FAG_PRICEJE
|
External operation Price per
|
|
decimal(9)
|
|
FAG_CURRENCY
|
External operation Currency
|
|
nvarchar(6)
|
|
FAG_MINPRICE
|
External operation Minimum price
|
|
decimal(9)
|
|
FAG_TRANSPORTPRICE
|
External operation Shipping price
|
|
decimal(9)
|
|
PO_WHS
|
Return address from warehouse
|
|
nvarchar(20)
|
The warehouse to send the purchase for external operation
Here you can define the warehouse for purchase order
|
FAG_TRANSPORTPRICEA
|
External operation Shipment Lot Size
|
|
int(4)
|
|
Flags
|
Additional flags
|
|
nvarchar(100)
|
Additional Flags, 6 Digits, Example/Default: 000000
Pos 1: in Precalculation unvisible: 1=unvisible, 0=visible
Pos 2: visible in Workorder: 1=unvisible, 0=visible
Pos 3: lock time receipt: 1=lock, 0=unlock
Pos 4: check plan quantity: 0=off, 1=on
Pos 5: post calculation visible: 1=unvisible, 0=visible
Pos 6: resourcen optimization: 0=on, 1=off
|
AKTIVFORMEL
|
Activ Formel
|
|
nvarchar(100)
|
Define, if this position is active
Quantity > x: G=x
Quantity < x: K=x
Quantity between X and y: Z=x=y
not active=N
active=J
|
SCRIPTS
|
Script Variant
|
|
ntext(8)
|
Define beas scripts for define properties in current Routing Position
Changeable left icon from Routing Position
|
CAFTINFO
|
Formula definition Variant
|
|
nvarchar(2048)
|
Define all Formulas for the current Routing Position
FieldName=F/T/V=Information=VariableTyp=VariableLen=Changeable=Unit=ChoseList=Instructions/Formulas
F=Formula
T=Table
V=Variablename
|
ZEITAUFNKZ
|
Date Record Property
|
|
nvarchar(20)
|
|
ZEITAUFNDAT
|
Date Time Recording
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
UDF1
|
Userfield 1
|
|
nvarchar(100)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(100)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(100)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(100)
|
|
UDF5
|
Userfield 5
|
|
nvarchar(100)
|
|
UDF6
|
Userfield 6
|
|
nvarchar(100)
|
|
UDF7
|
Userfield 7
|
|
nvarchar(100)
|
|
UDF8
|
Userfield 8
|
|
nvarchar(100)
|
|
UDF9
|
Userfield 9
|
|
nvarchar(100)
|
|
UDF10
|
Userfield 10
|
|
nvarchar(100)
|
|
UDF11
|
Userfield 11
|
|
nvarchar(100)
|
|
UDF12
|
Userfield 12
|
|
nvarchar(100)
|
|
UDF13
|
Userfield 13
|
|
nvarchar(100)
|
|
UDF14
|
Userfield 14
|
|
nvarchar(100)
|
|
UDF15
|
Userfield 15
|
|
nvarchar(100)
|
|