DWStaging
 dbo.PCARD_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.PCARD_A
  Properties
Property Value
Name PCARD_A
Schema dbo
Row Count 73839
Data Size 18448 KB
Index Size 1136 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
 
ATTACHMENTS
varchar(1)
True
False
False
 
BANK_REF_NO
varchar(24)
True
False
False
 
CARD_NUMBER
varchar(16)
True
False
False
 
CARDHOLD_AREA
varchar(10)
True
False
False
 
CARDHOLD_FIRSTNAME
varchar(25)
True
False
False
 
CARDHOLD_INITIAL
varchar(1)
True
False
False
 
CARDHOLD_LASTNAME
varchar(25)
True
False
False
 
CARDHOLD_NAME
varchar(40)
True
False
False
 
CARDHOLD_USERID
varchar(8)
True
False
False
 
COMPLETED_DATE
varchar(8)
True
False
False
 
DEBIT_CREDIT_IND
varchar(1)
True
False
False
 
DISPUTE_NOTE
varchar(1)
True
False
False
 
FED_TAX_ID
varchar(10)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
FY_TRVL_NBR
varchar(10)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INCORP_STATUS_CODE
varchar(1)
True
False
False
 
INCORP_STATUS_DESC
varchar(20)
True
False
False
 
ISN_PCARD_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
 
MCC
varchar(4)
True
False
False
 
MINORITY_VENDOR_CODE
varchar(4)
True
False
False
 
NOTES_IND
varchar(1)
True
False
False
 
PAY_TO_CITY
varchar(13)
True
False
False
 
PAY_TO_NAME
varchar(26)
True
False
False
 
PAY_TO_STATE
varchar(3)
True
False
False
 
PAY_TO_ZIP
int(10, 0)
True
False
False
 
PAYEE
varchar(11)
True
False
False
 
PC_TRANS_FILE_IND
varchar(1)
True
False
False
 
PC_TRANS_NUMBER
varchar(7)
True
False
False
 
PC_USER_FILE_IND
varchar(1)
True
False
False
 
PERSON_ID
int(10, 0)
True
False
False
 
POSTING_DATE
varchar(8)
True
False
False
 
RECEIPT
varchar(1)
True
False
False
 
RECONCILIATION_DATE
varchar(8)
True
False
False
 
REJECT_NOTE
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SALES_TAX_AMT
numeric(17, 2)
True
False
False
 
SALES_TAX_DEBIT_CREDIT
varchar(1)
True
False
False
 
SALES_TAX_FLAG
varchar(1)
True
False
False
 
SPLIT_FLAG
varchar(1)
True
False
False
 
STATEMENT_DATE
varchar(8)
True
False
False
 
STATUS
varchar(2)
True
False
False
 
STATUS_1099
varchar(1)
True
False
False
 
SUPERVISOR_ID
varchar(8)
True
False
False
 
TRANS_AMT
numeric(17, 2)
True
False
False
 
TRANS_CODE
varchar(4)
True
False
False
 
TRANS_DATE
varchar(8)
True
False
False
 
TRANS_ID
varchar(10)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_PCARD_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.PCARD_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.PCARD_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[PCARD_A] Script Date: 03/09/2017 16:45:47 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[PCARD_A](
    [ISN_PCARD_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,
    [PC_USER_FILE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PC_TRANS_FILE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CARD_NUMBER] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CARDHOLD_USERID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CARDHOLD_AREA] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SUPERVISOR_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANK_REF_NO] [varchar](24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FISCAL_YEAR] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PC_TRANS_NUMBER] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_TO_NAME] [varchar](26) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_TO_CITY] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_TO_STATE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_TO_ZIP] [int] NULL,
    [MCC] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANS_AMT] [numeric](17, 2) NULL,
    [TRANS_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TRANS_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOTES_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [POSTING_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CARDHOLD_LASTNAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CARDHOLD_FIRSTNAME] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CARDHOLD_INITIAL] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CARDHOLD_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATEMENT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECONCILIATION_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEBIT_CREDIT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SALES_TAX_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SALES_TAX_AMT] [numeric](17, 2) NULL,
    [SALES_TAX_DEBIT_CREDIT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SPLIT_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MINORITY_VENDOR_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS_1099] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INCORP_STATUS_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INCORP_STATUS_DESC] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FED_TAX_ID] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REJECT_NOTE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISPUTE_NOTE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PERSON_ID] [int] NULL,
    [FY_TRVL_NBR] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIPT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [COMPLETED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTACHMENTS] [varchar](1) 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 ATTACHMENTS BANK_REF_NO CARD_NUMBER CARDHOLD_AREA CARDHOLD_FIRSTNAME CARDHOLD_INITIAL CARDHOLD_LASTNAME CARDHOLD_NAME CARDHOLD_USERID COMPLETED_DATE DEBIT_CREDIT_IND DISPUTE_NOTE FED_TAX_ID FISCAL_YEAR FY_TRVL_NBR HOLD INCORP_STATUS_CODE INCORP_STATUS_DESC ISN_PCARD_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MCC MINORITY_VENDOR_CODE NOTES_IND PAY_TO_CITY PAY_TO_NAME PAY_TO_STATE PAYEE PC_TRANS_FILE_IND PC_TRANS_NUMBER PC_USER_FILE_IND POSTING_DATE RECEIPT RECONCILIATION_DATE REJECT_NOTE RowUpdatedOn SALES_TAX_DEBIT_CREDIT SALES_TAX_FLAG SPLIT_FLAG STATEMENT_DATE STATUS STATUS_1099 SUPERVISOR_ID TRANS_AMT TRANS_CODE TRANS_DATE TRANS_ID
20131202 FIA240B1 1019181 BATCH TXN000000000000000046831 4715000000007968 MARMARO, KRISTIN A 20131203 911646860 2014 1146219 45939 20131203 FIA241N4 1510463 E077620 5942 Amazon.com V911646860 A A004210 20131129 2017-02-06T10:52:12.258-05:00 CM 36.59 20131128
20140225 FIA240B1 1544077 BATCH TXN000000000000000048932 4715000000014509 BONDARIN, MARIA M 20140312 952454902 2014 1023479 48077 20140312 FIA241N4 1233283 E077620 5994 SAGE PUBLICATIONS V952454902 A A006344 20140220 2017-02-06T10:52:12.601-05:00 CM 91.00 20140219
20080721 FIA240B1 1354287 BATCH TXN000000000000000001251 4715000000003298 BALLARTE, DON C 20080812 267258318 2009 947320 215 20080812 FIA241N4 1227516 E062479 5251 SEWELL HARDWARE #4 A A000099 20080710 2017-02-06T10:52:05.893-05:00 CM 11.28 20080709
20091026 FIA240B1 1316486 BATCH TXN000000000000000010810 4715000000014509 BONDARIN, MARIA M 20091217 2010 951278 8926 20091217 FIA241N4 0928240 E062479 8699 HISPANIC CHAMBER OF COMME V650652653 A A002574 20091023 Y 2017-02-06T10:52:07.126-05:00 CM 50.00 20091021
20120604 FIA240B1 825380 BATCH TXN000000000000000033282 4715000000003355 MATURANA, DAVID F 20120618 650000829 2012 1022100 32635 20120618 FIA241N4 0832152 E077620 7623 JOHNSTONE SUPPLY BOYNTON V650000829 A A008901 20120601 2017-02-06T10:52:10.449-05:00 CM 449.89 20120531
20090320 FIA240B1 1357063 BATCH TXN000000000000000006142 4715000000009743 MOONEY, MATTHEW T 20090408 130794380 2009 1435360 5140 20090408 FIA241N4 1020204 E062479 5065 GRAYBAR ELECTRIC V130794380 A A004985 20090319 2017-02-06T10:52:06.595-05:00 CM 79.01 20090318
20110711 FIA240B1 1709333 BATCH TXN000000000000000024500 4715000000003193 URENA, JUANITA T 20110718 593459505 2012 1447128 23673 20110718 FIA241N4 1744491 E077620 9399 FDLE CCHINET V593459505 A A000122 20110708 2017-02-06T10:52:09.169-05:00 CM 24.00 20110707
20090327 FIA240B1 1529558 BATCH TXN000000000000000006370 4715000000008728 GIFFORD, ROGER A 20090415 2009 1013142 5323 20090415 FIA241N4 0910496 E062479 5411 PUBLIX SUPERMARKETS A A005204 20090326 2017-02-06T10:52:06.611-05:00 CM 7.04 20090325
20160318 FIA240B1 1459204 BATCH 247055426076170766513042 4715000000004748 PACHMAN, SHARON E 20160411 522136938 2016 1624016 66532 20160411 FIA241N4 1121337 E077620 3503 SHERATON NY TIMES SQ HTL A A006476 20160317 2017-02-06T10:52:15.222-05:00 CM 838.56 20160316
20150324 FIA240B1 1526166 BATCH TXN000000000000000057865 4715000000000220 STEWART, MICHELE B 20150410 590324412 2015 825580 57151 20150410 FIA241N4 1552192 E077620 5411 PUBLIX 367 V590324412 A A005924 20150319 Y 2017-02-06T10:52:13.881-05:00 CM 47.32 20150318
Powered by BI Documenter