VAT_DFTL_KEY_VW

(SQL View)
 Index Back

VAT Default Keys View


SELECT A.VAT_DRIVER , A.SEQ_NBR_3 , A.VAT_KEY_ID , A.FIELDNAME , A.PROMPTFIELD , A.FIELDNAME_ALIAS , B.LONGNAME , B.SHORTNAME , C.VAT_PAGEFIELD_TYPE FROM PS_VAT_DRIVER_KEY A , PSDBFLDLABL_VW B , PS_VAT_FIELDS C WHERE B.FIELDNAME = A.FIELDNAME AND C.FIELDNAME = A.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VAT_DRIVER Character(15) VARCHAR2(15) NOT NULL VAT Driver
2 SEQ_NBR_3 Number(3,0) SMALLINT NOT NULL Sequence
3 VAT_KEY_ID Character(18) VARCHAR2(18) NOT NULL Key Field Name
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: VAT_FIELDS

5 PROMPTFIELD Character(18) VARCHAR2(18) NOT NULL Dropdown Prompt Field
6 FIELDNAME_ALIAS Character(30) VARCHAR2(30) NOT NULL Field Name Alias
7 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
8 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
9 VAT_PAGEFIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Page Field Type
4=Edit Box
5=Drop Down List Box
7=Check Box