MATCH_RULE_IDPrompt Table: AP_MTCH_RULE_VW
BUSINESS_UNITPrompt Table: SP_BUS_AP_NONVW
VOUCHER_IDPrompt Table: VCHR_ID_VW3
Prompt Table: SP_SETID_NONVW
Prompt Table: VNDR_ACT_VW
A=Assigned
M=Match Ready
O=Open
R=Resolved
U=Unassigned
AP_MECC_FLTR_VW(SQL View) |
Index Back |
|---|---|
MECC DetailMatch Exception Collaboration Detail |
| SELECT DISTINCT MATCH_RULE_ID , BUSINESS_UNIT , VOUCHER_ID , SETID , VENDOR_ID , AP_MECC_STATUS , CREATE_DTTM FROM PS_AP_MECC_WC_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MATCH_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Match Rule ID
Prompt Table: AP_MTCH_RULE_VW |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUS_AP_NONVW |
| 3 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: VCHR_ID_VW3 |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VNDR_ACT_VW |
| 6 | AP_MECC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Match Exception Status
A=Assigned M=Match Ready O=Open R=Resolved U=Unassigned |
| 7 | CREATE_DTTM | DateTime(26) | TIMESTAMP | Creation Datetime |