SCN_LN_KEY_VW(SQL View) |
Index Back |
|---|---|
Sales Contract Line Delete Key |
| SELECT a.recname FROM psrecfield a , PSRECDEFN b , psrecfield d , psrecfield c WHERE a.fieldname = 'SETID' AND (a.edittable='SP_SETID_NONVW' OR a.edittable='SP_SETID_CLSVW' OR a.edittable='SP_SETID_OPRVW') AND a.fieldnum = 1 AND a.recname = b.recname AND b.rectype = 0 AND b.recname LIKE 'SCON%' AND d.recname=a.recname AND d.fieldname = 'LINE_NBR' AND d.fieldnum = 3 AND c.recname=a.recname AND c.fieldname = 'CNTRCT_ID' AND c.fieldnum = 2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |