DWStaging
 dbo.AP_INVOICE (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_INVOICE
  Properties
Property Value
Name AP_INVOICE
Schema dbo
Row Count 810344
Data Size 129400 KB
Index Size 12112 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
 
ADDRESS_TYPE_CODE
varchar(1)
True
False
False
 
AMT_ACCRUED
numeric(17, 2)
True
False
False
 
AMT_PAYABLE
numeric(17, 2)
True
False
False
 
ATTACHMENT_IND
varchar(1)
True
False
False
 
DET_INVOICE_NBR
varchar(25)
True
False
False
 
DET_STATUS
varchar(2)
True
False
False
 
DET_YR_REF_ITM_NBR
varchar(15)
True
False
False
 
DISCOUNT_AMT
numeric(17, 2)
True
False
False
 
DUE_DATE
varchar(8)
True
False
False
 
FOB_TERMS
varchar(3)
True
False
False
 
FREIGHT_ACCRUED
numeric(17, 2)
True
False
False
 
FREIGHT_AMT
numeric(17, 2)
True
False
False
 
FREIGHT_PAYABLE
numeric(17, 2)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
HOLD_PAYMENT
varchar(1)
True
False
False
 
INVOICE_DATE
varchar(8)
True
False
False
 
INVOICE_ITM_NBR
int(10, 0)
True
False
False
 
INVOICE_NBR
varchar(25)
True
False
False
 
INVOICE_NOTE_IND
varchar(1)
True
False
False
 
ISN_AP_INVOICE
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
 
PAY_AMT
numeric(17, 2)
True
False
False
 
PAY_AMT_INVOICE
numeric(17, 2)
True
False
False
 
PAY_DATE
varchar(8)
True
False
False
 
PAYMENT_TERMS
varchar(2)
True
False
False
 
PICKUP_CHECK_IND
varchar(1)
True
False
False
 
PO_YR_REF_NBR
varchar(12)
True
False
False
 
QTY_ACCRUED
numeric(17, 4)
True
False
False
 
QTY_INVOICED
numeric(17, 4)
True
False
False
 
QTY_PAYABLE
numeric(17, 4)
True
False
False
 
RETAIN_AMT
numeric(17, 2)
True
False
False
 
RETAIN_PCT
numeric(17, 4)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SEPARATE_CHECK_IND
varchar(1)
True
False
False
 
SIGNATURE_PRESENT_IND
varchar(1)
True
False
False
 
STATUS
varchar(2)
True
False
False
 
TOTAL_AMT_ACCRUED
numeric(17, 2)
True
False
False
 
TOTAL_AMT_PAYABLE
numeric(17, 2)
True
False
False
 
TOTAL_PAY_AMT
numeric(17, 2)
True
False
False
 
USER_REQ_WITHHOLD
varchar(1)
True
False
False
 
VENDOR_ADDRESS_SEQ
varchar(13)
True
False
False
 
WITHHOLD_IND
varchar(1)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_AP_INVOICE
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.AP_INVOICE depends on)
Name Type
  Child Dependencies (objects that depend on dbo.AP_INVOICE)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[AP_INVOICE] Script Date: 03/09/2017 16:44:50 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[AP_INVOICE](
    [ISN_AP_INVOICE] [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,
    [PO_YR_REF_NBR] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INVOICE_NBR] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INVOICE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_ADDRESS_SEQ] [varchar](13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDRESS_TYPE_CODE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DUE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAYMENT_TERMS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [FOB_TERMS] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PAY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HOLD_PAYMENT] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ATTACHMENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOTAL_PAY_AMT] [numeric](17, 2) NULL,
    [TOTAL_AMT_PAYABLE] [numeric](17, 2) NULL,
    [TOTAL_AMT_ACCRUED] [numeric](17, 2) NULL,
    [DET_YR_REF_ITM_NBR] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_INVOICE_NBR] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [INVOICE_ITM_NBR] [int] NULL,
    [DET_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [QTY_INVOICED] [numeric](17, 4) NULL,
    [QTY_PAYABLE] [numeric](17, 4) NULL,
    [QTY_ACCRUED] [numeric](17, 4) NULL,
    [PAY_AMT] [numeric](17, 2) NULL,
    [AMT_PAYABLE] [numeric](17, 2) NULL,
    [AMT_ACCRUED] [numeric](17, 2) NULL,
    [FREIGHT_AMT] [numeric](17, 2) NULL,
    [FREIGHT_PAYABLE] [numeric](17, 2) NULL,
    [FREIGHT_ACCRUED] [numeric](17, 2) NULL,
    [DISCOUNT_AMT] [numeric](17, 2) NULL,
    [PAY_AMT_INVOICE] [numeric](17, 2) NULL,
    [INVOICE_NOTE_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SEPARATE_CHECK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SIGNATURE_PRESENT_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PICKUP_CHECK_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RETAIN_PCT] [numeric](17, 4) NULL,
    [RETAIN_AMT] [numeric](17, 2) NULL,
    [WITHHOLD_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [USER_REQ_WITHHOLD] [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 ADDRESS_TYPE_CODE AMT_PAYABLE ATTACHMENT_IND DET_INVOICE_NBR DET_STATUS DET_YR_REF_ITM_NBR DUE_DATE FOB_TERMS HOLD HOLD_PAYMENT INVOICE_DATE INVOICE_ITM_NBR INVOICE_NBR INVOICE_NOTE_IND ISN_AP_INVOICE MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID PAY_AMT PAY_DATE PAYMENT_TERMS PICKUP_CHECK_IND PO_YR_REF_NBR QTY_INVOICED QTY_PAYABLE RowUpdatedOn SEPARATE_CHECK_IND SIGNATURE_PRESENT_IND STATUS TOTAL_AMT_PAYABLE TOTAL_PAY_AMT USER_REQ_WITHHOLD VENDOR_ADDRESS_SEQ WITHHOLD_IND
20100416 FIA127N1 1422501 E001609 54.00 1004098 CM 201000004745003 1422501 3 555279 20100416 FIA310N1 1423095 E001609 54.00 3.0000 2017-02-06T10:25:05.012-05:00
20150527 FIA127N1 1003165 E057673 2305.00 196556HAM5/8/15 CM 201500005061001 1003165 1 751217 20150527 FIA310N1 1003191 E057673 2305.00 1.0000 2017-02-06T10:25:33.482-05:00
20041019 FIA127N1 0843221 E002800 4.70 55663160 CM 200500002046003 843221 3 314601 20041019 FIA310N1 0843269 E002800 4.70 2.0000 2.0000 2017-02-06T10:24:29.865-05:00
20001114 FIA127N1 0735026 MTAYLOR 15.38 03134926-001-03_11/2 CM 200100205954001 735047 1 93280 20001114 FIA127N1 0735047 MTAYLOR 15.38 1.0000 2017-02-06T10:23:58.368-05:00
20060908 FIA127N1 1219304 E001609 82.96 15356633 CM 200700000410032 1219304 32 403362 20060908 FIA310N1 1225116 E001609 82.96 2.0000 2.0000 2017-02-06T10:24:42.719-05:00
20030729 FIA127N1 0943551 E002800 170.00 44780434 CM 200400000516016 943551 16 241868 20030729 FIA310N1 0944198 E002800 170.00 40.0000 40.0000 2017-02-06T10:24:19.771-05:00
20000111 FIA126N1 1400407 MTAYLOR B 20000111 DES 1400503 19991213 2000249 50764 20000111 FIA126N1 1400503 MTAYLOR 20000111 30 200002000249 2017-02-06T10:23:52.393-05:00 CM 20.80 20.80 5912160000002
20081210 FIA126N1 1519289 E032885 P 20081210 DES 1519387 20081203 92041978 498885 20081210 FIA126N1 1519387 E032885 20081210 30 200900002748 2017-02-06T10:24:56.572-05:00 CM 79.71 79.71 8412487160001
20081002 FIA127N1 1217021 E032885 38.64 ISR65108701 CM 200900000818143 1217021 142 491019 20081002 FIA310N1 1217234 E032885 38.64 12.0000 12.0000 2017-02-06T10:24:55.433-05:00
20090114 FIA126N1 1348505 E032885 P 20090114 DES 1348590 20090112 22-706353 502230 20090114 FIA126N1 1348590 E032885 20090114 30 200900000407 2017-02-06T10:24:57.071-05:00 Y CM 26.37 26.37 5917328910005
Powered by BI Documenter