Tables
Protheus provides a file of tables (SX5) that enables standardization through some codes of information used by the system. To change tables, access Configurator.
The tables used by the system are identified by codes, and relate the data a field may possibly contain.
During update operations of Service Pro Forma Invoice, tables may be accessed by pressing [F3] on the field.
SIGAPFS has the following tables:
Table |
Description |
12 |
State - Stores state acronyms. |
JU |
Types of Time Sheet View - Stores view types of a time sheet group on the other ones. |
Table |
Description |
NR1 |
Invoicing Language |
NR2 |
Description of Professional Category by Language |
NR3 |
Description Item tabled by Language |
NR4 |
Description of Type of Expense by Language |
NR5 |
Description of Type of Activity by Language |
NR6 |
Expense per Professional |
NR7 |
E-mail Servers Conference |
NR8 |
Conference of User Sent from E-mail |
NR9 |
Registration of Invoice Type |
NRA |
Fee Type |
NRB |
Legal Area |
NRC |
Time Sheet Activity Type |
NRD |
Tabled Services |
NRE |
Service Table |
NRF |
Fee Table |
NRG |
Collection Letter Types |
NRH |
Expense Type |
NRI |
Origination Type |
NRJ |
Invoicing Report Types |
NRK |
table type of Tabled Services |
NRL |
Legal Sub-area |
NRM |
Expense Type History |
NRN |
Employee Category |
NRU |
E-mail Sending Conference |
NRV |
E-billing Category |
NRW |
E-billing standard document |
NRX |
E-billing Company |
NRY |
E-billing stage |
NRZ |
E-billing task |
NS0 |
E-billing Activity Task |
NS1 |
E-billing Activity Type (from-to) |
NS2 |
E-billing Category Type (from/To) |
NS3 |
E-billing Expense Type |
NS4 |
E-billing expense type (from-to) |
NS5 |
Value for Service Tables |
NS7 |
Office (Branch Extension) |
NS9 |
Fees by Category |
NSA |
Invoice cancellation reason |
NSB |
Time Sheet Rectification |
NSC |
Pre Collection Status |
NSD |
Exception by Employee |
NSE |
Invoice Numbering Exception |
NSF |
Legal/Network User |
NSG |
Temporality for Dead File |
NSK |
File Cupboard |
NSL |
File Cupboard Cells |
NSM |
File Warehouse |
NSN |
Bins of Cupboard cell |
NSO |
Invoice protocol type |
NSS |
Apportionment between groups |
NT0 |
Invoicing contracts |
NT1 |
Contract Due Dates (fixed) |
NT5 |
Contract Type by Language |
NT7 |
Case Type by Language |
NTH |
Fields Contract of Fee Type |
NTJ |
Non-Collectable Activity |
NTK |
Non-Collectable Expense Types |
NTL |
Time Sheet Groups/Employee |
NTM |
Time Sheet Revisers Groups |
NTN |
Currencies Blocked by Invoice |
NTO |
Time Sheet Exception Groups |
NTP |
Office Location for Customer |
NTQ |
Office E-billing |
NTR |
Invoice Range |
NTS |
Service Value History |
NTT |
Exception History by Employee |
NTU |
Fee History by Category |
NTV |
Table History of Fees |
NTW |
Non-Collectable Action Type |
NTX |
Absence of Professionals |
NTY |
Routine Captions |
NTZ |
Completion Rules |
NU1 |
Service Table History |
NU9 |
Customer Participation |
NUA |
Customer Report Type |
NUB |
Non-Collectable Activities by customer |
NUC |
Non-Collectable Expenses by customer |
NUD |
Customer Participation History |
NUE |
Time Sheet Entry |
NUH |
Customers |
NUI |
Success Portion |
NUJ |
Success Condition – Condition |
NUK |
Subject Participation |
NUO |
Account Rendering Type |
NUR |
Employee Data |
NUS |
Employee History |
NUT |
Case x Contracts Relationship |
NUU |
Case History |
NUW |
Fee Table Exception History – Category |
NUX |
Field Grouping |
NUY |
Grouping Fields |
NV0 |
Exception History of Fee Table - Employee |
NV1 |
fee Table Exception – Category |
NV2 |
Exception of Fee Table – Employees |
NV4 |
Tabled Entry |
NV5 |
Individual Preferences for each Employee |
NVE |
Case Registration |
NVF |
Case Participation History |
NVM |
Cost Center Apportionment History |
NVN |
Invoice Forwarding |
NVP |
Standard Fee Table History |
NVQ |
Period Closing |
NVV |
Additional Invoices |
NVW |
Additional Invoice Cases |
NVX |
Fields Grouping Registration |
NVY |
Expenses |
NVZ |
Invoicing Expense |
NW0 |
Time Sheet invoicing |
NW1 |
Time Sheet involved |
NW2 |
Contracts Junction |
NW3 |
Contracts Junction |
NW4 |
Tabled Entry Invoicing |
NW9 |
Regional Holidays |
NWC |
Invoicing Success |
NWD |
Invoicing Additional Invoice |
NWF |
Advance Control |
NWL |
Success Status |
NWM |
Entry tabled in lot |
NWN |
Cases linked to tabled entry |
NWZ |
WO Summary of expenses |
NX0 |
Pre-invoice |
NX1 |
Pre-invoice cases |
NX2 |
Employee Pre-invoice |
NX3 |
Tables for migrator |
NX4 |
Collection History |
NX5 |
Invoice Generation Line |
NX6 |
Invoice Exchange |
NX7 |
Cases of Invoice Generation Line |
NX8 |
Pre-Invoice Contracts |
NX8 |
Pre-Invoice Contracts |
NX9 |
Temporary Contracts for Pre-Invoice |
NXA |
Invoices |
NXB |
Invoice Contracts |
NXC |
Invoice Cases |
NXD |
Invoice Employees |
NXE |
Invoice expense summary |
NXF |
Quotation |
NXG |
Payers |
NXH |
Protocol |
NXI |
Protocol Invoices |
NXJ |
Protocol Forms |
NXK |
Installment Type |
NXL |
Installment Description by Language |
NXM |
Invoice Documents related |
NXN |
E-billing Tabled Services |
NXO |
E-billing Tabled Services (from/to) |
NXP |
Payers |
NXQ |
Monthly Quotations |
NXR |
Pre-invoice Exchange |
NXV |
WO Reason Registration |
NY1 |
Case Rearranging History |
NYT |
Equitrac – General Config. |
NYU |
Equitrac – Files Config. |
NYV |
Equitrac – Expense Config. |
NYW |
Equitrac – Files |
NYX |
Equitrac – Details Files |
NYY |
Equitrac – Language Descr. Config. |