DWStaging
 dbo.FIP_RA (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.FIP_RA
  Properties
Property Value
Name FIP_RA
Schema dbo
Row Count 3
Data Size 8 KB
Index Size 24 KB
Create Date 10/24/2012 3:19 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
 
BILL_OF_LADING
varchar(15)
True
False
False
 
BUYER_ID
varchar(3)
True
False
False
 
CARRIER_NAME
varchar(30)
True
False
False
 
CLOSE_DATE
varchar(8)
True
False
False
 
DELIVERY_DATE
varchar(8)
True
False
False
 
DEPARTMENT_NAME
varchar(40)
True
False
False
 
DET_ITM_NBR
int(10, 0)
True
False
False
 
DET_RA_NUMBER
varchar(15)
True
False
False
 
DET_SEQ_NBR
int(10, 0)
True
False
False
 
DET_STATUS
varchar(2)
True
False
False
 
DET_YEAR_REF_NBR
varchar(12)
True
False
False
 
DISPOSITION_CREDIT/REFUND_IND
varchar(1)
True
False
False
 
DISPOSITION_DENIED
varchar(1)
True
False
False
 
DISPOSITION_DISPOSE
varchar(1)
True
False
False
 
DISPOSITION_OTHER
varchar(1)
True
False
False
 
DISPOSITION_REPLACE
varchar(1)
True
False
False
 
ENTRY_DATE
varchar(8)
True
False
False
 
HDR_RA_NUMBER
varchar(15)
True
False
False
 
HDR_SEQ_NBR
int(10, 0)
True
False
False
 
HDR_STATUS
varchar(2)
True
False
False
 
HDR_YEAR_REF_NBR
varchar(12)
True
False
False
 
HOLD
int(10, 0)
True
False
False
 
ISN_FIP_RA
int(10, 0)
False
False
False
 
MAINT_DATE
varchar(8)
True
False
False
 
MAINT_TIME
varchar(7)
True
False
False
 
MAINT_USER_ID
varchar(8)
True
False
False
 
NOTES_FOR_RETURN
varchar(1)
True
False
False
 
PACKING_LIST
varchar(15)
True
False
False
 
PURCHASING_DATE
varchar(8)
True
False
False
 
QTY_DAMAGED
numeric(17, 4)
True
False
False
 
QTY_NOT_TO_SPEC
numeric(17, 4)
True
False
False
 
QTY_OTHER
numeric(17, 4)
True
False
False
 
QTY_OVERSHIP
numeric(17, 4)
True
False
False
 
QTY_RECEIVED
numeric(17, 4)
True
False
False
 
QTY_RETURNED
numeric(17, 4)
True
False
False
 
RA_ACCOUNT
varchar(25)
True
False
False
 
RA_PRINT_DATE
varchar(8)
True
False
False
 
RA_SHIP_DATE
varchar(8)
True
False
False
 
RECEIVER_ID
varchar(8)
True
False
False
 
RECEIVING_INSTANCE
varchar(18)
True
False
False
 
REQUESTOR_NAME
varchar(40)
True
False
False
 
REQUESTOR_PHONE
varchar(15)
True
False
False
 
RETURN_ADDR_CODE
varchar(2)
True
False
False
 
RETURN_COST
numeric(17, 2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SHIPPER_NAME
varchar(30)
True
False
False
 
TOTAL_RETURN_COST
numeric(17, 2)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_FIP_RA
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.FIP_RA depends on)
Name Type
  Child Dependencies (objects that depend on dbo.FIP_RA)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[FIP_RA] Script Date: 03/09/2017 16:45:27 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FIP_RA](
    [ISN_FIP_RA] [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,
    [HOLD] [int] NULL,
    [DET_YEAR_REF_NBR] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_SEQ_NBR] [int] NULL,
    [DET_ITM_NBR] [int] NULL,
    [QTY_RETURNED] [numeric](17, 4) NULL,
    [QTY_DAMAGED] [numeric](17, 4) NULL,
    [QTY_NOT_TO_SPEC] [numeric](17, 4) NULL,
    [QTY_OTHER] [numeric](17, 4) NULL,
    [QTY_OVERSHIP] [numeric](17, 4) NULL,
    [QTY_RECEIVED] [numeric](17, 4) NULL,
    [RETURN_COST] [numeric](17, 2) NULL,
    [DISPOSITION_CREDIT/REFUND_IND] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISPOSITION_DENIED] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISPOSITION_DISPOSE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISPOSITION_REPLACE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DISPOSITION_OTHER] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_RA_NUMBER] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DET_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVING_INSTANCE] [varchar](18) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HDR_YEAR_REF_NBR] [varchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HDR_SEQ_NBR] [int] NULL,
    [HDR_RA_NUMBER] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [HDR_STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RECEIVER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BUYER_ID] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUESTOR_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUESTOR_PHONE] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DEPARTMENT_NAME] [varchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RA_ACCOUNT] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RETURN_ADDR_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ENTRY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CLOSE_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [DELIVERY_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PURCHASING_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RA_PRINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RA_SHIP_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [NOTES_FOR_RETURN] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TOTAL_RETURN_COST] [numeric](17, 2) NULL,
    [CARRIER_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SHIPPER_NAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [BILL_OF_LADING] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [PACKING_LIST] [varchar](15) 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 BILL_OF_LADING BUYER_ID CARRIER_NAME CLOSE_DATE DELIVERY_DATE DEPARTMENT_NAME DET_ITM_NBR DET_RA_NUMBER DET_SEQ_NBR DET_STATUS DET_YEAR_REF_NBR DISPOSITION_CREDIT/REFUND_IND DISPOSITION_DENIED DISPOSITION_DISPOSE DISPOSITION_OTHER DISPOSITION_REPLACE ENTRY_DATE HDR_RA_NUMBER HDR_SEQ_NBR HDR_STATUS HDR_YEAR_REF_NBR HOLD ISN_FIP_RA MAINT_DATE MAINT_TIME MAINT_USER_ID NOTES_FOR_RETURN PACKING_LIST PURCHASING_DATE QTY_OVERSHIP QTY_RETURNED RA_ACCOUNT RA_PRINT_DATE RA_SHIP_DATE RECEIVER_ID RECEIVING_INSTANCE REQUESTOR_NAME REQUESTOR_PHONE RETURN_ADDR_CODE RETURN_COST RowUpdatedOn SHIPPER_NAME TOTAL_RETURN_COST
DLW JEN FRANK 19990505 1 CA 199900196197 1535549 1 000 JEN FRANK 3674573 2017-02-06T11:32:39.79-05:00
FNS 20051116 LISA RAPPA / MATH DEPT 20051116 N/A 1 CM 200600000112 1359049 2 N/A 20051116 20051116 LISA W RAPPA/SLC DEPT 5612075206 2017-02-06T11:32:39.79-05:00 N/A 96.90
1 1 OP 200600000112 Y 1358021 3 57.0000 57.0000 200600000112001001 96.90 2017-02-06T11:32:39.79-05:00
Powered by BI Documenter