DWStaging
 dbo.AR_BILL_HDR_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_BILL_HDR_A
  Properties
Property Value
Name AR_BILL_HDR_A
Schema dbo
Row Count 88361
Data Size 20360 KB
Index Size 1736 KB
Create Date 11/5/2012 3:48 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
 
BATCH_ID
varchar(8)
True
False
False
 
BILL_AMOUNT
numeric(17, 2)
True
False
False
 
BILL_DATE
varchar(8)
True
False
False
 
BILL_DATE_9COMP
varchar(8)
True
False
False
 
BILL_FORMAT
varchar(1)
True
False
False
 
BILL_ID
varchar(9)
True
False
False
 
BILL_TYPE_CODE
varchar(2)
True
False
False
 
CITY
varchar(30)
True
False
False
 
CUSTOMER_ID
varchar(9)
True
False
False
 
CUSTOMER_NAME
varchar(40)
True
False
False
 
DUE_DATE
varchar(8)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_AR_BILL_HDR_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
 
NOT_PAID_FLAG
varchar(1)
True
False
False
 
OBLIGATION_AMOUNT
numeric(17, 2)
True
False
False
 
RECEIVABLE_AMOUNT
numeric(17, 2)
True
False
False
 
REMIT_ADDR_TYPE
varchar(2)
True
False
False
 
REMIT_CUST_ID
varchar(9)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
STATE
varchar(2)
True
False
False
 
STREET1
varchar(30)
True
False
False
 
STREET2
varchar(30)
True
False
False
 
STREET3
varchar(30)
True
False
False
 
TYPE
varchar(2)
True
False
False
 
ZIP
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_BILL_HDR_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_BILL_HDR_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AR_BILL_HDR_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_BILL_HDR_A] Script Date: 03/09/2017 16:44:55 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_BILL_HDR_A](
    [ISN_AR_BILL_HDR_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,
    [BILL_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_DATE_9COMP] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_AMOUNT] [numeric](17, 2) NULL,
    [BATCH_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET1] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET2] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET3] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CITY] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ZIP] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_TYPE_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOT_PAID_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVABLE_AMOUNT] [numeric](17, 2) NULL,
    [OBLIGATION_AMOUNT] [numeric](17, 2) NULL,
    [REMIT_CUST_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REMIT_ADDR_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_FORMAT] [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 BATCH_ID BILL_AMOUNT BILL_DATE BILL_DATE_9COMP BILL_FORMAT BILL_ID BILL_TYPE_CODE CITY CUSTOMER_ID CUSTOMER_NAME DUE_DATE FISCAL_YEAR HOLD ISN_AR_BILL_HDR_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NOT_PAID_FLAG OBLIGATION_AMOUNT RECEIVABLE_AMOUNT REMIT_ADDR_TYPE REMIT_CUST_ID RowUpdatedOn STATE STREET1 STREET2 STREET3 TYPE ZIP
20050228 FIC605N1 1319222 E021320 20050228 25.25 20050228 79949771 000015155 NA WELLINGTON F11073657 BORGELIN, FRANTZIE G/GUILLAUME 20050330 2005 1734288 15295 20050331 FIC605N1 1734288 E001650 25.25 2017-02-06T10:51:08.048-05:00 FL 1571 THE 12TH FAIRWAY AD 33414
20130205 FIC605N1 0511292 OPER1 020413CD 748.75 20130204 79869795 S 000347485 NA WEST PALM BEACH M11919669 CORREDOR, MELVIN GERARDO 20130219 2013 2125222 63582 20130512 FIC605N1 2125222 WEB7 748.75 2017-02-06T10:51:12.463-05:00 FL 4650 CHERRY ROAD 01 33417
20071219 FIC605N1 1430026 E028728 00013049 391.50 20071219 79928780 000077216 NA WEST PALM BEACH S07427701 ROHIT, SANJAI 20080118 2008 1343560 27710 20080505 FIC605N1 1343560 E002402 391.50 2017-02-06T10:51:09.156-05:00 FL 429 NORTHWOOD RD AD 33407
20120918 FIC605N1 0401479 OPER2 091712CD 16.25 20120917 79879082 S 000344535 NA DELRAY BEACH L13758313 MAURETOUR, LUDNIE 20121002 2013 1642328 60694 20121001 FIC605N1 1642328 WEB3 16.25 2017-02-06T10:51:12.198-05:00 FL 3816 NW 7TH COURT 01 33445
20131105 FIC605N1 0414421 OPER2 110413CD 189.00 20131104 79868895 S 000352774 NA DELRAY BEACH P13994108 RIVERON, PHILLIP MICHAEL 20131119 2014 1204349 68814 20131114 FIC605N1 1204349 WEB3 189.00 2017-02-06T10:51:12.931-05:00 FL 14623 BONAIRE BLVD APT 504 01 33446
20141104 FIC605N1 0401064 OPER2 110314RS 888.00 20141103 79858896 S 000359062 NA LOXAHATCHEE E08248676 BISAILLON, ELIZABETH A 20141118 2015 401064 75156 Y 888.00 2017-02-06T10:51:13.508-05:00 FL 16157 78TH RD N 01 33470
20160607 FIC605N1 0625393 OPER2 060616RS 361.00 20160606 79839393 S 000368538 NA BOCA RATON C14078364 CLEMENT, CEDRIC JACQUES 20160621 2016 625393 84998 Y 361.00 2017-02-06T10:51:14.413-05:00 FL 10773 CYPRESS LAKE TER 01 33498
20130123 FIC605N1 0543242 OPER2 012213CD 294.75 20130122 79869877 S 000346945 NA WEST PALM BEACH P12677639 DELGADO, PATRICIA 20130206 2013 1008449 63067 20130123 FIC605N1 1008449 WEB2 294.75 2017-02-06T10:51:12.416-05:00 FL 1413 STONEHAVEN ESTATES DR 01 33411
20080107 FIC605N1 0823156 E004135 01072008 936.08 20080107 79919892 000077295 NA WELLINGTON L11066883 HILLS, LOREN JANE 20080122 2008 33069 27788 20080207 FIC605N1 0033069 OPER2 936.08 2017-02-06T10:51:09.156-05:00 FL 1285 MAYVIEW WAY 01 33414
20040212 FIC605N1 1147029 OPER2 20040212 1013.00 20040212 79959787 000010522 AD BOCA RATON D11279163 FERRANTE, DOMENIC JAMES 20040313 2004 1435311 10615 20060523 FIC605N1 1435311 E014684 273.00 740.00 2017-02-06T10:51:07.627-05:00 FL 754 NW 7TH DR AD 33486
Powered by BI Documenter