TAX_PROV_INFO(SQL Table) |
Index Back |
|---|---|
Tax Provider Installation Info |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXCEPTIONS_AVP | Character(1) | VARCHAR2(1) NOT NULL |
Use STEP
Y/N Table Edit Default Value: N |
| 2 | TAX_RC_MATCHING | Character(1) | VARCHAR2(1) NOT NULL |
Reason Code Matching
1=Only Exact Reason Code Match 2=Use Default Record Default Value: 2 |
| 3 | TAX_CERT_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Certificate Level
1=Individual Certificate Levels 2=State Level Only Default Value: 2 |
| 4 | EXCEPTIONS_VERTEX | Character(1) | VARCHAR2(1) NOT NULL |
Use TDM
Y/N Table Edit Default Value: N |
| 5 | VER_VERTEX | Character(1) | VARCHAR2(1) NOT NULL |
Version
I=ISAM |
| 6 | SERVER_VERTEX | Character(20) | VARCHAR2(20) NOT NULL | Server Name |
| 7 | USER_VERTEX | Character(10) | VARCHAR2(10) NOT NULL | User Name |
| 8 | PSWD_VERTEX | Character(8) | VARCHAR2(8) NOT NULL | Password |