EM_VOUCHER_DISP (SQL View)	Index Back
Voucher Display

EM_VOUCHER_DISP

(SQL View)

Voucher Display

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , D.EFFDT , A.INVOICE_ID , A.INVOICE_DT , A.VENDOR_SETID , A.VENDOR_ID , A.DOC_SEQ_DATE , A.DOC_SEQ_NBR , A.TXN_CURRENCY_CD , A.SALETX_AMT , A.VAT_INV_AMT , A.VAT_CALC_AMT , A.DUE_DT , A.VAT_RGSTRN_SELLER , A.COUNTRY_VAT_BILLFR , A.COUNTRY_VAT_BILLTO , A.COUNTRY_SHIP_TO , A.GROSS_AMT , A.FREIGHT_AMT , A.MERCHANDISE_AMT , A.MISC_AMT , A.BUSINESS_UNIT_GL , A.VOUCHER_STYLE , C.NAME1 , C.AR_NUM , C.SETID , D.ADDRESS_SEQ_NUM , %subrec(address_sbr2,D) , E.DESCR , %subrec(addr_dsply_sbr,E) , H.DESCR , B.SBI_PRINT_OPT , A.PYMNT_TERMS_CD , A.ENTERED_DT , F.REMIT_SETID , F.REMIT_VENDOR , F.VNDR_LOC , F.BANK_ACCT_SEQ_NBR , F.CURRENCY_PYMNT , F.PYMNT_SELCT_STATUS , A.DSCNT_DUE_DT , A.DSCNT_AMT , A.VAT_ENTITY , A.VAT_EXCPTN_TYPE , A.VAT_EXCPTN_CERTIF , A.VAT_TREATMENT_GRP FROM PS_VOUCHER A , PS_VENDOR C , PS_VENDOR_ADDR D , PS_AP_BU_ADDR_VW E , PS_CURR_TXN_VW H , PS_VENDOR_LOC B , PS_PYMNT_VCHR_XREF F WHERE B.SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID AND C.SETID = D.SETID AND C.VENDOR_ID = D.VENDOR_ID AND B.PRIM_ADDR_SEQ_NUM = D.ADDRESS_SEQ_NUM AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_VENDOR_ADDR D_ED WHERE D.SETID = D_ED.SETID AND D.VENDOR_ID = D_ED.VENDOR_ID AND D.ADDRESS_SEQ_NUM = D_ED.ADDRESS_SEQ_NUM AND D_ED.EFFDT <= %CurrentDateIn ) AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND H.TXN_CURRENCY_CD = A.TXN_CURRENCY_CD AND H.EFFDT = ( SELECT MAX(H_ED.EFFDT) FROM PS_CURR_TXN_VW H_ED WHERE H.TXN_CURRENCY_CD = H_ED.TXN_CURRENCY_CD AND H_ED.EFFDT <= %CurrentDateIn) AND B.SETID = A.VENDOR_SETID AND B.VENDOR_ID = A.VENDOR_ID AND B.VNDR_LOC = A.VNDR_LOC AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_VENDOR_LOC B_ED WHERE B.SETID = B_ED.SETID AND B.VENDOR_ID = B_ED.VENDOR_ID AND B.VNDR_LOC = B_ED.VNDR_LOC AND B_ED.EFFDT <= %CurrentDateIn) AND A.BUSINESS_UNIT = F.BUSINESS_UNIT AND A.VOUCHER_ID = F.VOUCHER_ID AND F.PYMNT_CNT = 1

Related Language Record: EM_VCHR_DISP_LG

# 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: BUS_UNIT_TBL_AP

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
Default Value: NEXT

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

5 INVOICE_DT Date(10) DATE Invoice Date

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

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

8 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.

9 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

10 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

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

12 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount

13 VAT_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount

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

15 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration

16 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).

17 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).

18 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).

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

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

21 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

22 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount

23 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

24 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

25 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

26 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number

27 SETID Character(5) VARCHAR2(5) NOT NULL SetID

28 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

29 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

30 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

31 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

32 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

33 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

34 CITY Character(30) VARCHAR2(30) NOT NULL City

35 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

36 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

37 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

38 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

39 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

40 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

41 COUNTY Character(30) VARCHAR2(30) NOT NULL County

42 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

43 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

44 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

45 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

46 DESCR Character(30) VARCHAR2(30) NOT NULL Description

47 ADDRESS1_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship to Address Line 1

48 ADDRESS2_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 2

49 ADDRESS3_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 3

50 ADDRESS4_SHIPTO Character(55) VARCHAR2(55) NOT NULL Ship To Address Line 4

51 CITY_SHIPTO Character(30) VARCHAR2(30) NOT NULL Ship To City

52 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other

53 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other

54 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
AB=House Boat Reference
WW=House Trailer Reference

55 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

56 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other

57 STATE_SHIPTO Character(6) VARCHAR2(6) NOT NULL Ship to State

58 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other

59 POSTAL_SHIPTO Character(12) VARCHAR2(12) NOT NULL Ship to Postal Code

60 COUNTRY_SHIPTO Character(3) VARCHAR2(3) NOT NULL Ship to Country

61 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

62 SBI_PRINT_OPT Character(1) VARCHAR2(1) NOT NULL SBI Printing Options, Default = 'B'
B=Print Report and Files
F=Print SBI File Only
R=Print Report Only

63 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

64 ENTERED_DT Date(10) DATE Entered on

65 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

66 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

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

68 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number

69 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

70 PYMNT_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid

71 DSCNT_DUE_DT Date(10) DATE Discount Due Date

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

73 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

74 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated

75 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.

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

#	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: BUS_UNIT_TBL_AP
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Default Value: NEXT
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
5	INVOICE_DT	Date(10)	DATE	Invoice Date
6	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
8	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
9	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
10	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
11	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
12	VAT_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amount
13	VAT_CALC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount
14	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.
15	VAT_RGSTRN_SELLER	Character(20)	VARCHAR2(20) NOT NULL	Seller's VAT Registration
16	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
17	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
18	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
19	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
20	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
21	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
22	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
23	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
24	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
25	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
26	AR_NUM	Character(15)	VARCHAR2(15) NOT NULL	Our Customer Number
27	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
28	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
29	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
30	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
31	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
32	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
33	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
34	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
35	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
36	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
37	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
38	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
39	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
40	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
41	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
42	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
43	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
44	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
45	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
46	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
47	ADDRESS1_SHIPTO	Character(55)	VARCHAR2(55) NOT NULL	Ship to Address Line 1
48	ADDRESS2_SHIPTO	Character(55)	VARCHAR2(55) NOT NULL	Ship To Address Line 2
49	ADDRESS3_SHIPTO	Character(55)	VARCHAR2(55) NOT NULL	Ship To Address Line 3
50	ADDRESS4_SHIPTO	Character(55)	VARCHAR2(55) NOT NULL	Ship To Address Line 4
51	CITY_SHIPTO	Character(30)	VARCHAR2(30) NOT NULL	Ship To City
52	NUM1_OTHER	Character(6)	VARCHAR2(6) NOT NULL	Number 1 Other
53	NUM2_OTHER	Character(6)	VARCHAR2(6) NOT NULL	Number 2 Other
54	HOUSE_TYPE_OTHER	Character(2)	VARCHAR2(2) NOT NULL	House Type Other AB=House Boat Reference WW=House Trailer Reference
55	IN_CITY_LMT_OTHER	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Other
56	COUNTY_OTHER	Character(30)	VARCHAR2(30) NOT NULL	County Other
57	STATE_SHIPTO	Character(6)	VARCHAR2(6) NOT NULL	Ship to State
58	GEO_CODE_OTHER	Character(11)	VARCHAR2(11) NOT NULL	Geo Code Other
59	POSTAL_SHIPTO	Character(12)	VARCHAR2(12) NOT NULL	Ship to Postal Code
60	COUNTRY_SHIPTO	Character(3)	VARCHAR2(3) NOT NULL	Ship to Country
61	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
62	SBI_PRINT_OPT	Character(1)	VARCHAR2(1) NOT NULL	SBI Printing Options, Default = 'B' B=Print Report and Files F=Print SBI File Only R=Print Report Only
63	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
64	ENTERED_DT	Date(10)	DATE	Entered on
65	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
66	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
67	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
68	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence Number
69	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
70	PYMNT_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Selection Status C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid
71	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
72	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
73	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
74	VAT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type. N=None S=Suspended X=Exonerated
75	VAT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
76	VAT_TREATMENT_GRP	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment Group