| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PYD_D_CLSPAS | Payroll Data Source Class Parameter Activation Status | 3 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
2 | PYD_D_CLSPASH | Payroll Data Source Class Parameter Act. Status History | 3 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
3 | PYD_D_DAE_EREGP | PYDS: Scheduling Event Registry Parameter | 4 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
4 | PYD_D_DAE_ETP | PYDS: Scheduling Use Case Event Type Parameter Type | 3 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
5 | PYD_D_DAE_REGP | PYDS: Scheduling Use Case Registry Parameter | 5 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
6 | PYD_D_DAE_UCDP | PYDS: Scheduling Use Case Definition Parameter Types | 3 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
7 | PYD_D_INSTP | Payroll Data Source Instance Input Parameter | 4 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
8 | PYD_D_PT | Payroll Data Source Parameter Type | 2 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
9 | PYD_D_PTFLT | Payroll Data Source Par. Type - Allowed Pa.Types as filter | 2 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
10 | PYD_D_PTRDT | Payroll Data Source Par. Type Result Detail Type Asgmt. | 2 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
11 | PYD_D_PTT | Payroll Data Source Parameter Type Text | 3 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
12 | PYD_D_PTUICA | Payroll Data Source Parameter Type UI Cat. Attr. Asgmt. | 2 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
13 | PYD_D_RESO | Payroll Data Source Result Object | 4 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
14 | PYD_D_RESOH | Payroll Data Source Result Object History | 4 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
15 | PYD_D_RESOS | Payroll Data Source Result Object Shadow | 5 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
16 | PYD_D_RESP | Payroll Data Source Result Input Parameter | 5 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
17 | PYD_D_SHI | Payroll Data Source Shadow Item | 6 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
18 | PYD_D_TYPTI | Payroll Data Source Type Input Parameter Type Assignment | 3 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
19 | PYD_D_TYPTR | Payroll Data Source Type Result Parameter Type Assignment | 3 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
20 | PYD_D_TYPTRRDT | Payroll Data Source Type Par. Ty. Result Details Type Asgmt. | 3 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
21 | PYD_D_TYPTRSCR | Payroll Data Source Result Object Error Status Change Reason | 3 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
22 | PYD_D_TYPTRSCRT | Payroll Data Source Result Object Status Change Reason Text | 4 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
23 | PYD_D_UVD | Payroll Data Source Framework: User Variant Details | 5 | PAR_TYPE | Payroll Data Source Parameter Type | nvarchar | 30 | 0 | | |
TOPAccounting - General |
24 | TFC_INST_PARAMS | Parameter Values of a Remote Task in Task List | 10 | PAR_TYPE | Type of Parameter | nvarchar | 1 | 0 | | |
25 | TFC_TEMPL_PARAMS | Parameter Values of a Remote Task | 10 | PAR_TYPE | Type of Parameter | nvarchar | 1 | 0 | | |
TOPPension fund Netherlands |
26 | T5NL4 | Parameter restricties TC & AF | 3 | PAR_TYPE | Parameter type | nvarchar | 10 | 0 | | |