LM_LELW_VNDR_SH

(SQL View)
 Index Back

Vendor View


SELECT A.HRS_VENDOR_ID , A.HRS_VENDOR_LNAME , A.HRS_VENDOR_SNAME , A.HRS_VENDOR_DESCR , A.HRS_VENDOR_STATUS , B.LM_LELW_OPT_LBL_1 , B.LM_LELW_OPT_LBL_2 , B.LM_LELW_OPT_LBL_3 , B.LM_LELW_OPT_LBL_4 , B.LM_LELW_OPT_LBL_5 , B.LM_LELW_OPT_LBL_6 , B.LM_LELW_OPT_LBL_7 , B.LM_LELW_OPT_LBL_8 , B.LM_LELW_OPT_LBL_9 , B.LM_LELW_OPT_LBL_10 , B.LM_LELW_OPT_LBL_11 , B.LM_LELW_OPT_LBL_12 , B.LM_LELW_OPT_LBL_13 , B.LM_LELW_OPT_LBL_14 , B.LM_LELW_OPT_LBL_15 , B.LM_LELW_OPT_LBL_16 , B.LM_LELW_OPT_LBL_17 , B.LM_LELW_OPT_LBL_18 , B.LM_LELW_OPT_LBL_19 , B.LM_LELW_OPT_LBL_20 , B.LM_LELW_OPT_LBL_21 , B.LM_LELW_OPT_LBL_22 , B.LM_LELW_OPT_LBL_23 , B.LM_LELW_OPT_LBL_24 , B.LM_LELW_OPT_LBL_25 , B.LM_LELW_OPT_LBL_26 , B.LM_LELW_OPT_LBL_27 , B.LM_LELW_OPT_LBL_28 , B.LM_LELW_OPT_LBL_29 , B.LM_LELW_OPT_LBL_30 , B.LM_LELW_OPT_1 , B.LM_LELW_OPT_2 , B.LM_LELW_OPT_3 , B.LM_LELW_OPT_4 , B.LM_LELW_OPT_5 , B.LM_LELW_OPT_6 , B.LM_LELW_OPT_7 , B.LM_LELW_OPT_8 , B.LM_LELW_OPT_9 , B.LM_LELW_OPT_10 , B.LM_LELW_OPT_11 , B.LM_LELW_OPT_12 , B.LM_LELW_OPT_13 , B.LM_LELW_OPT_14 , B.LM_LELW_OPT_15 , B.LM_LELW_OPT_16 , B.LM_LELW_OPT_17 , B.LM_LELW_OPT_18 , B.LM_LELW_OPT_19 , B.LM_LELW_OPT_20 , B.LM_LELW_OPT_21 , B.LM_LELW_OPT_22 , B.LM_LELW_OPT_23 , B.LM_LELW_OPT_24 , B.LM_LELW_OPT_25 , B.LM_LELW_OPT_26 , B.LM_LELW_OPT_27 , B.LM_LELW_OPT_28 , B.LM_LELW_OPT_29 , B.LM_LELW_OPT_30 , B.LM_LELW_ACTIVE_1 , B.LM_LELW_ACTIVE_2 , B.LM_LELW_ACTIVE_3 , B.LM_LELW_ACTIVE_4 , B.LM_LELW_ACTIVE_5 , B.LM_LELW_ACTIVE_6 , B.LM_LELW_ACTIVE_7 , B.LM_LELW_ACTIVE_8 , B.LM_LELW_ACTIVE_9 , B.LM_LELW_ACTIVE_10 , B.LM_LELW_ACTIVE_11 , B.LM_LELW_ACTIVE_12 , B.LM_LELW_ACTIVE_13 , B.LM_LELW_ACTIVE_14 , B.LM_LELW_ACTIVE_15 , B.LM_LELW_ACTIVE_16 , B.LM_LELW_ACTIVE_17 , B.LM_LELW_ACTIVE_18 , B.LM_LELW_ACTIVE_19 , B.LM_LELW_ACTIVE_20 , B.LM_LELW_ACTIVE_21 , B.LM_LELW_ACTIVE_22 , B.LM_LELW_ACTIVE_23 , B.LM_LELW_ACTIVE_24 , B.LM_LELW_ACTIVE_25 , B.LM_LELW_ACTIVE_26 , B.LM_LELW_ACTIVE_27 , B.LM_LELW_ACTIVE_28 , B.LM_LELW_ACTIVE_29 , B.LM_LELW_ACTIVE_30 , B.LM_LELW_SSTR_LBL_1 , B.LM_LELW_SSTR_LBL_2 , B.LM_LELW_SSTR_LBL_3 , B.LM_LELW_SSTR_ACT_1 , B.LM_LELW_SSTR_ACT_2 , B.LM_LELW_SSTR_ACT_3 , B.LM_LELW_NBR_LBL_1 , B.LM_LELW_NBR_LBL_2 , B.LM_LELW_NBR_ACT_1 , B.LM_LELW_NBR_ACT_2 , B.LM_LELW_LSTR_LBL_1 , B.LM_LELW_LSTR_ACT , B.LM_LELW_ADMIN_ID , B.LM_LELW_ADMIN_PWD , B.LM_LELW_SITE_KEY , B.LM_LELW_VI_ROUTE , B.LM_LELW_VI_NAME FROM PS_HRS_VENDOR A , PS_LM_VENDOR_EXTD B WHERE A.HRS_VENDOR_ID = B.HRS_VENDOR_ID AND A.HRS_VERSION = B.HRS_VERSION

  • Related Language Record: LM_LELW_VNDR_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LELW_VNDR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID
    2 LM_LELW_LONG_NM Character(244) VARCHAR2(244) NOT NULL Long Name
    3 LM_LELW_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name
    4 LM_LELW_DESCR Character(254) VARCHAR2(254) NOT NULL Description
    5 LM_LELW_STATUS Character(3) VARCHAR2(3) NOT NULL Status
    10=Active
    20=Inactive

    Default Value: 20

    6 LM_LELW_OPT_LBL_1 Character(30) VARCHAR2(30) NOT NULL Options Label (1)
    7 LM_LELW_OPT_LBL_2 Character(30) VARCHAR2(30) NOT NULL Options Label (2)
    8 LM_LELW_OPT_LBL_3 Character(30) VARCHAR2(30) NOT NULL Options Label (3)
    9 LM_LELW_OPT_LBL_4 Character(30) VARCHAR2(30) NOT NULL Options Label (4)
    10 LM_LELW_OPT_LBL_5 Character(30) VARCHAR2(30) NOT NULL Options Label (5)
    11 LM_LELW_OPT_LBL_6 Character(30) VARCHAR2(30) NOT NULL Options Label 6
    12 LM_LELW_OPT_LBL_7 Character(30) VARCHAR2(30) NOT NULL Options Label (7)
    13 LM_LELW_OPT_LBL_8 Character(30) VARCHAR2(30) NOT NULL Options Label (8)
    14 LM_LELW_OPT_LBL_9 Character(30) VARCHAR2(30) NOT NULL Options Label 9
    15 LM_LELW_OPT_LBL_10 Character(30) VARCHAR2(30) NOT NULL Options Label 10
    16 LM_LELW_OPT_LBL_11 Character(30) VARCHAR2(30) NOT NULL Options Label (11)
    17 LM_LELW_OPT_LBL_12 Character(30) VARCHAR2(30) NOT NULL Options Label (12)
    18 LM_LELW_OPT_LBL_13 Character(30) VARCHAR2(30) NOT NULL Options Label (13)
    19 LM_LELW_OPT_LBL_14 Character(30) VARCHAR2(30) NOT NULL Options Label (14)
    20 LM_LELW_OPT_LBL_15 Character(30) VARCHAR2(30) NOT NULL Options Label (15)
    21 LM_LELW_OPT_LBL_16 Character(30) VARCHAR2(30) NOT NULL Options Label (16)
    22 LM_LELW_OPT_LBL_17 Character(30) VARCHAR2(30) NOT NULL Options Label 17
    23 LM_LELW_OPT_LBL_18 Character(30) VARCHAR2(30) NOT NULL Options Label (18)
    24 LM_LELW_OPT_LBL_19 Character(30) VARCHAR2(30) NOT NULL Options Label (19)
    25 LM_LELW_OPT_LBL_20 Character(30) VARCHAR2(30) NOT NULL Options Label (20)
    26 LM_LELW_OPT_LBL_21 Character(30) VARCHAR2(30) NOT NULL Options Label (21)
    27 LM_LELW_OPT_LBL_22 Character(30) VARCHAR2(30) NOT NULL Options Label (22)
    28 LM_LELW_OPT_LBL_23 Character(30) VARCHAR2(30) NOT NULL Options Label (23)
    29 LM_LELW_OPT_LBL_24 Character(30) VARCHAR2(30) NOT NULL Options Label (24)
    30 LM_LELW_OPT_LBL_25 Character(30) VARCHAR2(30) NOT NULL Options Label (25)
    31 LM_LELW_OPT_LBL_26 Character(30) VARCHAR2(30) NOT NULL Options Label (26)
    32 LM_LELW_OPT_LBL_27 Character(30) VARCHAR2(30) NOT NULL Options Label (27)
    33 LM_LELW_OPT_LBL_28 Character(30) VARCHAR2(30) NOT NULL Options Label (28)
    34 LM_LELW_OPT_LBL_29 Character(30) VARCHAR2(30) NOT NULL Options Label (29)
    35 LM_LELW_OPT_LBL_30 Character(30) VARCHAR2(30) NOT NULL Options Label (30)
    36 LM_LELW_OPT_1 Character(1) VARCHAR2(1) NOT NULL Options Default (1)

    Y/N Table Edit

    37 LM_LELW_OPT_2 Character(1) VARCHAR2(1) NOT NULL Options Default (2)

    Y/N Table Edit

    38 LM_LELW_OPT_3 Character(1) VARCHAR2(1) NOT NULL Options Default (3)

    Y/N Table Edit

    39 LM_LELW_OPT_4 Character(1) VARCHAR2(1) NOT NULL Options Default (4)

    Y/N Table Edit

    40 LM_LELW_OPT_5 Character(1) VARCHAR2(1) NOT NULL Options Default (5)

    Y/N Table Edit

    41 LM_LELW_OPT_6 Character(1) VARCHAR2(1) NOT NULL Options Default (6)

    Y/N Table Edit

    42 LM_LELW_OPT_7 Character(1) VARCHAR2(1) NOT NULL Options Default (7)

    Y/N Table Edit

    43 LM_LELW_OPT_8 Character(1) VARCHAR2(1) NOT NULL Options Default (8)

    Y/N Table Edit

    44 LM_LELW_OPT_9 Character(1) VARCHAR2(1) NOT NULL Options Label (9)

    Y/N Table Edit

    45 LM_LELW_OPT_10 Character(1) VARCHAR2(1) NOT NULL Options Label (10)

    Y/N Table Edit

    46 LM_LELW_OPT_11 Character(1) VARCHAR2(1) NOT NULL Options Default (11)

    Y/N Table Edit

    47 LM_LELW_OPT_12 Character(1) VARCHAR2(1) NOT NULL Options Default (12)

    Y/N Table Edit

    48 LM_LELW_OPT_13 Character(1) VARCHAR2(1) NOT NULL Options Default (13)

    Y/N Table Edit

    49 LM_LELW_OPT_14 Character(1) VARCHAR2(1) NOT NULL Options Default (14)

    Y/N Table Edit

    50 LM_LELW_OPT_15 Character(1) VARCHAR2(1) NOT NULL Options Default (15)

    Y/N Table Edit

    51 LM_LELW_OPT_16 Character(1) VARCHAR2(1) NOT NULL Options Default (16)

    Y/N Table Edit

    52 LM_LELW_OPT_17 Character(1) VARCHAR2(1) NOT NULL Options Default (17)

    Y/N Table Edit

    53 LM_LELW_OPT_18 Character(1) VARCHAR2(1) NOT NULL Options Default (18)

    Y/N Table Edit

    54 LM_LELW_OPT_19 Character(1) VARCHAR2(1) NOT NULL Options Default (19)

    Y/N Table Edit

    55 LM_LELW_OPT_20 Character(1) VARCHAR2(1) NOT NULL Options Default (20)

    Y/N Table Edit

    56 LM_LELW_OPT_21 Character(1) VARCHAR2(1) NOT NULL Options Default (21)

    Y/N Table Edit

    57 LM_LELW_OPT_22 Character(1) VARCHAR2(1) NOT NULL Options Default (22)

    Y/N Table Edit

    58 LM_LELW_OPT_23 Character(1) VARCHAR2(1) NOT NULL Options Default (23)

    Y/N Table Edit

    59 LM_LELW_OPT_24 Character(1) VARCHAR2(1) NOT NULL Options Default (24)

    Y/N Table Edit

    60 LM_LELW_OPT_25 Character(1) VARCHAR2(1) NOT NULL Options Default (25)

    Y/N Table Edit

    61 LM_LELW_OPT_26 Character(1) VARCHAR2(1) NOT NULL Options Default (26)

    Y/N Table Edit

    62 LM_LELW_OPT_27 Character(1) VARCHAR2(1) NOT NULL Options Default (27)

    Y/N Table Edit

    63 LM_LELW_OPT_28 Character(1) VARCHAR2(1) NOT NULL Options Default (28)

    Y/N Table Edit

    64 LM_LELW_OPT_29 Character(1) VARCHAR2(1) NOT NULL Options Default (29)

    Y/N Table Edit

    65 LM_LELW_OPT_30 Character(1) VARCHAR2(1) NOT NULL Options Default (30)

    Y/N Table Edit

    66 LM_LELW_ACTIVE_1 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE

    Y/N Table Edit

    Default Value: N

    67 LM_LELW_ACTIVE_2 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (2)

    Y/N Table Edit

    Default Value: N

    68 LM_LELW_ACTIVE_3 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (3)

    Y/N Table Edit

    Default Value: N

    69 LM_LELW_ACTIVE_4 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (4)

    Y/N Table Edit

    Default Value: N

    70 LM_LELW_ACTIVE_5 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (5)

    Y/N Table Edit

    Default Value: N

    71 LM_LELW_ACTIVE_6 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (6)

    Y/N Table Edit

    Default Value: N

    72 LM_LELW_ACTIVE_7 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (7)

    Y/N Table Edit

    Default Value: N

    73 LM_LELW_ACTIVE_8 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (8)

    Y/N Table Edit

    Default Value: N

    74 LM_LELW_ACTIVE_9 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (9)

    Y/N Table Edit

    Default Value: N

    75 LM_LELW_ACTIVE_10 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (10)

    Y/N Table Edit

    Default Value: N

    76 LM_LELW_ACTIVE_11 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (11)

    Y/N Table Edit

    Default Value: N

    77 LM_LELW_ACTIVE_12 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (12)

    Y/N Table Edit

    Default Value: N

    78 LM_LELW_ACTIVE_13 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (13)

    Y/N Table Edit

    Default Value: N

    79 LM_LELW_ACTIVE_14 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (14)

    Y/N Table Edit

    Default Value: N

    80 LM_LELW_ACTIVE_15 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (15)

    Y/N Table Edit

    Default Value: N

    81 LM_LELW_ACTIVE_16 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (16)

    Y/N Table Edit

    Default Value: N

    82 LM_LELW_ACTIVE_17 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (17)

    Y/N Table Edit

    Default Value: N

    83 LM_LELW_ACTIVE_18 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (18)

    Y/N Table Edit

    Default Value: N

    84 LM_LELW_ACTIVE_19 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (19)

    Y/N Table Edit

    Default Value: N

    85 LM_LELW_ACTIVE_20 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (20)

    Y/N Table Edit

    Default Value: N

    86 LM_LELW_ACTIVE_21 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (21)

    Y/N Table Edit

    Default Value: N

    87 LM_LELW_ACTIVE_22 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (22)

    Y/N Table Edit

    Default Value: N

    88 LM_LELW_ACTIVE_23 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (23)

    Y/N Table Edit

    Default Value: N

    89 LM_LELW_ACTIVE_24 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (24)

    Y/N Table Edit

    Default Value: N

    90 LM_LELW_ACTIVE_25 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (25)

    Y/N Table Edit

    Default Value: N

    91 LM_LELW_ACTIVE_26 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (26)

    Y/N Table Edit

    Default Value: N

    92 LM_LELW_ACTIVE_27 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (27)

    Y/N Table Edit

    Default Value: N

    93 LM_LELW_ACTIVE_28 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (28)

    Y/N Table Edit

    Default Value: N

    94 LM_LELW_ACTIVE_29 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (29)

    Y/N Table Edit

    Default Value: N

    95 LM_LELW_ACTIVE_30 Character(1) VARCHAR2(1) NOT NULL OPTION ACTIVE (30)

    Y/N Table Edit

    Default Value: N

    96 LM_LELW_SSTR_LBL_1 Character(30) VARCHAR2(30) NOT NULL Short String Label (1)
    97 LM_LELW_SSTR_LBL_2 Character(30) VARCHAR2(30) NOT NULL Short String Label (2)
    98 LM_LELW_SSTR_LBL_3 Character(30) VARCHAR2(30) NOT NULL Short String Label (3)
    99 LM_LELW_SSTR_ACT_1 Character(1) VARCHAR2(1) NOT NULL Short String Active 1

    Y/N Table Edit

    Default Value: N

    100 LM_LELW_SSTR_ACT_2 Character(1) VARCHAR2(1) NOT NULL Short String Active 2

    Y/N Table Edit

    Default Value: N

    101 LM_LELW_SSTR_ACT_3 Character(1) VARCHAR2(1) NOT NULL Short String Active 3

    Y/N Table Edit

    Default Value: N

    102 LM_LELW_NBR_LBL_1 Character(30) VARCHAR2(30) NOT NULL Number Label (1)
    103 LM_LELW_NBR_LBL_2 Character(30) VARCHAR2(30) NOT NULL Number Label 2
    104 LM_LELW_NBR_ACT_1 Character(1) VARCHAR2(1) NOT NULL Number Active 1

    Y/N Table Edit

    Default Value: N

    105 LM_LELW_NBR_ACT_2 Character(1) VARCHAR2(1) NOT NULL Number Active 2

    Y/N Table Edit

    Default Value: N

    106 LM_LELW_LSTR_LBL_1 Character(30) VARCHAR2(30) NOT NULL Long String Label
    107 LM_LELW_LSTR_ACT Character(1) VARCHAR2(1) NOT NULL Long String Active

    Y/N Table Edit

    Default Value: N

    108 LM_LELW_ADMIN_ID Character(30) VARCHAR2(30) NOT NULL Admin User ID
    109 LM_LELW_ADMIN_PWD Character(30) VARCHAR2(30) NOT NULL Admin Password
    110 LM_LELW_SITE_KEY Character(50) VARCHAR2(50) NOT NULL Site Key
    111 LM_LELW_VI_ROUTE Character(254) VARCHAR2(254) NOT NULL Vendor Route URL
    112 LM_LELW_VI_NAME Character(254) VARCHAR2(254) NOT NULL Vendor Internal Name