BUSINESS_UNITTIME_SHEET_IDWORK_ORDER_IDLINE_NBRTRCSPF_INV_PAY_VW(SQL View) |
Index Back |
|---|---|
Invoice Pay Types ViewThis View fetches the Pay Types by TRC |
| SELECT DISTINCT D.BUSINESS_UNIT , D.TIME_SHEET_ID , D.WORK_ORDER_ID , D.LINE_NBR , H.TRC , T.SP_PAY_TYPE , T.SP_PAY_TYPE_MULT FROM PS_SPA_TIME_HDR HD , PS_SPA_TIME_DTL D , PS_SPA_TM_DTL_HRLY H , PS_TL_TRC_TBL A , PS_SPA_TRC_PAYTYPE T WHERE HD.BUSINESS_UNIT = D.BUSINESS_UNIT AND HD.TIME_SHEET_ID = D.TIME_SHEET_ID AND D.BUSINESS_UNIT = H.BUSINESS_UNIT AND D.TIME_SHEET_ID = H.TIME_SHEET_ID AND D.WORK_ORDER_ID = H.WORK_ORDER_ID AND D.LINE_NBR = H.LINE_NBR AND D.TIME_LINE_STATUS IN('RAP', 'ADJ') AND D.TE_INVOICE_FLG = 'N' AND D.SPA_BILLING_ACTION = 'B' AND H.TRC = A.TRC AND T.TRC = A.TRC AND T.EFFDT = A.EFFDT AND %EffdtCheck(TL_TRC_TBL B, A, HD.PERIOD_END_DT) AND A.EFF_STATUS = 'A' |
| # | 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 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | TRC |
Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code |
| 6 | SP_PAY_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Pay Types for Supplier Rate Breakdown |
| 7 | SP_PAY_TYPE_MULT | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | Pay Type Multiplication Factor |