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/22/2019 06:30:51 |
| Last Modified | 10/22/2019 06:30:51 |
Columns
| Key | Name | Description |
|---|---|---|
| id_bs_pl | ||
| GL_ACC | ||
| GL_NAME | ||
| PERIOD | ||
| AMOUNT | ||
| coa_sap | ||
| section1 | ||
| section2 | ||
| target_group1 | ||
| target_group2 | ||
| target_report | ||
| name_account |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_acc_bs_pl
AS
SELECT dbo.tbl_acc_bs_pl.id_bs_pl, dbo.tbl_acc_bs_pl.GL_ACC, dbo.tbl_acc_bs_pl.GL_NAME, dbo.tbl_acc_bs_pl.PERIOD, dbo.tbl_acc_bs_pl.AMOUNT, dbo.tbl_acc_coa.coa_sap, dbo.tbl_acc_coa.section1,
dbo.tbl_acc_coa.section2, dbo.tbl_acc_coa.target_group1, dbo.tbl_acc_coa.target_group2, dbo.tbl_acc_coa.target_report, dbo.tbl_acc_coa.name_account
FROM dbo.tbl_acc_bs_pl LEFT OUTER JOIN
dbo.tbl_acc_coa ON dbo.tbl_acc_bs_pl.GL_ACC = dbo.tbl_acc_coa.coa_sap
GO
GO
CREATE VIEW dbo.v_acc_bs_pl
AS
SELECT dbo.tbl_acc_bs_pl.id_bs_pl, dbo.tbl_acc_bs_pl.GL_ACC, dbo.tbl_acc_bs_pl.GL_NAME, dbo.tbl_acc_bs_pl.PERIOD, dbo.tbl_acc_bs_pl.AMOUNT, dbo.tbl_acc_coa.coa_sap, dbo.tbl_acc_coa.section1,
dbo.tbl_acc_coa.section2, dbo.tbl_acc_coa.target_group1, dbo.tbl_acc_coa.target_group2, dbo.tbl_acc_coa.target_report, dbo.tbl_acc_coa.name_account
FROM dbo.tbl_acc_bs_pl LEFT OUTER JOIN
dbo.tbl_acc_coa ON dbo.tbl_acc_bs_pl.GL_ACC = dbo.tbl_acc_coa.coa_sap
GO
Depends On
2Used By
No items found