SF_COMP_LIST

(SQL Table)
 Index Back

Production Component List

08/27/97 MEG (CN# SF750-4.0) Changed prompt table for component id from mg_item_ncfg_vw to mg_item_appr_vw since in 7.5 we allow configured items in a component list. Added prompt table for config code - set to cp_config_vw. 9/19/97 JNW (CN# PL750-DI-GPENN-52): production_id saveprechg logic for era net change 11/05/97 MPD (CN# MG750-6.0): - 7.5 sf_qty_per field added 11/05/97 MPD (CN# MG750-7.0): - 7.5 sf_flr_exp_flag field added 11/13/97 DDW (CN# MG750-7.0) - deleted sf_flr_exp_flag and replaced with source_code 971113 cam (CN# MG750-6.0) : Transfer all code formerly associated with QTY_PER to new SF_QTY_PER field. CN#SF750-1.1 ARG 11/18/97 - Removed Issue_loc_qty 01/29/98 meg CN#750-4.0: Changed prompt table for config_code to sf_cfg_comp_vw. 07/30/1998 whs CN#800-1.0: New RowInit events to set grid labels. 01/21/1999 MDS CN# EN800-1.0: Added MG_ORIG_COMP_ID, MG_ORIG_CURSCH_QTY and PARENT_ITEM_ID. 01/28/99 JNW (CN#SF800-13): added teardown_flag 06/25/99 lee CN#MG800-4.0 Changed mg_item_appr_vw to mg_itme_apr2_vw to include expensed items. Changed: component_id RI. 06/30/99 lee CN#MG800-4.0 - Added panelgroup comp_maint_gen to update plan_change_flg and last_dttm_update. 06/30/99 lee CN#MG800-4.0 Gray Expensed items in component_id.rowinit. 10/04/99 ST Modified edittable 17 to 21 on Op Sequence as it was bweing overwritten by Item Search popup

# 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_BUMGOP_NONVW

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Prompt Table: SF_COMP_MTN_VW

3 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

Prompt Table: %EDITTABLE5

4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

Prompt Table: %EDITTABLE21

5 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
6 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

Default Value: ASY

7 SF_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL 07/06/99 SCC CN# SF800-9.0: Added label Quantity
8 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield

Default Value: 100

9 SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL Component Scheduled Qty
10 CURR_SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED
11 MG_ORIG_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL original qty per
12 ISSUE_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
13 YIELD_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
14 PEND_CONSUME_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME
15 PEND_LOSS_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS
16 PICK_QTY Number(12,4) DECIMAL(11,4) NOT NULL Pending Pick Quantity
17 PARENT_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Parent Item ID
18 TRANSACTION_FLAG Character(1) VARCHAR2(1) NOT NULL Component Issue/Receipt Flag
1=Issue Material from Stock
2=Return Material to Stock
19 ISSUE_METHOD Character(4) VARCHAR2(4) NOT NULL Component Issue Method
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish
20 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes

Y/N Table Edit

21 TEARDOWN_FLAG Character(1) VARCHAR2(1) NOT NULL 01/28/99 jnw (CN#SF800-13) added field

Y/N Table Edit

Default Value: N

22 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: SF_CFG_COMP_VW

23 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
24 INCR_CONS_TYPE Character(1) VARCHAR2(1) NOT NULL 07/22/02 EGS (CN#PL880-1): Added
1=None
2=Over Time

Default Value: 1

25 INCR_CONS_OFFSET Number(16,4) DECIMAL(15,4) NOT NULL 07/22/02 EGS (CN#PL880-1): Added
26 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
27 CMA_CTL_ID Character(25) VARCHAR2(25) NOT NULL Audit Test field
28 TRACE_USAGE Character(1) VARCHAR2(1) NOT NULL Trace Usage
0=None
1=Serial Trace
2=Lot Trace

Default Value: MASTER_ITEM_TBL.TRACE_USAGE

29 SF_ASSOC_QTY Number(12,4) DECIMAL(11,4) NOT NULL Component Scheduled Qty

Default Value: 0