CA_NOTE_TRANS_H

(SQL Table)
Index Back

Revenue Plan Search Dialogue

Master contracts are excluded from this view.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

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

Prompt Table: CA_NO_MSTR_VW

5 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
6 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

Prompt Table: CA_DETAIL

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

Prompt Table: CA_BILL_PLAN

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

Prompt Table: CA_ACCTPLAN

9 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.

Prompt Table: CA_CHG_HDR

10 MS_SEQNUM Number(3,0) SMALLINT NOT NULL Milestone Number
11 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID
12 EARLY_OUT_CD Character(4) VARCHAR2(4) NOT NULL Early Out Option Code