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 |