dbo.tbl_coo_data

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 (~)	967071
Created	4/5/2017 14:27:41
Last Modified	11/25/2019 14:41:42

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_coo	bigint	8	19	0	True	1 - 1	False	False
id_coo_data	bigint	8	19	0	True		False	False
VENDOR	varchar	50	0	0	False		False	False
INVOICE_NO	varchar	51	0	0	False		False	False
CONTIANER_NO	varchar	50	0	0	False		False	False
INVOICE_DATE	varchar	50	0	0	False		False	False
ETD_VEBDER	varchar	50	0	0	False		False	False
ETD_PORT	varchar	50	0	0	False		False	False
ETA_PORT	varchar	50	0	0	False		False	False
ETA_FACT	varchar	50	0	0	False		False	False
TRANSPORT_WAY	varchar	50	0	0	False		False	False
CARA_BAYAR	varchar	50	0	0	False		False	False
ONEROUS	varchar	50	0	0	False		False	False
SHIP_FROM	varchar	50	0	0	False		False	False
VIA	varchar	50	0	0	False		False	False
SHIP_TO	varchar	50	0	0	False		False	False
PAY_BY	varchar	50	0	0	False		False	False
SEAL_NO	varchar	50	0	0	False		False	False
SHIP_NAME	varchar	50	0	0	False		False	False
SHIP_COMPANY	varchar	50	0	0	False		False	False
ORDER_NO	varchar	50	0	0	False		False	False
ITEM_NUMBER	varchar	50	0	0	False		False	False
DESCRIPTION	varchar	150	0	0	False		False	False
ARRIV_PLAN_NUMBER	varchar	50	0	0	False		False	False
UOM	varchar	50	0	0	False		False	False
PRICE	varchar	50	0	0	False		False	False
CURRENT_MONEY	varchar	50	0	0	False		False	False
CTN_NO_PREFIX	varchar	50	0	0	False		False	False
CTN_NO_FROM	varchar	50	0	0	False		False	False
CTN_NO_TO	varchar	50	0	0	False		False	False
CTN_QUANTITY	varchar	50	0	0	False		False	False
PACKING_QTY	varchar	50	0	0	False		False	False
NET_WEIGHT	varchar	50	0	0	False		False	False
GROSS_WEIGHT	varchar	50	0	0	False		False	False
WEIGHT_UOM	varchar	50	0	0	False		False	False
VOLUME	varchar	50	0	0	False		False	False
VOLUME_UOM	varchar	50	0	0	False		False	False
BL_DATE	varchar	50	0	0	False		False	False
BL_NO	varchar	50	0	0	False		False	False
FREIGHT	varchar	50	0	0	False		False	False
EURO_NO	varchar	50	0	0	False		False	False
PALET_NO	varchar	50	0	0	False		False	False
HS_CODE	varchar	50	0	0	False		False	False
COUNTRY_OF	varchar	50	0	0	False		False	False
AKHIR	varchar	50	0	0	False		False	False
create_by	varchar	30	0	0	False		False	False
create_date	datetime	8	23	3	False		False	False
status_inv	varchar	50	0	0	False		False	False
car	varchar	30	0	0	False		False	False
nobc	varchar	10	0	0	False		False	False
tglbc	datetime	8	23	3	False		False	False
nobl	varchar	50	0	0	False		False	False
tgbl	date	3	10	0	False		False	False
CATAMZ	decimal	17	32	2	False		False	False
CAUPRI	decimal	17	32	2	False		False	False
CAROUD	varchar	5	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	IX_tbl_coo_data_dtl_I	id_coo_data	False
	PK_tbl_coo_data	id_coo	True

SQL Script

CREATE TABLE dbo.tbl_coo_data_dtl (
  id_coo bigint IDENTITY,
  id_coo_data bigint NOT NULL,
  VENDOR varchar(50) NULL,
  INVOICE_NO varchar(51) NULL,
  CONTIANER_NO varchar(50) NULL,
  INVOICE_DATE varchar(50) NULL,
  ETD_VEBDER varchar(50) NULL,
  ETD_PORT varchar(50) NULL,
  ETA_PORT varchar(50) NULL,
  ETA_FACT varchar(50) NULL,
  TRANSPORT_WAY varchar(50) NULL,
  CARA_BAYAR varchar(50) NULL,
  ONEROUS varchar(50) NULL,
  SHIP_FROM varchar(50) NULL,
  VIA varchar(50) NULL,
  SHIP_TO varchar(50) NULL,
  PAY_BY varchar(50) NULL,
  SEAL_NO varchar(50) NULL,
  SHIP_NAME varchar(50) NULL,
  SHIP_COMPANY varchar(50) NULL,
  ORDER_NO varchar(50) NULL,
  ITEM_NUMBER varchar(50) NULL,
  DESCRIPTION varchar(150) NULL,
  ARRIV_PLAN_NUMBER varchar(50) NULL,
  UOM varchar(50) NULL,
  PRICE varchar(50) NULL,
  CURRENT_MONEY varchar(50) NULL,
  CTN_NO_PREFIX varchar(50) NULL,
  CTN_NO_FROM varchar(50) NULL,
  CTN_NO_TO varchar(50) NULL,
  CTN_QUANTITY varchar(50) NULL,
  PACKING_QTY varchar(50) NULL,
  NET_WEIGHT varchar(50) NULL,
  GROSS_WEIGHT varchar(50) NULL,
  WEIGHT_UOM varchar(50) NULL,
  VOLUME varchar(50) NULL,
  VOLUME_UOM varchar(50) NULL,
  BL_DATE varchar(50) NULL,
  BL_NO varchar(50) NULL,
  FREIGHT varchar(50) NULL,
  EURO_NO varchar(50) NULL,
  PALET_NO varchar(50) NULL,
  HS_CODE varchar(50) NULL,
  COUNTRY_OF varchar(50) NULL,
  AKHIR varchar(50) NULL,
  create_by varchar(30) NULL,
  create_date datetime NULL,
  status_inv varchar(50) NULL,
  car varchar(30) NULL,
  nobc varchar(10) NULL,
  tglbc datetime NULL,
  nobl varchar(50) NULL,
  tgbl date NULL,
  CATAMZ decimal(32, 2) NULL,
  CAUPRI decimal(32, 2) NULL,
  CAROUD varchar(5) NULL,
  CONSTRAINT PK_tbl_coo_data PRIMARY KEY CLUSTERED (id_coo)
)
ON [PRIMARY]
GO

CREATE INDEX IX_tbl_coo_data_dtl_I
  ON dbo.tbl_coo_data_dtl (id_coo_data)
  INCLUDE (id_coo, VENDOR, INVOICE_NO, CONTIANER_NO, INVOICE_DATE, ETD_VEBDER, ETD_PORT, ETA_PORT, ETA_FACT, TRANSPORT_WAY, CARA_BAYAR, ONEROUS, SHIP_FROM, VIA, SHIP_TO, PAY_BY, SEAL_NO, SHIP_NAME, SHIP_COMPANY, ORDER_NO, ITEM_NUMBER, DESCRIPTION, ARRIV_PLAN_NUMBER, UOM, PRICE, CURRENT_MONEY, CTN_NO_PREFIX, CTN_NO_FROM, CTN_NO_TO, CTN_QUANTITY, PACKING_QTY, NET_WEIGHT, GROSS_WEIGHT, WEIGHT_UOM, VOLUME, VOLUME_UOM, BL_DATE, BL_NO, FREIGHT, EURO_NO, PALET_NO, HS_CODE, COUNTRY_OF, AKHIR)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_coo_data_dtl