CUSTCPY_HIER_VW

(SQL View)
 Index Back

Customer Hierarchy Table

Date Init. Issue # Description 03/28/01 JJM SP2 DI-EDWONG-3 Gromit 6039801; Added effdt logic

SELECT A.SETID , A.CUST_ID , A.EFFDT , A.PM_DIVISION , A.PM_REGION , A.PM_TERRITORY , A.PM_SYNDICATED_TYPE , A.PM_SYNDICATED_NUM , A.CLASSIFICATION FROM PS_CUST_HIERARCHY A WHERE %EffdtCheck(cust_hierarchy,A,%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 CUST_CPY_ID Character(15) VARCHAR2(15) NOT NULL Customer Copy ID
3 ADD_DT Date(10) DATE Customer Added On
4 PM_DIVISION Character(15) VARCHAR2(15) NOT NULL Division

Prompt Table: PM_DIVISION

5 PM_REGION Character(10) VARCHAR2(10) NOT NULL Region

Prompt Table: CUST_REGION_VW

6 PM_TERRITORY Character(15) VARCHAR2(15) NOT NULL Territory

Prompt Table: PM_TERRITORY

7 PM_SYNDICATED_TYPE Character(3) VARCHAR2(3) NOT NULL Syndicated Data Type

Prompt Table: PM_SYNDICATED

8 PM_SYNDICATED_NUM Character(15) VARCHAR2(15) NOT NULL Syndicated Number
9 CLASSIFICATION Character(10) VARCHAR2(10) NOT NULL Classification

Prompt Table: PM_CLASSIFICATE