| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBSI |
1 | BTXAUTH | BSI Tax Authorities | 7 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
2 | BTXCOMP | BSI: Tax Company Code | 4 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
3 | BTXCOMP_O | BSI: Tax Company Code | 3 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
4 | BTXCUTX | BSI: Customer Tax Formula | 14 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
5 | BTXCUTX_O | BSI: Customer Tax Formula | 13 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
6 | BTXEGRP | BSI: Employee Group | 4 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
7 | BTXEGRP_O | BSI: Employee Group | 3 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
8 | BTXOVER | BSI: Higher Level Tax Formula | 11 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
9 | BTXOVER_O | BSI: Higher Level Tax Formula | 10 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
10 | BTXPLAN | BSI: Benefit plan types | 3 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
11 | BTXPLNX | BSI: Benefit Plan | 9 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
12 | BTXPURGE | BSI: Purge Retention Periods | 2 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
13 | BTXRATE | BSI: Tax Rates per Company Based on Degree of Experience | 13 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
14 | BTXRATE_O | BSI: Tax Rates per Company Based on Degree of Experience | 12 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
15 | BTXTAX | BSI: Grouping Tax Authority Tax Category | 13 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
16 | BTXTAXC | Tax Authority Mapping | 6 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
17 | BTXTAXT | BSI: Tax Category | 3 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
TOPUSA |
18 | BRCDTA | BSI-TAX 4.0 BRCDTA | 30 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
19 | BRCGDTA | BSI-TAX 4.0 BRCGDTA | 30 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
20 | BRCGEN | BSI-TAX 4.0 BRCGEN | 9 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
21 | BRCRCP | BSI-TAX 4.0 BRCRCP | 11 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
22 | BTXEMPT | BSI: Employee tax results | 18 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
23 | BTXPURG | BSI: Purge Periods in Months | 2 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
24 | BTXSUPB | BSI: Upgrade-Information | 2 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |
25 | BTXTINF | BSI: Test information | 4 | MAINTDATE | BSI: Last changed on | nvarchar | 8 | 0 | | |