AP_MTCH_EX_GRP(SQL Table) |
Index Back |
---|---|
MECC Group HeaderMatch Exception Group Header |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | AP_MTCH_EXCP_GRP | Character(18) | VARCHAR2(18) NOT NULL | Match Exception Group |
2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | INCL_PO_BUYER | Character(1) | VARCHAR2(1) NOT NULL |
Include Buyer from Purchase Order
Y/N Table Edit Default Value: N |
5 | INCL_REQUESTOR | Character(1) | VARCHAR2(1) NOT NULL |
Include Requestor
Y/N Table Edit Default Value: N |
6 | INCL_INVC_ORIGIN | Character(1) | VARCHAR2(1) NOT NULL |
Include Invoice Originator
Y/N Table Edit Default Value: N |
7 | INCL_RECEIVER | Character(1) | VARCHAR2(1) NOT NULL |
Include Receiver
Y/N Table Edit Default Value: N |
8 | MTCH_EX_APBU_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Payables Business Unit Options
Y/N Table Edit Default Value: Y |
9 | MTCH_EX_POBU_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Procurement Business Unit Options
Y/N Table Edit Default Value: Y |
10 | MTCH_EX_SHIP_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Ship To Location Option
Y/N Table Edit Default Value: Y |
11 | MTCH_EX_MCID_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Match Control Id Filter
Y/N Table Edit Default Value: Y |
12 | AP_MTCH_GRPTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Match Exception Group Type
A=All Rules in Exception E=Any Rule in Exception Default Value: E |
13 | AP_TOT_RULES | Number(11,0) | DECIMAL(11) NOT NULL | Total Rules |
14 | AP_MEC_INCLD_OPRTR | Character(2) | VARCHAR2(2) NOT NULL |
MECC Include User field
B=Buyer I=Invoice Creator R=Receiver |