| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
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
|
| 5 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 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_INST_STG |
Number(10,0) |
DECIMAL(10) NOT NULL |
Stage Record Process Instance
|
| 10 |
JOBNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Process Scheduler Job Name
|
| 11 |
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
|
| 12 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 13 |
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
Default Value: 30
|
| 14 |
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.
|
| 15 |
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
Default Value: 30
|
| 16 |
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.
|
| 17 |
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
Default Value: 30
|
| 18 |
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
|
| 19 |
SELECT_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Released state.
|
| 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_ALL_RELEASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Select All Released
|
| 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.
|
| 24 |
SELECT_DEPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the RFID Tag Generation should include data in a Depleted state.
|
| 25 |
TRANSACTION_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table:
BCT_XFUL_INV_VW
|
| 26 |
LAST_TRANS_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
|
| 27 |
INITIAL_TRANS_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
|
| 28 |
FINAL_TRANS_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
|
| 29 |
AUTO_SCHED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto-Scheduled Job
Y/N Table Edit
Default Value: N
|
| 30 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 31 |
PROCESS_MODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Run Mode
JB=Job Mode
ON=Online Mode
PR=Process Mode
TR=Transaction Mode
Default Value: TR
|
| 32 |
EIP_CTL_ID_FROM |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
Prompt Table:
%EDITTABLE
|
| 33 |
EIP_CTL_ID_TO |
Character(25) |
VARCHAR2(25) NOT NULL |
EIP control ID selection
Prompt Table:
%EDITTABLE
|
| 34 |
LAST_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business unit tagged
|
| 35 |
LAST_INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 36 |
PROCESS_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-process any Errors in Range
Y/N Table Edit
Default Value: N
|
| 37 |
EIP_TRANS_SRC_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Source Reference
|
| 38 |
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 :-)
|
| 39 |
PUBID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Publication Identifier
|
| 40 |
DELETE_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
DELETE_CONTROL
Y/N Table Edit
Default Value: N
|
| 41 |
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: Y
|
| 42 |
SL_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table:
SP_BUIN_NONVW
|
| 43 |
TO_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table:
SP_BUIN_NONVW
|
| 44 |
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
|
| 45 |
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
|
| 46 |
SL_SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Business Unit selection
|
| 47 |
SL_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
|
| 48 |
TO_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
|
| 49 |
SL_ORDER_INT_LINE |
Number(5,0) |
INTEGER NOT NULL |
Order Line selection
|
| 50 |
TO_ORDER_INT_LINE |
Number(5,0) |
INTEGER NOT NULL |
Order Line selection
|
| 51 |
SL_SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
05/07/04 PWF Added field for new 8.9 data model changes
|
| 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_INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item selection
Prompt Table:
MST_ITM_PRPT_VW
|
| 54 |
SL_DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line Number selection
|
| 55 |
SL_SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer selection
|
| 56 |
SL_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID selection
Prompt Table:
DMND_CUST_ID_VW
|
| 57 |
SL_ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number selection
|
| 58 |
SL_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location selection
|
| 59 |
SL_LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load selection
Prompt Table:
SHIP_PRMPT13_VW
|
| 60 |
SL_SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via selection
|
| 61 |
TO_SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via selection
|
| 62 |
SL_CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier selection
|
| 63 |
TO_CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier selection
|
| 64 |
SL_ROUTE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Route selection
|
| 65 |
SL_WAVE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Route Group selection
|
| 66 |
TO_WAVE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Route Group selection
|
| 67 |
SL_PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product selection
|
| 68 |
SL_DEMAND_DATE |
Date(10) |
DATE |
Demand Date selection
|
| 69 |
TO_DEMAND_DATE |
Date(10) |
DATE |
Demand Date selection
|
| 70 |
SL_SCHED_SHIP_DATE |
Date(10) |
DATE |
Scheduled Ship Date selection
|
| 71 |
SL_SCHED_SHIP_TIME |
Time(15) |
TIMESTAMP |
Scheduled Ship Time
|
| 72 |
TO_SCHED_SHIP_DATE |
Date(10) |
DATE |
Scheduled Ship Date selection
|
| 73 |
TO_SCHED_SHIP_TIME |
Time(15) |
TIMESTAMP |
Scheduled Ship Time selection
|
| 74 |
SL_SHIP_EARLY_DATE |
Date(10) |
DATE |
Ship Early Date selection
|
| 75 |
SL_SHIP_EARLY_TIME |
Time(15) |
TIMESTAMP |
Ship Early Time selection
|
| 76 |
TO_SHIP_EARLY_DATE |
Date(10) |
DATE |
Ship Early Date selection
|
| 77 |
TO_SHIP_EARLY_TIME |
Time(15) |
TIMESTAMP |
Ship Early Time selection
|
| 78 |
SL_SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship ID Selection
|
| 79 |
TO_SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship ID Selection
|
| 80 |
SL_CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer Purchase Order selection
|
| 81 |
SL_CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract ID selection
|
| 82 |
SL_PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID selection
|
| 83 |
TO_PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID selection
|
| 84 |
SL_PICKLIST_LINE |
Number(7,0) |
INTEGER NOT NULL |
Pick List Line Number selection
|
| 85 |
TO_PICKLIST_LINE |
Number(7,0) |
INTEGER NOT NULL |
Pick List Line Number selection
|
| 86 |
SL_SHIP_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Ship Container selection
|
| 87 |
SL_TMS_EXT_REF_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Transportation Management System (TMS) Reference ID selection
|
| 88 |
SL_TMS_EXT_REF_LN |
Number(7,0) |
INTEGER NOT NULL |
Transportation Management System (TMS) Reference Line
|
| 89 |
SL_EXT_REF_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
External Reference Number selection
|
| 90 |
SL_EXT_REF_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
External Reference Line selection
|
| 91 |
SL_DELIVERY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
From Delivery ID
|
| 92 |
TO_DELIVERY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
To Delivery ID
|
| 93 |
AUTO_PICK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Pick
Y/N Table Edit
|
| 94 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table:
SHIP_HDR_INV_VW
|
| 95 |
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
|
| 96 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
SHIP_PRMPT9_VW
|
| 97 |
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
|
| 98 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 99 |
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
|
| 100 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 101 |
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
|
| 102 |
SHIP_TIME |
Time(15) |
TIMESTAMP |
Ship Time
|
| 103 |
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
|
| 104 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 105 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 106 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 107 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 108 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 109 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
Prompt Table:
SHIP_PRMPT11_VW
|
| 110 |
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
|
| 111 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 112 |
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
|
| 113 |
TRACKING_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tracking Number
|
| 114 |
TRACKING_NBR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Tracking Number
Y/N Table Edit
Default Value: N
|
| 115 |
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
|
| 116 |
FREIGHT_CALC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Calculate Flag
Y/N Table Edit
Default Value: N
|
| 117 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 118 |
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
|
| 119 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 120 |
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
|
| 121 |
SHIP_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Shipping Container ID
|
| 122 |
LEAD_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Lead Days for Calendar
|
| 123 |
ALLOC_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Reservation Lead Days
|
| 124 |
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
|
| 125 |
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
|
| 126 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUIN_NONVW
|
| 127 |
COMMIT_GROUP |
Number(10,0) |
DECIMAL(10) NOT NULL |
A group of data to be committed to the database as one unit of work that may be smaller than the processing group. Commit Group will always be contained within a Processing Group. When processing, if Pass-through Level is greater than the specified Commit Level, the Commit Group will be expanded to include all data at the Pass-through Level.
|
| 128 |
PROCESSING_GROUP |
Number(10,0) |
DECIMAL(10) NOT NULL |
A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
|
| 129 |
LAST_KIT_PROC_GRP |
Number(10,0) |
DECIMAL(10) NOT NULL |
A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
|
| 130 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 131 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 132 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 133 |
SYNCH_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronization Flag used to indicate the level of synchronization during a physical inventory snapshot.
0=No Synchronization Required
1=Synchronize a Business Unit
2=Synchronize an Item
3=Synchronize a Storage Location
4=Synchronize a Lot ID
5=Synchronize Item at a Stor Loc
|
| 134 |
PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing
|
| 135 |
MG |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturing
|
| 136 |
WO |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintenance Management
|
| 137 |
COUNT_LINES |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count of Lines
|
| 138 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 139 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 140 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 141 |
USE_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use of Priority
N=No
Y=Yes
|
| 142 |
TODAY_DATE |
Date(10) |
DATE |
Represents the creation date for a given time set utilized in position processing.
|
| 143 |
TSE_JOBID |
Character(10) |
VARCHAR2(10) NOT NULL |
TSE Job Identifier
|
| 144 |
DFLT_INV_LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Default Lot ID
|
| 145 |
DFLT_SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Default Serial ID
|
| 146 |
DFLT_STAGED_DATE |
Date(10) |
DATE |
Default Staged Date
|
| 147 |
TRANS_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Program
|
| 148 |
AUTO_BCK_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Backorder Approval
|
| 149 |
SOFT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Soft Reserve
|
| 150 |
ONLINE_RES_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Online Reservation Flag
|
| 151 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
|
| 152 |
USE_CLOSE_CAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Closure Calendar
|
| 153 |
DTTM_FROM |
DateTime(26) |
TIMESTAMP |
From Date/Time
|
| 154 |
DTTM_TO |
DateTime(26) |
TIMESTAMP |
To Date/Time
|
| 155 |
LAST_PRCS_GROUP |
Number(10,0) |
DECIMAL(10) NOT NULL |
A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
|
| 156 |
LAST_COMMIT_GROUP |
Number(10,0) |
DECIMAL(10) NOT NULL |
A group of data to be committed to the database as one unit of work that may be smaller than the processing group. Commit Group will always be contained within a Processing Group. When processing, if Pass-through Level is greater than the specified Commit Level, the Commit Group will be expanded to include all data at the Pass-through Level.
|
| 157 |
DOWNTIME_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prohibit Material Movements
|
| 158 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 159 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 160 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 161 |
MESSAGE_PARM2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 2
|
| 162 |
MESSAGE_PARM3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 3
|
| 163 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 164 |
GRP_SEQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence used to uniquely identify a row in the Fulfillment Group stage table.
|
| 165 |
DTL_SEQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence used to uniquely identify a row in the Fulfillment Details stage table.
|
| 166 |
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
|
| 167 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 168 |
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
|
| 169 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 170 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 171 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 172 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 173 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
|
| 174 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
|
| 175 |
FERC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
FERC Code
|
| 176 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|
| 177 |
COUNT_HDR_FL |
Number(6,0) |
INTEGER NOT NULL |
Headcount
|
| 178 |
COUNT_GRP_FL |
Number(6,0) |
INTEGER NOT NULL |
Headcount
|
| 179 |
COUNT_DTL_FL |
Number(6,0) |
INTEGER NOT NULL |
Headcount
|
| 180 |
COUNT_LLS_FL |
Number(6,0) |
INTEGER NOT NULL |
Headcount
|
| 181 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 182 |
COUNT_2 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 183 |
COUNT_3 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 184 |
ACTIONNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Action Name
|
| 185 |
ROWCOUNTER1 |
Number(5,0) |
INTEGER NOT NULL |
Row(s) Selected
|
| 186 |
FUL_LN_COUNT |
Number(14,0) |
DECIMAL(14) NOT NULL |
Row(s) Selected
|
| 187 |
SORTCODE |
Character(254) |
VARCHAR2(254) NOT NULL |
BOM Sort Code
|
| 188 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 189 |
DELETE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deletion Flag
|
| 190 |
WHERE_UOM |
Character(50) |
VARCHAR2(50) NOT NULL |
SQL Where field
|
| 191 |
PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 192 |
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
|
| 193 |
IN_PICKPLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Picking Plan
Y/N Table Edit
Default Value: Y
|
| 194 |
SEL_ORD_REL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created for outbound messaging.
Y/N Table Edit
Default Value: N
|
| 195 |
EXPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 196 |
CARTON_LABELS |
Character(1) |
VARCHAR2(1) NOT NULL |
Carton Labels
Y/N Table Edit
Default Value: N
|
| 197 |
PICK_ALL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick All Demand Option
Y/N Table Edit
Default Value: Y
|
| 198 |
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
|
| 199 |
IN_SINGLE_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Location Only
Y/N Table Edit
Default Value: N
|
| 200 |
IN_ORDREL_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Release Selection
1=All
2=Specific
3=Advanced Selection Criteria
Default Value: 1
|
| 201 |
IN_MRK_CONFIRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Pick
Y/N Table Edit
Default Value: N
|
| 202 |
REPRINT_PICK_BATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprint Pick Batch
Y/N Table Edit
Default Value: N
|
| 203 |
PUBLISH |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish Data
Y/N Table Edit
Default Value: N
|
| 204 |
BACKORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
Y/N Table Edit
Default Value: N
|
| 205 |
BU_BAL_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Level Balances
Y/N Table Edit
Default Value: N
|
| 206 |
PRINT_BARCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Code on Report Flag
Y/N Table Edit
Default Value: N
|
| 207 |
PRINT_BARCD_CTLFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Coded Control Flags
Y/N Table Edit
Default Value: N
|
| 208 |
PICK_RELEASE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Release ID
|
| 209 |
PICK_NOLOAD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TMS Lines Awaiting Upload
Y/N Table Edit
Default Value: N
|
| 210 |
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
|
| 211 |
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
|
| 212 |
PICKING_DT_FROM |
Date(10) |
DATE |
Picking Selection From Date
|
| 213 |
PICK_TIME_FROM |
Time(15) |
TIMESTAMP |
Picking From Time
|
| 214 |
PICKING_DT_TO |
Date(10) |
DATE |
Picking Selection To Date
|
| 215 |
PICK_TIME_TO |
Time(15) |
TIMESTAMP |
Picking To Time
|
| 216 |
PICKING_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Picking Lead Days
|
| 217 |
PICKING_LEAD_TIME |
Number(3,0) |
SMALLINT NOT NULL |
Picking Lead Minutes
|
| 218 |
PICK_TIME_UNTIL |
Time(15) |
TIMESTAMP |
Picking Until Time
|
| 219 |
REGEN_ORD_TRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Regenerate Order Transactions
Y/N Table Edit
Default Value: N
|
| 220 |
ORDER_REL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Orders
Y/N Table Edit
Default Value: N
|
| 221 |
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
|
| 222 |
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
|
| 223 |
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
|
| 224 |
PICK_PLAN_COMMIT |
Number(6,0) |
INTEGER NOT NULL |
Pick Plan Commit Batch
Default Value: 1000
|
| 225 |
ASC_DESC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending
A=Ascending
D=Descending
Default Value: A
|
| 226 |
ASC_DESC_FLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 2
A=Ascending
D=Descending
Default Value: A
|
| 227 |
ASC_DESC_FLG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 3
A=Ascending
D=Descending
Default Value: A
|
| 228 |
PAGE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option
Y/N Table Edit
Default Value: N
|
| 229 |
PAGE_BREAK2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option 2
Y/N Table Edit
Default Value: N
|
| 230 |
PAGE_BREAK3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option 3
Y/N Table Edit
Default Value: N
|
| 231 |
PICK_BATCH_BRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Batch Break
Y/N Table Edit
Default Value: N
|
| 232 |
PICK_BATCH_BRK2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Batch Break 3
Y/N Table Edit
Default Value: N
|
| 233 |
PICK_BATCH_BRK3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Batch Break 2
Y/N Table Edit
Default Value: N
|
| 234 |
PRINT_ITEM_SUBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Substitutes
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 235 |
MAX_PULL_LINES |
Number(2,0) |
SMALLINT NOT NULL |
Max Suggest/Sub Locations
Default Value: 6
|
| 236 |
USG_LABEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Usage Labels
Y/N Table Edit
Default Value: N
|
| 237 |
USG_LBL_FILE_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 238 |
USG_LBL_FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 239 |
USG_LBL_OVER_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit
Default Value: N
|
| 240 |
EXTRACT_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Extract File
Y/N Table Edit
Default Value: N
|
| 241 |
EXTRACT_FILE_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 242 |
EXTRACT_FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 243 |
EXTRACT_OVER_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit
Default Value: N
|
| 244 |
WAVE_ASC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending
A=Ascending Order
D=Descending Order
Default Value: A
|
| 245 |
WAVE_ASC_FLGB |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 4
A=Ascending Order
D=Descending Order
Default Value: A
|
| 246 |
WAVE_ASC_FLGC |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 5
A=Ascending Order
D=Descending Order
Default Value: A
|
| 247 |
WAVE_ASC_FLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 2
A=Ascending Order
D=Descending Order
Default Value: A
|
| 248 |
WAVE_ASC_FLG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 3
A=Ascending Order
D=Descending Order
Default Value: A
|
| 249 |
WAVE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Wave Page Break Option
Y/N Table Edit
Default Value: N
|
| 250 |
WAVE_BREAKB |
Character(1) |
VARCHAR2(1) NOT NULL |
Wave Page Break Option 4
Y/N Table Edit
Default Value: N
|
| 251 |
WAVE_BREAKC |
Character(1) |
VARCHAR2(1) NOT NULL |
Wave Page Break Option 5
Y/N Table Edit
Default Value: N
|
| 252 |
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
|
| 253 |
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
|
| 254 |
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
|
| 255 |
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
|
| 256 |
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
|
| 257 |
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
|
| 258 |
CRT_LBL_FILE_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 259 |
CRT_LBL_FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 260 |
CRT_LBL_OVER_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit
Default Value: N
|
| 261 |
LABEL_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit of Measure
1=Order
2=Standard
3=Standard Pack
|
| 262 |
RELEASE_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
08/2004 rcw: Order Release Instance
Prompt Table:
%EDITTABLE22
|
| 263 |
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
|
| 264 |
INV_CART_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Par Location ID
Prompt Table:
IN_CART_PRMT_VW
Set Control Field: SL_BUSINESS_UNIT
|
| 265 |
LABEL_FORMAT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Format ID
Prompt Table:
%EDITTABLE20
|
| 266 |
NUMBER_OF_LABELS |
Number(3,0) |
SMALLINT NOT NULL |
Nbr of Labels
Default Value: 1
|
| 267 |
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
|
| 268 |
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)
|
| 269 |
PICKING_TIEBREAKER |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Location Tiebreaker
01=Fewest Locations
02=Pick To Clear
|
| 270 |
PICKING_NOTES |
Character(3) |
VARCHAR2(3) NOT NULL |
Picking Notes
00=None
01=Largest Batch First
02=Smallest Batch First
03=Broken Pallet First
|
| 271 |
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
|
| 272 |
CONTAINER_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Picking from Containers
Y/N Table Edit
|
| 273 |
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
|
| 274 |
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
|
| 275 |
OUTDEST |
Character(127) |
VARCHAR2(127) NOT NULL |
Process Scheduler Output Destination
|
| 276 |
PICK_PLAN_BY_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Unit of Measure
Y/N Table Edit
Default Value: N
|
| 277 |
IN_PRINT_PICK_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Pick Quantity option
0=Print Pick Quantity Only
1=Print All Quantity Fields
|
| 278 |
IN_PICK_QTY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Quantity Option
0=Use Available Balance
1=Use Planned Pick Quantity
|
| 279 |
FPB_WORKFLOW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Fixed Pick Workflow
Y/N Table Edit
Default Value: N
|
| 280 |
FPB_ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Fixed Picking Bin Role Name
Prompt Table:
ROLE_USRLST_VW
|
| 281 |
FPB_RTE_CNTL_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Route Control Type
Prompt Table:
RTE_CNTL_TYPE
|
| 282 |
FPB_RTE_FROM_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
From Value
Prompt Table:
%EDITTABLE
|
| 283 |
FPB_RTE_TO_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
To Value
Prompt Table:
%EDITTABLE
|
| 284 |
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
|
| 285 |
IN_ALLOW_SPLIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Split
Y/N Table Edit
Default Value: N
|
| 286 |
IN_ALLOC_RESERV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Only Reserved
Y/N Table Edit
Default Value: N
|
| 287 |
IN_KEEP_RESERV |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Reservations
Y/N Table Edit
Default Value: N
|
| 288 |
IN_KEEP_LOT_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Lot Allocations
Y/N Table Edit
Default Value: Y
|
| 289 |
IN_PRINT_KIT_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Kit Header
Y/N Table Edit
Default Value: N
|
| 290 |
IN_KEEP_PRE_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Pre Allocations
Y/N Table Edit
Default Value: Y
|
| 291 |
IN_KEEP_ALLOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep All Allocations
Y/N Table Edit
Default Value: N
|
| 292 |
IN_RMV_SHP_SER |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove Ship Serials
Y/N Table Edit
Default Value: N
|
| 293 |
IN_RMV_SHP_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove from Ship ID
Y/N Table Edit
Default Value: Y
|
| 294 |
IN_EXCLUDE_RTV |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude RTVs
Y/N Table Edit
Default Value: N
|
| 295 |
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
|
| 296 |
LAST_ROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Row
|
| 297 |
IN_FL_TEMP_TBL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Temp Table Indicator
|
| 298 |
MAX_GRP_ID_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Maximum Group ID
|
| 299 |
MAX_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Maximum Sequence Number
|
| 300 |
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: 2
|
| 301 |
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
|
| 302 |
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
|
| 303 |
RLS_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 304 |
OPRID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 305 |
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
|
| 306 |
SKIP_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip Loading Feedback Trans
|
| 307 |
SHP_VALIDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Shipping Validation
S=Shp From Rlsd (not valdt mode)
Y=Ship Validate Mode
|
| 308 |
SHP_OVERRIDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Shipping Overrides
|
| 309 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 310 |
INIT_AUTO_REL_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
|
| 311 |
INIT_FULFILL_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
30=Picking
31=Material Picking Feedback
40=Picking Confirmation
50=Front-end Shipping Requests
51=Express Issue
60=Shipping Requests
61=Shipping/Issues
70=Deplete On Hand Quantity
95=Fulfillment Workbench
99=Transactions
|
| 312 |
REPORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recreate Unshipped Report
|
| 313 |
PURGE_RESULTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge FlexFormula Results
|
| 314 |
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
|
| 315 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
|
| 316 |
IN_FRT_P_BILFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit Billable Freight
|
| 317 |
IN_FRT_P_CMPFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Complete
|
| 318 |
IN_FRT_P_MANFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
External Manifest
|
| 319 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 320 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 321 |
RUN_FREIGHT |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Freight
|
| 322 |
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
|
| 323 |
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
|
| 324 |
IN_BEST_WAY_BTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Best Way Freight Option
10=Least Cost
20=By Commit Date
|
| 325 |
DEPL_DELIV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/16/08 EGS: Created
|
| 326 |
DELIVERY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
10/20/08 EGS: Created
1=Yes
2=Manual
3=No
|
| 327 |
AMOUNT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
10/29/08 EGS: Created
1=Override
2=Increment
|
| 328 |
FRT_TYPE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Type Code
|
| 329 |
ROWCOUNT1 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row Count
|
| 330 |
RESEND_FRT_RQST |
Character(1) |
VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
|
| 331 |
RESEND_FRT_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
|
| 332 |
MAX_RETRIES |
Number(3,0) |
SMALLINT NOT NULL |
EGS 03/24/09: Created
|
| 333 |
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
|