VAT_DRIVER_DFLT (SQL Table)	Index Back
VAT Driver Default

VAT_DRIVER_DFLT

(SQL Table)

VAT Driver Default

# 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 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: VAT_FIELDS

3 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

4 FIELDNAME_ALIAS Character(30) VARCHAR2(30) NOT NULL Field Name Alias

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

6 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default
Default Value: N

7 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID

8 UPG_DFLT_VALUE Character(50) VARCHAR2(50) NOT NULL holds upgrade-only default value for a VAT_DRIVER/FIELDNAME combination. used, by UPG_VAT_DEF, along with UPG_VAT_DEF.APPLY_UPG_DFLT_FLG.

#	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	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: VAT_FIELDS
3	REQUIRED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Required Flag N=No Y=Yes Y/N Table Edit Default Value: N
4	FIELDNAME_ALIAS	Character(30)	VARCHAR2(30) NOT NULL	Field Name Alias
5	PROMPTFIELD	Character(18)	VARCHAR2(18) NOT NULL	Dropdown Prompt Field
6	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Default Default Value: N
7	PNLFLDID	Number(4,0)	SMALLINT NOT NULL	Page Field ID
8	UPG_DFLT_VALUE	Character(50)	VARCHAR2(50) NOT NULL	holds upgrade-only default value for a VAT_DRIVER/FIELDNAME combination. used, by UPG_VAT_DEF, along with UPG_VAT_DEF.APPLY_UPG_DFLT_FLG.