beas_poollist

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

returns id (for beas_tempreport)

 

Creates a new report in table beas_tempreport

The result is the actual pool list 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>

 

Structure of beas_tempreport

Field

Description

id

ID of report

nr

continued number

createdate

Date / Time of report creation

linetype

0

level

0

belnr_id

Work order-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 of the assembly (beas_Ftpos.itemcode)

aplatz_id

Resource (beas_ftapl.aplatz_id or beas_ftapl_wkz.wkz_id)

decimalparm1

Duration time total

decimalparm2

Null

stringparm1

Material requirements with insufficient stock:

itemcode- stock  - requirement / itemcode ....

Example:

C35664 233.5 < 290.5 / C37908 7.8 < 288.8

is calculated only if parameter bomcheck='Y'

stringparm2

Null

intparm1

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

intparm2

if parallel-Resource: visible parallel-position of the parallel-Resource

datetimeparm1

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

Work order-Position (assembly)

beas_fthaupt (belnr_id)

Work order

oitm (itemcode)

Item