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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19