Table RUBRIQUE
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| RUBRIQUE | RUB | Heading | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| RUB0 | COD | No | |
| RUB1 | ROW | No | |
| RUB2 | CAI+ROW | No | |
| RUB3 | CODGRP+COD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMTMAX | Cap | AFR | 60 | TXB | ||||
| AMTNUL | Null amount | M | 4 | 1 | ||||
| AMTPRN | Amount printing | M | 15 | 322 | ||||
| ATTASS | Pôle Emp certificate | ADI | [ADI]CODE=371;ATTASS | Block | ||||
| ATTAT | WI certificate | ADI | [ADI]CODE=390;ATTAT | Block | ||||
| ATTHIL | Sickness certificate | ADI | [ADI]CODE=373;ATTHIL | Block | ||||
| ATTSAL | Pôle Emp certificate | ADI | [ADI]CODE=371;ATTSAL | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| BAS | Basis | AFR | 250 | |||||
| BNSALC | Bonuses and allowances | ADI | [ADI]CODE=372;BNSALC | Block | ||||
| CAI | Fund | M | 15 | 329 | ||||
| CMT | Comments | 3 | A | 80 | ||||
| CNDCAL | Calculation condition | AFR | 250 | |||||
| CNDCUM | Condition | 30 | AFR | 250 | ||||
| COD | Code | RUB | [RUB]RUB0=[RUB]COD | Delete | ||||
| CODACC | Access code | ACS | [ACS]ACS0=[RUB]CODACC | Block | ||||
| CODACT | Activity code | ACV | [ACV]CODACT=[RUB]CODACT | Block | ||||
| CODGRP | Group | ADI | [ADI]CODE=654;CODGRP | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CUM | Total | 30 | CUM | [CUM]CUM0=[RUB]CUM | Block | |||
| CUMAMT | Bracket totals | CUM | [CUM]CUM0=[RUB]CUMAMT | Block | TXB | |||
| CUMBAS | Basic totals | CUM | [CUM]CUM0=[RUB]CUMBAS | Block | ||||
| CUMMAX | Upper limit totals | CUM | [CUM]CUM0=[RUB]CUMMAX | Block | TXB | |||
| CUMNUM | Employee record total | M | 15 | 349 | ||||
| DEC | Calculation accuracy | DCB | 12 | |||||
| DES | Title | DES | ||||||
| DESPRN | Title | AFR | 250 | |||||
| DESSHO | Short title | SHO | ||||||
| EFF1MS | Workforce 1/summary | M | 4 | 1 | ||||
| EFF2MS | Workforce 2 /summary | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| FLGCPT | Accounting tracking | M | 4 | 1 | ||||
| FLGRET | Auth back-pay | M | 4 | 1 | ||||
| ITVAMT | Amt by interval | 15 | AFR | 60 | ||||
| ITVLIM | Lower range Amt/Interval | 15 | A | 10 | ||||
| ITVNBR | No. of intervals | C | 4 | |||||
| LFEAFT | Line break after | M | 4 | 1 | ||||
| LFEBEF | Line break before | M | 4 | 1 | ||||
| NBRACC | No. of accounts | C | 4 | |||||
| NBRCUM | No. of totals | C | 4 | |||||
| NOSUMMS | Excluding TP | M | 4 | 1 | ||||
| OPTCUM | Total option | 30 | M | 15 | 333 | |||
| PRNBAS | Calculation base | ADI | [ADI]CODE=338;PRNBAS | Block | ||||
| PRNFLG | Print flags | 5 | M | 4 | 1 | |||
| PRNGRP | Group | ADI | [ADI]CODE=333;PRNGRP | Block | ||||
| RAT1 | Employee's rate | AFR | 250 | |||||
| RAT2 | Employer's rate | AFR | 250 | |||||
| REG | Adjustment | M | 4 | 1 | ||||
| RGL | Adjustment | RGL | [RGL]RGL0=[RUB]RGL | Block | ||||
| ROW | Sequence | L | 5 | |||||
| RUBHIS | History heading | RUB | [RUB]RUB0=[RUB]RUBHIS | Block | ||||
| RUBTHM | Theme | ADI | [ADI]CODE=391;RUBTHM | Block | ||||
| STCPRN | Full settlement | ADI | [ADI]CODE=339;STCPRN | Block | ||||
| TBLCOD | Grid | GRI | [GRI]GRI0=[RUB]TBLCOD | Block | ||||
| TBLCOL | Column number | C | 2 | |||||
| TBLFRM | Formula | 3 | AFR | 220 | ||||
| TEXVRI | Text variable | 2 | VRA | [VRA]VRA0=[RUB]TEXVRI | Block | |||
| TMPCAL | Intermediate calculation | M | 4 | 1 | ||||
| TYPMAS | Type | ADI | [ADI]CODE=656;TYPMAS | Block | ||||
| TYPRUB | Calculation type | M | 15 | 316 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| VLYEND | Valid to | D | ||||||
| VLYSTR | Valid from | D |