SF_COMPO_BC_VW

(SQL View)
Index Back

BCT Prdn ID Comp Op View

970926 cam (CN# SF750-10.0) : Prompt table view for bar code panels to limit operations to a production ID and component list. 971111 cam (CN# MG750-6.0) : Remove QTY_PER as unused. 980128 cam (CN# SF750-10.0) : Remove unused NON_OWN_FLG.

Select a.BUSINESS_UNIT, a.PRODUCTION_ID, a.COMPONENT_ID, a.OP_SEQUENCE, a.QTY_CODE, a.CONFIG_CODE from PS_SF_COMP_LIST A

# 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

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
3 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
6 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator