Description
Properties
| Name | Value |
|---|---|
| Collation | SQL_Latin1_General_CP1_CI_AS |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 12/27/2012 12:33:37 |
| Last Modified | 12/27/2012 12:33:37 |
Columns
| Key | Name | Description |
|---|---|---|
| CAR | ||
| KdKpbc | ||
| Tujuan | ||
| JnsBarang | ||
| TujuanKirim | ||
| PasokNama | ||
| PasokAlmt | ||
| PasokNeg | ||
| UsahaId | ||
| UsahaNpwp | ||
| KdTPB | ||
| Registrasi | ||
| UsahaNama | ||
| UsahaAlmt | ||
| UsahaStatus | ||
| ApiKd | ||
| ApiNo | ||
| PpjkId | ||
| PpjkNpwp | ||
| PpjkNama | ||
| PpjkAlmt | ||
| PpjkNo | ||
| PpjkTg | ||
| IndId | ||
| IndNpwp | ||
| IndNama | ||
| IndAlmt | ||
| Moda | ||
| AngkutNama | ||
| AngkutNo | ||
| AngkutFl | ||
| PelBkr | ||
| PelMuat | ||
| PelTransit | ||
| BC23No | ||
| BC23Tg | ||
| KdKpbcBongkar | ||
| KdKpbcAwas | ||
| DokTupKd | ||
| DokTupNo | ||
| DokTupTg | ||
| PosNo | ||
| PosSub | ||
| TmpTbn | ||
| KdVal | ||
| Ndpbm | ||
| NilInv | ||
| Freight | ||
| BTambahan | ||
| Diskon | ||
| KdAss | ||
| Asuransi | ||
| KdHrg | ||
| Fob | ||
| Cif | ||
| Bruto | ||
| Netto | ||
| JmCont | ||
| JmBrg | ||
| TglTtd | ||
| KotaTtd | ||
| Namattd | ||
| ContakPerson | ||
| NoPhone | ||
| NoFax | ||
| Status | ||
| Snrf | ||
| Lengkap | ||
| PosSubSub |
Extended Properties
| Name | Value |
|---|---|
| MS_DiagramPane1 | [0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = "(H (1[40] 4[20] 2[20] 3) )" End Begin PaneConfiguration = 1 NumPanes = 3 Configuration = "(H (1 [50] 4 [25] 3))" End Begin PaneConfiguration = 2 NumPanes = 3 Configuration = "(H (1 [50] 2 [25] 3))" End Begin PaneConfiguration = 3 NumPanes = 3 Configuration = "(H (4 [30] 2 [40] 3))" End Begin PaneConfiguration = 4 NumPanes = 2 Configuration = "(H (1 [56] 3))" End Begin PaneConfiguration = 5 NumPanes = 2 Configuration = "(H (2 [66] 3))" End Begin PaneConfiguration = 6 NumPanes = 2 Configuration = "(H (4 [50] 3))" End Begin PaneConfiguration = 7 NumPanes = 1 Configuration = "(V (3))" End Begin PaneConfiguration = 8 NumPanes = 3 Configuration = "(H (1[56] 4[18] 2) )" End Begin PaneConfiguration = 9 NumPanes = 2 Configuration = "(H (1 [75] 4))" End Begin PaneConfiguration = 10 NumPanes = 2 Configuration = "(H (1[66] 2) )" End Begin PaneConfiguration = 11 NumPanes = 2 Configuration = "(H (4 [60] 2))" End Begin PaneConfiguration = 12 NumPanes = 1 Configuration = "(H (1) )" End Begin PaneConfiguration = 13 NumPanes = 1 Configuration = "(V (4))" End Begin PaneConfiguration = 14 NumPanes = 1 Configuration = "(V (2))" End ActivePaneConfig = 0 End Begin DiagramPane = Begin Origin = Top = 0 Left = 0 End Begin Tables = Begin Table = "tbl_bc_in_hdr" Begin Extent = Top = 6 Left = 38 Bottom = 125 Right = 202 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End Begin ColumnWidths = 9 Width = 284 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 End End Begin CriteriaPane = Begin ColumnWidths = 11 Column = 1440 Alias = 900 Table = 1170 Output = 720 Append = 1400 NewValue = 1170 SortType = 1350 SortOrder = 1410 GroupBy = 1350 Filter = 1350 Or = 1350 Or = 1350 Or = 1350 End End End |
| MS_DiagramPaneCount | 1 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_bc23hdr
AS
SELECT CAR, KdKpbc, Tujuan, JnsBarang, TujuanKirim, PasokNama, PasokAlmt, PasokNeg, UsahaId, UsahaNpwp, KdTPB, Registrasi, UsahaNama, UsahaAlmt, UsahaStatus,
ApiKd, ApiNo, PpjkId, PpjkNpwp, PpjkNama, PpjkAlmt, PpjkNo, PpjkTg, IndId, IndNpwp, IndNama, IndAlmt, Moda, AngkutNama, AngkutNo, AngkutFl, PelBkr, PelMuat,
PelTransit, BC23No, BC23Tg, KdKpbcBongkar, KdKpbcAwas, DokTupKd, DokTupNo, DokTupTg, PosNo, PosSub, TmpTbn, KdVal, Ndpbm, NilInv, Freight, BTambahan,
Diskon, KdAss, Asuransi, KdHrg, Fob, Cif, Bruto, Netto, JmCont, JmBrg, TglTtd, KotaTtd, Namattd, ContakPerson, NoPhone, NoFax, Email, Status, Snrf, Lengkap,
PosSubSub
FROM dbo.tbl_bc_in_hdr
GO
EXEC sys.sp_addextendedproperty N'MS_DiagramPane1',
N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = "(H (1[40] 4[20] 2[20] 3) )" End Begin PaneConfiguration = 1 NumPanes = 3 Configuration = "(H (1 [50] 4 [25] 3))" End Begin PaneConfiguration = 2 NumPanes = 3 Configuration = "(H (1 [50] 2 [25] 3))" End Begin PaneConfiguration = 3 NumPanes = 3 Configuration = "(H (4 [30] 2 [40] 3))" End Begin PaneConfiguration = 4 NumPanes = 2 Configuration = "(H (1 [56] 3))" End Begin PaneConfiguration = 5 NumPanes = 2 Configuration = "(H (2 [66] 3))" End Begin PaneConfiguration = 6 NumPanes = 2 Configuration = "(H (4 [50] 3))" End Begin PaneConfiguration = 7 NumPanes = 1 Configuration = "(V (3))" End Begin PaneConfiguration = 8 NumPanes = 3 Configuration = "(H (1[56] 4[18] 2) )" End Begin PaneConfiguration = 9 NumPanes = 2 Configuration = "(H (1 [75] 4))" End Begin PaneConfiguration = 10 NumPanes = 2 Configuration = "(H (1[66] 2) )" End Begin PaneConfiguration = 11 NumPanes = 2 Configuration = "(H (4 [60] 2))" End Begin PaneConfiguration = 12 NumPanes = 1 Configuration = "(H (1) )" End Begin PaneConfiguration = 13 NumPanes = 1 Configuration = "(V (4))" End Begin PaneConfiguration = 14 NumPanes = 1 Configuration = "(V (2))" End ActivePaneConfig = 0 End Begin DiagramPane = Begin Origin = Top = 0 Left = 0 End Begin Tables = Begin Table = "tbl_bc_in_hdr" Begin Extent = Top = 6 Left = 38 Bottom = 125 Right = 202 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End Begin ColumnWidths = 9 Width = 284 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 End End Begin CriteriaPane = Begin ColumnWidths = 11 Column = 1440 Alias = 900 Table = 1170 Output = 720 Append = 1400 NewValue = 1170 SortType = 1350 SortOrder = 1410 GroupBy = 1350 Filter = 1350 Or = 1350 Or = 1350 Or = 1350 End End End ', 'SCHEMA', N'dbo', 'VIEW', N'v_bc23hdr'
GO
EXEC sys.sp_addextendedproperty N'MS_DiagramPaneCount', 1, 'SCHEMA', N'dbo', 'VIEW', N'v_bc23hdr'
GO
GO
CREATE VIEW dbo.v_bc23hdr
AS
SELECT CAR, KdKpbc, Tujuan, JnsBarang, TujuanKirim, PasokNama, PasokAlmt, PasokNeg, UsahaId, UsahaNpwp, KdTPB, Registrasi, UsahaNama, UsahaAlmt, UsahaStatus,
ApiKd, ApiNo, PpjkId, PpjkNpwp, PpjkNama, PpjkAlmt, PpjkNo, PpjkTg, IndId, IndNpwp, IndNama, IndAlmt, Moda, AngkutNama, AngkutNo, AngkutFl, PelBkr, PelMuat,
PelTransit, BC23No, BC23Tg, KdKpbcBongkar, KdKpbcAwas, DokTupKd, DokTupNo, DokTupTg, PosNo, PosSub, TmpTbn, KdVal, Ndpbm, NilInv, Freight, BTambahan,
Diskon, KdAss, Asuransi, KdHrg, Fob, Cif, Bruto, Netto, JmCont, JmBrg, TglTtd, KotaTtd, Namattd, ContakPerson, NoPhone, NoFax, Email, Status, Snrf, Lengkap,
PosSubSub
FROM dbo.tbl_bc_in_hdr
GO
EXEC sys.sp_addextendedproperty N'MS_DiagramPane1',
N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = "(H (1[40] 4[20] 2[20] 3) )" End Begin PaneConfiguration = 1 NumPanes = 3 Configuration = "(H (1 [50] 4 [25] 3))" End Begin PaneConfiguration = 2 NumPanes = 3 Configuration = "(H (1 [50] 2 [25] 3))" End Begin PaneConfiguration = 3 NumPanes = 3 Configuration = "(H (4 [30] 2 [40] 3))" End Begin PaneConfiguration = 4 NumPanes = 2 Configuration = "(H (1 [56] 3))" End Begin PaneConfiguration = 5 NumPanes = 2 Configuration = "(H (2 [66] 3))" End Begin PaneConfiguration = 6 NumPanes = 2 Configuration = "(H (4 [50] 3))" End Begin PaneConfiguration = 7 NumPanes = 1 Configuration = "(V (3))" End Begin PaneConfiguration = 8 NumPanes = 3 Configuration = "(H (1[56] 4[18] 2) )" End Begin PaneConfiguration = 9 NumPanes = 2 Configuration = "(H (1 [75] 4))" End Begin PaneConfiguration = 10 NumPanes = 2 Configuration = "(H (1[66] 2) )" End Begin PaneConfiguration = 11 NumPanes = 2 Configuration = "(H (4 [60] 2))" End Begin PaneConfiguration = 12 NumPanes = 1 Configuration = "(H (1) )" End Begin PaneConfiguration = 13 NumPanes = 1 Configuration = "(V (4))" End Begin PaneConfiguration = 14 NumPanes = 1 Configuration = "(V (2))" End ActivePaneConfig = 0 End Begin DiagramPane = Begin Origin = Top = 0 Left = 0 End Begin Tables = Begin Table = "tbl_bc_in_hdr" Begin Extent = Top = 6 Left = 38 Bottom = 125 Right = 202 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End Begin ColumnWidths = 9 Width = 284 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 Width = 1500 End End Begin CriteriaPane = Begin ColumnWidths = 11 Column = 1440 Alias = 900 Table = 1170 Output = 720 Append = 1400 NewValue = 1170 SortType = 1350 SortOrder = 1410 GroupBy = 1350 Filter = 1350 Or = 1350 Or = 1350 Or = 1350 End End End ', 'SCHEMA', N'dbo', 'VIEW', N'v_bc23hdr'
GO
EXEC sys.sp_addextendedproperty N'MS_DiagramPaneCount', 1, 'SCHEMA', N'dbo', 'VIEW', N'v_bc23hdr'
GO
Depends On
1Used By
No items found