ST_CNTRY_TAX_VW

(SQL View)

SELECT COUNTRY, ST_STOCK_TAX_TYPE FROM PS_ST_TAX_TYPE_TBL WHERE ST_TAX_LEVEL = 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

2 ST_STOCK_TAX_TYPE Character(5) VARCHAR2(5) NOT NULL This field is used to setup up taxes for the Stock Admin application for companies without PeopleSoft payroll.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
2	ST_STOCK_TAX_TYPE	Character(5)	VARCHAR2(5) NOT NULL	This field is used to setup up taxes for the Stock Admin application for companies without PeopleSoft payroll.