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 |