SF_COMPLIST_VW

(SQL View)
 Index Back

Component List View

This view is a copy of sf_comp_list with the addition of descr60. Any changes that are made to sf_comp_list also need to be made here.

SELECT a.business_unit , a.production_id , a.component_id , a.op_sequence , a.mg_orig_comp_id , a.qty_code , a.sf_qty_per , a.yield , a.sched_qty , a.curr_sched_qty , a.mg_orig_qty_per , a.issue_qty , a.yield_qty , a.pend_consume_qty , a.pend_loss_qty , a.pick_qty , a.parent_item_id , a.transaction_flag , a.issue_method , a.non_own_flag , a.teardown_flag , a.config_code , a.source_code , a.incr_cons_type , a.incr_cons_offset , a.cma_ctl_id , a.trace_usage , a.sf_assoc_qty , b.descr60 , a.text254 FROM ps_sf_comp_list a , PS_MASTER_ITEM_TBL b , ps_set_cntrl_rec c WHERE a.business_unit = c.setcntrlvalue AND c.recname = 'MASTER_ITEM_TBL' AND b.setid = c.setid AND a.component_id = b.inv_item_id

# 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

Default Value: 1

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

Default Value: 1

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 CMA_CTL_ID Character(25) VARCHAR2(25) NOT NULL Audit Test field
27 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

28 SF_ASSOC_QTY Number(12,4) DECIMAL(11,4) NOT NULL Component Scheduled Qty
29 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
30 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text