dbo.tbl_acc_bs

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 (~)	5135
Created	10/31/2019 13:32:10
Last Modified	10/31/2019 13:32:10

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_bs_pl	bigint	8	19	0	True	1 - 1	False	False
seq_no	bigint	8	19	0	False		False	False
GL_ACC	varchar	50	0	0	False		False	False
GL_NAME	varchar	50	0	0	False		False	False
PERIOD	varchar	50	0	0	False		False	False
AMOUNT	decimal	13	23	2	False		False	False
IMPORT_DATE	datetime	8	23	3	False		False	False
EXTRACT_DATE	datetime	8	23	3	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_acc_bs_pl	id_bs_pl	True

SQL Script

CREATE TABLE dbo.tbl_acc_bs_pl (
  id_bs_pl bigint IDENTITY,
  seq_no bigint NULL,
  GL_ACC varchar(50) NULL,
  GL_NAME varchar(50) NULL,
  PERIOD varchar(50) NULL,
  AMOUNT decimal(23, 2) NULL,
  IMPORT_DATE datetime NULL,
  EXTRACT_DATE datetime NULL,
  CONSTRAINT PK_tbl_acc_bs_pl PRIMARY KEY CLUSTERED (id_bs_pl)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_acc_bs_pl