LM_ORGANIZATION_IDLM_OWNER_IDLM_CUST_OWNR_VW(SQL View) |
Index Back |
|---|---|
Customer Owner ViewCustomer O |
| SELECT LM_ORGANIZATION_ID , LM_PERSON_ID , NAME , LM_NAME_DISPLAY FROM PS_LM_PERS_DTL_VW WHERE LM_ORG_TYPE = 'CUST' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ORGANIZATION_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 2 | LM_OWNER_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Owner ID |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |