| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVC_SCNR_NRIV | Number range intervals | 11 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
2 | CNVTDMSBW_NRDIM | Number range table for DIMID | 9 | EXTERNIND | General Flag | nvarchar | 1 | 0 | | |
3 | CNVTDMSBW_NRSID | Number range Table for SID | 8 | EXTERNIND | General Flag | nvarchar | 1 | 0 | | |
4 | CNVTDMS_05_NRIV | TDMS Table for Number Range Intervals | 10 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
5 | CNVTDMS_11_NRANG | TDMS Number Ranges | 7 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
6 | CNV_20000_NRIV | Back up table for NRIV | 11 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
7 | CNV_20201_NRIV_N | Target number ranges | 10 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
8 | CNV_20201_NRIV_O | Source number ranges | 10 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
9 | CNV_NCE_NRIV_BAK | Number Conversion Engine: NRIV before modifications / Backup | 11 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
10 | CNV_NCE_NRIV_SIM | Number Conversion Engine: NRIV entries for simulation | 14 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
11 | CNV_NCE_NRIV_TMP | NCE: Number intervals on basis of NRIV | 15 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
12 | CNV_NCE_NRIV_WRK | Number Conversion Engine: NRIV copy for modifications | 12 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
13 | IUUC_NRIVLO_SNAP | Local NRIV for multiprocessor machines | 12 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
14 | IUUC_NRIVSH_SNAP | Local NRIV for multiprocessor machines | 14 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
15 | IUUC_NRIV_SNAP | IUUC Number Range Intervals | 11 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
16 | NRIV_DOCU | Non-Assigned Internal Numbers in Parallel Buffering | 14 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
TOPBasic Functions |
17 | ANKL | Generation table for generating asset classes from accounts | 18 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
TOPBasis Technology R3 |
18 | /ISDFPS/BAPINRIV | Transfer Data for NRIV Update | 7 | EXTERNIND | External Number Range Interval | nvarchar | 1 | 0 | | |
19 | /ISDFPS/NRIV | Central Table for Cross-System Number Ranges | 7 | EXTERNIND | External Number Range Interval | nvarchar | 1 | 0 | | |
20 | /ISDFPS/NRIV_UPD | Cross-System NR Settings - Update Using Local System | 7 | EXTERNIND | External Number Range Interval | nvarchar | 1 | 0 | | |
TOPClinical System |
21 | N1KRS | IS-H*MED: Number Ranges | 4 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
TOPLogistics Basic Data |
22 | WRF_MATGRP_TREE | Table of Hierarchy Levels | 4 | EXTERNIND | External Number Assignment | nvarchar | 1 | 0 | | |
TOPMigration |
23 | VIGW_NUM | Nummernvergabe auf Objektebene | 4 | EXTERNIND | Tunnus sisäiselle (" ") tai ulkoiselle ("X") numerosarjalle | nvarchar | 1 | 0 | | |
TOPNumber Range Management |
24 | NRIV | Number Range Intervals | 9 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
25 | NRIVSHADOW | Local NRIV for multiprocessor machines | 12 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
26 | NRIV_LOKAL | Local NRIV for multiprocessor machines | 10 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
27 | NRIV_RESTE | Internal numbers not assigned in conn. with NRIV split | 12 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
TOPProduction and Revenue Accounting |
28 | OIUCM_SN_NR_CONF | Number Range Interval Assignments To PRA Tables | 3 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
29 | OIUCM_SN_NR_T | Text Descriptions for OIU_CM_SN_NR tables | 3 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
30 | OIU_CM_SN_NR | Number ranges by table names | 2 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
31 | OIU_PR_DN_GRP | PRA: DN Group Codes | 4 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
32 | OIU_PR_FL_GRP | PRA: Field Group Codes | 4 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
33 | OIU_PR_MP_GRP | PRA MP Group Codes | 4 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
34 | OIU_PR_PF_GRP | PRA: Platform Group Codes | 4 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
35 | OIU_PR_RS_GRP | PRA: Reservoir Group Codes | 4 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
36 | OIU_PR_WL_GRP | PRA: Well Group Codes | 4 | EXTERNIND | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |