VCHR_INQSPNA_VW

#	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	INVOICE_DT	Date(10)	DATE	Invoice Date
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
8	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
9	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
10	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
11	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
12	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
13	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
14	AVAILABLE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prepayment Available Amount
15	CONV_GROSS_PAID	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used for Voucher Inquiry view to hold the paid amounts converted to the txn currency of the voucher.
16	VCHR_BALANCE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Left to Balance
17	CONV_DSCNT_PAID	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used for Voucher Inquiry to hold the Discount Paid converted to the voucher txn currency.
18	CONV_NET_PAID	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used for Voucher inquiry to hold the Net paid for a voucher converted to the txn currency.
19	TOTAL_MISC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc Charges Total
20	VAT_ENTRD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Entered VAT Amount
21	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
22	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
23	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open
24	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.
25	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
26	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
27	ENTERED_DT	Date(10)	DATE	Entered on
28	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
29	BUDGET_MISC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Misc Status E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check
30	MATCH_STATUS_VCHR	Character(1)	VARCHAR2(1) NOT NULL	Match Status C=Overridden - Credit Note D=Match Dispute E=Match Exceptions Exist M=Matched N=Not Applicable O=Manually Overridden T=To Be Matched
31	DOC_SEQ	Character(1)	VARCHAR2(1) NOT NULL	Enable Document Sequencing Y/N Table Edit
32	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
33	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
34	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
35	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
36	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
37	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
38	VAT_RGSTRN_SELLER	Character(20)	VARCHAR2(20) NOT NULL	Seller's VAT Registration
39	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
40	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
41	OFAC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	OFAC Status B=Blocked C=Cleared R=Review V=Valid
42	VCHR_DRAFT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Voucher Draft Flag N=Complete Voucher Y=Incomplete Voucher
43	ATTACHMENT_NUM	Number(5,0)	INTEGER NOT NULL	Attachment Number
44	VCHR_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Voucher Approval Flag D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework