PTWY_RULE_INV(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PTWY_RULE |
Character(2) | VARCHAR2(2) NOT NULL |
Putaway Rule
01=Default Location 02=Fixed Picking 03=Empty 04=Find Existing Item 05=Random 06=Containers |
| 3 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL |
Priority
Default Value: 1 |
| 4 | SPLIT_QTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Split Quantity
Y/N Table Edit Default Value: N |
| 5 | MIX_DATE_LOT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Mix Stage Dates and Lots
Y/N Table Edit Default Value: N |
| 6 | MAX_QTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Maximum Capacity Available
Y/N Table Edit Default Value: N |
| 7 | MIN_QTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Minimum Capacity Available
Y/N Table Edit Default Value: N |
| 8 | ZONE_CHK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Check Zone
Y/N Table Edit Default Value: N |
| 9 | DFLT_RULE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Rule Flag
Y/N Table Edit Default Value: N |