Requisition Cross References - Intergraph Smart Materials - Version 10.1 - Help - Hexagon

Intergraph Smart Materials Web Help (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.1

The Requisition Cross References report can be used to view the cross references between a requisition and the inquiries and agreements that were created based on this requisition.

  • This is an interactive report.

  • Click SearchColumn and select the column where you want to search, type the search criterion in the Search box, and click Go to apply the search.

  • To change the number of displayed rows, select a value from the Rows list.

  • Additionally, you can customize the report to meet your requirements, save the report, and download the result in csv or html format (see Use Actions menu).

Click a requisition number to open the Requisitions page, where the line items of the selected requisition appear. For more information, see Requisitions.

On the Requisitions page, always the highest supplement (revision) of the inquiry or purchase requisition is displayed.

Click the icon in the Show Details column to view the reference data of the selected requisition at the bottom of the page. The associated agreements and inquiries appear.

You can click an agreement number to open the PO Headers and Line Items page, where the line items of the selected agreement appear. For more information, see Agreements and Line Items.

Data Sources

The table below shows the Smart Materials screen(s) where the data is entered that is displayed in this report. Additionally, this table shows the synchronization table and the CIPs used by the report, and the name of the log file created by the sync job or the report.

Screen

R.30.01 Maintain Requisitions

P.30.11 Inquiries

P.50.07 Maintain Agreements

Table

n/a (no synchronization, direct query)

CIP

n/a (no CIP)

Log File

n/a

The following table shows all values displayed in the report, with the related Smart Materials screen and field where the value is displayed, the database table and column where the value is stored, and CIPs, functions, or procedures that are used to retrieve the value. Optionally, additional comment on the value is entered in the last column.

Value

Screen

Field

Database Column

Other Source/Comment

Project

R.30.11

m_reqs.proj_id

Engineering Requisition

R.30.11

Engineering Requisition

m_reqs.r_code

Suppl

R.30.11

Suppl

m_reqs.r_supp

Origin

R.30.11

Origin

m_reqs.origin_id

Status

R.30.11

Status

m_reqs.rst_id (-> m_req_status.rst_code)

SR Rev

R.30.11

SR Rev

m_reqs.sr_revision

MR Rev

R.30.11

MR Rev

m_reqs.mr_revision

Release Context

R.30.11

Release Context

m_reqs.release_context

Approved By

R.30.11

Approved By

m_reqs.approved_by

Approval Date

R.30.11

Approved Date

m_reqs.approved_date

Released Line Items

R.30.11

Released LI

count of m_req_line_items where release_ind is Y

Negative Qty Line Items

R.30.11

LI with neg Qty

count of m_req_line_items where (rli.total_release_qty - rli.last_total_release_qty) < 0

Changed Attachments

R.30.11

Changed Attachments

bir_p70.get_changed_attachements

Agreement Number

R.30.11

Agreement Number

m_po_headers.po_number

Order Type

R.30.11

Type

m_po_headers.order_type

Suppl

R.30.11

Suppl

m_po_headers.po_supp

Origin

R.30.11

Origin

m_po_headers.origin_id (-> m_origins.origin_code)

Inquiry Number

R.30.11

Inquiry Number

m_inquiries.inq_code

Suppl

R.30.11

Suppl

m_inquiries.i_supp

Purchase

R.30.11

Purchase

m_inquiries.actual_ind

Buyer

R.30.11

Buyer

m_inquiries.po_buyer

Created On

R.30.11

Created On

m_inquiries.inquiry_created_date