AP_PR_LN_VW

(SQL View)
 Index Back

XPR Line

Payment Request Line

SELECT B.REQUEST_ID , B.BUSINESS_UNIT , B.VOUCHER_LINE_NUM , B.ITM_SETID , B.INV_ITEM_ID , B.DESCR , B.QTY_VCHR , B.UNIT_OF_MEASURE , B.UNIT_PRICE , B.MERCHANDISE_AMT , B.TXN_CURRENCY_CD , B.SPEEDCHART_KEY , B.ACCOUNT_CODE , B.MAX_DISTRIB_LINE FROM PS_PR_REQUEST_AFVW A , PS_PR_LINE B WHERE A.REQUEST_ID = B.REQUEST_ID

  • Parent record: PR_REQUEST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BUS_AP_NONVW

    3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
    4 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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
    9 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
    10 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    11 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
    12 SPEEDCHART_KEY Character(10) VARCHAR2(10) NOT NULL SpeedChart Key
    13 ACCOUNT_CODE Character(20) VARCHAR2(20) NOT NULL Accounting Tag
    14 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line