| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 2 |
PICKING_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Location Option
01=Fixed Pick Location
03=Default Putaway Location
05=Default Shipment Location
08=Container Option
09=Pick by Date
10=All Available Locations
Default Value: 01
|
| 3 |
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)
|
| 4 |
PICKING_TIEBREAKER |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Location Tiebreaker
01=Fewest Locations
02=Pick To Clear
Default Value: 01
|
| 5 |
FPB_WORKFLOW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Fixed Pick Workflow
Y/N Table Edit
Default Value: N
|
| 6 |
PICK_PLAN_BY_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Unit of Measure
Y/N Table Edit
Default Value: N
|
| 7 |
PICKING_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Picking Lead Days
|
| 8 |
PICKING_LEAD_TIME |
Number(3,0) |
SMALLINT NOT NULL |
Picking Lead Minutes
|
| 9 |
PICKING_LEAD_HRS |
Time(15) |
TIMESTAMP |
Picking Lead Hours
|
| 10 |
PICKING_NOTES |
Character(3) |
VARCHAR2(3) NOT NULL |
Picking Notes
00=None
01=Largest Batch First
02=Smallest Batch First
03=Broken Pallet First
Default Value: 03
|
| 11 |
PICKING_DT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to determine the Date selection criteria used when submitting jobs to the Picking Plan.
01=Date/Time Range
02=Lead Days/Minutes
03=Today/Until
Default Value: 03
|
| 12 |
PICKING_DT_FROM |
Date(10) |
DATE |
Picking Selection From Date
|
| 13 |
PICKING_DT_TO |
Date(10) |
DATE |
Picking Selection To Date
|
| 14 |
PICK_TIME_FROM |
Time(15) |
TIMESTAMP |
Picking From Time
|
| 15 |
PICK_TIME_TO |
Time(15) |
TIMESTAMP |
Picking To Time
|
| 16 |
PICK_TIME_UNTIL |
Time(15) |
TIMESTAMP |
Picking Until Time
|
| 17 |
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
Default Value: 02
|
| 18 |
ASC_DESC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending
A=Ascending
D=Descending
Default Value: A
|
| 19 |
PAGE_BREAK |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option
Y/N Table Edit
Default Value: N
|
| 20 |
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
|
| 21 |
ASC_DESC_FLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 2
A=Ascending
D=Descending
Default Value: A
|
| 22 |
PAGE_BREAK2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option 2
Y/N Table Edit
Default Value: N
|
| 23 |
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
|
| 24 |
ASC_DESC_FLG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Ascending or Descending 3
A=Ascending
D=Descending
Default Value: A
|
| 25 |
PAGE_BREAK3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Plan Page Break Option 3
Y/N Table Edit
Default Value: N
|
| 26 |
TSE_TRIGGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Validation
Y/N Table Edit
Default Value: N
|
| 27 |
SOFT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Soft Reserve
Y/N Table Edit
Default Value: N
|
| 28 |
ALLOC_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Reservation Lead Days
|
| 29 |
ALLOC_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Sort Option
D=Date
O=Order Nbr
P=Priority
Default Value: D
|
| 30 |
AUTO_DEMD_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Stock Approval
Y/N Table Edit
Default Value: N
|
| 31 |
AUTO_BCK_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Backorder Approval
Y/N Table Edit
Default Value: N
|
| 32 |
AUTO_PRT_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Partial Qty Approval
Y/N Table Edit
Default Value: N
|
| 33 |
PRICE_MARKUP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Price / Markup Overrides
Y/N Table Edit
Default Value: N
|
| 34 |
ADHOC_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Adhoc Requisitions
Y/N Table Edit
Default Value: N
|
| 35 |
INTERUNIT_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Interunit BackOrders
Y/N Table Edit
Default Value: N
|
| 36 |
SHIP_PREP |
Number(6,0) |
INTEGER NOT NULL |
KPN 08/21/02: Changed long name of SHIP_PREP from Ship Preparation Time [Min] to Ship Preparation Time (Min)
|
| 37 |
FRONT_LOAD_FCST |
Character(1) |
VARCHAR2(1) NOT NULL |
Front Load Forecast
Y/N Table Edit
Default Value: N
|
| 38 |
ALLOW_FCST_CONSUME |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Forecast Consumption
Y/N Table Edit
Default Value: Y
|
| 39 |
CONTAINER_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Picking from Containers
Y/N Table Edit
Default Value: N
|
| 40 |
CARTON_LABELS |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Carton Labels
Y/N Table Edit
Default Value: N
|
| 41 |
LABEL_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit of Measure
1=Order
2=Standard
3=Standard Pack
Default Value: 1
|
| 42 |
CRT_LBL_FILE_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 43 |
CRT_LBL_FILE_PREF |
Character(3) |
VARCHAR2(3) NOT NULL |
File Prefix
|
| 44 |
CRT_LBL_FILE_SUF |
Character(4) |
VARCHAR2(4) NOT NULL |
File Suffix
|
| 45 |
EXTRACT_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Extract File
Y/N Table Edit
Default Value: N
|
| 46 |
EXTRACT_FILE_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 47 |
EXTRACT_FILE_PREF |
Character(3) |
VARCHAR2(3) NOT NULL |
File Prefix
|
| 48 |
EXTRACT_FILE_SUF |
Character(4) |
VARCHAR2(4) NOT NULL |
File Suffix
|
| 49 |
PRINT_BARCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Code on Report Flag
Y/N Table Edit
Default Value: N
|
| 50 |
PRINT_BARCD_CTLFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Coded Control Flags
Y/N Table Edit
Default Value: N
|
| 51 |
SHOW_TOTAL_PIECES |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Total Pieces
Y/N Table Edit
Default Value: N
|
| 52 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_WT_VW
|
| 53 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_VOL_VW
|
| 54 |
ROUTE_CLOSE_TIME |
Time(15) |
TIMESTAMP |
Determines the time on a given schedule date after which no more orders can be assigned to a particular route at the given schedule date.
|
| 55 |
ROUTE_STOP_INC |
Number(3,0) |
SMALLINT NOT NULL |
Determines how route stop numbers will be incremented for route codes in a given business unit. It is defined in Fulfillment Setup at a business unit level.
Default Value: 1
|
| 56 |
PRINT_ITEM_SUBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Substitutes
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 57 |
USG_LABEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Item Usage Labels
Y/N Table Edit
Default Value: N
|
| 58 |
USG_LBL_FILE_DIR |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 59 |
USG_LBL_FILE_PREF |
Character(3) |
VARCHAR2(3) NOT NULL |
File Prefix
|
| 60 |
USG_LBL_FILE_SUF |
Character(4) |
VARCHAR2(4) NOT NULL |
File Suffix
|
| 61 |
FPB_ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Fixed Picking Bin Role Name
Prompt Table:
ROLE_USRLST_VW
|
| 62 |
FPB_RTE_CNTL_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Route Control Type
Prompt Table:
RTE_CNTL_TYPE
|
| 63 |
FPB_RTE_FROM_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
From Value
Prompt Table:
%EDITTABLE
|
| 64 |
FPB_RTE_TO_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
To Value
Prompt Table:
%EDITTABLE
|
| 65 |
ONLINE_RES_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Online Reservation Flag
Y/N Table Edit
Default Value: N
|
| 66 |
ALLOW_SUB_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether item substitutions are allowed on the order schedule.
Y/N Table Edit
Default Value: N
|
| 67 |
ALLOW_OVERPICK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether or not overpicking is allowed for a customer or business unit.
Y/N Table Edit
Default Value: N
|
| 68 |
MAX_PICK_TOLERANCE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Used to indicate the allowable percentage of overshipment for a customer or business unit.
|
| 69 |
ATP_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
This field determines the window in which an order line can be ATP-reserved. If the scheduled shipment date is within today + ATP lead days, then the order line may be ATP-reserved; if the scheduled shipment date is outside this window, the order line cannot be ATP-reserved.
|
| 70 |
ATP_INCL_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether approved PO requisitions should be included as supply in the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 71 |
ATP_INCL_CO_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether co-products and by-products (from a production order) should be included as supply in the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 72 |
ATP_INCL_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether dependent demand (from a production order) should be included as demand in the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 73 |
ATP_INCL_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether ALM demand that is in IN_DEMAND should be included as demand in the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 74 |
ATP_INCL_WIP |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether quantity in WIP locations should be included in the starting quantity available when calculating ATP for an item.
Y/N Table Edit
Default Value: N
|
| 75 |
PARTIAL_ORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Orders Can Ship
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 76 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
Y/N Table Edit
Default Value: N
|
| 77 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
Y/N Table Edit
Default Value: N
|
| 78 |
PRT_PACKSLIP_BARCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Packing Slip Bar Code
Y/N Table Edit
Default Value: N
|
| 79 |
PRINT_BOL_BARCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bill of Lading Bar Code
Y/N Table Edit
Default Value: N
|
| 80 |
LOC_TRANS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Location Detail
Y/N Table Edit
Default Value: N
|
| 81 |
PTWY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Putaway Option
1=Stage for Putaway
2=Putaway at Save
Default Value: 1
|
| 82 |
CHECK_HOLDS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Sales Orders for Holds
Y/N Table Edit
Default Value: N
|
| 83 |
ALLOW_ADDR_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Address Override
Y/N Table Edit
Default Value: N
|
| 84 |
PACK_LNS_ONLY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Packed Lines Only
Y/N Table Edit
Default Value: N
|
| 85 |
PACK_QTY_ONLY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Packed Qty Only
Y/N Table Edit
Default Value: N
|
| 86 |
PARTIAL_PACK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Pack Allowed
Y/N Table Edit
Default Value: Y
|
| 87 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
|
| 88 |
USE_AE_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use AE Shipping Helper
Y/N Table Edit
Default Value: N
|
| 89 |
LOG_ERROR_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Log Errors Option
BT=Transaction Error Log
ML=Message Log
Default Value: BT
|
| 90 |
ALLOW_OVERRIDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Override of Lead Days
Y/N Table Edit
Default Value: N
|
| 91 |
MAX_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Lead Days
|
| 92 |
CROSS_DOCK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Dock Flag
A=All receipts
N=No cross docking
P=Pegged receipts, only
Y=Non-pegged receipts, only
Y/N Table Edit
Default Value: N
|
| 93 |
CROSS_DOCK_LEAD |
Number(3,0) |
SMALLINT NOT NULL |
Cross Dock Lead Days
|
| 94 |
USE_CLOSE_CAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Closure Calendar
Y/N Table Edit
Default Value: Y
|
| 95 |
SEL_NOT_PICK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Unpicked Orders Only
Y/N Table Edit
Default Value: Y
|
| 96 |
CUST_NOTE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Customer Notes
Y/N Table Edit
Default Value: N
|
| 97 |
ORD_HDR_NOTE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Order Header Notes
Y/N Table Edit
Default Value: N
|
| 98 |
ORD_LINE_NOTE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Order Line Notes
Y/N Table Edit
Default Value: N
|
| 99 |
PICK_NOLOAD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Lines Awaiting Upload
Y/N Table Edit
Default Value: N
|
| 100 |
UPLOAD_PICKED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Upload After Picking
Y/N Table Edit
Default Value: N
|
| 101 |
TOT_WT_VOL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Weight and Volume UOM
1=Standard
2=Order
3=Pack
Default Value: 1
|
| 102 |
SEL_ORIG_LOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include From Location Address
Y/N Table Edit
Default Value: Y
|
| 103 |
SEL_DEST_LOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include To Location Address
Y/N Table Edit
Default Value: Y
|
| 104 |
USE_DATE_TIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Time in Creating TMS ID
Y/N Table Edit
Default Value: N
|
| 105 |
TMS_RESEND_ERR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resend Error for TMS transaction
Y/N Table Edit
Default Value: Y
|
| 106 |
HOLD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Switch
N=No Hold
Y=On Hold
|
| 107 |
RELEASE_LOCKS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
When selected this option allows locks to be released on all but the first processing group of data once the processing groups are determined.
Y/N Table Edit
Default Value: N
|
| 108 |
AUTO_SCHEDULE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates to automatically create a run control and schedule processing.
Y/N Table Edit
Default Value: N
|
| 109 |
DFLT_SHP_LOC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Ship Location Option
1=Default Ship Staging Location
2=Default Cross Docking Location
3=Default Putaway Location
4=Default Inspection Location
5=Default Fixed Picking Bin Loc
6=Manually Entered Location
7=Default Pegging Location
Default Value: 1
|
| 110 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
STOR_AREA_VW2
|
| 111 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
STOR_LEV1_VW2
|
| 112 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
STOR_LEV2_VW2
|
| 113 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
STOR_LEV3_VW2
|
| 114 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
STOR_LEV4_VW2
|
| 115 |
ATP_INCL_STG_SUP |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether planned orders should be included as supply n the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 116 |
ATP_INCL_STG_DMD |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether planned orders should be included as demand n the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 117 |
ATP_STG_DEP_DMD |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Y/N field that determines whether dependent demand should be included as supply in the ATP calculation.
Y/N Table Edit
Default Value: N
|
| 118 |
ATP_INCL_PPUR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Purchase Orders
Y/N Table Edit
Default Value: N
|
| 119 |
ATP_PPUR_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Planned Purchase Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 120 |
ATP_PPUR_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Planned Purchase Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 121 |
ATP_PPUR_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Planned Purchase Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 122 |
ATP_INCL_PTRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Transfer Supply
Y/N Table Edit
Default Value: N
|
| 123 |
ATP_PTRS_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Supply Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 124 |
ATP_PTRS_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Supply Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 125 |
ATP_PTRS_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Supply Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 126 |
ATP_INCL_PTRD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Transfer Demand
Y/N Table Edit
Default Value: N
|
| 127 |
ATP_PTRD_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Demand Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 128 |
ATP_PTRD_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Demand Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 129 |
ATP_PTRD_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Transfer Demand Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 130 |
ATP_INCL_PPRS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Production Supply
Y/N Table Edit
Default Value: N
|
| 131 |
ATP_PPRS_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Prdn Supply Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 132 |
ATP_PPRS_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Production Supply Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 133 |
ATP_PPRS_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Production Supply Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 134 |
ATP_INCL_PPRD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Production Demand
Y/N Table Edit
Default Value: N
|
| 135 |
ATP_PPRD_APPR_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Prdn Demand Approval
10=Approved
20=Unapproved
30=Both
Default Value: 30
|
| 136 |
ATP_PPRD_FRZ_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Production Demand Frozen
10=Frozen
20=Unfrozen
30=Both
Default Value: 30
|
| 137 |
ATP_PPRD_STAT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Plan Production Demand Status
10=Planned
20=Firm Plan
30=Both
Default Value: 30
|
| 138 |
ATP_INCL_EPR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Entered Status Production
Y/N Table Edit
Default Value: N
|
| 139 |
RUN_DIRECT_INVOICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Direct Invoicing
|
| 140 |
IN_NSFT_RSV_ST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag that indicates whether non-soft-reserved items should be added to the demand table in an Unfulfilled or Releasable state.
0=Unfulfilled
1=Releasable
Default Value: 0
|
| 141 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
IN_RLS_OPRID_VW
|
| 142 |
RLS_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table:
IN_RLS_RCID_VW
|
| 143 |
IN_MSR_ENT_RSV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag that indicates whether reservations will be performed online or in the background from the MSR Entry page.
0=Online
1=Background
Default Value: 1
|
| 144 |
IN_NEG_AVL_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Negative Available Qty Allowed
Y/N Table Edit
Default Value: N
|
| 145 |
IN_LINE_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Backorder Rule
Prompt Table:
IN_RULE_B_VW
|
| 146 |
IN_LINE_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation Rule
Prompt Table:
IN_RULE_R_VW
|
| 147 |
IN_LN_RESV_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation - Backorder
Prompt Table:
IN_RULE_R_VW
|
| 148 |
IN_ORDER_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Reservation Rule
Prompt Table:
IN_RULE_O_VW
|
| 149 |
IN_RLS_KMULT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether kits should be released as whole multiples
Y/N Table Edit
Default Value: Y
|
| 150 |
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
|
| 151 |
IN_PICKPLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Picking Plan
Y/N Table Edit
Default Value: N
|
| 152 |
SEL_ORD_REL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created for outbound messaging.
Y/N Table Edit
Default Value: N
|
| 153 |
IN_MRK_CONFIRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mark for Confirmations
Y/N Table Edit
Default Value: N
|
| 154 |
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
Default Value: 1
|
| 155 |
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: 3
|
| 156 |
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: 6
|
| 157 |
OUTDEST |
Character(127) |
VARCHAR2(127) NOT NULL |
Process Scheduler Output Destination
|
| 158 |
PICK_BATCH_BRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Batch Break
Y/N Table Edit
Default Value: N
|
| 159 |
IN_VRFY_SHP_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verify Ship Date
Y/N Table Edit
Default Value: Y
|
| 160 |
IN_VRFY_SHP_TM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verify Ship Time
Y/N Table Edit
Default Value: Y
|
| 161 |
FROM_STOR_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
From storage area
Prompt Table:
STOR_AREA_VW2
|
| 162 |
FROM_STOR_LEV1 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 1
Prompt Table:
FROM_LV1_INV_VW
|
| 163 |
FROM_STOR_LEV2 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 2
Prompt Table:
FROM_LV2_INV_VW
|
| 164 |
FROM_STOR_LEV3 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 3
Prompt Table:
FROM_LV3_INV_VW
|
| 165 |
FROM_STOR_LEV4 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 4
Prompt Table:
FROM_LV4_INV_VW
|
| 166 |
IN_PICK_QTY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Quantity Option
0=Use Available Balance
1=Use Planned Pick Quantity
Default Value: 0
|
| 167 |
IN_PRINT_PICK_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Pick Quantity option
0=Print Pick Quantity Only
1=Print All Quantity Fields
Default Value: 0
|
| 168 |
IN_ALLOW_SPLIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Split
Y/N Table Edit
Default Value: N
|
| 169 |
SHIP_DOC_WARNING |
Character(1) |
VARCHAR2(1) NOT NULL |
Alert User if Shipment Changes
Y/N Table Edit
Default Value: N
|
| 170 |
SHIP_DOC_EARLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Printing Before Shipping
Y/N Table Edit
Default Value: N
|
| 171 |
CLR_TRK_AT_DEPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Tracking Info at Deplete
Y/N Table Edit
Default Value: N
|
| 172 |
IN_PRINT_KIT_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Kit Header
Y/N Table Edit
Default Value: N
|
| 173 |
REPORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recreate Unshipped Report
Y/N Table Edit
Default Value: N
|
| 174 |
PURGE_RESULTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge FlexFormula Results
Y/N Table Edit
Default Value: N
|
| 175 |
INCLUDE_RELSD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Released Allocations
Y/N Table Edit
Default Value: N
|
| 176 |
INCLUDE_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Pre-Relsd Allocations
Y/N Table Edit
Default Value: N
|
| 177 |
IN_DFR_DPL_BU_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Defer Depletions Default
1=Default Defer Depletions to Y
2=Default Defer Depletions to N
3=Do not use this feature
Default Value: 3
|
| 178 |
IN_ALLOW_DFR_DPL_O |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Defer Depletion override
Y/N Table Edit
Default Value: Y
|
| 179 |
IN_FRT_USAGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Indicator of internal or external freight
10=Internal
20=External
30=None
40=Both
Default Value: 30
|
| 180 |
IN_FRT_RATE_SHOP |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Freight Rate Shopping
1=Never
2=Optional
3=Always
Default Value: 1
|
| 181 |
IN_FRT_AUTO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
10/29/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 182 |
IN_FRT_AUTO_SO |
Character(1) |
VARCHAR2(1) NOT NULL |
10/29/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 183 |
IN_BEST_WAY_BTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Best Way Freight Option
10=Least Cost
20=By Commit Date
Default Value: 10
|
| 184 |
IN_FRT_DEL_MAX |
Number(10,0) |
DECIMAL(10) NOT NULL |
10/29/07 EGS: Created
|
| 185 |
IN_FRT_DMD_MAX |
Number(10,0) |
DECIMAL(10) NOT NULL |
10/29/07 EGS: Created
|
| 186 |
IN_FRT_PACK_MAX |
Number(10,0) |
DECIMAL(10) NOT NULL |
10/29/07 EGS: Created
|
| 187 |
INCL_SHIP_ADDR_EXT |
Character(1) |
VARCHAR2(1) NOT NULL |
10/29/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 188 |
IN_FRT_AUTO_PACK |
Character(1) |
VARCHAR2(1) NOT NULL |
10/29/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 189 |
IN_FRT_CANCEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/30/07 EGS: Created
Y/N Table Edit
Default Value: N
|
| 190 |
DW_DMD_MAX |
Number(10,0) |
DECIMAL(10) NOT NULL |
10/29/07 EGS: Created
|
| 191 |
DW_DEL_MAX |
Number(10,0) |
DECIMAL(10) NOT NULL |
10/29/07 EGS: Create
|
| 192 |
ADDL_COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table:
CE_ELEMENT6_VW
|
| 193 |
DELIVERY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
10/20/08 EGS: Created
1=Yes
2=Manual
3=No
Default Value: 3
|
| 194 |
MERGE_NOTIFY_EMAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Combine Notification Emails
N=No
Y=Yes
Default Value: N
|
| 195 |
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
|