VCHR_M_DIAG_VW

#	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_BUS_AP_NONVW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Default Value: NEXT
3	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
4	ERS_INV_SEQ	Number(5,0)	INTEGER NOT NULL	ERS Invoice Sequence
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: %EDITTABLE20
6	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_AP_VW
7	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Default Value: VENDOR.PRIM_ADDR_SEQ_NUM Prompt Table: VNDR_ADDR_AP_VW
8	VCHR_TTL_LINES	Number(5,0)	INTEGER NOT NULL	Lines Entered
9	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open Default Value: O
10	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
11	POST_VOUCHER	Character(1)	VARCHAR2(1) NOT NULL	Post Voucher Now D=Post Later N=Do Not Post P=Post Immediately Default Value: D
12	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted Default Value: U
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
14	PROCESS_MAN_CLOSE	Character(1)	VARCHAR2(1) NOT NULL	Process Manual Close N=No P=Processed Y=Yes Default Value: N
15	VOUCHER_ID_RELATED	Character(8)	VARCHAR2(8) NOT NULL	Related Voucher Prompt Table: %EDITTABLE2
16	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
17	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
18	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Prompt Table: CURR_TXN_VW
19	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. Prompt Table: RT_TYPE_TBL
20	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. "
21	FREIGHT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Freight Amount
22	PYMNT_CNT_TOTAL	Number(5,0)	INTEGER NOT NULL	Total Payment Count Default Value: 1
23	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_TRMS_VW
24	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard Default Value: N
25	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 Default Value: N
26	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
27	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
28	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit Default Value: N
29	MANUAL_CLOSE_DT	Date(10)	DATE	Manual Close Date
30	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 Default Value: P
31	VAT_CALC_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Calculated Amount Base Cur
32	VAT_DCMNT_ID	Number(8,0)	INTEGER NOT NULL	VAT Document ID
33	REVALUE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated. Y/N Table Edit Default Value: Y
34	RECV_ONLY_MTCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Receipt Only Match Y/N Table Edit Default Value: N
35	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
36	ERS_TAX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ERS Tax Type B=Sales Tax N=No Taxes U=Use Tax V=Value Added Tax
37	ERS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ERS Type N=Not Applicable P=PO Receipt R=Non PO Receipt Default Value: N
38	INV_RECPT_DT	Date(10)	DATE	Invoice Receipt Date
39	RECEIPT_DT	Date(10)	DATE	Received Date
40	UNMTCH_PAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Pay UnMatched Voucher Y/N Table Edit Default Value: N
41	UNMTCH_PAY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	UnMatched Pay Status N=Not Applicable P=Paid U=Unpaid Default Value: N
42	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source Default Value: ONL
43	SBI_IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	SelfBillingProcFlag Y/N Table Edit Default Value: N
44	CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Reporting Currency
45	VCHR_POADJ_OPT	Character(1)	VARCHAR2(1) NOT NULL	Adjust Purchase Order A=Adjust Matched PO D=Don't Adjust PO Default Value: D
46	VCHR_MTCH_ADJ_OPT	Character(1)	VARCHAR2(1) NOT NULL	Match Exception Adjustment Opt A=Automatic Generate N=None S=Stage Default Value: N
47	PO_RECPT_DT	Date(10)	DATE	Indicates date of receipt for PO
48	MTCH_LEVEL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Match Leve Status E=Match Error L=Line Level Matching M=Matched N=Not Matched S=Standard Default Value: N
49	MTCH_LEVEL_OPT	Character(1)	VARCHAR2(1) NOT NULL	Matching Level L=Line Leven V=Voucher Total Default Value: V
50	MATCH_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Match Override N=No O=Override Exception Default Value: N
51	INVOICE_RCPT_DT	Date(10)	DATE	InvoiceRecptDate