SAP table BTXEMPT (BSI: Employee tax results)
SAP table BTXEMPT has 2 primary key fields being EMPLOYEE,CHECKDATE.
| Field |
Description |
Data Type |
Length |
Decimals |
Checktable |
Data Element |
|
| EMPLOYEE |
BSI: Employee |
CHAR |
11 |
0 |
|
PB10_EMP
|
|
| CHECKDATE |
BSI: Check Date |
DATS |
8 |
0 |
|
PB10_CDATE
|
|
| EMPNAME |
BSI Canada: Employee name |
CHAR |
30 |
0 |
|
PB10_EMPNA
|
|
| COMPANY |
BSI: Tax Company Code |
CHAR |
11 |
0 |
BTXCOMP
|
COMPANY
|
|
| GROUPCODE |
BSI Canada: Group code |
CHAR |
11 |
0 |
|
PB10_GCODE
|
|
| PAYTYPE |
BSI: Payment type |
NUMC |
1 |
0 |
|
PB10_PTYPE
|
| 0 |
Regular |
| 1 |
Supplemental |
| 2 |
Cumulative |
| 3 |
Vacation |
|
| PAYFREQ |
BSI: Pay frequency |
NUMC |
3 |
0 |
|
PB10_PFREQ
|
|
| YTDPAYPER |
BSI: Year to date pay periods |
NUMC |
3 |
0 |
|
PB10_YTDPP
|
|
| VACATION |
BSI: Leave payment |
DEC |
5 |
2 |
|
PB10_VAC
|
|
| STDHOURS |
BSI: Standard hours |
DEC |
5 |
2 |
|
PB10_STDHR
|
|
| COTERM |
BSI: Coterminous |
NUMC |
1 |
0 |
|
COTERM
|
|
| NETWAGES |
BSI: Net wages |
DEC |
9 |
2 |
|
PB10_NETWG
|
|
| ESTGROSS |
BSI: Estimated gross |
DEC |
9 |
2 |
|
PB10_ESTGR
|
|
| ESTSPOUSAL |
BSI: Estimated gross - spouse |
DEC |
9 |
2 |
|
PB10_ESTSP
|
|
| GROSSUP |
BSI: Gross up indicator |
NUMC |
1 |
0 |
|
PB10_GRSUP
|
|
| RECIPROCAL |
BSI: Reciprocity indicator |
NUMC |
1 |
0 |
|
PB10_RECIP
|
|
| GROSSWAGES |
BSI: Total gross |
DEC |
9 |
2 |
|
PB10_GROSS
|
|
| MAINTDATE |
BSI: Last changed on |
DATS |
8 |
0 |
|
MAINTDATE
|
|
| MAINTTIME |
BSI: Last changed at |
TIMS |
6 |
0 |
|
MAINTTIME
|
|
BTXEMPT foreign key relationships
| Table |
Field |
Check Table |
|
Check Field |
| 0 BTXEMPT |
COMPANY |
BTXCOMP |
BSI: Tax Company Code |
MANDT |
| 0 BTXEMPT |
COMPANY |
BTXCOMP |
BSI: Tax Company Code |
COMPANY |