DWStaging
 dbo.GENERAL_LEDGER_FILE (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.GENERAL_LEDGER_FILE
  Properties
Property Value
Name GENERAL_LEDGER_FILE
Schema dbo
Row Count 336201
Data Size 35032 KB
Index Size 5432 KB
Create Date 10/24/2012 4:04 PM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ACCT_SIGN
varchar(1)
True
False
False
 
ACCT_TYPE
varchar(2)
True
False
False
 
ACTIVE_IND
varchar(1)
True
False
False
 
ADD_DATE
varchar(8)
True
False
False
 
ADD_PGM
varchar(8)
True
False
False
 
ADD_TIME
varchar(7)
True
False
False
 
ADD_USER
varchar(8)
True
False
False
 
BUDGET_POOL_NO
varchar(9)
True
False
False
 
BUDGETED_ACC_IND
varchar(1)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
GL_ACCT_NO
varchar(25)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INIT_BUDGET
numeric(17, 2)
True
False
False
 
ISN_GENERAL_LEDGER_FILE
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
 
ORIG_TP
numeric(17, 2)
True
False
False
 
PERM_ADJ
numeric(17, 2)
True
False
False
 
PERM_REALLOC
numeric(17, 2)
True
False
False
 
PRIOR_ACTIVITY
numeric(17, 2)
True
False
False
 
PRIOR_BALANCE
numeric(17, 2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
TEMP_ADJ
numeric(17, 2)
True
False
False
 
TEMP_REALLOC
numeric(17, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_GENERAL_LEDGER_FILE
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.GENERAL_LEDGER_FILE depends on)
Name Type
View
View
View
View
View
View
  Child Dependencies (objects that depend on dbo.GENERAL_LEDGER_FILE)
Name Type
VIEW
VIEW
VIEW
VIEW
VIEW
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[GENERAL_LEDGER_FILE] Script Date: 03/09/2017 16:45:35 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[GENERAL_LEDGER_FILE](
    [ISN_GENERAL_LEDGER_FILE] [int] NOT NULL,
    [FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACCT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUDGET_POOL_NO] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INIT_BUDGET] [numeric](17, 2) NULL,
    [ORIG_TP] [numeric](17, 2) NULL,
    [TEMP_ADJ] [numeric](17, 2) NULL,
    [PERM_ADJ] [numeric](17, 2) NULL,
    [ACCT_SIGN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ACTIVE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUDGETED_ACC_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TEMP_REALLOC] [numeric](17, 2) NULL,
    [PERM_REALLOC] [numeric](17, 2) NULL,
    [PRIOR_ACTIVITY] [numeric](17, 2) NULL,
    [PRIOR_BALANCE] [numeric](17, 2) 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] [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,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ACCT_SIGN ACCT_TYPE ACTIVE_IND ADD_DATE ADD_PGM ADD_TIME ADD_USER BUDGET_POOL_NO BUDGETED_ACC_IND FISCAL_YEAR GL_ACCT_NO ISN_GENERAL_LEDGER_FILE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PRIOR_ACTIVITY RowUpdatedOn TEMP_REALLOC
+ 6 A 20160426 FIG016N2 1114114 E000230 60000 Y 2016 111210001210001064510 301685 2017-02-06T10:33:21.906-05:00 577.00
+ 5 A 20040825 FIG730B2 307478 BATCH Y 2005 111505001505002059703 118367 120.00 2017-02-06T10:33:07.601-05:00
+ 5 A 20100714 FIG016N3 0101098 OPER2 N 2011 144010004401109653000 212823 20100817 FIG730B2 2031382 E005840 165046.07 2017-02-06T10:33:14.933-05:00
+ 3 A 20000818 FIG730B4 2100449 BATCH N 2001 681260008126039031100 50913 2017-02-06T10:33:02.25-05:00
+ 3 A 20060814 FIG730B7 1651117 BATCH N 2007 582151001512859031100 153645 2017-02-06T10:33:10.331-05:00
+ 1 A 20120710 FIG016N3 0152496 OPER1 N 2013 681260008128379010101 248567 20120815 FIG730B7 2025385 E005840 6035.81 2017-02-06T10:33:17.678-05:00
+ 5 A 20100817 FIG730B2 2031194 BATCH N 2011 111119001119002059300 232347 2221.73 2017-02-06T10:33:16.446-05:00
+ 3 A 20090911 FIG016N3 0232238 OPER2 N 2010 582151001516269036010 204110 2017-02-06T10:33:14.278-05:00
+ 5 A 20120712 FIG016N3 0248265 OPER1 N 2013 146040004604021059100 263007 20120815 FIG730B2 2025019 E005840 27066.15 2017-02-06T10:33:18.817-05:00
+ 5 A 20150914 FIG016N3 0028576 OPER2 N 2016 111104001104001052200 309323 20151112 FIG730B2 0509396 OPER2 268.86 2017-02-06T10:33:22.468-05:00
Powered by BI Documenter