VAT_CONTROL_VW

(SQL View)
 Index Back

Control Default Fields View


SELECT A.VAT_DRIVER ,' ' , A.PNLFLDID , A.FIELDNAME ,A.REQUIRED_FLAG , A.PROMPTFIELD , A.FIELDNAME_ALIAS , B.VAT_PAGEFIELD_TYPE , B.VAT_DEFAULT_USAGE , B.VAT_DEFAULT_VALUE FROM PS_VAT_DRIVER_DFLT A , PS_VAT_FIELDS B WHERE A.FIELDNAME = B.FIELDNAME AND B.VAT_DEFAULT_USAGE IN ('C','S')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VAT_DRIVER Character(15) VARCHAR2(15) NOT NULL VAT Driver

Prompt Table: VAT_DRIVER

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
3 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: VAT_FIELDS

5 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

6 PROMPTFIELD Character(18) VARCHAR2(18) NOT NULL Dropdown Prompt Field

Y/N Table Edit

7 FIELDNAME_ALIAS Character(30) VARCHAR2(30) NOT NULL Field Name Alias
8 VAT_PAGEFIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Page Field Type
4=Edit Box
5=Drop Down List Box
7=Check Box
9 VAT_DEFAULT_USAGE Character(1) VARCHAR2(1) NOT NULL VAT Defaulting Usage
C=Control
H=Handling
N=None
S=Services
10 VAT_DEFAULT_VALUE Character(10) VARCHAR2(10) NOT NULL VAT Default Value