| DESCRIPTION |
nvarchar(100) |
|
Default = '' |
Account segment description |
| SEQUENCE |
int |
|
Default = 0 |
Order this element appears in account string |
| LENGTH |
tinyint |
|
Default = 2 |
Length of the segment |
| SEPARATORCODE |
tinyint |
|
Default = 1 |
Segment separator |
| SEGMENTTYPE |
tinyint |
|
Default = 0 |
Numeric representation of Segment type (Accountcode 1, fund 2, Regular 3, Composite 4 |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| ISPROJECTSEGMENT |
bit |
|
Default = 0 |
This segment represents a project in FE7. |
| ELEMENTDEFINITIONCODE |
tinyint |
|
Default = 3 |
Accounting Element type this structure element is associated with. Should match Accounting Element. |
| ELEMENTDEFINITION |
nvarchar(12) (Computed) |
yes |
CASE [ELEMENTDEFINITIONCODE] WHEN 1 THEN N'Account code' WHEN 2 THEN N'Fund' WHEN 3 THEN N'User-defined' WHEN 4 THEN N'Endowment' WHEN 5 THEN N'Program' WHEN 6 THEN N'Event' WHEN 7 THEN N'Project' WHEN 8 THEN N'Grant' WHEN 9 THEN N'Membership' END |
Provides a translation for the 'ELEMENTDEFINITIONCODE' field. |
| SEGMENTSEQUENCE |
tinyint |
|
Default = 0 |
sequence just for account segments |
| SEGMENTCOLUMN |
tinyint |
|
Default = 0 |
Which column is the segment stored in for the account and transaction tables. |
| ELEMENTTYPECODE |
tinyint |
|
Default = 1 |
Account segment or transaction characteristic |
| ELEMENTTYPE |
nvarchar(26) (Computed) |
yes |
CASE [ELEMENTTYPECODE] WHEN 1 THEN N'Account segment' WHEN 2 THEN N'Transaction characteristic' END |
Provides a translation for the 'ELEMENTTYPECODE' field. |
| CLOSINGELEMENT |
bit |
|
Default = 0 |
Is this a closing accounting element? |
| DEFAULTDESCRIPTIONSEQUENCE |
tinyint |
|
Default = 0 |
Sequence for default account description |
| DEFAULTDESCRIPTIONLENGTH |
tinyint |
|
Default = 0 |
Length for the default account description |
| ISBASICGL |
bit |
|
Default = 1 |
Indicates whether account segment is for BasicGL or Financials. |
| SEPARATOR |
nvarchar(14) (Computed) |
yes |
CASE [SEPARATORCODE] WHEN 1 THEN N'- Hyphen' WHEN 2 THEN N', Comma' WHEN 3 THEN N'/ Slash' WHEN 4 THEN N'; Semicolon' WHEN 5 THEN N'. Period' WHEN 6 THEN N<No separator> END |
Provides a translation for the 'SEPARATORCODE' field. |
| ISCONSTANTVALUE |
bit |
|
Default = 0 |
Flag for constant valued segments. |