CA_RNW_CYC_VW(SQL View) |
Index Back |
---|---|
CA-Renewal Cycles |
SELECT A.RNW_PKG_ID , B.RNW_CYCLE_NBR , A.DESCR , A.TARGET_CONTRACT , A.RNW_PKG_STATUS , C.SOLD_TO_CUST_ID , D.NAME1 , A.CURRENT_CYCLE_NBR , B.RNW_CYCLE_STATUS , B.RNW_CYCLE_START_DT , B.PRODUCT_ID FROM PS_CA_RNW_PKG A , PS_CA_RNW_CYCLE B , PS_CA_CONTR_HDR C , PS_CUSTOMER D WHERE A.RNW_PKG_ID = B.RNW_PKG_ID AND A.TARGET_CONTRACT = C.CONTRACT_NUM AND C.SOLD_TO_CUST_ID = D.CUST_ID AND D.CUST_STATUS <> 'T' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RNW_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL |
PSIRS-KK
Prompt Table: CA_RNW_PKG |
2 | RNW_CYCLE_NBR | Number(6,0) | INTEGER NOT NULL |
PSIRS-KK
Default Value: 1 |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | TARGET_CONTRACT | Character(25) | VARCHAR2(25) NOT NULL |
PSIRS-KK
Prompt Table: CA_CNTR_SRCH_VW |
5 | RNW_PKG_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
PSIRS-KK
CAN=Canceled PND=Pending PRG=In Progress |
6 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table: CUST_SLD_VW |
7 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
8 | CURRENT_CYCLE_NBR | Number(6,0) | INTEGER NOT NULL | PSIRS-KK |
9 | RNW_CYCLE_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
PSIRS-KK
DON=Done PND=Pending RDY=Ready Default Value: PND |
10 | RNW_CYCLE_START_DT | Date(10) | DATE | PSIRS-KK |
11 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |