| 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 | | |