CUSTHIER_VW (SQL View)	Index Back
Corporate Customer Hierarchy Corporate Customer Hierarchy Date Init Issue Description 082807 JJM F-CJORG-O69Q0 Credit Checking Enhancements

CUSTHIER_VW

(SQL View)

Corporate Customer Hierarchy

Corporate Customer Hierarchy Date Init Issue Description 082807 JJM F-CJORG-O69Q0 Credit Checking Enhancements

SELECT SETID , CUST_ID , CUST_STATUS , CUST_STATUS_DT , NAMESHORT , CUSTOMER_TYPE , SINCE_DT , ADD_DT , NAME1 , NAME2 , ADDRESS_SEQ_NUM , CORPORATE_SETID , CORPORATE_CUST_ID , PARENT_SETID , PARENT_CUST_ID , REMIT_FROM_SETID , REMIT_FROM_CUST_ID , CRSPD_SETID , CRSPD_CUST_ID , VENDOR_SETID , VENDOR_ID , REFER_TO_SETID , REFER_TO_CUST_ID , REVIEW_DAYS , FORMER_NAME_1 , FORMER_NAME_2 , LAST_MAINT_OPRID , CNTCT_SEQ_NUM , SUBCUST_USE , SUBCUST_QUAL1 , SUBCUST_QUAL2 , 0 FROM PS_CUSTOMER WHERE CUST_STATUS IN ('A','I')

Related Language Record: CUST_VW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status
A=Active
I=Inactive
T=Template
Default Value: A

4 CUST_STATUS_DT Date(10) DATE Customer Status Date

5 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name

6 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
Default Value: 1

7 SINCE_DT Date(10) DATE NOT NULL Customer Since
Default Value: %date

8 ADD_DT Date(10) DATE NOT NULL Customer Added On
Default Value: %date

9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

10 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2

11 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Default Value: 1

12 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: CUSTOMER.SETID

13 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer

14 PARENT_SETID Character(5) VARCHAR2(5) NOT NULL Parent SetID

15 PARENT_CUST_ID Character(15) VARCHAR2(15) NOT NULL Parent Cust ID

16 REMIT_FROM_SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: CUSTOMER.SETID

17 REMIT_FROM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Remit From Customer

18 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID

19 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

20 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

21 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

22 REFER_TO_SETID Character(5) VARCHAR2(5) NOT NULL Refer To Setid

23 REFER_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Refer To Customer

24 REVIEW_DAYS Number(3,0) SMALLINT NOT NULL Review Days

25 FORMER_NAME_1 Character(40) VARCHAR2(40) NOT NULL Former Name 1

26 FORMER_NAME_2 Character(40) VARCHAR2(40) NOT NULL Former Name 2

27 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

28 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
Default Value: 1

29 SUBCUST_USE Character(1) VARCHAR2(1) NOT NULL SubCustomer
Y/N Table Edit
Default Value: N

30 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

31 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

32 LEVELNUM Number(5,0) INTEGER NOT NULL Level Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	CUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Customer Status A=Active I=Inactive T=Template Default Value: A
4	CUST_STATUS_DT	Date(10)	DATE	Customer Status Date
5	NAMESHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Name
6	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 Default Value: 1
7	SINCE_DT	Date(10)	DATE NOT NULL	Customer Since Default Value: %date
8	ADD_DT	Date(10)	DATE NOT NULL	Customer Added On Default Value: %date
9	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
10	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
11	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Default Value: 1
12	CORPORATE_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: CUSTOMER.SETID
13	CORPORATE_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Corporate Customer
14	PARENT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Parent SetID
15	PARENT_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Parent Cust ID
16	REMIT_FROM_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: CUSTOMER.SETID
17	REMIT_FROM_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Remit From Customer
18	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
19	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer
20	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
21	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
22	REFER_TO_SETID	Character(5)	VARCHAR2(5) NOT NULL	Refer To Setid
23	REFER_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Refer To Customer
24	REVIEW_DAYS	Number(3,0)	SMALLINT NOT NULL	Review Days
25	FORMER_NAME_1	Character(40)	VARCHAR2(40) NOT NULL	Former Name 1
26	FORMER_NAME_2	Character(40)	VARCHAR2(40) NOT NULL	Former Name 2
27	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
28	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Default Value: 1
29	SUBCUST_USE	Character(1)	VARCHAR2(1) NOT NULL	SubCustomer Y/N Table Edit Default Value: N
30	SUBCUST_QUAL1	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
31	SUBCUST_QUAL2	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
32	LEVELNUM	Number(5,0)	INTEGER NOT NULL	Level Number