dbo.tbl_acc_upload_gbr

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 (~)	2
Created	2/27/2020 15:18:34
Last Modified	2/27/2020 15:18:34

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_upload_inv	bigint	8	19	0	True	1 - 1	False	False
no_inv	varchar	70	0	0	False		False	False
tgl_inv	date	3	10	0	False		False	False
amount_inv	decimal	9	18	2	False		False	False
folder	varchar	255	0	0	False		False	False
filename	varchar	255	0	0	False		False	False
tipe	varchar	50	0	0	False		False	False
create_date	datetime	8	23	3	False		False	False
create_by	varchar	50	0	0	False		False	False
update_date	datetime	8	23	3	False		False	False
update_by	varchar	50	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_acc_upload_gbr_invoicce	id_upload_inv	True

SQL Script

CREATE TABLE dbo.tbl_acc_upload_gbr_invoice (
  id_upload_inv bigint IDENTITY,
  no_inv varchar(70) NULL,
  tgl_inv date NULL,
  amount_inv decimal(18, 2) NULL,
  folder varchar(255) NULL,
  filename varchar(255) NULL,
  tipe varchar(50) NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  CONSTRAINT PK_tbl_acc_upload_gbr_invoicce PRIMARY KEY CLUSTERED (id_upload_inv)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found