| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRPC_UPG_HRP1000 | Upgrade Back Up Data | 19 | GDATE | Delimitation date | nvarchar | 8 | 0 | | |
2 | P01E2_MELD_ST | ELStAM: Status of Notifications for the Administrator | 6 | GDATE | ELStAM: Date of Creation/Change | nvarchar | 8 | 0 | | |
3 | P01RBM_TRIN | ZfA: Manage PI Receipt of Notification | 8 | GDATE | Pension Receipt Notification: Date of Status Change | nvarchar | 8 | 0 | | |
4 | P01ZFA_TRIN | ZfA: Manage PI Receipt of Notification | 8 | GDATE | ZfA: Creation/Change Date | nvarchar | 8 | 0 | | |
5 | P05TPRNL_PR_OUT | Pension Return: PR - Output Data | 12 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
6 | P05T_WCR_SIMU | WCR Simulation | 40 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
7 | P2B2_QTACC | HCM Declustering B2 - Generating Absence Quotas | 7 | GDATE | Date Generated | nvarchar | 8 | 0 | | |
8 | P2B2_QTTRANS | HCM Declustering B2 - Transfer Pool for Quota Deduction | 7 | GDATE | Date Generated | nvarchar | 8 | 0 | | |
9 | P2RX_VERSC | Payroll Status Information | 9 | GDATE | Retro.acct.for gross part as of | nvarchar | 8 | 0 | | |
10 | T021D | Line Layout Fast Entry: Administration | 6 | GDATE | Fast Entry: Date of Saving | nvarchar | 8 | 0 | | |
11 | TBVZ | CO-PA report library (no longer used) | 7 | GDATE | Date created | nvarchar | 8 | 0 | | |
12 | TGTB | Control table for table converter | 12 | GDATE | Date | nvarchar | 8 | 0 | | |
13 | ZRP1000 | Infotype 1000 DB Table | 19 | GDATE | Delimitation date | nvarchar | 8 | 0 | | |
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD |
14 | DDPART | DD: Partitioned form of TBATG | 9 | GDATE | Date | nvarchar | 8 | 0 | | |
15 | TBATG | Control table for batch table conversion | 8 | GDATE | Date | nvarchar | 8 | 0 | | |
TOPB2A Business to Administration |
16 | PB2ASTAT | HR-B2A: Status Management | 7 | GDATE | Creation/Change Date of Data Record | nvarchar | 8 | 0 | | |
17 | PC01B2A_SVEMSTAT | SI-Specific Storage E-Mails for Procedure for Returning Data | 7 | GDATE | Date | nvarchar | 8 | 0 | | |
TOPCompany Pension Scheme Germany |
18 | P01RBM_HIST | Notification Status: Pension Receipt Notifications | 5 | GDATE | Pension Receipt Notification: Date of Status Change | nvarchar | 8 | 0 | | |
19 | P01RBM_STAT | Notification Status: Pension Receipt Notifications | 11 | GDATE | Pension Receipt Notification: Date of Status Change | nvarchar | 8 | 0 | | |
20 | P01RBM_STAT_R | Status of Confirmations (Pension Receipt Notifications) | 11 | GDATE | Pension Receipt Notification: Date of Status Change | nvarchar | 8 | 0 | | |
21 | P01RBM_TRANS | RBM: Status Table for Transfer | 6 | GDATE | Pension Receipt Notification: Date of Status Change | nvarchar | 8 | 0 | | |
22 | P01VA_STAT | PEP: Status of Pension Equalization Payment | 6 | GDATE | PEP: Date of Status Change | nvarchar | 8 | 0 | | |
TOPConstruction Industry |
23 | PDBKBESUM | Constr. Ind. Social Fund Procedure: BEMEL Records (Total) | 40 | GDATE | Local Date | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
24 | TFK021D | Screen variants: Administration | 6 | GDATE | Screen variants: Date saved | nvarchar | 8 | 0 | | |
25 | TFK021K | Subscreen Management (SAP) | 9 | GDATE | Fast Entry: Date of Saving | nvarchar | 8 | 0 | | |
26 | TFK021KC | Detail Screen Structure for Document Display (Customer) | 8 | GDATE | Fast Entry: Date of Saving | nvarchar | 8 | 0 | | |
TOPGermany |
27 | T5D4T | HIF Receiving Office for the E-Mail Procedure | 6 | GDATE | Company Number Valid Until | nvarchar | 8 | 0 | | |
28 | T5D4U | File Numbers for E-Mail Procedure with Health Ins. Funds | 8 | GDATE | Date | nvarchar | 8 | 0 | | |
TOPLocalization |
29 | J_3RSEXTRACTD | Exctract details (obsolete) | 18 | GDATE | Cargo customs declaration date | nvarchar | 8 | 0 | | |
TOPOrganizational Management |
30 | HRP1000 | Infotype 1000 DB Table | 19 | GDATE | Delimitation date | nvarchar | 8 | 0 | | |
TOPProfile Maintenance |
31 | TPFHS | Prototype: Profile header, administration data for profiles | 10 | GDATE | Data part last profile generation | nvarchar | 8 | 0 | | |
32 | TPFHT | Profile header, administration data for profiles in DB | 10 | GDATE | Data part last profile generation | nvarchar | 8 | 0 | | |
TOPProfitability Analysis |
33 | T239 | Report version table | 4 | GDATE | Date created | nvarchar | 8 | 0 | | |
34 | TKEB1 | Report Management | 11 | GDATE | Created On | nvarchar | 8 | 0 | | |
35 | TKES1 | Row/column structures | 11 | GDATE | Date created | nvarchar | 8 | 0 | | |
TOPPublic Sector |
36 | P01ZFA_NN_STATUS | ZfA: Status Management for ZKNN Notifications | 6 | GDATE | ZfA: Creation/Change Date | nvarchar | 8 | 0 | | |
37 | P01ZFA_STATUS | ZfA: Status Management for Notifications | 7 | GDATE | ZfA: Creation/Change Date | nvarchar | 8 | 0 | | |
38 | P01ZFA_TRANS | ZfA: Status Table for Transfer | 6 | GDATE | ZfA: Creation/Change Date | nvarchar | 8 | 0 | | |
TOPReporting |
39 | P05TPRNL_EE_ADMS | Pension Return: Admin of Status Income Relationship - Pers L | 15 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
40 | P05TPRNL_LP_ADMS | Pension Return: Administration of Status - Legal Pers Level | 13 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
41 | P05T_AE_ADM_STAT | Wage Return: Administrative Unit - Status Table | 11 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
42 | P05T_A_EXT | Wage Return: Collective Employer Data - Wage Return | 10 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
43 | P05T_CVZ_UITW | CVZ: Tabel voor uitwisselingsbestand | 8 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
44 | P05T_IV_ADM_STAT | Wage Return: Income Relationship - Status Table | 13 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
45 | P05T_JLO_STAT | Annual Wage Return status | 7 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
46 | P05T_RESPONSE | Wage Return: Table for Response Messages | 8 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
47 | P05T_WCR_ER_INFO | WCR Info on Employer Level | 18 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
48 | P05T_WCR_STAT | WCR Status Table | 11 | GDATE | Creation/Change Date | nvarchar | 8 | 0 | | |
TOPSales and Distribution |
49 | J_1USEXTRACTD | EXTRACTD | 18 | GDATE | | nvarchar | 8 | 0 | | |
TOPSets |
50 | T800S | FI-SL Set Table (before Release 4.0) | 24 | GDATE | Date on which object was last changed | nvarchar | 8 | 0 | | |
TOPSocial Insurance |
51 | P01SV_B2ATRNS | Status Table Transfer to Social Insurance Agency | 15 | GDATE | Employment Tax Statement: Created/Changed On | nvarchar | 8 | 0 | | |
TOPStatements |
52 | P01W_ADMIN_01 | HR: Data Module: Administration for Health Insurance Funds | 9 | GDATE | Creation/Change Date of Data Record | nvarchar | 8 | 0 | | |
TOPTax |
53 | P01E2_HIST | ELStAM Procedure: Table for Status History | 6 | GDATE | ELStAM: Date of Creation/Change | nvarchar | 8 | 0 | | |
54 | P01E2_LISTMTL_ST | ELStAM: Status Table for Monthly Change Lists | 13 | GDATE | ELStAM: Date of Creation/Change | nvarchar | 8 | 0 | | |
55 | P01E2_LIST_ST | Status Table for ELStAM Procedure Change Lists | 7 | GDATE | ELStAM: Date of Creation/Change | nvarchar | 8 | 0 | | |
56 | P01E2_STATUS | ELStAM Procedure: Status Table | 8 | GDATE | ELStAM: Date of Creation/Change | nvarchar | 8 | 0 | | |
57 | P01E2_TRANS_ST | Status Table Transfer for ELStAM Procedure | 9 | GDATE | ELStAM: Date of Creation/Change | nvarchar | 8 | 0 | | |
58 | P01T_ADMIN_STAT | ETStmt: Status Management Employment Tax Statements | 10 | GDATE | Employment Tax Statement: Created/Changed On | nvarchar | 8 | 0 | | |
59 | P01T_ADMST | ETStmt: Status Management - Employment Tax Statements (Old) | 10 | GDATE | Employment Tax Statement: Created/Changed On | nvarchar | 8 | 0 | | |
60 | P01T_A_ADS | ETNotif.: Status Administration/Employment Tax Notification | 11 | GDATE | Employment Tax Statement: Created/Changed On | nvarchar | 8 | 0 | | |
61 | P01T_A_EXT | ETNotif.: External Data | 10 | GDATE | Employment Tax Statement: Created/Changed On | nvarchar | 8 | 0 | | |
62 | P01T_TRANS | ETStmt: Administration/Processing Data Tickets | 6 | GDATE | Employment Tax Statement: Created/Changed On | nvarchar | 8 | 0 | | |
TOPUpgrade - General |
63 | TBATG_SAV | Steuertabelle für Tabellenumsetzung in Batch | 8 | GDATE | Datum | nvarchar | 8 | 0 | | |
64 | TBATG_SHD | Steuertabelle für Tabellenumsetzung in Batch | 8 | GDATE | Datum | nvarchar | 8 | 0 | | |
65 | TBATG_STD | Steuertabelle für Tabellenumsetzung in Batch | 8 | GDATE | Datum | nvarchar | 8 | 0 | | |
66 | UPGTBATG | Control Table for Creating Indexes in Advance | 8 | GDATE | Date | nvarchar | 8 | 0 | | |