| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SLOAP/PROFILE | version independent profile information | 3 | CONTR | User Name | nvarchar | 12 | 0 | | |
2 | /SLOAP/PRTMPCONT | version dependant profile control table | 3 | CONTR | User Name | nvarchar | 12 | 0 | | |
3 | P2RQ_QSPR | HR-AU-PS: Payroll structure for Superannuation | 22 | CONTR | Contributor status | nvarchar | 2 | 0 | | |
4 | P2RQ_SUPCOM | Superable salary components | 15 | CONTR | Contributor status | nvarchar | 2 | 0 | | |
5 | P2RR_ST | Payroll Results: Tax (Singapore) | 12 | CONTR | Contractual | nvarchar | 1 | 0 | | |
6 | P2UN_QSPR | HR-UN: Payroll structure for Superannuation | 22 | CONTR | Contributor status | nvarchar | 2 | 0 | | |
7 | P2UN_SUPCOM | Superable salary components For NPO | 15 | CONTR | Contributor status | nvarchar | 2 | 0 | | |
8 | PA3331 | HR Master Record: Infotype 3331 | 47 | CONTR | Contract number | nvarchar | 20 | 0 | | |
TOPClinical System |
9 | N1BDCC | IS-H*MED: External Drug Basic Catalog Entries | 12 | CONTR | Medication: Controlled Drug Indicator | nvarchar | 1 | 0 | | |
10 | N1FORMULARY | Medication: Drug Formulary | 38 | CONTR | Medication: Controlled Drug Indicator | nvarchar | 1 | 0 | | |
TOPData Collection |
11 | CF707 | IDES Insight | 8 | CONTR | Land | nvarchar | 2 | 0 | | |
12 | T2716 | Master data table: Land | 2 | CONTR | Land | nvarchar | 2 | 0 | | |
13 | T2816 | Master data texts: Land | 3 | CONTR | Land | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
14 | AVIP | Payment Advice Line Item | 54 | CONTR | Payment Advice Processing Control Field | nvarchar | 6 | 0 | | |
TOPFrance |
15 | T5F42 | Work Contract | 2 | CONTR | Identification of work contract type | nvarchar | 2 | 0 | | |
TOPItaly |
16 | PA0154 | HR master record, infotype 0154 (social security data) | 98 | CONTR | INPS Pay Scale Indicator 3 | nvarchar | 1 | 0 | | |
17 | T5ITNG | 01/M data table - section B | 15 | CONTR | INPS Pay Scale Indicator 3 | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
18 | PA0413 | HR Master Record: Infotype 0413 | 26 | CONTR | Free amount rule | nvarchar | 2 | 0 | | |
19 | T7PL30 | Free amount rules | 1 | CONTR | Free amount rule | nvarchar | 2 | 0 | | |
20 | T7PL31 | Free amount rule definitions | 1 | CONTR | Free amount rule | nvarchar | 2 | 0 | | |
21 | T7PL3T | Free amount rule texts | 2 | CONTR | Free amount rule | nvarchar | 2 | 0 | | |
TOPPublic Sector |
22 | PA0507 | HR-AU-PS: Master Data (Superannuation) | 24 | CONTR | Contributor status | nvarchar | 2 | 0 | | |
23 | T5QPBS1C | Superannuation contributor status | 2 | CONTR | Contributor status | nvarchar | 2 | 0 | | |
24 | T5QPBS1CT | Text for Contributor status | 3 | CONTR | Contributor status | nvarchar | 2 | 0 | | |
TOPSingapore |
25 | PA0179 | HR Master Record: Infotype 0179 (Tax SG) | 31 | CONTR | Contractual | nvarchar | 1 | 0 | | |
TOPWarranty Claim Processing |
26 | PVWTY | Warranty Claim Item (PPE Variant) | 10 | CONTR | Contribution | decimal | 11 | 2 | | |