AP_MECC_DTL(SQL Table) |
Index Back |
|---|---|
MECC DetailMatch Exception Collaboration Detail |
| # | 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_MTCH_EXCP_GRP | Character(18) | VARCHAR2(18) NOT NULL | Match Exception Group |
| 6 | AP_MECC_ASSGN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Match Exception Assignment Type
A=Adhoc Assignment G=MECC Group Assignment T=Transaction User |
| 7 | AP_MECC_ASSIGNTO | Character(30) | VARCHAR2(30) NOT NULL |
UserID of the person exception is assigned to
Prompt Table: AP_MEC_ASTO_DVW |
| 8 | 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 |
| 9 | AP_MECC_RES_CD | Character(10) | VARCHAR2(10) NOT NULL |
Match Exception Resolution Code
Prompt Table: AP_MECC_RCD_TBL |
| 10 | CREATE_DTTM | DateTime(26) | TIMESTAMP |
Creation Datetime
Default Value: %DateTime |
| 11 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |