AR_SPCLSTS_VW

(SQL View)
Index Back

AR_SPCLSTS_VW


SELECT SETID , AR_SPECIALIST , EFFDT , NAME1 FROM PS_AR_SPECIALIST

# 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
Set Control Field: SETID

2 AR_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Accounts Recievable Specialist - person responsible for an action on an item.
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

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