VCHR_LINE_VW

(SQL View)
 Index Back

Voucher Line View


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.DESCR , A.MERCHANDISE_AMT , A.INV_ITEM_ID , A.QTY_VCHR , A.UNIT_OF_MEASURE , A.UNIT_PRICE FROM PS_VOUCHER_LINE A

  • 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 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

    Default Value: 1

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDITTABLE13

    7 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
    8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    9 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price