VCHR_TTLDSTL_VW

(SQL View)
Index Back

Voucher's Total Distrib Lines

-> SL - 14-AUG-2002 New Voucher's Total Distribution lines <-

SELECT BUSINESS_UNIT , VOUCHER_ID , COUNT(*) FROM PS_DISTRIB_LINE GROUP BY BUSINESS_UNIT , VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_FS

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

Prompt Table: VOUCHER

3 TOTAL_DISTRIBS Number(5,0) INTEGER NOT NULL Total Number of Distributions