IN_RULE_LST

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RULE_CD Character(5) VARCHAR2(5) NOT NULL Rule Code
2 RULE_TYPE Character(1) VARCHAR2(1) NOT NULL Rule Type
B=Line Backorder Rule
L=Line Reservation - Backorder
O=Order Reservation Rule
R=Line Reservation Rule
3 DTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Details stage table.
4 GRP_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Group stage table.
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 METRIC_CD Character(1) VARCHAR2(1) NOT NULL Percent or Static
2=Percent
4=Static
8 PLUS_MINUS_OPR Character(1) VARCHAR2(1) NOT NULL Plus/Minus Operator
A=Add
S=Subtract
9 OFFSET_OPERATOR Character(4) VARCHAR2(4) NOT NULL DM Offset Operator
==Equal
BTW=In Between
LIKE=Like Comparison
10 VALUE_NUM Number(14,3) DECIMAL(13,3) NOT NULL VALUE NUMBER

Default Value: 0

11 IN_FL_COMPARE_RULE Character(2) VARCHAR2(2) NOT NULL Comparison Operator
<=Less than
<==Less than or equal
==Equal to
>=Greater than
>==Greater or equal