CUST_IDCONTRACT_NUMDefault Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table: CA_BUS_UNIT_VW
Prompt Table: CUST_SLD_VW
FO_CONTR_HDR_VW(SQL View) |
Index Back |
|---|---|
Contract Header Search View |
| SELECT DISTINCT HDR.SOLD_TO_CUST_ID ,CONTRACT_NUM ,DESCR ,BUSINESS_UNIT ,CUST.NAME1 ,HDR.CURRENCY_CD ,CA_STATUS FROM PS_CA_CONTR_HDR HDR ,PS_CUST_SLD_VW CUST ,PS_SET_CNTRL_REC REC WHERE HDR.SOLD_TO_CUST_ID = CUST.CUST_ID AND REC.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND REC.SETID = CUST.SETID AND REC.RECNAME = 'CUST_SLD_VW' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: CA_BUS_UNIT_VW |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL |
Name 1
Prompt Table: CUST_SLD_VW |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | CA_STATUS | Character(24) | VARCHAR2(24) NOT NULL | Contract Status |