GL_VDI_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.

GL_VDI_ER_VW

(SQL View)

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_VDI_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_VDI_ER Character(35) VARCHAR2(35) NOT NULL GL Account #-VDI/ER.

#	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_VDI_ER	Character(35)	VARCHAR2(35) NOT NULL	GL Account #-VDI/ER.