Tables
Protheus has a tables file which allows it to standardize some information used by the system using codes. To edit tables, the Configurator environment must be accessed.
Tables used by the system are identified by codes and list the possible information a field can contain.
During the update operation, tables can be accessed by pressing [ENTER] and then [F3] on the field associated with it.
The TOTVS Tax Automation module used the following tables:
Table: |
Description |
C01 |
Register Table of Fiscal Document Template |
C02 |
Register Table of Fiscal Document Status |
C03 |
Register Table of Origin of Goods |
C04 |
Register Table of ICMS Calculation Basis Modes |
C048 |
Central Bank / SISCOMEX Table of Countries |
C05 |
Register Table of ICMS/ST Calculation Basis Modes |
C06 |
Register Table of Public Area Types |
C07 |
Register Table of IBGE Cities |
C09 |
State |
C0A |
Register Table of NCM |
C0B |
Register Table of Service Codes |
C0I |
Register of the Classification Group of Electricity Item and/or Communication/Telecommunication |
C0J |
Register Table of Adjustments from Fiscal Documents |
C0K |
Register Table of Classification of the Electricity Item and/or Communication/Telecommunication |
C0L |
Register Table of Consumption Class (Electricity and Gas) |
C0M |
Register Table of Consumption Class |
C0N |
Register Table of Tension Groups |
C0O |
Register Table of Consumption Class (Piped Water) |
C0Q |
Register Table of Vehicles |
C0R |
Collection Document |
C0S |
Register Table of Bill of Lading Types |
C0T |
Register Table of Electronic AIDF |
C0U |
Table of Fiscal Document Purposes |
C0V |
Deferred Credit Class |
C0W |
Register Table of Fiscal Printers |
C0X |
Register Table of Freight Modes |
C0Z |
Table of Possession of Goods |
C10 |
Register Table of Revenue Type |
C11 |
Register Table of Calculation Basis Codes for Credit |
C12 |
Register Table of Succession Event Class Indicator |
C13 |
Table of Indicator of the Number of Depreciation Installments |
C14 |
Register Table of ICMS CST |
C16 |
Register Table of Transportation Type Indicator |
C17 |
Register Table of PIS/COFINS CST |
C18 |
Register Table of ISS CST |
C18 |
Register of Federal Lawsuit Class Indicator |
C19 |
Register of Lawsuit Class |
C1A |
Register of Calculation Adjustments - ICMS |
C1B |
Register of Calculation Adjustments - IPI |
C1C |
Register of Calculation Adjustments PIS/COFINS |
C1D |
Register of PIS/COFINS Adjustments of Contributions or Credits |
C1E |
Establishment Register Complement |
C1G |
Register Table of Referenced Processes |
C1H |
Register Table of Employees |
C1J |
Register of Measurement Units |
C1K |
Register of Measurement Unit Conversion Factors |
C1M |
Register Table of Item Identification - Products/Services |
C1N |
Register of Operation Class |
C1O |
Register Table of Item Identification - Products/Services |
C1P |
Register Table of Cost Center |
C1Q |
Register Table of Withholding Class Indicator |
C1R |
Employee Register Fields |
C1S |
Register Table of Origin Indicator of Miscellaneous Deductions |
C1T |
Register of Cooperative Company Type Indicator |
C1U |
Revenue Class |
C1V |
Financial Institutions (Bank) |
C1W |
Revenue Class Groups |
C1X |
Table of Revenue Class |
C1Y |
Register of Tax Anticipation Codes |
C1Z |
Register Table of Periods Exempt from EFD Contributions |
C20 |
Fiscal Document Cover |
C21 |
Complementary Information on Fiscal Documents |
C22 |
Referenced Processes of Fiscal Documents |
C23 |
Import Operations of Fiscal Documents |
C24 |
Transportation Modals |
C25 |
Referenced Collection Documents |
C26 |
Referenced Fiscal Document |
C27 |
Referenced Tax Receipts |
C28 |
Pick-up and/or Delivery |
C29 |
Invoices |
C2A |
Invoice Due Date |
C2B |
Operations with Fuel |
C2C |
Notes of Fiscal Entries |
C2D |
Adjustments of Fiscal Documents |
C2E |
Complements - template 06, 28 and 29 |
C2F |
Taxes - Fiscal Document Cover |
C2G |
Complements - template 21 and 22 |
C2H |
ICMS/ST collected for another state |
C2I |
Canceled Documents - template 02, 13, 14, 15 and 16 |
C2K |
Calculation System of Social Security Contribution over Gross Revenue |
C2L |
Register Table of Assets or Fixed Asset Components |
C2M |
Register Table of Item Type |
C2N |
Register Table of IPI Calculation |
C2Q |
Table of Item Identification Items |
C2R |
Register Table of Account/Account Group Class Code |
C2S |
Register Table of ICMS Calculation |
C2T |
Table of Tax Calculation Adjustments |
C2U |
Table of Additional Data of Calculation Adjustments (Company level) |
C2V |
Table of Additional Data of Calculation Adjustments (Fiscal Documents) |
C2X |
Table of Additional Data of Calculation Adjustments (Statement Values) |
C2Z |
Table of Obligations to Collect (Company level) |
C30 |
Fiscal Document Items |
C31 |
Complement of Medication Specific Item |
C32 |
Complement of Specific Item of Templates 06, 28 and 29 |
C33 |
Complement of Firearms |
C34 |
Complement of New Vehicles |
C35 |
Taxes of Fiscal Document Items |
C36 |
Complement of Fuel Storage |
C37 |
Complement of ICMS Refund |
C38 |
Complement of Specific Item of Templates 21 and 22 |
C39 |
Complement of Specific Item of Template 07 |
C3A |
Complement of Specific Item of Templates 08, 8B, 09, 10, 11, 26 and 27 |
C3B |
Other Documents and Operations which Generate Contributions and Credits Not Associated with Fiscal Documents |
C3C |
Referenced Processes (company level) |
C3D |
Operation Type Indicator (Company level) |
C3E |
Register Table of Codes of ICMS Obligations to Collect |
C3F |
Complement of Specific Item of Templates 08, 8B and 26 |
C3G |
Complement of Specific Item of Template 09 |
C3H |
Complement of Specific Item of Template 10 |
C3I |
Fiscal Documents of Item of Templates 08, 8B, 09, 10, 11, 26 and 27 |
C3P |
Register of the Hired Freight Class Indicator |
C3Q |
Complementary Information |
C3S |
Tax Codes |
C3V |
Table of the Beverage Incidence Table Indicator |
C3X |
Register Table of the Group corresponding to the trademark of the beverage |
C3Z |
Table of the Type of Goods and Service Item |
C40 |
Real Estate Activity Operations - Sold Real Estate Unit |
C41 |
Real Estate Unit Operation Type |
C42 |
Real Estate Unit Type |
C46 |
PIS/Cofins Paymt Details |
C47 |
PIS/COFINS Contribution Adjustment |
C48 |
Pis/Cofins Comp.Calc.Base |
C49 |
Details CB PIS/Cofins Calc |
C4A |
PIS/Cofins Contribution Adj |
C4B |
Credits derived from incorporation, merge or split-up events |
C4C |
PIS/COFINS Deferm.Add.Info. |
C4D |
Deferred Credit Types |
C4E |
Register Table of PISPASEP or COFINS Contribution deferred in previous periods - Values payable in the period |
C4F |
Export Info Document Comp |
C4G |
Items of Export Document |
C4I |
Assets Incorporated into Fixed Assets - Operations of Credit Generation based on Depreciation and Amortization fees |
C4J |
Assets Incorporated into Fixed Assets - Referenced Processes |
C4K |
Id Assets/Grp Inc Fix. Assets. |
C4L |
Asset Incorp. Fixed Assets |
C4M |
Ref. Proc. - Assets Incorp. Fix. Assets |
C4N |
Fuel Daily Movements |
C4O |
Fuel daily mov per tank |
C4P |
Sales Volume |
C4Q |
Other Deductions |
C4R |
ICMS Cred. on Perman. Asset |
C4S |
Transact.Asset.Comp.Fix.Asset |
C4T |
Other Credits -CIAP |
C4U |
Fisc.Doc.Ind. - CIAP |
C4V |
Fisc.Doc.Ind.It. - CIAP |
C4X |
Added Value Information |
C4Z |
Type of Credit Use - ICMS |
C50 |
Tax Credit Control – ICMS |
C51 |
Tax Credit Use – ICMS. |
C52 |
Tp.Trans.Asset/Comp. |
C53 |
Real Estate Enterprising |
C54 |
Referenced Processes II |
C55 |
Pumps |
C56 |
Pump seals |
C57 |
Pump nozzles |
C58 |
Detail. Exempt income |
C59 |
Total Cred/Deb Card Transact |
C5A |
Inventory |
C5B |
Inventory Items |
C5C |
Inventory Complementary Information |
C5D |
File Inventory Reason |
C5E |
Payroll PIS/PASEP |
C5F |
Cred. Ctrl. PIS/PASEP/COFINS |
C5G |
Ap. Tax Doc. Extemp. Cred. Calc. |
C5H |
Airway Transport Credit Statement |
C5I |
Withheld Contribution |
C5J |
Extemp. Contr. PIS/PASEP/COFINS |
C5K |
Detail. CExtemp. PIS/PASEP/COFINS |
C5L |
Cred. Stat. DescCExtemp. PPC |
C5M |
Social Security Contribution on Gross Revenue |
C5N |
Contribution Complement – Contribution Calculation Details |
C5O |
Referenced Processes - CP |
C5P |
File Details of Contribution Calculation |
C5Q |
SAT CF-e equipment ID |
C5R |
SAT-CF-e Tax Receipts |
C5S |
SAT CF-e Tax Receipt Items |
C5T |
SAT CF-e Receipt Item taxes |
C5U |
SAT-CF-e Referenced Processes |
C5V |
Table Code of Activities, Products and Services Subject to Social Security Contribution on Gross Revenue |
C5X |
Social Security Contribution Fields |
C5Z |
Control of Withheld Amounts PIS/PASEP/COFINS |
C6A |
Fiscal Docs with AIDF |
C6B |
Fiscal Docs. Cancel/Unusable |
C6C |
Authorized Devices |
C6D |
Totalizer Codes Red. Z |
C6E |
Adjustments of Social Security Contribution on Gross Revenue |
C6F |
Register of Fiscal Printer Equipment |
C6G |
Z Reduction |
C6H |
Z Reduction Tot. Inst. |
C6I |
Doc. Tax Receipt Issued by Fiscal Printer |
C6J |
Doc. Items Tax Receipt Issued by Fiscal Printer |
C6K |
Tp. Doc. Items Tax Issue Fiscal Printer |
C6L |
Referenced Process |
C6M |
Deemed Credit on Opening Inventory |
C6N |
Plant Daily Prod. Ctrl. |
C6P |
Fiscal.Doc.It.Extemp.Crdt.Ap. |
C6Q |
Document Extra Fields Collection |
C6R |
Revenues for Document Collection |
C6S |
Revenues Detail for Collection Document |
C6T |
Collection Document Type Code |
C6U |
Code Collection Document Product |
C6V |
Tax Documents |
C6Y |
Stock balance per Product |
C6Z |
Summary per CFOP |
C70 |
Referenced Process |
C71 |
Fiscal Voucher per Fiscal Printer |
C72 |
Referenced Process |
C7A |
Summary per State |
C73 |
Service Rendering Consolidation |
C74 |
Service Rendering Consolidation Complement PIS |
C75 |
Service Rendering Consolidation Complement |
C76 |
Referenced Process |
C77 |
Service Provision Consolidation - Communication (Code 21) and Telecommunication Service Invoices |
C78 |
Detailed Document Records |
C79 |
Information Records of Other States, in relation to non-measured services of satellite subscription TV |
C7B |
Complement of Entered Documents (Codes 13, 14, 15, and 16) |
C7F |
Complement of Entered Documents |
C7G |
Detailed Record of Daily Transaction |
C7H |
Monthly Summary of Fiscal Printer Items per Establishment (Codes 02 and 2D) |
C7I |
Daily Consolidation - Docs 06, 28, and 29 |
C7J |
Outflow Documents - PIS/PASEP |
C7K |
Outflow Documents - COFINS |
C7L |
Referenced Process |
C7M |
Daily Consolidation of Issued Electricity Invoice/Bill (Code 06) |
C7N |
Detailed Document Records (Code 06) |
C7O |
Information Record of ST by State (Codes 06) |
C7P |
SAT-CF-E Equipment Identification |
C7Q |
Daily Document Summary |
C7R |
SAT-CF-E Documents Issued |
C7S |
Referenced Process |
C7T |
CF-E Daily Summary (Code 59) |
C7U |
Detailed of Consolidated Transportation Tickets |
C7V |
Canc. of Consolidated Transportation Tickets |
C7X |
Add. Info of Consolidated Transportation Tickets |
C7Z |
Detailed Record of Consolidated Roadway/Waterway/Railway Tickets, Ticket and Luggage Invoice and Summary of Daily Transactions |
C82 |
Legal Entity Operations |
C83 |
Legal Entity Operations - Tax Rate |
C84 |
Consolidation of Legal Entity |
C85 |
Revenue Composition |
C86 |
Neighborhood Types Register |
C87 |
Workers Category |
C88 |
Degree of Exposure to Harmful Agents |
C89 |
Payroll Items Class |
C8A |
FPAS Codes and Rates - 3rd Party |
C8C |
Classification of Soc. Sec. Paymt Withh. Serv. |
C94 |
Specific Occupational Hazards |
C8D |
Tax Classification |
C8E |
e-Social File Types |
C8F |
Allocation Types |
C8G |
Codes vs. Acronyms vs. Tax Rates from Other Entities and Funds |
C8H |
Payment Types |
C8I |
Affected Body Part |
C8J |
Work Accident Causing Agent |
C8K |
Causing Agent - Work Illness Gen. Situation |
C8L |
Work Accident Generating Situation |
C8M |
Description of Injury Class |
C8N |
Leave Reasons |
C8O |
Termination Reasons |
C06 |
Types of Public Area |
C8P |
Legal Nature of Taxpayer |
C8T |
Payroll Item Tax Incidence for Social Security |
C8U |
Code of Payroll Item Tax Incidence for IRRF |
C8Z |
Brazilian Code of Occupations |
C8S |
Decision Indicative |
C1E |
S-1000 - Employer Information |
C8R |
S-1010 - Payroll Items Table |
C99 |
S-1020 - Department Allotments Table |
C8V |
S-1010 - Positions Table |
C8X |
S-1010 - Functions Table |
C90 |
S-1050 - Work Time and Shifts Table |
C92 |
S-1060 - Establishments and Construction Sites Table |
C93 |
S-1070 - Administrative and Legal Processes Table |
C8W |
S-1080 - Dock Worker Operators Table |
C9V |
S-2100 - Initial Vehicle Registration, S-2200 - Worker Admission S-2600 – Worker Without Employment Relationship - Start |
C9Y |
S-2100 - Initial Relationship Registration |
CRA |
S-2220 - Worker Registration Data Changes |
CRB |
S-2240 - Labor Contract Changes |
CMH |
Education Level |
CMI |
Dependant Type |
CM0 |
S-2260 - Work-Related Accident Communication |
CM7 |
Medical Practitioners |
C8B |
S-2280 - Occupation Health Certificate |
CM4 |
S-2300 - Vacation Notice |
CM6 |
S-2320 - Temporary Leave |
CRE |
S-2325 - Leave Reason Changes |
CRF |
S-2330 - Return from Temporary Leave |
CMM |
International Classification of Diseases |
CM5 |
S-2340 - Stability - Start |
CRH |
S-2345 - Stability - End |
CM9 |
S-2360 - Differentiated Work Conditions - Start |
CRI |
S-2365 - Differentiated Work Conditions - End |
CM8 |
S-2400 - Prior Notice |
CRG |
S-2405 - Prior Notice Cancellation |
CMG |
S-2100 - Initial Relationship Register |
CRK |
S-2420 - Activities Performed by Workers |
CMC |
S-2440 - Relevant Fact Notification |
CRC |
S-2620 – Worker Without Employment Relationship - Contract Change |
CRD |
S-2680 - Worker Without Employment Relationship - Termination |
CMD |
S-2800 - Termination |
CMF |
S-2820 - Reinstatement by Court Decision |
CMJ |
S-2900 - Deletion of Event Unduly Sent |
C8Y |
S-1100 - Opening |
C91 |
S-1200 - Worker Compensation |
CMN |
S-1310 - Services Received (Assignment of Labor), S-1320 - Services Rendered (Assignment of Labor), S-1330 - Services Received From Labor Cooperative, S-1340 - Services Rendered by Labor Cooperative |
CMR |
S-1350 - Acquisition of Production |
C8Q |
S-1360 – Production Commercialization |
C9B |
S-1370 - funds received or transferred to soccer clubs |
CMX |
S-1400 - Bases, Withholding, Deductions and Payments |
CU0 |
Integration Monitor - Inconsistencies |
CU1 |
Integration Monitor - Filters |
C9A |
District Courts |
C9F |
Person Responsible for the Information |
CR9 |
S-1000 - Employer Information |
CML |
Reason for Severance of Director With No Employment Relationship |
CRN |
S-1200 - Worker Compensation |
CRO |
S-1310 - Services Received (Assignment of Labor) |
CRP |
S-2280 - Occupation Health Certificate |
CRQ |
Employee Contract Time |
CRS |
S-1800 - Sports Event |
CRU |
Employee Contract Time - Contract Changes |
CRV |
S-1390 - Revenue from Concomitant Activities |
CRR |
S-1380 - Revenue Received from IT, ICT and Call Center Services |
CMW |
S-1300 - Various Payments - Lawyers * Auxiliary Register |
CMY |
S-1300 - Various Payments - Exemption Types * Auxiliary Register |
CRW |
S-1300 - Various Payments |
CRX |
S-1300 - Various Payments 0.1 - Benef. Paymt Natural Person Res. Brazil |
CRY |
S-1300 - Various Payments 0.1.1 - Deducted Details |
CRZ |
S-1300 - Various Payments 0.1.2 - Competence Details |
CU2 |
S-1300 - Various Payments 0.1.3 - Exempt Incomes |
CU3 |
S-1300 - Various Payments 0.1.4 - Incomes of Accrued Receipts |
CU4 |
S-1300 - Various Payments 0.1.4 - Lawyer Incomes of Accrued Receipts |
CU5 |
S-1300 - Various Payments 0.1.5 - Lawsuit |
CU6 |
S-1300 - Various Payments 0.1.4 - Lawsuit Lawyer |
CU7 |
S-1300 - Various Payments 0.2 - Benef. Paymt Legal Entity Domic. Brazil |
CU8 |
S-1300 - Various Payments 0.3 - Paymt Non-resident Brazil |
CU9 |
S-1300 - Various Payments 0.1.4 - Health Insurance Dependants |
CUA |
S-2280 - Chemical Agent |
C9Z |
S-1300 - Various Payments - Beneficiaries * Auxiliary Register |
CUB |
S-1300 - Various Payments - Paying Source Relation * Auxiliary Register |
CUC |
S-1300 - Various Payments - Income Types * Auxiliary Register |
CUD |
S-1300 - Various Payments - Benef. Taxation Method/IRRF * Auxiliary Register |
CUE |
S-1300 - Various Payments - Income Groups * Auxiliary Register |
CUF |
S-1300 - Various Payments - Income Codes * Auxiliary Register |
CUG |
S-1800 - Sports Event |
CUM |
S-2280 - Analysis Code |
CUN |
S-2360 - Distinct Work Condition Type |
CUO |
S-1399 - Periodic Events - Closing |
CUP |
Initial Register of Relationship |
CUQ |
S-2280 - Biological Monit. Res. |
CUR |
S-2340 - Stability Reason |
CUS |
S-1200 - Worker Compensation |
CUU |
TSV Information |
CUV |
Expense Types |
CAI |
Acquisition of Sugarcane |
CAJ |
Vehicle Type |
CAK |
Vehicle Kind |
CAL |
Vehicle Color |
CAM |
Processes Identification |
CAN |
Establishment Detail |
CAO |
Received Rec. Process Info. |
CAX |
Vehicle Fuel Type |
CEL |
Automaker Vehicle Color |
CFJ |
S-1060 - 3rd Party Lawsuit |
CFN |
S-1330 - Info on Adm/Legal Processes |
CFO |
S-1330 - Establishment Detail |
CFP |
S-1300 - Health Insurance Companies |
CW7 |
S-1370 - Forwarded Rec. Process Info. |
CH1 |
Sugarcane Daily Supply |
CH2 |
Deductions - Rates and Payments (Sugarcane) |
CEJ |
Accountant Register |