CONVR_Q_AR_VW (SQL View)	Index Back
Qualifier View for Conversatio Qualifier View that only shows AR/DM Qualifiers

CONVR_Q_AR_VW

(SQL View)

Qualifier View for Conversatio

Qualifier View that only shows AR/DM Qualifiers

SELECT %Substring(FIELDVALUE, 1, 2) , XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME = 'CONVR_QUALIFIER_CD' AND FIELDVALUE NOT IN ('BA', 'BI', 'QU', 'RM', 'SO', 'CT')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONVR_QUALIFIER_CD Character(2) VARCHAR2(2) NOT NULL Conversation Qualifier Code
BA=Buy Agremt
BI=Invoice #
CP=Cust Pay
CT=Contract
D=Document
I=Item
L=Lading
P=PO Number
PY=Payment ID
QU=Quote
RM=RMA
SC=Case Num
SO=Sale Order

2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONVR_QUALIFIER_CD	Character(2)	VARCHAR2(2) NOT NULL	Conversation Qualifier Code BA=Buy Agremt BI=Invoice # CP=Cust Pay CT=Contract D=Document I=Item L=Lading P=PO Number PY=Payment ID QU=Quote RM=RMA SC=Case Num SO=Sale Order
2	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name