dbo.tbl_packinglist

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 (~)	7230
Created	12/23/2014 16:34:40
Last Modified	12/23/2014 16:34:40

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_packinglist	bigint	8	19	True	1 - 1	False	False
no_kontrak	varchar	50	0	False		False	False
tgl_kontrak	date	3	10	False		False	False
no_packinglist	varchar	50	0	False		False	False
tgl_packinglist	date	3	10	False		False	False
assy_no	varchar	50	0	False		False	False
qty	float	8	53	False		False	False
qty_box	float	8	53	False		False	False
unit	varchar	5	0	False		False	False
price	float	8	53	False		False	False
amount	float	8	53	False		False	False
kurs	float	8	53	False		False	False
no_surat_jalan	varchar	50	0	False		False	False
tgl_surat_jalan	date	3	10	False		False	False
no_bc262	varchar	50	0	False		False	False
tgl_bc262	date	3	10	False		False	False
ex_no_bc261	varchar	50	0	False		False	False
ex_tgl_bc261	date	3	10	False		False	False
id_bc_hdr	bigint	8	19	False		False	False
id_bc261	bigint	8	19	False		False	False
status	varchar	20	0	False		False	False

SQL Script

CREATE TABLE dbo.tbl_packinglist_bc262 (
  id_packinglist bigint IDENTITY,
  no_kontrak varchar(50) NULL,
  tgl_kontrak date NULL,
  no_packinglist varchar(50) NULL,
  tgl_packinglist date NULL,
  assy_no varchar(50) NULL,
  qty float NULL,
  qty_box float NULL,
  unit varchar(5) NULL,
  price float NULL,
  amount float NULL,
  kurs float NULL,
  no_surat_jalan varchar(50) NULL,
  tgl_surat_jalan date NULL,
  no_bc262 varchar(50) NULL,
  tgl_bc262 date NULL,
  ex_no_bc261 varchar(50) NULL,
  ex_tgl_bc261 date NULL,
  id_bc_hdr bigint NULL,
  id_bc261 bigint NULL,
  status varchar(20) NULL
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

dbo.v_packinglistbc262