| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FTBB_YC_REF_ENT | Attributes of Reference Entity | 4 | COMPCODE | Company Code as Reference Entity | nvarchar | 4 | 0 | | |
TOPCATT Computer Aided Test Tool |
2 | CATCU | CATT integration of external test tool | 6 | COMPCODE | | nvarchar | 2 | 0 | | |
TOPClaims Management |
3 | ICLALAERES | Current Reserves (Settlement Expenses (ALAE) and Losses) | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
4 | ICLCLAIMDATA | Suppl. Reserves: Claim File | 2 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
5 | ICLCLAIMDATA_OUT | Suppl. Res.: Reserving Results at Indicative Level | 3 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
6 | ICLDRIVER1 | Example 1 for IBNR Driver Table | 2 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
7 | ICLDRIVER2 | Example 2 for IBNR Driver Table | 2 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
8 | ICLHISTDATA | Suppl. Reserves: History Data | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
9 | ICLIBNRQUART | IBNR: Reserves Table | 6 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
10 | ICLINDRESI | Claim-Independent Reserve | 6 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
11 | ICLULAEACCRES | Additional Reserve Amounts at Claim Year and Coverage Level | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
12 | ICLULAECCCDERES | Specified CDE Reserves at Company Code Level | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
13 | ICLULAECFFACTOR | Specified CDE Reserves at Company Code Level | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
14 | ICLULAECOVRES | Determined Additional Reserve Amounts at Coverage Level | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
15 | ICLULAEDRIVER1 | Reported Distribution Key 1 | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
16 | ICLULAEDRIVER2 | Reported Distribution Key 2 | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
17 | ICLULAEPERCENT | Determined Percentage and Additional Reserve Amounts | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
18 | ICLULAEREPPAY | Reported Settlement Expenses | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
19 | ICLULAERES | Current Reassigned Reserves (ULAE) | 4 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
20 | ICL_IBNR_RESULT | IBNR Reserves | 19 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
21 | TICL825 | Entity Table: Company Code | 2 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
22 | TICL825T | Text Table: Suppl. Reserves Company Code | 3 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
23 | TICL827 | CoCde/Ins.Line/RegOff/State: Permitted Combinations | 2 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
24 | TICL832 | Entity Table: G/L Account (Chart of Accts and Coll.Account) | 3 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
25 | TICL834 | CoCde/State/LineProd/Coverage: Permitted Combinations | 2 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
26 | TICL848 | IBNR: Loss/Expense Percentages | 2 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
27 | TICL849 | IBNR: Loss/Expense Percentages | 2 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
28 | TICL850 | IBNR: Loss/Expense Percentage Rate | 2 | COMPCODE | Company Code for Reserves | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
29 | IBROSTMCF | Clarif. Cases from Broker Report | 15 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
30 | IBROSTMH | ISCD: Broker Report - Header Data | 21 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
31 | IBROSTMP | ISCD: Broker Report - Item Data | 30 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
32 | IBROSTMSUM | Broker Summary Postings - Restart Information | 7 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
33 | ITAGCYCDMODE | Mode Within Cash Desk | 6 | COMPCODE | Selection Company Code in Container | nvarchar | 4 | 0 | | |
34 | ITAGCYCF | Cash Desk Carryforward | 9 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
35 | ITAGCYCLEARSUM | Italian Agency Collections: Clearing Account Totals | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
36 | ITAGCYCOLLTR | Transfer Information | 8 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
37 | ITAGCYCOMMCLEAR | TriggerTab Commission to Subagent from Internal Agencies | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
38 | ITAGCYCONTH | Header Data for Cash Desk Container | 31 | COMPCODE | Selection Company Code in Container | nvarchar | 4 | 0 | | |
39 | ITAGCYINSCOMPSH | Agency Collections: Shares to Be Transferred to Insurance | 7 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
40 | ITAGCYPAY | Payment Information | 14 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
41 | ITAGCYSUBCOMMTRG | Trigger Table for Posting and Transferring Subcommission | 7 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
42 | TKKVPYCORR | Customizing for Insufficient Deposit Coverage Correspondence | 2 | COMPCODE | Company Code Group | nvarchar | 4 | 0 | | |
TOPIncentive and Commission Management ICM |
43 | CACS00_DOCFI_H | Data Transfer: FI Documents (Header Data) | 4 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
44 | CACS00_DOCFI_P | Data Transfer: FI Documents (Items) | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
45 | CACSFI_ACSFI | Account Assignment of Stt.Types for FI Settlement System | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
46 | YCRM01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 10 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
47 | YCRM01_ACCST | Account Assignment Type/Cost Info for Settlement Types | 12 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
48 | YCRM01_DOCFI_H | Data Transfer: FI Documents Header Data | 6 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
49 | YCRM01_DOCFI_P | Data Transfer: FI Documents Item | 7 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
50 | YHITEC_ACCAS | Account Assignment Type/Cost Information for Remuneration | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
51 | YHITEC_ACCST | Account Assignment Type/Cost Info for Settlement Types | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
52 | YHITEC_DOCFI_H | Data Transfer: FI Documents Header Data | 4 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
53 | YHITEC_DOCFI_P | Data Transfer: FI Documents Item | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
54 | YSVMA_ACCAS | Account Assignment Type/Cost Information for Remuneration | 13 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
55 | YSVMA_ACCST | Account Assignment Type/Cost Info for Settlement Types | 8 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
56 | YSVMA_DOCFI_H | Data Transfer: FI Documents (Header Data) | 4 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
57 | YSVMA_DOCFI_P | Data Transfer: FI Documents (Items) | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
58 | YTEL01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 16 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
59 | YTEL01_ACCST | Account Assignment Type/Cost Info for Settlement Types | 10 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
60 | YTEL01_DOCFI_H | Data Transfer: FI Documents Header Data | 4 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
61 | YTEL01_DOCFI_P | Data Transfer: FI Documents Item | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
62 | YTEL05_ACCAS | Account Assignment Type/Cost Information for Remuneration | 9 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
63 | YTEL05_ACCST | Account Assignment Type/Cost Info for Settlement Types | 12 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
64 | YTEL05_DOCFI_H | Data Transfer: FI Documents (Header Data) | 4 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
65 | YTEL05_DOCFI_P | Data Transfer: FI Documents (Items) | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
66 | ZICMAG_ACCAS | Account Assignment Type/Cost Information for Remuneration | 8 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
67 | ZICMAG_ACCST | Account Assignment Type/Cost Info for Settlement Types | 8 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
68 | ZICMAG_DOCFI_H | Data Transfer: FI Documents (Header Data) | 4 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
69 | ZICMAG_DOCFI_P | Data Transfer: FI Documents (Items) | 5 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
TOPPosition Budgeting and Control |
70 | T77HRFPM_CLOSING | Settings for Period Closing with Commitment Creation | 2 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
TOPThird Party Remittance |
71 | T51RH | HR payee derived link to FI vendor | 8 | COMPCODE | Company Code | nvarchar | 4 | 0 | | |
TOPTravel Expenses |
72 | PTRV_CCC | Error Receipts for Credit Card Clearing | 31 | COMPCODE | Company ID for Credit Card Clearing | nvarchar | 10 | 0 | | |