DWStaging
 dbo.AP_CREDIT_MEMO (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_CREDIT_MEMO
  Properties
Property Value
Name AP_CREDIT_MEMO
Schema dbo
Row Count 960
Data Size 168 KB
Index Size 48 KB
Create Date 10/24/2012 9:40 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
 
CREDIT_AMOUNT
numeric(17, 2)
True
False
False
 
CREDIT_MEMO_NBR
varchar(6)
True
False
False
 
CREDIT_MEMO_REASON
varchar(2)
True
False
False
 
EXPIRE_DATE
varchar(8)
True
False
False
 
FISCAL_YEAR
varchar(4)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
INVOICE_NBR
varchar(25)
True
False
False
 
ISN_AP_CREDIT_MEMO
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
 
NOTE_IND
varchar(1)
True
False
False
 
ORIGIN
varchar(4)
True
False
False
 
PAY_TO_NAME
varchar(40)
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
 
PRIOR_YEAR_DATE
varchar(8)
True
False
False
 
PRIOR_YEAR_FLAG
varchar(1)
True
False
False
 
REF_NBR
varchar(12)
True
False
False
 
REF_TYPE
varchar(4)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STATUS
varchar(2)
True
False
False
 
VENDOR_CREDIT_MEMO_NBR
varchar(25)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AP_CREDIT_MEMO
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AP_CREDIT_MEMO depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AP_CREDIT_MEMO)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AP_CREDIT_MEMO] Script Date: 03/09/2017 16:44:50 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AP_CREDIT_MEMO](
    [ISN_AP_CREDIT_MEMO] [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,
    [CREDIT_MEMO_NBR] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CREDIT_MEMO_REASON] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [EXPIRE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIOR_YEAR_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PRIOR_YEAR_FLAG] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOTE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CREDIT_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](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INVOICE_NBR] [varchar](25) 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,
    [PAY_TO_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_CREDIT_MEMO_NBR] [varchar](25) 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 CREDIT_AMOUNT CREDIT_MEMO_NBR CREDIT_MEMO_REASON EXPIRE_DATE FISCAL_YEAR HOLD INVOICE_NBR ISN_AP_CREDIT_MEMO MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID NOTE_IND ORIGIN PAY_TO_NAME PAYEE_ADDR_SEQ_NBR PAYEE_ADDRESS_TYPE PAYEE_ID PAYEE_TYPE PRIOR_YEAR_DATE PRIOR_YEAR_FLAG REF_NBR REF_TYPE RowUpdatedOn STATUS VENDOR_CREDIT_MEMO_NBR
20041001 FIA136N1 0751288 E001609 45.95 000173 RT 2005 751351 168 20041001 FIA136N1 0751351 E001609 MEMO BARNES & NOBLE.COM 1 134027879 V 2005574 2017-02-06T11:25:34.765-05:00 PY
20070227 FIA136N1 1047072 E000343 28.68 000403 RT 2007 1047130 76559784 398 20070227 FIA136N1 1047130 E000343 PUR CORPORATE EXPRESS 1 841248716 V 200700003225 PO 2017-02-06T11:25:34.781-05:00 PY 76733729
20140821 FIA136N1 1451427 E057673 1914.00 000867 RT 2015 1452578 81494455 862 20140821 FIA136N1 1452578 E057673 MEMO BOUND TREE MEDICAL LLC 2 311739487 V 201500000461 2017-02-06T11:25:34.827-05:00 PY
20090819 FIA136N1 1505318 E032885 293.40 000612 RT 2010 1307055 5271540 607 20150623 FIA136N1 1307055 E057673 MEMO FISHER SCIENTIFIC CO LLC 3 232942737 V 200900004758 2017-02-06T11:25:34.812-05:00 CA
20130613 FIA136N1 1554385 E003843 34.97 000817 RT 2013 1555094 43875 812 20130613 FIA136N1 1555094 E003843 MEMO CHURCH & DWIGHT ORAL CARE 2 000003559 V 201300005737 2017-02-06T11:25:34.827-05:00 PY C44034
20140924 FIA136N1 1122273 E057673 2076.75 000877 RT 2015 1122445 062866/060507 872 20140924 FIA136N1 1122445 E057673 MEMO TGI OFFICE AUTOMATION, LLC 2 820575750 V 201400000384 2017-02-06T11:25:34.827-05:00 PY
20121108 FIA136N1 1716553 E003843 128.00 000780 OP 2013 1717209 WEB00072699 775 20121108 FIA136N1 1717209 E003843 MEMO ELSEVIER B.V. 3 131958712 V 201200001326 2017-02-06T11:25:34.827-05:00 PY WEB00072699C
20060323 FIA136N1 1258011 E000343 7.76 000332 RT 2006 1258162 68255705 327 20060323 FIA136N1 1258162 E000343 PUR CORPORATE EXPRESS 1 841248716 V 200600003912 PO 2017-02-06T11:25:34.781-05:00 PY 68449084
20121218 FIA136N1 1612382 E003843 106.00 000794 RT 2013 1613049 94424157 789 20121218 FIA136N1 1613049 E003843 MEMO SPORT SUPPLY GROUP, INC. 3 222795073 V 201200002721 2017-02-06T11:25:34.827-05:00 PY 94644060
20080414 FIA136N1 1450288 E042620 27.00 000498 RT 2008 1450495 86477531 493 20080414 FIA136N1 1450494 E042620 MEMO CORPORATE EXPRESS 1 841248716 V 20084284 2017-02-06T11:25:34.781-05:00 PY
Powered by BI Documenter