| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 3 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 5 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 6 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 7 |
FULFILLMENT_LOC |
Character(2) |
VARCHAR2(2) NOT NULL |
Page or process the fulfillment setup applies to.
03/16/04 PWF Addition of 80 for depletions
06/29/04 MDS (CN# IN890): Addition of Picking Feedback AE.
10/15/2004 WAB (F-KNANN-V59N4): Added online pages -- Create/Update Stock Request, Material Picking Feedback, Express Issue and Shipping/Issues -- and renamed existing pages, to be consistent with PIA menu items.
10=Reserve Materials Process
11=Create/Update Stock Request
20=Order Release Request
25=Undo Fulfillment Request
30=Picking
31=Material Picking Feedback
40=Picking Confirmation
50=Front-end Shipping Requests
51=Express Issue
60=Shipping Requests
61=Shipping/Issues
65=Freight Processing
70=Deplete On Hand Quantity
75=Kit Re-Explode
80=Build Bill of Lading
95=Fulfillment Workbench
99=Transactions
|
| 8 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 9 |
CONTAINER_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Picking from Containers
|
| 10 |
FPB_WORKFLOW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Fixed Pick Workflow
|
| 11 |
FPB_ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Fixed Picking Bin Role Name
|
| 12 |
FPB_RTE_CNTL_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Route Control Type
|
| 13 |
FPB_RTE_FROM_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
From Value
|
| 14 |
FPB_RTE_TO_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
To Value
|
| 15 |
IN_SHRTG_RLS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag indicating whether a demand line should be released (e.g. placed on a pick plan) as a shortage.
0=Release Shortage
1=Use Partial Quantity Logic
2=Do Not Release Shortage
|
| 16 |
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)
|
| 17 |
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
|
| 18 |
PICKING_TIEBREAKER |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Location Tiebreaker
01=Fewest Locations
02=Pick To Clear
|
| 19 |
PICK_PLAN_BY_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Unit of Measure
|
| 20 |
PRINT_ITEM_SUBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Substitutes
N=No
Y=Yes
|
| 21 |
SETDEFAULT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to set default values ot user options.
Y/N Table Edit
Default Value: Y
|
| 22 |
IN_ORD_REL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by Order Release Run Control
1=Create Allocations
2=Make Suggestions
3=Release Only
4=Create Pre-Allocations
5=Deallocation
6=Cancel Allocations
7=Return to Unfulfilled
8=Return to Releasable
9=Regenerate Output
A=Return to Released
B=Return to Confirmed
S=Select an Action
Default Value: 1
|
| 23 |
DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
|
| 24 |
PROCESS_INSTANCE2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 25 |
PUBLISH |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish Data
|
| 26 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 27 |
DELETE_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Temp. Tables
Y/N Table Edit
Default Value: Y
|
| 28 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 29 |
OM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Management
|
| 30 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 31 |
TO_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
|
| 32 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 33 |
IN_PICKPLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Picking Plan
Y/N Table Edit
Default Value: N
|
| 34 |
CARTON_LABELS |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Carton Labels
Y/N Table Edit
Default Value: N
|
| 35 |
EXTRACT_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Extract File
Y/N Table Edit
Default Value: N
|
| 36 |
USG_LABEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Item Usage Labels
Y/N Table Edit
Default Value: N
|
| 37 |
SEL_ORD_REL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created for outbound messaging.
Y/N Table Edit
Default Value: N
|
| 38 |
PICK_RELEASE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Release ID
|
| 39 |
ORDER_REL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Orders
Y/N Table Edit
Default Value: N
|
| 40 |
IN_ALLOC_RESERV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Only Reserved
Y/N Table Edit
Default Value: N
|
| 41 |
IN_PRINT_KIT_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Kit Header
Y/N Table Edit
Default Value: N
|
| 42 |
IN_KEEP_ALLOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep All Allocations
|
| 43 |
IN_KEEP_LOT_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Lot Allocations
|
| 44 |
IN_KEEP_PRE_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Pre Allocations
|
| 45 |
IN_KEEP_RESERV |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Reservations
|
| 46 |
IN_EXCLUDE_RTV |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude RTVs
Y/N Table Edit
Default Value: N
|
| 47 |
IN_TO_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Inventory Fulfillment State
|
| 48 |
WHERE_BU |
Character(254) |
VARCHAR2(254) NOT NULL |
WHERE CLAUSE
|
| 49 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 50 |
MESSAGE_TEXT_2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text
|
| 51 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 52 |
PRINT_SUB_ITM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print option used to print item substitute.
0=Print All The Time
1=Print At Zero
2=Print At Partial
Default Value: 1
|