AP_MECC_DTL_H

(SQL Table)
Index Back

MECC Detail

Match Exception Collaboration Detail - Archive Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
6 MATCH_RULE_ID Character(10) VARCHAR2(10) NOT NULL Match Rule ID
7 AP_MTCH_EXCP_GRP Character(18) VARCHAR2(18) NOT NULL Match Exception Group
8 AP_MECC_ASSGN_TYPE Character(1) VARCHAR2(1) NOT NULL Match Exception Assignment Type
A=Adhoc Assignment
G=MECC Group Assignment
T=Transaction User
9 AP_MECC_ASSIGNTO Character(30) VARCHAR2(30) NOT NULL UserID of the person exception is assigned to
10 AP_MECC_STATUS Character(1) VARCHAR2(1) NOT NULL Match Exception Status
A=Assigned
M=Match Ready
O=Open
R=Resolved
U=Unassigned

Default Value: O

11 AP_MECC_RES_CD Character(10) VARCHAR2(10) NOT NULL Match Exception Resolution Code
12 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime

Default Value: %DateTime

13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance