ORD_LINE_KEY_VW(SQL View) |
Index Back |
|---|---|
Order Line key view |
| select a.recname from psrecfield a, PSRECDEFN b, psrecfield d, psrecfield c where a.fieldname = 'BUSINESS_UNIT' and (a.edittable='SP_BU_OM_NONVW' or a.edittable='SP_BU_OM_CLSVW' or a.edittable='SP_BU_OM_OPRVW' or a.edittable='BUS_UNIT_TBL_OM') and a.fieldnum = 1 and a.recname = b.recname and b.rectype = 0 and b.recname not like 'AUDIT%' and d.recname=a.recname and d.fieldname = 'ORDER_INT_LINE_NO' and d.fieldnum = 3 and c.recname=a.recname and c.fieldname = 'ORDER_NO' 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). |