LM_CI_IDLM_ACT_IDLM_DMTHD_TYPE_IDLM_SRCHDMTHD_VW(SQL View) |
Index Back |
|---|---|
Search: View CI Delivery MethdSearch view for delivery method. |
| SELECT C1.LM_CI_ID , A1.LM_ACT_ID , DMTYP1.LM_DMTHD_TYPE_ID , DMTYP1.LM_DM_LONG_NM FROM PS_LM_CI_TBL C1 , PS_LM_DMTHD_ALL_VW DMALL1 , PS_LM_DMTH_TYP_TBL DMTYP1 , PS_LM_ACT A1 WHERE %Sql(LM_SRCHDMTHD_SQL,C1,DMALL1,DMTYP1,A1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 2 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 3 | LM_DMTHD_TYPE_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method Type ID - This is a unique identifier for each delivery method type |
| 4 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |