Reports Editor (smoReportDesigner) - Examples
Purchase Order
![]() |
|
![]() |
View of the editor |
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
![]() |
|
![]() |
View of the editor |
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
![]() |
|