AR_CA_SPEC_VW(SQL View) |
Index Back |
|---|---|
Bill Specialist by Contract LnBill Specialist by Contract Ln |
| SELECT DISTINCT D.CONTRACT_NUM , D.CONTRACT_LINE_NUM , B.BUSINESS_UNIT_BI , B.BILLING_SPECIALIST , S.NAME1 , S.PHONE FROM PS_CA_DETAIL D , PS_CA_BILL_PLAN B , PS_AR_BI_SPCLST_VW S , PS_SET_CNTRL_REC SC WHERE D.CONTRACT_NUM = B.CONTRACT_NUM AND D.BILL_PLAN_ID = B.BILL_PLAN_ID AND S.SETID = SC.SETID AND S.BILLING_SPECIALIST = B.BILLING_SPECIALIST AND SC.RECNAME = 'BI_SPECIALIST' AND SC.SETCNTRLVALUE = B.BUSINESS_UNIT_BI |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 3 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 4 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL | Billing Specialist |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 6 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |