MIN_TASK_OPTION(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | MIN_TASK_FLOW | 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 |
2 | DISPLAY_ROWS | Number(6,0) | INTEGER NOT NULL |
Determine number of rows to display in the grid
Default Value: 10 |
3 | 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 |
4 | 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 |
5 | MIN_CE_INITDISPLAY | Character(4) | VARCHAR2(4) NOT NULL |
Initial Display Mode
0001=Single Item 0002=All Items Default Value: 0001 |
6 | 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 |
7 | MIN_CE_STS_1 | Character(1) | VARCHAR2(1) NOT NULL |
New
Y/N Table Edit Default Value: Y |
8 | MIN_CE_STS_2 | Character(1) | VARCHAR2(1) NOT NULL |
Counting
Y/N Table Edit Default Value: N |
9 | MIN_CE_STS_3 | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Entered - Hold
Y/N Table Edit Default Value: N |
10 | MIN_CE_STS_4 | Character(1) | VARCHAR2(1) NOT NULL |
Ready to Update Stock Quantity
Y/N Table Edit Default Value: N |
11 | MIN_CE_PRELOAD_SER | Character(1) | VARCHAR2(1) NOT NULL |
Pre-Load Serial IDs
Y/N Table Edit Default Value: Y |
12 | MIN_EXPERT_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Expert Mode
Y/N Table Edit Default Value: N |
13 | MIN_PROMPTS | Character(1) | VARCHAR2(1) NOT NULL |
Display Lookups
Y/N Table Edit Default Value: Y |
14 | MIN_DESCRPT | Character(1) | VARCHAR2(1) NOT NULL |
Display Description
Y/N Table Edit Default Value: Y |
15 | MIN_COLLAPSE_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Collapse Header
Y/N Table Edit Default Value: N |
16 | MIN_SHOW_FILTER | Character(1) | VARCHAR2(1) NOT NULL |
Display Filter Related Fields
Y/N Table Edit Default Value: Y |
17 | MIN_SHOW_LAST | Character(1) | VARCHAR2(1) NOT NULL |
Display Prior Entry Caption
Y/N Table Edit Default Value: Y |
18 | MIN_CMPRT_SUPP | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Unique Compartments
Y/N Table Edit Default Value: N |
19 | DFLT_UOM_STOCK | Character(1) | VARCHAR2(1) NOT NULL |
Default Stocking UOM
Y/N Table Edit Default Value: Y |
20 | MIN_SHOW_HIDE_TBL | Character(1) | VARCHAR2(1) NOT NULL |
Display Show/Hide in tables
Y/N Table Edit Default Value: Y |
21 | 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 |
22 | MIN_PRNT_DELRPT | Character(1) | VARCHAR2(1) NOT NULL |
Print Delivery Report
Y/N Table Edit Default Value: N |
23 | MIN_DL_DFLT_DEL_TO | Character(1) | VARCHAR2(1) NOT NULL |
Default Delivered To
Y/N Table Edit Default Value: Y |
24 | MIN_DL_PRF_DELSORT | Character(1) | VARCHAR2(1) NOT NULL |
Perform Delivery Sort By
1=Item ID 2=Deliver To Default Value: 1 |
25 | MIN_DL_SEL_ITMSORT | Character(1) | VARCHAR2(1) NOT NULL |
Select Items Sort By
1=Item ID 2=Deliver To Default Value: 1 |
26 | MIN_DL_DFLT_CART | Character(1) | VARCHAR2(1) NOT NULL |
Container ID
Y/N Table Edit Default Value: N |
27 | MIN_SET_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Set Select Checkbox
Y/N Table Edit Default Value: N |
28 | MIN_DC_ADD_ITMSORT | Character(1) | VARCHAR2(1) NOT NULL |
Add Items Sort By
1=Item ID 2=Deliver To Default Value: 1 |
29 | MIN_DC_CRT_ITMSORT | Character(1) | VARCHAR2(1) NOT NULL |
Delivery Cart Sort By
1=Item ID 2=Deliver To Default Value: 1 |
30 | MIN_DC_DFLT_CART | Character(10) | VARCHAR2(10) NOT NULL |
Container ID
Prompt Table: DELV_CART_VW |
31 | MIN_CNT_UOM_ENABLE | Character(1) | VARCHAR2(1) NOT NULL |
Count UOM Enabled
Y/N Table Edit Default Value: N |
32 | 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 |
33 | GET_ALL_ALT | Character(1) | VARCHAR2(1) NOT NULL |
06/01/11 EGS: Created
Y/N Table Edit Default Value: N |
34 | 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 |
35 | MIN_AUTO_ADD_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Auto Add Search Results
Y/N Table Edit Default Value: N |
36 | MIN_DL_SAV_DLV_DOC | Character(1) | VARCHAR2(1) NOT NULL |
Save Delivery Document
Y/N Table Edit Default Value: N |
37 | 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 |
38 | 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 |
39 | 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 |
40 | MIN_SCHED_DT_DAYS | Number(3,0) | SMALLINT NOT NULL | Sched Days +/- Today |
41 | MIN_SHIP_DT_DAYS | Number(3,0) | SMALLINT NOT NULL | Ship Days +/- Today |
42 | 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 |
43 | MIN_STOR_LOC_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Display Storage Location
Y/N Table Edit |
44 | MIN_DISP_WARN_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Display Warning Messages
Y/N Table Edit |
45 | MIN_INTERIM_SAVE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Interim Save
Y/N Table Edit Default Value: N |
46 | MIN_CNT_FLT_FCS | Character(1) | VARCHAR2(1) NOT NULL |
Set Cursor on Filter Field
Y/N Table Edit Default Value: N |
47 | MIN_ITM_FDB_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Detail Display
A=All Items S=Single Item Default Value: S |
48 | MIN_DISPLAY_QTY | Character(1) | VARCHAR2(1) NOT NULL |
Display Par/Max Qty
Y/N Table Edit Default Value: Y |