APPR_RULE_AMT(SQL Table) |
Index Back |
|---|---|
Approval Rule Amounts |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  APPR_RULE_SET |
Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | 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 |
| 4 | 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 |
| 5 | APPR_RULE_SEQ |
Number(1,0) | SMALLINT NOT NULL | Approval Rule Sequence |
| 6 | FIELD_PNLFIELD | Character(18) | VARCHAR2(18) NOT NULL |
Field
Prompt Table: RECFIELD_VW |
| 7 | MAX_DEBIT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Maximum |
| 8 | MAX_CREDIT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Minimum |
| 9 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |