|
![]() |
Property | Value |
Name | SPECIAL_PAYROLL_A |
Schema | dbo |
Row Count | 0 |
Data Size | 0 KB |
Index Size | 0 KB |
Create Date | 11/5/2012 9:58 AM |
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_TIME |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
ADD_USER_ID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
CHECK_TYPE |
varchar(2) |
True |
False |
False |
|||
![]() |
![]() |
HOLD |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
INTERNAL_SEQ |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
ISN_SPECIAL_PAYROLL_A |
int(10, 0) |
False |
False |
False |
|||
![]() |
![]() |
MAINT_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_PGM |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_TIME |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
MAINT_USER_ID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
MISSED_CHECK_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAY_CHECK_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAYROLL_PROCESS_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
PAYROLL_PROCESS_DATE_9C |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_SPECIAL_PAYROLL_A |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[SPECIAL_PAYROLL_A] Script Date: 03/09/2017 16:45:55 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[SPECIAL_PAYROLL_A]( [ISN_SPECIAL_PAYROLL_A] [int] NOT NULL, [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HOLD] [int] NULL, [PAY_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CHECK_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [INTERNAL_SEQ] [int] NULL, [MISSED_CHECK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAYROLL_PROCESS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PAYROLL_PROCESS_DATE_9C] [int] NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Powered by BI Documenter |