dbo.tbl_coo

Description

Properties

Name	Value
Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	31488
Created	4/5/2017 14:26:49
Last Modified	10/13/2019 19:26:41

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_coo_data	bigint	8	19	True	1 - 1	False	False
vendor	varchar	50	0	False		False	False
no_invoice	varchar	50	0	False		False	False
tgl_invoice	date	3	10	False		False	False
item_count	int	4	10	False		False	False
file_name	varchar	100	0	False		False	False
status_inv	varchar	50	0	False		False	False
type_bc	varchar	50	0	False		False	False
car	varchar	30	0	False		False	False
nobc	varchar	10	0	False		False	False
tglbc	date	3	10	False		False	False
nobl	varchar	50	0	False		False	False
tgbl	date	3	10	False		False	False
id_bc_in_hdr	bigint	8	19	False		False	False
upload_by	varchar	20	0	False		False	False
upload_date	date	3	10	False		False	False
SHIP_COMPANY	varchar	50	0	False		False	False
no_faktur	varchar	50	0	False		False	False
tgl_faktur	date	3	10	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_coo_data_1	id_coo_data	True

SQL Script

CREATE TABLE dbo.tbl_coo_data (
  id_coo_data bigint IDENTITY,
  vendor varchar(50) NULL,
  no_invoice varchar(50) NULL,
  tgl_invoice date NULL,
  item_count int NULL,
  file_name varchar(100) NULL,
  status_inv varchar(50) NULL,
  type_bc varchar(50) NULL,
  car varchar(30) NULL,
  nobc varchar(10) NULL,
  tglbc date NULL,
  nobl varchar(50) NULL,
  tgbl date NULL,
  id_bc_in_hdr bigint NULL,
  upload_by varchar(20) NULL,
  upload_date date NULL,
  SHIP_COMPANY varchar(50) NULL,
  no_faktur varchar(50) NULL,
  tgl_faktur date NULL,
  CONSTRAINT PK_tbl_coo_data_1 PRIMARY KEY CLUSTERED (id_coo_data)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_coo_data