| # |
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 |
NOTIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to specify the notification method - WorkList only, Email only or Worklist and Email
B=Email and Worklist
N=None
W=WorkList Only
Y/N Table Edit
Default Value: N
|
| 5 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
| 6 |
RESERVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserved Flag
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 7 |
HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
N=Hold
Y=Hold
Y/N Table Edit
Default Value: Y
|
| 8 |
BACKORDER_ACTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Backorder Action
01=Cancel Backorder
02=Create Backorder
03=Hold and Notify
04=Release as Shortage
05=Reserve Substitute
|
| 9 |
BACKORDER_ACTION2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Backorder Action
01=Cancel Backorder
02=Create Backorder
03=Hold and Notify
04=Release as Shortage
|
| 10 |
BACKORDER_ACTION3 |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Remaining
01=Cancel Backorder
02=Create Backorder
03=Hold and Notify
04=Release as Shortage
|
| 11 |
SHIP_BCKORDR_ACTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Backorder Action
01=Cancel Backorder
02=Create Backorder
03=Hold and Notify
04=Release as Shortage
|
| 12 |
SHIP_BCKORDR_ACTN2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Backorder Action
CN=Cancel Backorder
CR=Create Backorder When
HD=Hold and Notify
SH=Release as Shortage
|