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 | 3/13/2020 12:48:28 |
| Last Modified | 3/13/2020 12:48:28 |
Columns
| Key | Name | Description |
|---|---|---|
| CAR | ||
| NODAFT | ||
| TGDAFT | ||
| total_fob | ||
| FREIGHT | ||
| NoDok | ||
| TgDok | ||
| typedok | ||
| NAMABELI | ||
| NEGBELI | ||
| NOINV | ||
| TGINV | ||
| NilInv | ||
| KDVAL | ||
| DELIVERY |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/****** Script for SelectTopNRows command from SSMS ******/
CREATE VIEW dbo.v_acc_inv_bc30
AS
SELECT dbo.v_acc_inv_out.CAR, dbo.v_acc_inv_out.NODAFT, dbo.v_acc_inv_out.TGDAFT, dbo.v_acc_inv_out.FOB AS total_fob, dbo.v_acc_inv_out.FREIGHT, dbo.v_acc_inv_out.NoDok, dbo.v_acc_inv_out.TgDok,
dbo.v_acc_inv_out.typedok, dbo.v_acc_inv_out.NAMABELI, dbo.v_acc_inv_out.NEGBELI, dbo.tblPebHdr.NOINV, dbo.tblPebHdr.TGINV, dbo.tblPebHdr.NilInv, dbo.tblPebHdr.KDVAL, dbo.tblPebHdr.DELIVERY
FROM dbo.v_acc_inv_out LEFT OUTER JOIN
dbo.tblPebHdr ON dbo.v_acc_inv_out.NoDok = dbo.tblPebHdr.NOINV
WHERE (dbo.v_acc_inv_out.typedok = 'BC30')
GO
GO
/****** Script for SelectTopNRows command from SSMS ******/
CREATE VIEW dbo.v_acc_inv_bc30
AS
SELECT dbo.v_acc_inv_out.CAR, dbo.v_acc_inv_out.NODAFT, dbo.v_acc_inv_out.TGDAFT, dbo.v_acc_inv_out.FOB AS total_fob, dbo.v_acc_inv_out.FREIGHT, dbo.v_acc_inv_out.NoDok, dbo.v_acc_inv_out.TgDok,
dbo.v_acc_inv_out.typedok, dbo.v_acc_inv_out.NAMABELI, dbo.v_acc_inv_out.NEGBELI, dbo.tblPebHdr.NOINV, dbo.tblPebHdr.TGINV, dbo.tblPebHdr.NilInv, dbo.tblPebHdr.KDVAL, dbo.tblPebHdr.DELIVERY
FROM dbo.v_acc_inv_out LEFT OUTER JOIN
dbo.tblPebHdr ON dbo.v_acc_inv_out.NoDok = dbo.tblPebHdr.NOINV
WHERE (dbo.v_acc_inv_out.typedok = 'BC30')
GO
Depends On
2Used By
No items found