EM_QV_BU_SEC_VW(SQL View) |
Index Back |
---|---|
MP - Quick Voucher Search ViewMP - Quick Voucher Search View with BU Security. |
SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , C.OPRID , A.INVOICE_ID , A.GROSS_AMT , A.INVOICE_DT , B.SETID , A.VENDOR_ID , B.VENDOR_NAME_SHORT , B.NAME1 , A.VNDR_LOC , A.VCHR_SRC , ' ' , A.VCHR_BLD_STATUS , A.TXN_CURRENCY_CD , A.PYMNT_TERMS_CD , A.DTTM_CREATED FROM PS_VCHR_HDR_QV A , PS_VENDOR B , PS_SEC_BU_OPR C WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.VENDOR_ID IN ( SELECT D.VENDOR_ID FROM PS_VENDOR_USER D WHERE C.OPRID = D.OPRID) AND A.VCHR_SRC IN ('SSI', 'XML', 'DCM','EXL') AND EXISTS ( SELECT 'X' FROM PS_EM_AGREEMENT AG , PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.REC_GROUP_ID = 'EM_01' AND SC.RECNAME = 'EM_AGREEMENT' AND (SC.SETID = AG.SETID OR A.BUSINESS_UNIT = AG.SETID) AND AG.EM_AGREE_BUYER = 'Y' AND AG.EM_AGREE_SELLER = 'Y' AND AG.VENDOR_SETID = A.VENDOR_SETID AND AG.VENDOR_ID = A.VENDOR_ID AND AG.VNDR_LOC = A.VNDR_LOC) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: EM_BU_VNAGRT_VW |
2 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Default Value: NEXT |
3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
4 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
5 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
6 | INVOICE_DT | Date(10) | DATE | Invoice Date |
7 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: VENDOR.SETID |
8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: EM_VNLNM_USR_VW |
9 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
10 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
11 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: EM_VNDR_LOC_VW |
12 | VCHR_SRC | Character(4) | VARCHAR2(4) NOT NULL | Voucher Source |
13 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
14 | VCHR_BLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Build Status
B=Build Voucher D=Delete Voucher E=Pre-Edit Error H=Tolerance Hold I=Initiated N=Not processed S=Voucher Staged T=Stage Voucher |
15 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
16 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
17 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |