GL_VFLI_EE_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_VFLI_EE_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 , PNA_GL_VFLI_EE 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 PNA_GL_VFLI_EE Character(35) VARCHAR2(35) NOT NULL GL Account # - VFLI

#	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	PNA_GL_VFLI_EE	Character(35)	VARCHAR2(35) NOT NULL	GL Account # - VFLI