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 (~) | 13 |
| Created | 10/8/2016 12:25:27 |
| Last Modified | 11/18/2016 22:44:25 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
bc_type_id | int | 4 | 10 | 0 | True |
False |
False |
||||
| bc_type_name | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| x | int | 4 | 10 | 0 | False |
False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
|
PK_enum_bc_type | bc_type_id | True |
SQL Script
CREATE TABLE dbo.enum_bc_type (
bc_type_id int NOT NULL,
bc_type_name varchar(50) NULL,
x int NULL,
CONSTRAINT PK_enum_bc_type PRIMARY KEY CLUSTERED (bc_type_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
bc_type_id int NOT NULL,
bc_type_name varchar(50) NULL,
x int NULL,
CONSTRAINT PK_enum_bc_type PRIMARY KEY CLUSTERED (bc_type_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
Depends On
No items found
Used By
26- dbo.vw_interface_module
- dbo.MG_ALL_ENUM_DATA
- dbo.MG_DATA_INTERFACE_MODULE_DEKSTOP_REGISTER
- dbo.MG_PEMI_RPT_261
- dbo.MG_PEMI_RPT_262
- dbo.MG_PEMI_RPT_BC23
- dbo.MG_PEMI_RPT_BC25
- dbo.MG_PEMI_RPT_BC27_IN
- dbo.MG_PEMI_RPT_BC27_OUT
- dbo.MG_PEMI_RPT_BC30
- dbo.MG_PEMI_RPT_BC40
- dbo.MG_PEMI_RPT_BC41
- dbo.MG_PEMI_RPT_DEVISA
- dbo.MG_PEMI_RPT_KB_DPIL
- dbo.MG_PEMI_RPT_KB_EKONOMI
- dbo.MG_PEMI_RPT_KB_EKSPOR
- dbo.MG_PEMI_RPT_KB_KB
- dbo.MG_PEMI_RPT_PENGANTAR
- dbo.MG_PEMI_RPT_REKAP
- dbo.MG_PEMI_RPT_RETURN
- dbo.MG_PEMI_RPT_rpMonthlyIncoming_BC23
- dbo.MG_PEMI_RPT_rpMonthlyOutgoing_BC30
- dbo.RPT_DYNAMIC_BARANG_PER_DOKUMENT_IN
- dbo.RPT_DYNAMIC_BARANG_PER_DOKUMENT_IN_AW_2340
- dbo.RPT_DYNAMIC_BARANG_PER_DOKUMENT_IN_AW_2340_FIX
- dbo.RPT_DYNAMIC_BARANG_PER_DOKUMENT_OUT