BUSINESS_UNITPrompt Table: SP_BUS_AP_NONVW
BUYER_IDMATCH_RULE_IDAP_EXP_BRULE_VW(SQL View) |
Index Back |
|---|
| SELECT business_unit , buyer_id , match_rule_id FROM PS_AP_MTCH_EXP_B_S GROUP BY business_unit , buyer_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 | BUYER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 3 | MATCH_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Match Rule ID |