CUST_AN_VW

(SQL View)
Index Back

Customer AutoNum View


select a.setid, a.beg_seq, a.descr from PS_AUTO_NUM_TBL a where a.num_type='CUST'

  • Related Language Record: CUST_AN_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 CUST_BEG_SEQ Character(15) VARCHAR2(15) NOT NULL Beginning Sequence
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description