dbo.xtbl_tpb

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 (~)	21327
Created	6/25/2019 13:06:44
Last Modified	6/25/2019 13:06:44

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
id	bigint	8	19	True	False	False
NOMOR_AJU	varchar	250	0	False	False	False
TANGGAL_AJU	date	3	10	False	False	False
NOMOR_DAFTAR	varchar	250	0	False	False	False
TANGGAL_DAFTAR	date	3	10	False	False	False
KODE_DOKUMEN_PABEAN	varchar	250	0	False	False	False
NAMA_PEMASOK	varchar	250	0	False	False	False
NAMA_PENGIRIM	varchar	250	0	False	False	False
NAMA_PENERIMA_BARANG	varchar	250	0	False	False	False
CIF	float	8	53	False	False	False
CIF_RUPIAH	float	8	53	False	False	False
FOB	float	8	53	False	False	False
FREIGHT	float	8	53	False	False	False
HARGA_INVOICE	float	8	53	False	False	False
HARGA_PENYERAHAN	float	8	53	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_xtbl_tpb_hdr	id	True

SQL Script

CREATE TABLE dbo.xtbl_tpb_hdr (
  id bigint NOT NULL,
  NOMOR_AJU varchar(250) NULL,
  TANGGAL_AJU date NULL,
  NOMOR_DAFTAR varchar(250) NULL,
  TANGGAL_DAFTAR date NULL,
  KODE_DOKUMEN_PABEAN varchar(250) NULL,
  NAMA_PEMASOK varchar(250) NULL,
  NAMA_PENGIRIM varchar(250) NULL,
  NAMA_PENERIMA_BARANG varchar(250) NULL,
  CIF float NULL,
  CIF_RUPIAH float NULL,
  FOB float NULL,
  FREIGHT float NULL,
  HARGA_INVOICE float NULL,
  HARGA_PENYERAHAN float NULL,
  CONSTRAINT PK_xtbl_tpb_hdr PRIMARY KEY CLUSTERED (id)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found