| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
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
|
| 4 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 5 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 6 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 7 |
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
|
| 8 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 9 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 10 |
PROCESS_INST_STG |
Number(10,0) |
DECIMAL(10) NOT NULL |
Stage Record Process Instance
|
| 11 |
JOBNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Process Scheduler Job Name
|
| 12 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %Datetime
|
| 13 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 14 |
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
|
| 15 |
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.
|
| 16 |
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
|
| 17 |
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.
|
| 18 |
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
|
| 19 |
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
|
| 20 |
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
|
| 21 |
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
|
| 22 |
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
|
| 23 |
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
|
| 24 |
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
|
| 25 |
TRANSACTION_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table:
BCT_XFUL_INV_VW
|
| 26 |
AUTO_SCHED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto-Scheduled Job
Y/N Table Edit
Default Value: N
|
| 27 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 28 |
PROCESS_MODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Run Mode
JB=Job Mode
ON=Online Mode
PR=Process Mode
TR=Transaction Mode
Default Value: JB
|
| 29 |
EIP_CTL_ID_FROM |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
Prompt Table:
%EDITTABLE21
|
| 30 |
EIP_CTL_ID_TO |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
Prompt Table:
%EDITTABLE21
|
| 31 |
PROCESS_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-process any Errors in Range
Y/N Table Edit
Default Value: N
|
| 32 |
EIP_TRANS_SRC_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Source Reference
|
| 33 |
EIP_TRANS_SRC |
Character(30) |
VARCHAR2(30) NOT NULL |
08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)
|
| 34 |
PUBNODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
Prompt Table:
PSMSGNODEDEFN
|
| 35 |
CHNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Channel Name (see PSCHNLDEFN).
|
| 36 |
PUBID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Publication Identifier
Prompt Table:
BCT_PUBID_VW
|
| 37 |
MSGNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
|
| 38 |
SUBNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of a Subscription, which defines which subscription process is invoked when you receive an application message.
|
| 39 |
DELETE_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
DELETE_CONTROL
Y/N Table Edit
Default Value: N
|
| 40 |
ALL_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
All Business Units
N=Specific Business Unit
Y=All Business Units
Y/N Table Edit
Default Value: N
|
| 41 |
SL_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 42 |
TO_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 43 |
ORDER_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Choose the Orders to Process
1=Schedule Date
2=Order Date
3=Ship Early Date
4=Orders Placed Today
|
| 44 |
SL_DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source selection
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Sourced Demand
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order Demand
|
| 45 |
SL_SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Business Unit selection
Prompt Table:
SP_BU_FS_NONVW
|
| 46 |
TO_SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
12/10/02 NRA (CN#PL880-1): Defined
|
| 47 |
SL_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
Prompt Table:
%EDITTABLE2
|
| 48 |
TO_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
Prompt Table:
%EDITTABLE2
|
| 49 |
SL_ORDER_INT_LINE |
Number(5,0) |
INTEGER NOT NULL |
Order Line selection
Prompt Table:
%EDITTABLE3
|
| 50 |
TO_ORDER_INT_LINE |
Number(5,0) |
INTEGER NOT NULL |
Order Line selection
Prompt Table:
%EDITTABLE3
|
| 51 |
SL_SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
05/07/04 PWF Added field for new 8.9 data model changes
Prompt Table:
%EDITTABLE4
|
| 52 |
TO_SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
05/07/04 PWF Added field for 8.9 data model changes
|
| 53 |
SL_SCHED_LINE_NO |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Schedule Line Number selection
Prompt Table:
%EDITTABLE4
|
| 54 |
TO_SCHED_LINE_NO |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Schedule Line Number selection
Prompt Table:
%EDITTABLE4
|
| 55 |
SL_INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item selection
Prompt Table:
%EDIT_ITEM_ID
Set Control Field: SL_BUSINESS_UNIT
|
| 56 |
SL_DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line Number selection
|
| 57 |
SL_SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer selection
Prompt Table:
%EDITTABLE6
Set Control Field: SL_SOURCE_BUS_UNIT
|
| 58 |
SL_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID selection
Prompt Table:
%EDITTABLE5
Set Control Field: SL_SOURCE_BUS_UNIT
|
| 59 |
SL_ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number selection
Prompt Table:
%EDITTABLE7
|
| 60 |
SL_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location selection
Prompt Table:
IN_LOC_VW
Set Control Field: SL_BUSINESS_UNIT
|
| 61 |
SL_LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load selection
Prompt Table:
INV_LOAD_FULVW
|
| 62 |
SL_SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via selection
Prompt Table:
SHIP_METHOD_VW
Set Control Field: SL_BUSINESS_UNIT
|
| 63 |
TO_SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via selection
Prompt Table:
SHIP_METHOD_VW
Set Control Field: SL_BUSINESS_UNIT
|
| 64 |
SL_CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier selection
Prompt Table:
CARRIER_VW
Set Control Field: SL_BUSINESS_UNIT
|
| 65 |
TO_CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier selection
Prompt Table:
CARRIER_VW
Set Control Field: SL_BUSINESS_UNIT
|
| 66 |
SL_ROUTE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Route selection
Prompt Table:
ROUTE_INV_FULVW
|
| 67 |
SL_WAVE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Route Group selection
Prompt Table:
WAVE_INV_FULVW
|
| 68 |
TO_WAVE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Route Group selection
Prompt Table:
WAVE_INV_FULVW
|
| 69 |
SL_PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product selection
Prompt Table:
PROD_VW_BU
Set Control Field: SL_BUSINESS_UNIT
|
| 70 |
SL_DEMAND_DATE |
Date(10) |
DATE |
Demand Date selection
|
| 71 |
TO_DEMAND_DATE |
Date(10) |
DATE |
Demand Date selection
|
| 72 |
SL_SCHED_SHIP_DATE |
Date(10) |
DATE |
Scheduled Ship Date selection
|
| 73 |
SL_SCHED_SHIP_TIME |
Time(15) |
TIMESTAMP |
Scheduled Ship Time
|
| 74 |
TO_SCHED_SHIP_DATE |
Date(10) |
DATE |
Scheduled Ship Date selection
|
| 75 |
TO_SCHED_SHIP_TIME |
Time(15) |
TIMESTAMP |
Scheduled Ship Time selection
|
| 76 |
SL_SHIP_EARLY_DATE |
Date(10) |
DATE |
Ship Early Date selection
|
| 77 |
SL_SHIP_EARLY_TIME |
Time(15) |
TIMESTAMP |
Ship Early Time selection
|
| 78 |
TO_SHIP_EARLY_DATE |
Date(10) |
DATE |
Ship Early Date selection
|
| 79 |
TO_SHIP_EARLY_TIME |
Time(15) |
TIMESTAMP |
Ship Early Time selection
|
| 80 |
SL_SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship ID Selection
Prompt Table:
%EDITTABLE14
|
| 81 |
TO_SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship ID Selection
Prompt Table:
%EDITTABLE14
|
| 82 |
SL_CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer Purchase Order selection
|
| 83 |
SL_CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract ID selection
|
| 84 |
SL_PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID selection
Prompt Table:
%EDITTABLE9
|
| 85 |
TO_PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID selection
Prompt Table:
%EDITTABLE9
|
| 86 |
SL_PICKLIST_LINE |
Number(7,0) |
INTEGER NOT NULL |
Pick List Line Number selection
Prompt Table:
%EDITTABLE10
|
| 87 |
TO_PICKLIST_LINE |
Number(7,0) |
INTEGER NOT NULL |
Pick List Line Number selection
Prompt Table:
%EDITTABLE10
|
| 88 |
SL_SHIP_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Ship Container selection
Prompt Table:
SHIP_CNTR_FULVW
|
| 89 |
SL_TMS_EXT_REF_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Transportation Management System (TMS) Reference ID selection
Prompt Table:
%EDITTABLE8
|
| 90 |
SL_TMS_EXT_REF_LN |
Number(7,0) |
INTEGER NOT NULL |
Transportation Management System (TMS) Reference Line
Prompt Table:
%EDITTABLE15
|
| 91 |
SL_EXT_REF_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
External Reference Number selection
Prompt Table:
%EDITTABLE23
|
| 92 |
SL_EXT_REF_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
External Reference Line selection
Prompt Table:
%EDITTABLE24
|
| 93 |
SL_PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 94 |
TO_PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 95 |
SL_PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
Prompt Table:
%EDITTABLE16
Set Control Field: SL_BUSINESS_UNIT
|
| 96 |
TO_PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 97 |
SL_SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop
Prompt Table:
%EDITTABLE25
|
| 98 |
TO_SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop ID
Prompt Table:
%EDITTABLE25
|
| 99 |
SL_WO_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table:
IN_WM_WO_TYP_VW
|
| 100 |
SL_PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
IN_WM_PC_PRJ_VW
|
| 101 |
SL_SRVC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Group
Prompt Table:
IN_WM_SRGRP_VW
|
| 102 |
SL_WO_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
IN_WM_LOC_VW
|
| 103 |
SL_DELIVERY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
From Delivery ID
Prompt Table:
%EDITTABLE11
|
| 104 |
TO_DELIVERY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
To Delivery ID
Prompt Table:
%EDITTABLE11
|
| 105 |
AUTO_PICK_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
The field is used to select the auto pick options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
Default Value: 0
|
| 106 |
AUTO_SHIP_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to capture the auto ship options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
Default Value: 0
|
| 107 |
AUTO_DEPL_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to capture the auto ship options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
Default Value: 0
|
| 108 |
AUTO_PICK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Pick
Y/N Table Edit
Default Value: N
|
| 109 |
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
|
| 110 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table:
SHIP_FUL_INV_VW
|
| 111 |
SHIP_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Ship Id should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 112 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
CARRIER_VW
Set Control Field: SL_BUSINESS_UNIT
|
| 113 |
CARRIER_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Carrier ID should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 114 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD_VW
Set Control Field: SL_BUSINESS_UNIT
|
| 115 |
SHIP_TYPE_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Ship Via should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 116 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 117 |
SHIP_DATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Ship Date should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 118 |
SHIP_TIME |
Time(15) |
TIMESTAMP |
Ship Time
|
| 119 |
SHIP_TIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Ship Time should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 120 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
STOR_AREA_VW2
Set Control Field: SL_BUSINESS_UNIT
|
| 121 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
STOR_LEV1_VW2
Set Control Field: SL_BUSINESS_UNIT
|
| 122 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
STOR_LEV2_VW2
Set Control Field: SL_BUSINESS_UNIT
|
| 123 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
STOR_LEV3_VW2
Set Control Field: SL_BUSINESS_UNIT
|
| 124 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
STOR_LEV4_VW2
Set Control Field: SL_BUSINESS_UNIT
|
| 125 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
Prompt Table:
%EDITTABLE35
|
| 126 |
BILL_OF_LADING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Bill of Lading should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 127 |
TO_BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
Prompt Table:
%EDITTABLE35
|
| 128 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 129 |
PRO_NUMBER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Pro Number should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 130 |
TRACKING_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tracking Number
|
| 131 |
TRACKING_NBR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Tracking Number
Y/N Table Edit
Default Value: N
|
| 132 |
SHORT_SHIP_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Short Shipment Option
01=Scrap the Undershipment
02=Return to Location Picked From
Default Value: 02
|
| 133 |
FREIGHT_CALC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Calculate Flag
Y/N Table Edit
Default Value: N
|
| 134 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 135 |
FREIGHT_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Freight Amount should be overridden with a blank (zero) value
Y/N Table Edit
Default Value: N
|
| 136 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
FREIGHT_TERMS
Set Control Field: SL_BUSINESS_UNIT
|
| 137 |
FREIGHT_TERMS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Freight Terms should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 138 |
LEAD_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Lead Days for Calendar
|
| 139 |
USE_LEAD_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Lead Days
1=Use Fulfillment Lead Days
2=Override Fulfillment Lead Days
3=Ignore Lead Days
Default Value: 1
|
| 140 |
SHIP_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Shipping Container ID
|
| 141 |
CLEAR_OVERRIDES |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates override data should be cleared from the page the next time the page is entered by the user.
Y/N Table Edit
Default Value: Y
|
| 142 |
IN_ORD_REL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by Order Release Run Control
1=Create Allocations
2=Make Suggestions
3=Release Only
4=Create Pre-Allocations
5=Deallocation
6=Cancel Allocations
7=Return to Unfulfilled
8=Return to Releasable
9=Regenerate Output
A=Return to Released
B=Return to Confirmed
S=Select an Action
Default Value: 1
|
| 143 |
IN_PICKPLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Picking Plan
Y/N Table Edit
Default Value: Y
|
| 144 |
SEL_ORD_REL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created for outbound messaging.
Y/N Table Edit
Default Value: N
|
| 145 |
EXPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 146 |
CARTON_LABELS |
Character(1) |
VARCHAR2(1) NOT NULL |
Carton Labels
Y/N Table Edit
Default Value: N
|
| 147 |
PICK_ALL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick All Demand Option
Y/N Table Edit
Default Value: Y
|
| 148 |
IN_LOC_SELECT_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Locations Selected By
1=Picking Rules
2=Default Shipping Location
3=Specific Location
Default Value: 1
|
| 149 |
IN_SINGLE_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Location Only
Y/N Table Edit
Default Value: N
|
| 150 |
IN_ORDREL_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Release Selection
1=All
2=Specific
3=Advanced Selection Criteria
Default Value: 1
|
| 151 |
IN_MRK_CONFIRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Pick
Y/N Table Edit
Default Value: N
|
| 152 |
REPRINT_PICK_BATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprint Pick Batch
Y/N Table Edit
Default Value: N
|
| 153 |
PUBLISH |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish Data
Y/N Table Edit
Default Value: N
|
| 154 |
BACKORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
Y/N Table Edit
Default Value: N
|
| 155 |
BU_BAL_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Level Balances
Y/N Table Edit
Default Value: N
|
| 156 |
PRINT_BARCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Code on Report Flag
Y/N Table Edit
Default Value: N
|
| 157 |
PRINT_BARCD_CTLFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Coded Control Flags
Y/N Table Edit
Default Value: N
|
| 158 |
PICK_RELEASE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Release ID
|
| 159 |
PICK_NOLOAD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TMS Lines Awaiting Upload
Y/N Table Edit
Default Value: N
|
| 160 |
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
|
| 161 |
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
|
| 162 |
PICKING_DT_FROM |
Date(10) |
DATE |
Picking Selection From Date
|
| 163 |
PICK_TIME_FROM |
Time(15) |
TIMESTAMP |
Picking From Time
|
| 164 |
PICKING_DT_TO |
Date(10) |
DATE |
Picking Selection To Date
|
| 165 |
PICK_TIME_TO |
Time(15) |
TIMESTAMP |
Picking To Time
|
| 166 |
PICKING_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Picking Lead Days
|
| 167 |
PICKING_LEAD_TIME |
Number(3,0) |
SMALLINT NOT NULL |
Picking Lead Minutes
|
| 168 |
PICK_TIME_UNTIL |
Time(15) |
TIMESTAMP |
Picking Until Time
|
| 169 |
REGEN_ORD_TRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Regenerate Order Transactions
Y/N Table Edit
Default Value: N
|
| 170 |
ORDER_REL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Orders
Y/N Table Edit
Default Value: N
|
| 171 |
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
|
| 172 |
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
|
| 173 |
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
|
| 174 |
PICK_PLAN_COMMIT |
Number(6,0) |
INTEGER NOT NULL |
Pick Plan Commit Batch
Default Value: 1000
|
| 175 |
ASC_DESC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending
A=Ascending
D=Descending
Default Value: A
|
| 176 |
ASC_DESC_FLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 2
A=Ascending
D=Descending
Default Value: A
|
| 177 |
ASC_DESC_FLG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 3
A=Ascending
D=Descending
Default Value: A
|
| 178 |
PAGE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option
Y/N Table Edit
Default Value: N
|
| 179 |
PAGE_BREAK2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option 2
Y/N Table Edit
Default Value: N
|
| 180 |
PAGE_BREAK3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option 3
Y/N Table Edit
Default Value: N
|
| 181 |
PICK_BATCH_BRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Batch Break
Y/N Table Edit
Default Value: N
|
| 182 |
PICK_BATCH_BRK2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Batch Break 3
Y/N Table Edit
Default Value: N
|
| 183 |
PICK_BATCH_BRK3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Batch Break 2
Y/N Table Edit
Default Value: N
|
| 184 |
PRINT_ITEM_SUBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Substitutes
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 185 |
MAX_PULL_LINES |
Number(2,0) |
SMALLINT NOT NULL |
Max Suggest/Sub Locations
Default Value: 6
|
| 186 |
USG_LABEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Usage Labels
Y/N Table Edit
Default Value: N
|
| 187 |
USG_LBL_FILE_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 188 |
USG_LBL_FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 189 |
USG_LBL_OVER_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit
Default Value: N
|
| 190 |
EXTRACT_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Extract File
Y/N Table Edit
Default Value: N
|
| 191 |
EXTRACT_FILE_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 192 |
EXTRACT_FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 193 |
EXTRACT_OVER_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit
Default Value: N
|
| 194 |
WAVE_ASC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending
A=Ascending Order
D=Descending Order
Default Value: A
|
| 195 |
WAVE_ASC_FLGB |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 4
A=Ascending Order
D=Descending Order
Default Value: A
|
| 196 |
WAVE_ASC_FLGC |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 5
A=Ascending Order
D=Descending Order
Default Value: A
|
| 197 |
WAVE_ASC_FLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 2
A=Ascending Order
D=Descending Order
Default Value: A
|
| 198 |
WAVE_ASC_FLG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 3
A=Ascending Order
D=Descending Order
Default Value: A
|
| 199 |
WAVE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Wave Page Break Option
Y/N Table Edit
Default Value: N
|
| 200 |
WAVE_BREAKB |
Character(1) |
VARCHAR2(1) NOT NULL |
Wave Page Break Option 4
Y/N Table Edit
Default Value: N
|
| 201 |
WAVE_BREAKC |
Character(1) |
VARCHAR2(1) NOT NULL |
Wave Page Break Option 5
Y/N Table Edit
Default Value: N
|
| 202 |
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
|
| 203 |
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
|
| 204 |
WAVE_SORTB |
Character(3) |
VARCHAR2(3) NOT NULL |
Used as the 2nd level sort parameter on the Location Summary option of the Picking Plan.
20=ASRS ID
21=Zone
22=Storage Location
23=Area
24=Item
25=Staged Date
26=Lot
27=Container
28=Unit of Measure
29=Serial ID
|
| 205 |
WAVE_SORTC |
Character(3) |
VARCHAR2(3) NOT NULL |
Used as the 2nd level sort parameter on the Location Summary option of the Picking Plan.
20=ASRS ID
21=Zone
22=Storage Location
23=Area
24=Item
25=Staged Date
26=Lot
27=Container
28=Unit of Measure
29=Serial ID
|
| 206 |
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
|
| 207 |
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
|
| 208 |
CRT_LBL_FILE_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 209 |
CRT_LBL_FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 210 |
CRT_LBL_OVER_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit
Default Value: N
|
| 211 |
LABEL_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit of Measure
1=Order
2=Standard
3=Standard Pack
|
| 212 |
RELEASE_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
08/2004 rcw: Order Release Instance
Prompt Table:
%EDITTABLE22
|
| 213 |
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
|
| 214 |
INV_CART_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Par Location ID
Prompt Table:
IN_CART_PRMT_VW
Set Control Field: SL_BUSINESS_UNIT
|
| 215 |
LABEL_FORMAT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Format ID
Prompt Table:
%EDITTABLE20
|
| 216 |
NUMBER_OF_LABELS |
Number(3,0) |
SMALLINT NOT NULL |
Nbr of Labels
Default Value: 1
|
| 217 |
PICKING_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Picking Plan
01=Fixed Pick Location
03=Default Putaway Location
05=Default Shipment Location
08=Container Option
09=Pick by Date
10=All Available Locations
|
| 218 |
PICKING_DT_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Date Option
01=Earliest Expiration Dt (FEFO)
02=Earliest Available Lot (FIFO)
03=Earliest Staged Date (FIFO)
04=Latest Staged Date (LIFO)
|
| 219 |
PICKING_TIEBREAKER |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Location Tiebreaker
01=Fewest Locations
02=Pick To Clear
|
| 220 |
PICKING_NOTES |
Character(3) |
VARCHAR2(3) NOT NULL |
Picking Notes
00=None
01=Largest Batch First
02=Smallest Batch First
03=Broken Pallet First
|
| 221 |
IN_SHRTG_RLS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag indicating whether a demand line should be released (e.g. placed on a pick plan) as a shortage.
0=Release Shortage
1=Use Partial Quantity Logic
2=Do Not Release Shortage
|
| 222 |
CONTAINER_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Picking from Containers
Y/N Table Edit
|
| 223 |
OUTDESTTYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Process Request output destination type.
0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node
Default Value: 6
|
| 224 |
OUTDESTFORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Process Request output format
0=Any
1=(None)
10=Postscript (*.lis)
11=Crystal Report (*.rpt)
12=Rich Text File (*.rtf)
13=SQR Portable Format (*.spf)
14=Text Files (*.txt)
15=Other
16=Default
17=XML Format(*.xml)
18=Data Mover Data File (*.dat)
19=Crystal Report Explorer(*.rpt)
2=Acrobat (*.pdf)
20=XMLP
21=Atom
22=Transformation
23=Printer Command Lang. (*.pcl)
24=PostScript (*.ps)
3=Comma delimited (*.csv)
4=HP Format (*.lis)
5=HTML Documents (*.htm)
6=Line Printer Format (*.lis)
7=Lotus 1-2-3 Files (*.wks)
8=Microsoft Excel Files (*.xls)
9=Microsoft Word (*.doc)
Default Value: 2
|
| 225 |
OUTDEST |
Character(127) |
VARCHAR2(127) NOT NULL |
Process Scheduler Output Destination
|
| 226 |
PICK_PLAN_BY_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Unit of Measure
Y/N Table Edit
Default Value: N
|
| 227 |
IN_PRINT_PICK_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Pick Quantity option
0=Print Pick Quantity Only
1=Print All Quantity Fields
|
| 228 |
IN_PICK_QTY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Quantity Option
0=Use Available Balance
1=Use Planned Pick Quantity
|
| 229 |
FPB_WORKFLOW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Fixed Pick Workflow
Y/N Table Edit
Default Value: N
|
| 230 |
FPB_ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Fixed Picking Bin Role Name
Prompt Table:
ROLE_USRLST_VW
|
| 231 |
FPB_RTE_CNTL_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Route Control Type
Prompt Table:
RTE_CNTL_TYPE
|
| 232 |
FPB_RTE_FROM_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
From Value
Prompt Table:
%EDITTABLE
|
| 233 |
FPB_RTE_TO_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
To Value
Prompt Table:
%EDITTABLE
|
| 234 |
SETDEFAULT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to set default values ot user options.
Y/N Table Edit
Default Value: Y
|
| 235 |
IN_ALLOW_SPLIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Split
Y/N Table Edit
Default Value: N
|
| 236 |
IN_ALLOC_RESERV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Only Reserved
Y/N Table Edit
Default Value: N
|
| 237 |
IN_KEEP_RESERV |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Reservations
Y/N Table Edit
Default Value: N
|
| 238 |
IN_KEEP_LOT_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Lot Allocations
Y/N Table Edit
Default Value: Y
|
| 239 |
IN_PRINT_KIT_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Kit Header
Y/N Table Edit
Default Value: N
|
| 240 |
IN_KEEP_PRE_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Pre Allocations
Y/N Table Edit
Default Value: Y
|
| 241 |
IN_KEEP_ALLOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep All Allocations
Y/N Table Edit
Default Value: N
|
| 242 |
IN_RMV_SHP_SER |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove Ship Serials
Y/N Table Edit
Default Value: N
|
| 243 |
IN_RMV_SHP_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove from Ship ID
Y/N Table Edit
Default Value: Y
|
| 244 |
IN_EXCLUDE_RTV |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude RTVs
Y/N Table Edit
Default Value: N
|
| 245 |
PRINT_SUB_ITM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print option used to print item substitute.
0=Print All The Time
1=Print At Zero
2=Print At Partial
Default Value: 1
|
| 246 |
AUTO_DIRINV_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Direct Invoicing
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
Default Value: 0
|
| 247 |
AUTO_PUTWY_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Autoputaway
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
Default Value: 0
|
| 248 |
AUTO_RELEASE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Auto Release 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: 10
|
| 249 |
RLS_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table:
RLS_RUN_CNTL_VW
|
| 250 |
OPRID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 251 |
WO_PRINT_INSTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Delivery Instructions
Y/N Table Edit
Default Value: Y
|
| 252 |
DELETE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deletion Flag
Default Value: N
|
| 253 |
REPORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recreate Unshipped Report
Y/N Table Edit
Default Value: N
|
| 254 |
PURGE_RESULTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge FlexFormula Results
Y/N Table Edit
Default Value: N
|
| 255 |
BOL_BUILD_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Build Bills of Lading
01=No Bill of Lading
02=Build Bill of Lading
03=Build and Print Bill of Lading
Default Value: 01
|
| 256 |
FOREIGN_DOMESTIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill of Lading Type
B=Foreign and Domestic
D=Domestic
F=Foreign
Default Value: D
|
| 257 |
BOL_EXP_ORD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Order Option
1=Single Order on Bill of Lading
2=Multiple Orders on BOL
Default Value: 1
|
| 258 |
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
|
| 259 |
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
|
| 260 |
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
|
| 261 |
IN_BOL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Of Lading Option
0=Do nothing
1=Create BOL
2=Both
Default Value: 0
|
| 262 |
IN_SHIP_ID_AUTOGEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Assign Ship IDs
Y/N Table Edit
Default Value: N
|
| 263 |
IN_PACK_LIST_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Packing List
Y/N Table Edit
Default Value: N
|
| 264 |
PRINT_NOTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Sales Order Notes
Y/N Table Edit
Default Value: N
|
| 265 |
IN_DFR_DPL_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
used to override the defer depletions field on in_demand
1=Override to Yes
2=Override to No
|
| 266 |
IN_FRT_P_BILFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit Billable Freight
Y/N Table Edit
Default Value: N
|
| 267 |
IN_FRT_P_CMPFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Complete
Y/N Table Edit
Default Value: N
|
| 268 |
IN_FRT_P_MANFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
External Manifest
Y/N Table Edit
Default Value: Y
|
| 269 |
IN_FRT_LOAD_RESULT |
Character(1) |
VARCHAR2(1) NOT NULL |
07/24/07 - mmt - Added field to be used to identify at the BU level whether the user is using internal, external, or no freight calculation
Y/N Table Edit
Default Value: N
|
| 270 |
IN_BEST_WAY_BTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Best Way Freight Option
10=Least Cost
20=By Commit Date
|
| 271 |
IN_FRT_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Options
10=Shop For Rates
20=Best Way
30=Use Specified Carrier
40=Carrier with Best Way
|
| 272 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
Prompt Table:
IN_DELIV_PR_VW
|
| 273 |
LAST_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Prompt Table:
IN_DMD_LST_IDVW
|
| 274 |
RUN_FREIGHT |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Freight
Y/N Table Edit
Default Value: Y
|
| 275 |
DEL_VALIDATE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Delivery validation option
10=Validate Only
20=Validate/Assign to New
30=Validate/Auto Assign Open
40=Validate/Auto Assign All
50=Reassign/Consolidate
60=Do Not Validate
Default Value: 60
|
| 276 |
DEPL_DELIV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/16/08 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 277 |
AMOUNT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
10/29/08 EGS: Created
1=Override
2=Increment
Default Value: 1
|
| 278 |
FRT_TYPE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Type Code
Prompt Table:
IN_FRT_DFLT
Set Control Field: SL_BUSINESS_UNIT
|
| 279 |
RESEND_FRT_RQST |
Character(1) |
VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
Y/N Table Edit
Default Value: N
|
| 280 |
RESEND_FRT_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
Y/N Table Edit
Default Value: N
|
| 281 |
MAX_RETRIES |
Number(3,0) |
SMALLINT NOT NULL |
EGS 03/24/09: Created
|
| 282 |
FRT_ROLLUP_IND_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates to batch run how the freight will be rolled up.
1=Delivery Freight
2=Rollup Packages/Containers
3=Default from Delivery
Default Value: 3
|