Agreements and Line Items - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

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

This report shows the agreements with their line items in all of the projects you can access.

Other costs are not considered by the report.

Before you run this report, you must execute a database job that prepares the data for the report. It is recommended to run this job at least once a day. For more details see Manage Synchronization Jobs. To ensure that Ident descriptions are properly shown in report, run the synchronization for Idents (Full Listing) report before synchronizing the data for Agreements and Line Items report.

  • 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 an Agreement number to filter the report by this agreement. The page header changes to indicate the filter.

The extended price is displayed in the currency unit defined by the session currency setting. If the rule is not defined to convert the agreement (line item) currency into the BIR default currency (defined with DBA setting BI_REPORT_CURRENCY), -1 is displayed as extended price. Furthermore, if the session currency is different than the BIR default currency, the software will convert again. If this conversion fails because the rule is not defined to convert the BIR default currency into the session currency, the extended price will also be shown as -1.

Click an Ident value to open the Idents (Full Listing) report where the ident details are displayed (see Idents (Full Listing)).

Click a Buyer value to view all the agreement line items that are assigned to this buyer.

Click a Commodity Code value to open the Commodity Code (Catalog Search) report where the commodity code details are displayed (see Commodity Codes (Catalog Search)).

SHARED Tip Click Agreements and Line Items to return to the main page.

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

P.50.01 Agreements

P.50.07 Maintain Agreements

Table

P50_IR_DATA[Project]

CIP

m_pck_bir_custom.conv_unit_prio

Log File

sync_p50_ir_......log

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

Order Type

P.50.01

Type

m_po_headers.order_type

Supplier

P.50.07

Supplier

m_po_headers.sup_id (-> m_suppliers.sup_code)

Agreement Number

P.50.01

Agreement Number

m_po_headers.po_number

Suppl

P.50.07

Suppl

m_po_headers.po_supp

Pos

P.50.07

Pos

m_po_line_items.poli_pos

Sub Pos

P.50.07

Sub

m_po_line_items.poli_sub_pos

Quantity

P.50.07

Quantity

m_po_line_items.poli_qty

Quantity Unit

P.50.07

Quantity Unit

m_po_line_items.qty_unit_id (-> m_units.unit_code)

Ident

P.50.07

Ident

m_po_line_items.ident

Ident Short Description

P.50.07

Ident Short Description

 

m_pck_std_custom.ident_desc

Tag Number

P.50.07

Tag Number

m_po_line_items.tag_number

Extended Price - <CURR>

P.50.07

Extended Price - EUR

m_po_line_items.poli_unit_price*m_po_line_items.poli_qty

Extended price in the currency unit defined by the session currency setting. <CURR> is replaced by the defined session currency.

-1 is displayed if the conversion rule is not defined of the agreement currency into the session currency.

Currency

P.50.07

Currency

Currency unit defined by the session currency setting.

Weight

P.50.07

Weight

m_po_line_items.poli_unit_weight*m_po_line_items.poli_qty

Weight Unit

P.50.07

Weight Unit

m_po_line_items.weight_unit_id (-> m_units.unit_code)

Buyer

P.50.07

Buyer

m_po_headers.buyer

Discipline

P.50.07

m_po_headers.dp_id (-> m_disciplines.dp_code).

Commodity Code

P.50.07

Commodity Code

m_po_line_items.ident (-> m_idents.commodity_id -> m_commodity_codes.commodity_code)

Part

P.50.07

Part

m_po_line_items.ident (-> m_idents.part_id -> m_parts.part_code)

Group

P.50.07

Group

m_po_line_items.ident (-> m_idents.group_id -> m_commodity_groups.cg_group_code)

Material Group

P.50.07

Material Group

 

Approved By

P.50.07

Approved By

m_po_headers.approved_by

Approval Date

P.50.07

Approval Date

m_po_headers.approved.date

Incoterm

P.50.07

Incoterm

m_po_line_items.frt_id (-> m_freight_terms.frt_code)

Delivery Place

P.50.07

Delivery Place

m_po_line_items.freight_value

Promised Contract

P.50.07

Prom Contract

m_item_ships.prom_contract_date

Manufacturer

P.50.07

Manufacturer

m_po_line_items.manufacturer

Agreement Other Costs

P.50.07

sum of Cost Value Total

m_pck_bir_custom.get_po_header_other_costs

Gross Other Costs

P.50.07

Gross Other Costs

m_pck_bir_custom.get_poli_gross_other_costs

Net Other Costs

P.50.07

Net Other Costs

m_pck_bir_custom.get_poli_net_other_costs

CIP1

m_pck_bir_custom.get_p50_cip1_header

m_pck_bir_custom.get_p50_cip1

CIP2

m_pck_bir_custom.get_p50_cip2_header

m_pck_bir_custom.get_p50_cip2

CIP3

m_pck_bir_custom.get_p50_cip3_header

m_pck_bir_custom.get_p50_cip3

CIP4

m_pck_bir_custom.get_p50_cip4_header

m_pck_bir_custom.get_p50_cip4

CIP5

m_pck_bir_custom.get_p50_cip5_header

m_pck_bir_custom.get_p50_cip5

CIP6

m_pck_bir_custom.get_p50_cip6_header

m_pck_bir_custom.get_p50_cip6

CIP7

m_pck_bir_custom.get_p50_cip7_header

m_pck_bir_custom.get_p50_cip7

CIP8

m_pck_bir_custom.get_p50_cip8_header

m_pck_bir_custom.get_p50_cip8

CIP9

m_pck_bir_custom.get_p50_cip9_header

m_pck_bir_custom.get_p50_cip9

CIP10

m_pck_bir_custom.get_p50_cip10_header

m_pck_bir_custom.get_p50_cip10