| # |
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_VW2
|
| 3 |
PICKING_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Picking Plan
01=Fixed Pick Location
03=Default Putaway Location
05=Default Shipment Location
08=Container Option
09=Pick by Date
10=All Available Locations
Default Value: 01
|
| 4 |
PICKING_DT_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Date Option
01=Earliest Expiration Dt (FEFO)
02=Earliest Available Lot (FIFO)
03=Earliest Staged Date (FIFO)
04=Latest Staged Date (LIFO)
|
| 5 |
PICKING_TIEBREAKER |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Location Tiebreaker
01=Fewest Locations
02=Pick To Clear
Default Value: 01
|
| 6 |
FPB_WORKFLOW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Fixed Pick Workflow
Y/N Table Edit
Default Value: N
|
| 7 |
PICK_PLAN_BY_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Unit of Measure
Y/N Table Edit
Default Value: N
|
| 8 |
SOFT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Soft Reserve
Y/N Table Edit
Default Value: N
|
| 9 |
ALLOC_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Reservation Lead Days
|
| 10 |
ADHOC_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Adhoc Requisitions
Y/N Table Edit
Default Value: N
|
| 11 |
CONTAINER_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Picking from Containers
Y/N Table Edit
Default Value: N
|
| 12 |
LABEL_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit of Measure
1=Order
2=Standard
3=Standard Pack
Default Value: 1
|
| 13 |
FPB_ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Fixed Picking Bin Role Name
Prompt Table:
ROLE_USRLST_VW
|
| 14 |
FPB_RTE_CNTL_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Route Control Type
Prompt Table:
RTE_CNTL_TYPE
|
| 15 |
FPB_RTE_FROM_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
From Value
Prompt Table:
%EDITTABLE
|
| 16 |
FPB_RTE_TO_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
To Value
Prompt Table:
%EDITTABLE
|
| 17 |
ONLINE_RES_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Online Reservation Flag
Y/N Table Edit
Default Value: DF_SETUP_INV.ONLINE_RES_FLAG
|
| 18 |
ALLOW_SUB_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether item substitutions are allowed on the order schedule.
Y/N Table Edit
Default Value: N
|
| 19 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
Y/N Table Edit
Default Value: DF_SETUP_INV.PARTIAL_QTY_FLAG
|
| 20 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
Y/N Table Edit
Default Value: DF_SETUP_INV.BCKORDR_CNCL_FLAG
|
| 21 |
CROSS_DOCK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Dock Flag
A=All receipts
N=No cross docking
P=Pegged receipts, only
Y=Non-pegged receipts, only
Y/N Table Edit
Default Value: N
|
| 22 |
CROSS_DOCK_LEAD |
Number(3,0) |
SMALLINT NOT NULL |
Cross Dock Lead Days
Default Value: 0
|
| 23 |
QTY_MIN_STD |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Min Quantity Standard UOM
|
| 24 |
DFLT_SHP_LOC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Ship Location Option
1=Default Ship Staging Location
2=Default Cross Docking Location
3=Default Putaway Location
4=Default Inspection Location
5=Default Fixed Picking Bin Loc
6=Manually Entered Location
7=Default Pegging Location
Default Value: 1
|
| 25 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
STOR_AREA_VW2
|
| 26 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
STOR_LEV1_VW2
|
| 27 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
STOR_LEV2_VW2
|
| 28 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
STOR_LEV3_VW2
|
| 29 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
STOR_LEV4_VW
|
| 30 |
IN_LINE_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Backorder Rule
Prompt Table:
IN_RULE_B_VW
|
| 31 |
IN_LINE_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation Rule
Prompt Table:
IN_RULE_R_VW
|
| 32 |
IN_LN_RESV_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation - Backorder
Prompt Table:
IN_RULE_R_VW
|
| 33 |
UNIT_MEASURE_ORD |
Character(3) |
VARCHAR2(3) NOT NULL |
Ordering UOM
Prompt Table:
INV_DFLT_UOM_VW
|
| 34 |
FROM_STOR_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
From storage area
Prompt Table:
STOR_AREA_VW2
|
| 35 |
FROM_STOR_LEV1 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 1
Prompt Table:
FROM_LV1_INV_VW
|
| 36 |
FROM_STOR_LEV2 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 2
Prompt Table:
FROM_LV2_INV_VW
|
| 37 |
FROM_STOR_LEV3 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 3
Prompt Table:
FROM_LV3_INV_VW
|
| 38 |
FROM_STOR_LEV4 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 4
Prompt Table:
FROM_LV4_INV_VW
|
| 39 |
IN_FRT_AUTO_PACK |
Character(1) |
VARCHAR2(1) NOT NULL |
10/29/07 EGS: Created
Y/N Table Edit
Default Value: N
|