DWStaging
 dbo.AP_PAYABLE (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_PAYABLE
  Properties
Property Value
Name AP_PAYABLE
Schema dbo
Row Count 1499495
Data Size 310432 KB
Index Size 22400 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
 
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
 
CREATE_CHECK_PAYABLE
varchar(1)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INV_PICKUP_CHECK_IND
varchar(1)
True
False
False
 
INV_SEPARATE_CHECK_IND
varchar(1)
True
False
False
 
INVOICE_ITM_NBR
int(10, 0)
True
False
False
 
INVOICE_NBR
varchar(25)
True
False
False
 
ISN_AP_PAYABLE
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
 
ORIGIN
varchar(4)
True
False
False
 
PAY_AMOUNT
numeric(17, 2)
True
False
False
 
PAY_DATE
varchar(8)
True
False
False
 
PAY_REGARDLESS
varchar(1)
True
False
False
 
PAY_STATUS
varchar(2)
True
False
False
 
PAYABLE_NBR
varchar(8)
True
False
False
 
PAYEE_ADDR_SEQ_NBR
int(10, 0)
True
False
False
 
PAYEE_ADDRESS_TYPE
varchar(1)
True
False
False
 
PAYEE_ID
varchar(9)
True
False
False
 
PAYEE_TYPE
varchar(2)
True
False
False
 
PAYMENT_DATE
varchar(8)
True
False
False
 
PAYMENT_TYPE
varchar(3)
True
False
False
 
PAYMENT_XREF
varchar(12)
True
False
False
 
PICKUP_MAIL_CHECK_IND
varchar(1)
True
False
False
 
REF_NBR
varchar(19)
True
False
False
 
REF_TYPE
varchar(4)
True
False
False
 
RETAINAGE_IND
varchar(1)
True
False
False
 
RETAINAGE_PCT
numeric(17, 3)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
True
False
False
 
SEPERATE_CHECK_IND
varchar(1)
True
False
False
 
WITHHOLD_PAYABLE_IND
varchar(1)
True
False
False
 
WITHHOLD_PCT
numeric(17, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AP_PAYABLE
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AP_PAYABLE depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AP_PAYABLE)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AP_PAYABLE] Script Date: 03/09/2017 16:44:51 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AP_PAYABLE](
    [ISN_AP_PAYABLE] [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,
    [PAYABLE_NBR] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_AMOUNT] [numeric](17, 2) NULL,
    [ORIGIN] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_TYPE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REF_NBR] [varchar](19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INVOICE_NBR] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEPERATE_CHECK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PICKUP_MAIL_CHECK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_XREF] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_DATE] [varchar](8) 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,
    [RETAINAGE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INVOICE_ITM_NBR] [int] NULL,
    [RETAINAGE_PCT] [numeric](17, 3) NULL,
    [INV_SEPARATE_CHECK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INV_PICKUP_CHECK_IND] [varchar](1) 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,
    [PAY_REGARDLESS] [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,
    [CREATE_CHECK_PAYABLE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WITHHOLD_PAYABLE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [WITHHOLD_PCT] [numeric](17, 2) NULL,
    [CHARGE_GUID] [varchar](19) 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 CHARGE_EXP CHARGE_GUID CHARGE_NBR CHARGE_TYPE CREATE_CHECK_PAYABLE FISCAL_YEAR HOLD INV_PICKUP_CHECK_IND INV_SEPARATE_CHECK_IND INVOICE_NBR ISN_AP_PAYABLE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID ORIGIN PAY_AMOUNT PAY_DATE PAY_REGARDLESS PAY_STATUS PAYABLE_NBR PAYEE_ADDR_SEQ_NBR PAYEE_ADDRESS_TYPE PAYEE_ID PAYEE_TYPE PAYMENT_DATE PAYMENT_TYPE PAYMENT_XREF PICKUP_MAIL_CHECK_IND REF_NBR REF_TYPE RETAINAGE_IND RowUpdatedOn SEPERATE_CHECK_IND WITHHOLD_PAYABLE_IND
20120127 FIA135N1 0104404 OPER2 12026-2 2012 104404 000000068/33 1044800 20120127 FIA550B9 0129371 OPER2 STUD 750.00 20120126 PD 00062232 S06814362 S 20120127 EFT 201200586685 2012005975942001002 FIND 2017-02-06T10:03:05.165-05:00
20140124 FIA135N1 0218129 OPER2 14023-2 2014 218129 000000576/11 1246035 20140124 FIA550B9 0311195 OPER2 STUD 2226.00 20140123 PD 00062209 B11343555 S 20140124 EFT 201400713109 2014006233193001002 FIND 2017-02-06T10:03:29.611-05:00
20060922 FIA135N1 0105550 OPER2 06265-1 2007 105550 Term:20071 560227 20060925 FIA550B9 0904268 OPER2 STUD 499.00 20060922 PD 00016914 S08484354 S 20060925 CHK 200700287146 2007000690579001002 RFND 2017-02-06T10:02:07.055-05:00
20131202 FIA135N1 1515197 E057673 13336-1 2014 1515197 1314-6838 1231856 20131203 FIA550B9 0112348 OPER1 DSBR 6.25 20131114 PD 00045189 1 420000000 V 20131203 CHK 201400703939 2014002428 RQ 2017-02-06T10:03:27.801-05:00
20060518 FIA135N1 0446415 OPER2 06137-4 200902 8644 VS 2006 446415 Term:20063 533297 20060518 FIA550B9 0449570 OPER2 STUD 43.56 20060518 PD 00067344 G12312856 S 20060518 CCR 200600272412 2006000465984001006 RFND 2017-02-06T10:02:03.888-05:00 Y
20090403 FIA135N1 0038009 OPER2 09092-2 2009 38009 000000040/17 765923 20090403 FIA550B9 0057315 OPER2 STUD 1113.75 20090402 PD 00065863 A12020061 S 20090403 CHK 200900400176 2009002930385001007 FIND 2017-02-06T10:02:31.75-05:00
20161118 FIA135N1 0105226 OPER2 16322-2 2017 105226 000000575/19 1493802 20161118 FIA550B9 0120321 OPER2 STUD 1015.00 20161117 PD 00034448 J14422935 S 20161118 EFT 201700887724 2017006576591001005 FIND 2017-02-06T10:04:01.076-05:00
20120814 FIA135N1 1532175 E057673 12227-1 2013 1532175 0796 1092392 20120815 FIA550B9 0100301 OPER2 DSBR 14.24 20120814 PD 00005914 000047811 E 20120815 EFT 201300613155 2013000796 TV 2017-02-06T10:03:11.015-05:00 Y
20061117 FIA135N1 0124157 OPER2 06320-4 200709 1794 VS 2007 124157 Term:20071 571030 20061117 FIA550B9 0124581 OPER2 STUD 800.00 20061117 PD 00029457 S12029658 S 20061117 CCR 200700294208 2007000700541001007 RFND 2017-02-06T10:02:08.303-05:00 Y
20040416 FIA135N1 1251473 E003651 04107-1 2004 1251473 GA PO#00342 368069 20040419 FIA550B9 0129281 OPER2 DSBR 881.64 20040416 PD 00060412 1 066033492 V 20040419 CHK 200400185343 Y 2004005305 RQ 2017-02-06T10:01:44.341-05:00
Powered by BI Documenter