APPR_RULE_QTY

index back

Approval Rule Quantities


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

FROM_QTY Number(7,2) DECIMAL(6,2) NOT NULL From Quantity
TO_QTY Number(7,2) DECIMAL(6,2) NOT NULL To Quantity
DESCR Character(30) VARCHAR2(30) NOT NULL Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: RECDEFN_VW

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19