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
LANGUAGE_CDPRC_PAYMETH_LVW(SQL View) |
Index Back |
|---|---|
payment methodpayment method |
| SELECT %Substring(A.FIELDVALUE, 1 , 3) , A.LANGUAGE_CD , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE FIELDNAME = 'PAYMENT_METHOD' AND %EffdtCheck(PSXLATITEMLANG, A, %CurrentDateIn) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |