DWStaging
 dbo.AR_CASH_RECON_A (Table)
Home  Diagrams  Documents  Images  DWStaging  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWStaging   Tables   dbo.AR_CASH_RECON_A
  Properties
Property Value
Name AR_CASH_RECON_A
Schema dbo
Row Count 116316
Data Size 13528 KB
Index Size 2152 KB
Create Date 2/17/2014 1:57 PM
Description
  Columns
 
 
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
 
AMOUNT
decimal(11, 2)
True
False
False
 
AUTHORIZED_BATCH
varchar(8)
True
False
False
 
BANK_DATE
varchar(8)
True
False
False
 
CASHIER_ID
varchar(8)
True
False
False
 
CLOSE_DATE
varchar(8)
True
False
False
 
COMMENT_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_AR_CASH_RECON_A
int(10, 0)
False
False
False
 
LINKED_DETAIL
varchar(1)
True
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
 
RECON_FLAG
varchar(1)
True
False
False
 
RECORD_TYPE
varchar(2)
True
False
False
 
REF_NUMBER
varchar(15)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SESSION_DATE
varchar(8)
True
False
False
 
SESSION_LOCATION
varchar(2)
True
False
False
 
SESSION_SEQ
int(10, 0)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_CASH_RECON_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_CASH_RECON_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AR_CASH_RECON_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_CASH_RECON_A] Script Date: 03/09/2017 16:44:56 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_CASH_RECON_A](
    [ISN_AR_CASH_RECON_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,
    [CLOSE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CASHIER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESSION_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SESSION_SEQ] [int] NULL,
    [SESSION_LOCATION] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECORD_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AMOUNT] [decimal](11, 2) NULL,
    [RECON_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_NUMBER] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMMENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANK_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AUTHORIZED_BATCH] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LINKED_DETAIL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID AMOUNT AUTHORIZED_BATCH BANK_DATE CASHIER_ID CLOSE_DATE COMMENT_IND HOLD ISN_AR_CASH_RECON_A LINKED_DETAIL MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID RECON_FLAG RECORD_TYPE REF_NUMBER RowUpdatedOn SESSION_DATE SESSION_LOCATION SESSION_SEQ
20151105 FIR450N1 0916136 E088587 1528.40 E087567 20151027 916136 107613 N CH 2017-02-06T10:44:22.789-05:00 20151027 GL 1
20080414 FIR450N1 0228487 OPER2 640.54 20080415 E004483 20080411 1018588 23597 20080416 FIR450N1 1018588 E002374 CH 2017-02-06T10:44:15.519-05:00 20080411 SO 1
20071211 FIR450N1 0204257 OPER2 644.31 WEB00178 20071213 WEB00004 20071211 1036478 21704 20071214 FIR450N1 1036478 E002374 CC 2017-02-06T10:44:15.332-05:00 20071211 RE 1
20160502 FIR450N1 0430558 OPER2 1483.00 E088582 20160405 430558 111222 N CH 2017-02-06T10:44:23.038-05:00 20160405 EC 2
20080801 FIR450N1 0112145 OPER2 3563.86 20080804 E000925 20080731 1046231 25764 20080805 FIR450N1 1046231 E002374 CH 2017-02-06T10:44:15.691-05:00 20080731 NO 1
20140813 FIR450N1 0308503 OPER2 7059.11 20140812 WEB00004 20140813 308503 95308 N AM 2017-02-06T10:44:21.837-05:00 20140812 RE 2
20120817 FIR450N1 0309520 OPER2 1640.00 20120816 20120919 WEB00009 20120817 825087 67514 20120920 FIR450N1 0825087 E002374 DS 2017-02-06T10:44:19.435-05:00 20120816 RE 2
20030813 FIR450N1 0139481 OPER2 12312.42 20031013 E019198 20030812 1036024 2794 20031014 FIR450N1 1036024 E002374 CC 2017-02-06T10:44:13.756-05:00 20030812 CE 1
20060816 FIR450N1 0319186 OPER2 13688.50 20060820 E002402 20060815 836347 14530 20060821 FIR450N1 0836347 E002374 CC 2017-02-06T10:44:14.739-05:00 20060815 CE 1
20160901 FIR450N1 0152365 OPER2 13102.89 20160821 WEB00005 20160822 152365 114038 N AM 2017-02-06T10:44:23.257-05:00 20160821 SW 1
Powered by BI Documenter