LM_DMTHD_IDPrompt Table: LM_DMTH_TYP_VW
LM_DMTH_TYP_VW(SQL View) |
Index Back |
|---|---|
View of Deliv Meth TypeTableView of Delivery Method Table LM_DMTH_TYP_TBL |
| SELECT LM_DMTHD_TYPE_ID , LM_DM_LONG_NM , LM_DM_SHRT_NM , LM_ROW_MAINT_DTTM FROM PS_LM_DMTH_TYP_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_DMTHD_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method
Prompt Table: LM_DMTH_TYP_VW |
| 2 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |
| 3 | LM_DM_SHRT_NM | Character(10) | VARCHAR2(10) NOT NULL | Short Name - Short Name of a Delivery Method Type |
| 4 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |