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_IDPMT_FORMAT_VW3(SQL View) |
Index Back |
|---|---|
Format Definition VW |
| SELECT MTHD.PYMNT_METHOD , DEFN.FORMAT_ID , DEFN.FORMAT_NAME , DEFN.DESCR254 FROM PS_PMT_FORMAT_DEFN DEFN , PS_PMT_FORMAT_MTHD MTHD WHERE DEFN.FORMAT_ID = MTHD.FORMAT_ID AND DEFN.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 | FORMAT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Layout Name |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |