GL_SUT_ER_VW

(SQL View)
Index Back

Company State/Fed Tax Table

This record stores company-related data required for processing of state unemployment and disability taxes, for payroll reporting of state unemployment and withholding taxes, and for posting state tax data to the General Ledger.

select company, state, effdt, GL_SUT_ER from PS_CO_STATETAX_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TAX_TBL

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GL_SUT_ER Character(35) VARCHAR2(35) NOT NULL GL-SUT (Employer).