VCHR_MCERCNT_VW

(SQL View)
 Index Back

Voucher Line


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

  • Parent record: VOUCHER

    • # 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 ERROR_CNT Number(4,0) SMALLINT NOT NULL Error Count