PAYMENT_METHODACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
FORMAT_IDLANGUAGE_CDPMT_FRMTVW3_LNG(SQL View) |
Index Back |
|---|---|
Format Method View LanguagePayment Format Method Langage View. This language view is used for the views PMT_FORMAT_VW3 |
| SELECT C.PYMNT_METHOD , A.FORMAT_ID , B.LANGUAGE_CD , B.FORMAT_NAME , B.DESCR254 FROM PS_PMT_FORMAT_DEFN A ,PS_PMT_FORMAT_LNG B , PS_PMT_FORMAT_MTHD C WHERE A.FORMAT_ID = B.FORMAT_ID AND A.FORMAT_ID = C.FORMAT_ID AND A.FORMAT_DOC_TYPE = 'PMT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAYMENT_METHOD |
Character(3) | VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report |
| 2 | FORMAT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Format ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | FORMAT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Layout Name |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |