V_QUERY_POSTTOGLPROCESSSTANDARD_3
View used for Financial Edge 7 output with project for the post to GL process.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| GLTRANSACTIONID | uniqueidentifier | GL Transaction ID | |
| ACCOUNTSTRING | nvarchar(100) | Account | |
| ACCOUNTNUMBER | nvarchar(100) | Account number | |
| POSTDATE | datetime | yes | PostDate |
| POSTDATE2 | datetime | yes | PostDate |
| TRANTYPE | varchar(1) | TranType | |
| ENCUMBRANCESTATUS | nvarchar(7) | yes | Encumbrance status |
| DEBITCREDIT | varchar(1) | Debit or credit | |
| TYPE | nvarchar(6) | yes | Type |
| AMOUNT | money | Amount | |
| JOURNAL | nvarchar(255) | Journal | |
| REFERENCE | nvarchar(255) | Reference | |
| JOURNALREFERENCE | nvarchar(255) | yes | Journal Reference |
| BATCH | nvarchar(36) | yes | Batch |
| PROJECTID | nvarchar(100) | yes | Project id |
| PROJECTAMOUNT | money | Project amount | |
| GLACCOUNTID | uniqueidentifier | account id |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:36:07 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_POSTTOGLPROCESSSTANDARD_3 AS
select
T1.ID as GLTRANSACTIONID,
ACCOUNT as ACCOUNTSTRING,
T2.ACCOUNTNUMBER as ACCOUNTNUMBER,
POSTDATE,
cast('' as datetime) as POSTDATE2,
'R' as TRANTYPE,
cast('Regular' as nvarchar(7)) as ENCUMBRANCESTATUS,
case TRANSACTIONTYPECODE when 0 then 'D' else 'C' end as DEBITCREDIT,
cast (case TRANSACTIONTYPECODE when 0 then 'Debit' else 'Credit' end as nvarchar(6)) as TYPE,
AMOUNT,
JOURNAL,
REFERENCE,
cast('' as nvarchar(255)) as JOURNALREFERENCE,
cast('' as nvarchar(36)) as BATCH,
--PROJECT,
cast('' as nvarchar(100)) as PROJECTID,
AMOUNT as PROJECTAMOUNT,
T2.ID as GLACCOUNTID
from
dbo.GLTRANSACTION T1
join dbo.GLACCOUNT T2 on T1.GLACCOUNTID = T2.ID