LM_LELW_VNDR_IDLANGUAGE_CDLM_LELW_VNDR_LG(SQL Table) |
Index Back |
|---|---|
Vendor Setup Table |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | LM_LELW_LONG_NM | Character(244) | VARCHAR2(244) NOT NULL | Long Name |
| 4 | LM_LELW_SHRT_NM | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
| 5 | LM_LELW_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 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_SSTR_LBL_1 | Character(30) | VARCHAR2(30) NOT NULL | Short String Label (1) |
| 37 | LM_LELW_SSTR_LBL_2 | Character(30) | VARCHAR2(30) NOT NULL | Short String Label (2) |
| 38 | LM_LELW_SSTR_LBL_3 | Character(30) | VARCHAR2(30) NOT NULL | Short String Label (3) |
| 39 | LM_LELW_NBR_LBL_1 | Character(30) | VARCHAR2(30) NOT NULL | Number Label (1) |
| 40 | LM_LELW_NBR_LBL_2 | Character(30) | VARCHAR2(30) NOT NULL | Number Label 2 |
| 41 | LM_LELW_LSTR_LBL_1 | Character(30) | VARCHAR2(30) NOT NULL | Long String Label |