Tables

 

beas_reservation_line

docentry

int

primary key for entry of this reservation document

linenum

int

primary key - line of this reservation document

reservationtype

char(1)

S = Stock-Reservation

P = in Production

A = Archive (Production)

base_type

char(20)

Type of Reference-Document, example

17 Order, 13 Invoice, 22 Purchase Order, wo=Work Order

base_docentry

int

docentry or belnr_id of Referernce-Document

base_linenum

int

linenum or belpos_id of Reference-Document

base_linenum2

int

pos_id of Reference-Document (only Workorder, bom-Position from beas_ftstl

itemcode

char(30)

itemcode

whscode

char(8)

Warehouse

Batchnum

char(32)

the Batchnumber or Serialnumber

bincode

char(20)

Code of Bin

rfid

char(20)

Code of the RFID-Field

Quantity

dec 19,6

Quantity

tstamp



link_type

char(20)

linked to document type

link_docentry

int

linked to document entry

link_linenum

int

linked to document line