| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 MATCH_RULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule ID
|
| 2 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 3 |
MTCH_RULE_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Match Rule Type
Prompt Table:
AP_MTH_RULETYPE
|
| 4 |
MTCH_RULE_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Match Rule Level
HS=Header Summary
LS=Line Summary
Default Value: LS
|
| 5 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
PSMSGSETDEFN
|
| 6 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
PSMSGCATDEFN
|
| 7 |
SQLID |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)
Prompt Table:
SQLID_VW
|
| 8 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 9 |
OVERRIDE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rule Type Parameters
Y/N Table Edit
Default Value: N
|
| 10 |
WORKFLOW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow Flag
Y/N Table Edit
Default Value: N
|
| 11 |
SEND_EMAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Workflow Flag
Y/N Table Edit
|
| 12 |
DAYS_NOTIFY |
Number(4,0) |
SMALLINT NOT NULL |
Totals Days before notification of expiration, renewal, etc.
|
| 13 |
USER_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
User List Source
C=Application Class
Q=Query
R=Role
S=SQL Definition
Default Value: R
|
| 14 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
PSROLEDEFN
|
| 15 |
SQLID_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
Match Rule SQL Object
Prompt Table:
SQLID_VW
|
| 16 |
ASSTN_SQLID |
Character(30) |
VARCHAR2(30) NOT NULL |
Association SQL
|
| 17 |
QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
Prompt Table:
QRY_NAME_VW
|
| 18 |
AP_LABEL_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Workbench Match Rule Label
|
| 19 |
SHOW_LABEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show only on Exception
Y/N Table Edit
|
| 20 |
DM_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit Memo Category
Q=Quantity
U=Unit Price
|
| 21 |
TOLERANCE_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Tolerance at Rule Control
Y/N Table Edit
Default Value: N
|
| 22 |
AP_TOL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tolerance Type
P=Percentage
V=Amount
Default Value: V
|
| 23 |
AP_MTCH_RULE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Exception Cause Type
E=External
I=Internal
|