Prompt Table: CUST_SLD_VW
CONTRACT_NUMDefault Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table: CA_BUS_UNIT_VW
Prompt Table: CA_REGION_CD_VW
CA_CONTR_CHG_VW(SQL View) |
Index Back |
|---|---|
Contract Header Search ViewThis is the Self-Service iClient version of the Contract Header Search View. |
| SELECT CUST.NAME1 ,CONTRACT_NUM ,BUSINESS_UNIT ,REGION_CD FROM PS_CA_CONTR_HDR HDR ,PS_CUST_SLD_VW CUST WHERE HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND HDR.CA_PROC_STATUS IN ('A','C') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL |
Name 1
Prompt Table: CUST_SLD_VW |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: CA_BUS_UNIT_VW |
| 4 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: CA_REGION_CD_VW |