|
Menu Item |
Screen |
Table |
Primary Key |
|---|---|---|---|
|
A1023 |
A.10.23 Companies |
m_companies |
company_id |
|
B2003 |
B.20.03 Adv. Maintain BOM |
m_list_pos |
lp_id |
|
D1011 |
D.10.11 Documents |
m_documents |
docu_id |
|
D4012 |
D.40.12 VDR Sets |
m_vdrs |
v_id |
|
D9021 |
D.90.21 Attachments CIP fields 1–10 and 51-60 CIP fields 11–20 and 41-50 CIP fields 21–30 CIP fields 31 – 40 |
m_att_documents m_att_vdrs m_documents m_vdrs |
attd_id attv_id docu_id v_id |
|
P2001 |
P.20.01 Suppliers/Subcontractors |
m_suppliers |
sup_id |
|
P3001 |
P.30.01 Requisition Workload |
m_reqs |
r_id |
|
P3011 |
P.30.11 Inquiries |
m_inquiries |
inq_id |
|
P3022 |
P.30.22 Commercial Evaluation CIP fields 1–50 CIP fields 51–60 CIP fields 61–70 CIP fields 71–90 CIP fields 91–100 |
m_quote_summaries m_comm_eval_cklsts m_quote_details m_qs_histories m_qd_histories |
qs_id cec_id qd_id qsh_id qdh_id |
|
P3023 |
P.30.23 Technical Evaluation CIP fields 1-10 CIP fields 11-20 CIP fields 21-30 CIP fields 31-40 |
m_inquiries m_inq_tecs m_req_li_tecs m_used_values |
inq_id inqt_id rlt_id uval_id |
|
P3024 |
P.30.24 Download/Load Bids |
m_quote_summaries |
qs_id |
|
P3025 |
P.30.25 Awarding |
m_req_line_items |
r_li_id |
|
P3027 |
P.30.27 Bidder Quotation |
||
|
P3081 |
P.30.81 Pending Inquiry Requisitions |
m_reqs |
r_id |
|
P5001 |
P.50.01 Agreements |
m_po_headers |
poh_id |
|
P5007 |
P.50.07 Maintain Agreements CIP fields 1 – 10 CIP fields 11 – 20 CIP fields 21 - 40 |
m_po_headers m_po_line_items m_item_ships |
poh_id poli_id item_ship_id |
|
P5081 |
P.50.81 Pending POs |
m_reqs |
r_id |
|
P6001 |
P.60.01 Tagged Items Planning |
m_eng_non_comm_items |
enci_id |
|
P6003 |
P.60.03 Requisitions Planning |
m_eng_comm_items |
eci_id |
|
P6011 |
P.60.11 Proc/Req Status Overview |
m_eng_comm_items |
eci_id |
|
P7071 |
P.70.71 Expediter Workload |
m_po_headers |
poh_id |
|
P7072 |
P.70.72 Expediting Details |
m_item_ships m_release_notes m_matl_move_tickets m_mmt_details m_heat_details m_sub_orders |
item_ship_id reln_id mmt_id mmtd_id hd_id so_id |
|
P7073 |
P.70.73 Order Reference |
m_reqs |
r_id |
|
P7074 |
P.70.74 Packages packages package items release notes item shipments |
m_packages m_package_items m_release_notes m_item_ships |
pck_id pcki_id reln_id item_ship_id |
|
P7081 |
P.70.81 VDR Submittal and Status |
m_att_vdrs |
attv_id |
|
P8042 |
P.80.42 Means of Conveyance (Multi) |
m_cargo_ships |
csh_id |
|
P9011 |
P.90.11 Maintain Fab Tracking |
m_fab_items |
fi_id |
|
PT2012 |
PT.20.12 Release Note Summary |
m_cargo_ship_details m_cargo_ship_mmts |
csd_id csm_id |
|
R3001 |
R.30.01 Maintain Requisitions CIP fields 1 – 10 CIP fields 11 – 20 |
m_reqs m_req_line_items |
r_id rli_id |
|
R3005 |
R.30.05 Process Requisition Line Items CIP fields 1 – 10 CIP fields 11 – 20 |
m_reqs m_req_line_items |
r_id rli_id |
|
SM2001 |
SM.20.01 Subcontractor Workload |
m_po_headers |
poh_id |
|
SM2011 |
SM.20.11 Subcontract Administration |
m_list_pos m_po_line_items |
lp_id poli_id |