AP_SCHD_ID_VW

(SQL View)
Index Back

Schedule ID View


SELECT DISTINCT BANK_SETID , BANK_CD , BANK_ACCT_KEY , SCHEDULE_ID FROM PS_PAYMENT_TBL WHERE SCHEDULE_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
3 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
4 SCHEDULE_ID Character(10) VARCHAR2(10) NOT NULL Schedule ID