DIH Item - BoM Positions

A bill of materials is always seen as a whole and can only be imported completely. In case of an update, the BoM is deleted first and re-inserted. It is not possible to update single positions, but synchronization can be done on position level.

An item needs to be defined which is used if the imported position has no valid item number. This is done in the Configuration Wizard.

A bill of materials can also be imported directly. Positions numbers are assigned automatically if they are not set manually.

If the material number is not defined, the default item is inserted, and the bill of materials is set to manually.

If the stored material number is unknown, the default item is inserted, bill of materials position is set to manually and the transferred item number is inserted into the information field.

NOTE: It is not possible to import Input Unit and Input factor for a BoM position.

Field	Name	M	Type	Description
ItemCode	Item code header (BoM ID)	X	nvarchar(50)	Id of bill of material Linked to header of bom (BEAS_STL_HEADER)
POS_ID	Position id	X	int(4)	internal position number id (not visible)
ART1_ID	Item code (consumed)		nvarchar(50)	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
POS_TEXT	Position		nvarchar(20)
INPUT_QTY	Quantity	X	numeric(4)	Determines the requirement in entry units per assembly in Input UoM. Usually, the entry unit is the consumption unit of the selected item,
nonSynch	Synchonisation		int(4)	Define the synchronisation option Valid values: synchronisation on (import: delete and import new)=0 synchronisation on, but don�t delete this line=1 don�t synchronisate this position=2
MENGE_JE	Quantity per Finished Item		decimal(9)
SortId	Sorting		int(4)	Define the sorting in the bom list self
Version	I-Version		nvarchar(20)
UseOwnDescription	Use own description		int(4)	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 Valid values: yes=1 no=0
DESCRIPTION	Description		nvarchar(255)	Item description about the bom position beas ignore this, if "UseOwnDescription" not 1
AKTIV	Active		nchar(1)	Valid values: activ=J not activ=N
ZNR	Drawing number		nvarchar(50)	Item drawing number about the bom position beas ignore this, if "UseOwnDescription" not 1
AUSSCHUSS	Scrap		numeric(4)	Scrap for bom
ROUND_TYPE	Rounding Type		int(4)	type of rounding Valid values: no rounding=-1 commercial=0 round up=1 round down=2 multiple of=3
ROUND_DEC	Rounding Decimal count		int(4)
APLANPOS_ID	linked to operation		int(4)	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.
ABM1	Length		numeric(4)
ABM2	Width		numeric(4)
ABM3	Height		numeric(4)
INFO	Info		nvarchar(50)
UserText	Additional Text		nvarchar(255)
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.
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.
VersionFrom	Valid From Version		nvarchar(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
VersionTo	Valid To Version		nvarchar(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
VersionArea	Valid for Version		nvarchar(255)	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.
OnlyReservation	only Reservation issue		int(4)	Valid values: yes=1 no=0
DontBookScrap	Dont book scrap		int(4)	if activ, the backflushig process don't book the scrap quantity Valid values: yes=1 no=0
PlaningSysNoSubMaterial	Planning Method		int(4)	Valid values: automatic=0 no=1
BITMAPNAME	Picture		nvarchar(50)
COLORID	Color		int(4)
RestChargeOff	IssueRemains from qty		decimal(9)
WhsCode	Warehouse Id		nvarchar(20)
BINCODE	Bin Location		nvarchar(228)	The bin location must be a valid location for the warehouse selected
ScrapPercent	Scrap		numeric(4)
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
SHORTVARIANT	Breakdown Variant		nchar(1)	Define, with which variant the subassembly have to breakdown if empty, then use Variant from parent Value can be empty or A-Z Valid values: 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
CAFTINFO	Formula Definition Variant		nvarchar(2048)	Define all Formulas for the current BoM Position FieldName=F/T/V=Information=VariableTyp=VariableLen=Changeable=Unit=ChoseList=Instructions/Formulas F=Formula T=Table V=Variablename
SCRIPTS	Script Variant		ntext(8)	Define beas scripts for define properties in current BoM Changeable left icon from BoM Position
ALTERNATIVMATERIAL	Alternative Material		nvarchar(1024)
EXPANDID	Breakdown		nchar(1)	Breakdown (expandid) Valid values: No=N Always=A Only Shortage=W
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)