| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 11 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
2 | PA9220 | HR Master Record: Infotype 9220 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
3 | PA9390 | Personal-Stammsatz Infotyp 9390 | 24 | PY_SEQNR | Sequenznummer | nvarchar | 5 | 0 | | |
4 | PA9429 | Registro maestro de personal Infotipo 9429 | 24 | PY_SEQNR | Nº de secuencia | nvarchar | 5 | 0 | | |
5 | PA9640 | Personal-Stammsatz Infotyp 9640 | 24 | PY_SEQNR | Sequenznummer | nvarchar | 5 | 0 | | |
6 | PA9701 | Personal-Stammsatz Infotyp 9701 | 24 | PY_SEQNR | Sequenznummer | nvarchar | 5 | 0 | | |
7 | PA9725 | HR Master Record: Infotype 9725 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
8 | PA9741 | HR Master Record: Infotype 9741 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
9 | PA9742 | HR Master Record: Infotype 9742 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
10 | PA9825 | HR Master Record: Infotype 9825 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
11 | PA9990 | HR Master Record: Infotype 9990 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
12 | PA9991 | HR Master Record: Infotype 9991 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
13 | PA9992 | HR Master Record: Infotype 9992 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
14 | PA9993 | HR Master Record: Infotype 9993 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
15 | PA9995 | HR Master Record: Infotype 9995 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
16 | PA9996 | HR Master Record: Infotype 9996 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
17 | PA9997 | HR Master Record: Infotype 9997 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
18 | PA9998 | HR Master Record: Infotype 9998 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
TOPBenefit Integration |
19 | PA0496 | Payroll Infotype: US Benefits Data - Per Pay Period | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
20 | PA0497 | Payroll Infotype: US Benefits Data - MTD | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
21 | PA0498 | Payroll Infotype: US Benefits Data - QTD | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
22 | PA0499 | Payroll Infotype: US Benefits Data - YTD | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
23 | PA0500 | Payroll Infotype: US Benefits Data in Arrears (ARRRS) | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
24 | PA0501 | Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK) | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
TOPJapan |
25 | PA3239 | HR Master Record: Infotype 3239 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
TOPPersonnel Administration |
26 | PA0402 | HR Master Data Infotype 0402 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
27 | PA0403 | HR Master Record for Infotype 0403 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
TOPUSA |
28 | PA0446 | | 24 | PY_SEQNR | | nvarchar | 5 | 0 | | |
29 | PA0447 | US Federal Tax MTD | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
30 | PA0448 | US Federal Tax QTD | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
31 | PA0449 | HR Master Record: Infotype 0449 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
32 | PA0450 | HR Master Record: Infotype 0450 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
33 | PA0451 | HR Master Record: Infotype 0451 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
34 | PA0452 | HR Master Record: Infotype 0452 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
35 | PA0453 | HR Master Record: Infotype 0453 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
36 | PA0454 | HR Master Record: Infotype 0454 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
37 | PA0455 | HR Master Record: Infotype 0455 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
38 | PA0456 | HR Master Record: Infotype 0456 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
39 | PA0457 | HR Master Record: Infotype 0457 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
40 | PA0458 | HR Master Record for Infotype 0458 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
41 | PA0459 | HR Master Record for Infotype 0459 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |
42 | PA0460 | HR Master Record for Infotype 0460 | 24 | PY_SEQNR | Sequence Number | nvarchar | 5 | 0 | | |