CA_NOTE_ADD_VW

(SQL View)

SELECT NOTE.CONTRACT_NUM ,NOTE.CONTRACT_COMPONENT ,NOTE.NOTES_SEQ_NUM FROM PS_CA_NOTE NOTE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
Prompt Table: CA_NOTE_ADD_VW2

2 CONTRACT_COMPONENT Character(4) VARCHAR2(4) NOT NULL Contract Component
AMT=Amount Allocation
BIL=Billing Plan
CHG=Amendments
EO=Early Out Options
HDR=Contract Header
LINE=Contract Line
MLST=Contract Milestone
PEN=Bonus/Penalty
PGP=Progress Payments Terms
PPD=Prepaids
PROJ=Contractor Terms
REV=Revenue Plan
TERM=Special Payment Terms

3 NOTES_SEQ_NUM Number(3,0) SMALLINT NOT NULL Notes Sequence Num

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_NOTE_ADD_VW2
2	CONTRACT_COMPONENT	Character(4)	VARCHAR2(4) NOT NULL	Contract Component AMT=Amount Allocation BIL=Billing Plan CHG=Amendments EO=Early Out Options HDR=Contract Header LINE=Contract Line MLST=Contract Milestone PEN=Bonus/Penalty PGP=Progress Payments Terms PPD=Prepaids PROJ=Contractor Terms REV=Revenue Plan TERM=Special Payment Terms
3	NOTES_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Notes Sequence Num