DIH Operation templates

Field	Name	M	Type	Description
AG_ID	Operation ID	X	nchar(20)
MatchCode	Match code		nvarchar(20)
AGTYP	Operation type		nvarchar(20)
APLATZ_ID	Resource		nchar(20)
BDE	Clock mandatory		nchar(1)	Valid values: Yes=J No=N
BEZ	Description	X	ntext(8)
TRAPLATZ	Setup time for precalculation		numeric(4)
TR2APLATZ	Setup time capacity		numeric(4)
TEAPLATZ	Mach+Labor Time/unit		numeric(4)
TIMETYPE_ID	Time Type		nvarchar(20)
MENGE_JE	Quantity per time		decimal(9)
MENGE_ZEITJE	Time unit		int(4)	Valid values: Minute=1 Hours=60
NUTZEN	Use factor		decimal(9)
ANZAHL	Work steps		decimal(9)
TL	Idle time		numeric(4)
UEBLGRZ	Overlap limit		numeric(4)
AUSSCHUSSFAKTOR	Scrap factor		numeric(4)
QS_ID	QC inspection plan		nvarchar(50)
ANZLS	Number of pay slips		numeric(4)
RM_ME_ID	Confirm in units		nvarchar(20)
RM_FAKTOR	Factor per production UoM		numeric(4)
LOHNGRUPPE	Wage Group		nchar(2)
MENGENAUSSCHUSS	Scrap Factor Bill of Materials		numeric(4)
ANWEISUNGEN	instructions		ntext(8)
FAG	External operation		nchar(1)	Valid values: Yes=J No=N
CardCode	Supplier		nvarchar(30)
FAG_ITEMCODE	External operation		nvarchar(50)
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)
FAG_TRANSPORTPRICEA	External operation Shipment Lot Size		int(4)
SCRIPTS	Scripts		ntext(8)
THAPLATZ	Machine Time / unit		numeric(4)
TRTIMETYPE_ID	Cost type tool time		nvarchar(20)
THTIMETYPE_ID	Cost type main time		nvarchar(20)
TNAPLATZ	Labor Time / unit		numeric(4)
TNTIMETYPE_ID	Cost type second time		nvarchar(20)
PTIMETYPE_ID	Personell time type		nvarchar(20)
MILESTONE	Milestone		nvarchar(20)
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	Active formula		nvarchar(100)
FORMEL	Formula		nvarchar(50)
PO_WHS	Return address from warehouse		nvarchar(20)
BILD1	Anhang 1		nvarchar(100)
BILD2	Anhang 2		nvarchar(100)
BILD3	Anhang 3		nvarchar(100)
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)