| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7RUREGION | KLADR: Regions (Provinces) | 4 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
TOPAddress ManagementBusiness Address |
2 | T005S | Taxes: Region (Province) Key | 4 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
TOPBank |
3 | T005P | Validation of tax keys | 4 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
TOPBasic Functions |
4 | T059REXT | Reporting key (new withholding tax) | 5 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
5 | T059Z | Withholding tax code (enhanced functions) | 11 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
6 | T059Q | Withholding Tax | 15 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
7 | T059R | Recipient Code | 4 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
TOPInformation System |
8 | QSTRE | FI/HR Withholding Tax Report for Spain | 7 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
TOPPersonnel Administration |
9 | PA0837 | HR master record for infotypes 0837 | 24 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
10 | PA0838 | HR master record for infotypes 0838 | 25 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
11 | PB0837 | Candidates data for infotype 0837 (sample) | 24 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |
12 | PB0838 | Candidates data for infotype 0838 (sample) | 25 | FPRCD | Provincial tax code | nvarchar | 3 | 0 | | |