SETID_INQBUS_UNIT_AR_INQPrompt Table: SP_BU_CS2_NONVW
CUST_IDPrompt Table: AR_CUST_ALL_VW
CONTRACT_NUMPrompt Table: CA_CONTR_HDR
Prompt Table: SP_BU_CA_NONVW
Prompt Table: CA_STATUS_VW
A=Active
C=Closed
P=Pending
Prompt Table: CA_TYPE_TBL
ITEM_CNTRCT_VW(SQL View) |
Index Back |
|---|---|
Item contract viewItem contract view |
| SELECT DISTINCT I.SETID , I.BUSINESS_UNIT , I.CUST_ID , I.CONTRACT_NUM , C.BUSINESS_UNIT , C.CA_STATUS , C.CA_PROC_STATUS , C.CONTRACT_TYPE FROM PS_ITEM_DSP2_VW I , PS_CA_CONTR_HDR C WHERE I.CONTRACT_NUM <> ' ' AND I.CONTRACT_NUM = C.CONTRACT_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_INQ |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUS_UNIT_AR_INQ |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit AR
Prompt Table: SP_BU_CS2_NONVW |
| 3 | 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.
Prompt Table: AR_CUST_ALL_VW |
| 4 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CONTR_HDR |
| 5 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL |
Contracts Business Unit
Prompt Table: SP_BU_CA_NONVW |
| 6 | CA_STATUS | Character(24) | VARCHAR2(24) NOT NULL |
Contract Status
Prompt Table: CA_STATUS_VW |
| 7 | CA_PROC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
A=Active C=Closed P=Pending |
| 8 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table: CA_TYPE_TBL |