| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/X005 | Approval COA Fields | 9 | SEQ_ID | Dummy for B20 int1 (Local Everywhere) | tinyint | 3 | 0 | | |
2 | /OPT/Y005 | Approval COA Fields | 9 | SEQ_ID | Dummy for B20 int1 (Local Everywhere) | tinyint | 3 | 0 | | |
3 | /OPT/Z005 | Approval COA Fields | 9 | SEQ_ID | Dummy for B20 int1 (Local Everywhere) | tinyint | 3 | 0 | | |
TOPAdvanced Returns Management |
4 | MSR_I_SEQ | Multi-step returns -sequence bundles steps | 1 | SEQ_ID | Sequence Identification Number | nvarchar | 4 | 0 | | |
5 | MSR_I_SEQ2CHAIN | Multi-step returns - combines the current state with planned | 3 | SEQ_ID | Sequence Identification Number | nvarchar | 4 | 0 | | |
6 | MSR_I_SEQ_T | Multi-step returns - associated text table to MSR_I_SEQ | 2 | SEQ_ID | Sequence Identification Number | nvarchar | 4 | 0 | | |
7 | MSR_I_STEP2SEQ | Multi-step returns - assign steps to sequence | 1 | SEQ_ID | Sequence Identification Number | nvarchar | 4 | 0 | | |
TOPCalculations |
8 | CMS_BCM_CGP_ADM | Admin data of covarage gap monitoring report | 4 | SEQ_ID | Natural Number | int | 10 | 0 | | |
TOPFinancial Accounting |
9 | /OPT/BL_T401 | Approval COA Fields | 9 | SEQ_ID | Dummy for B20 int1 (Local Everywhere) | tinyint | 3 | 0 | | |
TOPIncentive and Commission Management ICM |
10 | CACS25_SESHD | Settlement Schedule Header | 5 | SEQ_ID | Sequence Number of Settlement Schedule | nvarchar | 6 | 0 | | |
11 | CACS25_SESIT | Settlement Schedule Item | 4 | SEQ_ID | Sequence Number of Settlement Schedule | nvarchar | 6 | 0 | | |
12 | CACS_FFLTIT | Fulfillment Level Item | 4 | SEQ_ID | Fulfillment Level Sequence ID | nvarchar | 4 | 0 | | |
13 | YCRM01_SESHD | Settlement Schedule Header | 5 | SEQ_ID | Sequence Number of Settlement Schedule | nvarchar | 6 | 0 | | |
14 | YCRM01_SESIT | Settlement Schedule Item | 4 | SEQ_ID | Sequence Number of Settlement Schedule | nvarchar | 6 | 0 | | |
15 | YSVMA_SESHD | Settlement Schedule Header | 5 | SEQ_ID | Sequence Number of Settlement Schedule | nvarchar | 6 | 0 | | |
16 | YSVMA_SESIT | Settlement Schedule Item | 4 | SEQ_ID | Sequence Number of Settlement Schedule | nvarchar | 6 | 0 | | |
17 | YTEL05_SESHD | Settlement Schedule Header | 5 | SEQ_ID | Sequence Number of Settlement Schedule | nvarchar | 6 | 0 | | |
18 | YTEL05_SESIT | Settlement Schedule Item | 4 | SEQ_ID | Sequence Number of Settlement Schedule | nvarchar | 6 | 0 | | |
TOPWeb Service and SOAP - ABAP |
19 | SRT_SEQ_CX_INFO | soap sequence exceptons as xstring | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
20 | SRT_SEQ_ERR_INFO | soap sequence status information | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
21 | SRT_SEQ_HDR_STAT | soap_sequence header and state info | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
22 | SRT_SEQ_HEADER | soap_sequence header information | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
23 | SRT_SEQ_MSG_DEL | Buffer previous message id | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
24 | SRT_SEQ_MSG_QUE | Buffer message id#s that are queued but not processed | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
25 | SRT_SEQ_QUEUE | Soap sequence: assigned queue | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
26 | SRT_SEQ_QUE_HIST | Soap sequence : History of former queues | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
27 | SRT_SEQ_REORG | queue for sequences that can be reorg after termination | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
28 | SRT_SEQ_RETRY | soap_sequence header information | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
29 | SRT_SEQ_RTRYCONT | soap_sequence header information | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
30 | SRT_SEQ_STATE | soap sequence status information | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
31 | SRT_SEQ_TST_DT | Sequence Manager test data | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
32 | SRT_SEQ_WSRM | Soap Sequence: assigned WSRM sequence | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
33 | SRT_SEQ_WSRM_REL | Relationship WSRM sequence to soap sequence for fast access | 4 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
34 | SRT_SEQ_WS_HIST | Soap sequence: History of former wsrm sequences | 3 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |
35 | SRT_TEST_WSA_CL | Contains info for the received msg from ws-a client test | 1 | SEQ_ID | Character field of length 40 | nvarchar | 40 | 0 | | |
36 | SRT_TF_TST_DATA | DB Table where the data from Test Scenarios to be store | 2 | SEQ_ID | Soap Sequence Id | nvarchar | 32 | 0 | | |