DMD_FUL_RC_VW(SQL View) |
Index Back |
|---|---|
Fulfillment Run ControlRun control for fulfillment requests. |
| SELECT PROCESS_INSTANCE , OPRID , RUN_CNTL_ID , FULFILLMENT_LOC , REQUEST_ID , LANGUAGE_CD , SL_BUSINESS_UNIT , SL_DEMAND_SOURCE , SL_SOURCE_BUS_UNIT , TO_SOURCE_BUS_UNIT , SL_ORDER_NO , TO_ORDER_NO , SL_ORDER_INT_LINE , TO_ORDER_INT_LINE , SL_SCHED_LINE_NBR , TO_SCHED_LINE_NBR , SL_INV_ITEM_ID , SL_DEMAND_LINE_NO , SL_SHIP_TO_CUST_ID , SL_CUST_ID , SL_ADDRESS_SEQ_NUM , SL_LOCATION , SL_LOAD_ID , SL_SHIP_TYPE_ID , TO_SHIP_TYPE_ID , SL_CARRIER_ID , TO_CARRIER_ID , SL_ROUTE_CD , SL_WAVE_CD , TO_WAVE_CD , SL_PRODUCT_ID , SL_DEMAND_DATE , TO_DEMAND_DATE , SL_SCHED_SHIP_DATE , TO_SCHED_SHIP_DATE , SL_SCHED_SHIP_TIME , TO_SCHED_SHIP_TIME , SL_SHIP_EARLY_DATE , TO_SHIP_EARLY_DATE , SL_SHIP_EARLY_TIME , TO_SHIP_EARLY_TIME , SL_CUSTOMER_PO , SL_CNTRCT_ID , SL_PICK_BATCH_ID , TO_PICK_BATCH_ID , SL_PICKLIST_LINE , TO_PICKLIST_LINE , SL_SHIP_CNTR_ID , SL_TMS_EXT_REF_ID , SL_TMS_EXT_REF_LN , SL_EXT_REF_NBR , SL_EXT_REF_LN_NBR , SL_SHIP_ID , TO_SHIP_ID , SL_PRIORITY_NBR , TO_PRIORITY_NBR , SL_PARENT_PROD_ID , TO_PARENT_PROD_ID , SL_SHOP_ID , TO_SHOP_ID , SL_DELIVERY_ID , TO_DELIVERY_ID , DELIVERY_ID , AUTO_PICK_FLAG , SHIP_ID , SHIP_ID_FLG , CARRIER_ID , CARRIER_ID_FLG , SHIP_TYPE_ID , SHIP_TYPE_ID_FLG , SHIP_DATE , SHIP_DATE_FLG , SHIP_TIME , SHIP_TIME_FLG , BILL_OF_LADING , BILL_OF_LADING_FLG , PRO_NUMBER , PRO_NUMBER_FLG , FREIGHT_TERMS , FREIGHT_TERMS_FLG , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , LEAD_DAYS , USE_LEAD_DAYS , ORDER_REQUEST , %subrec(IN_ORD_REL_SBR, A) , SELECT_UNFULFILLED , SELECT_RELEASABLE , SELECT_RELEASED , SELECT_CONFIRMED , AUTO_RELEASE_OPT , TRANSACTION_CODE , IN_DFR_DPL_OVRD , LAST_PROCESS_INST FROM PS_RUN_CNTL_IN_FUL A |
| # | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | SL_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table: SP_BUIN_NONVW |
| 8 | 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 |
| 9 | SL_SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Business Unit selection |
| 10 | TO_SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | 12/10/02 NRA (CN#PL880-1): Defined |
| 11 | SL_ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Order Number selection |
| 12 | TO_ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Order Number selection |
| 13 | SL_ORDER_INT_LINE | Number(5,0) | INTEGER NOT NULL | Order Line selection |
| 14 | TO_ORDER_INT_LINE | Number(5,0) | INTEGER NOT NULL | Order Line selection |
| 15 | SL_SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | 05/07/04 PWF Added field for new 8.9 data model changes |
| 16 | TO_SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | 05/07/04 PWF Added field for 8.9 data model changes |
| 17 | SL_INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item selection
Prompt Table: MST_ITM_PRPT_VW |
| 18 | SL_DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line Number selection |
| 19 | SL_SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer selection |
| 20 | SL_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer ID selection
Prompt Table: DMND_CUST_ID_VW |
| 21 | SL_ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number selection |
| 22 | SL_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location selection |
| 23 | SL_LOAD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Load selection
Prompt Table: SHIP_PRMPT13_VW |
| 24 | SL_SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via selection |
| 25 | TO_SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via selection |
| 26 | SL_CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier selection |
| 27 | TO_CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier selection |
| 28 | SL_ROUTE_CD | Character(6) | VARCHAR2(6) NOT NULL | Route selection |
| 29 | SL_WAVE_CD | Character(6) | VARCHAR2(6) NOT NULL | Route Group selection |
| 30 | TO_WAVE_CD | Character(6) | VARCHAR2(6) NOT NULL | Route Group selection |
| 31 | SL_PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product selection |
| 32 | SL_DEMAND_DATE | Date(10) | DATE | Demand Date selection |
| 33 | TO_DEMAND_DATE | Date(10) | DATE | Demand Date selection |
| 34 | SL_SCHED_SHIP_DATE | Date(10) | DATE | Scheduled Ship Date selection |
| 35 | TO_SCHED_SHIP_DATE | Date(10) | DATE | Scheduled Ship Date selection |
| 36 | SL_SCHED_SHIP_TIME | Time(15) | TIMESTAMP | Scheduled Ship Time |
| 37 | TO_SCHED_SHIP_TIME | Time(15) | TIMESTAMP | Scheduled Ship Time selection |
| 38 | SL_SHIP_EARLY_DATE | Date(10) | DATE | Ship Early Date selection |
| 39 | TO_SHIP_EARLY_DATE | Date(10) | DATE | Ship Early Date selection |
| 40 | SL_SHIP_EARLY_TIME | Time(15) | TIMESTAMP | Ship Early Time selection |
| 41 | TO_SHIP_EARLY_TIME | Time(15) | TIMESTAMP | Ship Early Time selection |
| 42 | SL_CUSTOMER_PO | Character(25) | VARCHAR2(25) NOT NULL | Customer Purchase Order selection |
| 43 | SL_CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Contract ID selection |
| 44 | SL_PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID selection |
| 45 | TO_PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID selection |
| 46 | SL_PICKLIST_LINE | Number(7,0) | INTEGER NOT NULL | Pick List Line Number selection |
| 47 | TO_PICKLIST_LINE | Number(7,0) | INTEGER NOT NULL | Pick List Line Number selection |
| 48 | SL_SHIP_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Ship Container selection |
| 49 | SL_TMS_EXT_REF_ID | Character(10) | VARCHAR2(10) NOT NULL | Transportation Management System (TMS) Reference ID selection |
| 50 | SL_TMS_EXT_REF_LN | Number(7,0) | INTEGER NOT NULL | Transportation Management System (TMS) Reference Line |
| 51 | SL_EXT_REF_NBR | Number(10,0) | DECIMAL(10) NOT NULL | External Reference Number selection |
| 52 | SL_EXT_REF_LN_NBR | Number(5,0) | INTEGER NOT NULL | External Reference Line selection |
| 53 | SL_SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship ID Selection |
| 54 | TO_SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship ID Selection |
| 55 | SL_PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
| 56 | TO_PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
| 57 | SL_PARENT_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Product Id |
| 58 | TO_PARENT_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Product Id |
| 59 | SL_SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop |
| 60 | TO_SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop ID |
| 61 | SL_DELIVERY_ID | Character(15) | VARCHAR2(15) NOT NULL | From Delivery ID |
| 62 | TO_DELIVERY_ID | Character(15) | VARCHAR2(15) NOT NULL | To Delivery ID |
| 63 | DELIVERY_ID | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 64 | AUTO_PICK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag Items for Auto-Pick |
| 65 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table: SHIP_HDR_INV_VW |
| 66 | 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 |
| 67 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: SHIP_PRMPT9_VW |
| 68 | 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 |
| 69 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 70 | 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 |
| 71 | SHIP_DATE | Date(10) | DATE | Item Shipping Date |
| 72 | 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 |
| 73 | SHIP_TIME | Time(15) | TIMESTAMP | Ship Time |
| 74 | 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 |
| 75 | 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 |
| 76 | 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 |
| 77 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 78 | 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 |
| 79 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
| 80 | 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 |
| 81 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 82 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 83 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 84 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 85 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 86 | LEAD_DAYS | Number(4,0) | SMALLINT NOT NULL | Lead Days for Calendar |
| 87 | 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 |
| 88 | 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 |
| 89 | 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 |
| 90 | IN_PICKPLAN | Character(1) | VARCHAR2(1) NOT NULL |
Picking Plan
Y/N Table Edit Default Value: Y |
| 91 | SEL_ORD_REL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
11/99 Created for outbound messaging.
Y/N Table Edit Default Value: N |
| 92 | EXPORT | Character(1) | VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No Y=Yes Y/N Table Edit Default Value: N |
| 93 | CARTON_LABELS | Character(1) | VARCHAR2(1) NOT NULL |
Carton Labels
Y/N Table Edit Default Value: N |
| 94 | PICK_ALL_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Pick All Demand Option
Y/N Table Edit Default Value: Y |
| 95 | 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 |
| 96 | IN_SINGLE_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Single Location Only
Y/N Table Edit Default Value: N |
| 97 | IN_ORDREL_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Order Release Selection
1=All 2=Specific 3=Advanced Selection Criteria Default Value: 1 |
| 98 | IN_MRK_CONFIRM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag Items for Auto-Pick
Y/N Table Edit Default Value: N |
| 99 | REPRINT_PICK_BATCH | Character(1) | VARCHAR2(1) NOT NULL |
Reprint Pick Batch
Y/N Table Edit Default Value: N |
| 100 | PUBLISH | Character(1) | VARCHAR2(1) NOT NULL |
Publish Data
Y/N Table Edit Default Value: N |
| 101 | BACKORDER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Backorder Flag
Y/N Table Edit Default Value: N |
| 102 | BU_BAL_RPT | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Level Balances
Y/N Table Edit Default Value: N |
| 103 | PRINT_BARCD | Character(1) | VARCHAR2(1) NOT NULL |
Print Bar Code on Report Flag
Y/N Table Edit Default Value: N |
| 104 | PRINT_BARCD_CTLFLG | Character(1) | VARCHAR2(1) NOT NULL |
Print Bar Coded Control Flags
Y/N Table Edit Default Value: N |
| 105 | PICK_RELEASE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Release ID |
| 106 | PICK_NOLOAD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
TMS Lines Awaiting Upload
Y/N Table Edit Default Value: N |
| 107 | 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 |
| 108 | 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 |
| 109 | PICKING_DT_FROM | Date(10) | DATE | Picking Selection From Date |
| 110 | PICK_TIME_FROM | Time(15) | TIMESTAMP | Picking From Time |
| 111 | PICKING_DT_TO | Date(10) | DATE | Picking Selection To Date |
| 112 | PICK_TIME_TO | Time(15) | TIMESTAMP | Picking To Time |
| 113 | PICKING_LEAD_DAYS | Number(3,0) | SMALLINT NOT NULL | Picking Lead Days |
| 114 | PICKING_LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Picking Lead Minutes |
| 115 | PICK_TIME_UNTIL | Time(15) | TIMESTAMP | Picking Until Time |
| 116 | REGEN_ORD_TRANS | Character(1) | VARCHAR2(1) NOT NULL |
Regenerate Order Transactions
Y/N Table Edit Default Value: N |
| 117 | ORDER_REL_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Select Orders
Y/N Table Edit Default Value: N |
| 118 | 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 |
| 119 | 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 |
| 120 | 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 |
| 121 | PICK_PLAN_COMMIT | Number(6,0) | INTEGER NOT NULL |
Pick Plan Commit Batch
Default Value: 1000 |
| 122 | ASC_DESC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending
A=Ascending D=Descending Default Value: A |
| 123 | ASC_DESC_FLG2 | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 2
A=Ascending D=Descending Default Value: A |
| 124 | ASC_DESC_FLG3 | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 3
A=Ascending D=Descending Default Value: A |
| 125 | PAGE_BREAK | Character(1) | VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option
Y/N Table Edit Default Value: N |
| 126 | PAGE_BREAK2 | Character(1) | VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option 2
Y/N Table Edit Default Value: N |
| 127 | PAGE_BREAK3 | Character(1) | VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option 3
Y/N Table Edit Default Value: N |
| 128 | PICK_BATCH_BRK | Character(1) | VARCHAR2(1) NOT NULL |
Pick Batch Break
Y/N Table Edit Default Value: N |
| 129 | PICK_BATCH_BRK2 | Character(1) | VARCHAR2(1) NOT NULL |
Pick Batch Break 3
Y/N Table Edit Default Value: N |
| 130 | PICK_BATCH_BRK3 | Character(1) | VARCHAR2(1) NOT NULL |
Pick Batch Break 2
Y/N Table Edit Default Value: N |
| 131 | PRINT_ITEM_SUBS | Character(1) | VARCHAR2(1) NOT NULL |
Print Substitutes
N=No Y=Yes Y/N Table Edit Default Value: N |
| 132 | MAX_PULL_LINES | Number(2,0) | SMALLINT NOT NULL |
Max Suggest/Sub Locations
Default Value: 6 |
| 133 | USG_LABEL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Item Usage Labels
Y/N Table Edit Default Value: N |
| 134 | USG_LBL_FILE_DIR | Character(80) | VARCHAR2(80) NOT NULL | File Directory |
| 135 | USG_LBL_FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 136 | USG_LBL_OVER_FILE | Character(1) | VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit Default Value: N |
| 137 | EXTRACT_FILE | Character(1) | VARCHAR2(1) NOT NULL |
Create Extract File
Y/N Table Edit Default Value: N |
| 138 | EXTRACT_FILE_DIR | Character(80) | VARCHAR2(80) NOT NULL | File Directory |
| 139 | EXTRACT_FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 140 | EXTRACT_OVER_FILE | Character(1) | VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit Default Value: N |
| 141 | WAVE_ASC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending
A=Ascending Order D=Descending Order Default Value: A |
| 142 | WAVE_ASC_FLGB | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 4
A=Ascending Order D=Descending Order Default Value: A |
| 143 | WAVE_ASC_FLGC | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 5
A=Ascending Order D=Descending Order Default Value: A |
| 144 | WAVE_ASC_FLG2 | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 2
A=Ascending Order D=Descending Order Default Value: A |
| 145 | WAVE_ASC_FLG3 | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending 3
A=Ascending Order D=Descending Order Default Value: A |
| 146 | WAVE_BREAK | Character(1) | VARCHAR2(1) NOT NULL |
Wave Page Break Option
Y/N Table Edit Default Value: N |
| 147 | WAVE_BREAKB | Character(1) | VARCHAR2(1) NOT NULL |
Wave Page Break Option 4
Y/N Table Edit Default Value: N |
| 148 | WAVE_BREAKC | Character(1) | VARCHAR2(1) NOT NULL |
Wave Page Break Option 5
Y/N Table Edit Default Value: N |
| 149 | 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 |
| 150 | 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 |
| 151 | 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 |
| 152 | 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 |
| 153 | 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 |
| 154 | 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 |
| 155 | CRT_LBL_FILE_DIR | Character(80) | VARCHAR2(80) NOT NULL | File Directory |
| 156 | CRT_LBL_FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 157 | CRT_LBL_OVER_FILE | Character(1) | VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit Default Value: N |
| 158 | LABEL_UOM | Character(1) | VARCHAR2(1) NOT NULL |
Unit of Measure
1=Order 2=Standard 3=Standard Pack |
| 159 | RELEASE_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL |
08/2004 rcw: Order Release Instance
Prompt Table: %EDITTABLE22 |
| 160 | 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 |
| 161 | INV_CART_ID | Character(15) | VARCHAR2(15) NOT NULL |
Par Location ID
Prompt Table:
IN_CART_PRMT_VW
|
| 162 | LABEL_FORMAT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Format ID
Prompt Table: %EDITTABLE20 |
| 163 | NUMBER_OF_LABELS | Number(3,0) | SMALLINT NOT NULL |
Nbr of Labels
Default Value: 1 |
| 164 | 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 |
| 165 | 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) |
| 166 | PICKING_TIEBREAKER | Character(2) | VARCHAR2(2) NOT NULL |
Picking Location Tiebreaker
01=Fewest Locations 02=Pick To Clear |
| 167 | PICKING_NOTES | Character(3) | VARCHAR2(3) NOT NULL |
Picking Notes
00=None 01=Largest Batch First 02=Smallest Batch First 03=Broken Pallet First |
| 168 | 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 |
| 169 | CONTAINER_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Picking from Containers
Y/N Table Edit |
| 170 | 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 |
| 171 | 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 |
| 172 | OUTDEST | Character(127) | VARCHAR2(127) NOT NULL | Process Scheduler Output Destination |
| 173 | PICK_PLAN_BY_UOM | Character(1) | VARCHAR2(1) NOT NULL |
Order Unit of Measure
Y/N Table Edit Default Value: N |
| 174 | IN_PRINT_PICK_QTY | Character(1) | VARCHAR2(1) NOT NULL |
Print Pick Quantity option
0=Print Pick Quantity Only 1=Print All Quantity Fields |
| 175 | IN_PICK_QTY_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Pick Quantity Option
0=Use Available Balance 1=Use Planned Pick Quantity |
| 176 | FPB_WORKFLOW_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use Fixed Pick Workflow
Y/N Table Edit Default Value: N |
| 177 | FPB_ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
Fixed Picking Bin Role Name
Prompt Table: ROLE_USRLST_VW |
| 178 | FPB_RTE_CNTL_TYPE | Character(30) | VARCHAR2(30) NOT NULL |
Route Control Type
Prompt Table: RTE_CNTL_TYPE |
| 179 | FPB_RTE_FROM_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
From Value
Prompt Table: %EDITTABLE |
| 180 | FPB_RTE_TO_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
To Value
Prompt Table: %EDITTABLE |
| 181 | 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 |
| 182 | IN_ALLOW_SPLIT | Character(1) | VARCHAR2(1) NOT NULL |
Allow Split
Y/N Table Edit Default Value: N |
| 183 | IN_ALLOC_RESERV | Character(1) | VARCHAR2(1) NOT NULL |
Pick Only Reserved
Y/N Table Edit Default Value: N |
| 184 | IN_KEEP_RESERV | Character(1) | VARCHAR2(1) NOT NULL |
Keep Reservations
Y/N Table Edit Default Value: N |
| 185 | IN_KEEP_LOT_ALLOC | Character(1) | VARCHAR2(1) NOT NULL |
Keep Lot Allocations
Y/N Table Edit Default Value: Y |
| 186 | IN_PRINT_KIT_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Print Kit Header
Y/N Table Edit Default Value: N |
| 187 | IN_KEEP_PRE_ALLOC | Character(1) | VARCHAR2(1) NOT NULL |
Keep Pre Allocations
Y/N Table Edit Default Value: Y |
| 188 | IN_KEEP_ALLOCATION | Character(1) | VARCHAR2(1) NOT NULL |
Keep All Allocations
Y/N Table Edit Default Value: N |
| 189 | IN_RMV_SHP_SER | Character(1) | VARCHAR2(1) NOT NULL |
Remove Ship Serials
Y/N Table Edit Default Value: N |
| 190 | IN_RMV_SHP_ID | Character(1) | VARCHAR2(1) NOT NULL |
Remove from Ship ID
Y/N Table Edit Default Value: Y |
| 191 | IN_EXCLUDE_RTV | Character(1) | VARCHAR2(1) NOT NULL |
Exclude RTVs
Y/N Table Edit Default Value: N |
| 192 | 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 |
| 193 | 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 |
| 194 | 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 |
| 195 | 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 |
| 196 | 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 |
| 197 | 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 |
| 198 | TRANSACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 199 | 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 |
| 200 | LAST_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |