SPA_TM_WODIST_V(SQL View) |
Index Back |
---|---|
Timesheet Work Order Distrib |
SELECT A.BUSINESS_UNIT ,A.TIME_SHEET_ID ,A.WORK_ORDER_ID ,A.DISTRIB_LINE_NUM ,A.LINE_NBR ,B.DESCR FROM PS_SPA_TIME_DTL A , PS_SPF_WOPO_DISTRB B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID AND A.DISTRIB_LINE_NUM = B.DISTRIB_LINE_NUM |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
3 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
4 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |