BUSINESS_UNITWORK_ORDER_IDACTIVITY_IDINVOICE_IDINVOICE_LINESPA_PL_ACTIN_VW(SQL View) |
Index Back |
|---|---|
Progress Log details |
| SELECT I.BUSINESS_UNIT , I.WORK_ORDER_ID , P.ACTIVITY_ID , I.INVOICE_ID , I.INVOICE_LINE , H.INVOICE_DT , I.INV_LINE_AMT , I.CURRENCY_CD , P.PLOG_ID , P.LINE_NBR , P.COMPLETE_DATE FROM PS_SPF_INVOICE_DTL I , PS_SPA_PLOG_DTL P , PS_SPF_INVOICE_HDR H WHERE I.BUSINESS_UNIT = P.BUSINESS_UNIT AND I.PLOG_ID = P.PLOG_ID AND I.LINE_NBR = P.LINE_NBR AND I.BUSINESS_UNIT = H.BUSINESS_UNIT AND I.INVOICE_ID = H.INVOICE_ID AND I.ACTIVITY_ID = P.ACTIVITY_ID AND I.INV_LINE_STATUS = '2' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | INVOICE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 5 | INVOICE_LINE |
Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 6 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 7 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | PLOG_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 10 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 11 | COMPLETE_DATE | Date(10) | DATE | To save the task execution complete date |