Ortems SolutionUpdate
With the release of DELMIA Ortems 2021 Refresh4 (=Fix 2118), 3 enhancement requests are offered:
- 10 more FREE fields are available on some tables (operations, work orders and links)
- 10 more Text-type Complementary Information in INFO_xx tables
- new Complementary Information table for operations has been created (INFO_OP)
Introduction
Additional placeholders for free information allow easier integration with customers’ information systems.
With more user information available, it offers what the users need to analyze and efficiently plan their production.
It is possible to use custom additional Complementary Information at Operation level in the Planning application, as it is already offered at Work Order (WO), Serie, Item, and Machine levels.
10 new “FREE” fields were added, so that the following tables now include 15 FREE fields
- Operation tables : B_BT and B_BT2 (= B_BT for simulation)
- WO tables : B_OF, E_OF and E_OF2 (= E_OF for simulation)
- Link tables : B_PREC, B_PROF, I_PREN, B_PREN and B_PREN2 (= B_PREN for simulation)
FREE fields are named ‘FREE1’ to ‘FREE15’.
FREE fields are offered in the database tables, but not managed in Ortems applications (not visible in Planning program, not visible in WIP Control module, etc). They can be used and displayed in Report module, and managed by interfaces between Ortems and other applications using Vic modules.
New Complementary Information rows
All the Complementary Information tables now include 20 text-type fields (Type & Code can be found in the last part of this presentation about Complementary Information for Operations = INFO_OP table).
Example with Compl. Info. for WOs:
These tables are:
- INFO_OF (Compl. Info. for Work Orders),
- INFO_MACH (Compl. Info. for Machines),
- INFO_ART (Compl. Info. for Items),
- INFO_SER (Compl. Info. for Series)
and
- the new table INFO_OP described below.
These fields are usable in Planning application (left panel with Right Click > Configure option) and in the filters. :
New Complementary Information table for operations
New INFO_OP table is the Complementary Information table for operations
Its structure is the following one:
Column description | Code | Type |
WO ID | NOF | VARCHAR(100) |
Phase code | E_NOPHASE | VARCHAR(100) |
Fraction (split) number | E_FRACTION | NUMERIC(3) |
Standard field designation 1 | L_OP_STR1 | VARCHAR(40) |
Standard field contents 1 | C_OP_STR1 | VARCHAR(1000) |
Standard field designation 2 | L_OP_STR2 | VARCHAR(40) |
Standard field contents 2 | C_OP_STR2 | VARCHAR(1000) |
Standard field designation 3 | L_OP_STR3 | VARCHAR(40) |
Standard field contents 3 | C_OP_STR3 | VARCHAR(1000) |
Standard field designation 4 | L_OP_STR4 | VARCHAR(40) |
Standard field contents 4 | C_OP_STR4 | VARCHAR(1000) |
Standard field designation 5 | L_OP_STR5 | VARCHAR(40) |
Standard field contents 5 | C_OP_STR5 | VARCHAR(1000) |
Standard field designation 6 | L_OP_STR6 | VARCHAR(40) |
Standard field contents 6 | C_OP_STR6 | VARCHAR(1000) |
Standard field designation 7 | L_OP_STR7 | VARCHAR(40) |
Standard field contents 7 | C_OP_STR7 | VARCHAR(1000) |
Standard field designation 8 | L_OP_STR8 | VARCHAR(40) |
Standard field contents 8 | C_OP_STR8 | VARCHAR(1000) |
Standard field designation 9 | L_OP_STR9 | VARCHAR(40) |
Standard field contents 9 | C_OP_STR9 | VARCHAR(1000) |
Standard field designation 10 | L_OP_STR10 | VARCHAR(40) |
Standard field contents 10 | C_OP_STR10 | VARCHAR(1000) |
Standard field designation 11 | L_OP_STR11 | VARCHAR(40) |
Standard field contents 11 | C_OP_STR11 | VARCHAR(350) |
Standard field designation 12 | L_OP_STR12 | VARCHAR(40) |
Standard field contents 12 | C_OP_STR12 | VARCHAR(350) |
Standard field designation 13 | L_OP_STR13 | VARCHAR(40) |
Standard field contents 13 | C_OP_STR13 | VARCHAR(350) |
Standard field designation 14 | L_OP_STR14 | VARCHAR(40) |
Standard field contents 14 | C_OP_STR14 | VARCHAR(350) |
Standard field designation 15 | L_OP_STR15 | VARCHAR(40) |
Standard field contents 15 | C_OP_STR15 | VARCHAR(350) |
Standard field designation 16 | L_OP_STR16 | VARCHAR(40) |
Standard field contents 16 | C_OP_STR16 | VARCHAR(350) |
Standard field designation 17 | L_OP_STR17 | VARCHAR(40) |
Standard field contents 17 | C_OP_STR17 | VARCHAR(350) |
Standard field designation 18 | L_OP_STR18 | VARCHAR(40) |
Standard field contents 18 | C_OP_STR18 | VARCHAR(350) |
Standard field designation 19 | L_OP_STR19 | VARCHAR(40) |
Standard field contents 19 | C_OP_STR19 | VARCHAR(350) |
Standard field designation 20 | L_OP_STR20 | VARCHAR(40) |
Standard field contents 20 | C_OP_STR20 | VARCHAR(350) |
Numeric field designation 1 | L_OP_NUM1 | VARCHAR(40) |
Numeric field contents 1 | C_OP_NUM1 | NUMERIC(11) |
Numeric field designation 2 | L_OP_NUM2 | VARCHAR(40) |
Numeric field contents 2 | C_OP_NUM2 | NUMERIC(11) |
Numeric field designation 3 | L_OP_NUM3 | VARCHAR(40) |
Numeric field contents 3 | C_OP_NUM3 | NUMERIC(11) |
Numeric field designation 4 | L_OP_NUM4 | VARCHAR(40) |
Numeric field contents 4 | C_OP_NUM4 | NUMERIC(11) |
Numeric field designation 5 | L_OP_NUM5 | VARCHAR(40) |
Numeric field contents 5 | C_OP_NUM5 | NUMERIC(11) |
Memo field designation | L_OP_BLOB1 | VARCHAR(40) |
Memo field contents | C_OP_BLOB1 | BLOB |
Free field 1 | FREE1 | VARCHAR(100) |
Free field 2 | FREE2 | VARCHAR(100) |
Free field 3 | FREE3 | VARCHAR(100) |
Free field 4 | FREE4 | VARCHAR(100) |
Free field 5 | FREE5 | VARCHAR(100) |
Reserved 1 | RESERVED1 | VARCHAR(100) |
Reserved 2 | RESERVED2 | VARCHAR(100) |
Reserved 3 | RESERVED3 | VARCHAR(100) |
Reserved 4 | RESERVED4 | VARCHAR(100) |
Reserved 5 | RESERVED5 | VARCHAR(100) |
Reserved User Exit 1 | UE_RESERVED1 | VARCHAR(100) |
Reserved User Exit 2 | UE_RESERVED2 | VARCHAR(100) |
Reserved User Exit 3 | UE_RESERVED3 | VARCHAR(100) |
Reserved User Exit 4 | UE_RESERVED4 | VARCHAR(100) |
Reserved User Exit 5 | UE_RESERVED5 | VARCHAR(100) |
Blob-type fields can store data, but they are not visible in the Planning application description windows.
