SF_ISS_TMP

(SQL Table)
Index Back

Temp table for Lot Ser

5/16/00 mmt

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
5 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
6 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
7 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
8 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

Prompt Table: %EDITTABLE31

9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

Prompt Table: %EDITTABLE32

10 SF_ROW_NUM Number(6,0) INTEGER NOT NULL Row Number
11 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
12 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
13 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested