|
For detailed information on how to import see Data Integration Hub and Source-Target-Link.
A Bill of materials is always regarded 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.
The correct order for an import is:
•Item
•Routings
•Bill of materials head data
•Bill of materials
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
|
|
X
|
nvarchar(50)
|
Id of bill of material
Linked to header of bom (BEAS_STL_HEADER)
|
POS_ID
|
|
X
|
int(4)
|
internal position number id (not visible)
|
ART1_ID
|
|
|
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
|
|
|
nvarchar(20)
|
|
INPUT_QTY
|
|
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
|
|
|
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
|
|
|
decimal(9)
|
|
SortId
|
|
|
int(4)
|
Define the sorting in the bom list self
|
Version
|
|
|
nvarchar(20)
|
|
UseOwnDescription
|
|
|
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
|
|
|
nvarchar(255)
|
Item description about the bom position
beas ignore this, if "UseOwnDescription" not 1
|
AKTIV
|
|
|
nchar(1)
|
Valid values: activ=J
not activ=N
|
ZNR
|
|
|
nvarchar(50)
|
Item drawing number about the bom position
beas ignore this, if "UseOwnDescription" not 1
|
AUSSCHUSS
|
|
|
numeric(4)
|
Scrap for bom
|
ROUND_TYPE
|
|
|
int(4)
|
type of rounding
Valid values: no rounding=-1
commercial=0
round up=1
round down=2
multiple of=3
|
ROUND_DEC
|
|
|
int(4)
|
|
APLANPOS_ID
|
|
|
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
|
|
|
numeric(4)
|
|
ABM2
|
|
|
numeric(4)
|
|
ABM3
|
|
|
numeric(4)
|
|
INFO
|
|
|
nvarchar(50)
|
|
UserText
|
|
|
nvarchar(255)
|
|
GUELTIG_BIS
|
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
GUELTIG_VON
|
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
VersionFrom
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
int(4)
|
Valid values: yes=1
no=0
|
DontBookScrap
|
|
|
int(4)
|
if activ, the backflushig process don't book the scrap quantity
Valid values: yes=1
no=0
|
PlaningSysNoSubMaterial
|
|
|
int(4)
|
Valid values: automatic=0
no=1
|
BITMAPNAME
|
|
|
nvarchar(50)
|
|
COLORID
|
|
|
int(4)
|
|
RestChargeOff
|
|
|
decimal(9)
|
|
WhsCode
|
|
|
nvarchar(20)
|
|
BINCODE
|
|
|
nvarchar(228)
|
The bin location must be a valid location for the warehouse selected
|
ScrapPercent
|
|
|
numeric(4)
|
|
SHORTVARIANTDEF
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
nvarchar(0)
|
Define beas scripts for define properties in current BoM
Changeable left icon from BoM Position
|
ALTERNATIVMATERIAL
|
|
|
nvarchar(1024)
|
|
EXPANDID
|
|
|
nchar(1)
|
Breakdown (expandid)
Valid values: No=N
Always=A
Only Shortage=W
|
UDF1
|
|
|
nvarchar(100)
|
|
UDF2
|
|
|
nvarchar(100)
|
|
UDF3
|
|
|
nvarchar(100)
|
|
UDF4
|
|
|
nvarchar(100)
|
|
UDF5
|
|
|
nvarchar(100)
|
|
UDF6
|
|
|
nvarchar(100)
|
|
UDF7
|
|
|
nvarchar(100)
|
|
UDF8
|
|
|
nvarchar(100)
|
|
UDF9
|
|
|
nvarchar(100)
|
|
UDF10
|
|
|
nvarchar(100)
|
|
UDF11
|
|
|
nvarchar(100)
|
|
UDF12
|
|
|
nvarchar(100)
|
|
UDF13
|
|
|
nvarchar(100)
|
|
UDF14
|
|
|
nvarchar(100)
|
|
UDF15
|
|
|
nvarchar(100)
|
|
BBD_OPTION
|
|
|
nchar(1)
|
BBD Option
Valid values: Due date=D
Pickdate=P
Best before date=B
|
Help URL: https://help.beascloud.com/beas202402/index.html?dih-item---bom-positions.htm
|