Material transactions are defined in a definition file: "Transaction plan lines".
Different transaction types like receipt and issue, goods receipt etc. can be executed here.
The transaction type is indicated in the "Transaction Type" field.
The following transaction are supported:
- Work order Receipt / Issue
- Manual Receipt / Issue
Note: The system create one document PER import line
Means: If you import 200 lines, the system will create 200 documents.
See also DIH Material management transaction plan lines.
All this fields in this table are mandatory related to document type and item manage method
Field
|
Value
|
Transaction Type
|
Define the type of transaction type
Transaction Typ
|
Description
|
WOISSUE
|
Production – Material issue (or "WOIM")
|
WORECEIPT
|
Production – Material / Assembly receipt
|
ISSUE
|
manual Issue
|
RECEIPT
|
manual receipt
|
|
Link Document Type
|
"WO"
|
Link Document
|
Work order Number (BEAS_FTHAUPT.BELNR_ID)
|
Link Line 1
|
Work order Position (BEAS_FTPOS.BELPOS_ID)
|
Link Line 2
|
Only for Bill of Material: Internal Bill of Material Position (BEAS_FTSTL.POS_ID)
For assemlby: Don't define it or 0
|
ItemCode
|
The Item Number (Assembly: BEAS_FTPOS.ItemCode, Bill of Material: BEAS_FTSTL.ART1_ID)
|
Quantity
|
the Issue Quantity in Inventory UoM
|
WareHouse
|
The WareHouse from the Item OWHS.WhsCode
|
Bincode
|
Bincode, if warehouse is a bin managed warehouse
Supported: SAP, WMS and beas bin management
If this is a WMS or beas bin managed warehouse, the bincode is mandatory
|
RFID / LUID
|
The RFID (beas) or LUID (WMS) Number for current Bincode
|
DistNumber
|
The visible Serial/Batch Number
Normal Item: Empty
Batch Administration: OBTN.DistNumber
Serial Administration: OSRN.DistNumber
if this is a work order receipt or purchase receipt and batchnumber generation is activated, then it's not mandatory to fill it
|
SysNumber
|
Only for Issue documents
Alternative to DistNumber (visible Batch/Serial Number) you can use the internal System Number. (OBTN.SysNumber, OSRN.SysNumber) Don't define both. Don't use it for receipt documents
|
Batch Number
|
Not supported anymore. Please use DistNumber or SysNumber
|
Important:
The data must be checked for correctness before the import. There is no further check in the import process-
The values must be checked in the Import Preview function or all necessary checks must be defined in the Source – Target – Link.
Complete list:
Field
|
Name
|
M
|
Type
|
Description
|
LineType
|
Transaction Type
|
X
|
nvarchar(20)
|
transaction line per line. Import: it's mandatory
Valid values: issue work order material=WOISSUE
receipt work order assembly or material=WORECEIPT
issue work order material (compatible)=WOIM
receipt work order assemlby or material (compatible)=WORM
Manual receipt=RECEIPT
Manual issue=ISSUE
|
DocDate
|
Document Valid Date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
Notes
|
Documetn remarks
|
|
nvarchar(255)
|
|
CardCode
|
Business partner
|
|
nvarchar(20)
|
|
Project
|
Project
|
|
nvarchar(20)
|
|
BASE_DOCTYPE
|
Link Document Type
|
|
nvarchar(20)
|
Type of base document
Example: WO = Workorder
|
BASE_DOCENTRY
|
Link Document
|
|
int(4)
|
Document entry
Example: work order = BEAS_FTHAUPT.BELNR_ID
|
BASE_LINENUM
|
Link Line 1
|
|
int(4)
|
Document entry
Example: work order position = BEAS_FTFTPOS.BELPOS_ID
|
BASE_LINENUM2
|
Link Line 2
|
|
int(4)
|
Document entry line 2
Example: work order bom position = BEAS_FTSTL.POS_ID
|
ItemCode
|
Itemcode
|
|
nvarchar(50)
|
|
Quantity
|
Quantity
|
X
|
decimal(9)
|
|
WhsCode
|
Warehouse
|
|
nvarchar(20)
|
|
BINCODE
|
Bincode
|
|
nvarchar(20)
|
|
RFID
|
RFID
|
|
nvarchar(20)
|
|
Version
|
Version
|
|
nvarchar(20)
|
|
DistNumber
|
DistNumber
|
|
nvarchar(40)
|
The "visible" Batch- and Serial number
|
SysNumber
|
Internal Batch/Serial number
|
|
int(4)
|
Describe the internal batch/serial number
you can define this in issue documents for define exact correct Serial/Batch Number
|
MnfSerial
|
Batch attribute 1
|
|
nvarchar(40)
|
|
LotNumber
|
Batch attribute 2
|
|
nvarchar(40)
|
|
InDate
|
date of entry
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
MnfDate
|
Manufacturing Date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ExpDate
|
Expir. date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
PERS_ID
|
personnel number
|
|
nvarchar(20)
|
|
USER_ID
|
User WEB User
|
|
nvarchar(20)
|
|
Price
|
Price
|
|
decimal(9)
|
Define the Price in defined currency
Import information:
Work order issue/receipt: not supported
Manual Issue: only if "Use Perpetual Inventory" is disabled
Manual Recept with follow rule:
If in first import line a price is defined, the system will use the prices defined in the import lines.
If no price defined in first line, the system will ignore prices from all lines.
|
Currency
|
Currency
|
|
nvarchar(5)
|
|
STATION_ID
|
Work station
|
|
nvarchar(50)
|
|
BatchNum
|
Batchnumber
|
|
nvarchar(1024)
|
|
UDF1
|
Userfield 1
|
|
nvarchar(100)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(100)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(100)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(100)
|
|
Help URL: https://help.beascloud.com/beas202204/index.html?dih_transactions_production__b.htm
|