CA_CONTR_HDR_VW(SQL View) |
Index Back |
---|---|
Contract Header Search ViewThis is the Self-Service iClient version of the Contract Header Search View. |
SELECT CONTRACT_NUM , CUST.NAME1 , BUSINESS_UNIT , CONTR_LEGAL_ENTITY , REGION_CD , CONTRACT_SIGN_DT , CONTRACT_SIGN_DT , CONTRACT_SIGN_DT , HDR.CONTRACT_ADMIN FROM PS_CA_CONTR_HDR HDR , PS_CUST_SLD_VW CUST , PS_SET_CNTRL_GROUP D WHERE HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND HDR.CA_RQST_SRC <> 'OND' AND D.REC_GROUP_ID = ( SELECT REC_GROUP_ID FROM PS_REC_GROUP_REC WHERE RECNAME = 'CUSTOMER') AND CUST.SETID = D.SETID AND HDR.BUSINESS_UNIT = D.SETCNTRLVALUE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Default Value: NEXT |
2 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
4 | CONTR_LEGAL_ENTITY | Character(15) | VARCHAR2(15) NOT NULL |
Contract Legal Entity
Prompt Table: CA_LEGAL_ENTITY |
5 | 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 |
6 | CONTRACT_SIGN_DT | Date(10) | DATE | Contract Signed |
7 | FROM_DT | Date(10) | DATE | From Date |
8 | TO_DT | Date(10) | DATE | To Contract Sign Date |
9 | CONTRACT_ADMIN | Character(40) | VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Prompt Table: MEMBER_VW |