dbo.test_compare

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	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	25257
Created	11/29/2019 00:30:31
Last Modified	12/4/2019 18:29:56

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id	bigint	8	19	0	True	1 - 1	False	False
status	varchar	50	0	0	False		False	False
GRNUMBER	varchar	50	0	0	False		False	False
GRDATE	date	3	10	0	False		False	False
GRQTY	decimal	17	38	4	False		False	False
PARTNUMBER	varchar	50	0	0	False		False	False
PARTCODE	varchar	50	0	0	False		False	False
PARTCOA	varchar	50	0	0	False		False	False
PARTPRICE	decimal	17	38	4	False		False	False
NETAMOUNT	decimal	17	38	4	False		False	False
PARTUNIT	varchar	50	0	0	False		False	False
PARTETA	date	3	10	0	False		False	False
PONUMBER	varchar	50	0	0	False		False	False
PODATE	date	3	10	0	False		False	False
AJUNUMBER	varchar	50	0	0	False		False	False
AJUDATE	date	3	10	0	False		False	False
REGISTERNUMBER	varchar	50	0	0	False		False	False
REGISTERDATE	date	3	10	0	False		False	False
SHIPPING	varchar	50	0	0	False		False	False
SHIPPER	varchar	50	0	0	False		False	False
create_date	datetime	8	23	3	False		False	False
create_by	int	4	10	0	False		False	False
source_out_id	bigint	8	19	0	False		False	False
mapping_supplier_customer_id	int	4	10	0	False		False	False
mapping_date	datetime	8	23	3	False		False	False
mapping_by	int	4	10	0	False		False	False
bruto	decimal	17	38	4	False		False	False
netto	decimal	17	38	4	False		False	False
mode_source_out	bigint	8	19	0	False		False	False
surat_jalan	varchar	50	0	0	False		False	False
faktur_no	varchar	50	0	0	False		False	False
faktur_date	date	3	10	0	False		False	False
inv_no	varchar	50	0	0	False		False	False
inv_date	date	3	10	0	False		False	False

SQL Script

CREATE TABLE dbo.test_compare (
  id bigint IDENTITY,
  status varchar(50) NULL,
  GRNUMBER varchar(50) NULL,
  GRDATE date NULL,
  GRQTY decimal(38, 4) NULL,
  PARTNUMBER varchar(50) NULL,
  PARTCODE varchar(50) NULL,
  PARTCOA varchar(50) NULL,
  PARTPRICE decimal(38, 4) NULL,
  NETAMOUNT decimal(38, 4) NULL,
  PARTUNIT varchar(50) NULL,
  PARTETA date NULL,
  PONUMBER varchar(50) NULL,
  PODATE date NULL,
  AJUNUMBER varchar(50) NULL,
  AJUDATE date NULL,
  REGISTERNUMBER varchar(50) NULL,
  REGISTERDATE date NULL,
  SHIPPING varchar(50) NULL,
  SHIPPER varchar(50) NULL,
  create_date datetime NULL,
  create_by int NULL,
  source_out_id bigint NULL,
  mapping_supplier_customer_id int NULL,
  mapping_date datetime NULL,
  mapping_by int NULL,
  bruto decimal(38, 4) NULL,
  netto decimal(38, 4) NULL,
  mode_source_out bigint NULL,
  surat_jalan varchar(50) NULL,
  faktur_no varchar(50) NULL,
  faktur_date date NULL,
  inv_no varchar(50) NULL,
  inv_date date NULL
)
ON [PRIMARY]
GO

Depends On

No items found