| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | RDPT_COND_ACTIV | Activate Condition within Redemption Schedule | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
2 | T056A | Time-dependent conditions | 7 | GSART | Business type (interest reference) | nvarchar | 3 | 0 | | |
3 | T056F | Reference interest rates | 2 | GSART | Business type (interest reference) | nvarchar | 3 | 0 | | |
4 | TREAC_EA_POST | Defines in which way flows of an EA should be posted | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
5 | TW15 | Reference between product type and repayment type | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
6 | TW16 | References between product type and security classification | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
7 | TZB11 | Activity-dependent one-time conditions | 6 | GSART | Product Type | nvarchar | 3 | 0 | | |
8 | TZD0A | Darwin: Customer default values per trans. type for KNA1 | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
9 | TZD0B | Darwin: Customer default values per co.cd/trn.type for KNB1 | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
10 | TZD37 | Texts for TZC37 | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
11 | TZKM1 | Event-controlled modification of condition items | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
12 | TZM37 | Transition matrix of internal status | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
13 | TZN01 | Product type numbers | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
14 | VDAPPOFF_RES | Residence Time for Model Calculation Archiving | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
15 | VDCNTL_CASH_FLOW | Display Interval for Cash Flow | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
16 | VDPL_OBJ_CAT_ASS | Assign Insurance Object Category | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
17 | VDPL_SAMPLE_ASS | Assign Samples To Types (Policy Loan Integration) | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
18 | VDPL_TRANS_ASS | Assign Transactions | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
19 | VDREF_INT | Customizing table for Reference Interest Rate | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
20 | VDSEPA_AUTODEB | Records for new auto debit (SEPA direct debit) | 18 | GSART | Product Type | nvarchar | 3 | 0 | | |
21 | VDSEPA_AUTODEB_O | Records for new auto debit (SEPA direct debit) (up to 604) | 18 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPAccounting |
22 | TDIOA_BAL_COND | Assignment Condition Type to Flow Type Grouping - IOA Calc. | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
23 | TDIOA_FT_BALANCE | Assignment of Flows to Flow Type Grouping - IOA Calculation | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
24 | TDIOA_GSTEER | General Control Data for Interest on Arrears Calculation | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
25 | TDIOA_SCHEME_BAL | Assignment of Product Type to Profile and Flow Type Grouping | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
26 | TDIOA_TEMPL | Template for Interest On Arrears Calculation | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
27 | TDIOA_TEMPLTXT | Template Texts for Interest on Arrears Calculation | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
28 | TDIOA_TRIV_AMT | Trivial Amount per Currency and Profile IOA Calculation | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPBack Office |
29 | TRFC_MRG_FT | Assign Update Types for Margin Management | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPBasic Functions |
30 | T036V | Allocation of planning levels for Financial Assets Mgmt | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPFinancial Services |
31 | BWFS_CML_SELEC | Selection Table for FS-CML | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
32 | VDBIW_DATA | Extractor Flow Data - Data of Last Extraction | 12 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPGermany |
33 | TZ41 | Customizing reg. report. fld. ctrl. for prem. res. fund | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPInformation System |
34 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 8 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPLoans Management |
35 | TD01 | Table for collateral keys | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
36 | TD03 | Assign Loan Type -> Product Type | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
37 | TD07 | Purpose of loan | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
38 | TD07T | Purpose of loan (Texts for table TD07) | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
39 | TDA5 | Non-Accept.Reason | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
40 | TDA5T | Reason for non-acceptance (texts for TDA5) | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
41 | TDALE_EXP_LOAN | ALE Export Relevance Per Loan | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
42 | TDB23 | Activity Type - Control of Requirements | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
43 | TDBO_CONDN | Standard Conditions | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
44 | TDCAPTR_GSTEER | General Control Data of Capital Transfer | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
45 | TDCAPTR_TEMPL | Templates for Capital Transfer | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
46 | TDCAPTR_TEMPLTXT | Texts for Capital Transfer Templates | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
47 | TDCAP_COND | Condition amount for capitalization | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
48 | TDCONDVER_MSG | Condition Verification: Update Checks and Define Msge Type | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
49 | TDDEBTTR_GSTEER | General Control Data | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
50 | TDDEFPROD | Control Dunning Using Product Type | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
51 | TDDEF_COND | Condition amount for deferral | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
52 | TDDEF_LIMIT | Limit table for deferral interest | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
53 | TDIOA_BO_MGL | Interest on Arrears Active in BO for Mortgage/General Loans | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
54 | TDIOA_SCHM_TPL | Default Calculation Profile for New Loan | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
55 | TDKK2 | Predefine Correspondence Class Assignment for Partner | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
56 | TDLOAN_CPPART | Default Sttng of Permitted Roles and Roles for Partner Copy | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
57 | TDLOS_CONTROL | Loan Origination: Control Parameters | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
58 | TDLOS_PURPOSE | Loan Origination: Assignment of Loan Purpose | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
59 | TDPAYMLIMITS | Limits for Prepayment | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
60 | TDREPAY_GSTEER | General Control Data for Payoff and Notice | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
61 | TDREPAY_RECLIST | Customizing for Receivables List | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
62 | TDREPAY_RECLISTT | Name of Items in Receivables List | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
63 | TDREPAY_RLFLOWS | Flow Type Groups for Receivables List for Payoff | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
64 | TDREPAY_RLFLOWST | Text Table for TDREPAY_RLFLOWST | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
65 | TDREPAY_TEMPL | Table for Payoff and Notice Templates | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
66 | TDREPAY_TEMPLTXT | Texts for Payoff Templates | 5 | GSART | Product Type | nvarchar | 3 | 0 | | |
67 | TDRP_COND_TYPE | Repayment schedule: relevant condition types | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
68 | TDRP_FLOW_TYPE | Repayment schedule: relevant flow types | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
69 | TDTZPA_EXT | Activate Country-Specific Functions | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
70 | TRDC_ADM | Loan Document Data Summarization: Administration Table | 5 | GSART | Product Type | nvarchar | 3 | 0 | | |
71 | TTONFTEXCLOAN | Vom Vergleich ausgeschlossene Darlehen | 5 | GSART | Produktart | nvarchar | 3 | 0 | | |
72 | TTONFTVDARL | Test neue Fima: Grunddaten und VDARL | 30 | GSART | Produktart | nvarchar | 3 | 0 | | |
73 | TVDST | Posting applications control table | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
74 | TVDSTX | Posting applications control table | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
75 | TZB0W | Assign Activity Category - Reversal Transaction Grouping | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
76 | TZPAB_ADDON | Addon for Financial Assets Management product types | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
77 | VDARC_DOC_ADM | Admin. Table for Reorganization of Loan Document Data | 7 | GSART | Product Type | nvarchar | 3 | 0 | | |
78 | VDARL | Loans | 16 | GSART | Product Type | nvarchar | 3 | 0 | | |
79 | VDARL_RP | adContract - Repayment Plan Data | 27 | GSART | Product Type | nvarchar | 3 | 0 | | |
80 | VDBEPP | Flow Data - Planned Item | 32 | GSART | Product Type | nvarchar | 3 | 0 | | |
81 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 32 | GSART | Product Type | nvarchar | 3 | 0 | | |
82 | VDCHK_GROSS_NET | Storage of data for report RFVD_GROSS_TO_NET | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
83 | VDHINT | Loans Interested Parties | 13 | GSART | Product Type | nvarchar | 3 | 0 | | |
84 | VDKOREF | Worklist File for Bal. Sheet Transfer / Acct Assignment Ref. | 17 | GSART | Product Type | nvarchar | 3 | 0 | | |
85 | VDORDER | Borrower's note loan order data | 20 | GSART | Product Type | nvarchar | 3 | 0 | | |
86 | VDPOST_CONTROL | Data Selection for Debit Position | 6 | GSART | Product Type | nvarchar | 3 | 0 | | |
87 | VZFGD | Release data (Informative data for the release procedure) | 17 | GSART | Product Type | nvarchar | 3 | 0 | | |
88 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 35 | GSART | Product Type | nvarchar | 3 | 0 | | |
89 | VZFZE_VDNBZE | Central Entry Table for Release Procedure | 11 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPMaster Data |
90 | TDESC_REASON | Reason Categories | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
91 | TDESC_REASONT | Reason Descriptions | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPOutgoing Payments |
92 | TDDISB_GSTEER | General control data | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
93 | TDDISB_TEMPL | Disbursement: Template | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
94 | TDDISB_TEMPLTXT | Disbursement: Sample Text | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPPortfolio |
95 | TDBILL_PAR | Settings for Billing | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
96 | TDCAP_CUST | Settings/Preassignments for Capitalization of Overdue Items | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
97 | TDCAP_GSTEER | General Control Data | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
98 | TDCHARGE_GSTEER | General Control Data | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
99 | TDDEF_CUST | Settings/Preassignments for Deferral | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
100 | TDDEF_GSTEER | General Control Data | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
101 | TDREMIT_ZIP | Assignment of Remittance Code to Postal Code | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
102 | VDCNCL | Rescission of Business Operation | 21 | GSART | Business type (interest reference) | nvarchar | 3 | 0 | | |
TOPReal Estate Management |
103 | TIV26 | Real Estate Contract Type (Entities) | 13 | GSART | Product Type | nvarchar | 3 | 0 | | |
104 | VIBEPP | Flow data - Planned items for real estate management | 38 | GSART | Product Type | nvarchar | 3 | 0 | | |
105 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 80 | GSART | Product Type | nvarchar | 3 | 0 | | |
106 | VIMI33 | Offers for a rental unit (-> VIMIMV) | 46 | GSART | Product Type | nvarchar | 3 | 0 | | |
107 | VIMIMV | Lease-Out | 60 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPReceivablesPayment Management |
108 | TDMAZNB | Customizing: Automatic Incoming Payment Postprocessing | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
109 | TDPRODPLAN | Assignment of Product Type to IP Distribution Plan | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
110 | TZB41 | Account Clearing: Amount Limits | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
111 | TZB42 | Account Clearing: Checks at Contract Level | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPRegulatory reporting for insurance companies |
112 | TISSR_BPV_ANRECH | Meldewesen Schweiz - Anrechnungsfaktor | 5 | GSART | Produktart | nvarchar | 3 | 0 | | |
113 | TZB2V | Melderelevante Produktarten Österreich | 3 | GSART | Produktart | nvarchar | 3 | 0 | | |
114 | TZC3A | Steuerung Großkreditmeldung Ö (Vertrag/Promesse) | 3 | GSART | Produktart | nvarchar | 3 | 0 | | |
TOPRisk Analysis |
115 | CFAFOIACT_DETAIL | FO Integration: Selection of Details | 5 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPTransaction Data Pool |
116 | JBDBSTD | SAP Banking: Positions | 20 | GSART | Product Type | nvarchar | 3 | 0 | | |
117 | JBDFUNCDEAKT | Deactivate Datapool Functions | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
118 | JBDOBJ1 | Object Table for Financial Transactions, General Part | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
119 | TJBD_FOBJ_ARCH_C | Object-Specific Customizing JB_FOBJ | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
120 | TJBD_LOAN_ARCH_C | Object-Specific Customizing: JB_LOAN | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPTransaction Management |
121 | ATARCHIVE01 | Archiving: Minimum retention period of transaction in system | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
122 | AT200 | Rules for Determining a Tax Indicator | 5 | GSART | Product Type | nvarchar | 3 | 0 | | |
123 | AT210 | Rules for Determining a Taxes for CFM postings | 5 | GSART | Product Type | nvarchar | 3 | 0 | | |
124 | IDCFMBRSE_PST | Customizing for creation of sales transactions for tax pmnts | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
125 | IDCFMSETX_COMP | Compensating method for Funds (TRM) | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
126 | IDCFM_BST_CFM | Customizing for Balance Sheet Transfer for Brazil | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
127 | IDCFM_BST_CFMA | Customizing for Balance Sheet Transfer with VA (obsolete) | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
128 | IDCFM_BST_CFMAV | Customizing for Balance Sheet Transfer with VA (obsolete) | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
129 | IDCFM_BST_CFMIT | Customizing for Balance Sheet Transfer for Brazil (obsolete) | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
130 | IDCFM_BST_CFMIT1 | Customizing for Balance Sheet Transfer for Brazil (obsolete) | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
131 | IDCFM_BST_CUSA | Customizing for Balance Sheet Transfer for Brazil (obsolete) | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
132 | IDCFM_BST_CUSAV | Customizing for Balance Sheet Transfer for Brazil (obsolete) | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
133 | IDCFM_BST_CUST | Customizing for Balance Sheet Transfer for Brazil | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
134 | IDCFM_BST_CUSTIT | Customizing for Balance Sheet Transfer for Brazil | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
135 | IDCFM_FRIM_DATA | Impairment Main Data | 27 | GSART | Product Type | nvarchar | 3 | 0 | | |
136 | RDPT_SET | Quantity of Redemption Schedules | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
137 | TPMA_DERIV_ASSGN | Assignment of Derivation Categories | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
138 | TPMB_LAC_INTERV | Flexible LAC Calculation | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
139 | TRGC_DERIV_ASSGN | Treasury: Assignment of Derivation Categories | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
140 | VWACTCLASSIF | Capitalization of Classification for Product Types | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
141 | VWFL_FT_DE | CFM: Assign Update Type to Flow Type | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
142 | VWT_DEFDEP_PT | CFM: Default Value Securities Account per Product Type | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPTransfer to Financial Accounting |
143 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 9 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPTreasury |
144 | TZ40 | Customizing regulatory reporting field control for contract | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
145 | TZBPV | Control table for CH regulatory reporting (BPV) | 2 | GSART | Business type (interest reference) | nvarchar | 3 | 0 | | |
146 | TZC37 | Financial Assets Management status definition | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
147 | TZPA | Financial Assets Management Product Types | 2 | GSART | Product Type | nvarchar | 3 | 0 | | |
148 | TZPAB | Financial Assets Management product types | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
149 | TZPAT | Financial Assets Management product type texts | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |
150 | VWPANLA | Asset master for securities | 7 | GSART | Product Type | nvarchar | 3 | 0 | | |
151 | VWPT_FREE_ATTR | Free Security Attributes | 4 | GSART | Product Type | nvarchar | 3 | 0 | | |
TOPTreasury and Risk Management |
152 | TZRR2 | Treasury: Valuation Areas at Company Code/Product Type Level | 3 | GSART | Product Type | nvarchar | 3 | 0 | | |