EM_XML_UPLD_VW

(SQL View)
 Index Back

eS - Supplier Attachments

eSettlements Supplier Supplier Attachments

SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.EM_XML_UPLD_DTTM , A.EM_XML_PROC_DTTM , A.EM_XML_UPLD_TYPE , '2' , A.OPRID , A.ATTACHSYSFILENAME , A.ATTACHUSERFILE FROM PS_EM_XML_ATT_P A UNION SELECT B.SETID , B.VENDOR_ID , B.VNDR_LOC , B.EM_XML_UPLD_DTTM , %DateTimeNull , ' ' , '1' , B.FMS_OPRID , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE FROM PS_EM_XML_ATT_VW B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 EM_XML_UPLD_DTTM DateTime(26) TIMESTAMP Upload DateTime
5 EM_XML_PROC_DTTM DateTime(26) TIMESTAMP Process DateTime
6 EM_XML_UPLD_TYPE Character(1) VARCHAR2(1) NOT NULL XML Upload Type
C=CXML
X=XML
7 EM_XML_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
1=Pending
2=Processed
3=Success
4=Error
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
10 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File