| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T536A | Addresses | 4 | SEQNU | Text Identification | nvarchar | 1 | 0 | | |
2 | T5A4 | Process Control for Continued Pay | 3 | SEQNU | Sequence Number | nvarchar | 2 | 0 | | |
3 | T5A4G | Use of Absence Categories | 6 | SEQNU | Sequence Number | nvarchar | 2 | 0 | | |
4 | T7RUWCS | Working Conditions Environment | 5 | SEQNU | Sequence number | nvarchar | 2 | 0 | | |
5 | T7RUWCST | Working Conditions Environment | 6 | SEQNU | Sequence number | nvarchar | 2 | 0 | | |
6 | T7RU_T559_WCS | Absence Quotas for Working Conditions Environment | 4 | SEQNU | Number of Record with Same Key | nvarchar | 3 | 0 | | |
TOPPayroll |
7 | T7RO30 | ZIP Codes | 4 | SEQNU | Sequence Number | nvarchar | 2 | 0 | | |
8 | T7ROCF | Configuration Table for RO Payroll | 3 | SEQNU | Sequence Number | nvarchar | 2 | 0 | | |
TOPPayroll General Parts |
9 | T53G7 | Characteristics of the basis model | 5 | SEQNU | Sequential number | nvarchar | 3 | 0 | | |
10 | T53GA | Characteristics Model for the gross amount | 4 | SEQNU | Sequential number | nvarchar | 3 | 0 | | |
11 | T53GD | Characteristics Model for the net amount | 4 | SEQNU | Sequential number | nvarchar | 3 | 0 | | |
12 | T53GM | Non Exempt: Characteristics Level Systems | 4 | SEQNU | Sequential number | nvarchar | 3 | 0 | | |
13 | T53GX2 | Characteristics Basis Model Rounding | 4 | SEQNU | Sequential number | nvarchar | 3 | 0 | | |
TOPSpain |
14 | T5E04 | Registered company and work center names | 4 | SEQNU | Sequential number | nvarchar | 1 | 0 | | |
15 | T5E30 | Adjust Social Insurance reasons and actions | 4 | SEQNU | RED system: Sequential number of an action | nvarchar | 1 | 0 | | |
16 | T5E61 | Contract transformations allowed | 9 | SEQNU | Contracts: Contract sequence number | nvarchar | 1 | 0 | | |
17 | T5E65 | Work schedule in part-time contracts according Soc. Ins. Ad. | 3 | SEQNU | Contracts: Contract working day sequential number | nvarchar | 1 | 0 | | |
18 | T5E67 | Special contracts according to Social Insurance | 3 | SEQNU | Contracts: Requirement sequence number | nvarchar | 1 | 0 | | |
19 | T5EA5 | Calculation sequences by payment method | 3 | SEQNU | Sequential number | nvarchar | 1 | 0 | | |