AP_MECC_ASSGN_V (SQL View)	Index Back
Assign To Prompt View Assign To Prompt View

AP_MECC_ASSGN_V

(SQL View)

Assign To Prompt View

SELECT a.business_unit , a.voucher_id , a.voucher_line_num , a.match_rule_id , b.oprid , b.oprdefndesc , a.ap_mecc_assgn_type , a.ap_mtch_excp_grp FROM PS_AP_MECC_ASSIGN a , psoprdefn_vw b WHERE a.ap_mecc_assignto = b.oprid AND a.eff_status = 'A'

# 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 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

4 MATCH_RULE_ID Character(10) VARCHAR2(10) NOT NULL Match Rule ID

5 AP_MECC_ASSIGNTO Character(30) VARCHAR2(30) NOT NULL UserID of the person exception is assigned to

6 NAME Character(50) VARCHAR2(50) NOT NULL Name

7 AP_MECC_ASSGN_TYPE Character(1) VARCHAR2(1) NOT NULL Match Exception Assignment Type
A=Adhoc Assignment
G=MECC Group Assignment
T=Transaction User

8 AP_MTCH_EXCP_GRP Character(18) VARCHAR2(18) NOT NULL Match Exception Group

#	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	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
4	MATCH_RULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule ID
5	AP_MECC_ASSIGNTO	Character(30)	VARCHAR2(30) NOT NULL	UserID of the person exception is assigned to
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	AP_MECC_ASSGN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Match Exception Assignment Type A=Adhoc Assignment G=MECC Group Assignment T=Transaction User
8	AP_MTCH_EXCP_GRP	Character(18)	VARCHAR2(18) NOT NULL	Match Exception Group