dbo.APP_SETTING

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	10/8/2016 12:25:26
Last Modified	10/8/2016 12:25:26

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
SEDANG_CREATE_PERIODE	bit	1	1	0	False	False	False
CREATE_PERIODE_DATE	datetime	8	23	3	False	False	False
CREATE_PERIODE_INFO	varchar	2000	0	0	False	False	False
APP_NAME	varchar	2000	0	0	False	False	False
PT_NAME	varchar	2000	0	0	False	False	False
ALAMAT_PT	varchar	2000	0	0	False	False	False
SEDANG_STOCK_OPNAME	bit	1	1	0	False	False	False
PERIODE_AKTIF	bigint	8	19	0	False	False	False
PERIODE_OLD	bigint	8	19	0	False	False	False
PREPARE_CLOSING_PERIODE	bit	1	1	0	False	False	False
PREPARE_STOCK_OPNAME	bit	1	1	0	False	False	False

SQL Script

CREATE TABLE dbo.APP_SETTING (
  SEDANG_CREATE_PERIODE bit NULL,
  CREATE_PERIODE_DATE datetime NULL,
  CREATE_PERIODE_INFO varchar(2000) NULL,
  APP_NAME varchar(2000) NULL,
  PT_NAME varchar(2000) NULL,
  ALAMAT_PT varchar(2000) NULL,
  SEDANG_STOCK_OPNAME bit NULL,
  PERIODE_AKTIF bigint NULL,
  PERIODE_OLD bigint NULL,
  PREPARE_CLOSING_PERIODE bit NULL,
  PREPARE_STOCK_OPNAME bit NULL
)
ON [PRIMARY]
GO

Depends On

No items found