PL_BU_ITEMSDEL(SQL Table) |
Index Back |
---|---|
PL Items Delete Table10/29/01 EGS (CN#PL900-1): Added. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table: SP_PRBINS_NONVW |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: PL_PI_BU_IN_VW |
3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: PL_PI_BU_ITM_VW |
4 | CFG_CODE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Configuration Code Generation
B=Both N=No Y=Yes Y/N Table Edit |
5 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes Y/N Table Edit |
6 | PHANTOM_ITEM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Phantom Item
Y/N Table Edit |
7 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
8 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
9 | ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down N=Natural Round U=Round Up |
10 | PL_ITEM_PREC | Number(3,0) | SMALLINT NOT NULL | 10/08/01 EGS (CN#PL900-1): Added. |
11 | PLANNED_BY | Character(1) | VARCHAR2(1) NOT NULL |
Planned By
1=Distribution Planning 2=Master Planning 3=Material Planning 4=Not Planned |
12 | DEMAND_FENCE_DATE | Date(10) | DATE | 08/16/01 EGS (CN#PL900-1.0): Added |
13 | FCST_PRI_RANK | Number(3,0) | SMALLINT NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
14 | SAFETY_PRI_RANK | Number(3,0) | SMALLINT NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
15 | SALES_CONSUMP | Character(1) | VARCHAR2(1) NOT NULL |
Sales Consumption
Y/N Table Edit Default Value: N |
16 | PROD_CONSUMP | Character(1) | VARCHAR2(1) NOT NULL |
Production Consumption
Y/N Table Edit Default Value: N |
17 | TRANS_CONSUMP | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Consumption
Y/N Table Edit Default Value: N |
18 | MSR_CONSUMP | Character(1) | VARCHAR2(1) NOT NULL |
10/12/01 EGS (CN#PL900-1): Added
Y/N Table Edit Default Value: N |
19 | EXTRA_CONSUMP | Character(1) | VARCHAR2(1) NOT NULL |
09/30/02 EGS (CN#PL880-1): Added
Y/N Table Edit Default Value: N |
20 | PL_AGG_DMD_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Aggregate Demand
Y/N Table Edit |
21 | PL_ITEM_EXPL | Character(1) | VARCHAR2(1) NOT NULL | jnw 10/1/99 (cn# mg800-12) created field |
22 | FCST_FULFILL_SIZE | Number(12,4) | DECIMAL(11,4) NOT NULL | Forecast Fulfillment Size |
23 | FCST_ADJ_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
02/28/02 EBN (CN#PL900-1.0): Added.
1=No Adjustment 2=Allocate to Next Bucket 3=Allocate to Last Bucket 4=Allocate Evenly Across Buckets 5=Allocate Using Calendar Weight |
24 | PL_FIXED_PERIOD | Number(3,0) | SMALLINT NOT NULL | Fixed Period (days) |
25 | ITEM_EARLY_DATE | Date(10) | DATE | 08/16/01 EGS (CN#PL900-1.0): Added |
26 | PL_SEARCH_DEPTH | Number(2,0) | SMALLINT NOT NULL | Search Depth |
27 | PL_SHIFT_DAYS | Number(3,0) | SMALLINT NOT NULL | Reschedule Early Limit |
28 | LOW_LEVEL_CD | Number(3,0) | SMALLINT NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
29 | INV_QTY_DTTM | DateTime(26) | TIMESTAMP | 08/16/01 EGS (CN#PL900-1.0): Added |
30 | INV_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
31 | QTY_AVAIL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Available |
32 | QTY_RESERVED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Reserved |
33 | STAGED_INF_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
34 | STAGED_ITEM_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
35 | QUAR_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
36 | SHIP_NOT_DEPL_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
37 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL | Family |
38 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
39 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
40 | PHASE_OUT | Character(1) | VARCHAR2(1) NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
Y/N Table Edit |
41 | ITM_STATUS_EFFDT | Date(10) | DATE | Item Status Date |
42 | PL_PROJ_USE_DT | Date(10) | DATE | 11/04/02 JC (CN#PL880-1): Added USEUP_DATE label |
43 | PL_PROJ_USE_QOH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 11/03/02 JC (CN#PL880-1): Added QOH_USEUP label 12/18/02 EGS (CN#PL880-1): Changed to 11.4. |
44 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |
45 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
46 | NET_CHANGE_QOH | Character(1) | VARCHAR2(1) NOT NULL |
02/11/02 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
47 | LOT_FOR_LOT_FLG | Character(1) | VARCHAR2(1) NOT NULL | 05/06/02 EGS (CN#PL900-1): Added |
48 | DP_WEIGHTPROFILE | Character(20) | VARCHAR2(20) NOT NULL | DP_WEIGHTPROFILE |
49 | UTILIZ_GROUP | Character(4) | VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count |
50 | UTILIZ_CD | Character(4) | VARCHAR2(4) NOT NULL | Utilization Type |
51 | SOURCE_CODE | Character(2) | VARCHAR2(2) NOT NULL |
8/5/97 lee - inactivated source code 4 - service
1=Make 2=Buy 3=Expense 4=Service 5=Floor Stock 6=Planning |
52 | PL_UNIT_COST | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | 09/27/02 EGS (CN#PL880-1): Changed to 13.4 |
53 | SPOT_BUY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
10/24/02 EGS (CN#PL880-1): Added
Y/N Table Edit Default Value: N |
54 | AOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Average Order Qty |
55 | PL_RESCHEDULE_TOL | Number(3,0) | SMALLINT NOT NULL |
Reschedule Tolerance(In days)
Default Value: 0 |
56 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |