DWStaging
 dbo.AR_RECEIPT_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_RECEIPT_A
  Properties
Property Value
Name AR_RECEIPT_A
Schema dbo
Row Count 5219221
Data Size 1118968 KB
Index Size 77856 KB
Create Date 11/7/2012 11:53 AM
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
 
CASH_TENDERED
numeric(17, 2)
True
False
False
 
CASHIER_SESSION_KEY
varchar(19)
True
False
False
 
CHANGE_DUE
numeric(17, 2)
True
False
False
 
CITY
varchar(30)
True
False
False
 
COMMENT_IND
varchar(1)
True
False
False
 
CUSTOMER_ID
varchar(9)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_AR_RECEIPT_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
 
MISC_RECEIPT_CAT
varchar(2)
True
False
False
 
PAID_TERM
varchar(6)
True
False
False
 
PAYEE_ID
varchar(11)
True
False
False
 
PAYEE_NAME
varchar(40)
True
False
False
 
PRINTED_RECEIPT_NUM
int(10, 0)
True
False
False
 
RECEIPT_AMOUNT
numeric(17, 2)
True
False
False
 
RECEIPT_BANK
numeric(17, 2)
True
False
False
 
RECEIPT_BOX
numeric(17, 2)
True
False
False
 
RECEIPT_CASH
numeric(17, 2)
True
False
False
 
RECEIPT_CHECK
numeric(17, 2)
True
False
False
 
RECEIPT_CREDIT_CARD
numeric(17, 2)
True
False
False
 
RECEIPT_OTHER_1
numeric(17, 2)
True
False
False
 
RECEIPT_OTHER_2
numeric(17, 2)
True
False
False
 
RECEIPT_POP
numeric(17, 2)
True
False
False
 
RECEIPT_REFERENCE_NUM
varchar(30)
True
False
False
 
RECEIPT_SEQ
int(10, 0)
True
False
False
 
RECEIPT_STATUS
varchar(2)
True
False
False
 
RECEIPT_TYPE
varchar(2)
True
False
False
 
RECEIPT_WIRE
numeric(17, 2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
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
 
STUDENT_ID
varchar(9)
True
False
False
 
TOTAL_OBLG_PAID
numeric(17, 2)
True
False
False
 
TOTAL_RECV_PAID
numeric(17, 2)
True
False
False
 
ZIP
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AR_RECEIPT_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AR_RECEIPT_A depends on)
Name Type
View
View
View
StoredProcedure
StoredProcedure
  Child Dependencies (objects that depend on dbo.AR_RECEIPT_A)
Name Type
STOREDPROCEDURE
STOREDPROCEDURE
VIEW
VIEW
VIEW
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AR_RECEIPT_A] Script Date: 03/09/2017 16:45:00 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AR_RECEIPT_A](
    [ISN_AR_RECEIPT_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,
    [PRINTED_RECEIPT_NUM] [int] NULL,
    [CASHIER_SESSION_KEY] [varchar](19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIPT_SEQ] [int] NULL,
    [RECEIPT_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMMENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIPT_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CUSTOMER_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIPT_AMOUNT] [numeric](17, 2) NULL,
    [CASH_TENDERED] [numeric](17, 2) NULL,
    [CHANGE_DUE] [numeric](17, 2) NULL,
    [RECEIPT_CASH] [numeric](17, 2) NULL,
    [RECEIPT_CHECK] [numeric](17, 2) NULL,
    [RECEIPT_CREDIT_CARD] [numeric](17, 2) NULL,
    [RECEIPT_WIRE] [numeric](17, 2) NULL,
    [RECEIPT_BANK] [numeric](17, 2) NULL,
    [RECEIPT_OTHER_1] [numeric](17, 2) NULL,
    [RECEIPT_OTHER_2] [numeric](17, 2) 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,
    [MISC_RECEIPT_CAT] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_ID] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIPT_REFERENCE_NUM] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOTAL_RECV_PAID] [numeric](17, 2) NULL,
    [TOTAL_OBLG_PAID] [numeric](17, 2) NULL,
    [RECEIPT_POP] [numeric](17, 2) NULL,
    [RECEIPT_BOX] [numeric](17, 2) NULL,
    [PAID_TERM] [varchar](6) 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 CASHIER_SESSION_KEY CITY COMMENT_IND CUSTOMER_ID FISCAL_YEAR HOLD ISN_AR_RECEIPT_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MISC_RECEIPT_CAT PAID_TERM PAYEE_ID PAYEE_NAME PRINTED_RECEIPT_NUM RECEIPT_AMOUNT RECEIPT_BANK RECEIPT_CREDIT_CARD RECEIPT_OTHER_1 RECEIPT_OTHER_2 RECEIPT_REFERENCE_NUM RECEIPT_SEQ RECEIPT_STATUS RECEIPT_TYPE RowUpdatedOn STATE STREET1 STREET2 STREET3 STUDENT_ID ZIP
20080123 FIC720N1 0045229 OPER2 FIC402N220080123001 LAKE WORTH 45230 1938736 20080123 FIC720N1 0045230 OPER2 20082 DAMIANA SOSA-RAMIREZ 729.90 729.90 26 CO AU 2017-02-06T09:22:28.773-05:00 FL 617 UQUHART ST. D12545349 33461
20100114 FIC720N1 0051393 OPER2 FIC402N220100114041 WEST PALM BEACH 51394 2528570 20100114 FIC720N1 0051394 OPER2 20102 TERRANCE B.N. COLLINS 777.50 777.50 37 CO AU 2017-02-06T09:23:42.156-05:00 FL 1728 37TH STREET T13162052 33407
20090123 FIC720N1 0041281 OPER2 FIC402N220090123002 DELRAY BEACH 41282 2213064 20090123 FIC720N1 0041282 OPER2 20092 VAINA LEONORE FRANCOIS 1135.00 1135.00 3 CO AU 2017-02-06T09:23:02.531-05:00 FL 1530 CATHERINE DR APT4 V12430427 33445
20020827 FIC720N1 1016452 JOHNSONI 1 20020827003 ROCHESTER 1016455 215185 20020827 FIC720N1 1016455 JOHNSONI 20031 DOMINIC J FERRAUILO 479.00 479.00 67 CO AU 2017-02-06T09:18:52.789-05:00 NY 253 COOL ISLE D11465663 14622
20110707 FIC720N1 1221369 WEB3 1 20110707019 WELLINGTON 1221372 3051503 20110707 FIC720N1 1221372 WEB3 20121 MELISSA GRACE GUCCIONE 1162.00 1162.00 27 CO AU 2017-02-06T09:24:47.458-05:00 FL 2062 POLO GARDENS DR. APT 303 M13159918 33414
20110214 FIC720N1 2332303 WEB3 1 20110214003 WEST PALM BEACH 2332304 2929877 20110214 FIC720N1 2332304 WEB3 20112 MONIQUE ELENA AVILA 35.00 35.00 1069.20 1104.20 19 CO AU 2017-02-06T09:24:32.185-05:00 FL 1371 SCOTTSDALE RD WEST M13300447 33417
20070312 FIC720N1 1738304 WEB2 WEB0000220070312002 WEST PALM BEACH Y 2007 1738310 1719624 20070312 FIC720N1 1738310 WEB2 20072 HUI QING HE 984085 1405.50 1206.00 199.50 1405.50 16 CO AU 2017-02-06T09:22:01.925-05:00 FL 1935 ABBEY ROAD #402 H11951100 33415
20080714 FIC720N1 0117198 OPER2 FIC402N220080714002 LAKE WORTH 117199 2030328 20080714 FIC720N1 0117199 OPER2 20091 YOUSELINE FRANCOIS 1150.00 1150.00 95 CO AU 2017-02-06T09:22:39.849-05:00 FL 1001 SOUTH "M" STREET APT Y11328523 33460
20000531 FIC720N1 1325563 SMITHC 5 20000531001 LAKE WORTH 1325569 272534 20000531 FIC720N1 1325569 SMITHC 20003 PATRICIA A COOK 374.12 374.12 374.12 19 CO AU 2017-02-06T09:18:59.841-05:00 FL 7002 CHESAPEAKE CIR P06381255 33462
20020812 FIC720N1 1806057 WEB1 2 20020812001 JUPITER 1806058 778568 20020812 FIC720N1 1806058 WEB1 20031 HEATHER HYLAN BROWN 464.00 464.00 38 CO AU 2017-02-06T09:20:03.177-05:00 FL 11045 153RD COURT N H11122611 33458
Powered by BI Documenter