BUSINESS_UNITPrompt Table: SP_BUS_AP_NONVW
VENDOR_SETIDPrompt Table: SP_SETID_NONVW
VENDOR_IDMATCH_RULE_IDAP_EXP_VRULE_VW(SQL View) |
Index Back |
|---|
| SELECT business_unit , vendor_setid , vendor_id , match_rule_id FROM PS_AP_MTCH_EXP_SUM GROUP BY business_unit , vendor_setid , vendor_id , match_rule_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUS_AP_NONVW |
| 2 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETID_NONVW |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | MATCH_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Match Rule ID |