CUST_PRC_SLD_VW (SQL View)	Index Back
Sold-To Customers - Pricing View that shows Order Management Pricing for sold to customers.

CUST_PRC_SLD_VW

(SQL View)

Sold-To Customers - Pricing

View that shows Order Management Pricing for sold to customers.

SELECT A.SETID , A.CUST_ID , A.NAME1 , A.ADDRESS_SEQ_SOLD , A.CNTCT_SEQ_SOLD , A.CURRENCY_CD , A.CUST_LEVEL , A.CUR_RT_TYPE FROM PS_CUSTOMER A WHERE A.SOLD_TO_FLG = 'Y' AND A.CUST_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

3 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

4 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Sequence that the Sold To address should be used. Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.

5 CNTCT_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Contact - Sold To

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

7 CUST_LEVEL Character(1) VARCHAR2(1) NOT NULL Customer Level. Example of possible values are New, Prospect, Regular, or Temporary
N=New
P=Prospect - Quotations Only
R=Regular
T=Temporary

8 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
3	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
4	ADDRESS_SEQ_SOLD	Number(5,0)	INTEGER NOT NULL	Sequence that the Sold To address should be used. Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.
5	CNTCT_SEQ_SOLD	Number(5,0)	INTEGER NOT NULL	Primary Contact - Sold To
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
7	CUST_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Customer Level. Example of possible values are New, Prospect, Regular, or Temporary N=New P=Prospect - Quotations Only R=Regular T=Temporary
8	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.