Short overview about main table structure inside Beas Database

 

Items

 

oitm (items)

|

|-  beas_apl (rounting)

|       |_ [itemcode,pos_id] - beas_apl_wkz (resource)

|                 |_ [wkz_id, resourcentyp='W'] beas_wkz (ToolAdministration)

|                 |_ [wkz_id, resourcentyp='A'/'R'] beas_aplatz (Work Center)

|       |_ [aplatz_id] - beas_aplatz (Work Center)

|       |_ [ag_id] - beas_ag (Operations)

|

|- beas_stl (Bill of Materials)        

        |_ beas_me (Unit of M.)

 

 

Workorders

 

beas_fthaupt (workorder)

|

|- [belnr_id] beas_ftpos (Position)

|        |_[docentry,auftragpos=rdr1.linenum] ordr (Order) and rdr1 (Orderline)

|        |_[belnr_id,belpos_id] beas_ftstl (Bill of Materials)

|               |_ [belnr_id-dln1.u_belnrid,belpos_id-dln1.u_belposid,pos_id-dln1.u_posid]

|                  oige,ige1 (Goods Receipt) and oign,ign1 (Goods Issue)

|        |_[belnr_id,belpos_id] beas_ftapl (Routing)

|               |_ [belnr_id,belpos_id,pos_id] beas_ftapl_wkz

|                      |_ [wkz_id, resourcentyp='W'] beas_wkz (ToolAdministration)

|                      |_ [wkz_id, resourcentyp='A'/'R'] beas_aplatz (Work Center)

|               |_ [aplatz_id] beas_aplatz (Work Center)

|               |_ [belnr_id,belpos_id,pos_id] beas_ftpool (Pool Report)

|               |_ [belnr_id,belpos_id,pos_id,aplatz_id] beas_resourcen (Dispatches)

|               |_ [belnr_id-dln1.u_belnrid,belpos_id-dln1.u_belposid,pos_id-dln1.u_posid]

|                  orpd,rpd1 (Goods Return) and opch/pch1 (A/P Invoice)

|               |_ [belnr_id,belpos_id,pos_id] beas_arbzeit (Production Time Receipt)

 

 

Quality Control

 

beas_qsartikelhaupt

|

|___[itemcode,knd_id] beas_qsartikel

         |__________[qs_id] beas_qs

         |__________beas_qsstichprobe

 

beas_qsfthaupt

|___beas_qsftmessung

         |__________beas_qsartikelhaupt

         |                |_ ....

         |__________beas_qsstichprobe

         |__________beas_qsftpos

                         |_beas_wkz

                         |_beas_qs

         

QC Order - Order field: qs_fthaupt.Charge_id

related to operation

Pxx/yy/zz-0001        

|   |  |_ beas_ftpos.pos_id

|   |---- beas_ftpos.belpos_id  

|-------- beas_ftpos.belnr_id

 

work order credit - related to receipt ign1

Exx/yy

|  |_____ linenum

|________ docentry

 

goods receipt

Ixx/y-0001

|  |_____ linenum

|________ docentry

 

Normal receipt

Cxx/yy-0001

|  |_____ linenum

|________ docentry