IN_RULE_GRP

(SQL Table)

# 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.

#	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.