dbo.tbl_acc_coa

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 (~)	1420
Created	10/21/2019 02:41:54
Last Modified	10/21/2019 02:41:54

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_coa_trx	bigint	8	19	0	True	1 - 1	False	False
coa_sap	varchar	50	0	0	True		False	False
name_account	varchar	100	0	0	False		False	False
target_group1	varchar	100	0	0	False		False	False
target_group2	varchar	100	0	0	False		False	False
target_report	varchar	50	0	0	False		False	False
periode	date	3	10	0	False		False	False
trx_amount	decimal	9	18	4	False		False	False
section1	varchar	50	0	0	False		False	False
section2	varchar	50	0	0	False		False	False
active	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_coa_trx	id_coa_trx	True

SQL Script

CREATE TABLE dbo.tbl_acc_coa_trx (
  id_coa_trx bigint IDENTITY,
  coa_sap varchar(50) NOT NULL,
  name_account varchar(100) NULL,
  target_group1 varchar(100) NULL,
  target_group2 varchar(100) NULL,
  target_report varchar(50) NULL,
  periode date NULL,
  trx_amount decimal(18, 4) NULL,
  section1 varchar(50) NULL,
  section2 varchar(50) NULL,
  active 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_coa_trx PRIMARY KEY CLUSTERED (id_coa_trx)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

dbo.v_acc_coa_trx