dbo.tbl_acc

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

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_cf	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	70	0	0	False		False	False
REASON_CODE	varchar	50	0	0	False		False	False
REASON_NAME	varchar	50	0	0	False		False	False
PERIOD	varchar	50	0	0	False		False	False
DEBIT_AMOUNT	decimal	13	23	2	False		False	False
CREDIT_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_cf	id_cf	True

SQL Script

CREATE TABLE dbo.tbl_acc_cf (
  id_cf bigint IDENTITY,
  seq_no bigint NULL,
  GL_ACC varchar(50) NULL,
  GL_NAME varchar(70) NULL,
  REASON_CODE varchar(50) NULL,
  REASON_NAME varchar(50) NULL,
  PERIOD varchar(50) NULL,
  DEBIT_AMOUNT decimal(23, 2) NULL,
  CREDIT_AMOUNT decimal(23, 2) NULL,
  IMPORT_DATE datetime NULL,
  EXTRACT_DATE datetime NULL,
  CONSTRAINT PK_tbl_acc_cf PRIMARY KEY CLUSTERED (id_cf)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_acc_cf