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)
|
|