EM_VO_LNQV_DISP

(SQL View)
Index Back

Voucher Line


SELECT F.BUSINESS_UNIT , F.VOUCHER_ID , F.VOUCHER_LINE_NUM , F.MERCHANDISE_AMT , F.UNIT_OF_MEASURE , F.UNIT_PRICE , F.TXN_CURRENCY_CD , F.INV_ITEM_ID , F.QTY_VCHR , F.DESCR , F.PO_ID FROM PS_VCHR_LINE_QV F

  • 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
    4 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    6 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
    7 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    9 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order