BUSINESS_UNITWO_IDWM_ATT_WOTXN_VW(SQL View) |
Index Back |
|---|---|
WM Attachments WO Trxn View |
| SELECT A.BUSINESS_UNIT, A.WO_ID, A.ATTACHSYSFILENAME FROM PS_WM_WO_ATTACH A UNION ALL SELECT B.BUSINESS_UNIT, B.WO_ID, B.ATTACHSYSFILENAME FROM PS_WM_TSK_ATTACH B UNION ALL SELECT C.BUSINESS_UNIT, C.WO_ID, C.ATTACHSYSFILENAME FROM PS_WM_WO_INSPC_ATT C |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |