BUSINESS_UNITPrompt Table: SP_BU_BI_NONVW
BILLING_SPECIALISTPrompt Table: BI_SPECIALST_VW
BI_SPLST_SUM_VW(SQL View) |
Index Back |
|---|---|
billing specialist summay |
| SELECT A.BUSINESS_UNIT , A.BILLING_SPECIALIST , A.NAME1 , COUNT(A.INVOICE) FROM PS_BI_BIL_SPLST_VW A GROUP BY A.BUSINESS_UNIT , A.BILLING_SPECIALIST , A.NAME1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_BI_NONVW |
| 2 | BILLING_SPECIALIST |
Character(8) | VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table: BI_SPECIALST_VW |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | COUNT_LINES | Number(15,0) | DECIMAL(15) NOT NULL | Count of Lines |