dbo.tbl_sa

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 (~)	885
Created	11/16/2020 12:16:24
Last Modified	11/16/2020 12:16:24

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_sa_bom	bigint	8	19	0	True	1 - 1	False	False
id_sa	bigint	8	19	0	False		False	False
id_sa_hdr	bigint	8	19	0	True		False	False
id_bc_in_hdr	bigint	8	19	0	False		False	False
id_bc_in_dtl	bigint	8	19	0	False		False	False
id_data_in_hdr	bigint	8	19	0	False		False	False
id_data_in_dtl	bigint	8	19	0	False		False	False
SA_NO	varchar	50	0	0	False		False	False
KODE_BARANG	varchar	50	0	0	False		False	False
PART_NO	varchar	50	0	0	False		False	False
URAIAN	varchar	255	0	0	False		False	False
JUMLAH_SATUAN_ASAL	decimal	17	38	4	False		False	False
JUMLAH_SATUAN	decimal	17	38	4	False		False	False
JENIS_SATUAN	varchar	5	0	0	False		False	False
STATUS	varchar	50	0	0	False		False	False
CURR	varchar	5	0	0	False		False	False
PRICE	float	8	53	0	False		False	False
CIF	float	8	53	0	False		False	False
NDPMB	float	8	53	0	False		False	False
NDPDM_NOW	float	8	53	0	False		False	False
HARGA_PABEAN	float	8	53	0	False		False	False
HS	varchar	20	0	0	False		False	False
BM	float	8	53	0	False		False	False
PPN	float	8	53	0	False		False	False
PPH	float	8	53	0	False		False	False
BM_RP	float	8	53	0	False		False	False
PPN_RP	float	8	53	0	False		False	False
PPH_RP	float	8	53	0	False		False	False
NOMOR_DAFTAR_DOK_ASAL	varchar	50	0	0	False		False	False
TANGGAL_DAFTAR_DOK_ASAL	date	3	10	0	False		False	False
SERI_BARANG	int	4	10	0	False		False	False
SERI_BAHAN_BAKU	int	4	10	0	False		False	False
SERI_BAHAN_BAKU_ASAL	int	4	10	0	False		False	False
ASSY_NO	varchar	50	0	0	False		False	False
KODE_JENIS_DOK_ASAL	varchar	50	0	0	False		False	False
KODE_KANTOR	varchar	50	0	0	False		False	False
NOMOR_AJU_DOK_ASAL	varchar	50	0	0	False		False	False
KODE_ASAL_BAHAN_BAKU	int	4	10	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_sa_bom	id_sa_bom	True

SQL Script

CREATE TABLE dbo.tbl_sa_bom (
  id_sa_bom bigint IDENTITY,
  id_sa bigint NULL,
  id_sa_hdr bigint NOT NULL,
  id_bc_in_hdr bigint NULL,
  id_bc_in_dtl bigint NULL,
  id_data_in_hdr bigint NULL,
  id_data_in_dtl bigint NULL,
  SA_NO varchar(50) NULL,
  KODE_BARANG varchar(50) NULL,
  PART_NO varchar(50) NULL,
  URAIAN varchar(255) NULL,
  JUMLAH_SATUAN_ASAL decimal(38, 4) NULL,
  JUMLAH_SATUAN decimal(38, 4) NULL,
  JENIS_SATUAN varchar(5) NULL,
  STATUS varchar(50) NULL,
  CURR varchar(5) NULL,
  PRICE float NULL,
  CIF float NULL,
  NDPMB float NULL,
  NDPDM_NOW float NULL,
  HARGA_PABEAN float NULL,
  HS varchar(20) NULL,
  BM float NULL,
  PPN float NULL,
  PPH float NULL,
  BM_RP float NULL,
  PPN_RP float NULL,
  PPH_RP float NULL,
  NOMOR_DAFTAR_DOK_ASAL varchar(50) NULL,
  TANGGAL_DAFTAR_DOK_ASAL date NULL,
  SERI_BARANG int NULL,
  SERI_BAHAN_BAKU int NULL,
  SERI_BAHAN_BAKU_ASAL int NULL,
  ASSY_NO varchar(50) NULL,
  KODE_JENIS_DOK_ASAL varchar(50) NULL,
  KODE_KANTOR varchar(50) NULL,
  NOMOR_AJU_DOK_ASAL varchar(50) NULL,
  KODE_ASAL_BAHAN_BAKU int NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  CONSTRAINT PK_tbl_sa_bom PRIMARY KEY CLUSTERED (id_sa_bom) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_sa_bom