Following are the control, permanent, and workfile tables that the system uses for processing year-end forms.
This chapter includes the following topics:
The system uses the following control table from the production library when processing year-end forms.
The system uses the following permanent tables from the production library when processing year-end forms.
This table contains pension information for printing T4A forms. The system uses the following logical tables:
F07727LA - Logical by year, company, address number, tax area, and tax ID
F07727LB - Logical by year, address number, company, tax area, and tax ID
F07727LC - Logical by year, social insurance number, company, tax area, and tax ID
This table contains the archived history for T4 data. The system uses the following logical tables:
F07730LA - Logical by version ID and T4 serial number
F07730LB - Logical by year, company, address number, tax area, tax ID, payroll ID, and T4/Relevé amended flag
F07730LD - Logical by year and address number
F07730LE - Logical by payroll ID, T4/Relevé amended flag, year, company, address number, tax area, and tax ID
F07730LF - Logical by payroll ID, T4/Relevé amended flag, and T4 control number
F07730LI - Logical by year, company, tax ID, tax area, address number, payroll ID, and amended flag
This table contains the archived history for Relevé 1 data. The system uses the following logical tables:
F07731LA - Logical by version ID and Relevé 1 serial number
F07731LB - Logical by year, company, address number, tax area, tax ID, payroll ID, and T4/Relevé amended flag
F07731LD - Logical by year and address number
F07731LE - Logical by payroll ID, T4/Relevé amended flag, year, company, address number, tax area, and tax ID
F07731LF - Logical by payroll ID, T4/Relevé amended flag, and T4 serial number
F07731LG - Logical by year, tax ID, company, address number, negative amount flag, secondary print flag, tax type, and tax area
F07731LH - Logical by year, address number, and company
This table contains the archived history for T4A data. The system uses the following logical tables:
F07732LA - Logical by version ID and T4A serial number
F07732LD - Logical by year and address number
F07732LE - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID
F07732LF - Logical by payroll ID, Relevé amended flag, and T4A serial number
This table contains the archived history for Relevé 2 data. The system uses the following logical tables:
F07733LA - Logical by year, address number, T4/Relevé amended flag, tax area, tax ID, and company
F07733LB - Logical by address number, amended flag, tax area, tax ID, and company
F07733LC - Logical by version ID and Relevé 2 serial number
F07733LD - Logical by version ID, amended flag, and Relevé 2 serial number
F07733LE - Logical by year and address number
F07733LG - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID
This table contains the archived history for NR4 data. The system uses the following logical tables:
F07734LA - Logical by year, company, address number, tax area, tax ID, version ID, and amended flag
F07734LB - Logical by address number, tax area, year, tax ID, and company
F07734LC - Logical by address number, version ID, and amended flag
F07734LD - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID
F07734LE - Logical by year and address number
F07734LF - Logical by payroll ID, T4/Relevé amended flag, and NR4 serial number
This table contains adjustment information for T4 data. The system uses the following logical tables:
F07740LA - Logical by version ID, year, company, address number, tax area, and tax ID
F07740LB - Logical by year and address number
This table contains adjustment information for Relevé 1 data. The system uses the following logical tables:
F07741LA - Logical by version ID, year, company, address number, tax area, and tax ID
F07741LB - Logical by year and address number
The system uses the F07742LA logical table, logical by version ID, year, company, address number, tax area, and tax ID to store adjustment information for T4A data.
This table contains adjustment information for Relevé 2 data. The system uses the following logical tables:
F07743LA - Logical by version ID, year, company, address number, tax area, and tax ID
F07743LB - Logical by year, address number, tax area, tax ID, and company
F07743LC - Logical by version ID, year, company, address number, tax area, and tax ID
The system uses the following workfile tables from your T4LIBxxx library when processing year-end forms.
This table contains one record per T4 form. The system uses the following logical tables:
T07730LA - Logical by version ID and T4 serial number
T07730LB - Logical by year, company, address number, tax area, and tax ID
T07730LD - Logical by year and address number
T07730LE - Logical by payroll ID, T4/Relevé amended flag, year, company, address number, and tax ID
T07730LF - Logical by payroll ID, T4/Relevé amended flag, and T4 serial number
T07730LH - Logical by year, address number, tax ID, and province (Québec only)
T07730LI - Logical by year, company, tax ID, tax area, address number, payroll ID, and amended flag
This table contains one record per Relevé 1 form. The system uses the following logical tables:
T07731LA - Logical by version ID and Relevé 1 serial number
T07731LB - Logical by year, company, address number, tax area, tax ID, and amended flag
T07731LD - Logical by year and address number
T07731LE - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID
T07731LF - Logical by payroll ID, T4/Relevé amended flag, and T4A serial number
T07731LG - Logical by year, tax ID, company, address number, negative amount flag, secondary print flag, tax type, and tax area
T07731LH - Logical by year, address number, and company
This table contains one record per T4A form. The system uses the following logical tables:
T07732LA - Logical by version ID and T4A serial number
T07732LB - Logical by year, company, address number, tax area, tax ID, and amended flag
T07732LC - Logical by version ID and T4A serial number
T07732LD - Logical by year and address number
T07732LE - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID
T07732LF - Logical by payroll ID, T4/Relevé amended flag, and T4A serial number
T07732LG - Logical by address number, tax area (work), tax ID, home company, and type of form
This table contains one record per Relevé 2 form. The system uses the following logical tables:
T07733LA - Logical by address number, tax area, year, tax ID, and company
T07733LB - Logical by year, address number, amended flag, tax area, tax ID, and company
T07733LC - Logical by version and Relevé 2 serial number
T07733LD - Logical by version ID, amended flag, and Relevé 2 serial number
T07733LE - Logical by year and address number
T07733LG - Logical by version ID, amended flag, year, company, address number, tax area, and tax ID
This table contains one record per NR4 form. The system uses the following logical tables:
T07734LA - Logical by year, company, address number, tax area, tax ID, version ID, and amended flag
T07734LB - Logical by address number, tax area, year, tax ID, and company
T07734LC - Logical by address number, version, and amended flag
T07734LD - Logical by version, amended flag, year, company, address number, tax area, and tax ID
T07734LE - Logical by year and address number
T07734LF - Logical by T4/Relevé amended flag and NR4 serial number
T07734LG - Logical by version ID and NR4 serial number
The T07740LA, a logical table by version ID, year, company, address number, tax area, and tax ID contains adjustment information for T4 data.
The T07741LA, a logical table by version ID, year, company, address number, tax area, and tax ID contains adjustment information for Relevé 1 data.
The T07742LA, a logical table by version ID, year, company, tax area, and tax ID contains adjustment information for T4A data.
This table contains adjustment information for Relevé 2 data. The system uses the following logical tables:
T07743LA - Logical by version ID, year, company, address number, tax area, and tax ID
T07743LB - Logical by year, address number, tax area, tax ID, and company
T07743LC - Logical by version ID, year, company, address number, tax area, and tax ID
The T07744LA, a logical table by version ID, year, company, address number, tax area, and tax ID contains adjustment information for NR4 data.
This table contains XML file information in sequential format for the XML audit Report.
This table contains XML file information in sequential format for the XML Audit Report.