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