APPR_RULE_AMT |
index back |
|---|---|
Approval Rule Amounts |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 APPR_RULE_SET |
Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| EFFDT |
Date(10) | DATE | Effective Date |
| APPR_STEP |
Character(3) | VARCHAR2(3) NOT NULL |
Approval Step
1=Approval Step 1 2=Approval Step 2 3=Approval Step 3 4=Approval Step 4 5=Approval Step 5 6=Approval Step 6 7=Approval Step 7 8=Approval Step 8 9=Approval Step 9 |
| APPR_PATH |
Character(3) | VARCHAR2(3) NOT NULL |
Approval Path
A=Approval Path A B=Approval Path B C=Approval Path C D=Approval Path D E=Approval Path E |
| APPR_RULE_SEQ |
Number(1,0) | SMALLINT NOT NULL | Approval Rule Sequence |
| FIELD_PNLFIELD | Character(18) | VARCHAR2(18) NOT NULL |
Field
Prompt Table: RECFIELD_VW |
| MAX_DEBIT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Maximum |
| MAX_CREDIT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Minimum |
| RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |