PTWY_IT_RULE_IN(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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_VW |
| 3 | 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 |
| 4 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL |
Priority
Default Value: 1 |
| 5 | SPLIT_QTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Split Quantity
Y/N Table Edit Default Value: N |
| 6 | MIX_DATE_LOT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Mix Stage Dates and Lots
Y/N Table Edit Default Value: N |
| 7 | MAX_QTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Maximum Capacity Available
Y/N Table Edit Default Value: N |
| 8 | MIN_QTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Minimum Capacity Available
Y/N Table Edit Default Value: N |
| 9 | ZONE_CHK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Check Zone
Y/N Table Edit Default Value: N |
| 10 | DFLT_RULE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Rule Flag
Y/N Table Edit Default Value: N |