EX_SHEET_PAY_VW

(SQL View)
 Index Back

Expenditure Method View


select distinct a.setid, a.expend_mthd, a.expend_mthd_edit, a.vendor_id, b.bank_cd, b.bank_acct_key, b.pymnt_method from PS_EX_EXP_MTHD_TBL a, ps_bus_unit_opt_ex b where a.eff_status = 'A' and a.effdt = (select max(effdt) from PS_EX_EXP_MTHD_TBL c where c.setid = a.setid and c.expend_mthd = a.expend_mthd and c.effdt <= %currentdatein) and a.setid = b.setid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 EXPEND_MTHD Character(3) VARCHAR2(3) NOT NULL Payment Type
3 EXPEND_MTHD_EDIT Character(3) VARCHAR2(3) NOT NULL Payment Type Edit
EMP=Employee
PPA=Prepaid Airfare
PPD=Prepaid
PPH=Prepaid Hotel
VND=Supplier
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR

5 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: BANK_CD_VW

6 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

Prompt Table: BANK_ACCT_TBL

7 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer