TR_MTHD_ELECT (SQL View)	Index Back
Vaild Treasury Electronic Meth

TR_MTHD_ELECT

(SQL View)

Vaild Treasury Electronic Meth

SELECT %Substring(FIELDVALUE,1, 3) , XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME='PYMNT_METHOD' AND FIELDVALUE IN ('ACH','EFT','DD', 'WIR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name