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 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 |
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 |