MIN_USER_TASK(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN_SRCH |
|
2 | Character(4) | VARCHAR2(4) NOT NULL |
Task Flow
0100=Par Count 0200=Item Stock Inquiry 0300=Guided Count 0310=Count by Location 0320=Count by Item 0330=Manual Count 0400=Receiving PO 0410=Receiving Ad Hoc 0500=Delivery 0550=Delivery Cart 0600=Express Issue 0700=Bin to Bin Transfer 0800=Perform Putaway 0900=Adjustments 0950=Fulfillment Inquiry 1000=Picking Feedback 1001=Inquiry by All Units |
|
3 | DISPLAY_ROWS | Number(6,0) | INTEGER NOT NULL |
Determine number of rows to display in the grid
Default Value: 10 |
4 | MIN_CE_MAIN_SORT | Character(4) | VARCHAR2(4) NOT NULL |
Sort By
0001=Sort By Item 0002=Sort By Location 0003=Sort By Order Entered 0004=Sort By Pick Batch |
5 | MIN_CE_MAIN_GROUP | Character(1) | VARCHAR2(1) NOT NULL |
Group by
I=Group By Item L=Group By Location N=No Grouping Default Value: L |
6 | MIN_CE_INITDISPLAY | Character(4) | VARCHAR2(4) NOT NULL |
Initial Display Mode
0001=Single Item 0002=All Items Default Value: 0001 |
7 | MIN_CE_ALL_ITEM | Character(4) | VARCHAR2(4) NOT NULL |
All Item Filter
0001=Display All 0002=Display Counted Only 0003=Display Uncounted Only Default Value: 0001 |
8 | MIN_CE_STS_1 | Character(1) | VARCHAR2(1) NOT NULL |
New
Y/N Table Edit Default Value: Y |
9 | MIN_CE_STS_2 | Character(1) | VARCHAR2(1) NOT NULL |
Counting
Y/N Table Edit Default Value: N |
10 | MIN_CE_STS_3 | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Entered - Hold
Y/N Table Edit Default Value: N |
11 | MIN_CE_STS_4 | Character(1) | VARCHAR2(1) NOT NULL |
Ready to Update Stock Quantity
Y/N Table Edit Default Value: N |
12 | MIN_CE_PRELOAD_SER | Character(1) | VARCHAR2(1) NOT NULL |
Pre-Load Serial IDs
Y/N Table Edit Default Value: Y |
13 | MIN_EXPERT_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Expert Mode
Y/N Table Edit Default Value: N |
14 | MIN_PROMPTS | Character(1) | VARCHAR2(1) NOT NULL |
Display Lookups
Y/N Table Edit Default Value: Y |
15 | MIN_DESCRPT | Character(1) | VARCHAR2(1) NOT NULL |
Display Description
Y/N Table Edit Default Value: Y |
16 | MIN_COLLAPSE_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Collapse Header
Y/N Table Edit Default Value: N |
17 | MIN_SHOW_FILTER | Character(1) | VARCHAR2(1) NOT NULL |
Display Filter Related Fields
Y/N Table Edit Default Value: Y |
18 | MIN_SHOW_LAST | Character(1) | VARCHAR2(1) NOT NULL |
Display Prior Entry Caption
Y/N Table Edit Default Value: Y |
19 | MIN_CMPRT_SUPP | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Unique Compartments
Y/N Table Edit Default Value: N |
20 | DFLT_UOM_STOCK | Character(1) | VARCHAR2(1) NOT NULL |
Default Stocking UOM
Y/N Table Edit Default Value: Y |
21 | MIN_SHOW_HIDE_TBL | Character(1) | VARCHAR2(1) NOT NULL |
Display Show/Hide in tables
Y/N Table Edit Default Value: Y |
22 | MIN_ITEM_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
Item To Display in the Mobile Grid
1=Supplier Item ID 2=Mfg Item ID 3=PO Item ID Default Value: 1 |
23 | MIN_PRNT_DELRPT | Character(1) | VARCHAR2(1) NOT NULL |
Print Delivery Report
Y/N Table Edit Default Value: N |
24 | MIN_DL_DFLT_DEL_TO | Character(1) | VARCHAR2(1) NOT NULL |
Default Delivered To
Y/N Table Edit Default Value: Y |
25 | MIN_DL_PRF_DELSORT | Character(1) | VARCHAR2(1) NOT NULL |
Perform Delivery Sort By
1=Item ID 2=Deliver To Default Value: 1 |
26 | MIN_DL_SEL_ITMSORT | Character(1) | VARCHAR2(1) NOT NULL |
Select Items Sort By
1=Item ID 2=Deliver To Default Value: 1 |
27 | MIN_DL_DFLT_CART | Character(1) | VARCHAR2(1) NOT NULL |
Container ID
Y/N Table Edit Default Value: N |
28 | MIN_SET_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Set Select Checkbox
Y/N Table Edit Default Value: N |
29 | MIN_DC_ADD_ITMSORT | Character(1) | VARCHAR2(1) NOT NULL |
Add Items Sort By
1=Item ID 2=Deliver To Default Value: 1 |
30 | MIN_DC_CRT_ITMSORT | Character(1) | VARCHAR2(1) NOT NULL |
Delivery Cart Sort By
1=Item ID 2=Deliver To Default Value: 1 |
31 | MIN_DC_DFLT_CART | Character(10) | VARCHAR2(10) NOT NULL |
Container ID
Prompt Table: DELV_CART_VW |
32 | MIN_CNT_UOM_ENABLE | Character(1) | VARCHAR2(1) NOT NULL |
Count UOM Enabled
Y/N Table Edit Default Value: N |
33 | MIN_AII_OPT | Character(2) | VARCHAR2(2) NOT NULL |
05/10/11 EGS: Created
10=Item Only 20=Alternate Only 30=Item as Primary 40=Alternate as Primary Default Value: 10 |
34 | GET_ALL_ALT | Character(1) | VARCHAR2(1) NOT NULL |
06/01/11 EGS: Created
Y/N Table Edit Default Value: N |
35 | MIN_EXPAND_CMNTS | Character(1) | VARCHAR2(1) NOT NULL |
Field used to Expand Comments option on the Receiving PO Mobile transaction
Y/N Table Edit Default Value: N |
36 | MIN_AUTO_ADD_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Auto Add Search Results
Y/N Table Edit Default Value: N |
37 | MIN_DL_SAV_DLV_DOC | Character(1) | VARCHAR2(1) NOT NULL |
Save Delivery Document
Y/N Table Edit Default Value: N |
38 | 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 |
39 | SCHED_DATE_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
Determines how schedule dates will be entered on the Fulfillment Status Selection Criteria. Options are Today, a specific date and a range of date/time.
01=Today 02=Specific 03=Range |
40 | SHIP_DATE_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
Determines how shipment dates will be entered on the Fulfillment Status Selection Criteria. Options are Today, a specific date and a range of date/time.
01=Today 02=Specific 03=Range |
41 | MIN_SCHED_DT_DAYS | Number(3,0) | SMALLINT NOT NULL | Sched Days +/- Today |
42 | MIN_SHIP_DT_DAYS | Number(3,0) | SMALLINT NOT NULL | Ship Days +/- Today |
43 | ADJUST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Type
0=CM Only A=VMI Return D=Decrease I=Increase M=Misc Issue R=Misc Return S=Scrap V=Scrap RTV |
44 | MIN_STOR_LOC_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Display Storage Location
Y/N Table Edit |
45 | MIN_DISP_WARN_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Display Warning Messages
Y/N Table Edit |
46 | MIN_INTERIM_SAVE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Interim Save
Y/N Table Edit Default Value: N |
47 | MIN_CNT_FLT_FCS | Character(1) | VARCHAR2(1) NOT NULL |
Set Cursor on Filter Field
Y/N Table Edit Default Value: N |
48 | MIN_ITM_FDB_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Detail Display
A=All Items S=Single Item Default Value: S |
49 | MIN_DISPLAY_QTY | Character(1) | VARCHAR2(1) NOT NULL |
Display Par/Max Qty
Y/N Table Edit Default Value: Y |
50 | MIN_USE_INST_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
Use Installation Values
Y/N Table Edit Default Value: N |