| # |
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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUMGOP_NONVW
|
| 4 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
Prompt Table:
%EDITTABLE6
|
| 5 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDITTABLE22
|
| 6 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 7 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 8 |
STD_PACK_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Pack Unit of Measure
Prompt Table:
%EDITTABLE18
|
| 9 |
PRODUCTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
|
| 10 |
PACK_QTY_1 |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Packing Quantity
|
| 11 |
UNIT_MEASURE_PACK |
Character(3) |
VARCHAR2(3) NOT NULL |
Packing UOM
|
| 12 |
NO_OF_LABEL |
Number(7,0) |
INTEGER NOT NULL |
Number of Labels
|
| 13 |
NO_OF_LABELS |
Number(7,0) |
INTEGER NOT NULL |
Number of Labels
|
| 14 |
PACK_QTY_2 |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Packing Quantity
|
| 15 |
PACK_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Packing UOM
|
| 16 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table:
CP_CONFIG_VW
|
| 17 |
PRINT_BAR_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Code
Y/N Table Edit
Default Value: N
|
| 18 |
PRINT_EXTRACT_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Extract File
Y/N Table Edit
Default Value: DF_SETUP_INV.EXTRACT_FILE
|
| 19 |
PRINT_CNTL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Coded Control Flags
Y/N Table Edit
Default Value: N
|
| 20 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 21 |
RPT_DEST |
Character(50) |
VARCHAR2(50) NOT NULL |
File Destination
|
| 22 |
FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 23 |
FILE_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
File Prefix
|
| 24 |
FILE_SUFFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
File Suffix
|
| 25 |
FILE_DIRECTORY |
Character(80) |
VARCHAR2(80) NOT NULL |
File Directory
|
| 26 |
RPT_DIRECTORY |
Character(50) |
VARCHAR2(50) NOT NULL |
3/26/98 rlk - Change rftlong to "Process File Directory" to work with panels run_sfs7001, run_sfs7002, and run_sfs7003.
|
| 27 |
INV_LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lot ID
|
| 28 |
REVISION |
Character(4) |
VARCHAR2(4) NOT NULL |
01/27/2000 RML Added "As of" label
|
| 29 |
LABEL_FORMAT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Format ID
Prompt Table:
%EDITTABLE20
|
| 30 |
OVERRIDE_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override File
Y/N Table Edit
|
| 31 |
PROCESS_BEGIN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Begin Process Instance
|
| 32 |
PROCESS_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
End Process Instance
|
| 33 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
Prompt Table:
PROCESS_VW
|
| 34 |
JOBID |
Character(10) |
VARCHAR2(10) NOT NULL |
Job ID
Prompt Table:
MESSAGE_LOG
|
| 35 |
REPORT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Report Identifier
|
| 36 |
REPORT_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Only Mode
Y/N Table Edit
Default Value: N
|
| 37 |
PRDN_AREA_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Area Select Option
A=All Production Areas
R=Range of Production Areas
|
| 38 |
PRDN_AREA_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area
Prompt Table:
SF_PRDN_AREA
|
| 39 |
SEL_PRDN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Production Type
ALL=All
PR=Production
RW=Rework
TD=Teardown
|
| 40 |
SORT_OPT_WIPVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Option
1=Account
2=Item ID
3=Production Area
|
| 41 |
PA_PA_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Area Select Option
A=All Production Areas
N=None
R=Range of Production Areas
Default Value: N
|
| 42 |
PA_PA_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area - From
Prompt Table:
%EDITTABLE
|
| 43 |
PA_PA_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area - To
Prompt Table:
%EDITTABLE
|
| 44 |
PA_ITEM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Select Option
A=All Items
N=None
R=Range of Items
Default Value: N
|
| 45 |
PA_ITEM_FROM |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID - From
Prompt Table:
%EDITTABLE2
|
| 46 |
PA_ITEM_TO |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID - To
Prompt Table:
%EDITTABLE2
|
| 47 |
PID_PID_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Production ID Select Option
A=All Production IDs
N=None
R=Range of Production IDs
Default Value: N
|
| 48 |
PID_PID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Identifier - From
Prompt Table:
%EDITTABLE3
|
| 49 |
PID_PID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Identifier - To
Prompt Table:
%EDITTABLE3
|
| 50 |
PID_PA_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Area Select Option
A=All Production Areas
N=None
R=Range of Production Areas
Default Value: N
|
| 51 |
PID_PA_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area - From
Prompt Table:
%EDITTABLE4
|
| 52 |
PID_PA_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area - To
Prompt Table:
%EDITTABLE4
|
| 53 |
COMPONENT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
CN#SF800-20.0 MACN 03/99 - created it for run_sfs2006
A=All Components
R=Range Components
|
| 54 |
COMPONENT_FROM |
Character(18) |
VARCHAR2(18) NOT NULL |
CN#SF800-20.0 MACN 03/99 - created it for run_sfs2006
Prompt Table:
MG_ITEM_APPR_VW
|
| 55 |
COMPONENT_TO |
Character(18) |
VARCHAR2(18) NOT NULL |
CN#SF800-20.0 MACN 03/99 - created it for run_sfs2006
Prompt Table:
MG_ITEM_APPR_VW
|
| 56 |
PID_ITEM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Selct Option
A=All Items
N=None
R=Range of Items
Default Value: N
|
| 57 |
PID_ITEM_FROM |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID - From
Prompt Table:
%EDITTABLE5
|
| 58 |
PID_ITEM_TO |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID - To
Prompt Table:
%EDITTABLE5
|
| 59 |
ISSUE_METHOD_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Issue Method Option
BOTH=Both Issue and Kit
ISS=Issue
KIT=Kit
Default Value: ISS
|
| 60 |
WIP_AREA_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
WIP Stor Area Select Option
A=All
N=None
R=Range
Default Value: A
|
| 61 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
%EDITTABLE7
|
| 62 |
TO_STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
%EDITTABLE21
|
| 63 |
WIP_LEV1_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
WIP Level 1 Select Option
A=All
N=None
R=Range
Default Value: A
|
| 64 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
%EDITTABLE8
|
| 65 |
TO_STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
%EDITTABLE12
|
| 66 |
WIP_LEV2_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
WIP Level 2 Select Option
A=All
N=None
R=Range
Default Value: A
|
| 67 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
%EDITTABLE9
|
| 68 |
TO_STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
%EDITTABLE13
|
| 69 |
WIP_LEV3_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
WIP Level 3 Select Option
A=All
N=None
R=Range
Default Value: A
|
| 70 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
%EDITTABLE10
|
| 71 |
TO_STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
%EDITTABLE14
|
| 72 |
WIP_LEV4_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
WIP Level 4 Select Option
A=All
N=None
R=Range
Default Value: A
|
| 73 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
%EDITTABLE11
|
| 74 |
TO_STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
%EDITTABLE19
|
| 75 |
SEL_IN_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Close In-Process Productions
Y/N Table Edit
Default Value: N
|
| 76 |
SEL_PEND |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Pending-Cmpl Productions
Y/N Table Edit
Default Value: N
|
| 77 |
SEL_CMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Completed Productions
Y/N Table Edit
Default Value: N
|
| 78 |
SEL_LAB |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Labor-Closed Productions
Y/N Table Edit
Default Value: N
|
| 79 |
SEL_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Acctg-Closed Production
Y/N Table Edit
Default Value: N
|
| 80 |
NEW_IP_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
New Status for In-Process Prdn
A=Clsd/Acctg
C=Complete
L=Clsd/Labor
P=Pend/Cmpl
|
| 81 |
NEW_PEND_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
New Status for Pend-Cmpl Prdn
A=Clsd/Acctg
C=Complete
I=In-Process
L=Clsd/Labor
|
| 82 |
NEW_CMPL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
New Status for Completed Prdn
A=Clsd/Acctg
I=In-Process
L=Clsd/Labor
|
| 83 |
NEW_LAB_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
New Status for Labor-Cls Prdn
A=Clsd/Acctg
C=Complete
|
| 84 |
NEW_ACCT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
New Status for Acctg_Cls Prdn
|
| 85 |
IN_PROC_FR_DT |
Date(10) |
DATE |
Select In-Proc Prdn From Date
|
| 86 |
IN_PROC_TO_DT |
Date(10) |
DATE |
Select In-Proc Prdn To Date
|
| 87 |
PEND_FR_DT |
Date(10) |
DATE |
Select Pend-Cmpl Prdn From Dat
|
| 88 |
PEND_TO_DT |
Date(10) |
DATE |
Select Pend-Cmpl Prdn To Date
|
| 89 |
CMPL_FR_DT |
Date(10) |
DATE |
Select Cmpl Prdn From Date
|
| 90 |
CMPL_TO_DT |
Date(10) |
DATE |
Select Cmpl Prdn To Date
|
| 91 |
LAB_FR_DT |
Date(10) |
DATE |
Labor From Date
|
| 92 |
LAB_TO_DT |
Date(10) |
DATE |
Labor To Date
|
| 93 |
ACCT_FR_DT |
Date(10) |
DATE |
Acctg From Date
|
| 94 |
ACCT_TO_DT |
Date(10) |
DATE |
Acctg To Date
|
| 95 |
CMPL_SHORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Close with Component Shortages
Y/N Table Edit
Default Value: N
|
| 96 |
SCRAP_REMAIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Scrap Assemblies Remain
Y/N Table Edit
Default Value: N
|
| 97 |
CLOSE_REMAIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Close with Assemblies Remain
Y/N Table Edit
Default Value: N
|
| 98 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
REASON_CD
|
| 99 |
SHORT_REP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
06/30/98 cam (CN# SF800-1.0) : Change field long name to be more generic for use in Material Shortage Inquiry too. Also revise translate value long name for 'Both' to be more descriptive.
B=Both Production and Pending
C=Production Shortages
L=Location Shortages
P=Pending Shortages
Default Value: B
|
| 100 |
REP_DATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Date Option
A=All Dates
R=Range
Default Value: A
|
| 101 |
SHORT_FR_DT |
Date(10) |
DATE |
Select Shortage From Date
|
| 102 |
SHORT_TO_DT |
Date(10) |
DATE |
Select Shortage To Date
|
| 103 |
SHRT_REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Material Shortage Report
1=Comp Id
2=Prdn Id
Default Value: 1
|
| 104 |
SUMMARY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary Report
Y/N Table Edit
Default Value: N
|
| 105 |
SURPLUS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Ignore Surplus Quantities
Y/N Table Edit
Default Value: N
|
| 106 |
EFF_REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Efficiency/Utilization Rpt Opt
B=Both Labor and Machine
L=Labor Only
M=Machine Only
Default Value: B
|
| 107 |
EFF_FR_DT |
Date(10) |
DATE |
Efficiency/Util. Rpt From Date
|
| 108 |
EFF_TO_DT |
Date(10) |
DATE |
Efficiency/Util. Rpt To Date
|
| 109 |
PICK_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Id Options
A=All
S=Single
Default Value: A
|
| 110 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
Prompt Table:
%EDITTABLE6
|
| 111 |
PUSH_PULL |
Character(1) |
VARCHAR2(1) NOT NULL |
Locations Selected By
1=System (Push)
2=Picker (Pull)
Default Value: 1
|
| 112 |
REPRINT_PICK_BATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprint Pick Batch
Y/N Table Edit
Default Value: N
|
| 113 |
PICK_PLAN_COMMIT |
Number(6,0) |
INTEGER NOT NULL |
Pick Plan Commit Batch
Default Value: 100
|
| 114 |
MAX_PULL_LINES |
Number(2,0) |
SMALLINT NOT NULL |
Max Suggest/Sub Locations
Default Value: 10
|
| 115 |
PICK_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Picking Report Sort
C=Component Sort
L=Location Sort
P=Production Sort
Default Value: C
|
| 116 |
PICKING_DT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to determine the Date selection criteria used when submitting jobs to the Picking Plan.
01=Date/Time Range
02=Lead Days/Minutes
03=Today/Until
Default Value: DF_SETUP_INV.PICKING_DT_TYPE
|
| 117 |
PICKING_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Picking Lead Days
|
| 118 |
PICKING_DT_FROM |
Date(10) |
DATE |
Picking Selection From Date
|
| 119 |
PICKING_DT_TO |
Date(10) |
DATE |
Picking Selection To Date
|
| 120 |
PICK_SHIFT_FROM |
Number(1,0) |
SMALLINT NOT NULL |
Picking Shift From
|
| 121 |
PICK_SHIFT_TO |
Number(1,0) |
SMALLINT NOT NULL |
Picking Shift To
|
| 122 |
UPDATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
07/15/1998 WHS CN#SF800-2.0 - Added new translate value "R" for Confirm AND Release material
C=Confirm
D=Delete (Unreserve)
N=No Update
R=Confirm/Release
U=Unconfirm
Default Value: C
|
| 123 |
REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Options
N=Update Only - No Report
R=Update and Report
Default Value: N
|
| 124 |
PICKLINE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Line Selection Option
A=All
N=None
R=Range
Default Value: A
|
| 125 |
FR_PICKLST_LINE_NO |
Number(7,0) |
INTEGER NOT NULL |
From Picklist Line Number
Prompt Table:
SF_ISS_LN_VW
|
| 126 |
TO_PICKLST_LINE_NO |
Number(7,0) |
INTEGER NOT NULL |
To Picklist Line Number
Prompt Table:
SF_ISS_LN_VW
|
| 127 |
TOLERANCE_LL |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Tolerance - Lower Limit Amount
|
| 128 |
TOLERANCE_UL |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Tolerance - Upper Limit Amount
|
| 129 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
CM_DISTR_TYPE
|
| 130 |
DIS_DT_FROM |
Date(10) |
DATE |
3/24/98 rlk - Change rftshort to "From Date" to work with run_sfs2002 panel.
|
| 131 |
DIS_DT_TO |
Date(10) |
DATE |
Dispatch List To Date
|
| 132 |
DIS_PRINT_TEXT |
Character(1) |
VARCHAR2(1) NOT NULL |
3/26/98 rlk - Change rftshort to "Print Comments" to work with run_sfs2002 panel.
Y/N Table Edit
|
| 133 |
DIS_PRINT_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
3/25/98 rlk - Change rftlong to "Print Op Time Info" to wrok with run_sfs2002 panel
Y/N Table Edit
|
| 134 |
DIS_PRINT_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
3/26/98 rlk - Changed rftlong to "Print Components" to work with run_sfs2002 panel
Y/N Table Edit
|
| 135 |
DIS_PRINT_SUB |
Character(1) |
VARCHAR2(1) NOT NULL |
3/26/98 rlk - Changed rftlong to "Print Subcontracted Ops" to work with run_sfs2002 panel.
Y/N Table Edit
|
| 136 |
DIS_REPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
05/14/99 SPL CN# SF800-24.0
The DIS_REPORT_TYPE field was created for the enhanced Dispatch List report and inquiry to indicate a report/inquiry by start date (default equivalent to the previous functionality), by due date, or past due.
D=Due Date
P=Past Due
S=Start Date
Default Value: S
|
| 137 |
DIS_WC_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Dispatch List From WorkCenter
Prompt Table:
EN_WORK_CENTER
|
| 138 |
DIS_WC_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
05/14/99 SPL CN# SF800-24.0 Field for enhanced Dispatch List report.
A=All Work Centers
R=Range of Work Centers
Default Value: A
|
| 139 |
DIS_WC_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Dispatch List To WorkCenter
Prompt Table:
EN_WORK_CENTER
|
| 140 |
SPW_DATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Shop Paperwork Date option
A=All Dates
N=No Dates
R=Range of Dates
Default Value: A
|
| 141 |
SPW_DATE_FROM |
Date(10) |
DATE |
Shop Paper Work From date
|
| 142 |
SPW_DATE_TO |
Date(10) |
DATE |
Shop Paper Work to Date
|
| 143 |
SPW_PRINT_TEXT |
Character(1) |
VARCHAR2(1) NOT NULL |
Shop Paper Work Print Text
Y/N Table Edit
|
| 144 |
SPW_PRINT_ATTACH |
Character(1) |
VARCHAR2(1) NOT NULL |
3/26/98 rlk - Change rftlong to "Print Attachments" to work with run_sfs2003 panel
Y/N Table Edit
|
| 145 |
SPW_PRINT_FLAGGED |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Selected production ID's
1=Print Selected Production ID's
2=Print Prdn ID's within Range
3=Reprint Prdn ID's within Range
Default Value: 1
|
| 146 |
SPW_REPORT_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
3/27/98 rlk - Change rftshort to "Sort Option" to work with run_sfs2003 panel
1=Prdn ID
2=Prdn Area
3=Item ID
Default Value: 1
|
| 147 |
SPW_PRINT_CFG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Config Detail
N=n
Y=y
|
| 148 |
PS_DATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Schedule date Opt
A=All
R=Range
Default Value: A
|
| 149 |
PS_DATE_FROM |
Date(10) |
DATE |
Production Schedule From Date
|
| 150 |
PS_DATE_TO |
Date(10) |
DATE |
Production Schedule Date To
|
| 151 |
PS_REPORT_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
3/27/98 rlk - Change rftshort to "Sort Option" to work with run_sfs2004 panel
1=Prdn Area
2=Item ID
3=Start Date
4=Due Date
5=Prdn St Dt
6=Prdn Due Dt
Default Value: 1
|
| 152 |
PS_PRINT_TEXT |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Schedule Print Text
Y/N Table Edit
|
| 153 |
PS_PRINT_FIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
3/24/98 rlk - Change rftshort to "Firm" to work with run_sfs2004 panel
Y/N Table Edit
|
| 154 |
PS_PRINT_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
3/26/98 rlk - Changed rftshort to "Released" to work with run_sfs2004 panel.
Y/N Table Edit
|
| 155 |
PS_PRINT_INPROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
3/24/98 rlk - Change rftshort to "In Process" to work with run_sfs2004 panel
Y/N Table Edit
|
| 156 |
PS_PRINT_PEND_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
3/25/98 rlk - Change rftlong to "Pending Complete" so it works with run_sfs2004 panel
Y/N Table Edit
|
| 157 |
PS_PRINT_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
3/23/98 rlk - Change rftshort to "Complete" to work with RUN_SFS2004 panel
Y/N Table Edit
|
| 158 |
PS_PRINT_CLS_LAB |
Character(1) |
VARCHAR2(1) NOT NULL |
3/23/98 rlk - Change rftshort to "Clsd Labor" to work on RUN_SFS2004
Y/N Table Edit
|
| 159 |
PS_PRINT_CLS_ACTG |
Character(1) |
VARCHAR2(1) NOT NULL |
3/23/98 rlk - Change rftshort to Clsd Acctg so can use in panel RUN_SFS2004.
Y/N Table Edit
|
| 160 |
PS_PRINT_CANCELLED |
Character(1) |
VARCHAR2(1) NOT NULL |
3/23/98 rlk - Changed rftshort to "Canceled" so can use on RUN_SFS2004 panel
Y/N Table Edit
|
| 161 |
RETURN_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Return to Location
D=Default Putaway Location
P=Directed Putaway
S=Specific Location
Default Value: D
|
| 162 |
RUN_PROCESS_BTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Process
|
| 163 |
PS_PRINT_ENTERED |
Character(1) |
VARCHAR2(1) NOT NULL |
3/24/98 rlk - Change rftshort to "Firm" to work with run_sfs2004 panel
Y/N Table Edit
|
| 164 |
SPECIFY_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Type
1=Prdn Start
2=Prdn Due
|
| 165 |
PA_DATE_FROM |
Date(10) |
DATE |
3/23/98 rlk - Changed rftshort to work with sf_prdn_plan_load panel
|
| 166 |
PA_DATE_TO |
Date(10) |
DATE |
Production Due Date To
|
| 167 |
PRDN_TYPE_TEARDOWN |
Character(1) |
VARCHAR2(1) NOT NULL |
Teardown
Y/N Table Edit
Default Value: Y
|
| 168 |
PRDN_TYPE_PRDN |
Character(1) |
VARCHAR2(1) NOT NULL |
Production
Y/N Table Edit
Default Value: Y
|
| 169 |
LOG_UNPICKED_LINES |
Character(1) |
VARCHAR2(1) NOT NULL |
Log Unpicked Lines
Y/N Table Edit
Default Value: Y
|
| 170 |
PRINT_SUBSTITUTES |
Character(1) |
VARCHAR2(1) NOT NULL |
Substitutes
Y/N Table Edit
Default Value: DF_SETUP_INV.PRINT_ITEM_SUBS
|
| 171 |
PAGE_BREAK_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Page Break Option
Y/N Table Edit
Default Value: N
|
| 172 |
PRDN_TYPE_REWORK |
Character(1) |
VARCHAR2(1) NOT NULL |
Rework
Y/N Table Edit
Default Value: Y
|
| 173 |
SF_SORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
CN#SF800-20.0 MACN 03/99 - created it for run_sfs2006
1=Production
2=Item ID
3=Prdn St Dt
4=Prdn Due Dt
|
| 174 |
SEL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Selection
A=All Status
R=Range Stat
|
| 175 |
OUTPUT_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Production Output
Y/N Table Edit
|
| 176 |
DIS_PRINT_ORIGCOMP |
Character(1) |
VARCHAR2(1) NOT NULL |
03/11/99 ST CN# EN800-1.0
Created field for Diaptch List Report and Production Report.
Y/N Table Edit
|
| 177 |
SUB_REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Subcontracted Option
1=Op St Date
2=Prdn Id
3=Prdn Area
4=Item Id
Default Value: 4
|
| 178 |
TOLERANCE_RM |
Number(12,8) |
DECIMAL(11,8) NOT NULL |
04/01/99 CRC CN# EN800-6.0 for co/by product close production panel,add new field for panel sfs1100a
|
| 179 |
RETURN_DFLT_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Putaway Location
Y/N Table Edit
Default Value: Y
|
| 180 |
DIRECT_PTWY_BOX |
Character(1) |
VARCHAR2(1) NOT NULL |
Directed Putaway
Y/N Table Edit
Default Value: N
|
| 181 |
RETURN_SPEC_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Specific Location
Y/N Table Edit
Default Value: N
|
| 182 |
SF_RPL_SOURCE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
WIP Replenishment Source Opt
1=Inventory Location
3=Feeder Line (Prdn Area)
A=All
B=Both
Default Value: B
|
| 183 |
SF_RPL_SRC_INV |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Location
Y/N Table Edit
Default Value: Y
|
| 184 |
SF_RPL_SRC_FDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Feeder Line (Prdn Area)
Y/N Table Edit
Default Value: Y
|
| 185 |
SF_RPL_SRC_VND |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier
Y/N Table Edit
Default Value: Y
|
| 186 |
SF_RPL_METHOD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
WIP Replenishment Method
1=Pull List
2=Pull Ticket
3=Workflow
4=Kanban Cards
A=All
B=Both
Default Value: B
|
| 187 |
SF_RPL_LABEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Create File for Labels
Y/N Table Edit
Default Value: N
|
| 188 |
SF_RPL_PRNT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Print Status Option
B=Both Printed and Unprinted
N=Not Printed
P=Previously Printed
Default Value: N
|
| 189 |
SF_RPL_SORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Replenishment Sort Option
I=Item ID
K=Kanban ID
S=Repl Source
T=Repl Status
V=Supplier ID
W=WIP Location
Default Value: I
|
| 190 |
SF_KANBAN_SEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Kanban ID Select Option
A=All Kanban IDs
R=Range of Kanban IDs
Default Value: A
|
| 191 |
SF_KANBAN_FROM |
Character(15) |
VARCHAR2(15) NOT NULL |
From Kanban ID
Prompt Table:
SF_RPL_KANBN_VW
|
| 192 |
SF_KANBAN_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
To Kanban ID
Prompt Table:
SF_RPL_KANBN_VW
|
| 193 |
SF_VENDOR_SEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Selection Option
A=All Suppliers
R=Range of Suppliers
Default Value: A
|
| 194 |
SF_VENDOR_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID
Prompt Table:
VENDOR_PO_VW
|
| 195 |
SF_VENDOR_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
To Supplier ID
Prompt Table:
VENDOR_PO_VW
|
| 196 |
SF_RPL_AREA_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Repl Stor Area Select Option
A=All Areas
R=Area Range
Default Value: A
|
| 197 |
SF_RPL_STOR_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
SF_RPLLOC_AR_VW
|
| 198 |
SF_RPL_AREA_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
SF_RPLLOC_AR_VW
|
| 199 |
SF_RPL_STOR_LEV1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Level 1
Prompt Table:
SF_RPLLOC_L1_VW
|
| 200 |
SF_RPL_LEV1_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
SF_RPLSTO_T1_VW
|
| 201 |
SF_RPL_STOR_LEV2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Level 2
Prompt Table:
SF_RPLLOC_L2_VW
|
| 202 |
SF_RPL_LEV2_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
SF_RPLSTO_T2_VW
|
| 203 |
SF_RPL_STOR_LEV3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Level 3
Prompt Table:
SF_RPLLOC_L3_VW
|
| 204 |
SF_RPL_LEV3_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
SF_RPLSTO_T3_VW
|
| 205 |
SF_RPL_STOR_LEV4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Level 4
Prompt Table:
SF_RPLLOC_L4_VW
|
| 206 |
SF_RPL_LEV4_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
SF_RPLSTO_T4_VW
|
| 207 |
SF_KANBAN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Kanban ID
Prompt Table:
SF_RPL_KNBN2_VW
|
| 208 |
SF_RPL_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Replenishment Vendor ID
Prompt Table:
VENDOR
Set Control Field: VENDOR_SETID
|
| 209 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 210 |
SF_RPL_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Replinshment Vendor
Prompt Table:
VNDR_LOC_VW1
|
| 211 |
SF_RPL_PRNT_SORTBY |
Character(1) |
VARCHAR2(1) NOT NULL |
Repl. Dispatch Sort By
I=Sort by Item ID
W=Sort by WIP Location
Default Value: W
|
| 212 |
EDI_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
EDX Method
Y/N Table Edit
Default Value: Y
|
| 213 |
EMAIL_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
E-Mail Method
Y/N Table Edit
Default Value: Y
|
| 214 |
FAX_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
FAX Method
Y/N Table Edit
Default Value: Y
|
| 215 |
PHONE_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Phone Method
Y/N Table Edit
Default Value: Y
|
| 216 |
PRINT_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Method
Y/N Table Edit
Default Value: Y
|
| 217 |
TEST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initial Issue # Description
12/07/00 JJM R-JMESER-JM6J2 Added label ID "History"
Y/N Table Edit
Default Value: N
|
| 218 |
PRINT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Copy
Y/N Table Edit
Default Value: N
|
| 219 |
PRT_DUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Duplicate on PO
Y/N Table Edit
Default Value: N
|
| 220 |
NUM_OF_COPIES |
Number(3,0) |
SMALLINT NOT NULL |
Number Of Copies
Default Value: 1
|
| 221 |
COVER_FILE_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Fax Cover Page
Prompt Table:
PO_FAX_COV_VW
|
| 222 |
SF_DISPATCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Dispatched Replenishment Req
Y/N Table Edit
Default Value: N
|
| 223 |
SF_STATUS_OPEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Open
Y/N Table Edit
Default Value: Y
|
| 224 |
REPL_DTTM_FROM |
DateTime(26) |
TIMESTAMP |
Dispatch Date From
|
| 225 |
REPL_DTTM_TO |
DateTime(26) |
TIMESTAMP |
Dispatch Date To
|
| 226 |
URL_STRING |
Character(250) |
VARCHAR2(250) NOT NULL |
URL String
|
| 227 |
COMPLETED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Completed
N=Not Completed
Y=Complete
|
| 228 |
MG_COMPLETE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Option
C=Complete
I=Incomplete
U=Unchanged
Default Value: U
|
| 229 |
PRINT_PEG_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Pegging Detail
Y/N Table Edit
Default Value: N
|
| 230 |
SEL_ISSUE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
11/21/05 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 231 |
SEL_KIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
11/21/05 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 232 |
SEL_REPLEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
11/21/05 EGS: Created
Y/N Table Edit
Default Value: Y
|
| 233 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
Prompt Table:
SF_PID_SUBOP_VW
|
| 234 |
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
Default Value: N
|