CA_NOTE_DETAIL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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
Default Value: 1

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

5 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

6 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

7 MILESTONE_ID Character(6) VARCHAR2(6) NOT NULL Milestone_ID identifies the milestones that can be referenced from multiple functional areas.

8 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

9 EARLY_OUT_CD Character(4) VARCHAR2(4) NOT NULL Early Out Option Code

10 NOTE_CLASS Character(2) VARCHAR2(2) NOT NULL Classification
C=Custom
S=Standard
Default Value: S

11 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type
Prompt Table: NOTE_TYPE

12 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code
Prompt Table: STD_NOTE

13 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

14 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added

15 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

16 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_BU_SP_NONVW
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 Default Value: 1
4	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
5	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID
6	ACCT_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Recognition Plan
7	MILESTONE_ID	Character(6)	VARCHAR2(6) NOT NULL	Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
8	INCENTIVE_ID	Character(10)	VARCHAR2(10) NOT NULL	Investment Incentive ID
9	EARLY_OUT_CD	Character(4)	VARCHAR2(4) NOT NULL	Early Out Option Code
10	NOTE_CLASS	Character(2)	VARCHAR2(2) NOT NULL	Classification C=Custom S=Standard Default Value: S
11	NOTE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Note Type Prompt Table: NOTE_TYPE
12	STD_NOTE_CD	Character(10)	VARCHAR2(10) NOT NULL	Standard Note Code Prompt Table: STD_NOTE
13	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
14	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
15	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
16	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID