dbo.tbl_grn

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 (~)	0
Created	11/21/2019 08:00:23
Last Modified	11/21/2019 08:00:23

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
grn_id	bigint	8	19	True	1 - 1	False	False
grn_num	varchar	50	0	False		False	False
grn_date	date	3	10	False		False	False
grn_sup_code	varchar	50	0	False		False	False
grn_item_code	varchar	50	0	False		False	False
grn_item_name	varchar	50	0	False		False	False
grn_item_unit	varchar	50	0	False		False	False
grn_item_qty	float	8	53	False		False	False
grn_item_base	varchar	50	0	False		False	False
grn_item_dept_code	varchar	50	0	False		False	False
grn_item_price	float	8	53	False		False	False
grn_item_amount_price	float	8	53	False		False	False
grn_po_num	varchar	50	0	False		False	False
grn_po_date	date	3	10	False		False	False
grn_eta	date	3	10	False		False	False
grn_etd	date	3	10	False		False	False
grn_create_date	date	3	10	False		False	False
grn_create_by	varchar	50	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_grn_lp	grn_id	True

SQL Script

CREATE TABLE dbo.tbl_grn_lp (
  grn_id bigint IDENTITY,
  grn_num varchar(50) NULL,
  grn_date date NULL,
  grn_sup_code varchar(50) NULL,
  grn_item_code varchar(50) NULL,
  grn_item_name varchar(50) NULL,
  grn_item_unit varchar(50) NULL,
  grn_item_qty float NULL,
  grn_item_base varchar(50) NULL,
  grn_item_dept_code varchar(50) NULL,
  grn_item_price float NULL,
  grn_item_amount_price float NULL,
  grn_po_num varchar(50) NULL,
  grn_po_date date NULL,
  grn_eta date NULL,
  grn_etd date NULL,
  grn_create_date date NULL,
  grn_create_by varchar(50) NULL,
  CONSTRAINT PK_tbl_grn_lp PRIMARY KEY CLUSTERED (grn_id)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found