CA_PVN (SQL Table)	Index Back
Table to store last PVN number This table will store the PVN (public voucher number) that was last generated. For use by Billing.

CA_PVN

(SQL Table)

Table to store last PVN number

This table will store the PVN (public voucher number) that was last generated. For use by Billing.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

3 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

5 PUBLIC_VOUCHER_NBR Number(6,0) INTEGER NOT NULL Public Voucher Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
3	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
4	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
5	PUBLIC_VOUCHER_NBR	Number(6,0)	INTEGER NOT NULL	Public Voucher Number