dbo.tblbc261_perhitungan_exim_asal

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 (~)	6187
Created	10/14/2014 16:46:49
Last Modified	11/18/2016 22:50:39

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_bc261_bc_asal	bigint	8	19	True	1 - 1	False	False
id_bc261_exim_dtl	bigint	8	19	True		False	False
id_bc261_exim_hdr	bigint	8	19	True		False	False
qty_modul	float	8	53	False		False	False
qty_dipakai	float	8	53	False		False	False
harga_satuan	float	8	53	False		False	False
total_usd	float	8	53	False		False	False
nilai_pabean	float	8	53	False		False	False
ex_aju	varchar	50	0	False		False	False
ex_nodaft	varchar	50	0	False		False	False
ex_tgdaft	date	3	10	False		False	False
ex_nourut	int	4	10	False		False	False
hs	varchar	50	0	False		False	False
bm	float	8	53	False		False	False
ppn	float	8	53	False		False	False
pph	float	8	53	False		False	False
vendor	varchar	50	0	False		False	False
assy_code	varchar	50	0	False		False	False
assy_name	varchar	150	0	False		False	False
part_name_customs	varchar	50	0	False		False	False
part_number	varchar	50	0	False		False	False
kode_barang	varchar	50	0	False		False	False
no_aju	varchar	50	0	False		False	False
tg_aju	date	3	10	False		False	False
status_data	varchar	50	0	False		False	False
id_bc_out_hdr	bigint	8	19	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tblbc261_perhitungan_exim_asal_bc	id_bc261_bc_asal	True

SQL Script

CREATE TABLE dbo.tblbc261_perhitungan_exim_asal_bc (
  id_bc261_bc_asal bigint IDENTITY,
  id_bc261_exim_dtl bigint NOT NULL,
  id_bc261_exim_hdr bigint NOT NULL,
  qty_modul float NULL,
  qty_dipakai float NULL,
  harga_satuan float NULL,
  total_usd float NULL,
  nilai_pabean float NULL,
  ex_aju varchar(50) NULL,
  ex_nodaft varchar(50) NULL,
  ex_tgdaft date NULL,
  ex_nourut int NULL,
  hs varchar(50) NULL,
  bm float NULL,
  ppn float NULL,
  pph float NULL,
  vendor varchar(50) NULL,
  assy_code varchar(50) NULL,
  assy_name varchar(150) NULL,
  part_name_customs varchar(50) NULL,
  part_number varchar(50) NULL,
  kode_barang varchar(50) NULL,
  no_aju varchar(50) NULL,
  tg_aju date NULL,
  status_data varchar(50) NULL,
  id_bc_out_hdr bigint NULL,
  CONSTRAINT PK_tblbc261_perhitungan_exim_asal_bc PRIMARY KEY CLUSTERED (id_bc261_bc_asal) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found