PR_LINE

(SQL Table)
 Index Back

XPR Line

Payment Request Line

  • 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

    Default Value: PR_REQUEST.REQUEST_ID

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PR_REQUEST.BUSINESS_UNIT

    3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
    4 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

    Default Value: INV_ITEMS.SETID

    5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: ITM_PURCH_VW
    Set Control Field: ITM_SETID

    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

    Prompt Table: UNITS_TBL

    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

    Default Value: PR_REQUEST.TXN_CURRENCY_CD

    12 SPEEDCHART_KEY Character(10) VARCHAR2(10) NOT NULL SpeedChart Key

    Prompt Table: EMSPEEDCHART_VW

    13 ACCOUNT_CODE Character(20) VARCHAR2(20) NOT NULL Accounting Tag

    Prompt Table: TAG_SEL_DVW

    14 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line