| # |
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 |
LOCK_BOM_RTG |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy BOM/RTG
N=Don't Copy BOM/RTG
P=Prompt User
Y=Copy BOM/RTG
Default Value: N
|
| 3 |
PRDN_SCHED_DEFN |
Character(3) |
VARCHAR2(3) NOT NULL |
Prdn Schedule Defn
CMP=Completion Date
PRM=Prompt User
STR=Start Date
Default Value: CMP
|
| 4 |
RATES_BY_WC_TASK |
Character(3) |
VARCHAR2(3) NOT NULL |
Rate Maintenance / Defaulting
TSK=By Task
WC=By Work Center
Default Value: WC
|
| 5 |
BOM_VERIFICATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Online BOM Verification
N=Never Verify Online
O=Prompt User
Y=Always Verify Online
Default Value: N
|
| 6 |
CALENDAR_CODE_PR |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Calendar Code
Prompt Table:
MG_CAL_PRMPT_VW
|
| 7 |
CALENDAR_CODE_RT |
Character(10) |
VARCHAR2(10) NOT NULL |
Run-time Calendar Code
|
| 8 |
CALC_PER_ORDER_FLG |
Character(4) |
VARCHAR2(4) NOT NULL |
Calc Per Order for Prdn Sched
CALC=Calc Per Order for Prdn Sched
NOCA=Don't Calc Per Ord on Prdn Sch
Default Value: CALC
|
| 9 |
TRDN_DEFAULT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
3/1/99 JNW (CN#SF800-13): added field
Y/N Table Edit
Default Value: Y
|
| 10 |
REVISION_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Revision Control
Y/N Table Edit
Default Value: N
|
| 11 |
BOM_USAGE |
Character(2) |
VARCHAR2(2) NOT NULL |
BOM Usage
1=By Effectivity Date
2=By Revision
Default Value: 1
|
| 12 |
EN_AUTO_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
02/16/99 LAJ...CN#EG800-1.0
Yes/No field to indicate if new revisions should be created automatically.
Y/N Table Edit
Default Value: N
|
| 13 |
FREZ_PRDN_PL_RW |
Character(1) |
VARCHAR2(1) NOT NULL |
5/25/99 jnw cn#sf800-13 created field
Y/N Table Edit
Default Value: N
|
| 14 |
FREZ_PRDN_PL_TD |
Character(1) |
VARCHAR2(1) NOT NULL |
5/25/99 jnw cn#sf800-13 created field
Y/N Table Edit
Default Value: N
|
| 15 |
FREZ_PRDN_AUTO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
SGL added 02/24/00
1=Auto Freeze Planning
2=No Auto Freeze Planning
Default Value: 1
|
| 16 |
MG_AUTO_REL_PID |
Character(1) |
VARCHAR2(1) NOT NULL |
09/10/99 MDS CN#EN800-6.0: Created MG_AUTO_REL_PID flag to be used in completions to determine whether to 1) auto-release, 2) prompt for auto-release or 3) do not auto-release an unreleased PID.
1=Prompt for Auto Release
2=Auto Release
3=No Auto Release
Default Value: 1
|
| 17 |
MG_PID_COMPL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
12/30/99 MDS CN#EN800-6.0: Created MG_PID_COMPL_OPT flag to be used to determine whether a PID completion should be processed as an on-line or deferred transaction.
1=On-line
2=Deferred
Default Value: 1
|
| 18 |
REV_ON_BOM |
Character(1) |
VARCHAR2(1) NOT NULL |
03/28/00 ST Created new field for Comp Revision.
04/26/00 lee - added label id: blank comp revs.
Y/N Table Edit
Default Value: Y
|
| 19 |
EN_DEFAULT_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
03/28/00 ST Created new field for Comp Rev
04/26/00 lee - added label id: dflt comp rev
Y/N Table Edit
Default Value: N
|
| 20 |
MG_MULT_OUTPUT |
Character(1) |
VARCHAR2(1) NOT NULL |
cel 07/19/00
This field is for future use if needed to determine general gui for CPG vs non-CPG.
Y/N Table Edit
Default Value: Y
|
| 21 |
BOM_EXP_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
BOM Explosion By Date
0=By Start Date
1=By End Date
Default Value: 1
|
| 22 |
REV_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Components Align with Revision
Y/N Table Edit
Default Value: Y
|
| 23 |
DISP_PEND_COMP_ISS |
Character(1) |
VARCHAR2(1) NOT NULL |
12/22/03 MDS (CN#MG880) Create new display pending component issue flag.
Y/N Table Edit
Default Value: Y
|
| 24 |
DISP_COMP_ISS_DUE |
Character(1) |
VARCHAR2(1) NOT NULL |
12/22/03 MDS (CN#MG880) Create new display outstanding component issue flag.
Y/N Table Edit
Default Value: N
|
| 25 |
AUTO_SUBMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
01/15/04 PWF New Field to auto submit back ground process
N=No Auto Start Processes
Y=Auto Start Processes
Default Value: N
|
| 26 |
MG_PEGNOTIFY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
WHS - Pegging
Flag determines frequency of Supply/Demand Pegging notifications
A=Notify at Compl and Close
C=Notify at Close
N=No notify at Compl or Close
Default Value: A
|
| 27 |
LOT_BACKFLUSH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Backflush Lot Option
0=Default from BU
1=Manual
2=Earliest Expiration Date
3=Earliest Available Date
Default Value: 1
|
| 28 |
ENABLE_DRILLDOWN |
Character(1) |
VARCHAR2(1) NOT NULL |
06/27/2010 SCM92 MDS: Added flag to enable Production Variance Drilldown capbility. Flag was cloned from drill_down_optn.
N=No Variance Drilldown
Y=Variance Drilldown Enabled
Y/N Table Edit
Default Value: N
|