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_cf | ||
| GL_ACC | ||
| GL_NAME | ||
| REASON_CODE | ||
| REASON_NAME | ||
| PERIOD | ||
| DEBIT_AMOUNT | ||
| CREDIT_AMOUNT | ||
| coa_sap | ||
| name_account | ||
| section1 | ||
| section2 | ||
| target_group1 | ||
| target_group2 | ||
| target_report |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_acc_cf
AS
SELECT dbo.tbl_acc_cf.id_cf, dbo.tbl_acc_cf.GL_ACC, dbo.tbl_acc_cf.GL_NAME, dbo.tbl_acc_cf.REASON_CODE, dbo.tbl_acc_cf.REASON_NAME, dbo.tbl_acc_cf.PERIOD, dbo.tbl_acc_cf.DEBIT_AMOUNT,
dbo.tbl_acc_cf.CREDIT_AMOUNT, dbo.tbl_acc_coa.coa_sap, dbo.tbl_acc_coa.name_account, 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
FROM dbo.tbl_acc_cf LEFT OUTER JOIN
dbo.tbl_acc_coa ON dbo.tbl_acc_cf.GL_ACC = dbo.tbl_acc_coa.coa_sap
GO
GO
CREATE VIEW dbo.v_acc_cf
AS
SELECT dbo.tbl_acc_cf.id_cf, dbo.tbl_acc_cf.GL_ACC, dbo.tbl_acc_cf.GL_NAME, dbo.tbl_acc_cf.REASON_CODE, dbo.tbl_acc_cf.REASON_NAME, dbo.tbl_acc_cf.PERIOD, dbo.tbl_acc_cf.DEBIT_AMOUNT,
dbo.tbl_acc_cf.CREDIT_AMOUNT, dbo.tbl_acc_coa.coa_sap, dbo.tbl_acc_coa.name_account, 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
FROM dbo.tbl_acc_cf LEFT OUTER JOIN
dbo.tbl_acc_coa ON dbo.tbl_acc_cf.GL_ACC = dbo.tbl_acc_coa.coa_sap
GO
Depends On
2Used By
No items found