CORP_CUST_VW

(SQL View)
Index Back

AR Corporate Customers (Tree)


SELECT t.setid , t.tree_node , t.effdt , d.descr , d.cr_analyst , d.collector , d.sales_person , t.tree_node_num , t.tree_node_num_end FROM PSTREENODE t , ps_corp_node_ar d WHERE t.tree_name = 'AR_CORPORATE_CUST' AND t.effdt = ( SELECT MAX(effdt) FROM PSTREENODE WHERE setid = t.setid AND tree_name = t.tree_name AND effdt <= %CurrentDateIn) AND t.tree_node_num > 1 AND d.setid = t.setid AND d.tree_node = t.tree_node

# 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 CORP_CUST Character(20) VARCHAR2(20) NOT NULL Corporate Customer
3 EFFDT Date(10) DATE Effective Date
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 CR_ANALYST Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
6 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.
7 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
8 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
9 TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range number