PRC_ORD_TMPL_IDPRC_PRI_SEQ_NOPrompt Table: PRC_ORD_FLDLIST
ASC=Ascending
DESC=Descending
Default Value: ASC
PRC_ORD_TMPL_PR(SQL Table) |
Index Back |
|---|---|
Processing Order Templ PrioriProcessing Order Template Field's Priority |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRC_ORD_TMPL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Processsing Order Template ID |
| 2 | PRC_PRI_SEQ_NO |
Number(3,0) | SMALLINT NOT NULL | Priority Sequence Number |
| 3 | PRC_ORD_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Processing Order Template Field Priority |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PRC_ORD_FLDLIST |
| 5 | PRC_ORD_SRTORD | Character(4) | VARCHAR2(4) NOT NULL |
Processing Order Template Field's Sort Order
ASC=Ascending DESC=Descending Default Value: ASC |