FIELDNAME4=Edit Box
5=Drop Down List Box
7=Check Box
C=Calculation
D=Driver Default
K=Driver Key
O=Determinant
C=Control
H=Handling
N=None
S=Services
VAT_FIELDS(SQL Table) |
Index Back |
|---|---|
VAT Fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | VAT_PAGEFIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Page Field Type
4=Edit Box 5=Drop Down List Box 7=Check Box |
| 3 | VAT_FIELD_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
VAT Field Category
C=Calculation D=Driver Default K=Driver Key O=Determinant |
| 4 | VAT_DEFAULT_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Defaulting Usage
C=Control H=Handling N=None S=Services |
| 5 | VAT_DEFAULT_VALUE | Character(10) | VARCHAR2(10) NOT NULL | VAT Default Value |