SALES_PERSN_VW

(SQL View)
Index Back

Sales People w/Name


select distinct sales_person, effdt, eff_status, name1 from PS_SALES_PERSN_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.

Prompt Table: SALES_PERSN_TBL

2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

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