| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CF002 | Human Resources | 12 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 2 | CF004 | Stock Prices | 8 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 3 | P2RB_PK | Pension Fund, Payroll Belgium | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 4 | P2RC_PK | HR-CH: Pension fund payroll values | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 5 | P2RN_PK | Payroll Result: Pension Module | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 6 | P2UN_PK | Pension Fund, Payroll United Nations | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 7 | T5C1E | Transaction Types | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 8 | T5PPBS3V | Check values for PD infotype fields | 2 | VALTY | Value type | nvarchar | 2 | 0 | | |
| 9 | T5PPBS3VT | Text of values for PD infotype fields | 3 | VALTY | Value type | nvarchar | 2 | 0 | | |
| TOPData Collection |
| 10 | CF001 | Profitability Analysis | 15 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 11 | CF003 | Projects | 15 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 12 | CF005 | Personnel Information | 13 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 13 | CF006 | Balance Sheet | 10 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 14 | CF050 | Balance sheet/P&L (FI/FILC) | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 15 | CF500 | IDES Investment | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 16 | CF701 | IDES Marketing | 13 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 17 | CF703 | IDES Profitability | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 18 | CF704 | IDES Sales Info Sys. | 12 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 19 | CF705 | IDES Personnel Info | 14 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 20 | CF706 | IDES Legal Cons. | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 21 | CF707 | IDES Insight | 11 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 22 | CF708 | IDES: Setup Example | 10 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 23 | CF720 | Top EIS Aspect | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 24 | CF750 | MCRED | 9 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 25 | CF751 | MCBLUE | 9 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 26 | CF752 | MCBlack | 10 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 27 | T241W | Description of value type | 3 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 28 | T242W | Value types | 2 | VALTY | Value type | nvarchar | 1 | 0 | | |
| 29 | TKCUM | EIS: Conversion table of new fixed fields 4.0 | 3 | VALTY | Value type | nvarchar | 1 | 0 | | |
| TOPFunds Management |
| 30 | FMLGD_H_CUST | Note to Payee Control | 7 | VALTY | Processing variant | nvarchar | 4 | 0 | | |
| 31 | FMLGD_H_VALTYP | Processing variant | 2 | VALTY | Processing variant | nvarchar | 4 | 0 | | |
| 32 | FMLGD_H_VALTYPT | Text Table for FMLGD_H_VALTYP | 2 | VALTY | Processing variant | nvarchar | 4 | 0 | | |
| TOPGlobal Trade Services |
| 33 | /SAPSLL/LEGCULC | SLL: Customs Document: Customs Processing: Duties | 8 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
| 34 | /SAPSLL/LEGCULCR | Customs Document (Backup): Customs Processing: Duties | 6 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
| 35 | /SAPSLL/PRVAL | Legal and Logistics Services: Product Master - Prices | 5 | VALTY | Valuation Type | nvarchar | 10 | 0 | | |
| 36 | /SAPSLL/SECADJWL | Worklist for Automatic Adjustment of Securities | 10 | VALTY | Value Type | nvarchar | 2 | 0 | | |
| 37 | /SAPSLL/TLC_ASC | GTS: Customs Management: Toll Procedure | 5 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
| 38 | /SAPSLL/TLC_ASE | GTS: Customs Processing: Duty Structure for Exports | 5 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
| 39 | /SAPSLL/TLC_AST | GTS: Customs Processing: Duty Structure for Proc. Transit. | 5 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
| TOPHR Information Systems |
| 40 | T72B1_BW | HR-PF-BW: Permitted Value Type per PC Activities for BW | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| TOPPension fund General Parts |
| 41 | T5CA2 | PC Value Types | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 42 | T5CA3 | HR-CH: Value type descriptions | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 43 | T5CA8 | PC Method Determination | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 44 | T5CA9 | PC Method Variant Determination | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 45 | T5CAC | Parameter Range Determination | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 46 | T5CAD | PC Parameter Values | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 47 | T5CAG | PC Method Definitions | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 48 | T5CAH | Schedule Value Types | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 49 | T5CAO | Line Selection of Processing Schedules | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 50 | T5CAV | Value Type Attribute Assignment | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 51 | T5CB3 | PC Parameter Attributes | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 52 | T5CBE | Value Type Field Assignment | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 53 | T5CBO | Additional Selection Parameters for Reports | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 54 | T5CBU | Field Selection for PC Online Evaluation View | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 55 | T5CC0 | PC Method Steps Add-Ons | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 56 | T5CC4 | HR-PF: Value Type Grouping | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 57 | T5CP3 | HR-CH: Field assignment for infotype 279 | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 58 | T5CP4 | HR-CH: Value assignment for fields (BI) | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 59 | T5CPA | HR-CH: Determination of Wage Types for PF Value Types | 2 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 60 | T5CPB | HR-CH: Pension fund postings | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 61 | T5CPQ | Input Parameter Quantity Value Types for PF Calulation | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 62 | T5CPS | Additional Infotype Field Values for PF Calculation | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 63 | T5CPW | Ad Hoc Query Field Assignment | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 64 | T5CQ1 | Account View Posting Value Types | 4 | VALTY | Account View Posting Value Type | nvarchar | 4 | 0 | | |
| 65 | T5CQ3 | Account View Result Value Types | 5 | VALTY | Result value type | nvarchar | 4 | 0 | | |
| 66 | T5NF3 | PA-PF-NL: Feldzuordnung für Infotyp 279 | 6 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
| 67 | T5NP3 | HR-Gran: Mapping table VALTY - LGART for Simulation | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 68 | T72A2 | HR-PF: Totals Value Types | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 69 | T72A6 | HR-IB: Parameters for a PF recalculation | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 70 | T72A9 | HR-PF: Total Compensation Statement Integration | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 71 | T72AD | Value types of a variant for the Wage Maintenance Debugger | 3 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 72 | T72F0 | HR-PF: FI Posting Characteristics of Value Types | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 73 | T72FA | HR-PF: FI Index Table | 10 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 74 | T72P0 | HR-PF: Determination of Payroll Values for PF Value Types | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 75 | T72T5 | HR-PF: TS Account Data | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 76 | T72T6 | HR-PF: TS Account Data Totals Formation | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 77 | T72TB | HR-PF: TS Parameter Values | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| TOPPension fund Netherlands |
| 78 | T5NBG | Berekeningsmethode (FAS/ALM interface) | 6 | VALTY | VS-waardesoort | nvarchar | 4 | 0 | | |
| 79 | T5ND1 | HR-CH: Pension fund postings | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 80 | T5NDA | Log tabel voor euroconversie van IT0279 waardecomponenten | 3 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
| 81 | T5NDB | Log tabel voor euroconversie van tabel T5CPB | 6 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
| 82 | T5NE1 | Groepsdefinitie (VK-rapport) | 6 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
| 83 | T5NE6 | Berekeningsmethode (VK-rapport) | 11 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
| 84 | T5NK2 | Pensioen producten - VB-Waardesoorten | 3 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
| 85 | T5NL3 | Toewijzing VB-waardesoort aan actuarieel bestandstype kolom | 4 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
| TOPPension Fund Switzerland |
| 86 | PA3230 | Personnel Master Record for Infotype 3230 | 29 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
| 87 | T5CD3 | House Bank Pension Fund for Non-Recurring Payments | 3 | VALTY | Value Type of DME Posting | nvarchar | 4 | 0 | | |
| TOPSwitzerland |
| 88 | T5CEL | HR-CH: Values from Infotype 0279 for Master Data Sheet | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
