dbo.tblEksportir

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	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	1
Created	2/22/2013 00:56:03
Last Modified	2/22/2013 00:56:03

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
IdEks	varchar	1	0	True	False	False
NpwpEks	varchar	15	0	True	False	False
NamaEks	varchar	50	0	True	False	False
AlmtEks	varchar	70	0	True	False	False
TelpEks	varchar	20	0	False	False	False
FaxEks	varchar	15	0	False	False	False
NoSiup	varchar	30	0	False	False	False
TgSiup	date	3	10	False	False	False
JnPerus	varchar	1	0	False	False	False
NoTdp	varchar	30	0	False	False	False
TgTdp	date	3	10	False	False	False
TtdPeb	varchar	30	0	False	False	False
Niper	varchar	4	0	False	False	False
StatusH	varchar	2	0	False	False	False
NoMou	varchar	50	0	False	False	False
TgMou	date	3	10	False	False	False
JnKons	varchar	1	0	False	False	False
NoKonsolidator	varchar	30	0	False	False	False
TgKonsolidator	date	3	10	False	False	False

SQL Script

CREATE TABLE dbo.tblEksportir (
  IdEks varchar(1) NOT NULL,
  NpwpEks varchar(15) NOT NULL,
  NamaEks varchar(50) NOT NULL,
  AlmtEks varchar(70) NOT NULL,
  TelpEks varchar(20) NULL,
  FaxEks varchar(15) NULL,
  NoSiup varchar(30) NULL,
  TgSiup date NULL,
  JnPerus varchar(1) NULL,
  NoTdp varchar(30) NULL,
  TgTdp date NULL,
  TtdPeb varchar(30) NULL,
  Niper varchar(4) NULL,
  StatusH varchar(2) NULL,
  NoMou varchar(50) NULL,
  TgMou date NULL,
  JnKons varchar(1) NULL,
  NoKonsolidator varchar(30) NULL,
  TgKonsolidator date NULL
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found