AP_APPR_HDR_VW (SQL View)	Index Back
Voucher header Voucher Approval Search Record

AP_APPR_HDR_VW

(SQL View)

Voucher header

Voucher Approval Search Record

SELECT a.business_unit , a.voucher_id , a.appr_status , a.oprid , a.oprid_last_updt , a.voucher_style , a.invoice_id , a.ers_inv_seq , a.invoice_dt , a.due_dt , a.vendor_setid , a.vendor_id , a.vndr_loc , a.address_seq_num , a.grp_ap_id , a.origin , a.vchr_ttl_lines , a.close_status , a.entry_status , a.accounting_dt , a.post_voucher , a.post_status_ap , a.process_instance , a.in_process_flg , a.business_unit_gl , a.process_man_close , a.dst_cntrl_id , a.dup_invoice_status , a.voucher_id_related , a.gross_amt , a.gross_amt_bse , a.txn_currency_cd , a.rt_type , a.rate_mult , a.rate_div , a.base_currency , a.dscnt_amt , a.dscnt_amt_bse , a.dscnt_prorate_flg , a.tax_exempt , a.vchr_priority , CASE WHEN a.vchr_priority = 'H' THEN '1' WHEN a.vchr_priority = 'M' THEN '2' ELSE '3' END , a.vchr_src , a.usetax_amt , a.saletx_amt , a.freight_amt , a.misc_amt , a.merchandise_amt , a.pymnt_terms_cd , a.descr254_mixed FROM PS_VOUCHER a , ps_vchr_af_hdr_vw b WHERE a.business_unit = b.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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AP_NONVW

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

3 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending

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

5 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

6 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

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

8 ERS_INV_SEQ Number(5,0) INTEGER NOT NULL ERS Invoice Sequence

9 INVOICE_DT Date(10) DATE Invoice Date

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

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

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

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

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

15 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID

16 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

17 VCHR_TTL_LINES Number(5,0) INTEGER NOT NULL Lines Entered

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

19 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

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

21 POST_VOUCHER Character(1) VARCHAR2(1) NOT NULL Post Voucher Now
D=Post Later
N=Do Not Post
P=Post Immediately

22 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted

23 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

24 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

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

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

27 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template

28 DUP_INVOICE_STATUS Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Status

29 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher

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

31 GROSS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Gross Amount

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

33 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

34 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

35 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

36 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

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

38 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount

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

40 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

41 VCHR_PRIORITY Character(1) VARCHAR2(1) NOT NULL This is a new field reserved for Mobile Approval. Added on April 24th 2012.
H=High
L=Low
M=Medium

42 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
1=High
2=Medium
3=Low

43 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source

44 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

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

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

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

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

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

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

#	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: SP_BU_AP_NONVW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Default Value: NEXT
3	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
6	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
7	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
8	ERS_INV_SEQ	Number(5,0)	INTEGER NOT NULL	ERS Invoice Sequence
9	INVOICE_DT	Date(10)	DATE	Invoice Date
10	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.
11	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
12	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
13	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
14	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
15	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
16	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
17	VCHR_TTL_LINES	Number(5,0)	INTEGER NOT NULL	Lines Entered
18	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open
19	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
20	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
21	POST_VOUCHER	Character(1)	VARCHAR2(1) NOT NULL	Post Voucher Now D=Post Later N=Do Not Post P=Post Immediately
22	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
23	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
24	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
25	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
26	PROCESS_MAN_CLOSE	Character(1)	VARCHAR2(1) NOT NULL	Process Manual Close N=No P=Processed Y=Yes
27	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template
28	DUP_INVOICE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Invoice Status
29	VOUCHER_ID_RELATED	Character(8)	VARCHAR2(8) NOT NULL	Related Voucher
30	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
31	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
32	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
33	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
34	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
35	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
36	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
37	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
38	DSCNT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Discount Amount
39	DSCNT_PRORATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Discount
40	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
41	VCHR_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	This is a new field reserved for Mobile Approval. Added on April 24th 2012. H=High L=Low M=Medium
42	PRIORITY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Priority Flag 1=High 2=Medium 3=Low
43	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
44	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
45	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
46	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
47	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount
48	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
49	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.
50	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description