| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
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
|
| 5 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 6 |
TRANSACTION_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
|
| 7 |
TRANS_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Program
|
| 8 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 9 |
OM_CHANGE_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Allow OM Changes Thru
|
| 10 |
LAST_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business unit tagged
|
| 11 |
SELECT_UNFULFILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.
Y/N Table Edit
|
| 12 |
SELECT_RELEASABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a releasable state.
Y/N Table Edit
|
| 13 |
SELECT_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Released state.
Y/N Table Edit
|
| 14 |
SELECT_CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.
Y/N Table Edit
|
| 15 |
SELECT_DEPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the RFID Tag Generation should include data in a Depleted state.
Y/N Table Edit
|
| 16 |
SELECT_SHIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Picked state.
Y/N Table Edit
|
| 17 |
SL_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
|
| 18 |
TO_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
|
| 19 |
SL_DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source selection
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Sourced Demand
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order Demand
|
| 20 |
SL_SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Business Unit selection
|
| 21 |
SL_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
|
| 22 |
TO_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
|
| 23 |
SL_INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item selection
|
| 24 |
SL_PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 25 |
IN_KIT_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether overrides to the Kit Re-Explode processing options are allowed
Y/N Table Edit
|
| 26 |
IN_KIT_EXPL_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Kit Effective Date to be used by the Kit Re-Explode program
1=Schedule Date
2=Order Date
3=Ship Early Date
4=Today's Date
|
| 27 |
IN_KIT_EXEC_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Execution Mode for the Kit Re-Explode program
1=Report and Re-Explode
2=Report Only
|
| 28 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 29 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 30 |
DOWNTIME_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prohibit Material Movements
|
| 31 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 32 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 33 |
COUNT_LINES |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count of Lines
|
| 34 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 35 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 36 |
OVRRIDE_STATES_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether the user can override the default states from a page.
Y/N Table Edit
|
| 37 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 38 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 39 |
NEXT_SHIP_LINE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Next Ship Line
|
| 40 |
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
|
| 41 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 42 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 43 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 44 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 45 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 46 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|