|
![]() |
Property | Value |
Name | TRVL_TABLE_A |
Schema | dbo |
Row Count | 2 |
Data Size | 8 KB |
Index Size | 24 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_TIME |
varchar(7) |
True |
False |
False |
|||
![]() |
![]() |
ADD_USER_ID |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
CC_COMPANY |
varchar(9) |
True |
False |
False |
|||
![]() |
![]() |
CC_COMPANY_SEQ_NBR |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
DEPARTURE_CITY |
varchar(15) |
True |
False |
False |
|||
![]() |
![]() |
END_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
HOLD |
int(10, 0) |
True |
False |
False |
|||
![]() |
![]() |
ISN_TRVL_TABLE_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 |
|||
![]() |
![]() |
MILE_RATE |
numeric(17, 3) |
True |
False |
False |
|||
![]() |
![]() |
RECEIV_GL_CODE |
varchar(5) |
True |
False |
False |
|||
![]() |
![]() |
RECEIV_QUAL_2 |
varchar(4) |
True |
False |
False |
|||
![]() |
![]() |
RENTAL_CAR_RATE |
numeric(17, 2) |
True |
False |
False |
|||
![]() |
![]() |
RETURN_CITY |
varchar(15) |
True |
False |
False |
|||
![]() |
![]() |
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
![]() |
![]() |
SITE_LOCAL_NUM |
varchar(1) |
True |
False |
False |
|||
![]() |
![]() |
START_DATE |
varchar(8) |
True |
False |
False |
|||
![]() |
![]() |
TOLERANCE |
varchar(2) |
True |
False |
False |
Name | Insert | Update | Delete | Instead |
Name | Clustered | Columns |
False |
ISN_TRVL_TABLE_A |
Name | Columns | Referenced Table | Referenced Columns | Checked |
Name | Text | Checked |
Name | Type |
Name | Type |
Object | Property | Value |
Object | Property | Value |
/****** Object: Table [dbo].[TRVL_TABLE_A] Script Date: 03/09/2017 16:46:34 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[TRVL_TABLE_A]( [ISN_TRVL_TABLE_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, [START_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [END_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RECEIV_GL_CODE] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RECEIV_QUAL_2] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [TOLERANCE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MILE_RATE] [numeric](17, 3) NULL, [RENTAL_CAR_RATE] [numeric](17, 2) NULL, [DEPARTURE_CITY] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RETURN_CITY] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SITE_LOCAL_NUM] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CC_COMPANY] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CC_COMPANY_SEQ_NBR] [int] NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
ADD_DATE | ADD_PGM | ADD_TIME | ADD_USER_ID | CC_COMPANY | CC_COMPANY_SEQ_NBR | DEPARTURE_CITY | END_DATE | HOLD | ISN_TRVL_TABLE_A | MAINT_DATE | MAINT_PGM | MAINT_TIME | MAINT_USER_ID | MILE_RATE | RECEIV_GL_CODE | RECEIV_QUAL_2 | RENTAL_CAR_RATE | RETURN_CITY | RowUpdatedOn | SITE_LOCAL_NUM | START_DATE | TOLERANCE |
19980519 | FIT041N | 1048072 | MCOOPER | LAKE WORTH | 1642585 | 1 | 19980522 | FIT041N | 1642585 | MCOOPER | LAKE WORTH | 2017-02-06T11:33:15.233-05:00 | ||||||||||
20150320 | FIT040N1 | 1552304 | E014684 | 510313900 | 8 | 20180630 | 1518568 | 2 | 20151214 | FIT040N1 | 1518568 | E014684 | 0.445 | 13002 | 40.00 | 2017-02-06T11:33:15.249-05:00 | 20140701 | 04 |
Powered by BI Documenter |