SPF_INV_ID_VW(SQL View) |
Index Back |
|---|---|
Invoice ID Views EnterpriseInvoice ID Views Enterprise |
| SELECT BUSINESS_UNIT , VENDOR_ID , INVOICE_ID , INVOICE_DT , INVOICE_STATUS FROM PS_SPF_INVOICE_HDR WHERE INVOICE_STATUS IN ('2', '3') |
| # | 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 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPM_BU_SNW_VW |
| 3 | INVOICE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 4 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 5 | 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 |