SP_CANOTE_NONVW(SQL View) |
Index Back |
|---|
| SELECT CUST.NAME1 ,NOTE.CONTRACT_NUM ,NOTE.CONTRACT_COMPONENT ,NOTE.NOTES_SEQ_NUM ,NOTE.NOTE_TYPE ,NOTE.ADD_DTTM ,NOTE.LAST_MAINT_OPRID ,HDR.BUSINESS_UNIT ,HDR.CONTRACT_ADMIN FROM PS_CA_NOTE NOTE ,PS_CA_CONTR_HDR HDR ,PS_CUST_SLD_VW CUST WHERE NOTE.CONTRACT_NUM = HDR.CONTRACT_NUM AND HDR.SOLD_TO_CUST_ID = CUST.CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  NAME1 |
Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_BU_SP_NONVW |
| 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 | NOTES_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Notes Sequence Num |
| 5 | NOTE_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Note Type |
| 6 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 7 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 9 | CONTRACT_ADMIN | Character(40) | VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Prompt Table: MEMBER_VW |