dbo.tbl_po_lokal

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:13:26
Last Modified	11/18/2016 23:31:46

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_po_lokal_dtl	bigint	8	19	True	1 - 1	False	False
id_po_lokal_hdr	bigint	8	19	False		False	False
PO_NO	varchar	50	0	False		False	False
PART_NAME	varchar	50	0	False		False	False
ORDER_QTY	float	8	53	False		False	False
UNIT	varchar	5	0	False		False	False
VOLUME	float	8	53	False		False	False
AMOUNT	float	8	53	False		False	False
HARGA_PENYERAHAN	float	8	53	False		False	False
NETTODTL	float	8	53	False		False	False
SATUAN_NETTO	varchar	10	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	tbl_po_lokal_dtl_uq	id_po_lokal_dtl	True

SQL Script

CREATE TABLE dbo.tbl_po_lokal_dtl (
  id_po_lokal_dtl bigint IDENTITY,
  id_po_lokal_hdr bigint NULL,
  PO_NO varchar(50) NULL,
  PART_NAME varchar(50) NULL,
  ORDER_QTY float NULL,
  UNIT varchar(5) NULL,
  VOLUME float NULL,
  AMOUNT float NULL,
  HARGA_PENYERAHAN float NULL,
  NETTODTL float NULL,
  SATUAN_NETTO varchar(10) NULL,
  CONSTRAINT tbl_po_lokal_dtl_uq UNIQUE (id_po_lokal_dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found