UNMATCH_TMP (SQL Table)	Index Back
Un Match Temp

UNMATCH_TMP

(SQL Table)

Un Match Temp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: UNMATCH_VW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
Prompt Table: UNMATCH_VCHR_VW

3 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard

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 UNMATCH_FLG Character(1) VARCHAR2(1) NOT NULL Un Match Flag
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: UNMATCH_VW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Prompt Table: UNMATCH_VCHR_VW
3	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard
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	UNMATCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Un Match Flag Y/N Table Edit Default Value: N