EM_VCHR_HDRQV_V (SQL View)	Index Back
EC Voucher Header

EM_VCHR_HDRQV_V

(SQL View)

EC Voucher Header

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.INVOICE_DT , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.ADDRESS_SEQ_NUM , A.REMIT_ADDR_SEQ_NUM , A.ORIGIN , A.OPRID , A.ACCOUNTING_DT , A.GROSS_AMT , A.DSCNT_AMT , A.SALETX_AMT , A.FREIGHT_AMT , A.PYMNT_TERMS_CD , B.PYMNT_METHOD , A.TXN_CURRENCY_CD , A.VAT_ENTRD_AMT , A.DSCNT_AMT_FLG , A.DUE_DT , A.DSCNT_DUE_DT , A.VAT_CALC_TYPE , A.VAT_RECOVERY_PCT , A.DESCR254_MIXED , A.MISC_CHRG_AMT , A.VCHR_PREPAY_AMT , A.VOUCHER_STYLE , A.DOC_TYPE , A.DSCNT_PRORATE_FLG , A.VCHR_SRC , A.PREPAID_AUTO_APPLY , A.PREPAID_REF , A.TAX_PYMNT_TYPE , A.VAT_CF_ANLSYS_TYPE , A.VAT_ROUND_RULE , A.VAT_TREATMENT_GRP , A.VOUCHER_TYPE , A.VCHR_QV_TEMPLATE FROM PS_VCHR_HDR_QV A , PS_EM_AGREEMENT B WHERE A.VCHR_SRC IN ('XML','SSI') AND B.SETID = A.BUSINESS_UNIT AND B.VENDOR_ID = A.VENDOR_ID

# 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_BUVNAGRT2_VW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

4 INVOICE_DT Date(10) DATE NOT NULL Invoice Date

5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
Default Value: VENDOR.SETID

6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: EM_VNLNM_USR_VW

7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
Prompt Table: VNDR_LOC_AP_VW

8 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Prompt Table: VENDOR_ADDR_VW

9 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location

10 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
Prompt Table: ORIGIN_AP

11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

12 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

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

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

15 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount

16 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount

17 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.
Prompt Table: PYMT_TR_EFF_VW

18 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

19 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
Default Value: OPR_DEF_TBL_AP.CURRENCY_CD
Prompt Table: CURR_TXN_VW

20 VAT_ENTRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Entered VAT Amount

21 DSCNT_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Discount Amount Control
T=Controlled by Payment Terms
U=User Specified

22 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

23 DSCNT_DUE_DT Date(10) DATE Discount Due Date

24 VAT_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL "A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive

25 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent

26 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description

27 MISC_CHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc Charge Amount

28 VCHR_PREPAY_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Prepay Amount

29 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

30 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

31 DSCNT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Discount

32 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
Default Value: QUCK

33 PREPAID_AUTO_APPLY Character(1) VARCHAR2(1) NOT NULL Automatically Apply Prepayment

34 PREPAID_REF Character(10) VARCHAR2(10) NOT NULL Prepayment Reference

35 TAX_PYMNT_TYPE Character(5) VARCHAR2(5) NOT NULL Tax Payment Type Code

36 VAT_CF_ANLSYS_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Chartfield Analysis
E=Use Expense Line Chartfields
N=Not Applicable
V=Use VAT Accounting Chartfields

37 VAT_ROUND_RULE Character(1) VARCHAR2(1) NOT NULL " Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up

38 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group

39 VOUCHER_TYPE Character(1) VARCHAR2(1) NOT NULL Voucher Type
A=Adjustment Voucher
B=Batch Edit Voucher
C=Recurring Voucher
E=ERS Voucher
J=Journal Voucher
N=Reversal Voucher
P=Prepaid Voucher
R=Regular Voucher
T=Third Party Voucher
V=Registered Voucher
X=Template Voucher

40 VCHR_QV_TEMPLATE Character(1) VARCHAR2(1) NOT NULL Quick Invoice Template
C=Complete
M=Summary
S=Simple
Default Value: C

#	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_BUVNAGRT2_VW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
4	INVOICE_DT	Date(10)	DATE NOT NULL	Invoice Date
5	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Default Value: VENDOR.SETID
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: EM_VNLNM_USR_VW
7	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_AP_VW
8	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: VENDOR_ADDR_VW
9	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location
10	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORIGIN_AP
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
12	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
13	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
14	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
15	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
16	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
17	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. Prompt Table: PYMT_TR_EFF_VW
18	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
19	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Default Value: OPR_DEF_TBL_AP.CURRENCY_CD Prompt Table: CURR_TXN_VW
20	VAT_ENTRD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Entered VAT Amount
21	DSCNT_AMT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Discount Amount Control T=Controlled by Payment Terms U=User Specified
22	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
23	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
24	VAT_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount." E=Exclusive I=Inclusive
25	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
26	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
27	MISC_CHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc Charge Amount
28	VCHR_PREPAY_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Prepay Amount
29	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
30	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
31	DSCNT_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Discount
32	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source Default Value: QUCK
33	PREPAID_AUTO_APPLY	Character(1)	VARCHAR2(1) NOT NULL	Automatically Apply Prepayment
34	PREPAID_REF	Character(10)	VARCHAR2(10) NOT NULL	Prepayment Reference
35	TAX_PYMNT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Tax Payment Type Code
36	VAT_CF_ANLSYS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Chartfield Analysis E=Use Expense Line Chartfields N=Not Applicable V=Use VAT Accounting Chartfields
37	VAT_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	" Rounding rule to be applied to VAT calculations. Options are 'Natural' D=Round Down N=Natural Round U=Round Up
38	VAT_TREATMENT_GRP	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment Group
39	VOUCHER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Voucher Type A=Adjustment Voucher B=Batch Edit Voucher C=Recurring Voucher E=ERS Voucher J=Journal Voucher N=Reversal Voucher P=Prepaid Voucher R=Regular Voucher T=Third Party Voucher V=Registered Voucher X=Template Voucher
40	VCHR_QV_TEMPLATE	Character(1)	VARCHAR2(1) NOT NULL	Quick Invoice Template C=Complete M=Summary S=Simple Default Value: C