PROCESS_INSTANCEC=Control
H=Handling
N=None
S=Services
LC_VATDRV_AET(SQL Table) |
Index Back |
|---|---|
LC_VATDRIVER State Recordx |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | VAT_CONTEXT_ID | Character(30) | VARCHAR2(30) NOT NULL | VAT Context ID |
| 5 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 6 | VAT_DEFAULT_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Defaulting Usage
C=Control H=Handling N=None S=Services |
| 7 | VAT_DRIVER | Character(15) | VARCHAR2(15) NOT NULL | VAT Driver |
| 8 | SEARCH_SEQ | Number(4,0) | SMALLINT NOT NULL | Search Sequence |
| 9 | VATDRIVER_ORDER | Character(4) | VARCHAR2(4) NOT NULL | Defines if the order by direction is Ascending ("ASC") or Descending ("DESC") |