BUSINESS_UNITPLOG_IDLINE_NBRSPF_PL_PGC4_VW(SQL View) |
Index Back |
|---|---|
Progress Log Fluid ApprovalsView create to Show Line(s) data in Page composer for Progress Log Fluid Approvals. Also used as Search record for the fluid Distribution page for actual allocation used in Progress Log Fluid Approvals |
| SELECT A.BUSINESS_UNIT , A.PLOG_ID , A.LINE_NBR , A.ACTIVITY_ID , A.PERCENT_COMPLETE ,' ' , A.SP_BILL_AMOUNT , A.CURRENCY_CD , B.WORK_ORDER_ID , B.WO_NAME ,' ' FROM PS_SPA_PLOG_DTL A , PS_SPF_WORDERREC B , PS_SPA_PLOG_HDR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PLOG_ID = C.PLOG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PLOG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 5 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |
| 6 | SP_PERC_COMPLETE | Character(20) | VARCHAR2(20) NOT NULL | Created For Progress Log Fluid Approvals |
| 7 | SP_BILL_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billable Amount |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 10 | WO_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work Order Name |
| 11 | SP_BILLABLE_AMOUNT | Character(30) | VARCHAR2(30) NOT NULL | Created For Progress Log Fluid Approvals |