DWStaging
 dbo.AP_PAYMENT (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.AP_PAYMENT
  Properties
Property Value
Name AP_PAYMENT
Schema dbo
Row Count 890707
Data Size 181520 KB
Index Size 13320 KB
Create Date 3/4/2015 10:09 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
 
BANK_CODE
varchar(4)
True
False
False
 
BATCH_ID
varchar(8)
True
False
False
 
CHARGE_EXP
varchar(6)
True
False
False
 
CHARGE_GUID
varchar(19)
True
False
False
 
CHARGE_NBR
varchar(16)
True
False
False
 
CHARGE_TYPE
varchar(2)
True
False
False
 
CHECK_EFT_CCR_NBR
varchar(15)
True
False
False
 
EFT_NUMBER
varchar(15)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_AP_PAYMENT
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
 
PAYEE_ABA
varchar(9)
True
False
False
 
PAYEE_ACCT_NBR
varchar(20)
True
False
False
 
PAYEE_ACCT_TYPE
varchar(1)
True
False
False
 
PAYEE_ADDR_SEQ_NBR
int(10, 0)
True
False
False
 
PAYEE_ADDRESS_TYPE
varchar(1)
True
False
False
 
PAYEE_CITY
varchar(40)
True
False
False
 
PAYEE_COUNTRY
varchar(3)
True
False
False
 
PAYEE_ID
varchar(9)
True
False
False
 
PAYEE_PHONE_NBR
varchar(15)
True
False
False
 
PAYEE_STATE
varchar(2)
True
False
False
 
PAYEE_TYPE
varchar(2)
True
False
False
 
PAYEE_ZIP
varchar(11)
True
False
False
 
PAYMENT_AMT
numeric(17, 2)
True
False
False
 
PAYMENT_DATE
varchar(8)
True
False
False
 
PAYMENT_NBR
varchar(8)
True
False
False
 
PAYMENT_TYPE
varchar(3)
True
False
False
 
PICKUP_CHECK_IND
varchar(1)
True
False
False
 
PRINT_CHECK_YN
varchar(1)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STATUS
varchar(2)
True
False
False
 
STATUS_DATE
varchar(8)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AP_PAYMENT
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AP_PAYMENT depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AP_PAYMENT)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AP_PAYMENT] Script Date: 03/09/2017 16:44:52 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AP_PAYMENT](
    [ISN_AP_PAYMENT] [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,
    [PAYMENT_NBR] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_TYPE] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_AMT] [numeric](17, 2) NULL,
    [STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BATCH_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BANK_CODE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EFT_NUMBER] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHECK_EFT_CCR_NBR] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRINT_CHECK_YN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_ADDR_SEQ_NBR] [int] NULL,
    [PAYEE_ADDRESS_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_CITY] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_ZIP] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_COUNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_PHONE_NBR] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PICKUP_CHECK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHARGE_TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHARGE_NBR] [varchar](16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHARGE_EXP] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_ABA] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_ACCT_NBR] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYEE_ACCT_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CHARGE_GUID] [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 BANK_CODE BATCH_ID CHARGE_EXP CHARGE_GUID CHARGE_NBR CHARGE_TYPE CHECK_EFT_CCR_NBR EFT_NUMBER FISCAL_YEAR HOLD ISN_AP_PAYMENT MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAYEE_ABA PAYEE_ACCT_NBR PAYEE_ACCT_TYPE PAYEE_ADDR_SEQ_NBR PAYEE_ADDRESS_TYPE PAYEE_CITY PAYEE_COUNTRY PAYEE_ID PAYEE_PHONE_NBR PAYEE_STATE PAYEE_TYPE PAYEE_ZIP PAYMENT_AMT PAYMENT_DATE PAYMENT_NBR PAYMENT_TYPE PICKUP_CHECK_IND PRINT_CHECK_YN RowUpdatedOn STATUS STATUS_DATE
20130927 FIA550B6 0156335 OPER2 BARN 13269-2 000000000082795 2014 156335 697914 20130927 FIA560B1 0202240 OPER2 267083763 0066221600000000 C JUPITER US W13698873 5613896925 FL S 33458 550.00 20130926 00693732 EFT 2017-02-06T10:16:05.264-05:00 PD 20130927
20050518 FIA550B6 0019399 OPER2 BARN 05137-1 00296454 2005 19399 235196 20050518 FIA560B2 0020252 OPER2 WEST PALM BEACH US L11556537 5615852853 FL S 33405 10.00 20050517 00231214 CHK Y Y 2017-02-06T10:15:13.503-05:00 PD 20050518
20140403 FIA550B6 0139463 OPER2 BARN 14092-1 00631488 2014 139463 732243 20140403 FIA560B2 0141270 OPER2 11 P ATLANTA US 580436120 GA V 303485503 5359.49 20140402 00727476 CHK Y 2017-02-06T10:16:09.101-05:00 PD 20140403
20090302 FIA550B6 0201413 OPER2 BARN 09058-1 00442932 2009 201413 399095 20090302 FIA560B2 0202145 OPER2 9 P DALLAS US 742225928 TX V 753951610 4195.54 20090227 00396828 CHK Y 2017-02-06T10:15:31.692-05:00 PD 20090302
20110523 FIA550B6 0316001 OPER2 BARN 11139-2 201404 3570 VS 000000000077617 2011 316001 535116 20110523 FIA560B1 0317330 OPER2 TEQUESTA US L13200449 5613394928 FL S 33469 277.30 20110519 00531814 CCR 2017-02-06T10:15:47.261-05:00 PD 20110523
20140717 FIA550B6 0159238 OPER2 BARN 14197-1 00636919 2015 159238 744307 20140717 FIA560B2 0205439 OPER2 1 B BELLE GLADE US 000004133 5619967307 FL V 33430 800.00 20140716 00739407 CHK Y 2017-02-06T10:16:10.459-05:00 PD 20140717
20051020 FIA550B6 0219250 OPER2 BARN 05292-1 00337513 2006 219250 254430 20051020 FIA560B2 0222484 OPER2 2 P TAMPA US T00000700 FL V 33620 180.00 20051019 00250734 CHK Y 2017-02-06T10:15:15.702-05:00 PD 20051020
20150213 FIA550B6 0352285 OPER2 BARN 15043-2 000000000112282 2015 352285 782217 20150213 FIA560B1 0356577 OPER2 267084199 1207480700000000 S WEST PALM BEACH US S13354055 FL S 33409 1159.58 20150212 00778450 EFT 2017-02-06T10:16:14.78-05:00 PD 20150213
20140926 FIA550B6 0320050 OPER2 BARN 14268-2 00639829 2015 320050 757451 20140926 FIA560B2 0325531 OPER2 BOYNTON BEACH US Y14481550 5613694504 FL S 33437 849.75 20140925 00749066 CHK Y 2017-02-06T10:16:11.987-05:00 PD 20140926
20021115 FIA550B6 0142381 OPER2 BARN 02318-3 00203358 2003 142381 130473 20021115 FIA560B7 0143204 OPER2 1 B WEST PALM BEACH US 650925828 5618209196 FL V 33401 5204.00 20021114 00128670 CHK Y 2017-02-06T10:15:01.725-05:00 PD 20021115
Powered by BI Documenter