dbo.tableOutSUAI

Description

Properties

Name	Value
Collation	SQL_Latin1_General_CP1_CI_AS
File Group
Filestream File Group
Is Partitioned
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	False
Full Text Catalog
Full Text
Compression
Row Count (~)
Created
Last Modified

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
nomorurut	bigint	8	19	0	True	1 - 1	False	False
urutgroup	int	4	10	0	False		False	False
sa_invoice_no	varchar	50	0	0	False		False	False
sa_invoice_date	datetime	8	23	3	False		False	False
order_no	varchar	50	0	0	False		False	False
etd_port_date	datetime	8	23	3	False		False	False
kind	varchar	255	0	0	False		False	False
wsize	varchar	50	0	0	False		False	False
article_code	varchar	255	0	0	False		False	False
qty_aju	decimal	9	18	4	False		False	False
qty_actual	decimal	9	18	4	False		False	False
outstanding	decimal	9	18	4	False		False	False
sa_invoice_no_aktual	varchar	50	0	0	False		False	False
sa_invoice_date_aktual	datetime	8	23	3	False		False	False
etd_port_date_aktual	datetime	8	23	3	False		False	False
order_no_aktual	varchar	50	0	0	False		False	False
kind_aktual	varchar	50	0	0	False		False	False
wsize_aktual	varchar	50	0	0	False		False	False
cust_part_aktual	varchar	50	0	0	False		False	False
qty_aktual	decimal	9	18	4	False		False	False
row_span	int	4	10	0	False		False	False

SQL Script

CREATE TYPE dbo.tableOutSUAI_BC25 AS TABLE (
  nomorurut bigint IDENTITY,
  urutgroup int NULL,
  sa_invoice_no varchar(50) NULL,
  sa_invoice_date datetime NULL,
  order_no varchar(50) NULL,
  etd_port_date datetime NULL,
  kind varchar(255) NULL,
  wsize varchar(50) NULL,
  article_code varchar(255) NULL,
  qty_aju decimal(18, 4) NULL,
  qty_actual decimal(18, 4) NULL,
  outstanding decimal(18, 4) NULL,
  sa_invoice_no_aktual varchar(50) NULL,
  sa_invoice_date_aktual datetime NULL,
  etd_port_date_aktual datetime NULL,
  order_no_aktual varchar(50) NULL,
  kind_aktual varchar(50) NULL,
  wsize_aktual varchar(50) NULL,
  cust_part_aktual varchar(50) NULL,
  qty_aktual decimal(18, 4) NULL,
  row_span int NULL,
  PRIMARY KEY CLUSTERED (nomorurut)
)
GO

Depends On

No items found

Used By

No items found