SP_CANOTE_OPRVW(SQL View) |
Index Back |
|---|
| SELECT OPR.OPRID ,CUST.NAME1 ,NOTE.CONTRACT_NUM ,NOTE.CONTRACT_COMPONENT ,NOTE.NOTES_SEQ_NUM ,NOTE.NOTE_TYPE ,NOTE.ADD_DTTM ,NOTE.LAST_MAINT_OPRID FROM PS_CA_NOTE NOTE ,PS_CA_CONTR_HDR HDR ,PS_CUST_SLD_VW CUST ,PS_SP_BU_CA_OPRVW OPR WHERE NOTE.CONTRACT_NUM = HDR.CONTRACT_NUM AND OPR.BUSINESS_UNIT=HDR.BUSINESS_UNIT AND HDR.SOLD_TO_CUST_ID = CUST.CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 |  NAME1 |
Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 3 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_BU_SP_NONVW |
| 4 | 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 |
| 5 | NOTES_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Notes Sequence Num |
| 6 | NOTE_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Note Type |
| 7 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 8 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |