PeopleSoft 9 Account Payables |
Table Name | AP_MTCH_RULECFG |
Table Description |
AP_MTCH_RULECFG |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | VARCHAR(5) | Yes | Yes |
MATCH_CNTRL_ID | VARCHAR(10) | Yes | Yes |
EFFDT | datetime | Yes | Yes |
MATCH_RULE_ID | VARCHAR(10) | Yes | No |
MTCH_RULE_TYPE | VARCHAR(15) | No | No |
MTCH_RULE_LEVEL | VARCHAR(2) | No | No |
SQLID | VARCHAR(30) | No | No |
QUAL_APPL_NXT_RULE | VARCHAR(1) | No | No |
AP_RULE_ACTION_F | VARCHAR(1) | No | No |
AP_RULE_ACTION_T | VARCHAR(1) | No | No |
OTH_APPL_NXT_RULE | VARCHAR(1) | No | No |
AP_PCT_UNDERAMT | INT | No | No |
AP_PCT_OVERAMT | INT | No | No |
AMT_TOL_DOWN | DECIMAL(15,2) | No | No |
AMT_TOL_UP | DECIMAL(15,2) | No | No |
SEQ_NUM | SMALLINT | No | No |
Index |
Name | Type | Unique | Member |
PS_AP_MTCH_RULECFG | PK | Yes |
![]() |
Member(s) of "PS_AP_MTCH_RULECFG" Index |
SETID |
MATCH_CNTRL_ID |
EFFDT |
MATCH_RULE_ID |
Published June 06, 2007 |