EM_PV_QUERY_VW

(SQL View)
 Index Back

Pre-Validation Summary

Pre-Validation Summary

SELECT S.BATCH_SEQ_NUM ,S.VH_SEQ_NUM ,S.ERROR_COUNT ,S.INVOICE_ID ,S.INVOICE_DT ,S.VOUCHER_ID ,H.PROCESS_DATE ,H.PRIMARY_TMPLT_ID ,H.TMPLT_ID ,H.BUSINESS_UNIT ,H.DESCR ,H.VENDOR_SETID ,H.VENDOR_ID ,H.NAME1 ,H.VNDR_LOC ,S.ATTACHUSERFILE ,S.DTTM_STAMP FROM PS_EM_BAT_SUMMARY S , PS_EM_BAT_HDR_STG H WHERE H.BATCH_SEQ_NUM = S.BATCH_SEQ_NUM UNION SELECT 0 ,0 ,A.ERROR_COUNT ,A.INVOICE_ID ,A.INVOICE_DT ,' ' ,%DatePart(A.DTTM_STAMP) ,' ' ,' ' ,A.BUSINESS_UNIT ,' ' ,A.VENDOR_SETID ,A.VENDOR_ID ,A.NAME1 ,A.VNDR_LOC ,A.ATTACHUSERFILE ,A.DTTM_STAMP FROM PS_EM_VCHRIN_SUMM A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BATCH_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Batch Number
2 VH_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Data Sequence Number
3 ERROR_COUNT Number(9,0) DECIMAL(9) NOT NULL Error Count
4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
5 INVOICE_DT Date(10) DATE Invoice Date
6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 PROCESS_DATE Date(10) DATE Process Date
8 PRIMARY_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Primary Template ID
9 TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Template ID
10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
13 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
14 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
15 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
16 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
17 DTTM_STAMP DateTime(26) TIMESTAMP 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.