dbo.tbl_data_alatkantor_bc27

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 (~)	0
Created	8/12/2017 13:09:42
Last Modified	8/12/2017 13:09:42

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_ak_27_in	bigint	8	19	0	True	1 - 1	False	False
no_bc	varchar	55	0	0	False		False	False
tgl_bc	date	3	10	0	False		False	False
no_doc_in	varchar	55	0	0	False		False	False
doc_in_date	date	3	10	0	False		False	False
kode_pengirim	varchar	55	0	0	False		False	False
kode_barang	varchar	55	0	0	False		False	False
nama_barang	varchar	70	0	0	False		False	False
satuan	varchar	5	0	0	False		False	False
jumlah	float	8	53	0	False		False	False
kdval	varchar	5	0	0	False		False	False
nilai_barang	float	8	53	0	False		False	False
bruto	float	8	53	0	False		False	False
jm_kemas	float	8	53	0	False		False	False
jn_kemas	varchar	5	0	0	False		False	False
no_invoice	varchar	50	0	0	False		False	False
tgl_inv	date	3	10	0	False		False	False
kpbc	varchar	10	0	0	False		False	False
nama_pengirim	varchar	100	0	0	False		False	False
npwp	varchar	30	0	0	False		False	False
status_data	varchar	30	0	0	False		False	False
create_date	datetime	8	23	3	False		False	False
create_by	varchar	50	0	0	False		False	False
update_date	datetime	8	23	3	False		False	False
update_by	varchar	50	0	0	False		False	False
filename	varchar	255	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__tbl_data__0CC66DC10E10D11A	id_ak_27_in	True

SQL Script

CREATE TABLE dbo.tbl_data_alatkantor_bc27_in (
  id_ak_27_in bigint IDENTITY,
  no_bc varchar(55) NULL,
  tgl_bc date NULL,
  no_doc_in varchar(55) NULL,
  doc_in_date date NULL,
  kode_pengirim varchar(55) NULL,
  kode_barang varchar(55) NULL,
  nama_barang varchar(70) NULL,
  satuan varchar(5) NULL,
  jumlah float NULL,
  kdval varchar(5) NULL,
  nilai_barang float NULL,
  bruto float NULL,
  jm_kemas float NULL,
  jn_kemas varchar(5) NULL,
  no_invoice varchar(50) NULL,
  tgl_inv date NULL,
  kpbc varchar(10) NULL,
  nama_pengirim varchar(100) NULL,
  npwp varchar(30) NULL,
  status_data varchar(30) NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  filename varchar(255) NULL,
  PRIMARY KEY CLUSTERED (id_ak_27_in)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found