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