| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table:
SP_BU_CA_NONVW
|
| 2 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_NO_MSTR_VW
|
| 3 |
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
|
| 4 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
Prompt Table:
CA_DETAIL
|
| 5 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
Prompt Table:
CA_BILL_PLAN
|
| 6 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
Prompt Table:
CA_ACCTPLAN
|
| 7 |
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
|
| 8 |
MS_SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Milestone Number
|
| 9 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
|
| 10 |
EARLY_OUT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Early Out Option Code
|