| # |
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 |
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
|
| 3 |
TRANS_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Program
|
| 4 |
OVRRIDE_LEVEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
indicates whether to allow a user to override the pass-through level from a page.
Y/N Table Edit
Default Value: N
|
| 5 |
PASS_THROUGH_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level.
10=Request
20=Order
30=Line
Default Value: 30
|
| 6 |
OVRRIDE_COMMIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to allow a user to override the processing and commit levels and counts from a page.
Y/N Table Edit
Default Value: N
|
| 7 |
PROCESSING_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count based on Processing Level used to determine the Processing Group. A value of zero indicates include all data into one Processing Group. This count can be used to help tune at a site that is running into issues with large runs causing blocking and deadlocks on the base tables updated by the Process. When processing, if Commit Count is greater than the specified Processing Count and the Processing Level is the same as the Commit Level, the Processing Count should be set to the Commit Count.
|
| 8 |
PROCESSING_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies the level for the Processing Count. When Processing Count is not zero, Processing Level must be greater than or equal to Commit Level.
10=Request
20=Order
30=Line
Default Value: 30
|
| 9 |
COMMIT_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count based on Commit Level used to determine the size of a unit of work to commit to the database. A value of zero indicates include all updates in the same unit of work and do one commit at the end of each Processing Group. This count can be used to help tune at a site that is running into issues with large runs causing blocking and deadlocks on the base tables updated by the process.
|
| 10 |
COMMIT_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies the level for the Commit Count. When Commit Count is not zero, Commit Level must be less than or equal to Processing Level.
10=Request
20=Order
30=Line
40=Item
Default Value: 30
|
| 11 |
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
Default Value: N
|
| 12 |
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
Default Value: N
|
| 13 |
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
Default Value: N
|
| 14 |
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
Default Value: N
|
| 15 |
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
Default Value: N
|
| 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
Default Value: N
|
| 17 |
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
Default Value: N
|
| 18 |
OVERRIDE_RLS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Override AutoRls Options
Y/N Table Edit
Default Value: Y
|
| 19 |
AUTO_RELEASE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Auto-Processing Option
00=No Auto-Processing
10=Use Auto-Processing Default
20=Advance to Reserved
30=Advance to Releasable
40=Advance to Released
50=Advance to Confirmed
60=Advance to Shipped
70=Advance to Depleted
Default Value: 00
|
| 20 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
IN_RLS_OPRID_VW
|
| 21 |
RLS_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table:
IN_RLS_RCID_VW
|
| 22 |
AUTO_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Process field used in Billing/Revenue Fee Worksheet pages.
Y/N Table Edit
Default Value: N
|
| 23 |
COMPLETE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Flag
0=Process Location
1=Pick Line Complete
2=Pick Batch Complete
3=Pick Line as Planned
4=Pick Batch as Planned
5=Process Location - Incomplete
6=Complete Pick - Zero Quantity
7=Complete Pick - Leave Alone
8=Complete Pick - Dft Ship Loc
A=Use Defaults
B=No Action
|
| 24 |
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
Default Value: N
|
| 25 |
IN_KIT_REEXPLODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag indicating whether the Kit Re-Explode program should be initiated
Y/N Table Edit
Default Value: N
|
| 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
Default Value: 1
|
| 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
Default Value: 2
|