Reports Editor (smoReportDesigner) - Examples

Last modified on 2022/05/28 10:55

Purchase Order

MasterData: EP_ORDER table containing information on the order

DetailData: AM_SUPPLIER table containing information on the supplier

Logical field name Position in the data tree Physical field name
Supplier EP_ORDER/Master Table/AM_SUPPLIER SUPPLIER
Address EP_ORDER/Master Table/AM_SUPPLIER ADDRESS_1
Address Line 2 EP_ORDER/Master Table/AM_SUPPLIER ADDRESS_2
Zip Code EP_ORDER/Master Table/AM_SUPPLIER ZIP_CODE
City EP_ORDER/Master Table/AM_SUPPLIER CITY

DetailData : table EP_ORDER_DETAILS containing the order details

Logical field name Position in the data tree Physical field name
Ordered Qty EP_ORDER_DETAILS QTY_ORDERED
Unit Price EP_ORDER_DETAILS UNIT_NET_PRICE
Brand Name EP_ORDER_DETAILS/Master Tables/AM_CATALOG (CATALOG_ID)/Master Tables/AM_MANUFACTURER (MANUFACTURER_ID) MANUFACTURER
Model EP_ORDER_DETAILS/Master Tables/AM_CATALOG (CATALOG_ID) ARTICLE_MODEL

Equipment form

MasterData: AM_ASSET table containing information on equipment

Logical field name Position in the data tree Physical field name
Asset Tag AM_ASSET ASSET_TAG
Comment AM_ASSET COMMENT_ASSET
Delivery Date AM_ASSET DELIVERY_DATE

Note: The RTZCONVERT function is automatically inserted and converts the date/time to the current user's local time zone:

RTZCONVERT(< AM_ASSET."DELIVERY_DATE">)

Last Automatic Inventory AM_ASSET LAST_AUTOMATIC_DISCOVERY
Invoice Number AM_ASSET INVOICE_NUMBER
Last Physical Inventory AM_ASSET LAST_PHYSICAL_INVENTORY

Note: The RTZCONVERT function is automatically inserted and converts the date/time to the current user's local time zone:

RTZCONVERT(< AM_ASSET."LAST_PHYSICAL_INVENTORY">)

Network Identifier AM_ASSET NETWORK_IDENTIFIER
P.O. Number AM_ASSET ORDER_NUMBER
Purchase Price AM_ASSET PURCHASE_PRICE
Purchase Date AM_ASSET PURCHASE_DATE

Note: The RTZCONVERT function is automatically inserted and converts the date/time to the current user's local time zone:

RTZCONVERT(< AM_ASSET."PURCHASE_DATE">)

Location AM_ASSET LOCATION_ID

Note: The SMO_TREE_GET_PATH function is automatically inserted and converts the location ID to the location name:

[SMO_TREE_GET_PATH('AM_LOCATION',< AM_ASSET."LOCATION_ID">)]

Department AM_ASSET DEPARTMENT_ID

Note: The SMO_TREE_GET_PATH function is automatically inserted and converts the department ID to the department name:

[SMO_TREE_GET_PATH('AM_DEPARTMENT',< AM_ASSET."DEPARTMENT_ID">)]

Category AM_ASSET/Master Tables/AM_CATALOG (CATALOG_ID) UN_CLASSIFICATION_ID

Note: The SMO_TREE_GET_PATH function is automatically inserted and converts the catalog ID to the catalog name:

[SMO_TREE_GET_PATH('AM_UN_CLASSIFICATION',< AM_CATALOG."UN_CLASSIFICATION_ID">)]

Model AM_ASSET/Master Tables/AM_CATALOG (CATALOG_ID) ARTICLE_MODEL
Brand Name AM_ASSET/Master Tables/AM_CATALOG (CATALOG_ID)/Master Tables/AM_MANUFACTURER (MANUFACTURER_ID) MANUFACTURER

DetailData: AM_ASSET_CHARACTERISTICS table containing equipment attributes

Logical field name Position in the data tree Physical field name
Attribute AM_ASSET/Detail Tables/AM_ASSET_CHARACTERISTICS/Master Tables/AM_CHARACTERITICS CHARACTERISTIC_EN
Value AM_ASSET/Detail Tables/AM_ASSET_CHARACTERISTICS DATA_1
Unit AM_ASSET/Detail Tables/AM_ASSET_CHARACTERISTICS/Master Tables/AM_CHARACTERITICS/Master Tables/ AM_REFERENCE_6 (MEASURE_UNIT_ID) REFERENCE_EN

DetailData: AM_SOFTWARE table containing the software associated with equipment

Logical field name Position in the data tree Physical field name
Software AM_ASSET/Detail Tables/AM_SOFTWARE (ASSET_ID)/Master Tables/AM_CATALOG_2(CATALOG_ID) ARTICLE_MODEL
Detailed Version AM_ASSET/Detail Tables/AM_SOFTWARE (ASSET_ID)/Master Tables/AM_CATALOG_2(CATALOG_ID) CURRENT_LICENCE_VERSION

DetailData: AM_ASSET_LINKS_1 table containing equipment related to other equipment

Logical field name Position in the data tree Physical field name
Asset Tag AM_ASSET/Detail Tables/AM_ASSET_LINKS_1/Master Tables/AM_ASSET_1(ASSET_ID) ASSET_TAG
Category AM_ASSET/Detail tables/AM_ASSET_LINKS_1/Master Tables/AM_ASSET_1(ASSET_ID)/Master Tables/AM_CATALOG_3/Master Tables/AM_UN_CLASSIFICATION (UN_CLASSIFICATION_ID) UN_CLASSIFICATION_FR
Brand Name AM_ASSET/Detail Tables/AM_ASSET_LINKS_1/Master Tables/AM_ASSET_1(ASSET_ID)/Master Tables/AM_CATALOG_3(CATALOG_ID)/Master Tables/AM_MANUFACTURER_1 MANUFACTURER
Model AM_ASSET/Detail Tables/AM_ASSET_LINKS_1/Master Tables/AM_ASSET_1(ASSET_ID)/Master Tables/AM_CATALOG_3 ARTICLE_MODEL

List of employees

MasterData: AM_EMPLOYEE table containing information on employees

Logical field name Position in the data tree Physical field name
Name AM_EMPLOYEE LAST_NAME
Location AM_EMPLOYEE LOCATION_ID

Note: The SMO_TREE_GET_PATH function is automatically inserted and converts the location ID to the location name:

[SMO_TREE_GET_PATH('AM_LOCATION',< AM_EMPLOYEE."LOCATION_ID">)]

Title AM_EMPLOYEE/Master Tables/AM_REFERENCE_1/REFERENCE_FR REFERENCE_FR
VIP Level AM_EMPLOYEE/Master Tables/AM_VIP_LEVEL/VIP_LEVEL_FR VIP_LEVEL_FR

Work order

Actions are filtered by name to exclude initial actions whose name contains Call.

Discard Equipment Form

User form

Tags:
Powered by XWiki © EasyVista 2022