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 (~) | 0 |
| Created | 1/9/2013 07:01:46 |
| Last Modified | 11/18/2016 23:31:45 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
id_po_lokal | bigint | 8 | 19 | 0 | True |
1 - 1 | False |
False |
|||
| PO_NO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NAME_perush | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ADDRESS | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| CITY | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NPWP | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NPWP_PENGUSAHA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ALAMAT_PENGUSAHA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NO_IZIN_TPB | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| INVOICE | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TGL_INVOICE | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| HARGA_PENYERAHAN_TOTAL | float | 8 | 53 | 0 | False |
False |
False |
|||||
| JENIS_KEMASAN | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| JUMLAH_KEMASAN | float | 8 | 53 | 0 | False |
False |
False |
|||||
| TANGGAL_KIRIM | varchar | 50 | 0 | 0 | False |
False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
tbl_po_lokal_hdr_uq | id_po_lokal | True |
SQL Script
CREATE TABLE dbo.tbl_po_lokal_hdr (
id_po_lokal bigint IDENTITY,
PO_NO varchar(50) NULL,
NAME_perush varchar(50) NULL,
ADDRESS varchar(100) NULL,
CITY varchar(50) NULL,
NPWP varchar(50) NULL,
NPWP_PENGUSAHA varchar(50) NULL,
ALAMAT_PENGUSAHA varchar(50) NULL,
NO_IZIN_TPB varchar(50) NULL,
INVOICE varchar(50) NULL,
TGL_INVOICE varchar(50) NULL,
HARGA_PENYERAHAN_TOTAL float NULL,
JENIS_KEMASAN varchar(50) NULL,
JUMLAH_KEMASAN float NULL,
TANGGAL_KIRIM varchar(50) NULL,
CONSTRAINT tbl_po_lokal_hdr_uq UNIQUE (id_po_lokal) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
id_po_lokal bigint IDENTITY,
PO_NO varchar(50) NULL,
NAME_perush varchar(50) NULL,
ADDRESS varchar(100) NULL,
CITY varchar(50) NULL,
NPWP varchar(50) NULL,
NPWP_PENGUSAHA varchar(50) NULL,
ALAMAT_PENGUSAHA varchar(50) NULL,
NO_IZIN_TPB varchar(50) NULL,
INVOICE varchar(50) NULL,
TGL_INVOICE varchar(50) NULL,
HARGA_PENYERAHAN_TOTAL float NULL,
JENIS_KEMASAN varchar(50) NULL,
JUMLAH_KEMASAN float NULL,
TANGGAL_KIRIM varchar(50) NULL,
CONSTRAINT tbl_po_lokal_hdr_uq UNIQUE (id_po_lokal) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
Depends On
No items found
Used By
No items found