CA_COMPONENT_VW (SQL View)	Index Back
Amendment Exceptions Amendment Exceptions

CA_COMPONENT_VW

(SQL View)

Amendment Exceptions

SELECT A.FIELDVALUE , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'CONTRACT_COMPONENT' AND %EffdtCheck(PSXLATITEM XX, A, %CurrentDateIn) AND A.FIELDVALUE IN ('HDR' ,'LINE')

Related Language Record: CA_CMPNT_VW_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	DESCR20_MIXED	Character(20)	VARCHAR2(20) NOT NULL	Description 20 characters, mixed case