VCHR_HDR_NP_VW

(SQL View)

SELECT BUSINESS_UNIT , VOUCHER_ID , ACCOUNTING_DT , ENTRY_STATUS , APPR_STATUS , VENDOR_SETID , VENDOR_ID , INVOICE_ID , INVOICE_DT , CLOSE_STATUS , BUDGET_MISC_STATUS , 'A' , KK_TRAN_OVER_FLAG , KK_TRAN_OVER_OPRID , KK_TRAN_OVER_DTTM , IN_PROCESS_FLG FROM PS_VOUCHER WHERE BUDGET_MISC_STATUS <> 'V'

# 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 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

4 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

5 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

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

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

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

9 INVOICE_DT Date(10) DATE Invoice Date

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

11 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
Default Value: V

12 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic

13 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes

14 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator

15 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime

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

#	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	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
4	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
5	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
6	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
8	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
9	INVOICE_DT	Date(10)	DATE	Invoice Date
10	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open
11	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 Default Value: V
12	KK_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Amount Type 0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic
13	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
14	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
15	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
16	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag