| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /CPD/AVR_PRG_DAT | Buffer Table for Progress Analysis Data | 4 | CYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 2 | /CPD/AVR_PR_DAT | Buffer Table for Progress Analysis Data | 5 | CYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 3 | J_1GMYF0_M | MYF data | 2 | CYEAR | Calendar Year | nvarchar | 4 | 0 | | |
| 4 | J_1GWTR0 | Vendor Tax Data | 2 | CYEAR | Calendar Year | nvarchar | 4 | 0 | | |
| 5 | P2MX_GRORD | Maintenance payment order | 18 | CYEAR | Calendar year for garnishment payroll | nvarchar | 4 | 0 | | |
| 6 | P2RK_GRORD | Payroll results Canada: Garnishment order | 19 | CYEAR | Calendar year for garnishment payroll | nvarchar | 4 | 0 | | |
| 7 | P2VE_ABS_EVAL | HRMS-VE: Wage Management for Valuation of Vacations | 5 | CYEAR | Holiday and factory calendar function module year | nvarchar | 4 | 0 | | |
| 8 | PAPBSGB_SWF_ABS | SWF: Absences | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 9 | PAPBSGB_SWF_ATP | SWF : Agency TP | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 10 | PAPBSGB_SWF_CONT | SWF: Contract Details | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 11 | PAPBSGB_SWF_CTRL | SWF : Control | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 12 | PAPBSGB_SWF_CUR2 | SWF: Curriculum | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 13 | PAPBSGB_SWF_CURR | SWF: Curriculum | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 14 | PAPBSGB_SWF_EP | SWF: Educational Psychologists | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 15 | PAPBSGB_SWF_INFO | SWF: Staff Information | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 16 | PAPBSGB_SWF_PAY | SWF: Additional Payments | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 17 | PAPBSGB_SWF_QUAL | SWF: Qualifications | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 18 | PAPBSGB_SWF_QUL2 | SWF: Qualifications | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 19 | PAPBSGB_SWF_STAF | SWF: Staff Details | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 20 | PAPBSGB_SWF_VACA | SWF: Vacancies | 2 | CYEAR | SWF: Census Year | nvarchar | 4 | 0 | | |
| 21 | T7PLPIT | PIT document - form | 3 | CYEAR | Calendar year | nvarchar | 4 | 0 | | |
| TOPBasic Functions |
| 22 | T874 | Elimination of hidden reserves | 11 | CYEAR | Fiscal year | nvarchar | 4 | 0 | | |
| 23 | T875C | Changes in depreciation | 9 | CYEAR | Fiscal year | nvarchar | 4 | 0 | | |
| TOPBenefit Integration |
| 24 | T7USBENPE | US pension related data (e.g. Soc. Sec. wages and taxes) | 5 | CYEAR | Cumulation Interval Year | nvarchar | 4 | 0 | | |
| TOPChina |
| 25 | T7CN13 | Salary information (CN) | 5 | CYEAR | Calendar year for all kinds of salary | nvarchar | 4 | 0 | | |
| TOPConsolidation |
| 26 | TF635 | Goodwill/Neg.Goodwill | 8 | CYEAR | Fiscal year | nvarchar | 4 | 0 | | |
| 27 | TF635A | Goodwill/Neg.Goodwill | 7 | CYEAR | Fiscal year | nvarchar | 4 | 0 | | |
| 28 | TF646 | Recorded Fair Value Adjustments | 7 | CYEAR | Fiscal year | nvarchar | 4 | 0 | | |
| TOPFinancial Accounting |
| 29 | J_1GMYF0 | MYF data | 2 | CYEAR | Calendar Year | nvarchar | 4 | 0 | | |
| 30 | J_1GWTC0 | Withholding tax certificates data | 2 | CYEAR | Calendar Year | nvarchar | 4 | 0 | | |
| TOPGeneral Parts |
| 31 | T74_FBN11 | Buying/Selling Holiday Factor | 3 | CYEAR | Calendar year | nvarchar | 4 | 0 | | |
| TOPPersonnel Administration |
| 32 | PA0658 | HR Master Record: Infotype 0658 | 24 | CYEAR | Calendar year | nvarchar | 4 | 0 | | |
| TOPPersonnel Time Management |
| 33 | T554A | Breakdown of Absences After Quota Deduction | 12 | CYEAR | Calendar year | nvarchar | 4 | 0 | | |
| 34 | T556W | Wage Type Assignment for Att./Absence Quota Compensations | 13 | CYEAR | Calendar year | nvarchar | 4 | 0 | | |
| TOPVenezuela |
| 35 | T7VEA1 | Transfer of External Payroll Results: Vacations | 5 | CYEAR | Holiday and factory calendar function module year | nvarchar | 4 | 0 | | |
