OPR_DEF_TBL_OM3(SQL Table) |
Index Back |
---|---|
Operator Dflts - OM (RMAThis table holds the operator defaults to be used during Quotation entry. Users may identify the default Business Unit and auto-numbering sequence for quotations by operator. |
# | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_OM_NONVW |
3 | BEG_SEQ | Character(3) | VARCHAR2(3) NOT NULL |
Beginning Sequence
Prompt Table: RMA_AN_VW |
4 | SERVERNAME | Character(8) | VARCHAR2(8) NOT NULL |
Server Name
Prompt Table: SERVERDEFN |
5 | 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: 2 |
6 | OUTPUTDEST | Character(127) | VARCHAR2(127) NOT NULL | Output Destination |
7 | 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: 14 |