dbo.tbl_bahanpenolong

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 (~)	20366
Created	8/12/2017 13:09:42
Last Modified	8/12/2017 13:09:42

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted	Description
id_bp_out_dtl	bigint	8	19	0	True	1 - 1	False	False	1 => CT01 2=>to produksi 3=>BC
container_number	varchar	50	0	0	False		False	False
no_invoice	varchar	50	0	0	False		False	False
tgl_invoice	date	3	10	0	False		False	False
part_no	varchar	50	0	0	False		False	False
part_name	varchar	255	0	0	False		False	False
qty	float	8	53	0	False		False	False
qty_out	float	8	53	0	False		False	False
uom	varchar	10	0	0	False		False	False
doc_no	varchar	50	0	0	False		False	False
doc_date	date	3	10	0	False		False	False
doc_out_to	int	4	10	0	False		False	False	2. out produksi 1. out ct01 3. memo
filename	varchar	255	0	0	False		False	False
car	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
approved_date	date	3	10	0	False		False	False
price	float	8	53	0	False		False	False
status_data	varchar	50	0	0	False		False	False
kode_buyer	varchar	50	0	0	False		False	False
nama_buyer	varchar	50	0	0	False		False	False
id_memo_bp	bigint	8	19	0	False		False	False
bruto	float	8	53	0	False		False	False
hs_kode	varchar	50	0	0	False		False	False
jmkemas	float	8	53	0	False		False	False
jnkemas	varchar	5	0	0	False		False	False
netto	float	8	53	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__tbl_baha__0EB00D08EA29C220	id_bp_out_dtl	True

SQL Script

CREATE TABLE dbo.tbl_bahanpenolong_out (
  id_bp_out_dtl bigint IDENTITY,
  container_number varchar(50) NULL,
  no_invoice varchar(50) NULL,
  tgl_invoice date NULL,
  part_no varchar(50) NULL,
  part_name varchar(255) NULL,
  qty float NULL,
  qty_out float NULL,
  uom varchar(10) NULL,
  doc_no varchar(50) NULL,
  doc_date date NULL,
  doc_out_to int NULL,
  filename varchar(255) NULL,
  car varchar(50) NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  approved_date date NULL,
  price float NULL,
  status_data varchar(50) NULL,
  kode_buyer varchar(50) NULL,
  nama_buyer varchar(50) NULL,
  id_memo_bp bigint NULL,
  bruto float NULL,
  hs_kode varchar(50) NULL,
  jmkemas float NULL,
  jnkemas varchar(5) NULL,
  netto float NULL,
  PRIMARY KEY CLUSTERED (id_bp_out_dtl)
)
ON [PRIMARY]
GO

EXEC sys.sp_addextendedproperty N'MS_Description',
N'1 => CT01 2=>to produksi 3=>BC ', 'SCHEMA', N'dbo', 'TABLE', N'tbl_bahanpenolong_out', 'COLUMN', N'id_bp_out_dtl'
GO

EXEC sys.sp_addextendedproperty N'MS_Description',
N'2. out produksi 1. out ct01 3. memo ', 'SCHEMA', N'dbo', 'TABLE', N'tbl_bahanpenolong_out', 'COLUMN', N'doc_out_to'
GO

Depends On

No items found

dbo.tbl_bahanpenolong_out