Maestro database schema

tbl_issue
Issue master data. May include reference to person, project, part and/or serial number.

tbl_person
Person master data.

tbl_project
Project master data.

tbl_pv_al
Not used (AL in PV6, possibly used by EX edition for managing client jobs, and if so not used by SE edition).

tbl_pv_cnv
Not used (CNV in PV6, possibly used to convert one part to another).

tbl_pv_cost
Part source cost at a specified buy-level, aka "price break" (COST in PV6).

tbl_pv_cu
Not used (CU in PV6, customer master data, not used by SE edition).

tbl_pv_cur
Currency master data (CUR in PV6).

tbl_pv_fil
Document master data, file or URL associated with a part number (FIL in PV6).

tbl_pv_hist
Audit trail for inventory adjustments (HIST in in PV6).

tbl_pv_hpref
Item master user field captions, row GPREFKey="UserFields" (HPREF in PV6, EX edition has additional rows compared to SE edition).

tbl_pv_job
Not used (JOB in PV6, job master data for customer jobs, not used by SE edition).

tbl_pv_lin
Vendor "line card" relationships (LIN in PV6).

tbl_pv_lnk
Index table referencing sources for parts (LNK in PV6).

tbl_pv_mf
Not used (MF in PV6, part made-from relationships, not used by SE edition).

tbl_pv_mfr
Manufacturer master data (MFR in PV6).

tbl_pv_mfrpn
Manufacturers part numbers and related data (MFRPN in PV6)

tbl_pv_org
User organization master data (ORG in PV6).

tbl_pv_pl
Parts list master data (PL in PV6).

tbl_pv_pll
Not used (PLL in PV6, index table for purchase and kitting lists).

tbl_pv_pn
Part master data (PN in PV6).

tbl_pv_po
PO and RFQ line items (PO in PV6, not used by SE edition).

tbl_pv_pod
Not used (POD in PV6, purchase order line item data, not used by SE edition).

tbl_pv_pom
Not used (POM in PV6, purchase order and RFQ master data).

tbl_pv_rpx
Not used (RPX in PV6, global report layouts, not used in SE edition).

tbl_pv_ship
Not used (SHIP in PV6, shipping methods master data).

tbl_pv_su
Supplier master data (SU in PV6).

tbl_pv_task
Not used (TASK in PV6, line items for jobs, not used by SE edition).

tbl_pv_type
Part type master data - also see pv_pn.PNTYPE (TYPE in PV6).

tbl_pv_un
Units of measure with conversion ratios (UN in PV6).

tbl_stock_location
Stock location master data.

tbl_stock_serial
Stock serial number master data.