AR_CA_DETAIL_VW(SQL View) |
Index Back |
|---|---|
AR Contract Line Details ViewAR Contract Line Details View |
| SELECT D.CONTRACT_NUM , D.CONTRACT_LINE_NUM , %Coalesce(B.BUSINESS_UNIT_BI, ' ') , %Coalesce(B.BILLING_SPECIALIST, ' ') , %Coalesce(B.BILLING_AUTHORITY, ' ') , %Coalesce(P.BUSINESS_UNIT_PC, ' ') , %Coalesce(P.PROJECT_ID, ' ') , %Coalesce(P.ACTIVITY_ID, ' ') FROM PS_CA_DETAIL D LEFT OUTER JOIN PS_CA_BILL_PLAN B ON D.CONTRACT_NUM = B.CONTRACT_NUM AND D.BILL_PLAN_ID = B.BILL_PLAN_ID LEFT OUTER JOIN PS_CA_DETAIL_PROJ P ON D.CONTRACT_NUM = P.CONTRACT_NUM AND D.CONTRACT_LINE_NUM = P.CONTRACT_LINE_NUM |
| # | 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 | BILLING_AUTHORITY | Character(8) | VARCHAR2(8) NOT NULL | Billing Authority |
| 6 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 7 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 8 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |