| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUMGOP_NONVW
|
| 3 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
Prompt Table:
SF_COMP_MTN_VW
|
| 4 |
COMPONENT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
Prompt Table:
%EDITTABLE5
|
| 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 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 9 |
SF_QTY_PER |
Number(16,10) |
DECIMAL(15,10) NOT NULL |
07/06/99 SCC CN# SF800-9.0: Added label Quantity
|
| 10 |
YIELD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Component Yield
|
| 11 |
SCHED_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Component Scheduled Qty
|
| 12 |
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
|
| 13 |
MG_ORIG_QTY_PER |
Number(16,10) |
DECIMAL(15,10) NOT NULL |
original qty per
|
| 14 |
ISSUE_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
|
| 15 |
YIELD_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
|
| 16 |
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
|
| 17 |
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
|
| 18 |
PICK_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Pending Pick Quantity
|
| 19 |
PARENT_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Item ID
|
| 20 |
TRANSACTION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Component Issue/Receipt Flag
1=Issue Material from Stock
2=Return Material to Stock
|
| 21 |
ISSUE_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Component Issue Method
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish
|
| 22 |
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
|
| 23 |
TEARDOWN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
01/28/99 jnw (CN#SF800-13) added field
Y/N Table Edit
Default Value: N
|
| 24 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table:
SF_CFG_COMP_VW
|
| 25 |
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
|
| 26 |
INCR_CONS_OFFSET |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
07/22/02 EGS (CN#PL880-1): Added
|
| 27 |
INCR_CONS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
07/22/02 EGS (CN#PL880-1): Added
1=None
2=Over Time
|
| 28 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 29 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 30 |
CMA_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Audit Test field
|
| 31 |
TRACE_USAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Usage
0=None
1=Serial Trace
2=Lot Trace
|
| 32 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
|