Stores a flat representation of the giving hierarchy.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
DESIGNATIONLEVEL1ID
|
uniqueidentifier
|
false
|
|
The first level of this tree node.
|
|
DESIGNATIONLEVEL2ID
|
uniqueidentifier
|
true
|
|
The second level of this tree node.
|
|
DESIGNATIONLEVEL3ID
|
uniqueidentifier
|
true
|
|
The third level of this tree node.
|
|
DESIGNATIONLEVEL4ID
|
uniqueidentifier
|
true
|
|
The fourth level of this tree node.
|
|
DESIGNATIONLEVEL5ID
|
uniqueidentifier
|
true
|
|
The fifth level of this tree node.
|
|
DESIGNATIONREPORT1CODEID
|
uniqueidentifier
|
true
|
|
Code table for first arbitrary designation report code.
|
|
DESIGNATIONREPORT2CODEID
|
uniqueidentifier
|
true
|
|
Code table for second arbitrary designation report code.
|
|
GLDEPARTMENTID
|
uniqueidentifier
|
true
|
|
The GL Department for this designation.
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
VSECATEGORYID
|
uniqueidentifier
|
true
|
|
The VSE category associated with this designation
|
|
DESIGNATIONUSECODEID
|
uniqueidentifier
|
true
|
|
Code table for the designation use code.
|
|
VSESUBCATEGORYID
|
uniqueidentifier
|
true
|
|
The VSE subcategory associated with this designation.
|
|
DESIGNATIONLEVELTYPEHIERARCHYITEMID
|
uniqueidentifier
|
true
|
|
The designation level type hierarchy item this designation is based on.
|
|
BASECURRENCYID
|
uniqueidentifier
|
true
|
|
The base currency associated with this designation.
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
PROJECTCODE
|
nvarchar(100)
|
false
|
|
GL project code
|
|
ISACTIVE
|
bit
|
false
|
|
Indicates whether or not the designation is active.
|
|
USERID
|
nvarchar(512)
|
false
|
|
The lookup ID used for searching for this designation.
|
|
VANITYNAME
|
nvarchar(512)
|
false
|
|
User entered field for a friendly name.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
ACCOUNTNUMBER
|
nvarchar(100)
|
false
|
|
GL account number
|
|
STARTDATE
|
datetime
|
true
|
|
Start date associated with this designation
|
|
ENDDATE
|
datetime
|
true
|
|
End date associated with this designation
|
|
ISREVENUEDESIGNATION
|
bit
|
false
|
|
Indicates if this designation is accepting revenue.
|
|
SYSTEMGENERATED
|
bit
|
false
|
|
|
|
NAME
|
nvarchar(512)
|
false
|
|
|
Indexes
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
|
IX_DESIGNATION_BASECURRENCYID
|
|
False
|
False
|
False
|
|
IX_DESIGNATION_DATEADDED
|
|
False
|
False
|
True
|
|
IX_DESIGNATION_DATECHANGED
|
|
False
|
False
|
False
|
|
IX_DESIGNATION_DESIGNATIONLEVEL2ID
|
|
False
|
False
|
False
|
|
IX_DESIGNATION_DESIGNATIONLEVEL3ID
|
|
False
|
False
|
False
|
|
IX_DESIGNATION_DESIGNATIONLEVEL4ID
|
|
False
|
False
|
False
|
|
IX_DESIGNATION_DESIGNATIONLEVEL5ID
|
|
False
|
False
|
False
|
|
IX_DESIGNATION_DESIGNATIONREPORT1CODEID
|
|
False
|
False
|
False
|
|
IX_DESIGNATION_DESIGNATIONREPORT2CODEID
|
|
False
|
False
|
False
|
|
IX_DESIGNATION_GLDEPARTMENTID
|
|
False
|
False
|
False
|
|
IX_DESIGNATION_ID
|
|
False
|
False
|
False
|
|
PK_DESIGNATION
|
|
True
|
True
|
False
|
|
UC_DESIGNATION_USERID
|
|
True
|
False
|
False
|
|
UIX_DESIGNATION_DESIGNATIONLEVEL1ID_DESIGNATIONLEVEL2ID_DESIGNATIONLEVEL3ID_DESIGNATIONLEVEL4ID_DESIGNATIONLEVEL5ID
|
DESIGNATIONLEVEL1ID
DESIGNATIONLEVEL2ID
DESIGNATIONLEVEL3ID
DESIGNATIONLEVEL4ID
DESIGNATIONLEVEL5ID
|
True
|
False
|
False
|
