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:46:37 |
| Last Modified | 10/21/2019 02:46:37 |
Columns
| Key | Name | Description |
|---|---|---|
| coa_sap | ||
| name_account | ||
| trx_amount | ||
| periode |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_acc_coa_trx
AS
SELECT dbo.tbl_acc_coa.coa_sap, dbo.tbl_acc_coa.name_account, dbo.tbl_acc_coa_trx.trx_amount, dbo.tbl_acc_coa_trx.periode
FROM dbo.tbl_acc_coa LEFT OUTER JOIN
dbo.tbl_acc_coa_trx ON dbo.tbl_acc_coa.coa_sap = dbo.tbl_acc_coa_trx.coa_sap
GO
GO
CREATE VIEW dbo.v_acc_coa_trx
AS
SELECT dbo.tbl_acc_coa.coa_sap, dbo.tbl_acc_coa.name_account, dbo.tbl_acc_coa_trx.trx_amount, dbo.tbl_acc_coa_trx.periode
FROM dbo.tbl_acc_coa LEFT OUTER JOIN
dbo.tbl_acc_coa_trx ON dbo.tbl_acc_coa.coa_sap = dbo.tbl_acc_coa_trx.coa_sap
GO
Depends On
2Used By
No items found