Agreement Cross References - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon

Intergraph Smart Materials Web Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

The Agreement Cross References report can be used to view the cross references between an agreement and the inquiries and requisitions that were used to create this agreement.

  • 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 the agreement number to open the Agreements and Line Items page, where the line items of the selected agreement appear. For more information, see Agreements and Line Items.

Click the icon in the Show Details column to view the reference data of the selected agreement at the bottom of the page. The total costs of the agreement appear, with the applied currency displayed in the header. The inquiries and requisitions associated with the selected agreements are displayed below the total costs.

You can click an engineering requisition to open the Requisitions page, where the line items of the selected requisition appear. For more information, see Requisitions.

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.01 Agreements

Table

P50_IR_DATA[Project]

CIP

m_pck_bir_custom.conv_unit_prio
m_pck_bir_custom.get_aggrev_cipx (x to be replaced by 1 to 10)

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

P.50.01

Project

m_po_headers.proj_id

Agreement Number

P.50.01

Agreement Number

m_po_headers.po_number

Suppl

P.50.07

m_po_headers.po_supp

Short Description

P.50.01

Short Desc

m_po_header_nls.short_desc

Type

P.50.01

Type

m_po_headers.order_type

Supplier

P.50.07

Supplier

m_po_headers.sup_id (-> m_suppliers.sup_code)

Origin

P.50.01

Origin

m_po_headers.origin_id (-> m_origins.origin_code)

Highest Supplement

P.50.07

max(m_po_headers.po_supp)

Buyer

P.50.01

Buyer

m_po_headers.buyer

Expediter

P.50.07

Expediter

m_po_headers.expediter

Traffic

P.50.07

Traffic

m_po_headers.traffic

Expediting Level

P.50.07

Expediting Level

m_po_headers.exped_ilv_id (-> m_inspection_levels.ilv_code)

Inspection Level

P.50.07

Inspection Level

m_po_headers.ilv_id (-> m_inspection_levels.ilv_code)

Routing Method

P.50.07

Routing Method

m_po_headers.rm_id (-> m_routing_methods.rm_code)

Created On

P.50.07

Created On

m_po_headers.creation_date

Approved By

P.50.07

Approved by

m_po_headers.approved_by

Approved Date

P.50.07

Approved Date

m_po_headers.approved.date

Issue Date

P.50.07

Issued

m_po_headers.issue_date

First Delivery

P.50.07

First Delivery

m_po_headers.first_prom_contr_date

Last Delivery

P.50.07

Last Delivery

m_po_headers.last_prom_contr_date

Total Costs

Last Cost

P.50.07

Last Cost

m_po_total_cost.last_price

sum(last_price) of all agreement line items

converted to the session currency using m_sys.m_api_bireport.conv_unit_proj

Changed Cost

P.50.07

Changed Cost

m_po_total_cost.changed_price

sum(changed_price) of all agreement line items

converted to the session currency using m_sys.m_api_bireport.conv_unit_proj

Total Cost

P.50.07

Total Cost

m_po_total_cost.total_price

sum(total_price) of all agreement line items

converted to the session currency using m_sys.m_api_bireport.conv_unit_proj

Tax

P.50.07

Tax

m_po_total_costs.tax_ind

Tax Amount

P.50.07

Tax Amount

m_po_total_costs.tax_amount

sum(tax_amount) of all agreement line items

converted to the session currency using m_sys.m_api_bireport.conv_unit_proj

Total Cost + Tax

P.50.07

Total Cost + Tax

sum(total_price) + sum(tax_amount)

converted to the session currency using m_sys.m_api_bireport.conv_unit_proj

Inquiries

Inquiry Number

P.30.11

Inquiry Number

m_inquiries.inq_code

Suppl

P.30.11

Suppl

m_inquiries.i_supp

Purchase

P.30.11

Purchase

m_inquiries.actual_ind

Buyer

P.30.11

Buyer

m_inquiries.po_buyer

Created On

P.30.11

Created On

m_inquiries.inquiry_created_date

Engineering Requisitions

Engineering Requisition

R.30.01

Engineering Requisition

m_reqs.r_code

Suppl

R.30.01

Suppl

m_reqs.r_supp

Purchase

R.30.01

Purchase

m_reqs.actual_ind

Origin

R.30.01

Origin

m_reqs.origin_id

Short Description

R.30.01

Short Desc

m_req_nls.short_desc

Rel to Proc

R.30.01

Rel to Proc

m_req.rel_to_proc_date

Originator

R.30.01

Originator

m_req.originator