VCHR_MAXLN_VW

(SQL View)
 Index Back

Voucher Line


SELECT BUSINESS_UNIT , VOUCHER_ID , MAX(VOUCHER_LINE_NUM) FROM PS_VOUCHER_LINE 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 MAX_LINE_NBR Number(5,0) INTEGER NOT NULL Maximum Line Number