TAX_PROV_INFO(SQL Table) |
Index Back |
|---|---|
Tax Provider Installation Info |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TAX_APP_TAXWARE | Character(1) | VARCHAR2(1) NOT NULL |
Taxware Tax Application
E=Taxware Enterprise S=Taxware Sales and Use Tax |
| 2 | EXCEPTIONS_AVP | Character(1) | VARCHAR2(1) NOT NULL |
Using STEP
Y/N Table Edit |
| 3 | 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 |
| 4 | TAX_CERT_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Certificate Level
1=Individual Certificate Levels 2=State Level Only Default Value: 2 |
| 5 | TAX_APP_VERTEX | Character(1) | VARCHAR2(1) NOT NULL |
Vertex Tax Application
O=Vertex O Series Q=Vertex Q Series |
| 6 | EXCEPTIONS_VERTEX | Character(1) | VARCHAR2(1) NOT NULL |
Using TDM
Y/N Table Edit |
| 7 | VER_VERTEX | Character(1) | VARCHAR2(1) NOT NULL |
Version
I=ISAM |
| 8 | SERVER_VERTEX | Character(20) | VARCHAR2(20) NOT NULL | Server Name |
| 9 | USER_VERTEX | Character(10) | VARCHAR2(10) NOT NULL | User Name |
| 10 | PSWD_VERTEX | Character(254) | VARCHAR2(254) NOT NULL | 11/04 - Increased to 44 bytes to allow for encryption. Vertex passwords must be 6-16 characters. |
| 11 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
Prompt Table: PSMSGNODEDEFN |
| 12 | TAX_DEPLOYMENT | Character(1) | VARCHAR2(1) NOT NULL |
Tax Vendor Deployment Option
1=Web Service 2=Direct Call Default Value: 1 |
| 13 | TAX_CALL_OPT_P | Character(1) | VARCHAR2(1) NOT NULL |
Tax Vendor Call Option for Payables
1=Line Level 2=Doc Level Default Value: 1 |
| 14 | TAX_CALL_OPT_S | Character(1) | VARCHAR2(1) NOT NULL |
Tax Vendor Call Option for Sales
1=Line Level 2=Doc Level Default Value: 1 |
| 15 | MAX_DOC_LINES | Number(3,0) | SMALLINT NOT NULL |
Max Nbr of Lines in a Tax Doc
Default Value: 500 |
| 16 | TAX_EXEMPT_OVR | Character(1) | VARCHAR2(1) NOT NULL |
Tax Exemption Override Allowed
Y/N Table Edit Default Value: Y |
| 17 | TAX_UPGRADE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Tax Vendor Upgrade Status
0=Not Run or Not Successful 1=Successful 9=Upgrade Not Necessary Default Value: 9 |
| 18 | CONNECT_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Connection Method to 3rd Party Tax Software
1=Integration Broker 2=Java Direct XML Post 3=Business Interlink Default Value: 1 |