AP_SCHD_INQ_VW8

(SQL View)
 Index Back

Voucher Scheduled Payment


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.PYMNT_GROSS_AMT , A.SCHEDULED_PAY_DT , A.TXN_CURRENCY_CD , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.VENDOR_NAME_SHORT , A.NAME1 FROM PS_AP_SCHD_INQ_VW A UNION SELECT B.BUSINESS_UNIT , B.VOUCHER_ID , B.PYMNT_GROSS_AMT , B.SCHEDULED_PAY_DT , B.TXN_CURRENCY_CD , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , B.VENDOR_NAME_SHORT , B.NAME1 FROM PS_AP_SCHD_INQ_VW2 B

  • Parent record: VOUCHER

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AP_NONVW

    2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: VCHR_ID_VW

    3 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
    4 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
    5 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

    Prompt Table: CURR_TXN_VW

    6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    9 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1