CTXPRC_PARAMS(SQL Table) |
Index Back |
|---|---|
CAN TAX PROCESS PARAMETERSSingle record table for processing parameters required by Canadian year end SQR reports. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BALANCE_ID | Character(2) | VARCHAR2(2) NOT NULL |
Balance ID
Default Value: INSTALLATION.BAL_ID_FOR_CAL_YR Prompt Table: BALANCE_ID_TBL |
| 2 | BALANCE_YEAR | Number(4,0) | SMALLINT NOT NULL |
Balances for Year
Prompt Table: BAL_YR_NO_CO_VW |
| 3 | BALANCE_QTR | Number(3,0) | SMALLINT NOT NULL |
Balances for Quarter
Default Value: 1 Prompt Table: BALQTR_NO_CO_V |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 5 | FORM_ID | Character(6) | VARCHAR2(6) NOT NULL | Form Identification |
| 6 | EMPLOYEES_PER_PAGE | Number(1,0) | SMALLINT NOT NULL | Employees Per Page |
| 7 | TRANSMITTER_ID | Character(8) | VARCHAR2(8) NOT NULL | T4 Transmitter No |
| 8 | TRANSM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
T4 Transmitter Type
1=Filing For Yourself (Company) 2=Filing on Behalf of Others 3=Filing Using Software Package 4=Software Vendor Default Value: 3 |
| 9 | PACKAGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
T4 Data Type
1=Original File 2=Test File 3=Replacement File Default Value: 1 |
| 10 | COMM_LANGUAGE | Character(3) | VARCHAR2(3) NOT NULL |
Language of Communication
E=English F=French Default Value: E |
| 11 | RLV_TECH_RES_NAME | Character(30) | VARCHAR2(30) NOT NULL | RL Technical Resource Name |
| 12 | RLV_TECH_RES_PHONE | Number(7,0) | INTEGER NOT NULL | RL Technical Res Phone |
| 13 | RLV_TECH_RES_ACODE | Number(3,0) | SMALLINT NOT NULL | RL Technical Res Area Code |
| 14 | RLV_TECH_RES_EXT | Number(7,0) | INTEGER NOT NULL | RL Technical Res Extension |
| 15 | RLV_TECH_RES_LANG | Character(1) | VARCHAR2(1) NOT NULL |
RL Technical Res Language
A=English F=French |
| 16 | RLV_ACCT_RES_NAME | Character(30) | VARCHAR2(30) NOT NULL | RL Accting Resource Name |
| 17 | RLV_ACCT_RES_PHONE | Number(7,0) | INTEGER NOT NULL | RL Accting Res Phone |
| 18 | RLV_ACCT_RES_ACODE | Number(3,0) | SMALLINT NOT NULL | RL Accting Res Area Code |
| 19 | RLV_ACCT_RES_EXT | Number(7,0) | INTEGER NOT NULL | RL Accting Res Extension |
| 20 | RLV_ACCT_RES_LANG | Character(1) | VARCHAR2(1) NOT NULL |
RL Accting Res Language
A=English F=French |
| 21 | RLV_PACKAGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
RL Package Type
1=Original File 3=Test File 4=Amended 6=Cancelled Default Value: 1 |
| 22 | RLV_TRANSM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
RL Transmitter Type
1=Filing for Yourself (company) 2=Filing on Behalf of Others 3=Filing for You and Others Default Value: 1 |
| 23 | RLV_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
RL Source of Slips
A=From Ministere du Revenu B=Facsimiles from 3rd Party C=Slips Facsimiles by Transmiter D=Any combination of Above Default Value: A |
| 24 | RLV_COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
RL Transmitter Company
Prompt Table: COMPANY_TBL |
| 25 | RLV_TRANSM_ID | Character(8) | VARCHAR2(8) NOT NULL | RL Transmitter No |
| 26 | ACCT_CONTACT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Accting Contact Name |
| 27 | ACCT_CONTACT_ACODE | Number(3,0) | SMALLINT NOT NULL | Accting Contact Area Code |
| 28 | ACCT_CONTACT_PHONE | Number(7,0) | INTEGER NOT NULL | Accting Contact Phone |
| 29 | ACCT_CONTACT_EXT | Number(5,0) | INTEGER NOT NULL | Accting Contact Ext'n |
| 30 | TECH_CONTACT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Technical Contact Name |
| 31 | TECH_CONTACT_ACODE | Number(3,0) | SMALLINT NOT NULL | Technical Contact Area Code |
| 32 | TECH_CONTACT_PHONE | Number(7,0) | INTEGER NOT NULL | Technical Contact Phone |
| 33 | TECH_CONTACT_EXT | Number(7,0) | INTEGER NOT NULL | Technical Contact Ext'n |
| 34 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 35 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 36 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 37 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 38 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 39 | PROVINCE | Character(6) | VARCHAR2(6) NOT NULL |
Province
Prompt Table: STATE_TBL |
| 40 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 41 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: CAN Prompt Table: COUNTRY_TBL |
| 42 | SUBMISSION_REF_ID | Number(8,0) | INTEGER NOT NULL | Used by T4/T4A Magnetic Media SQR (CTX910XM) to determine type of slips to be processed |
| 43 | ALT_EMAIL_ADDRESS | Character(60) | VARCHAR2(60) NOT NULL | Alternate Email |