| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N2VDNOTE_CONTEXT | IS-H*MED PD: Context of a Progress Entry | 7 | SERVICEID | IS-H: Service Sequence Number | nvarchar | 10 | 0 | | |
TOPEnergy Data Management |
2 | EPAYFRQ_METHOD | Allocation of Paymt Procedure and Frequency f. Serv.Provider | 2 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
3 | ESERVPROV | Service provider | 2 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
4 | ESERVPROVHIST | Service Provider (Historical Data) | 2 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
5 | ESERVPROVKONT | G/L Accounts and Contract Accounts for Service Provider | 2 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
6 | ESERVPROVP | Service provider/vendor | 2 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
7 | ESERVPROVSERVICE | Non-Billable Services (Service Types) for Service Provider | 2 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
8 | ESERVPROVT | Service Provider (Text) | 3 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
9 | ESRCSYSTEM | Source System | 4 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
TOPIntercompany Data Exchange |
10 | ECERTIF | Deregulation: certification | 2 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
11 | EENRCALC | Determination of Process Control | 3 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
12 | EENRRCSUPP | Allocation of Rate Categories to Service Providers | 2 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
13 | ESERVICE | Point of delivery service | 7 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
14 | ESERVICEDET | Determination of Service Types | 4 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
15 | TEPFCS | Obsolete- do not use! | 2 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
16 | TEPRV | Obsolete- do not use! | 2 | SERVICEID | Service Provider (Old) | nvarchar | 10 | 0 | | |
17 | TEPRVT | Obsolete- do not use! | 2 | SERVICEID | Service Provider (Old) | nvarchar | 10 | 0 | | |
TOPMaster Data |
18 | EVER | IS-U Cont. | 51 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
TOPMove-InOut |
19 | ECAMIOPRCI | IS-U: Parked Document: Contracts and Installations | 21 | SERVICEID | Service Provider | nvarchar | 10 | 0 | | |
TOPProduct Configurator |
20 | COMM_CFGDOCKEY | Ref. table between documentation and object | 4 | SERVICEID | Service ID | smallint | 5 | 0 | | |
TOPSAP Internet Transaction Server |
21 | SITS_SERVICE_PAR | ITS: Valid Parameters of Service | 1 | SERVICEID | Service ID (UID) | nvarchar | 25 | 0 | | |
TOPStakeholder Relationship Management |
22 | USS_WEB_SURVEY | USUR0: Link Between Web Survey and Contact | 5 | SERVICEID | Object ID | nvarchar | 64 | 0 | | |