dbo.xtemp_pasi

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 (~)	9
Created	4/21/2019 06:34:45
Last Modified	4/21/2019 06:34:45

Columns

Name	Data Type	Length	Not Null	Computed	Persisted
CAR	nvarchar	255	False	False	False
KdKpbc	nvarchar	255	False	False	False
KdKpbcBongkar	nvarchar	255	False	False	False
KdKpbcAwas	nvarchar	255	False	False	False
PasokNama	nvarchar	255	False	False	False
PasokAlmt1	nvarchar	255	False	False	False
Moda	nvarchar	255	False	False	False
KdVal	nvarchar	255	False	False	False
Cif	nvarchar	255	False	False	False
Bruto	nvarchar	255	False	False	False
Netto	nvarchar	255	False	False	False
NilSerah	nvarchar	255	False	False	False
Nodaf	nvarchar	255	False	False	False
Tgldaf	nvarchar	255	False	False	False
UsahaNama	nvarchar	255	False	False	False
UsahaNPWP	nvarchar	255	False	False	False
UsahaAlamat1	nvarchar	255	False	False	False
UsahaAlamat2	nvarchar	255	False	False	False
UsahaSkep	nvarchar	255	False	False	False
PasokAlmt2	nvarchar	255	False	False	False
PasokSkep	nvarchar	255	False	False	False
PasokNPWP	nvarchar	255	False	False	False
NoInvoice	nvarchar	255	False	False	False
TgInvoice	nvarchar	255	False	False	False
NoPackinglist	nvarchar	255	False	False	False
TgPackinglist	nvarchar	255	False	False	False
NoKontrak	nvarchar	255	False	False	False
TgKontrak	nvarchar	255	False	False	False
SuratJalan	nvarchar	255	False	False	False
TgSuratjalan	nvarchar	255	False	False	False
SuratKep	nvarchar	255	False	False	False
TgSuratKep	nvarchar	255	False	False	False
SuratLain	nvarchar	255	False	False	False
TgSuratLain	nvarchar	255	False	False	False
NoBc27Asal	nvarchar	255	False	False	False
TgBc27Asal	nvarchar	255	False	False	False
Nopol	nvarchar	255	False	False	False
MrkNoKms	nvarchar	255	False	False	False
JmlJnsKms	nvarchar	255	False	False	False
NoSeg	nvarchar	255	False	False	False
CtBcTuj1	nvarchar	255	False	False	False
CtBcTuj2	nvarchar	255	False	False	False
Volume	nvarchar	255	False	False	False
Tgl_Keluar	nvarchar	255	False	False	False
No_Keluar	nvarchar	255	False	False	False

SQL Script

CREATE TABLE dbo.xtemp_pasi_hdr (
  CAR nvarchar(255) NULL,
  KdKpbc nvarchar(255) NULL,
  KdKpbcBongkar nvarchar(255) NULL,
  KdKpbcAwas nvarchar(255) NULL,
  PasokNama nvarchar(255) NULL,
  PasokAlmt1 nvarchar(255) NULL,
  Moda nvarchar(255) NULL,
  KdVal nvarchar(255) NULL,
  Cif nvarchar(255) NULL,
  Bruto nvarchar(255) NULL,
  Netto nvarchar(255) NULL,
  NilSerah nvarchar(255) NULL,
  Nodaf nvarchar(255) NULL,
  Tgldaf nvarchar(255) NULL,
  UsahaNama nvarchar(255) NULL,
  UsahaNPWP nvarchar(255) NULL,
  UsahaAlamat1 nvarchar(255) NULL,
  UsahaAlamat2 nvarchar(255) NULL,
  UsahaSkep nvarchar(255) NULL,
  PasokAlmt2 nvarchar(255) NULL,
  PasokSkep nvarchar(255) NULL,
  PasokNPWP nvarchar(255) NULL,
  NoInvoice nvarchar(255) NULL,
  TgInvoice nvarchar(255) NULL,
  NoPackinglist nvarchar(255) NULL,
  TgPackinglist nvarchar(255) NULL,
  NoKontrak nvarchar(255) NULL,
  TgKontrak nvarchar(255) NULL,
  SuratJalan nvarchar(255) NULL,
  TgSuratjalan nvarchar(255) NULL,
  SuratKep nvarchar(255) NULL,
  TgSuratKep nvarchar(255) NULL,
  SuratLain nvarchar(255) NULL,
  TgSuratLain nvarchar(255) NULL,
  NoBc27Asal nvarchar(255) NULL,
  TgBc27Asal nvarchar(255) NULL,
  Nopol nvarchar(255) NULL,
  MrkNoKms nvarchar(255) NULL,
  JmlJnsKms nvarchar(255) NULL,
  NoSeg nvarchar(255) NULL,
  CtBcTuj1 nvarchar(255) NULL,
  CtBcTuj2 nvarchar(255) NULL,
  Volume nvarchar(255) NULL,
  Tgl_Keluar nvarchar(255) NULL,
  No_Keluar nvarchar(255) NULL
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found