EM_VCHR_PRO_VW (SQL View)	Index Back
eSettlements Voucher Proposals eSettlements Voucher Proposals

EM_VCHR_PRO_VW

(SQL View)

eSettlements Voucher Proposals

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.INVOICE_DT , A.GROSS_AMT , A.DSCNT_AMT , A.ENTERED_DT , A.VOUCHER_STYLE , A.PYMNT_TERMS_CD , A.ENTRY_STATUS , A.CLOSE_STATUS , A.PROCESS_MAN_CLOSE , B.PROPOSE_ID , B.PROPOSAL_STATUS , B.PYMNT_TERMS_CD , B.EXPIRATION_DATE FROM PS_VOUCHER A , PS_EM_PROPOSAL_VW B WHERE A.BUSINESS_UNIT = B.EM_BUSINESS_UNIT (+) AND A.VOUCHER_ID = B.VOUCHER_ID (+)

# 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 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

7 INVOICE_DT Date(10) DATE Invoice Date

8 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount

9 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount

10 ENTERED_DT Date(10) DATE Entered on

11 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher

12 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.

13 ENTRY_STATUS Character(1) VARCHAR2(1) NOT NULL If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted

14 CLOSE_STATUS Character(1) VARCHAR2(1) NOT NULL Close Status Indicator
C=Closed
O=Open

15 PROCESS_MAN_CLOSE Character(1) VARCHAR2(1) NOT NULL Process Manual Close
N=No
P=Processed
Y=Yes

16 PROPOSE_ID Character(8) VARCHAR2(8) NOT NULL Propose ID

17 PROPOSAL_STATUS Character(1) VARCHAR2(1) NOT NULL Proposal Status:
A=Approved
C=Cancelled
D=Denied
P=Pending
S=Submitted

18 PYMNT_TERMS_CD2 Character(5) VARCHAR2(5) NOT NULL Settlement Terms Code used in Vendor Rebate Agreement (For AR)

19 EXPIRATION_DATE Date(10) DATE Expiration Date

#	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	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
4	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
6	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
7	INVOICE_DT	Date(10)	DATE	Invoice Date
8	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
9	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
10	ENTERED_DT	Date(10)	DATE	Entered on
11	VOUCHER_STYLE	Character(4)	VARCHAR2(4) NOT NULL	Voucher Style ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher
12	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.
13	ENTRY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down. C=Complete D=Through batch defaults E=Edited by Batch Voucher Module L=Reviewed through Maintenance M=Modified O=Open P=Postable R=Recycle S=Scheduled for Payment T=Template Voucher X=Deleted
14	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open
15	PROCESS_MAN_CLOSE	Character(1)	VARCHAR2(1) NOT NULL	Process Manual Close N=No P=Processed Y=Yes
16	PROPOSE_ID	Character(8)	VARCHAR2(8) NOT NULL	Propose ID
17	PROPOSAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Proposal Status: A=Approved C=Cancelled D=Denied P=Pending S=Submitted
18	PYMNT_TERMS_CD2	Character(5)	VARCHAR2(5) NOT NULL	Settlement Terms Code used in Vendor Rebate Agreement (For AR)
19	EXPIRATION_DATE	Date(10)	DATE	Expiration Date