RUN_CNTL_IN_VW

(SQL View)
 Index Back

PS/IN Process Run Control


SELECT A.OPRID , A.RUN_CNTL_ID , A.REQUEST_ID , A.LANGUAGE_CD , A.RPT_DEST , A.PROCESS_BEGIN , A.PROCESS_END , A.PROCESS_NAME , A.JOBID , A.BUSINESS_UNIT , A.SETID , A.ORDER_REL_OPTION , A.PICK_SINGLE_OPTION , A.PICK_ALL_OPTION , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_OPTION , A.ORDER_NO , A.ORDER_FROM , A.ORDER_TO , A.INV_ITEM_ID_OPTION , A.INV_ITEM_ID , A.INV_LOT_ITEM_ID , A.LOAD_ID , A.SHIP_TO_CUST_ID , A.LOCATION , A.CARRIER_ID , A.COUNTING_EVENT_ID , A.PICK_BATCH_ID , A.REPRINT_PICK_BATCH , A.PUSH_PULL , A.PICKING_SORT , A.ASC_DESC_FLAG , A.PAGE_BREAK , A.PICKING_SORT2 , A.ASC_DESC_FLG2 , A.PAGE_BREAK2 , A.PICKING_SORT3 , A.ASC_DESC_FLG3 , A.PAGE_BREAK3 , A.PICKING_DT_FROM , A.PICK_TIME_FROM , A.PICKING_DT_TO , A.PICK_TIME_TO , A.PICK_TIME_UNTIL , A.PICKING_DT_TYPE , A.PICKING_LEAD_DAYS , A.PICKING_LEAD_TIME , A.WAVE_OPTION , A.WAVE_SORT , A.WAVE_ASC_FLG , A.WAVE_BREAK , A.WAVE_SORT2 , A.WAVE_ASC_FLG2 , A.WAVE_SORT3 , A.WAVE_ASC_FLG3 , A.FILE_NAME , A.MAX_ITEMS , A.DOWNLOAD_TO_FILE , A.PRINT_LISTING , A.REPRINT , A.TRANSACTION_OPTION , A.TRANSACTION_GROUP , A.DATE_OPTION , A.AS_OF_DATE , A.DATE_FROM , A.DATE_TO , A.INV_COST_TYPE_OPT , A.SORT_OPTION_COST , A.INV_ITEM_GROUP , A.INV_PROD_FAM_CD , A.SUMMARY_PAGE , A.SHIP_ID , A.CART_OPTION , A.INV_CART_ID , A.CART_GROUP , A.AVG_DFLT_OPTION , A.ROUND_OPTION , A.COPY_NUM , A.SOLD_TO_CUST_ID , A.INV_EDI_OPTION , A.INV_EDI_FILE_OPT , A.ASN_REQUEST_NBR , A.RMA_ID , A.RMA_OPTION , A.BILL_OF_LADING , A.BOL_OPTION , A.DT_TIMESTAMP , A.BUSINESS_UNIT_RMA , A.SHIP_MANIFEST_NUM , A.FORECAST_MONTH , A.FORECAST_YEAR , A.PLANNER_CD , A.FORECAST_SET , A.FROZEN_PERIODS , A.BOOK_SHIP_FLAG , A.RUN_OPTION , A.STOR_AREA_OPTION , A.STORAGE_AREA , A.FROM_STOR_AREA , A.TO_STOR_AREA , A.STOR_LEV1_OPTION , A.STOR_LEVEL_1 , A.FROM_STOR_LEV1 , A.TO_STOR_LEV1 , A.DT_TIMESTAMP_FROM , A.DT_TIMESTAMP_TO , A.COST_ADJUSTMENTS , A.PPV_UPDATES , A.CUST_DETAIL , A.BEG_SEQ , A.LABEL_FORMAT_ID , A.UNIT_OF_MEASURE , A.INV_LOT_ID , A.INV_LOT_ID_2 , A.SERIAL_ID , A.QTY , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.GROUP_BY_UOM , A.NUMBER_OF_LABELS , A.NUMBER_IN_SEQ , A.START_NUMBER , A.STAGED_DATE , A.RECEIVER_ID , A.RECV_LN_NBR , A.DESCR60 , A.STANDARD_UOM , A.STANDARD_QTY , A.REFERENCE_NUM , A.FILE_DIRECTORY , A.PICKLIST_LINE_NO , A.OVERRIDE_FILE , A.AUTOGEN_LBL , A.FROM_ITEMID , A.TO_ITEMID , A.INV_ITEM_LIST_OPT , A.SLOW_INV_SORT , A.UTILIZ_GROUP , A.UTILIZ_RPT_OPT , A.NEG_INV_BAL_OPT , A.PRINT_BARCD , A.PRINT_BARCD_CTLFLG , A.PTWYPLAN_SELECTION , A.PTWYPLAN_SORT , A.PTWY_PLAN_ID , A.STAGING_ID , A.CARTON_LABELS , A.EXTRACT_FILE , A.LABEL_UOM , A.PRINT_LABEL_OPTION , A.ORDER_INT_LINE_NO , A.CRT_LBL_FILE_DIR , A.CRT_LBL_OVER_FILE , A.CRT_LBL_FILE_NAME , A.CRT_LBL_FORMAT_ID , A.EXTRACT_FILE_DIR , A.EXTRACT_OVER_FILE , A.EXTRACT_FILE_NAME , A.PRINT_ONLY , A.ROUTE_CD , A.WAVE_CD , A.PICK_RELEASE_ID , A.PICK_PLAN_COMMIT , A.PRINT_ITEM_SUBS , A.BU_BAL_RPT , A.LOT_BAL_RPT , A.PI_PO_BAL_RPT , A.DEMAND_BAL_RPT , A.SHOW_CALC_OPT , A.SHOW_ALL , A.SORT_OPTION_INV , A.STOR_LOC_SORT , A.MAX_PULL_LINES , A.EXPORT , A.SHIP_TYPE_ID , A.BACKORDER_FLAG , A.PROCESS_STATUS , A.REGEN_ORD_TRANS FROM PS_RUN_CNTL_IN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 RPT_DEST Character(50) VARCHAR2(50) NOT NULL File Destination
6 PROCESS_BEGIN Number(10,0) DECIMAL(10) NOT NULL Begin Process Instance
7 PROCESS_END Number(10,0) DECIMAL(10) NOT NULL End Process Instance
8 PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name

Prompt Table: PROCESS_VW

9 JOBID Character(10) VARCHAR2(10) NOT NULL Job ID

Prompt Table: MESSAGE_LOG

10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

11 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

12 ORDER_REL_OPTION Character(1) VARCHAR2(1) NOT NULL Order Release Option

Y/N Table Edit

Default Value: N

13 PICK_SINGLE_OPTION Character(3) VARCHAR2(3) NOT NULL Pick List Demand Selection Opt
010=Order Number
020=Item ID
030=Load ID
040=Ship To Customer
060=Location
070=Carrier ID
080=Route Code
090=Route Group
100=Order Range
110=Ship Method
120=TMS ID
14 PICK_ALL_OPTION Character(1) VARCHAR2(1) NOT NULL Pick All Demand Option

Y/N Table Edit

Default Value: Y

15 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
16 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: SP_BU_FS_NONVW

17 ORDER_OPTION Character(1) VARCHAR2(1) NOT NULL Order Number Options
A=All Orders
M=Multiple Orders
S=Single Order

Default Value: S

18 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

Prompt Table: %EDITTABLE

19 ORDER_FROM Character(10) VARCHAR2(10) NOT NULL Order No From
20 ORDER_TO Character(10) VARCHAR2(10) NOT NULL Order No To
21 INV_ITEM_ID_OPTION Character(1) VARCHAR2(1) NOT NULL Inventory Id Option
A=All Items
S=Single Item
22 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MASTER_ITEM_VW

23 INV_LOT_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: INV_ITM_LOT_VW2

24 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: DEMAND_LOAD_VW

25 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: %EDITTABLE2

26 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: DEMAND_LOC_VW

27 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: DMND_CARIER2_VW

28 COUNTING_EVENT_ID Number(15,0) DECIMAL(15) NOT NULL Counting Event ID

Prompt Table: %EDITTABLE2

29 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

Prompt Table: DEMAND_PCKID_VW

30 REPRINT_PICK_BATCH Character(1) VARCHAR2(1) NOT NULL Reprint Pick Batch

Y/N Table Edit

Default Value: N

31 PUSH_PULL Character(1) VARCHAR2(1) NOT NULL Locations Selected By
1=System (Push)
2=Picker (Pull)

Default Value: 1

32 PICKING_SORT Character(3) VARCHAR2(3) NOT NULL Used as the highest level sort parameter for the order lines which appear on the Picking Plan.
01=Item ID
02=Order No
03=Carrier ID
04=Ship To
05=Load ID
06=Location
07=Route
08=Route Stop
09=Priority
10=Ship Via
11=TMS ID
12=Load Stop
13=Freight
14=Customer
15=Address
16=Product ID
17=Parent Product
18=Delivery ID
30=Work Order
31=Task
32=Shop
33=Part
33 ASC_DESC_FLAG Character(1) VARCHAR2(1) NOT NULL Ascending or Descending
A=Ascending
D=Descending

Default Value: A

34 PAGE_BREAK Character(1) VARCHAR2(1) NOT NULL Pick Plan Page Break Option

Y/N Table Edit

Default Value: N

35 PICKING_SORT2 Character(3) VARCHAR2(3) NOT NULL Used as the 2nd level sort parameter for the order lines which appear on the Picking Plan.
01=Item ID
02=Order No
03=Carrier ID
04=Ship To
05=Load ID
06=Location
07=Route
08=Route Stop
09=Priority
10=Ship Via
11=TMS ID
12=Load Stop
13=Freight
14=Customer
15=Address
16=Product ID
17=Parent Product
18=Delivery ID
36 ASC_DESC_FLG2 Character(1) VARCHAR2(1) NOT NULL Ascending or Descending 2
A=Ascending
D=Descending

Default Value: A

37 PAGE_BREAK2 Character(1) VARCHAR2(1) NOT NULL Pick Plan Page Break Option 2

Y/N Table Edit

Default Value: N

38 PICKING_SORT3 Character(3) VARCHAR2(3) NOT NULL Used as the 3rd level sort parameter for the order lines which appear on the Picking Plan.
01=Item ID
02=Order No
03=Carrier ID
04=Ship To
05=Load ID
06=Location
07=Route
08=Route Stop
09=Priority
10=Ship Via
11=TMS ID
12=Load Stop
13=Freight
14=Customer
15=Address
16=Product ID
17=Parent Product
18=Delivery ID
39 ASC_DESC_FLG3 Character(1) VARCHAR2(1) NOT NULL Ascending or Descending 3
A=Ascending
D=Descending

Default Value: A

40 PAGE_BREAK3 Character(1) VARCHAR2(1) NOT NULL Pick Plan Page Break Option 3

Y/N Table Edit

Default Value: N

41 PICKING_DT_FROM Date(10) DATE Picking Selection From Date
42 PICK_TIME_FROM Time(15) TIMESTAMP Picking From Time
43 PICKING_DT_TO Date(10) DATE Picking Selection To Date
44 PICK_TIME_TO Time(15) TIMESTAMP Picking To Time
45 PICK_TIME_UNTIL Time(15) TIMESTAMP Picking Until Time
46 PICKING_DT_TYPE Character(3) VARCHAR2(3) NOT NULL Used to determine the Date selection criteria used when submitting jobs to the Picking Plan.
01=Date/Time Range
02=Lead Days/Minutes
03=Today/Until

Default Value: DF_SETUP_INV.PICKING_DT_TYPE

47 PICKING_LEAD_DAYS Number(3,0) SMALLINT NOT NULL Picking Lead Days
48 PICKING_LEAD_TIME Number(3,0) SMALLINT NOT NULL Picking Lead Minutes
49 WAVE_OPTION Character(2) VARCHAR2(2) NOT NULL Print Location Summary
01=Picking Plan Only
02=Location Summary Only
03=Picking Plan and Loc Summary

Default Value: 01

50 WAVE_SORT Character(3) VARCHAR2(3) NOT NULL Used as the highest level sort parameter on the Location Summary option of the Picking Plan.
01=ASRS ID
02=Zone/ASRS
21=Zone
22=Storage Location
23=Area
50=Zone/Stor Loc
51=Area/Zone
52=Area/Zone/Stor Loc
53=Area/Zone/ASRS
51 WAVE_ASC_FLG Character(1) VARCHAR2(1) NOT NULL Ascending or Descending
A=Ascending Order
D=Descending Order

Default Value: A

52 WAVE_BREAK Character(1) VARCHAR2(1) NOT NULL Wave Page Break Option

Y/N Table Edit

Default Value: N

53 WAVE_SORT2 Character(3) VARCHAR2(3) NOT NULL Used as the 2nd level sort parameter on the Location Summary option of the Picking Plan.
02=Order No
03=Carrier ID
04=Ship To
05=Load ID
06=Location
07=Route
08=Route Stop
09=Order Priority
10=Ship Via
11=TMS Reference ID
12=Load Stop Number
13=Freight Terms
14=Customer ID
15=Address Seq Num
16=Product ID
17=Parent Product ID
18=Delivery ID
30=Work Order ID
31=Work Order Task
32=Shop ID
54 WAVE_ASC_FLG2 Character(1) VARCHAR2(1) NOT NULL Ascending or Descending 2
A=Ascending Order
D=Descending Order

Default Value: A

55 WAVE_SORT3 Character(3) VARCHAR2(3) NOT NULL Used as the 3rd level sort parameter on the Location Summary option of the Picking Plan.
02=Order No
03=Carrier ID
04=Ship To
05=Load ID
06=Location
07=Route
08=Route Stop
09=Order Priority
10=Ship Via
11=TMS Reference ID
12=Load Stop Number
13=Freight Terms
14=Customer ID
15=Address Seq Num
16=Product ID
17=Parent Product ID
18=Delivery ID
30=Work Order ID
31=Work Order Task
32=Shop ID
56 WAVE_ASC_FLG3 Character(1) VARCHAR2(1) NOT NULL Ascending or Descending 3
A=Ascending Order
D=Descending Order

Default Value: A

57 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
58 MAX_ITEMS Number(6,0) INTEGER NOT NULL Maximum Items to Select
59 DOWNLOAD_TO_FILE Character(1) VARCHAR2(1) NOT NULL Create File

Y/N Table Edit

60 PRINT_LISTING Character(1) VARCHAR2(1) NOT NULL Print Listing

Y/N Table Edit

61 REPRINT Character(1) VARCHAR2(1) NOT NULL Reprint All Items

Y/N Table Edit

Default Value: N

62 TRANSACTION_OPTION Character(1) VARCHAR2(1) NOT NULL Transaction Type Option
A=All
S=Single

Default Value: A

63 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
64 DATE_OPTION Character(1) VARCHAR2(1) NOT NULL Date Option
A=As of Date
R=Range
T=Today

Default Value: T

65 AS_OF_DATE Date(10) DATE As of Date
66 DATE_FROM Date(10) DATE Date From
67 DATE_TO Date(10) DATE Date To
68 INV_COST_TYPE_OPT Character(1) VARCHAR2(1) NOT NULL 08/04/1999 whs (CN#CM800-17.0) deactivated actual cost xlat value. Rename xlt from 'average' to 'perpetual weighted average'
1=Perpetual Weight Avg Costed
2=Actual Costed
3=Standard Costed
4=All Costed Inventory Items

Default Value: 4

69 SORT_OPTION_COST Character(1) VARCHAR2(1) NOT NULL 8/20/99 whs CM800-17.0 Added Alternate Account to Xlat values
1=Item ID
2=Cost Type / Item ID
3=Item Group / Item ID
4=Product Family Code / Item ID
5=Account
6=Alternate Account

Default Value: 1

70 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

Prompt Table: INV_ITEM_GROUP

71 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

Prompt Table: INV_ITEM_FAM

72 SUMMARY_PAGE Character(1) VARCHAR2(1) NOT NULL Summary Page Only

Y/N Table Edit

73 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

Prompt Table: DEMAND_LIST_VW

74 CART_OPTION Character(3) VARCHAR2(3) NOT NULL Par Location Option
01=All Par Locations for Unit
02=Specific Par Location for Unit
03=All for Par Location Group
04=All Par Locations

Default Value: 01

75 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID

Prompt Table: CART_ATTRIB_INV

76 CART_GROUP Character(5) VARCHAR2(5) NOT NULL Par Location Group
77 AVG_DFLT_OPTION Character(1) VARCHAR2(1) NOT NULL Use Average Count as Default

Y/N Table Edit

Default Value: N

78 ROUND_OPTION Character(3) VARCHAR2(3) NOT NULL Rounding Option
01=Do Not Round
02=Round to Nearest Integer
03=Round Down to Prior Integer
04=Round Up to Next Integer

Default Value: 02

79 COPY_NUM Number(2,0) SMALLINT NOT NULL Number of Copies Printed

Default Value: 1

80 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: %EDITTABLE

81 INV_EDI_OPTION Character(1) VARCHAR2(1) NOT NULL Inventory ASN EDI Option
A=All Shipments
D=Sold To Customer
H=Ship To Customer
I=Shipping ID
V=Delivery ID
82 INV_EDI_FILE_OPT Character(1) VARCHAR2(1) NOT NULL Generate EDI File

Y/N Table Edit

Default Value: N

83 ASN_REQUEST_NBR Number(6,0) INTEGER NOT NULL ASN Request Number
84 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number

Prompt Table: RMA_REPORT_VW

85 RMA_OPTION Character(1) VARCHAR2(1) NOT NULL RMA Number Options
A=All RMAs
S=Single RMA
86 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.

Prompt Table: BOL_INV2_VW

87 BOL_OPTION Character(1) VARCHAR2(1) NOT NULL BOL Options
A=Load All BOLs
S=Load Single BOL
88 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
89 BUSINESS_UNIT_RMA Character(5) VARCHAR2(5) NOT NULL RMA Business Unit

Prompt Table: SP_BU_FS_NONVW

90 SHIP_MANIFEST_NUM Character(10) VARCHAR2(10) NOT NULL Shipping Manifest Number

Prompt Table: BOL_INV_MFST_VW

91 FORECAST_MONTH Number(2,0) SMALLINT NOT NULL Forecast Month
92 FORECAST_YEAR Number(4,0) SMALLINT NOT NULL Forecast Year
93 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

Prompt Table: PLANNER_TBL

94 FORECAST_SET Character(20) VARCHAR2(20) NOT NULL Forecast Set

Prompt Table: FORECAST_SET

95 FROZEN_PERIODS Number(2,0) SMALLINT NOT NULL Frozen Periods
96 BOOK_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Booking or Shipments
B=Bookings
S=Shipments
97 RUN_OPTION Character(1) VARCHAR2(1) NOT NULL Initial Download
I=Initial Download
M=Monthly

Default Value: M

98 STOR_AREA_OPTION Character(1) VARCHAR2(1) NOT NULL Storage Area Options
A=All Storage Areas
R=Range of Storage Areas
S=Single Storage Area
99 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_AREA_VW2

100 FROM_STOR_AREA Character(5) VARCHAR2(5) NOT NULL From storage area

Prompt Table: STOR_AREA_VW2

101 TO_STOR_AREA Character(5) VARCHAR2(5) NOT NULL To Storage Location

Prompt Table: STOR_AREA_VW2

102 STOR_LEV1_OPTION Character(1) VARCHAR2(1) NOT NULL Storage Level 1 Options
A=All Storage Levels
R=Range of Storage Levels
S=Single Storage Level
103 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: STOR_LEV1_VW2

104 FROM_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL From Storage Level 1

Prompt Table: STOR_LEV1_VW2

105 TO_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL To Storage Level 1

Prompt Table: STOR_LEV1_VW2

106 DT_TIMESTAMP_FROM DateTime(26) TIMESTAMP From Date Timestamp
107 DT_TIMESTAMP_TO DateTime(26) TIMESTAMP To Date Timestamp
108 COST_ADJUSTMENTS Character(1) VARCHAR2(1) NOT NULL Cost Adjustments

Y/N Table Edit

Default Value: Y

109 PPV_UPDATES Character(1) VARCHAR2(1) NOT NULL PPV Updates

Y/N Table Edit

Default Value: N

110 CUST_DETAIL Character(1) VARCHAR2(1) NOT NULL Include Customer Detail

Y/N Table Edit

111 BEG_SEQ Character(3) VARCHAR2(3) NOT NULL Beginning Sequence

Prompt Table: %EDITTABLE4

112 LABEL_FORMAT_ID Character(30) VARCHAR2(30) NOT NULL Format ID

Prompt Table: %EDITTABLE3

113 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: INV_STCK_UOM_VW

114 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Prompt Table: LOT_CONTROL_INV

115 INV_LOT_ID_2 Character(15) VARCHAR2(15) NOT NULL Lot ID

Prompt Table: LOT_PT_INV_VW10

116 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Prompt Table: SERIAL_INV_VW

117 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
118 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: STOR_LEV2_VW2

119 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: STOR_LEV3_VW2

120 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: STOR_LEV4_VW2

121 GROUP_BY_UOM Character(3) VARCHAR2(3) NOT NULL Group by UOM
122 NUMBER_OF_LABELS Number(3,0) SMALLINT NOT NULL Nbr of Labels

Default Value: 1

123 NUMBER_IN_SEQ Number(3,0) SMALLINT NOT NULL Nbr in Seq

Default Value: 1

124 START_NUMBER Number(18,0) DECIMAL(18) NOT NULL Starting Number
125 STAGED_DATE Date(10) DATE Staged Date
126 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
127 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
128 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
129 STANDARD_UOM Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
130 STANDARD_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Standard Quantity
131 REFERENCE_NUM Character(30) VARCHAR2(30) NOT NULL Reference
132 FILE_DIRECTORY Character(80) VARCHAR2(80) NOT NULL File Directory
133 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
134 OVERRIDE_FILE Character(1) VARCHAR2(1) NOT NULL Override File

Y/N Table Edit

Default Value: N

135 AUTOGEN_LBL Character(1) VARCHAR2(1) NOT NULL Autogenerate Labels

Y/N Table Edit

Default Value: N

136 FROM_ITEMID Character(18) VARCHAR2(18) NOT NULL 04/10/00 SCC (Internet Architecture): Add label ITEM_ID
137 TO_ITEMID Character(18) VARCHAR2(18) NOT NULL To Item ID
138 INV_ITEM_LIST_OPT Character(1) VARCHAR2(1) NOT NULL Item List Option
A=All Items
C=Category
F=Item Family
G=Item Group
R=Range of Items
S=Single Item
139 SLOW_INV_SORT Character(1) VARCHAR2(1) NOT NULL Sort Criteria
T=Number of Transactions
U=Number of Units Transacted
V=Demand Value Transacted
140 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
CYCL=Cycle Count
141 UTILIZ_RPT_OPT Character(1) VARCHAR2(1) NOT NULL Modified 8/4/03 by David Bernardo - removed translate of N
B=Both Summary and Detail Report
D=Detail Report Only
N=No Report
S=Summary Report Only
142 NEG_INV_BAL_OPT Character(1) VARCHAR2(1) NOT NULL Negative Inv Option
1=Include Negative Inv Balances
2=Exclude Negative Inv Balances
3=Include Negative Inv Bal Only
143 PRINT_BARCD Character(1) VARCHAR2(1) NOT NULL Print Bar Code on Report Flag
144 PRINT_BARCD_CTLFLG Character(1) VARCHAR2(1) NOT NULL Print Bar Coded Control Flags
145 PTWYPLAN_SELECTION Character(1) VARCHAR2(1) NOT NULL Putaway Plan Selection Option
0=All Staging IDs
1=Specific Staging ID
146 PTWYPLAN_SORT Character(1) VARCHAR2(1) NOT NULL Putaway Plan Sort Order
0=Item ID
1=Receiver ID
2=Storage Location
147 PTWY_PLAN_ID Number(10,0) DECIMAL(10) NOT NULL Putaway Plan ID
148 STAGING_ID Number(15,0) DECIMAL(15) NOT NULL Putaway Staging ID
149 CARTON_LABELS Character(1) VARCHAR2(1) NOT NULL Generate Carton Labels
150 EXTRACT_FILE Character(1) VARCHAR2(1) NOT NULL Create Extract File
151 LABEL_UOM Character(1) VARCHAR2(1) NOT NULL Unit of Measure
1=Order
2=Standard
3=Standard Pack
152 PRINT_LABEL_OPTION Character(1) VARCHAR2(1) NOT NULL Printing Selection
1=Pick Batch ID
2=Order Number
3=Generate
4=Reprint
5=Par Location
6=Item ID
7=All Unprocessed Receipts
8=Print Specific Receipt
153 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
154 CRT_LBL_FILE_DIR Character(80) VARCHAR2(80) NOT NULL File Directory
155 CRT_LBL_OVER_FILE Character(1) VARCHAR2(1) NOT NULL Override File
156 CRT_LBL_FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
157 CRT_LBL_FORMAT_ID Character(30) VARCHAR2(30) NOT NULL Format ID
158 EXTRACT_FILE_DIR Character(80) VARCHAR2(80) NOT NULL File Directory
159 EXTRACT_OVER_FILE Character(1) VARCHAR2(1) NOT NULL Override File
160 EXTRACT_FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
161 PRINT_ONLY Character(1) VARCHAR2(1) NOT NULL Print Control
162 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.

Prompt Table: ROUTE_INV_VW
Set Control Field: BUSINESS_UNIT

163 WAVE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier used to group together one or more delivery route codes.

Prompt Table: WAVE_INV
Set Control Field: BUSINESS_UNIT

164 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID
165 PICK_PLAN_COMMIT Number(6,0) INTEGER NOT NULL Pick Plan Commit Batch
166 PRINT_ITEM_SUBS Character(1) VARCHAR2(1) NOT NULL Print Substitutes
N=No
Y=Yes

Y/N Table Edit

Default Value: N

167 BU_BAL_RPT Character(1) VARCHAR2(1) NOT NULL Business Unit Level Balances

Y/N Table Edit

Default Value: N

168 LOT_BAL_RPT Character(1) VARCHAR2(1) NOT NULL Lot Level Balances

Y/N Table Edit

Default Value: N

169 PI_PO_BAL_RPT Character(1) VARCHAR2(1) NOT NULL Storage Location Balances

Y/N Table Edit

Default Value: N

170 DEMAND_BAL_RPT Character(1) VARCHAR2(1) NOT NULL Rollup of Demand Tables

Y/N Table Edit

Default Value: N

171 SHOW_CALC_OPT Character(1) VARCHAR2(1) NOT NULL Show Calc for BU Balances

Y/N Table Edit

Default Value: N

172 SHOW_ALL Character(1) VARCHAR2(1) NOT NULL Show All Detail

Y/N Table Edit

Default Value: N

173 SORT_OPTION_INV Character(1) VARCHAR2(1) NOT NULL Sort Option
1=Item ID
2=Transaction Group
174 STOR_LOC_SORT Character(2) VARCHAR2(2) NOT NULL STOR_LOC_SORT
01=ASRS ID
02=Storage Area/Levels

Default Value: 01

175 MAX_PULL_LINES Number(2,0) SMALLINT NOT NULL Max Suggest/Sub Locations

Default Value: 5

176 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

Default Value: N

177 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
178 BACKORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Backorder Flag
179 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
180 REGEN_ORD_TRANS Character(1) VARCHAR2(1) NOT NULL Regenerate Order Transactions

Y/N Table Edit

Default Value: N