PO_RC_WB_PRCS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WORKBENCH_ID |
Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |
| 3 | SERVERNAME | Character(8) | VARCHAR2(8) NOT NULL | Server Name |
| 4 | RUNCNTLID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | COVER_FILE_NAME | Character(12) | VARCHAR2(12) NOT NULL | Fax Cover Page |
| 6 | OUTDESTTYPE_PO | Character(3) | VARCHAR2(3) NOT NULL |
Output Destination Type
2=FILE 3=PRINTER 6=WEB |
| 7 | OUTDESTFORMAT_PO | Character(3) | VARCHAR2(3) NOT NULL |
Output Destination Format
10=Postscript (*.lis) 13=SQRiBE Portable Format (*.spf) 15=Other (*.lis) 2=Acrobat (*.pdf) 3=Comma Delimited (*.csv) 4=HP Format (*.lis) 5=HTML Documents (*.htm) 6=Line Printer Format (*.lis) |
| 8 | RPT_DEST | Character(50) | VARCHAR2(50) NOT NULL | File Destination |
| 9 | PRINT_TERMS | Character(1) | VARCHAR2(1) NOT NULL |
Print Terms
N=Do not print PO Terms Y=Print PO Terms |
| 10 | PRT_CHGS_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Print Changes Only |
| 11 | TEST_IND | Character(1) | VARCHAR2(1) NOT NULL | Date Initial Issue # Description 12/07/00 JJM R-JMESER-JM6J2 Added label ID "History" |
| 12 | PRINT_IND | Character(1) | VARCHAR2(1) NOT NULL | Print Copy |
| 13 | PRT_DUP | Character(1) | VARCHAR2(1) NOT NULL | Print Duplicate on PO |