PL_GEN_TMPL_REQ(SQL Table) |
Index Back |
|---|---|
PL Generate Templates Request10/18/01 EGS (CN#PL900-1): Added |
| # | 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 | BU_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
08/16/01 EGS (CN#PL880-1.0): Added
Prompt Table: PL_GROUP_IN_VW |
| 4 | PRODUCTION_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Production Options
Y/N Table Edit Default Value: Y |
| 5 | PURCHASE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Options
Y/N Table Edit Default Value: Y |
| 6 | TRANS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Options
Y/N Table Edit Default Value: Y |
| 7 | INV_ITEM_LIST_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Item List Option
A=All Items C=Category F=Item Family G=Item Group R=Range of Items S=Single Item Default Value: A |
| 8 | FROM_ITEMID | Character(18) | VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
Prompt Table: MASTER_ITEM_TBL |
| 9 | TO_ITEMID | Character(18) | VARCHAR2(18) NOT NULL |
To Item ID
Prompt Table: MASTER_ITEM_TBL |
| 10 | ONLY_NEW_ITEMS | Character(1) | VARCHAR2(1) NOT NULL |
Only New Items
Y/N Table Edit Default Value: N |
| 11 | DATE_ADDED | Date(10) | DATE | Date Added |