GPNL_BK_ACCT_VW

(SQL View)
 Index Back

Payee Bank Account Info NLD

View on PYE_BANKACT_NLD that Concatenates the payment description1 and payment description 2

SELECT EMPLID , ACCOUNT_ID , PAYMENT_DESCR1_NLD %Concat ' ' %Concat PAYMENT_DESCR2_NLD FROM PS_PYE_BANKACT_NLD

  • Parent record: PYE_BANKACCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description