DWStaging
 dbo.AR_RECEIVABLES_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_RECEIVABLES_A
  Properties
Property Value
Name AR_RECEIVABLES_A
Schema dbo
Row Count 1730146
Data Size 266664 KB
Index Size 25832 KB
Create Date 2/17/2014 2: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
numeric(11, 2)
True
False
False
 
AMOUNT_DUE
numeric(11, 2)
True
False
False
 
AMOUNT_PAID
numeric(11, 2)
True
False
False
 
BANK_IND
varchar(1)
True
False
False
 
BILL_INSTALL_NUM
int(10, 0)
True
False
False
 
COLLECTION_FLAG
varchar(2)
True
False
False
 
COMMENT_IND
varchar(1)
True
False
False
 
CONTRACT_ID
int(10, 0)
True
False
False
 
CUSTOMER_ID
varchar(9)
True
False
False
 
DUNNING_LETTER_COUNT
int(10, 0)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLD_DATE
varchar(8)
True
False
False
 
HOLD_TYPE
varchar(2)
True
False
False
 
ISN_AR_RECEIVABLES_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
 
NEEDS_GL_CREATED_IND
varchar(1)
True
False
False
 
OVERPAID_FLAG
varchar(1)
True
False
False
 
RECEIVABLE_DATE
varchar(8)
True
False
False
 
RECEIVABLE_NBR
varchar(9)
True
False
False
 
RECEIVABLE_REC_TYPE
varchar(2)
True
False
False
 
RECEIVABLE_SEQ
int(10, 0)
True
False
False
 
RECEIVABLE_STATUS
varchar(2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SPECIAL_CHARGE_DESC
varchar(30)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
TERM
varchar(6)
True
False
False
 
TERM_9COMP
varchar(6)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_RECEIVABLES_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_RECEIVABLES_A depends on)
Name Type
View
  Child Dependencies (objects that depend on dbo.AR_RECEIVABLES_A)
Name Type
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_RECEIVABLES_A] Script Date: 03/09/2017 16:45:01 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_RECEIVABLES_A](
    [ISN_AR_RECEIVABLES_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,
    [FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVABLE_NBR] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVABLE_SEQ] [int] NULL,
    [RECEIVABLE_REC_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVABLE_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVABLE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CONTRACT_ID] [int] NULL,
    [BILL_INSTALL_NUM] [int] NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM_9COMP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OVERPAID_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DUNNING_LETTER_COUNT] [int] NULL,
    [NEEDS_GL_CREATED_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPECIAL_CHARGE_DESC] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMMENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AMOUNT] [numeric](11, 2) NULL,
    [AMOUNT_PAID] [numeric](11, 2) NULL,
    [AMOUNT_DUE] [numeric](11, 2) NULL,
    [HOLD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COLLECTION_FLAG] [varchar](2) 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 AMOUNT_PAID BANK_IND COLLECTION_FLAG COMMENT_IND CONTRACT_ID CUSTOMER_ID FISCAL_YEAR HOLD HOLD_DATE HOLD_TYPE ISN_AR_RECEIVABLES_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NEEDS_GL_CREATED_IND OVERPAID_FLAG RECEIVABLE_DATE RECEIVABLE_NBR RECEIVABLE_REC_TYPE RECEIVABLE_SEQ RECEIVABLE_STATUS RowUpdatedOn SPECIAL_CHARGE_DESC STUDENT_ID TERM TERM_9COMP
20140329 FIC220N1 1651243 WEB3 1179.00 1179.00 109 000001327 2014 1047406 1374630 20140829 FIC220N1 1047406 E005840 20140519 006247802 ST 1 PD 2017-02-06T09:59:38.308-05:00 M14070908 20143
20100324 FIC220N1 0025480 OPER2 8 000001280 2010 30207 841677 20100324 FIC220N1 0030207 OPER2 20100112 004145478 ST 1 PD 2017-02-06T09:58:44.394-05:00 H12969796 20102
20140819 FIC220N1 1331051 E001335 1161.94 1161.94 114 000001327 2015 1411532 1414990 20141024 FIC220N1 1411532 E031488 20140828 006288021 ST 1 PD 2017-02-06T09:59:42.317-05:00 S14788368 20151
20160705 FIC220N1 1126495 WEB5 2033.91 2033.91 105 000001633 2017 125365 1647780 20161020 FIC220N1 0125365 OPER2 20160829 006521717 ST 1 PD 2017-02-06T10:00:05.202-05:00 J13368782 20171
20130410 FIC220N1 0132473 OPER2 765.55 765.55 41 000000035 2013 148418 1253356 20130412 FIC220N1 0148418 OPER2 20130111 006126674 ST 1 PD 2017-02-06T09:59:26.109-05:00 L06902076 20132
20111205 FIC220N1 0934590 WEB5 529.00 529.00 8 000000573 2012 1201061 1082811 20130116 FIC422B1 1356226 E031488 20120111 005948800 ST 1 PD 2017-02-06T09:59:08.683-05:00 M11556479 20122
20110111 FIC220N1 1150106 WEB5 Y S07963630 2011 140501 953806 20110114 FIC220N1 0140501 OPER2 20110111 005265419 BK 1 PD 2017-02-06T09:58:55.766-05:00 20111
20031013 FIC220N1 0124551 OPER2 500.00 500.00 1 000000968 2004 102413 271808 20031017 FIC220N1 0102413 OPER2 20030827 000272565 ST 1 PD 2017-02-06T09:57:48-05:00 C11505260 20041
20080829 FIC220N1 1322366 E057742 838.80 838.80 16 000001327 2009 1359206 658468 20111110 FIC422B1 1502132 E005840 20080828 002320335 ST 1 PD 2017-02-06T09:58:25.97-05:00 S12979209 20091
20070103 FIC220N1 0016094 OPER2 Y M12014452 2007 127202 512350 20070202 FIC220N1 0127202 OPER2 20070103 000865189 BK 1 PD 2017-02-06T09:58:11.415-05:00 20072
Powered by BI Documenter