VAT_DFLT_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | VAT_CONTEXT_ID | Character(30) | VARCHAR2(30) NOT NULL | VAT Context ID |
| 3 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Error Flag |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 6 | COMMIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag Reservations for Commits |
| 7 | COMMIT_BATCH | Number(6,0) | INTEGER NOT NULL | Commit Batch |
| 8 | RECNAME_TMP | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name |
| 9 | VAT_CNTXT_TYPE_OVR | Character(1) | VARCHAR2(1) NOT NULL |
VAT Context Type Override
2=Batch - BV2 Codeline B=Batch - Row by Row Processing |