SUPP_UDITEM_VW

(SQL View)
 Index Back

Supplier Data Item

Supplier Data Item

SELECT %subrec(CUST_DITEM_SBR, A) FROM PS_SUPP_DATA_ITEM A WHERE A.SYS_DEFINED_FLAG <> 'Y'

  • Related Language Record: SUPP_DITEM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DATA_ITEM_ID Character(8) VARCHAR2(8) NOT NULL Data Item ID
    2 AR_DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DATA_CATEGORY Character(1) VARCHAR2(1) NOT NULL Data Item Category
    A=Activity
    B=Balance
    G=General
    M=Metrics
    U=User
    4 DATA_ITEM_TYPE Character(2) VARCHAR2(2) NOT NULL Data item type
    AC=App Class
    RF=Record Field

    Default Value: RF

    5 MULTI_VALUE_FLAG Character(1) VARCHAR2(1) NOT NULL Multiple Values
    N=No
    Y=Yes

    Default Value: N

    6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFNPVW

    7 FIELDNAME_VALUE Character(18) VARCHAR2(18) NOT NULL Field name

    Prompt Table: PSRECFIELD_VW

    8 FIELDNAME_CURRENCY Character(18) VARCHAR2(18) NOT NULL Field name

    Prompt Table: PSRECFIELD_VW

    9 VALUE_FUNCTION Character(4) VARCHAR2(4) NOT NULL Aggregate Function
    CNT=Count
    MAX=Max
    MIN=Min
    NONE=None
    SUM=Sum
    UCNT=Uniques

    Default Value: NONE

    10 DISPLAY_TEMPLATE Character(254) VARCHAR2(254) NOT NULL Display Template
    11 EXTRA_VALUE_FIELDS Character(254) VARCHAR2(254) NOT NULL Extra Value Fields
    12 KEY_FIELD_MAP Character(128) VARCHAR2(128) NOT NULL Key Field Map
    13 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Package Name

    Prompt Table: PSPACKAGROOT_VW

    14 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL App Package Path

    Default Value: :

    Prompt Table: PSPACKAGPATH_VW

    15 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Class Name

    Prompt Table: PSPACKAGCLAS_VW

    16 PARAM_VALUE Character(16) VARCHAR2(16) NOT NULL Parameter
    17 DEFINITION_TEXT Character(254) VARCHAR2(254) NOT NULL Definition
    18 DEFN_LOCKED_FLG Character(1) VARCHAR2(1) NOT NULL Definition Locked
    N=No
    Y=Yes

    Default Value: N

    19 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
    N=Inactive
    Y=Active

    Default Value: N

    20 SYS_DEFINED_FLAG Character(1) VARCHAR2(1) NOT NULL System defined flag
    N=No
    Y=Yes