DWStaging
 dbo.JOURNAL_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.JOURNAL_FILE
  Properties
Property Value
Name JOURNAL_FILE
Schema dbo
Row Count 2265758
Data Size 278440 KB
Index Size 33808 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
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
 
ADJUSTMENT_CODE
varchar(1)
True
False
False
 
AMOUNT
numeric(17, 2)
True
False
False
 
APPROV_READY
varchar(8)
True
False
False
 
ASSET_ID
varchar(16)
True
False
False
 
AUTOMATIC_ENTRY_IND
varchar(1)
True
False
False
 
BATCH_ID
varchar(8)
True
False
False
 
BILLING_NO
varchar(8)
True
False
False
 
BUDGET_DEPT
bit(1, 0)
True
False
False
 
BUDGET_TYPE_CODE
varchar(8)
True
False
False
 
CALENDAR_PERIOD
varchar(6)
True
False
False
 
CHECK_NO
varchar(8)
True
False
False
 
COMITMNT_CCYY_NO
varchar(12)
True
False
False
 
CORR_JNL_PERIOD
varchar(6)
True
False
False
 
CORR_JNL_TYPE_NO
varchar(7)
True
False
False
 
CUST_NO
varchar(9)
True
False
False
 
DEFAULT_ACCT_NO
varchar(25)
True
False
False
 
DEFAULT_LINE_DESC
varchar(40)
True
False
False
 
DEFAULT_NSF
varchar(1)
True
False
False
 
DETAIL_DESCRIPTION
varchar(40)
True
False
False
 
DETAIL_IND
varchar(1)
True
False
False
 
DUE_DATE
varchar(8)
True
False
False
 
GL_ACCT_NO
varchar(25)
True
False
False
 
HEADER_IND
varchar(1)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_JOURNAL_FILE
int(10, 0)
False
False
False
 
JOURNAL_NO
int(10, 0)
True
False
False
 
JOURNAL_TYPE
varchar(2)
True
False
False
 
LAST_LINE_NO
int(10, 0)
True
False
False
 
LINE_NO
int(10, 0)
True
False
False
 
LINE_SUSP_IND
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
 
MANUAL_ENTRY
varchar(1)
True
False
False
 
NSF_OVERRIDE
varchar(1)
True
False
False
 
NSF_SUSPEND
varchar(1)
True
False
False
 
ORG_UNIT
varchar(16)
True
False
False
 
PAY_DATE
varchar(8)
True
False
False
 
PAYMENT_TYPE
varchar(3)
True
False
False
 
PAYMENT_XREF
varchar(12)
True
False
False
 
PO_CCYY_NO
varchar(12)
True
False
False
 
POST_ONLINE
varchar(1)
True
False
False
 
POST_REGARDLESS
varchar(1)
True
False
False
 
POSTED_DATE
varchar(8)
True
False
False
 
POSTED_IND
varchar(1)
True
False
False
 
POSTED_TIME
int(10, 0)
True
False
False
 
POSTED_USER
varchar(8)
True
False
False
 
PROJECT_NO
varchar(10)
True
False
False
 
RECV_ADJUST_KEY
varchar(19)
True
False
False
 
RESPONSIBLE_USER
varchar(8)
True
False
False
 
RESTART_IND
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STUDENT_NO
varchar(9)
True
False
False
 
TERM
varchar(6)
True
False
False
 
TOT_CR_ACTUAL
numeric(17, 2)
True
False
False
 
TOT_CR_CONTROL
numeric(17, 2)
True
False
False
 
TOT_DB_ACTUAL
numeric(17, 2)
True
False
False
 
TOT_DB_CONTROL
numeric(17, 2)
True
False
False
 
VENDOR_NO
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_JOURNAL_FILE
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.JOURNAL_FILE depends on)
Name Type
  Child Dependencies (objects that depend on dbo.JOURNAL_FILE)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[JOURNAL_FILE] Script Date: 03/09/2017 16:45:42 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[JOURNAL_FILE](
    [ISN_JOURNAL_FILE] [int] NOT NULL,
    [CALENDAR_PERIOD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOURNAL_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JOURNAL_NO] [int] NULL,
    [LINE_NO] [int] NULL,
    [LAST_LINE_NO] [int] NULL,
    [HEADER_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DETAIL_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [GL_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DETAIL_DESCRIPTION] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AMOUNT] [numeric](17, 2) NULL,
    [PO_CCYY_NO] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMITMNT_CCYY_NO] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEFAULT_NSF] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NSF_SUSPEND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NSF_OVERRIDE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESTART_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LINE_SUSP_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ASSET_ID] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_NO] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUST_NO] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_NO] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PROJECT_NO] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CORR_JNL_PERIOD] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CORR_JNL_TYPE_NO] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_NO] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILLING_NO] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MANUAL_ENTRY] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [AUTOMATIC_ENTRY_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOT_CR_CONTROL] [numeric](17, 2) NULL,
    [TOT_CR_ACTUAL] [numeric](17, 2) NULL,
    [TOT_DB_CONTROL] [numeric](17, 2) NULL,
    [TOT_DB_ACTUAL] [numeric](17, 2) NULL,
    [POST_REGARDLESS] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POST_ONLINE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [APPROV_READY] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEFAULT_LINE_DESC] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEFAULT_ACCT_NO] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TERM] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSTED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSTED_TIME] [int] NULL,
    [POSTED_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSTED_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ORG_UNIT] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESPONSIBLE_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUDGET_TYPE_CODE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADJUSTMENT_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
    [BUDGET_DEPT] [bit] NULL,
    [PAYMENT_XREF] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BATCH_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECV_ADJUST_KEY] [varchar](19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID ADJUSTMENT_CODE APPROV_READY ASSET_ID AUTOMATIC_ENTRY_IND BATCH_ID BILLING_NO BUDGET_DEPT BUDGET_TYPE_CODE CALENDAR_PERIOD CHECK_NO COMITMNT_CCYY_NO CORR_JNL_PERIOD CORR_JNL_TYPE_NO CUST_NO DEFAULT_ACCT_NO DEFAULT_LINE_DESC DEFAULT_NSF DETAIL_DESCRIPTION DETAIL_IND DUE_DATE GL_ACCT_NO HEADER_IND HOLD ISN_JOURNAL_FILE JOURNAL_NO JOURNAL_TYPE LAST_LINE_NO LINE_SUSP_IND MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MANUAL_ENTRY NSF_OVERRIDE NSF_SUSPEND ORG_UNIT PAY_DATE PAYMENT_TYPE PAYMENT_XREF PO_CCYY_NO POST_ONLINE POST_REGARDLESS POSTED_DATE POSTED_IND POSTED_TIME POSTED_USER PROJECT_NO RECV_ADJUST_KEY RESPONSIBLE_USER RESTART_IND RowUpdatedOn STUDENT_NO TERM TOT_CR_ACTUAL TOT_CR_CONTROL TOT_DB_ACTUAL TOT_DB_CONTROL VENDOR_NO
APPROVE false 199910 H 1512226 104541 2045 CO 1 N JGREENWO Y N 19991027 P 1512226 E002790 JGREENWO 2017-02-06T09:39:25.275-05:00 13.05 13.05
APPROVE false 200212 N H 1215522 441880 902 AP 2 N 3-WAY Y N 20021210 P 1215523 E002800 3-WAY 2017-02-06T09:40:14.977-05:00 4.18 4.18 4.18 4.18
20080909 FIU302N1 1016426 E037615 NO SHOW false 200809 N H 1218417 647 CO 1 N Y N 20080909 P 1016426 E037615 2017-02-06T09:42:05.504-05:00 137.18 137.18
APPROVE false 200008 N H 1852255 175502 278 AP 34 N CHECK Y N 20000804 P 1852255 OPER2 CHECK 2017-02-06T09:39:35.696-05:00 1995.23 1995.23 1995.23 1995.23
20060815 FIU302N1 1346353 E019027 NO SHOW false 200608 N H 939018 1703 EN 1 N Y N 20060815 P 1346353 E019027 2017-02-06T09:41:25.817-05:00 81709.00 81709.00
APPROVE false 200905 N H 1348013 1315417 1624 AP 2 N 3-WAY Y N 20090511 P 1348013 E032885 3-WAY 2017-02-06T09:42:19.185-05:00 4.78 4.78 4.78 4.78
APPROVE false 200012 H 1431134 212911 1491 AP 2 N VCOLLAZO Y N 20001218 P 1431135 E000683 VCOLLAZO 2017-02-06T09:39:41.219-05:00 150.00 150.00 150.00 150.00
APPROVE false 201306 N H 1513257 1846505 2388 EN 1 N 3-WAY Y N 20130626 P 1513257 E003843 3-WAY 2017-02-06T09:43:35.017-05:00 24.86 24.86
APPROVE false 200008 N H 1138555 180307 1559 EN 12 N 3-WAY Y N 20000821 P 1138561 E001609 3-WAY 2017-02-06T09:39:36.398-05:00 270.02 270.02
APPROVE false 200304 N H 1120547 487549 3827 EN 1 N 3-WAY Y N 20030428 P 1120549 E002800 3-WAY 2017-02-06T09:40:21.841-05:00 172.92 172.92
Powered by BI Documenter