EM_S_XTRCT_VW(SQL View) |
Index Back |
|---|---|
Supplier Invoice Extract ViewInquiry view of extracted invoices for Suppliers. |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.DTTM_STAMP , A.VENDOR_SETID , A.VENDOR_ID , A.APPR_STATUS , A.MATCH_STATUS , B.PYMNT_CNT , B.PYMNT_STATUS , B.PYMNT_DT , A.PROCESS_INSTANCE FROM PS_EM_EXT_SELL A , PS_EM_EXT_SELL_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.DTTM_STAMP = B.DTTM_STAMP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | DTTM_STAMP |
DateTime(26) | TIMESTAMP NOT NULL | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved D=Denied P=Pending |
| 7 | MATCH_STATUS_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Match Status
C=Overridden - Credit Note D=Match Dispute E=Match Exceptions Exist M=Matched N=Not Applicable O=Manually Overridden T=To Be Matched |
| 8 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 9 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 10 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 11 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |