CUST_CNT_CD_VW

(SQL View)
 Index Back

Customer Contact Type Codes

This record stores the valid Product Group Codes to be used for Pricing, Reporting, Accounting, Transit and more.

SELECT DISTINCT CONTACT_CODE , DESCR , EFF_STATUS , DESCRSHORT , CONTACT_TYPE FROM PS_CUST_CNTCT_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTACT_CODE Character(6) VARCHAR2(6) NOT NULL Contact Type Code
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
5 CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person.
B=Billing Contact
C=Contract Collaborator
D=Commercial Paper Contact
E=External Contact
F=Cash Forecast
G=General
I=Internal Corporate Contact
L=Line of Credit Contact
M=Executive Management
O=Investment Pool Contact
P=Accounts Payable
R=Broker
S=Sales Contact
V=Service Contact
W=Warehousing/Shipping Contact

Default Value: G