Skip to end of metadata
Go to start of metadata

Purpose

This post was created intended to explain the most relevant parameters contained on BSI Interface.

Overview

The tax calculation for US payroll on SAP system is done by BSI Tax Factory system. The communication regarding this calculation is done inside payroll function USTAX and it can be seen at schema node BSI Interface. Each parameter of this interface has a meaning that will define how the tax is calculated. Here you can see a description of the most relevant parameters.

BSI Interface codes and what they mean

When you run U.S. you can see in the payroll log, BSI Interface.


 

Here you can find out what are the BSI codes and what they mean.


ET: employee test type
This command specifies which test driver you want to use. It is a required parameter for Pension or Locator batch tests. Regular tax is the default.
Enter the appropriate value from the table below:

0 Invoke the Regular tax test driver. This is the default value.
1 Invoke the PensionTax test driver.
2 Invoke the TaxLocator test driver. (see note)
3 Invoke the ReverseTax test driver.
Note: To perform Placeholder Locator processing, the Return All States (RA) value must be set to '1' on the EPC command line.

Example: ATC ET:1

EC: employee code
Enter up to a maximum of 11 characters, left justified. Surround the code with quotation marks if it contains imbedded blanks.

Examples: EC:150-30-5115 or
EC: ''TOM JONES''

EN: employee name
Enter up to a maximum of 30 characters, left justified. Surround the code with quotation marks if it contains imbedded blanks.
Examples: EN: ''J.D. SMITH'' or
EN:ANDERSON

CC: company code
Enter up to a maximum of 11 characters, left justified. Surround the code with quotation marks if it contains imbedded blanks.

Examples: CC: ''IMB CORP. '' or
CC:BSI

GC: group code
Enter up to a maximum of 11 characters, left justified. Surround the code with quotation marks if it contains imbedded blanks.

Examples: GC: P.R.Dept. or
GC: ''PR DEPT. ''

PP: pay period
How frequently the recipient is paid in the year. Enter one of the standard values from the Pay Frequency Table (located in the Appendix) or enter any other pay period value of your choice.
Example: PP:26

CD: check date
The date on which the recipient is paid. Enter MM-DD-YYYY.
Example: CD:07-01-1999

PT: payment type
This keyword, which is used for open-ended tax types only, indicates the payment type(s) you wish to process. Select the appropriate value from the Payment Type Table, which is located in the Appendix.
The keyword may be entered multiple times with a different value in order to define the various payment types that are to be overridden. If the keyword and its value are not entered, all three payment types listed will be overridden.
Examples: PT:REG
PT:SUP
PT:CUM
YP:ytd pay periods
The number of pay periods this year, prior to this pay period. Enter from 1 to 366 depending on the pay period parameter.
Example: YP:27

PH: pay period hours
Enter any number of hours from .01 to 99999.99. Only used with vacation payment type.
Example: PH:37.5

GU: gross up code
Indicates to the system whether or not gross up calculations are to be performed for this recipient. Enter the appropriate value from the table below.
1. Do not perform gross up calculations
2. Perform the gross up calculations that will consider state and local taxes a deduction for federal tax purposes
3. Perform the gross up calculations that will not consider state and local taxes a deduction for federal tax purposes
4. Use filing tables
Example: GU:2

BD: birth date
The date on which the employee was born. Enter MM-DD-YYYY
Example: BD:07-01-1963

RS: employee resident state
This command is used for reciprocal situations when the resident state does not have a withholding tax.
Example: RS:GA

RC: reciprocal code
Enter the appropriate value from the table below:

0 do not perform reciprocal calculations
1 perform reciprocal calculations

Example: RC:1

PS:principal state of employment

This command is used to determine which state’s rules are followed in multi-state situations. Enter a code that represents the principal state. The code can be from 1-3 characters.

Example: PS:GA

Note 1: This command is also used for Deceased functionality.

Note 2: Tax-Employee-level only: The existing Principal State of Employment is expected to determine what states’ payment limit, if any, applies. The Final Paycheck Net Amount is a new output API field. A state payment limit may apply depending on the Principal State of Employment.

GW:gross income

The total of all income earned by the recipient for this pay period. Enter income ranging from 0.00 to 999999999.99. Optionally, a dollar sign and commas may also be entered.

Examples: GW:1000.00 or
GW:$1,000.00

DT: Date of Death

Select or type the date of death. Enter MM-DD-YYYY. 
Note: This command is used with Employee Parameter values 4, 5, or 6.

Example: 07-01-2013

 

ADC Authority Data Command
See Authority Data for an overview.
This command specifies to the Tax Test Program taxing authority parameters for the tax type.


TC: authority code
This command indicates the User's code for the taxing authority.
Example: TC:GA

NR: resident code
The recipient's resident status for the taxing authority entered via the TC: keyword. Enter the appropriate value from the table below:

0. Resident
1. Non-Resident
2. Default Resident
3. Live/Work
4. Resident on 1/1
5. Work on 1/1
6. Live/Work on 1/1
Example: NR:1
Note: Pass the new values (4, 5, and 6) instead of previous values (0, 1, and 3) that currently only apply to Indiana Localities in the program-to-program interface between TaxFactory and your system.

RP: reciprocal participation code
Enter the appropriate value from the table below:
0 taxing authority does not participate in reciprocal calculations
1 taxing authority participates in reciprocal calculations

Example: RP:1
TT:tax type
Enter the appropriate tax type value from the Tax Type Table, which is located in the Appendix. If a tax type is not entered, data will be processed for all tax types applicable to default or entered codes.
Example: TT:70


FN: formula number
Indicates which formula for the appropriate tax type is to be processed. Enter the appropriate formula number or letter from the Formula Number Table, which is located in the Appendix.
Example: FN:6
PW:pay period income
The current income for this tax type. Enter income ranging from 0.00 to 999999999.99. Optionally, a dollar sign and commas may also be entered.
Examples: PW:1000.55 or
PW:$1,000.55

HW: hours worked
Enter from 0.00 to 9999.99 hours.
Examples: HW:0
HW:40.00
HW:173.33

MS: marital status
The marital status selected by the recipient for this tax type. Enter the appropriate value from the Marital Status Table, which is located in the Appendix.
Examples: MS:01
MS:07

NE: number exemptions
The number of exemptions claimed by the recipient for this tax type. Enter from 0 to 99999 exemptions.
Examples: NE:1
NE:10001
NE:0

ADD Additional Data
Additional Data specifies the tax type parameters that are not as frequently used as High Use Data, it is not a required command.


TE: tax exempt
Indicates whether or not the recipient is exempt from the tax type previously entered. Enter the appropriate value from the table below.
1. not exempt
2. exempt
Example: TE:1
RN:round indicator
Indicates whether or not you wish to round the calculated tax to the nearest dollar or cent if this option is valid for the tax type previously entered. Enter the appropriate value from the table below.
0 use authority default
1 round to the nearest cent
2 round to the nearest dollar, if allowed.
Example: RN:1
PW: percent worked
Enter a decimal number which is less than or equal to 1 or a percent which is less than or equal to 100%.
Examples: PW:.75
PW:75%
Note: If the authority specified in the ADC command is a locality, its PW must be less than or equal to the PW for its state.

SDC: Supplemental Data Command
This command specifies to the Tax Test Program the tax type parameters for supplemental taxing, this is also NOT a required command.

SM: supplemental code
This code indicates the supplemental method that is to be used to calculate the tax. Enter the appropriate value from the Supplemental Methods Table, which is located in the Appendix.
Example: SM:09
Note: If the aggregation with pay periods method is selected, supply year-to-date pay periods in the Recipient Parameters Command.

BW: base income
The income earned by the recipient for working one full pay period without considering supplemental or overtime income. Enter an income ranging from 0.00 to 999999999.99. Optionally, a dollar sign and commas may also be entered.
Examples: BW:1079.82 or
BW:$1,079.82