| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /FLDQ/AD_QU_INDX | QU2 Index Table | 1 | RECORD_ID | Parameter ID for Editing object | nvarchar | 20 | 0 | | |
2 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 1 | RECORD_ID | Parameter ID for Editing object | nvarchar | 20 | 0 | | |
3 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 1 | RECORD_ID | Parameter ID for Editing object | nvarchar | 20 | 0 | | |
4 | /SYCLO/PSH01 | Syclo Push Register | 5 | RECORD_ID | Record Id | int | 10 | 0 | | |
5 | /SYCLO/PSH10 | Push framework: subscription queue | 3 | RECORD_ID | Record Number | nvarchar | 10 | 0 | | |
6 | /SYCLO/SYSLOG001 | System statistics - Middleware integration | 3 | RECORD_ID | Record no. | nvarchar | 10 | 0 | | |
7 | /SYCLO/WB001 | DevTool: Mobile Screen Definition | 7 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
8 | /SYCLO/WB001F | DevTool: Mobile Screen layout | 12 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
9 | /SYCLO/WB001V | DevTool: Screen field value table | 10 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
10 | /SYCLO/WB002 | DevTool: object | 7 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
11 | /SYCLO/WB002A | DevTool: Object attributes | 9 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
12 | /SYCLO/WB003 | DevTool: Mobile Screen Set | 8 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
13 | /SYCLO/WB004 | DevTool: Action definition | 9 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
14 | /SYCLO/WB005 | DevTool: client data table | 8 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
15 | /SYCLO/WB005R | DevTool: Data table entries | 8 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
16 | /SYCLO/WB006 | DevTool: Transaction definition header | 7 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
17 | /SYCLO/WB006A | DevTool: Client transaction attributes | 10 | RECORD_ID | DevTool: readable identifier | int | 10 | 0 | | |
18 | /XFT/EPA_B0001 | Checklists | 2 | RECORD_ID | Record ID | nvarchar | 32 | 0 | | |
19 | /XFT/EPA_TBARCO | Open barcodes | 5 | RECORD_ID | Record ID | nvarchar | 32 | 0 | | |
20 | /XFT/EPA_TPROT | Log | 3 | RECORD_ID | Record ID | nvarchar | 32 | 0 | | |
21 | /XFT/SRM_DEMO_02 | Property Extension | 2 | RECORD_ID | Record ID | nvarchar | 32 | 0 | | |
22 | CIAP_D_NF | CIAP Nota Fiscal/Record relationship | 2 | RECORD_ID | CIAP Record Unique ID | varbinary | 16 | 0 | | |
23 | CIAP_D_QUOTA | CIAP record quota | 2 | RECORD_ID | CIAP Record Unique ID | varbinary | 16 | 0 | | |
24 | CIAP_D_SUSP | CIAP Records that were manually suspended | 2 | RECORD_ID | CIAP Record Unique ID | varbinary | 16 | 0 | | |
25 | CNVC_CCE_USG_RES | Customizing Comparison:Result table for usage of customizing | 6 | RECORD_ID | | nvarchar | 10 | 0 | | |
26 | T7BREFD_BENINFO | Beneficiary and income identification | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
27 | T7BREFD_BENONRES | Data of beneficiary non-resident or resident abroad | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
28 | T7BREFD_BRANCH | Place of work | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
29 | T7BREFD_DEPPLAN | Dependent of health care private plan | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
30 | T7BREFD_DETCOM | Detail of competences to which the payment refers | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
31 | T7BREFD_DETDEDUC | Detail of deductions | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
32 | T7BREFD_DNOD1300 | Dependents control of the eSocial framework 1300 - PAY | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
33 | T7BREFD_DTCTRL | Current and previous validity | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
34 | T7BREFD_EEABS | Employee temporary absence | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
35 | T7BREFD_EEADDR | Employee address | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
36 | T7BREFD_EEASO | Occupational health certificate | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
37 | T7BREFD_EEBANK | Employee bank details | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
38 | T7BREFD_EECNTC | Employee contact information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
39 | T7BREFD_EECNTR | Employment information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
40 | T7BREFD_EECOMP | Employee identification additional information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
41 | T7BREFD_EEDEP | Dependents | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
42 | T7BREFD_EEDISA | Challenged employee | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
43 | T7BREFD_EEDOCS | Employee identification documents | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
44 | T7BREFD_EEDWSC | Regular workday information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
45 | T7BREFD_EEEDMP | Dismissal protection end | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
46 | T7BREFD_EEEODS | Union leader source company | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
47 | T7BREFD_EEEWSC | Special workday information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
48 | T7BREFD_EEEXAM | Tests done | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
49 | T7BREFD_EEFACT | Relevant fact statement | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
50 | T7BREFD_EEFOR | Foreign employee | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
51 | T7BREFD_EEFWSC | Workday in fixed shifts information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
52 | T7BREFD_EEGAR | Payments made to alimony beneficiaries | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
53 | T7BREFD_EEIDPY | Worker identification | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
54 | T7BREFD_EEINFO | Employee information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
55 | T7BREFD_EELAWS | Lawsuit of the employee | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
56 | T7BREFD_EELINF | Employee legal information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
57 | T7BREFD_EELVNT | Employee leave notice | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
58 | T7BREFD_EEOINF | Other information of employee | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
59 | T7BREFD_EEORES | Condominium information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
60 | T7BREFD_EEPACT | Performed activity | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
61 | T7BREFD_EERABS | Employee temporary absence return | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
62 | T7BREFD_EEREM | Remuneration information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
63 | T7BREFD_EERISK | Harmful agents | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
64 | T7BREFD_EERSNC | Change to absence reason | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
65 | T7BREFD_EESDMP | Dismissal protection start | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
66 | T7BREFD_EESVNC | Information group of employment relationship succession | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
67 | T7BREFD_EETEMP | Worker on temporary loan | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
68 | T7BREFD_EETERM | Termination | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
69 | T7BREFD_EETRFR | Worker transfer information group | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
70 | T7BREFD_EEVWSC | Relief shift workday information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
71 | T7BREFD_EEWDAY | Contract schedule | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
72 | T7BREFD_EEWERT | Info termination employee with no employment relationship | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
73 | T7BREFD_EEWRKP | Employee place of work | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
74 | T7BREFD_EEWSCH | Workday | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
75 | T7BREFD_ERBKSH | Bank information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
76 | T7BREFD_ERCNTC | Contact of person responsible for information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
77 | T7BREFD_ERCOINFO | Company additional information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
78 | T7BREFD_EREXEM | Additional information - Exempted companies - Exemption data | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
79 | T7BREFD_ERFGTS | Exclusive information for FGTS | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
80 | T7BREFD_ERINFO | Employer identification | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
81 | T7BREFD_EROINF | Other employer information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
82 | T7BREFD_ERSWHO | Software house information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
83 | T7BREFD_EVDEL | Event exclusion | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
84 | T7BREFD_EXMPINC | Exempt/non-taxable income | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
85 | T7BREFD_FINIS | NIS archive information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
86 | T7BREFD_HELPLAN | CNPJ of health plan provider | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
87 | T7BREFD_INFRRA | Additional information - income received cumulatively | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
88 | T7BREFD_ININFO | Trainee exclusive information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
89 | T7BREFD_JOB | Job information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
90 | T7BREFD_LAWCOINF | Additional information of legal decisions | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
91 | T7BREFD_LAWYER | Lawyer identification | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
92 | T7BREFD_LEGALFEE | Detail of lawsuit fees | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
93 | T7BREFD_LEGCOMP | Information regarding legal compensation | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
94 | T7BREFD_NOTPER | Notice | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
95 | T7BREFD_NRESIPAY | Payment to non-resident or resident abroad | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
96 | T7BREFD_NTPRCA | Cancellation of notice period | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
97 | T7BREFD_PAYBPF | Beneficiary natural person - resident in Brazil | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
98 | T7BREFD_PAYBPJ | Framework table control | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
99 | T7BREFD_PYAGRE | Identification of agreement/convention/bargaining | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
100 | T7BREFD_PYCMPL | Payroll additional information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
101 | T7BREFD_PYGAR | Payments made to alimony beneficiaries | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
102 | T7BREFD_PYINFO | Payroll additional information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
103 | T7BREFD_PYPAY | Wage types that form employee remuneration | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
104 | T7BREFD_PYPER | period to which the remuneration differences refer to | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
105 | T7BREFD_PYREM | Employee remuneration information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
106 | T7BREFD_PYREOT | Remuneration other company codes | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
107 | T7BREFD_PYRESC | Information regarding indemnity amounts | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
108 | T7BREFD_PYREVN | Payroll additional information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
109 | T7BREFD_PYTOT | Totaling of worker's remuneration | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
110 | T7BREFD_PYWPL | Establishment identification and workplace | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
111 | T7BREFD_PYWTAM | Wage types that form employee remuneration | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
112 | T7BREFD_TEMPWRK | Infomation regarding temporary worker's remuneration | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
113 | T7BREFD_WRKPLC | Workplace information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
114 | T7BREFD_WRKSCH | Workday information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
115 | T7BREFD_WTLAWS | Processes | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
116 | T7BREFD_WTYPE | Wage type information | 3 | RECORD_ID | Record code | nvarchar | 9 | 0 | | |
TOPBasis Components |
117 | /XFT/INV_Q | Invoice receipt queue: Header | 23 | RECORD_ID | Record ID | nvarchar | 32 | 0 | | |
118 | /XFT/INV_Q_S | Invoice receipt queue: Header | 23 | RECORD_ID | Record ID | nvarchar | 32 | 0 | | |
TOPClinical System |
119 | N2DI_RECORD | Administration Data of Speech Recording | 2 | RECORD_ID | Recording ID | nvarchar | 32 | 0 | | |
120 | N2DI_RECORD_TEXT | Clear Text of Speech Recording | 2 | RECORD_ID | Recording ID | nvarchar | 32 | 0 | | |
TOPContract Accounts Receivable and Payable |
121 | TFKK_EXTR_STR | Short Extracts: Structures | 2 | RECORD_ID | Short Extracts: Record ID | nvarchar | 2 | 0 | | |
TOPEasy Enhancement Workbench |
122 | AXT_TABLE_TMPL | Extensibility Template for new tables | 2 | RECORD_ID | Record ID | varbinary | 16 | 0 | | |
TOPLoans Management |
123 | VDCBR_RES_HT | Header and Totals Records for Data Reported to Credit Bur. | 6 | RECORD_ID | Key for Header Record of Reporting File | nvarchar | 6 | 0 | | |
TOPMaster Data |
124 | BCA_US_HLD2REL | Hold Records which have not been released - Dual Control | 4 | RECORD_ID | Record ID Type for Hold Table | nvarchar | 10 | 0 | | |
125 | BCA_US_HOLD | Hold Amounts Which Affect Available Balance | 4 | RECORD_ID | Record ID Type for Hold Table | nvarchar | 10 | 0 | | |
126 | ISM_PCSADR_LOG | IS-M Postal Change Service: Address Update - Log Table | 4 | RECORD_ID | Record Index | nvarchar | 9 | 0 | | |
TOPSAP Records Management |
127 | SRMRGCONTC | Context Counter: Highest Counter Readings | 3 | RECORD_ID | Record Character Generator: Unique ID | nvarchar | 32 | 0 | | |
TOPWorkforce Management Application |
128 | WFA_AGTEVT_EL | Agent (Scheduled) Event Eligibility | 7 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |
129 | WFA_SCEVT_ORG | Schedule Event - Organization Relationship | 9 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |
130 | WFA_SCEVT_QUL | Schedule Event - Qualifications Relationship | 9 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |
131 | WFA_SCEVT_WA | Work filter on schedule events | 7 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |
132 | WFA_TEAM_EVT | Teams assigned to a scheduled event | 10 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |
TOPWorkforce Management Core |
133 | WFMCAS_AGTEVT_EL | Agent (Scheduled) Event Eligibility | 7 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |
134 | WFMCAS_SCEVT_ORG | Schedule Event - Organization Relationship | 9 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |
135 | WFMCAS_SCEVT_QUL | Schedule Event - Qualifications Relationship | 9 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |
136 | WFMCAS_SCEVT_WA | Work filter on schedule events | 7 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |
137 | WFMCAS_TEAM_EVT | Teams assigned to a scheduled event | 10 | RECORD_ID | WFM GUID | varbinary | 16 | 0 | | |