AR_CUSTTYPE_VW

(SQL View)
Index Back

Customer Type View


SELECT %Substring(A.FIELDVALUE, 1 , 1) , A.XLATLONGNAME FROM PSXLATITEM A WHERE FIELDNAME = 'CUSTOMER_TYPE' AND %EffdtCheck(PSXLATITEM, A, %CurrentDateIn) AND a.eff_status='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CUSTOMER_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Type
1=User 1
2=User 2
3=User 3
4=User 4
F=Foreign
M=Commercial
N=Consumer
S=State and Local
X=Excluded Foreign Customer
2 AR_CUSTYPE_DESC Character(254) VARCHAR2(254) NOT NULL Customer Type Description