| ACCOUNTNUMBER |
nvarchar(100) |
|
Default = '' |
Account Number |
| ACCOUNTDESCRIPTION |
nvarchar(400) |
|
Default = '' |
Account Description |
| 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. |
| ACTIVE |
bit |
|
Default = 1 |
|
| ACCOUNTSTRING |
nvarchar(100) |
|
Default = '' |
An indexed version of the account string used for searching. |
| ACCOUNTCODEID |
uniqueidentifier (Computed) |
yes |
dbo.UFN_LEDGERACCOUNT_GETACCOUNTCODEID(ID) |
|
| ACCOUNTALIAS |
nvarchar(100) |
|
Default = '' |
Account Alias |
| SEG1VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(1),[PDACCOUNTSYSTEMID])) |
1st Segment Value |
| SEG2VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(2),[PDACCOUNTSYSTEMID])) |
2nd Segment Value |
| SEG3VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(3),[PDACCOUNTSYSTEMID])) |
3rd Segment Value |
| SEG4VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(4),[PDACCOUNTSYSTEMID])) |
4th Segment Value |
| SEG5VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(5),[PDACCOUNTSYSTEMID])) |
5th Segment Value |
| SEG6VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(6),[PDACCOUNTSYSTEMID])) |
6th Segment Value |
| SEG7VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(7),[PDACCOUNTSYSTEMID])) |
7th Segment Value |
| SEG8VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(8),[PDACCOUNTSYSTEMID])) |
8th Segment Value |
| SEG9VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(9),[PDACCOUNTSYSTEMID])) |
9th Segment Value |
| SEG10VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(10),[PDACCOUNTSYSTEMID])) |
10th Segment Value |
| SEG11VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(11),[PDACCOUNTSYSTEMID])) |
11th Segment Value |
| SEG12VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(12),[PDACCOUNTSYSTEMID])) |
12th Segment Value |
| SEG13VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(13),[PDACCOUNTSYSTEMID])) |
13th Segment Value |
| SEG14VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(14),[PDACCOUNTSYSTEMID])) |
14th Segment Value |
| SEG15VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(15),[PDACCOUNTSYSTEMID])) |
15th Segment Value |
| SEG16VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(16),[PDACCOUNTSYSTEMID])) |
16th Segment Value |
| SEG17VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(17),[PDACCOUNTSYSTEMID])) |
17th Segment Value |
| SEG18VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(18),[PDACCOUNTSYSTEMID])) |
18th Segment Value |
| SEG19VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(19),[PDACCOUNTSYSTEMID])) |
19th Segment Value |
| SEG20VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(20),[PDACCOUNTSYSTEMID])) |
20th Segment Value |
| SEG21VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(21),[PDACCOUNTSYSTEMID])) |
21th Segment Value |
| SEG22VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(22),[PDACCOUNTSYSTEMID])) |
22th Segment Value |
| SEG23VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(23),[PDACCOUNTSYSTEMID])) |
23th Segment Value |
| SEG24VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(24),[PDACCOUNTSYSTEMID])) |
24th Segment Value |
| SEG25VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(25),[PDACCOUNTSYSTEMID])) |
25th Segment Value |
| SEG26VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(26),[PDACCOUNTSYSTEMID])) |
26th Segment Value |
| SEG27VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(27),[PDACCOUNTSYSTEMID])) |
27th Segment Value |
| SEG28VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(28),[PDACCOUNTSYSTEMID])) |
28th Segment Value |
| SEG29VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(29),[PDACCOUNTSYSTEMID])) |
29th Segment Value |
| SEG30VALUE |
varchar(100) (Computed) |
yes |
([dbo].[UFN_GLACCOUNT_SEGMENTVALUES_3]([ACCOUNTNUMBER],(30),[PDACCOUNTSYSTEMID])) |
30th Segment Value |
| HASHVALUE |
int |
|
Default = 0 |
|
| MD5HASHVALUE |
uniqueidentifier |
yes |
|
|