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