RO_TYPE_HOLD_VW

(SQL View)
 Index Back

Hold Processing

This record is a view used for hold processing.

SELECT A.SETID , A.CAPTURE_TYPE_CD , A.HOLD_CD , A.ENABLED , B.ENT_USER_NPART_FLG , B.ENT_USER_PART_FLG , B.PART_USER_FLG , B.RO_HOLD_CHECK_TYPE , %subrec(RB_APPCLASS_SB2,B) FROM %Table(RO_TYPE_HOLD) A ,%Table(RO_DEFN_HOLD) B WHERE A.SETID=B.SETID AND A.HOLD_CD=B.HOLD_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Prompt Table: SP_SETID_NONVW

2 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order
3 HOLD_CD Character(6) VARCHAR2(6) NOT NULL This field determine the hold code of an item.

Prompt Table: RO_DEFN_HOLD

4 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

Y/N Table Edit

Default Value: Y

5 ENT_USER_NPART_FLG Character(1) VARCHAR2(1) NOT NULL Flag that specifies if a hold code will apply when a non-partner order is placed by an enterprise user.
6 ENT_USER_PART_FLG Character(1) VARCHAR2(1) NOT NULL Flag that specifies if a hold code will apply when a partner order is placed by an enterprise user.
7 PART_USER_FLG Character(1) VARCHAR2(1) NOT NULL Flag that specifies if a hold code will apply when a partner order is placed by a partner user.
8 RO_HOLD_CHECK_TYPE Character(4) VARCHAR2(4) NOT NULL Hold check type (header/line)
CUST=Related Customer
HEAD=Header
LINE=Line
9 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: RBC_APPCLASS_VW

10 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

Prompt Table: RBC_APPRTPATH_V