UPG_VAT_DEF_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | KEY1_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 1 Field Name |
| 4 | KEY2_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 2 Field Name |
| 5 | KEY3_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 3 Field Name |
| 6 | KEY4_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 4 Field Name |
| 7 | KEY5_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 5 Field Name |
| 8 | EFFDT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
EffDt Flag
N=Effective Date Value X=No Effective Date Y=Effective Date in Field |
| 9 | EFF_STATUS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status Flag
N=No Effective Status Y=Effective Status Exists |
| 10 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 11 | FIELDNAME_ALIAS | Character(30) | VARCHAR2(30) NOT NULL | Field Name Alias |
| 12 | VAT_DRIVER | Character(15) | VARCHAR2(15) NOT NULL | VAT Driver |
| 13 | FIELDNAME_CUR | Character(18) | VARCHAR2(18) NOT NULL | Currency Field |
| 14 | FIELDNAME_RT_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Rate Type |
| 15 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 16 | VAT_DEFAULT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | VAT Default Type |
| 17 | QS_SELECT_DTYP | Character(4) | VARCHAR2(4) NOT NULL |
Specify datatype for SQL/Select verifictaion
CHAR=Character NUM=Numeric |
| 18 | FIELDNAME0 | Character(18) | VARCHAR2(18) NOT NULL | Name of Field |
| 19 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Fieldname 2 |
| 20 | EFFDT_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Effective Date |
| 21 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 22 | FIELDNAME_CUREFFDT | Character(18) | VARCHAR2(18) NOT NULL | Currency Effective Date |
| 23 | UPG_RELEASE | Character(4) | VARCHAR2(4) NOT NULL |
Upgrade Application Release
751=7.51 Release 752=7.52 Release 753=7.53 Release 801=8 SP1 Release 803=8 SP3 Release 840=8.40 Release 841=8.40 SP1 880=8.80 Release |
| 24 | PUBLIC_SECTOR | Character(1) | VARCHAR2(1) NOT NULL | Public Sector |
| 25 | APPLY_UPG_DFLT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Specifies if UPG_VAT_DEF upgrade script should
set VAT_DEFAULTS.VAT_VALUE_CHAR = VAT_DRIVER_DFLT.UPG_DFLT_VALUE
if necessary.
I=Insert default N=None U=Update to default, if empty |
| 26 | 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. |
| 27 | COMMENTS_254 | Character(254) | VARCHAR2(254) NOT NULL | EDI Comments |