| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
RPT_DEST |
Character(50) |
VARCHAR2(50) NOT NULL |
File Destination
|
| 5 |
PROCESS_BEGIN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Begin Process Instance
|
| 6 |
PROCESS_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
End Process Instance
|
| 7 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
Prompt Table:
PROCESS_VW
|
| 8 |
JOBID |
Character(10) |
VARCHAR2(10) NOT NULL |
Job ID
Prompt Table:
MESSAGE_LOG
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUMGOP_NONVW
|
| 10 |
IS_ITEM_SELECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Selection
A=All
N=No
R=Range
Y=Yes
Default Value: A
|
| 11 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDITTABLE
|
| 12 |
INV_ITEM_ID_LAST |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDITTABLE
|
| 13 |
BOM_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering
PR=Manufacturing
|
| 14 |
BOM_STATE_TO |
Character(2) |
VARCHAR2(2) NOT NULL |
10/11/99 TKI CN#SF800-14.0 Changed short descriptions to be in sync with BOM_STATE
EN=Engineering
PR=Manufacturing
Default Value: PR
|
| 15 |
BOM_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
|
| 16 |
IS_BOM_SELECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
IS_BOM_SELECTED
A=All
R=Range
|
| 17 |
BOM_CODE |
Number(2,0) |
SMALLINT NOT NULL |
CN# EN800-3.0, anna 09/21
added new field to database
|
| 18 |
BOM_ALL_DATE_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
09/28/99 RML Added another label
N=No
Y=Yes
|
| 19 |
COMP_EFF_DATE |
Date(10) |
DATE |
Component Effective Date
Default Value: %date
|
| 20 |
COMP_EFF_DATE_TO |
Date(10) |
DATE |
Component Effective Date
|
| 21 |
REVISION |
Character(4) |
VARCHAR2(4) NOT NULL |
01/27/2000 RML Added "As of" label
Prompt Table:
EN_REV_SRCH
|
| 22 |
REVISION_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Revision
|
| 23 |
EXPL_N_LEVELS |
Number(2,0) |
SMALLINT NOT NULL |
09/28/99 RML Added another label
Default Value: 1
|
| 24 |
PRINT_DETAILS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Details
N=No
Y=Yes
Default Value: N
|
| 25 |
PRINT_COMP_OUTPUTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Top Level Outputs
N=No
Y=YES
|
| 26 |
PRINT_SUBSTITUTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Substitutes
Y/N Table Edit
|
| 27 |
PRINT_ALL_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Options
|
| 28 |
PRINT_OP_SEQUENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Component Op Sequence
N=No
Y=Yes
|
| 29 |
PRINT_REF_DESIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reference Designators
N=No
Y=Yes
|
| 30 |
PRINT_ASSY |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Assembly Data
N=No
Y=Yes
|
| 31 |
PRINT_ASSY_TEXT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/16/99 TKI CN#SF800-14.0 Changed labels to Assembly Header and Assy Header since this now covers both the TEXT256 field as well as the description fields
N=No
Y=Yes
|
| 32 |
PRINT_ASSY_DOCS |
Character(1) |
VARCHAR2(1) NOT NULL |
Assembly Documents
N=No
Y=Yes
|
| 33 |
PRINT_ASSY_ATTCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Assembly Attachments
N=No
Y=Yes
|
| 34 |
PRINT_NON_OWNED |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Non Owned
N=No
Y=Yes
|
| 35 |
PRINT_COMPONENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Components Data
N=No
Y=Yes
|
| 36 |
PRINT_COMP_TEXT |
Character(1) |
VARCHAR2(1) NOT NULL |
Component Text
N=No
Y=Yes
|
| 37 |
PRINT_COMP_DIM |
Character(1) |
VARCHAR2(1) NOT NULL |
Component Dimensions
N=No
Y=Yes
|
| 38 |
PRINT_COMP_DOCS |
Character(1) |
VARCHAR2(1) NOT NULL |
Component Documents
N=No
Y=Yes
|
| 39 |
PRINT_COMP_ATTCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Component Attachments
N=No
Y=Yes
|
| 40 |
PRINT_LL_OUTPUTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Lower Level Outputs
Y/N Table Edit
Default Value: N
|
| 41 |
CE_COST_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Type
Prompt Table:
CE_TYPE
|
| 42 |
COST_VERSION |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table:
%EDITTABLE3
|
| 43 |
BOM_COST_AS_BATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost as Batch
Y/N Table Edit
Default Value: N
|
| 44 |
COMP_SUB_WHUSD_FL1 |
Character(2) |
VARCHAR2(2) NOT NULL |
03/30/99 ST - Added new field to search for components or substitutes in BOMs. (used in Comp/Sub Where Used Report)
01=Components
02=Substitutes
03=Outputs
|
| 45 |
CREW_CODE_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
Prompt Table:
EN_CREW
|
| 46 |
CREW_CODE_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
04/20/2000 SPL Changed short name to "TO" for iClient simplification.
Prompt Table:
EN_CREW
|
| 47 |
CREW_RANGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
A=All Crews
N=No Crews
R=Crew Range
Default Value: A
|
| 48 |
MACHINE_CODE_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
Prompt Table:
EN_MACHINE
|
| 49 |
MACHINE_CODE_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
04/20/2000 SPL Changed short name to "TO" for iClient simplification.
Prompt Table:
EN_MACHINE
|
| 50 |
MACHINE_RANGE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
A=All Mach.
N=No Machine
R=Range
Default Value: A
|
| 51 |
RES_PRINT_PRODUCTN |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 52 |
RES_PRINT_ROUTINGS |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 53 |
RES_PRINT_TASKS |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 54 |
RES_PRINT_USE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
A=Print All Usages
N=Print No Resource Usages
S=Print Selected Usages:
Default Value: A
|
| 55 |
RES_PRINT_WORK_CNT |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
Y/N Table Edit
Default Value: N
|
| 56 |
SEL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Selection
A=All Status
R=Range Stat
Default Value: A
|
| 57 |
TOOL_CODE_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
Prompt Table:
EN_TOOL
|
| 58 |
TOOL_CODE_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
04/20/2000 SPL Changed short name to "TO" for iClient simplification.
Prompt Table:
EN_TOOL
|
| 59 |
TOOL_RANGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
A=All Tools
N=No Tools
R=Tool Range
Default Value: A
|
| 60 |
RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
Routing Code
|