| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | PIQDB_DE_STATHDR | Header Table for Statistical Reporting Germany | 5 | RUNTYPE | Run Type (Generation/Completion/Delta) | nvarchar | 1 | 0 | | |
| TOPAccrual Engine |
| 2 | ACEPSPPLOG | Logical Periodic Accrual Run | 9 | RUNTYPE | Run Type of Periodic Accrual Program | nvarchar | 1 | 0 | | |
| TOPData Transfer |
| 3 | T52E2 | Posting to Accounting: Posting Variants | 16 | RUNTYPE | Run Type | nvarchar | 2 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 4 | CACS_STMRNJO | Calculation and Settlement Log | 7 | RUNTYPE | Run Category for Closing and Settlement | nvarchar | 2 | 0 | | |
| 5 | CACS_TGTRNJO | Obsolete (Target Agreements: Log for Mass Run) | 4 | RUNTYPE | Run Category for Closing and Settlement | nvarchar | 2 | 0 | | |
| TOPInterestCharge Calculation |
| 6 | TBKKM_TS | Control for Time Stamp Synchronization | 3 | RUNTYPE | Type of Process | nvarchar | 1 | 0 | | |
| TOPPosition Budgeting and Control |
| 7 | HRFPM_RUNADMINS | HRFPM: Administration Information for Commitment Runs | 9 | RUNTYPE | Origin of Commitment Run | nvarchar | 1 | 0 | | |
