SPF_INV_WO_VW(SQL View) |
Index Back |
|---|---|
Invoice/Work Order cross ref.Invoice - Work Order cross reference |
| SELECT A.BUSINESS_UNIT , A.INVOICE_ID , A.INVOICE_LINE , A.TIME_SHEET_ID , A.LINE_NBR , A.INV_LINE_STATUS , B.PERIOD_END_DT , B.PERSON_ID , E.WO_CLIID , E.WORK_ORDER_ID FROM PS_SPF_INVOICE_DTL A , PS_SPA_TIME_HDR B , PS_SPB_PERSON_TBL C , PS_SPA_TIME_DTL D , PS_SPF_WORDERREC E WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND B.PERSON_ID = C.PERSON_ID AND A.TIME_SHEET_ID = D.TIME_SHEET_ID AND A.LINE_NBR = D.LINE_NBR AND D.WORK_ORDER_ID = E.WORK_ORDER_ID AND A.BUSINESS_UNIT = E.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_SP |
| 2 | INVOICE_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Invoice Number
Default Value: SPF_INVOICE_HDR.INVOICE_ID |
| 3 | INVOICE_LINE |
Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 4 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
Default Value: EX_TIME_HDR.TIME_SHEET_ID |
| 5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | INV_LINE_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Invoice Line Status
1=Generated 10=Adjusted by Ent Approver 11=Adjusted by Enterprise 2=Approved by Enterprise 3=Submitted to Enterprise 4=Denied by Enterprise 5=Submitted to Supplier 6=Approved by Supplier 7=Denied by Supplier 8=Canceled 9=Adjusted by Supplier |
| 7 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 8 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 9 | WO_CLIID | Character(30) | VARCHAR2(30) NOT NULL | Requester |
| 10 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |