| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting - General |
1 | TFC_CLS_ITEM | Hierarchies for Closing | 4 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
2 | TFC_CLS_ITEMT | Hierarchies for Closing | 4 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
3 | TFC_INST_CLS_IT | Hierarchies for Closing | 6 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
4 | TFC_INST_ORG_OB | Organizational Levels per Profile/Instance | 4 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
5 | TFC_INST_ORG_OBT | Organizational Levels per Profile/Instance | 4 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
6 | TFC_ORG_OBJECTS | Customizing for Org Objects | 2 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
7 | TFC_ORG_OBJECTST | Customizing for Org Objects | 2 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
8 | TFC_TEMPL_CLS_IT | Hierarchies for Closing | 6 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
9 | TFC_TEMPL_ORG_OB | Organizational Levels per Profile/Instance | 4 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
10 | TFC_TEMPL_ORG_OT | Organizational Levels per Profile/Instance | 4 | ORGTYPE | Structure Data Type for Fast Close | nvarchar | 5 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
11 | EBPP_ORDER_HDR | Zahlungsanweisungen über EBPP: Kopfdaten | 2 | ORGTYPE | Type of Organization | nvarchar | 2 | 0 | | |
12 | EBPP_ORDER_ITM | Payment Orders via Biller Direct: Items | 2 | ORGTYPE | Type of Organization | nvarchar | 2 | 0 | | |
13 | EBPP_ORDER_PAY | Payment Orders via Biller Direct: Payment Data | 2 | ORGTYPE | Type of Organization | nvarchar | 2 | 0 | | |
TOPCentral Part of Product Master |
14 | COMS_SET_GEN_DAT | Objects for Generating Set Types | 3 | ORGTYPE | Indicator for Organizational Dependency | nvarchar | 10 | 0 | | |
15 | COMS_SET_GEN_DEF | COMC_SETTYPE Entries for the Set Type Generation | 3 | ORGTYPE | Indicator for Organizational Dependency | nvarchar | 10 | 0 | | |
16 | COMS_SET_GEN_KEY | Variants During Generation of Set Types | 3 | ORGTYPE | Indicator for Organizational Dependency | nvarchar | 10 | 0 | | |
17 | COMS_SET_GEN_K_T | Variants During Generation of Set Types | 3 | ORGTYPE | Indicator for Organizational Dependency | nvarchar | 10 | 0 | | |
TOPConfiguration Control |
18 | IE4N_USPI | Definition of User-Specific Settings: Installation | 2 | ORGTYPE | Organization Type | nvarchar | 2 | 0 | | |
19 | IE4N_USPR | Definition of User-Specific Settings: Dismantling | 2 | ORGTYPE | Organization Type | nvarchar | 2 | 0 | | |
TOPPortfolio Management |
20 | RPM_FIDATA | Financial Information | 20 | ORGTYPE | Organisation Type | nvarchar | 4 | 0 | | |
21 | RPM_ORGTYPE | Organisation Type | 3 | ORGTYPE | Organisation Type | nvarchar | 4 | 0 | | |
22 | RPM_ORGTYPE_T | Organisation Type Text | 4 | ORGTYPE | Organisation Type | nvarchar | 4 | 0 | | |
23 | RPM_PROJECT_CO | Controlling Information about a project | 17 | ORGTYPE | Organisation Type | nvarchar | 4 | 0 | | |
TOPProduct Configurator |
24 | COMM_CFGKB | Runtime Version of SCE Knowledge Base | 20 | ORGTYPE | Organisation Type | nvarchar | 10 | 0 | | |
TOPSet Types and Attributes |
25 | COMS_SETTYPE_GEN | Settings for Generating Set Types | 3 | ORGTYPE | Indicator for Organizational Dependency | nvarchar | 10 | 0 | | |
26 | COMS_SET_DETAIL | Settings for Generating Set Types | 3 | ORGTYPE | Indicator for Organizational Dependency | nvarchar | 10 | 0 | | |
27 | COMS_SET_GEN_D_T | Objects for Generating Set Types | 3 | ORGTYPE | Indicator for Organizational Dependency | nvarchar | 10 | 0 | | |
28 | COMS_SET_HEADER | Settings for Generating Set Types | 3 | ORGTYPE | Indicator for Organizational Dependency | nvarchar | 10 | 0 | | |