GPBR_REV_CD_VW (SQL View)	Index Back
Revenue Code Record View Revenue Code Record View.

GPBR_REV_CD_VW

(SQL View)

Revenue Code Record View

Revenue Code Record View.

SELECT A.GPBR_REVENUE_CODE, A.GPBR_TAX_RATE FROM %Table(GPBR_REV_CD_TBL) A WHERE %EffdtCheck(GPBR_REV_CD_TBL B, A, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPBR_REVENUE_CODE Character(6) VARCHAR2(6) NOT NULL Revenue Code.

2 GPBR_TAX_RATE Number(6,2) DECIMAL(5,2) NOT NULL Tax Rate.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPBR_REVENUE_CODE	Character(6)	VARCHAR2(6) NOT NULL	Revenue Code.
2	GPBR_TAX_RATE	Number(6,2)	DECIMAL(5,2) NOT NULL	Tax Rate.