| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
TEMPLATE_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Template Code
|
| 3 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
TMPL_TABLE_NAME |
Character(2) |
VARCHAR2(2) NOT NULL |
Field Used to store table that item template will be updating
1=Master Item Group
10=Item Cost Method
11=Product Attributes Group
12=BU Item Substitutes
13=Purchasing Attributes Group
14=Inventory Management Group
15=Inventory Fulfillment Group
16=Picking/Putaway Zones
17=Fixed Picking Location
18=Default Putaway Location
19=Item Putaway Rules
2=Inventory Items
20=Planning Attributes
21=Replenishment Attributues
22=Automatic Serial Numbering
23=PO BU Item Attributes
24=Item Supplier Attributes Group
3=Inv Item UOM
30=Manufactured Item Group
31=UPN Attributes
32=GPO Attributes
36=Replenishment Location
4=Item UOM Type
5=Substitute Items
6=Business Unit Item Group
7=BU Items Config
8=BU Items Util CD
9=BU Items WtVol
Default Value: 15
|
| 6 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 7 |
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
|
| 8 |
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)
|
| 9 |
PICKING_TIEBREAKER |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Location Tiebreaker
01=Fewest Locations
02=Pick To Clear
|
| 10 |
FPB_WORKFLOW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Fixed Pick Workflow
Y/N Table Edit
|
| 11 |
PICK_PLAN_BY_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Unit of Measure
Y/N Table Edit
|
| 12 |
SOFT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Soft Reserve
Y/N Table Edit
|
| 13 |
ALLOC_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Reservation Lead Days
|
| 14 |
ADHOC_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Adhoc Requisitions
Y/N Table Edit
|
| 15 |
CONTAINER_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Picking from Containers
Y/N Table Edit
|
| 16 |
LABEL_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit of Measure
1=Order
2=Standard
3=Standard Pack
|
| 17 |
FPB_ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Fixed Picking Bin Role Name
Prompt Table:
ROLE_USRLST_VW
|
| 18 |
FPB_RTE_CNTL_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Route Control Type
Prompt Table:
RTE_CNTL_TYPE
|
| 19 |
FPB_RTE_FROM_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
From Value
Prompt Table:
%EDITTABLE
|
| 20 |
FPB_RTE_TO_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
To Value
Prompt Table:
%EDITTABLE
|
| 21 |
ONLINE_RES_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Online Reservation Flag
Y/N Table Edit
|
| 22 |
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
|
| 23 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
Y/N Table Edit
|
| 24 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
Y/N Table Edit
|
| 25 |
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
|
| 26 |
CROSS_DOCK_LEAD |
Number(3,0) |
SMALLINT NOT NULL |
Cross Dock Lead Days
|
| 27 |
QTY_MIN_STD |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Min Quantity Standard UOM
|
| 28 |
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
|
| 29 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
TML_AREA_VW
|
| 30 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
TML_LVL1_VW
|
| 31 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
TML_LVL2_VW
|
| 32 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
TML_LVL3_VW
|
| 33 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
TML_LVL4_VW
|
| 34 |
IN_LINE_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Backorder Rule
Prompt Table:
IN_RULE_B_VW
|
| 35 |
IN_LINE_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation Rule
Prompt Table:
IN_RULE_R_VW
|
| 36 |
IN_LN_RESV_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation - Backorder
Prompt Table:
IN_RULE_R_VW
|
| 37 |
UNIT_MEASURE_ORD |
Character(3) |
VARCHAR2(3) NOT NULL |
Ordering UOM
Prompt Table:
UNITS_TBL
|
| 38 |
FROM_STOR_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
From storage area
Prompt Table:
TML_STOR_AR_VW
|
| 39 |
FROM_STOR_LEV1 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 1
Prompt Table:
TML_STOR_L1_VW
|
| 40 |
FROM_STOR_LEV2 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 2
Prompt Table:
TML_STOR_L2_VW
|
| 41 |
FROM_STOR_LEV3 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 3
Prompt Table:
TML_STOR_L3_VW
|
| 42 |
FROM_STOR_LEV4 |
Character(4) |
VARCHAR2(4) NOT NULL |
From Storage Level 4
Prompt Table:
TML_STOR_L4_VW
|
| 43 |
IN_FRT_AUTO_PACK |
Character(1) |
VARCHAR2(1) NOT NULL |
10/29/07 EGS: Created
Y/N Table Edit
|