|
![]() |
Property | Value |
Name | GL_HIERARCHY |
Schema | dbo |
Row Count | 5479 |
Data Size | 568 KB |
Index Size | 128 KB |
Create Date | 10/24/2012 4:04 PM |
Description |
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
![]() |
![]() |
ADD_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ADD_PGM |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ADD_TERMINAL_ID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ADD_TIME |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
ADD_USER_ID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ALIAS_END_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ALIAS_ID |
varchar(16) |
True |
False |
False |
|||
![]() |
![]() |
ALIAS_START_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
ALIAS_TRANS_1 |
varchar(3) |
True |
False |
False |
|||
![]() |
![]() |
ALIAS_TRANS_2 |
varchar(3) |
True |
False |
False |
|||
![]() |
![]() |
ALIAS_TRANS_3 |
varchar(3) |
True |
False |
False |
|||
![]() |
![]() |
ALIAS_TRANS_4 |
varchar(3) |
True |
False |
False |
|||
![]() |
![]() |
ALIAS_TRANS_5 |
varchar(3) |
True |
False |
False |
|||
![]() |
![]() |
APPROVAL_CONDITION |
varchar(3) |
True |
False |
False |
|||
![]() |
![]() |
APPROVAL_VALUE |
numeric(17, 2) |
True |
False |
False |
|||
![]() |
![]() |
DETAIL_PRINT_OPTION |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
GROUP_NAME |
varchar(4) |
True |
False |
False |
|||
![]() |
![]() |
HOLD |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
IDENTIFIER_A |
varchar(16) |
True |
False |
False |
|||
![]() |
![]() |
IDENTIFIER_B |
varchar(16) |
True |
False |
False |
|||
![]() |
![]() |
ISN_GL_HIERARCHY |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
MAINT_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_PGM |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_TERMINAL_ID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_TIME |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_USER_ID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
NAME |
varchar(30) |
True |
False |
False |
|||
![]() |
![]() |
NEXT_IDENT |
varchar(16) |
True |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
![]() |
![]() |
SUMMARY_PRINT_OPTION |
varchar(1) |
True |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_GL_HIERARCHY |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[GL_HIERARCHY] Script Date: 03/09/2017 16:45:35 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[GL_HIERARCHY]( [ISN_GL_HIERARCHY] [int] NOT NULL, [GROUP_NAME] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [IDENTIFIER_A] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_CONDITION] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [APPROVAL_VALUE] [numeric](17, 2) NULL, [NEXT_IDENT] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DETAIL_PRINT_OPTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SUMMARY_PRINT_OPTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [IDENTIFIER_B] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ALIAS_ID] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ALIAS_START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ALIAS_END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ALIAS_TRANS_1] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ALIAS_TRANS_2] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ALIAS_TRANS_3] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ALIAS_TRANS_4] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ALIAS_TRANS_5] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HOLD] [int] NULL, [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_TERMINAL_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_TERMINAL_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
ADD_DATE | ADD_PGM | ADD_TERMINAL_ID | ADD_TIME | ADD_USER_ID | ALIAS_END_DATE | ALIAS_ID | ALIAS_START_DATE | ALIAS_TRANS_1 | ALIAS_TRANS_2 | ALIAS_TRANS_3 | ALIAS_TRANS_4 | ALIAS_TRANS_5 | APPROVAL_CONDITION | DETAIL_PRINT_OPTION | GROUP_NAME | HOLD | IDENTIFIER_A | IDENTIFIER_B | ISN_GL_HIERARCHY | MAINT_DATE | MAINT_PGM | MAINT_TERMINAL_ID | MAINT_TIME | MAINT_USER_ID | NAME | NEXT_IDENT | RowUpdatedOn | SUMMARY_PRINT_OPTION |
20000831 | FIG039N2 | 1415321 | BBLACK | GRP2 | 1415321 | 7504006270901090 | 2194 | 75040000 00 | 2017-02-06T11:26:20.005-05:00 | |||||||||||||||||||
20090611 | FIG039N2 | 1547571 | E001353 | GRP2 | 1547571 | 7739006370901090 | 4370 | 77390000 00 | 2017-02-06T11:26:20.177-05:00 | |||||||||||||||||||
19980420 | FIG039N2 | 2142004 | MCOOPER | GRP2 | 2142004 | 7771102670114110 | 800 | 77710000 00 | 2017-02-06T11:26:19.912-05:00 | |||||||||||||||||||
20031211 | FIG039N2 | 1726029 | E001353 | GRP2 | 1726029 | 7798116470103550 | 165 | 77980000 00 | 2017-02-06T11:26:19.865-05:00 | |||||||||||||||||||
19980225 | FIG038N2 | 1845347 | MCOOPER | GRP1 | 1706212 | 1126030026030120 | 1283 | 19990112 | FIG038N2 | 1706212 | MCOOPER | 11260300 00 | 2017-02-06T11:26:19.943-05:00 | |||||||||||||||
20130710 | FIG039N2 | 1126517 | E026994 | GRP2 | 1126517 | 7743101870106220 | 4898 | 77430000 00 | 2017-02-06T11:26:20.208-05:00 | |||||||||||||||||||
20050718 | FIG039N2 | 1624433 | E001353 | GRP2 | 1624433 | 7711211670116220 | 3448 | 77110000 00 | 2017-02-06T11:26:20.099-05:00 | |||||||||||||||||||
20120702 | FIG039N2 | 1305339 | E001353 | GRP2 | 1305339 | 71140000 00 | 2035 | 71000000 00 | 2017-02-06T11:26:20.005-05:00 | |||||||||||||||||||
20020625 | FIG038N2 | 1109139 | BBLACK | GRP1 | 1109139 | 1126030026030695 | 2764 | 11260300 00 | 2017-02-06T11:26:20.036-05:00 | |||||||||||||||||||
20080714 | FIG039N2 | 1229489 | E001353 | GRP2 | 1229489 | 7730001970115110 | 4097 | 77300000 00 | 2017-02-06T11:26:20.161-05:00 |
Powered by BI Documenter |