dbo.tbl_pajak

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 (~)	37319
Created	6/17/2020 00:02:27
Last Modified	6/17/2020 00:02:27

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_b123	bigint	8	19	0	True	1 - 1	False	False
pemberi_jkp	varchar	50	0	0	False		False	False
npwp	varchar	50	0	0	False		False	False
kode_no_seri	varchar	50	0	0	False		False	False
tgl	date	3	10	0	False		False	False
tglx	varchar	50	0	0	False		False	False
dpp	decimal	9	18	2	False		False	False
ppn	decimal	9	18	2	False		False	False
ppnbm	decimal	9	18	2	False		False	False
car	varchar	50	0	0	False		False	False
nobc	varchar	50	0	0	False		False	False
tglbc	date	3	10	0	False		False	False
tipe_bc	varchar	50	0	0	False		False	False
tipe_pajak	varchar	50	0	0	False		False	False
periode	varchar	50	0	0	False		False	False
masa_spt	varchar	50	0	0	False		False	False
status_bc	varchar	50	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_pajak_b2	id_b123	True

SQL Script

CREATE TABLE dbo.tbl_pajak_b123 (
  id_b123 bigint IDENTITY,
  pemberi_jkp varchar(50) NULL,
  npwp varchar(50) NULL,
  kode_no_seri varchar(50) NULL,
  tgl date NULL,
  tglx varchar(50) NULL,
  dpp decimal(18, 2) NULL,
  ppn decimal(18, 2) NULL,
  ppnbm decimal(18, 2) NULL,
  car varchar(50) NULL,
  nobc varchar(50) NULL,
  tglbc date NULL,
  tipe_bc varchar(50) NULL,
  tipe_pajak varchar(50) NULL,
  periode varchar(50) NULL,
  masa_spt varchar(50) NULL,
  status_bc varchar(50) NULL,
  CONSTRAINT PK_tbl_pajak_b2 PRIMARY KEY CLUSTERED (id_b123)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found