SF_RUNCNTL_DFLT

(SQL Table)
Index Back

Mfg Run Control Defaults

This is the mfg run control record that stores the output options from the previous run of the process.

  • Parent record: PSOPRDEFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
    4 OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    8=Feed
    9=IB Node

    Default Value: 3

    5 OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process Request output format
    0=Any
    1=(None)
    10=Postscript (*.lis)
    11=Crystal Report (*.rpt)
    12=Rich Text File (*.rtf)
    13=SQR Portable Format (*.spf)
    14=Text Files (*.txt)
    15=Other
    16=Default
    17=XML Format(*.xml)
    18=Data Mover Data File (*.dat)
    19=Crystal Report Explorer(*.rpt)
    2=Acrobat (*.pdf)
    20=XMLP
    21=Atom
    22=Transformation
    23=Printer Command Lang. (*.pcl)
    24=PostScript (*.ps)
    3=Comma delimited (*.csv)
    4=HP Format (*.lis)
    5=HTML Documents (*.htm)
    6=Line Printer Format (*.lis)
    7=Lotus 1-2-3 Files (*.wks)
    8=Microsoft Excel Files (*.xls)
    9=Microsoft Word (*.doc)

    Default Value: 6

    6 SRVRDESTFILE Character(127) VARCHAR2(127) NOT NULL Server File Destination
    7 SRVRDESTPRINTER Character(127) VARCHAR2(127) NOT NULL Server Destination Printer
    8 SPW_PRINT_ATTACH Character(1) VARCHAR2(1) NOT NULL 3/26/98 rlk - Change rftlong to "Print Attachments" to work with run_sfs2003 panel

    Default Value: N

    9 SPW_PRINT_TEXT Character(1) VARCHAR2(1) NOT NULL Shop Paper Work Print Text

    Default Value: N

    10 SPW_PRINT_CFG Character(1) VARCHAR2(1) NOT NULL Print Config Detail
    N=n
    Y=y

    Default Value: N

    11 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.

    Default Value: N

    12 PRINT_BAR_CODE Character(1) VARCHAR2(1) NOT NULL Print Bar Code

    Default Value: N

    13 PRINT_CNTL_FLG Character(1) VARCHAR2(1) NOT NULL Print Bar Coded Control Flags

    Default Value: N