VAT_CDAPPLIC_VW(SQL View) |
Index Back |
|---|---|
VAT Default Types View |
| SELECT DISTINCT A.VAT_DRIVER , A.FIELDNAME , C.REQUIRED_FLAG , A.PROMPTFIELD , A.FIELDNAME_ALIAS , C.VAT_DEFAULT_TYPE , D.VAT_DEFAULT_VALUE FROM PS_VAT_DRIVER_DFLT A , PS_VAT_APPLI_TREAT B , PS_VAT_DRIVER_TYPE C , PS_VAT_FIELDS D WHERE D.VAT_DEFAULT_USAGE = 'H' AND B.FIELDNAME = A.FIELDNAME AND C.VAT_DRIVER = A.VAT_DRIVER AND C.VAT_DEFAULT_TYPE = B.VAT_DEFAULT_TYPE AND D.FIELDNAME = A.FIELDNAME AND A.FIELDNAME = 'TAX_CD_VAT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VAT_DRIVER | Character(15) | VARCHAR2(15) NOT NULL | VAT Driver |
| 2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
N=No Y=Yes |
| 4 | PROMPTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Dropdown Prompt Field |
| 5 | FIELDNAME_ALIAS | Character(30) | VARCHAR2(30) NOT NULL | Field Name Alias |
| 6 | VAT_DEFAULT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | VAT Default Type |
| 7 | VAT_DEFAULT_VALUE | Character(10) | VARCHAR2(10) NOT NULL | VAT Default Value |