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_CDOM_PAY_MTHD_LVW(SQL View) |
Index Back |
|---|---|
OM Payment Method View - LANGPrompt view on xlat values for PAYMENT_METHOD field; used to exclude methods (e.g.,EC,PayPal) that are not available/appropriate for use in OM. |
| SELECT A.FIELDVALUE , L.LANGUAGE_CD , L.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG L WHERE %Join(COMMON_KEYS, PSXLATITEM A, PSXLATITEMLANG L) AND A.FIELDNAME = 'PAYMENT_METHOD' AND A.FIELDVALUE NOT IN ( 'PL', 'EC') AND A.EFFDT = ( SELECT MAX(I.EFFDT) FROM PSXLATITEM I WHERE I.FIELDNAME = A.FIELDNAME AND I.FIELDVALUE = A.FIELDVALUE AND I.EFFDT <= %CurrentDateIn AND I.EFF_STATUS = 'A') |
| # | 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 | DESCRIPTION | Character(35) | VARCHAR2(35) NOT NULL | DESCRIPTION |