beas_poollist

beas_poollist [userid (beas_pers.ers_id)] [stationid] [bomcheck]

returns id (for beas_tempreport)

 

create a new report in table beas_tempreport

result is the actual poollist for this user and station

 

Example for user 1:

#sqlscript
execute beas_poollist N'1',N'<stationname>','Y'
#end
// display result
tools=isql=select  * from beas_tempreport where id=<sqlresults1>
// delete report
sql=delete from beas_tempreport where id=<sqlresults1>

 

Structor of beas_tempreport

Field

Description

id

id of report

nr

continues number

createdate

Date / Time of create this report

linetype

0

level

0

belnr_id

Workorder-Number (beas_fthaupt.belnr_id)

belpos_id

Position-Number (beas_ftpos.belpos_id)

pos_id

Routing-Position

pos2_id

parallel-Resource - internal Position number

itemcode

itemcode from assembly (beas_Ftpos.itemcode)

aplatz_id

Resource (beas_ftapl.aplatz_id or beas_ftapl_wkz.wkz_id)

decimalparm1

durationtime total

decimalparm2

null

stringparm1

Material requirements with insufficient stock:

itemcode- stock  - requirement / itemcode ....

Exampe:

C35664 233.5 < 290.5 / C37908 7.8 < 288.8

is calculate only, if parameter bomcheck='Y'

stringparm2

null

intparm1

1 = routing position is logged from current user or other user

intparm2

if parallel-Ressource: visible parallel-position of the parallel-Ressurce

datetimeparm1

planned begin of routing

datetimeparm2

planned end of  routing

 

You can link this table with

beas_ftapl (belnr_id,belpos_id,pos_id)

routing

beas_ftapl_wkz (belnr_id,belpos_id,pos_id,wkzpos_id=beas_tempreport.pos2_id)

parallel-Resource  (if pos2_id > 0)

beas_ftpos (belnr_id,belpos_id)

Workorder-Position (assembly)

beas_fthaupt (belnr_id)

Workorder

oitm (itemcode)

Item