PC_CON_CUST_VW(SQL View) |
Index Back |
|---|---|
Project Bill to CustomersProject Bill to Customers |
| SELECT E.BUSINESS_UNIT_PC , E.PROJECT_ID , E.ACTIVITY_ID , B.CONTRACT_NUM , B.BILL_TO_CUST_ID , B.DESCR , C.NAME1 FROM PS_CA_CONTR_HDR B , PS_CUSTOMER C , PS_SET_CNTRL_REC D , PS_CA_DETAIL_PROJ E , PS_CA_DETAIL F WHERE C.CUST_ID = B.BILL_TO_CUST_ID AND C.SETID = D.SETID AND E.CONTRACT_NUM = B.CONTRACT_NUM AND E.CONTRACT_NUM = F.CONTRACT_NUM AND E.CONTRACT_LINE_NUM = F.CONTRACT_LINE_NUM AND D.SETCNTRLVALUE = B.BUSINESS_UNIT AND D.RECNAME = 'CUSTOMER' AND F.PRICING_STRUCTURE = 'RATE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 5 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |