| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /BIC/B0000189000 | PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line | 95 | REC_TYPE | | nvarchar | 1 | 0 | | |
| 2 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 8 | REC_TYPE | | nvarchar | 10 | 0 | | |
| 3 | BKKPOMND | Payment order Enriched with Mandate details | 42 | REC_TYPE | SEPA Mandate: Recipient Type | nvarchar | 10 | 0 | | |
| TOPBank |
| 4 | SEPA_MANDATE | SEPA Mandate | 45 | REC_TYPE | SEPA Mandate: Recipient Type | nvarchar | 10 | 0 | | |
| TOPBank Accounting |
| 5 | TCJ_BALANCE | FI Cash Journal: Totals Records | 4 | REC_TYPE | Totals Record Type for Cash Journal | nvarchar | 4 | 0 | | |
| TOPCheck Input |
| 6 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 6 | REC_TYPE | PRA Journal Entry Record Type (0=Control, 1= Line item) | nvarchar | 1 | 0 | | |
| TOPCommunication Services Mail, Fax, SMS, Telephony |
| 7 | SXROUTE | SAPconnect: Routing table | 5 | REC_TYPE | SAPconnect: Address type | nvarchar | 3 | 0 | | |
| TOPeCATT Extended Computer Aided Test Tool |
| 8 | ECTRACE | eCATT Recordings | 1 | REC_TYPE | eCATT Recorder Recording Type | nvarchar | 10 | 0 | | |
| 9 | ECTRACE_CONTENT | eCATT Trace - Recordings in the Test Content System | 1 | REC_TYPE | eCATT Recorder Recording Type | nvarchar | 10 | 0 | | |
| 10 | ECTR_ACTIVATE | eCATT Activation Cross-Session Recording | 2 | REC_TYPE | eCATT Recorder Recording Type | nvarchar | 10 | 0 | | |
| 11 | ECTR_ACTIVATE_CS | eCATT Activation Cross-Session Recording - 2 | 2 | REC_TYPE | eCATT Recorder Recording Type | nvarchar | 10 | 0 | | |
| 12 | ECTR_ACTIVATE_ES | eCATT Activation Cross-Session Recording - 2 | 2 | REC_TYPE | eCATT Recorder Recording Type | nvarchar | 10 | 0 | | |
| TOPIncident Recording |
| 13 | EHHSSD_INC_PSTAT | Incident - Person Statement | 13 | REC_TYPE | Type of Statement Recorder | nvarchar | 21 | 0 | | |
| TOPRecords and Case Management |
| 14 | RMPSE_SOA_REC | Define Record Types for Services | 4 | REC_TYPE | RecordType | nvarchar | 5 | 0 | | |
| TOPRevenue |
| 15 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 7 | REC_TYPE | PRA Journal Entry Record Type (0=Control, 1= Line item) | nvarchar | 1 | 0 | | |
| 16 | OIUH_RV_JEINTF | PRA Journal Entries | 6 | REC_TYPE | PRA Journal Entry Record Type (0=Control, 1= Line item) | nvarchar | 1 | 0 | | |
| TOPRoyalty Reporting |
| 17 | OIUREP_ADJ_DTLA | MMS OGOR A Adjustment Detail Record | 6 | REC_TYPE | Detail Layout Record Type | nvarchar | 2 | 0 | | |
| 18 | OIUREP_ADJ_DTLB | MMS OGOR B Adjustment Detail Record | 6 | REC_TYPE | Detail Layout Record Type | nvarchar | 2 | 0 | | |
| 19 | OIUREP_ADJ_DTLC | MMS OGOR C Adjustment Detail Record | 6 | REC_TYPE | Detail Layout Record Type | nvarchar | 2 | 0 | | |
| 20 | OIUREP_ADJ_HDR | Adjustment Header for MMS OGOR | 6 | REC_TYPE | Detail Layout Record Type | nvarchar | 2 | 0 | | |
| 21 | OIUREP_ADJ_PASR | MMS PASR Adjustment Detail Record | 6 | REC_TYPE | Detail Layout Record Type | nvarchar | 2 | 0 | | |
| 22 | OIUREP_ADJ_PASRH | MMS PASR Adjustment Header Record | 6 | REC_TYPE | Detail Layout Record Type | nvarchar | 2 | 0 | | |
| 23 | OIUREP_HISTCNTRL | Regulatory Reporting History Control table | 3 | REC_TYPE | History Record Type | nvarchar | 2 | 0 | | |
| 24 | OIUREP_STRUC | Regulatory Reporting Structures | 9 | REC_TYPE | Detail Layout Record Type | nvarchar | 2 | 0 | | |
| TOPTransaction Data Pool |
| 25 | JBDVTLD_POS | Variable Transaction: Ledger Item | 5 | REC_TYPE | Record Type | nvarchar | 1 | 0 | | |
| TOPUse Subcomponents |
| 26 | SOER | SAPoffice: receive externally | 5 | REC_TYPE | Receive externally: Recipient type | nvarchar | 1 | 0 | | |
| 27 | SOGR | SAPoffice: Recipient determination during inbound distrib. | 3 | REC_TYPE | Code for document class | nvarchar | 3 | 0 | | |
| 28 | TBCS_RECIP | Control Table for Possible Dialog Recipient Types | 1 | REC_TYPE | Specification of recipient type | nvarchar | 1 | 0 | | |
| TOPUser and Authorization Management |
| 29 | TUL_ENG_PROT | System Measurement: Engine Use Logs | 6 | REC_TYPE | Key for measurement data | nvarchar | 10 | 0 | | |
| TOPValuation |
| 30 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 8 | REC_TYPE | PRA Journal Entry Record Type (0=Control, 1= Line item) | nvarchar | 1 | 0 | | |
