dbo.dt_ms_manual

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 (~)	242
Created	9/11/2017 09:42:00
Last Modified	3/1/2018 10:57:00

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
ms_manual_invoice_id	bigint	8	19	0	True	1 - 1	False	False
ms_file_id	bigint	8	19	0	False		False	False
ms_manual_invoice_type_id	int	4	10	0	False		False	False
invoice_no	varchar	50	0	0	False		False	False
invoice_date	date	3	10	0	False		False	False
req_eta_date	date	3	10	0	False		False	False
kode_supplier	varchar	50	0	0	False		False	False
shipping_by	varchar	50	0	0	False		False	False
rec_date	date	3	10	0	False		False	False
mapping_supplier_customer_id	int	4	10	0	False		False	False
mode_source_out	int	4	10	0	False		False	False
source_out_id	bigint	8	19	0	False		False	False
create_date	datetime	8	23	3	False		False	False
create_by	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

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_dt_ms_manual_invoice	ms_manual_invoice_id	True

Foreign Keys

Name	Columns	Description
FK_dt_ms_manual_invoice_enum_ms_manual_invoice_type	ms_manual_invoice_type_id

SQL Script

CREATE TABLE dbo.dt_ms_manual_invoice (
  ms_manual_invoice_id bigint IDENTITY,
  ms_file_id bigint NULL,
  ms_manual_invoice_type_id int NULL,
  invoice_no varchar(50) NULL,
  invoice_date date NULL,
  req_eta_date date NULL,
  kode_supplier varchar(50) NULL,
  shipping_by varchar(50) NULL,
  rec_date date NULL,
  mapping_supplier_customer_id int NULL,
  mode_source_out int NULL,
  source_out_id bigint NULL,
  create_date datetime NULL,
  create_by int NULL,
  mapping_date datetime NULL,
  mapping_by int NULL,
  CONSTRAINT PK_dt_ms_manual_invoice PRIMARY KEY CLUSTERED (ms_manual_invoice_id)
)
ON [PRIMARY]
GO

ALTER TABLE dbo.dt_ms_manual_invoice WITH NOCHECK
  ADD CONSTRAINT FK_dt_ms_manual_invoice_enum_ms_manual_invoice_type FOREIGN KEY (ms_manual_invoice_type_id) REFERENCES dbo.enum_ms_manual_invoice_type (ms_manual_invoice_type_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.dt_ms_manual_invoice
  NOCHECK CONSTRAINT FK_dt_ms_manual_invoice_enum_ms_manual_invoice_type
GO

Depends On

dbo.enum_ms_manual_invoice_type

dbo.dt_ms_manual_invoice