|
|
Data dictionary edis - 7.27
ddcapp - Applications| 1 | application | character | x(12) | | | ? | EDIS application | |
| 2 | descr | character | X(60) | | | | Description | |
| 3 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 4 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 5 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 6 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 8 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 9 | source_cr | character | x(12) | | | | Source creation | |
| 10 | source_lc | character | x(12) | | | | Source last changed | |
| 11 | is_end_point | logical | TRUE/FALSE | | | FALSE | End point | |
Indexes
ddcapp - primary - unique
| 1 | application | character | x(12) | EDIS application |
Contents > ddcapp
ddcdat - EDIS data records| 1 | application | character | x(12) | | | ? | EDIS application | ddcapp |
| 2 | record_id | integer | >>>>>>>>>9 | | | ? | Record ID | |
| 3 | table_name | character | x(25) | | | | EDIS table | ddctab |
| 4 | field_name | character | x(50) | | | | Application (From) | ddcapp |
| 5 | record_state | integer | >>>>>>>>>9 | | | 0 | Status | t_test: edis-record-state |
| 6 | action | integer | >>>>>>>>>9 | | | 0 | EDIS action | t_test: edis-record-action |
| 7 | date_created | date | 99/99/9999 | | | | Date created | |
| 8 | time_created | integer | >>>>>>>>>9 | | | 0 | Time created | |
| 9 | master_id | integer | >>>>>>>>>9 | | | 0 | Header record ID | |
| 10 | detail_records | integer | >>>>>>>>>9 | | | 0 | Number of line records | |
| 11 | transaction_number | integer | >>>>>>>>>9 | | | 0 | Transaction number | |
| 12 | user_created | character | x(20) | | | | User ID | |
| 13 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ddcdat - primary - unique
| 1 | application | character | x(12) | EDIS application |
| 2 | record_id | integer | >>>>>>>>>9 | Record ID |
ddcdat2 - unique
| 1 | application | character | x(12) | EDIS application |
| 2 | master_id | integer | >>>>>>>>>9 | Header record ID |
| 3 | record_id | integer | >>>>>>>>>9 | Record ID |
ddcdat3 - unique
| 1 | application | character | x(12) | EDIS application |
| 2 | record_state | integer | >>>>>>>>>9 | Status |
| 3 | master_id | integer | >>>>>>>>>9 | Header record ID |
| 4 | record_id | integer | >>>>>>>>>9 | Record ID |
ddcdat4 - unique
| 1 | transaction_number | integer | >>>>>>>>>9 | Transaction number |
| 2 | application | character | x(12) | EDIS application |
| 3 | record_id | integer | >>>>>>>>>9 | Record ID |
Contents > ddcdat
ddcdsl - Data storage large| 1 | application | character | x(12) | | | ? | Application | ddcapp |
| 2 | record_id | integer | >>>>>>>>>9 | | | ? | Record ID | ddcdat |
| 3 | large_data | character | x(2048) | | | | Large record data | |
Indexes
ddcdsl - primary - unique
| 1 | application | character | x(12) | Application |
| 2 | record_id | integer | >>>>>>>>>9 | Record ID |
Contents > ddcdsl
ddcdsm - Data storage medium| 1 | application | character | x(12) | | | ? | Application | ddcapp |
| 2 | record_id | integer | >>>>>>>>>9 | | | ? | Record ID | ddcdat |
| 3 | medium_data | character | x(1024) | | | | Medium record data | |
Indexes
ddcdsm - primary - unique
| 1 | application | character | x(12) | Application |
| 2 | record_id | integer | >>>>>>>>>9 | Record ID |
Contents > ddcdsm
ddcdss - Data storage small| 1 | application | character | x(12) | | | ? | Application | ddcapp |
| 2 | record_id | integer | >>>>>>>>>9 | | | ? | Record ID | ddcdat |
| 3 | small_data | character | x(256) | | | | Small record data | |
Indexes
ddcdss - primary - unique
| 1 | application | character | x(12) | Application |
| 2 | record_id | integer | >>>>>>>>>9 | Record ID |
Contents > ddcdss
ddcenu - Enumerator| 1 | application | character | x(12) | | | ? | Application | ddcapp |
| 2 | number_type | integer | >>>>>>>>>9 | | | ? | Number type | t_test: edis-number-type |
| 3 | number_value | integer | >>>>>>>>>9 | | | 0 | Number value | |
Indexes
ddcenu - primary - unique
| 1 | application | character | x(12) | Application |
| 2 | number_type | integer | >>>>>>>>>9 | Number type |
Contents > ddcenu
ddcfld - Fields| 1 | application | character | x(12) | | | ? | EDIS application | ddcapp |
| 2 | table_name | character | x(25) | | | ? | EDIS table | ddctab |
| 3 | field_name | character | x(50) | | | ? | Field name | |
| 4 | field_no | integer | >>>>>>>>>9 | | | 0 | Number | |
| 5 | field_nr_user | integer | >>>>>9 | | | 0 | Field number (User) | |
| 6 | descr | character | X(60) | | | | Description | |
| 7 | data_type | integer | >>>>>>>>>9 | | | 0 | Data type | t_test: edis-data-type |
| 8 | field_length | integer | >>>>>>>>>9 | | | 0 | Length | |
| 9 | number_decimals | integer | >>>>>>>>>9 | | | 0 | Decimals | |
| 10 | field_mandatory | logical | yes/no | | | no | Mandatory | |
| 11 | field_offset | integer | >>>>>>>>>9 | | | 0 | Offset | |
| 12 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 13 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 14 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 15 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 16 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 17 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 18 | source_cr | character | x(12) | | | | Source creation | |
| 19 | source_lc | character | x(12) | | | | Source last changed | |
| 20 | type_master_detail | integer | >>>>>9 | | | 0 | Date format | t_test: date_format |
| 21 | numeric_format | integer | >>>>>9 | | | 0 | Numeric format | t_test: numeric_format |
| 22 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ddcfld - primary - unique
| 1 | application | character | x(12) | EDIS application |
| 2 | table_name | character | x(25) | EDIS table |
| 3 | field_name | character | x(50) | Field name |
ddcfld02ix
| 1 | application | character | x(12) | EDIS application |
| 2 | table_name | character | x(25) | EDIS table |
| 3 | field_nr_user | integer | >>>>>9 | Field number (User) |
Contents > ddcfld
ddcimpdefh - EDIS import definitions| 1 | import_definition | character | x(12) | | | ? | Import definition | |
| 2 | description | character | X(60) | | | | Description | |
| 3 | action | integer | >>>>>9 | | | 0 | EDIS action (Default) | t_test: edis_action |
| 4 | import_path | character | x(256) | | | | Import directory (Default) | |
| 5 | move_path | character | x(256) | | | | Move to directory (Default) | |
| 6 | import_type | integer | >>>>>9 | | | 0 | Import file type | t_test: edis_importtype |
| 7 | import_separator | character | X(1) | | | | Separator | |
| 8 | import_conversion | integer | >>>>>9 | | | 0 | Character conversion | t_test: edis_convertimport |
| 9 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 10 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 11 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 12 | source_cr | character | X(16) | | | | Source creation | |
| 13 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 14 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 15 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 16 | source_lc | character | X(16) | | | | Source last changed | |
| 17 | comment | character | X(1) | | | | Comment | |
Indexes
ddcimpdefh01ix - primary - unique
| 1 | import_definition | character | x(12) | Import definition |
Contents > ddcimpdefh
ddcimpdefl - EDIS import definition (Lines)| 1 | import_definition | character | x(12) | | | ? | Import definition | ddcimpdefh |
| 2 | seqnr_ddcimpdefl | integer | >>>>>9 | | | ? | Sequence number | |
| 3 | seqnr_ddcimpdefl_user | integer | >>>>>9 | | | 0 | Sequence number (User) | |
| 4 | application | character | x(12) | | | | EDIS application | ddcapp |
| 5 | table_name | character | X(25) | | | | EDIS table | ddctab |
| 6 | description | character | X(60) | | | | Description | |
| 7 | import_path | character | x(256) | | | | Import directory | |
| 8 | file_name | character | X(80) | | | | File name | |
| 9 | move_path | character | x(256) | | | | Move to directory | |
| 10 | action | integer | >>>>>9 | | | 0 | EDIS action | t_test: edis_action |
| 11 | type_header_line | integer | >>>>>9 | | | 0 | Header/Line | t_test: edis_masterdetail |
| 12 | field_name_header | character | X(50) | | | | Field name | ddcfld |
| 13 | value_header_field | character | X(50) | | | | Field value | |
| 14 | use_path_file_name | integer | >>>>>9 | | | 0 | Use (Path / File name) | t_test: edis_filenamecopy |
| 15 | field_path_file_name | character | X(50) | | | | Field (Path / File name) | ddcfld |
| 16 | read_file_direction | integer | >>>>>9 | | | 0 | Direction | t_test: read_file_direction |
| 17 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 18 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 19 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 20 | source_cr | character | X(16) | | | | Source creation | |
| 21 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 22 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 23 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 24 | source_lc | character | X(16) | | | | Source last changed | |
| 25 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ddcimpdefl01ix - primary - unique
| 1 | import_definition | character | x(12) | Import definition |
| 2 | seqnr_ddcimpdefl | integer | >>>>>9 | Sequence number |
ddcimpdefl02ix
| 1 | import_definition | character | x(12) | Import definition |
| 2 | seqnr_ddcimpdefl_user | integer | >>>>>9 | Sequence number (User) |
Contents > ddcimpdefl
ddcimpsynh - EDIS import Synergy| 1 | import_synergy | character | X(10) | | | ? | EDIS import Synergy | |
| 2 | application | character | x(12) | | | | EDIS application | ddcapp |
| 3 | table_name | character | X(25) | | | | EDIS table | ddctab |
| 4 | request_type | character | x(1024) | | | | Type | |
| 5 | request_state | character | X(60) | | | | Status | |
| 6 | import_auto | integer | >>>>>>>> | | | 0 | EDIS import: Automatic | |
| 7 | import_timestamp | character | X(18) | | | | EDIS import: Timestamp | |
| 8 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 9 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 10 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 11 | source_cr | character | X(16) | | | | Source creation | |
| 12 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 13 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 14 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 15 | source_lc | character | X(16) | | | | Source last changed | |
Indexes
ddcimpsynh01ix - primary - unique
| 1 | import_synergy | character | X(10) | EDIS import Synergy |
Contents > ddcimpsynh
ddcimpsynl - EDIS import Synergy (Lines)| 1 | import_synergy | character | X(10) | | | ? | EDIS import Synergy | ddcimpsynh |
| 2 | field_nr | character | X(6) | | | ? | Field (To) | ddcfld |
| 3 | field_name | character | X(50) | | | | Field name | |
| 4 | data_type | integer | >>>>>9 | | | 0 | Data type | |
| 5 | synergy_field | integer | >>>>>9 | | | 0 | Field ID | |
| 6 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 7 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 8 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 9 | source_cr | character | X(16) | | | | Source creation | |
| 10 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 11 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 12 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 13 | source_lc | character | X(16) | | | | Source last changed | |
| 14 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ddcimpsynl01ix - primary - unique
| 1 | import_synergy | character | X(10) | EDIS import Synergy |
| 2 | field_nr | character | X(6) | Field (To) |
Contents > ddcimpsynl
ddclnk - Mapping (Lines)| 1 | from_application | character | x(12) | | | ? | Application (From) | ddcapp |
| 2 | to_application | character | x(12) | | | ? | Application (To) | ddcapp |
| 3 | from_table | character | x(25) | | | ? | Table (From) | ddctab |
| 4 | to_number | integer | >>>>>>>>>9 | | | ? | Number | |
| 5 | to_field | character | x(50) | | | ? | Field (To) | ddcfld |
| 6 | expression | character | X(1024) | | | | Expression | |
| 7 | rpn_expression | character | X(1024) | | | | RPN Expression | |
| 8 | rpn_result_type | character | x(1) | | | | RPN Result type | |
| 9 | condition | character | X(1024) | | | | Condition | |
| 10 | rpn_condition | character | X(1024) | | | | RPN Condition | |
| 11 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 12 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 13 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 14 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 15 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 16 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 17 | source_cr | character | x(12) | | | | Source creation | |
| 18 | source_lc | character | x(12) | | | | Source last changed | |
| 19 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ddclnk - primary - unique
| 1 | from_application | character | x(12) | Application (From) |
| 2 | to_application | character | x(12) | Application (To) |
| 3 | from_table | character | x(25) | Table (From) |
| 4 | to_number | integer | >>>>>>>>>9 | Number |
| 5 | to_field | character | x(50) | Field (To) |
Contents > ddclnk
ddcmes - EDIS messages| 1 | application | character | x(12) | | | ? | EDIS application | ddcapp |
| 2 | message_id | integer | >>>>>>>>>9 | | | ? | Message ID | |
| 3 | res_message | character | x(256) | | | | Message | |
| 4 | record_id | integer | >>>>>>>>>9 | | | 0 | Record ID | |
| 5 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ddcmes - primary - unique
| 1 | application | character | x(12) | EDIS application |
| 2 | message_id | integer | >>>>>>>>>9 | Message ID |
ddcmes2 - unique
| 1 | application | character | x(12) | EDIS application |
| 2 | record_id | integer | >>>>>>>>>9 | Record ID |
| 3 | message_id | integer | >>>>>>>>>9 | Message ID |
Contents > ddcmes
ddcpat - Pathways| 1 | from_application | character | x(12) | | | ? | Application (From) | ddcapp |
| 2 | to_application | character | x(12) | | | ? | Application (To) | ddcapp |
| 3 | active | logical | yes/no | | | no | Active | |
| 4 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 5 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 6 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 9 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 10 | source_cr | character | x(12) | | | | Source creation | |
| 11 | source_lc | character | x(12) | | | | Source last changed | |
| 12 | in_use | integer | >>>>>9 | | | 0 | In use | |
| 13 | nr_users | integer | >>>>>>>> | | | 0 | Users | |
Indexes
ddcpat - primary - unique
| 1 | from_application | character | x(12) | Application (From) |
| 2 | to_application | character | x(12) | Application (To) |
Contents > ddcpat
ddctab - Tables| 1 | application | character | x(12) | | | ? | EDIS application | ddcapp |
| 2 | table_name | character | x(25) | | | ? | EDIS table | |
| 3 | descr | character | X(60) | | | | Description | |
| 4 | table_type | integer | >>>>>>>>>9 | | | 0 | Table type | t_test: edis-record-size |
| 5 | from_database | character | x(16) | | | | From database | |
| 6 | import_procedure | character | x(132) | | | | Import procedure | |
| 7 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 8 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 9 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 10 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 11 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 12 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 13 | source_cr | character | x(12) | | | | Source creation | |
| 14 | source_lc | character | x(12) | | | | Source last changed | |
| 15 | table_name_detail | character | X(25) | | | | Table (Header) | |
| 16 | type_master_detail | integer | >>>>>9 | | | 0 | Table usage | |
Indexes
ddctab - primary - unique
| 1 | application | character | x(12) | EDIS application |
| 2 | table_name | character | x(25) | EDIS table |
ddctab01ix
| 1 | application | character | x(12) | EDIS application |
| 2 | table_name_detail | character | X(25) | Table (Header) |
| 3 | table_name | character | x(25) | EDIS table |
Contents > ddctab
ddctar - Mappings| 1 | from_application | character | x(12) | | | ? | Application (From) | ddcapp |
| 2 | to_application | character | x(12) | | | ? | Application (To) | ddcapp |
| 3 | from_table | character | x(25) | | | ? | Table (From) | ddctab |
| 4 | to_number | integer | >>>>>>>>>9 | | | ? | Number | |
| 5 | to_table | character | x(25) | | | | Table (To) | ddctab |
| 6 | expression | character | X(1024) | | | | Condition | |
| 7 | rpn_expression | character | x(256) | | | | RPN Expression | |
| 8 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 9 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 10 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 11 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 12 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 13 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 14 | source_cr | character | x(12) | | | | Source creation | |
| 15 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
ddctar - primary - unique
| 1 | from_application | character | x(12) | Application (From) |
| 2 | to_application | character | x(12) | Application (To) |
| 3 | from_table | character | x(25) | Table (From) |
| 4 | to_number | integer | >>>>>>>>>9 | Number |
ddctar02ix
| 1 | to_application | character | x(12) | Application (To) |
| 2 | to_table | character | x(25) | Table (To) |
Contents > ddctar
ddctrn - Translations| 1 | from_application | character | x(12) | | | ? | Application (From) | ddcapp |
| 2 | to_application | character | x(12) | | | ? | Application (To) | ddcapp |
| 3 | translation_type | character | x(12) | | | ? | Translation type | ddctrt |
| 4 | from_value | character | x(32) | | | ? | From value | |
| 5 | to_value | character | x(32) | | | | To value | |
| 6 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 7 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 8 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 9 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 10 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 11 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 12 | source_cr | character | x(12) | | | | Source creation | |
| 13 | source_lc | character | x(12) | | | | Source last changed | |
| 14 | documents | integer | >>>>>>>> | | | 0 | Documents | |
Indexes
ddctrn - primary - unique
| 1 | from_application | character | x(12) | Application (From) |
| 2 | to_application | character | x(12) | Application (To) |
| 3 | translation_type | character | x(12) | Translation type |
| 4 | from_value | character | x(32) | From value |
Contents > ddctrn
ddctrt - Translation types| 1 | translation_type | character | x(12) | | | ? | Translation type | |
| 2 | descr | character | X(60) | | | | Description | |
| 3 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 4 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 5 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 6 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 7 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 8 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 9 | source_cr | character | x(12) | | | | Source creation | |
| 10 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
ddctrt - primary - unique
| 1 | translation_type | character | x(12) | Translation type |
Contents > ddctrt
y_ddcapp - Logging: Applications| 1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | |
| 2 | application | character | x(12) | | | | EDIS application | |
| 3 | descr | character | X(60) | | | | Description | |
| 4 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 5 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 6 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 9 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 10 | source_cr | character | x(12) | | | | Source creation | |
| 11 | source_lc | character | x(12) | | | | Source last changed | |
| 12 | is_end_point | logical | TRUE/FALSE | | | FALSE | End point | |
Indexes
y_ddcappix - primary - unique
| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_ddcapp1ix
| 1 | application | character | x(12) | EDIS application |
| 2 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_ddcapp
y_ddcfld - Logging: Fields| 1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | |
| 2 | application | character | x(12) | | | | EDIS application | ddcapp |
| 3 | table_name | character | x(25) | | | | EDIS table | ddctab |
| 4 | field_name | character | x(50) | | | | Field name | |
| 5 | field_no | integer | >>>>>>>>>9 | | | 0 | Number | |
| 6 | descr | character | X(60) | | | | Description | |
| 7 | data_type | integer | >>>>>>>>>9 | | | 0 | Data type | t_test: edis-data-type |
| 8 | field_length | integer | >>>>>>>>>9 | | | 0 | Length | |
| 9 | number_decimals | integer | >>>>>>>>>9 | | | 0 | Decimals | |
| 10 | field_mandatory | logical | yes/no | | | no | Mandatory | |
| 11 | field_offset | integer | >>>>>>>>>9 | | | 0 | Offset | |
| 12 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 13 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 14 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 15 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 16 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 17 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 18 | source_cr | character | x(12) | | | | Source creation | |
| 19 | source_lc | character | x(12) | | | | Source last changed | |
| 20 | type_master_detail | integer | >>>>>9 | | | 0 | Date format | t_test: date_format |
| 21 | numeric_format | integer | >>>>>9 | | | 0 | Numeric format | t_test: numeric_format |
Indexes
y_ddcfldix - primary - unique
| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_ddcfld1ix
| 1 | application | character | x(12) | EDIS application |
| 2 | table_name | character | x(25) | EDIS table |
| 3 | field_name | character | x(50) | Field name |
| 4 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_ddcfld
y_ddclnk - Logging: Mapping (Lines)| 1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | |
| 2 | from_application | character | x(12) | | | | Application (From) | ddcapp |
| 3 | to_application | character | x(12) | | | | Application (To) | ddcapp |
| 4 | from_table | character | x(25) | | | | Table (From) | ddctab |
| 5 | to_number | integer | >>>>>>>>>9 | | | 0 | Number | |
| 6 | to_field | character | x(50) | | | | Field (To) | ddcfld |
| 7 | expression | character | X(1024) | | | | Expression | |
| 8 | rpn_expression | character | X(1024) | | | | RPN Expression | |
| 9 | rpn_result_type | character | x(1) | | | | RPN Result type | |
| 10 | condition | character | X(1024) | | | | Condition | |
| 11 | rpn_condition | character | X(1024) | | | | RPN Condition | |
| 12 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 13 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 14 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 15 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 16 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 17 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 18 | source_cr | character | x(12) | | | | Source creation | |
| 19 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
y_ddclnkix - primary - unique
| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_ddclnk1ix
| 1 | from_application | character | x(12) | Application (From) |
| 2 | to_application | character | x(12) | Application (To) |
| 3 | from_table | character | x(25) | Table (From) |
| 4 | to_number | integer | >>>>>>>>>9 | Number |
| 5 | to_field | character | x(50) | Field (To) |
| 6 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_ddclnk
y_ddcpat - Logging: Pathways| 1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | |
| 2 | from_application | character | x(12) | | | | Application (From) | ddcapp |
| 3 | to_application | character | x(12) | | | | Application (To) | ddcapp |
| 4 | active | logical | yes/no | | | no | Active | |
| 5 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 6 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 7 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 8 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 9 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 10 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 11 | source_cr | character | x(12) | | | | Source creation | |
| 12 | source_lc | character | x(12) | | | | Source last changed | |
| 13 | in_use | integer | >>>>>9 | | | 0 | In use | |
| 14 | nr_users | integer | >>>>>>>> | | | 0 | Users | |
Indexes
y_ddcpatix - primary - unique
| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_ddcpat1ix
| 1 | from_application | character | x(12) | Application (From) |
| 2 | to_application | character | x(12) | Application (To) |
| 3 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_ddcpat
y_ddctab - Logging: Tables| 1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | |
| 2 | application | character | x(12) | | | | EDIS application | ddcapp |
| 3 | table_name | character | x(25) | | | | EDIS table | |
| 4 | descr | character | X(60) | | | | Description | |
| 5 | table_type | integer | >>>>>>>>>9 | | | 0 | Table type | t_test: edis-record-size |
| 6 | from_database | character | x(16) | | | | From database | |
| 7 | import_procedure | character | x(132) | | | | Import procedure | |
| 8 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 9 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 10 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 11 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 12 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 13 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 14 | source_cr | character | x(12) | | | | Source creation | |
| 15 | source_lc | character | x(12) | | | | Source last changed | |
| 16 | table_name_detail | character | X(25) | | | | Table (Header) | |
| 17 | type_master_detail | integer | >>>>>9 | | | 0 | Table usage | |
Indexes
y_ddctabix - primary - unique
| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_ddctab1ix
| 1 | application | character | x(12) | EDIS application |
| 2 | table_name | character | x(25) | EDIS table |
| 3 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_ddctab
y_ddctar - Logging: Mappings| 1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | |
| 2 | from_application | character | x(12) | | | | Application (From) | ddcapp |
| 3 | to_application | character | x(12) | | | | Application (To) | ddcapp |
| 4 | from_table | character | x(25) | | | | Table (From) | ddctab |
| 5 | to_number | integer | >>>>>>>>>9 | | | 0 | Number | |
| 6 | to_table | character | x(25) | | | | Table (To) | ddctab |
| 7 | expression | character | X(1024) | | | | Condition | |
| 8 | rpn_expression | character | x(256) | | | | RPN Expression | |
| 9 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 10 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 11 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 12 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 13 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 14 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 15 | source_cr | character | x(12) | | | | Source creation | |
| 16 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
y_ddctarix - primary - unique
| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_ddctar1ix
| 1 | from_application | character | x(12) | Application (From) |
| 2 | to_application | character | x(12) | Application (To) |
| 3 | from_table | character | x(25) | Table (From) |
| 4 | to_number | integer | >>>>>>>>>9 | Number |
| 5 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_ddctar
y_ddctrn - Logging: Translations| 1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | |
| 2 | from_application | character | x(12) | | | | Application (From) | ddcapp |
| 3 | to_application | character | x(12) | | | | Application (To) | ddcapp |
| 4 | translation_type | character | x(12) | | | | Translation type | ddctrt |
| 5 | from_value | character | x(32) | | | | From value | |
| 6 | to_value | character | x(32) | | | | To value | |
| 7 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 8 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 9 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 10 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 11 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 12 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 13 | source_cr | character | x(12) | | | | Source creation | |
| 14 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
y_ddctrnix - primary - unique
| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_ddctrn1ix
| 1 | from_application | character | x(12) | Application (From) |
| 2 | to_application | character | x(12) | Application (To) |
| 3 | translation_type | character | x(12) | Translation type |
| 4 | from_value | character | x(32) | From value |
| 5 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
Contents > y_ddctrn
y_ddctrt - Logging: Translation types| 1 | seqnr_log | integer | >,>>>,>>9 | | | ? | Sequence number | |
| 2 | translation_type | character | x(12) | | | | Translation type | |
| 3 | descr | character | X(60) | | | | Description | |
| 4 | euserid_cr | character | x(20) | | | | Created: User | stuser |
| 5 | date_cr | date | 99/99/9999 | | | | Created: Date | |
| 6 | time_cr | integer | >>>>>9 | | | ? | Created: Time | |
| 7 | euserid_lc | character | x(20) | | | | Modified: User | stuser |
| 8 | date_lc | date | 99/99/9999 | | | | Modified: Date | |
| 9 | time_lc | integer | >>>>>9 | | | ? | Modified: Time | |
| 10 | source_cr | character | x(12) | | | | Source creation | |
| 11 | source_lc | character | x(12) | | | | Source last changed | |
Indexes
y_ddctrtix - primary - unique
| 1 | seqnr_log | integer | >,>>>,>>9 | Sequence number |
y_ddctrt1ix
| 1 | translation_type | character | x(12) | Translation type |
Contents > y_ddctrt
| Main Category: |
Attachments & notes |
Document Type: |
Online help main |
| Category: |
|
Security level: |
All - 0 |
| Sub category: |
|
Document ID: |
29.158.080 |
| Assortment: |
Exact Financials
|
Date: |
10-09-2019 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|
|