BTXTTAX

BSI: Test Taxes | #masterdata | Component: USA
Column Name Description
EMPLOYEE BSI: Employee
CHECKDATE FK BSI: Check Date
COUNTRY BSI: Country indicator
INCOME BSI: Income category
TAXCODE FK BSI: Tax Code
TAXTYPE FK BSI: Tax type
FORMULA BSI: Tax formula
Column Name Description
Column Name Description
Column Name Description
CHECKDATE FK BSI: Check Date
Column Name Description
RESCODE BSI: Resident code Show values
EXEMPT Exempt Show values
RECIPROCAL BSI: Reciprocity indicator Show values
NONRESCER Certificate status Show values
SUPPCODE BSI: Supplemental Code Show values
ADDTAXCODE BSI: Additional Tax Code Show values
EICSTATUS EIC status Show values
SELFADJTX BSI: Indicator for self-adjusting tax Show values
STATUS BSI: Status Show values
Column Name Description Domain name
PPWAGES BSI Canada: Pay Period Wages BSI_WAGE
YTDWAGES BSI Canada: Year to date Wages BSI_WAGE
YTDTAX BSI Canada: Year to date tax BSI_WAGE
ROUNDING Number of positions to roundoff NUM01
MARITAL BSI: Marital status NUMC2
REXEMPT BSI: Remaining tax exemptions NUMC5
REXAMOUNT BSI: Remaining exempt amount BSI_WAGE
PEXEMPT BSI: Prior tax exemptions NUMC5
DEXEMPT BSI: D Tax exemptions NUMC5
ADEXEMPT BSI: Additional tax exemptions NUMC5
ADEXAMOUNT BSI: Additional exemption amount BSI_WAGE
BASEWAGES BSI: Base wage BSI_WAGE
ADDTAXRATE BSI: Additional Tax Rate BSI_RATE
ADDTAXAMT BSI: Additional Tax Amount BSI_WAGE
PPTAX BSI Canada: Pay Period Wages BSI_WAGE
MTDWAGES BSI: Month to date Wages BSI_WAGE
MTDTAX BSI: Month to date tax BSI_WAGE
PCTWORKED BSI: Percentage work BSI_WAGE
RPTAXCRAMT BSI: Tax credit BSI_RATE
EXPRATE BSI: Experience amount BSI_WAGE
MAXWAGEOR BSI: Maximum rate BSI_RATE
NONTAXCON BSI: Non taxable contributions BSI_WAGE
CALCTAX BSI: Calculated tax BSI_WAGE
TAXWAGE BSI: Taxable wages BSI_WAGE
TOTALWAGE BSI: Total pay BSI_WAGE
Master Data Relations Join Conditions
BSI: Check Date
  • BSI: Check Date
  • BSI: Employee
  • BTXTTAX.CHECKDATE == BTXEMPT.CHECKDATE
  • BTXTTAX.EMPLOYEE == BTXEMPT.EMPLOYEE
BSI: Tax Category BTXTTAX.TAXTYPE == BTXTAXT.TAXTYPE
Other Relations | to Master Data Relations ↑ Join Conditions
BSI: Tax Code
  • BSI: Country indicator
  • ?
  • BSI: Tax Code
  • BSI: Income category
  • BTXTTAX.COUNTRY == BTXTAXC.COUNTRY
  • BTXTTAX.[column in domain "MANDT"] == BTXTAXC.MANDT
  • BTXTTAX.TAXCODE == BTXTAXC.TAXCODE
  • BTXTTAX.INCOME == BTXTAXC.INCOME