RO_PK_METHOD_VW (SQL View)	Index Back
Payment terms Payment terms view to be used by Pricing

RO_PK_METHOD_VW

(SQL View)

Payment terms

Payment terms view to be used by Pricing

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

Related Language Record: RO_PK_METHD_LVW

# 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 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	EOEP_CHAR	Character(254)	VARCHAR2(254) NOT NULL	Long field