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