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