CR_ANALYST_VW

(SQL View)
Index Back

No EFFDT credit analysts view

This View should be used when ever prompting for the collector from an effective dated table. Example : CUST_OPTION is an effective dated table. Use this view to prompt for COLLECTOR.

SELECT DISTINCT SETID , CR_ANALYST , NAME1 FROM PS_CR_ANALYST_TBL A WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(CR_ANALYST_TBL X, A, %CurrentDateIn)

# 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 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.

Prompt Table: CR_ANALYST_TBL

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