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 | 10/21/2019 02:51:27 |
| Last Modified | 3/13/2020 12:47:31 |
Columns
| Key | Name | Description |
|---|---|---|
| CAR | ||
| NODAFT | ||
| TGDAFT | ||
| NilInv | ||
| FOB | ||
| FREIGHT | ||
| NoDok | ||
| TgDok | ||
| typedok | ||
| NAMABELI | ||
| NEGBELI |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_acc_inv_out
AS
SELECT dbo.tbl_bc_out_hdr.CAR, dbo.tbl_bc_out_hdr.NODAFT, dbo.tbl_bc_out_hdr.TGDAFT, dbo.tbl_bc_out_hdr.NilInv, dbo.tbl_bc_out_hdr.FOB, dbo.tbl_bc_out_hdr.FREIGHT, dbo.tbl_bc_out_dok.NoDok,
dbo.tbl_bc_out_dok.TgDok, dbo.tbl_bc_out_hdr.typedok, dbo.tbl_bc_out_hdr.NAMABELI, dbo.tbl_bc_out_hdr.NEGBELI
FROM dbo.tbl_bc_out_hdr INNER JOIN
dbo.tbl_bc_out_dok ON dbo.tbl_bc_out_hdr.id_bc_out_hdr = dbo.tbl_bc_out_dok.id_bc_out_hdr
WHERE (dbo.tbl_bc_out_dok.KdDok = '380')
GO
GO
CREATE VIEW dbo.v_acc_inv_out
AS
SELECT dbo.tbl_bc_out_hdr.CAR, dbo.tbl_bc_out_hdr.NODAFT, dbo.tbl_bc_out_hdr.TGDAFT, dbo.tbl_bc_out_hdr.NilInv, dbo.tbl_bc_out_hdr.FOB, dbo.tbl_bc_out_hdr.FREIGHT, dbo.tbl_bc_out_dok.NoDok,
dbo.tbl_bc_out_dok.TgDok, dbo.tbl_bc_out_hdr.typedok, dbo.tbl_bc_out_hdr.NAMABELI, dbo.tbl_bc_out_hdr.NEGBELI
FROM dbo.tbl_bc_out_hdr INNER JOIN
dbo.tbl_bc_out_dok ON dbo.tbl_bc_out_hdr.id_bc_out_hdr = dbo.tbl_bc_out_dok.id_bc_out_hdr
WHERE (dbo.tbl_bc_out_dok.KdDok = '380')
GO