ORIGIN_AP_1

(SQL View)
Index Back

AP Origin Definition


SELECT SETID , ORIGIN , DESCR , DESCRSHORT , DEPTID FROM PS_ORIGIN_PROCURE

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

    Prompt Table: SP_SETID_NONVW

    2 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_AP

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department