SF_SEREDT_BC_VW

(SQL View)
Index Back

BCT Serial Comp Returns View

980226 cam (CN# SF750-10.0) : Prompt table view based on SF_COMPQTY_VW, which limits the data to the production area/component/op. This view provides the serial ID prompt on edit issue returns (i.e.: negative quantity) transaction update panel. 04/01/99 meg (cn#sf800-27.0) Removed container_id.

SELECT A.business_unit, A.prdn_area_code, A.component_id, A.op_sequence, A.revision, A.qty_code, A.inv_lot_id, A.serial_id FROM PS_SF_COMPQTY_VW A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
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 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
6 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
7 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID