RO_PK_METHD_LVW (SQL View)	Index Back
Payment terms Payment terms view to be used by pricing

RO_PK_METHD_LVW

(SQL View)

Payment terms

Payment terms view to be used by pricing

SELECT A.FIELDVALUE , A.LANGUAGE_CD , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'PAYMENT_METHOD' AND %EffdtCheck(PSXLATITEMLANG A1, A, %currentdatein)

Related Language Record for RO_PK_METHOD_VW

# 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.
CC=Credit Card
CHK=Check
DD=Direct Debit
DR=Draft
EFT=Electronic Fund Transfer
INV=Invoice

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field

#	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. CC=Credit Card CHK=Check DD=Direct Debit DR=Draft EFT=Electronic Fund Transfer INV=Invoice
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EOEP_CHAR	Character(254)	VARCHAR2(254) NOT NULL	Long field