SPA_INVID_VW(SQL View) |
Index Back |
|---|---|
Invoice ID ViewInvoice ID View |
| SELECT A.BUSINESS_UNIT , A.INVOICE_ID , B.DESCR , A.VENDOR_ID , C.NAME1 , A.INVOICE_STATUS FROM PS_SPF_INVOICE_HDR A , PS_BUS_UNIT_TBL_FS B , PS_VENDOR C , PS_SET_CNTRL_GROUP D WHERE A.INVOICE_STATUS IN ('2', '3') AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.SETID = D.SETID AND C.VENDOR_ID = A.VENDOR_ID AND D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.REC_GROUP_ID = 'FS_38' |
| # | 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 |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPM_BU_SNW_VW |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | INVOICE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Invoice Status
0=Submitted to Enterprise 1=Generated 10=Canceled 11=Adjusted 2=Approved 3=Processed 4=Paid 5=Submitted 6=Denied 7=Submitted to Supplier 8=Approved by Supplier 9=Denied by Supplier |