PV_TMPL_RULE(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BATCH_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Prevalidation Batch Type
EMIN=eSettlements Invoices |
2 | TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID |
3 | PV_RULE_ID | Character(20) | VARCHAR2(20) NOT NULL |
Rule ID
Prompt Table: PV_RULE |
4 | RULE_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |