AP_MECC_DTL_H(SQL Table) |
Index Back |
---|---|
MECC DetailMatch 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 |