ETG is the data table for the Entity Group data.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Entity Group | Text | 8 | 1 | Edit | Yes | Public | ||
EXTKEY | Key of Entity Group | Text | 8 | 1 | Edit | Yes | Public | ||
NAM | Name of Entity Group | Text | 40 | 1 | Edit | Yes | Public | ||
SYSCUR | System Base Currency | Text | 3 | 1 | Edit | Yes | Public | ||
RATBASCUR | Rate Base Currency | Text | 3 | 1 | Edit | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
XRTRATDIR | Direction of Rate Logic | Numeric | 1 | 0 | Edit | Yes | Public | ||
COLOR | Color for charts | Text | 16 | 1 | Edit | Yes | Public | ||
BEGTIM1 | Begin of working 1st day | Numeric | 4 | 2 | Edit | Yes | Public | ||
ENDTIM1 | End of working 1st day | Numeric | 4 | 2 | Edit | Yes | Public | ||
WRKHRS1 | Working hours 1st day | Numeric | 4 | 2 | Edit | Yes | Public | ||
BEGTIM2 | Begin of working 2nd day | Numeric | 4 | 2 | Edit | Yes | Public | ||
BEGTIM3 | Begin of working 3rd day | Numeric | 4 | 2 | Edit | Yes | Public | ||
BEGTIM4 | Begin of working 4th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
BEGTIM5 | Begin of working 5th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
BEGTIM6 | Begin of working 6th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
BEGTIM7 | Begin of working 7th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
ENDTIM2 | End of working 2nd day | Numeric | 4 | 2 | Edit | Yes | Public | ||
ENDTIM3 | End of working 3rd day | Numeric | 4 | 2 | Edit | Yes | Public | ||
ENDTIM4 | End of working 4th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
ENDTIM5 | End of working 5th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
ENDTIM6 | End of working 6th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
ENDTIM7 | End of working 7th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
WRKHRS2 | Working hours 2nd day | Numeric | 4 | 2 | Edit | Yes | Public | ||
WRKHRS3 | Working hours 3rd day | Numeric | 4 | 2 | Edit | Yes | Public | ||
WRKHRS4 | Working hours 4th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
WRKHRS5 | Working hours 5th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
WRKHRS6 | Working hours 6th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
WRKHRS7 | Working hours 7th day | Numeric | 4 | 2 | Edit | Yes | Public | ||
REGCOD | Region Code | Text | 4 | 1 | Edit | Yes | Public | REGTXT | |
FORCUR | Foreign System Currency | Text | 3 | 1 | Edit | Yes | Public | ||
GETFLDNRM | Field holding the normalized search Fields. | Text | 60 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
ETG_EXTKEY | EXTKEY | Unique |
ETG_GETFLDNRM | GETFLDNRM | |
ETG_INR | INR | Unique |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter ETG. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field holds the external key to identify an Entity Group.
This field holds the external key to identify an entity group.
This is the visible name of an Entity Group. This name is used in selection list and on panels to identify an Entity Group.
This is the visible name of an entity group. This name is used in selection lists and on panels used to identify an entity group.
This field contains the system base currency for the entity group.
This field contains the system base currency for the entity group.
This currency defines the base currency for the defined exchange rates.
This field defines the base currency for the defined exchange rates.
This field holds the version counter to keep track of the version history of an ETG entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
The contents controls the calculation method of exchange rates. 1 = Price Notation -1 = Inverse Notation like for EUR If empty the system automatically defaults to -1 for a system with rate base currency GBP or EUR and 1 for all other cases.
1: price notation; -1 inverse as for EUR
Color to be used if entity group is represented in charts.
Typically specified in form rgb(rrr,ggg,bbb) as this allows automatic modification of color to create color gradients.
Color to be used if entity group is represented in charts.
Typically specified in form rgb(rrr,ggg,bbb) as this allows automatic modification of color to create color gradients. This field controls the color in which the entries assigned to the user are displayed in the Dashboard charts.
This field contains the time the work has to beginn on Sunday. The format is hh.mm.
This field contains the time the work has to beginn on Sunday. The format is hh.mm.
This field contains the time the work should end on Sunday. The format is hh.mm.
This field contains the time the work should end on Sunday. The format is hh.mm.
This field contains the time that should be worked on Sunday. The format is hh.mm.
This field contains the time that should be worked on Sunday. The format is hh.mm.
This field contains the time the work has to beginn on Monday. The format is hh.mm.
This field contains the time the work has to beginn on Monday. The format is hh.mm.
This field contains the time the work has to beginn on Tuesday. The format is hh.mm.
This field contains the time the work has to beginn on Tuesday. The format is hh.mm.
This field contains the time the work has to beginn on Wednesday. The format is hh.mm.
This field contains the time the work has to beginn on Wednesday. The format is hh.mm.
This field contains the time the work has to beginn on Thursday. The format is hh.mm.
This field contains the time the work has to beginn on Thursday. The format is hh.mm.
This field contains the time the work has to beginn on Friday. The format is hh.mm.
This field contains the time the work has to beginn on Friday. The format is hh.mm.
This field contains the time the work has to beginn on Saturday. The format is hh.mm.
This field contains the time the work has to beginn on Saturday. The format is hh.mm.
This field contains the time the work should end on Monday. The format is hh.mm.
This field contains the time the work should end on Monday. The format is hh.mm.
This field contains the time the work should end on Tuesday. The format is hh.mm.
This field contains the time the work should end on Tuesday. The format is hh.mm.
This field contains the time the work should end on Wednesday. The format is hh.mm.
This field contains the time the work should end on Wednesday. The format is hh.mm.
This field contains the time the work should end on Thursday. The format is hh.mm.
This field contains the time the work should end on Thursday. The format is hh.mm.
This field contains the time the work should end on Friday. The format is hh.mm.
This field contains the time the work should end on Friday. The format is hh.mm.
This field contains the time the work should end on Saturday. The format is hh.mm.
This field contains the time the work should end on Saturday. The format is hh.mm.
This field contains the time that should be worked on Monday. The format is hh.mm.
This field contains the time that should be worked on Monday. The format is hh.mm.
This field contains the time that should be worked on Tuesday. The format is hh.mm.
This field contains the time that should be worked on Tuesday. The format is hh.mm.
This field contains the time that should be worked on Wednesday. The format is hh.mm.
This field contains the time that should be worked on Wednesday. The format is hh.mm.
This field contains the time that should be worked on Thursday. The format is hh.mm.
This field contains the time that should be worked on Thursday. The format is hh.mm.
This field contains the time that should be worked on Friday. The format is hh.mm.
This field contains the time that should be worked on Friday. The format is hh.mm.
This field contains the time that should be worked on Saturday. The format is hh.mm.
This field contains the time that should be worked on Saturday. The format is hh.mm.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
The region a group of entities belong to. Allows to choose from regions setup in DBIREG
The region a group of entities belong to. Allows to choose from regions setup in DBIREG
This field contains the foreign fee base currency for the entity group. This currency is used as base currency for posting of Fee and Commission of International LCs and Guarantees instead of local currency for domestic contracts.
Base currency for posting/booking fee and commission of Foreign/International LCs and Guarantees (i.e. when the domestic flag is empty)